APPS.RCV_GET_DELIVERED_QTY dependencies on PO_HEADERS_ALL

Line 21: po_headers_all poh,

17: rct.transaction_id trans_id,
18: rct.parent_transaction_id parent_trans_id,
19: rct.primary_quantity trans_qty
20: FROM rcv_shipment_lines rsl,
21: po_headers_all poh,
22: rcv_transactions rct
23: WHERE rct.source_document_code = 'PO'
24: AND rsl.item_id = x_item_id
25: AND rsl.po_header_id = poh.po_header_id

Line 47: (SELECT 1 FROM po_headers_all poh

43: AND rct.shipment_line_id = rsl.shipment_line_id
44: AND rct.transaction_type = 'DELIVER'
45: AND rct.transaction_date between x_start_date and x_end_date
46: AND exists
47: (SELECT 1 FROM po_headers_all poh
48: WHERE rsl.po_header_id = poh.po_header_id
49: AND NVL(poh.vendor_site_id,-99) = NVL(x_vendor_site_id,-99)
50: AND poh.vendor_id = x_vendor_id
51: AND rownum = 1);