I need the logic for this requirement

Transact-SQL
1

Suppose in Oracle R12 we have global blanket purchase orders so I need a query which will fetch items which are not associated with any kind of GBPA. Item which don't have any GBPA such items I need in Oracle r12.

Pls can someone fastly provide me the query or logic pls

2

hi

hope this helps

SELECT mii.item_code, mii.segment1 AS item_name  
FROM mtl_items mii  
WHERE NOT EXISTS (  
  SELECT 1  
  FROM po_gbp_header pgbh  
  INNER JOIN po_gbp_lines pgbpl ON pgbh.gbp_header_id = pgbpl.gbp_header_id  
  WHERE pgbpl.item_id = mii.item_code  
)  
AND mii.ORG_ID = :org_id;

by the way this is a microsoft SQL Server Forum
FYI
:+1:

3

Hii thanks for ua help but we have to check from approved supplier list ASL documents and ASL tables.