APPS.RCV_ROI_HEADER dependencies on RCV_TRANSACTIONS_INTERFACE

Line 692: FROM rcv_transactions_interface rti, po_headers poh

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

Line 1076: rcv_transactions_interface rti

1072: BEGIN
1073: SELECT COUNT(*)
1074: INTO x_in_this_op_unit
1075: FROM po_headers poh,
1076: rcv_transactions_interface rti
1077: WHERE poh.vendor_id = p_header_record.header_record.vendor_id
1078: AND poh.segment1 = rti.document_num
1079: AND rti.header_interface_id = p_header_record.header_record.header_interface_id
1080: AND NVL(rti.source_document_code, 'PO') = 'PO';

Line 1093: UPDATE rcv_transactions_interface

1089: UPDATE rcv_headers_interface
1090: SET processing_status_code = 'PENDING'
1091: WHERE header_interface_id = p_header_record.header_record.header_interface_id;
1092:
1093: UPDATE rcv_transactions_interface
1094: SET processing_status_code = 'PENDING'
1095: WHERE header_interface_id = p_header_record.header_record.header_interface_id
1096: AND processing_status_code = 'RUNNING'
1097: AND processing_mode_code = 'BATCH';

Line 1864: DELETE FROM rcv_transactions_interface

1860: -- delete any asn lines that have been sent
1861:
1862: asn_debug.put_line('Delete any asn lines that have been sent');
1863:
1864: DELETE FROM rcv_transactions_interface
1865: WHERE header_interface_id = p_header_record.header_record.header_interface_id;
1866:
1867: -- Insert lines from rcv_shipment_lines into rcv_transactions_interface
1868:

Line 1867: -- Insert lines from rcv_shipment_lines into rcv_transactions_interface

1863:
1864: DELETE FROM rcv_transactions_interface
1865: WHERE header_interface_id = p_header_record.header_record.header_interface_id;
1866:
1867: -- Insert lines from rcv_shipment_lines into rcv_transactions_interface
1868:
1869: -- Make sure we don't inset cancelled lines and lines that are waiting to
1870: -- be cancelled in rti
1871: -- The transaction processor will then cancel the lines

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

1873: -- Bug 587603 Inserting processing request id for CANCEL otherwise
1874: -- transaction processor will not look at it.
1875:
1876: /*
1877: * Populate the org_id column in rcv_transactions_interface with org_id from
1878: * po_headers_all table
1879: */
1880:
1881: INSERT INTO rcv_transactions_interface

Line 1881: INSERT INTO rcv_transactions_interface

1877: * Populate the org_id column in rcv_transactions_interface with org_id from
1878: * po_headers_all table
1879: */
1880:
1881: INSERT INTO rcv_transactions_interface
1882: (interface_transaction_id,
1883: header_interface_id,
1884: GROUP_ID,
1885: last_update_date,

Line 1916: SELECT rcv_transactions_interface_s.NEXTVAL,

1912: destination_type_code,
1913: processing_request_id,
1914: org_id
1915: )
1916: SELECT rcv_transactions_interface_s.NEXTVAL,
1917: p_header_record.header_record.header_interface_id,
1918: p_header_record.header_record.GROUP_ID,
1919: p_header_record.header_record.last_update_date,
1920: p_header_record.header_record.last_updated_by,

Line 1956: FROM rcv_transactions_interface rti

1952: WHERE rsl.shipment_header_id = p_header_record.header_record.receipt_header_id
1953: AND rsl.shipment_line_status_code <> 'CANCELLED'
1954: AND rsl.po_header_id = poh.po_header_id
1955: AND NOT EXISTS(SELECT 'x'
1956: FROM rcv_transactions_interface rti
1957: WHERE rti.shipment_line_id = rsl.shipment_line_id
1958: AND rti.shipment_header_id = rsl.shipment_header_id
1959: AND rti.transaction_type = 'CANCEL'
1960: AND rti.shipment_header_id = p_header_record.header_record.receipt_header_id);