eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCV_ROI_PREPROCESSOR dependencies on RCV_HEADERS_INTERFACE

Line 22: -- will have headers in rcv_headers_interface

18: cascaded_table_index number;
19:
20: -- Our main loop cursors
21: -- This is for picking up the RECEIVE and SHIP txns, which
22: -- will have headers in rcv_headers_interface
23: cursor headers_cur (x_request_id number, x_group_id NUMBER, x_header_interface_id NUMBER) is
24: select * from rcv_headers_interface
25: where NVL(asn_type,'STD') in ('ASN','ASBN','STD','WC','LCM') /* lcm changes */
26: and processing_status_code in ('RUNNING', 'SUCCESS')

Line 24: select * from rcv_headers_interface

20: -- Our main loop cursors
21: -- This is for picking up the RECEIVE and SHIP txns, which
22: -- will have headers in rcv_headers_interface
23: cursor headers_cur (x_request_id number, x_group_id NUMBER, x_header_interface_id NUMBER) is
24: select * from rcv_headers_interface
25: where NVL(asn_type,'STD') in ('ASN','ASBN','STD','WC','LCM') /* lcm changes */
26: and processing_status_code in ('RUNNING', 'SUCCESS')
27: and ( nvl(validation_flag,'N') = 'Y' OR
28: processing_status_code = 'SUCCESS') -- include sucess rows for multi-line asn

Line 99: rcv_headers_interface and rcv_transactions_interface.

95: PROCEDURE NAME: Preprocessor()
96:
97: DESCRIPTION: Derives, defaults, and validates entries in the
98: Receiving Open Interface tables,
99: rcv_headers_interface and rcv_transactions_interface.
100: The preprocessor also handles ASN/ASBN imports,
101: creating the appropriate lines in rcv_shipment_headers
102: and rcv_shipment_lines.
103:

Line 131: x_header_id IN rcv_headers_interface.header_interface_id%TYPE,

127:
128: PROCEDURE process_line(
129: x_cascaded_table IN OUT NOCOPY RCV_ROI_PREPROCESSOR.cascaded_trans_tab_type,
130: n IN OUT NOCOPY BINARY_INTEGER,
131: x_header_id IN rcv_headers_interface.header_interface_id%TYPE,
132: x_asn_type IN rcv_headers_interface.asn_type%TYPE,
133: v_header_record IN OUT NOCOPY RCV_ROI_PREPROCESSOR.header_rec_type
134: );
135:

Line 132: x_asn_type IN rcv_headers_interface.asn_type%TYPE,

128: PROCEDURE process_line(
129: x_cascaded_table IN OUT NOCOPY RCV_ROI_PREPROCESSOR.cascaded_trans_tab_type,
130: n IN OUT NOCOPY BINARY_INTEGER,
131: x_header_id IN rcv_headers_interface.header_interface_id%TYPE,
132: x_asn_type IN rcv_headers_interface.asn_type%TYPE,
133: v_header_record IN OUT NOCOPY RCV_ROI_PREPROCESSOR.header_rec_type
134: );
135:
136: PROCEDURE explode_lpn_failed(