APPS.RCV_VALIDATE_PO dependencies on PO_HEADERS_ALL

Line 202: l_po_header_id po_headers_all.po_header_id%TYPE;

198: GROUP BY rsh.shipment_header_id,
199: rsh.receipt_num;
200:
201:
202: l_po_header_id po_headers_all.po_header_id%TYPE;
203: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;
204: l_receipt_date rcv_transactions.transaction_date%TYPE;
205: l_receipt_number rcv_shipment_headers.receipt_num%TYPE;
206: l_multi_mod_val_result_id NUMBER;

Line 309: FROM po_headers_all poh

305: WHERE rti.po_header_id = l_po_header_id
306: OR ( (rti.receipt_source_code = 'VENDOR' OR rti.source_document_code = 'PO')
307: AND EXISTS
308: ( SELECT 1
309: FROM po_headers_all poh
310: WHERE type_lookup_code IN('STANDARD', 'BLANKET', 'SCHEDULED')
311: AND poh.segment1 = rti.document_num
312: AND poh.org_id = Nvl(rti.org_id, poh.org_id)
313: AND poh.po_header_id = l_po_header_id )