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.INV_DIAG_RCV_IOT dependencies on RCV_SHIPMENT_HEADERS

Line 96: l_org_id rcv_shipment_headers.organization_id%TYPE;

92:
93: iot1_sql INV_DIAG_RCV_PO_COMMON.sqls_list;
94:
95: dummy_num NUMBER;
96: l_org_id rcv_shipment_headers.organization_id%TYPE;
97: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
98: l_shipment_num rcv_shipment_headers.shipment_num%TYPE;
99: l_shipment_line_num rcv_shipment_lines.line_num%TYPE;
100: l_makecall NUMBER := 0;

Line 97: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;

93: iot1_sql INV_DIAG_RCV_PO_COMMON.sqls_list;
94:
95: dummy_num NUMBER;
96: l_org_id rcv_shipment_headers.organization_id%TYPE;
97: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
98: l_shipment_num rcv_shipment_headers.shipment_num%TYPE;
99: l_shipment_line_num rcv_shipment_lines.line_num%TYPE;
100: l_makecall NUMBER := 0;
101: l_count NUMBER := 1;

Line 98: l_shipment_num rcv_shipment_headers.shipment_num%TYPE;

94:
95: dummy_num NUMBER;
96: l_org_id rcv_shipment_headers.organization_id%TYPE;
97: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
98: l_shipment_num rcv_shipment_headers.shipment_num%TYPE;
99: l_shipment_line_num rcv_shipment_lines.line_num%TYPE;
100: l_makecall NUMBER := 0;
101: l_count NUMBER := 1;
102:

Line 195: from rcv_shipment_headers rsh,

191: NULL) THEN
192:
193: select Count(*)
194: into l_count
195: from rcv_shipment_headers rsh,
196: rcv_shipment_lines rsl
197: where rsh.receipt_num = l_receipt_num
198: AND rsh.shipment_num = l_shipment_num
199: AND rsh.shipment_header_id = rsl.shipment_header_id

Line 211: from rcv_shipment_headers rsh,

207: IF (l_shipment_num is NOT NULL and l_shipment_line_num is NOT NULL and l_org_id is NOT NULL AND l_count <> 0) THEN
208:
209: select Count(*)
210: into l_count
211: from rcv_shipment_headers rsh,
212: rcv_shipment_lines rsl
213: where rsh.shipment_num = l_shipment_num
214: AND rsh.shipment_header_id = rsl.shipment_header_id
215: AND rsl.line_num = l_shipment_line_num

Line 225: from rcv_shipment_headers rsh,

221: IF (l_receipt_num is NOT NULL and l_shipment_line_num is NOT NULL and l_org_id is NOT NULL AND l_count <> 0) THEN
222:
223: select Count(*)
224: into l_count
225: from rcv_shipment_headers rsh,
226: rcv_shipment_lines rsl
227: where rsh.receipt_num = l_receipt_num
228: AND rsh.shipment_header_id = rsl.shipment_header_id
229: AND rsl.line_num = l_shipment_line_num

Line 239: from rcv_shipment_headers rsh

235: IF (l_shipment_num is NOT NULL and l_receipt_num is NOT NULL and l_org_id is NOT NULL AND l_count <> 0) THEN
236:
237: select Count(*)
238: into l_count
239: from rcv_shipment_headers rsh
240: where rsh.receipt_num = l_receipt_num
241: AND rsh.shipment_num = l_shipment_num
242: and rsh.ship_to_org_id = l_org_id
243: and rsh.receipt_source_code = 'INVENTORY';

Line 251: from rcv_shipment_headers rsh

247: IF (l_shipment_num is NOT NULL and l_org_id is NOT NULL AND l_count <> 0) THEN
248:
249: select Count(*)
250: into l_count
251: from rcv_shipment_headers rsh
252: where rsh.shipment_num = l_shipment_num
253: and rsh.ship_to_org_id = l_org_id
254: and rsh.receipt_source_code = 'INVENTORY';
255:

Line 262: from rcv_shipment_headers rsh

258: IF (l_receipt_num is NOT NULL and l_org_id is NOT NULL AND l_count <> 0) THEN
259:
260: select Count(*)
261: into l_count
262: from rcv_shipment_headers rsh
263: where rsh.receipt_num = l_receipt_num
264: and rsh.ship_to_org_id = l_org_id
265: and rsh.receipt_source_code = 'INVENTORY';
266:

Line 288: from rcv_shipment_headers rsh

284: begin
285:
286: select shipment_num
287: into l_shipment_num
288: from rcv_shipment_headers rsh
289: where receipt_num = l_receipt_num
290: and ship_to_org_id = l_org_id
291: and rsh.receipt_source_code = 'INVENTORY';
292:

Line 305: from rcv_shipment_headers rsh

301:
302: begin
303: select receipt_num
304: into l_receipt_num
305: from rcv_shipment_headers rsh
306: where shipment_num = l_shipment_num
307: and ship_to_org_id = l_org_id
308: and rsh.receipt_source_code = 'INVENTORY';
309:

Line 339: RCV_SHIPMENT_HEADERS'||'

335: RCV_TRANSACTIONS_INTERFACE'||'
336: PO_INTERFACE_ERRORS'||'
337: '||'
338: '||'
339: RCV_SHIPMENT_HEADERS'||'
340: RCV_SHIPMENT_LINES'||'
341: RCV_TRANSACTIONS'||'
342: '||'
343: '||'

Line 411: JTF_DIAGNOSTIC_COREAPI.insert_html('');

407: JTF_DIAGNOSTIC_COREAPI.BRPrint;
408:
409:
410: sql_text := iot1_sql(4);
411: JTF_DIAGNOSTIC_COREAPI.insert_html('');
412: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS [Top]');
413: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
414: JTF_DIAGNOSTIC_COREAPI.BRPrint;
415:

Line 412: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS [Top]');

408:
409:
410: sql_text := iot1_sql(4);
411: JTF_DIAGNOSTIC_COREAPI.insert_html('');
412: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS [Top]');
413: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
414: JTF_DIAGNOSTIC_COREAPI.BRPrint;
415:
416: