DBA Data[Home] [Help]

APPS.PO_ITEMS_SV1 dependencies on PO_HEADERS

Line 80: FROM po_headers a, po_lines b

76: X_progress := '020';
77: BEGIN
78: SELECT distinct b.item_id
79: INTO X_inventory_item_id_v
80: FROM po_headers a, po_lines b
81: WHERE a.po_header_id = b.po_header_id
82: AND b.vendor_product_num = X_vendor_product_num
83: AND a.vendor_id = X_vendor_id
84: AND b.item_id is not NULL;