APPS.RCV_ROI_HEADER dependencies on PO_HEADERS

Line 690: FROM rcv_transactions_interface rti, po_headers poh

686:
687: BEGIN
688: SELECT Count(DISTINCT poh.vendor_site_id),poh.vendor_site_id
689: INTO count1,x_ven_site_id
690: FROM rcv_transactions_interface rti, po_headers poh
691: WHERE ((rti.document_num IS NOT NULL AND rti.document_num = poh.segment1) OR
692: (rti.po_header_id is not null AND rti.po_header_id = poh.po_header_id))
693: AND rti.header_interface_id = p_header_record.header_record.header_interface_id
694: GROUP BY poh.vendor_site_id;

Line 1088: FROM po_headers poh,

1084: IF NVL(p_header_record.header_record.asn_type, 'STD') IN('ASN', 'ASBN','WC', 'LCM') THEN /* lcm changes */ --{
1085: BEGIN
1086: SELECT COUNT(*)
1087: INTO x_in_this_op_unit
1088: FROM po_headers poh,
1089: rcv_transactions_interface rti
1090: WHERE poh.vendor_id = p_header_record.header_record.vendor_id
1091: AND poh.segment1 = rti.document_num
1092: AND rti.header_interface_id = p_header_record.header_record.header_interface_id

Line 1904: * po_headers_all table

1900: -- transaction processor will not look at it.
1901:
1902: /*
1903: * Populate the org_id column in rcv_transactions_interface with org_id from
1904: * po_headers_all table
1905: */
1906:
1907: INSERT INTO rcv_transactions_interface
1908: (interface_transaction_id,

Line 1977: po_headers_all poh

1973: rsl.destination_type_code,
1974: p_header_record.header_record.processing_request_id,
1975: poh.org_id
1976: FROM rcv_shipment_lines rsl,
1977: po_headers_all poh
1978: WHERE rsl.shipment_header_id = p_header_record.header_record.receipt_header_id
1979: AND rsl.shipment_line_status_code <> 'CANCELLED'
1980: AND rsl.po_header_id = poh.po_header_id
1981: AND NOT EXISTS(SELECT 'x'