APPS.RCV_ROI_HEADER dependencies on RCV_TRANSACTIONS_INTERFACE

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 1089: rcv_transactions_interface rti

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
1093: AND NVL(rti.source_document_code, 'PO') = 'PO';

Line 1106: UPDATE rcv_transactions_interface

1102: UPDATE rcv_headers_interface
1103: SET processing_status_code = 'PENDING'
1104: WHERE header_interface_id = p_header_record.header_record.header_interface_id;
1105:
1106: UPDATE rcv_transactions_interface
1107: SET processing_status_code = 'PENDING'
1108: WHERE header_interface_id = p_header_record.header_record.header_interface_id
1109: AND processing_status_code = 'RUNNING'
1110: AND processing_mode_code = 'BATCH';

Line 1890: DELETE FROM rcv_transactions_interface

1886: -- delete any asn lines that have been sent
1887:
1888: asn_debug.put_line('Delete any asn lines that have been sent');
1889:
1890: DELETE FROM rcv_transactions_interface
1891: WHERE header_interface_id = p_header_record.header_record.header_interface_id;
1892:
1893: -- Insert lines from rcv_shipment_lines into rcv_transactions_interface
1894:

Line 1893: -- Insert lines from rcv_shipment_lines into rcv_transactions_interface

1889:
1890: DELETE FROM rcv_transactions_interface
1891: WHERE header_interface_id = p_header_record.header_record.header_interface_id;
1892:
1893: -- Insert lines from rcv_shipment_lines into rcv_transactions_interface
1894:
1895: -- Make sure we don't inset cancelled lines and lines that are waiting to
1896: -- be cancelled in rti
1897: -- The transaction processor will then cancel the lines

Line 1903: * Populate the org_id column in rcv_transactions_interface with org_id from

1899: -- Bug 587603 Inserting processing request id for CANCEL otherwise
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

Line 1907: INSERT INTO rcv_transactions_interface

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,
1909: header_interface_id,
1910: GROUP_ID,
1911: last_update_date,

Line 1942: SELECT rcv_transactions_interface_s.NEXTVAL,

1938: destination_type_code,
1939: processing_request_id,
1940: org_id
1941: )
1942: SELECT rcv_transactions_interface_s.NEXTVAL,
1943: p_header_record.header_record.header_interface_id,
1944: p_header_record.header_record.GROUP_ID,
1945: p_header_record.header_record.last_update_date,
1946: p_header_record.header_record.last_updated_by,

Line 1982: FROM rcv_transactions_interface rti

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'
1982: FROM rcv_transactions_interface rti
1983: WHERE rti.shipment_line_id = rsl.shipment_line_id
1984: AND rti.shipment_header_id = rsl.shipment_header_id
1985: AND rti.transaction_type = 'CANCEL'
1986: AND rti.shipment_header_id = p_header_record.header_record.receipt_header_id);