APPS.INV_DIAG_RCV_IOT dependencies on RCV_SHIPMENT_LINES

Line 99: l_shipment_line_num rcv_shipment_lines.line_num%TYPE;

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:
103: BEGIN

Line 196: rcv_shipment_lines rsl

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
200: AND rsl.line_num = l_shipment_line_num

Line 212: rcv_shipment_lines rsl

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
216: and rsh.ship_to_org_id = l_org_id

Line 226: rcv_shipment_lines rsl

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
230: and rsh.ship_to_org_id = l_org_id

Line 340: RCV_SHIPMENT_LINES'||'

336: PO_INTERFACE_ERRORS'||'
337: '||'
338: '||'
339: RCV_SHIPMENT_HEADERS'||'
340: RCV_SHIPMENT_LINES'||'
341: RCV_TRANSACTIONS'||'
342: '||'
343: '||'
344: MTL_SUPPLY'||'

Line 418: JTF_DIAGNOSTIC_COREAPI.insert_html('');

414: JTF_DIAGNOSTIC_COREAPI.BRPrint;
415:
416:
417: sql_text := iot1_sql(5);
418: JTF_DIAGNOSTIC_COREAPI.insert_html('');
419: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');
420: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
421: JTF_DIAGNOSTIC_COREAPI.BRPrint;
422:

Line 419: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');

415:
416:
417: sql_text := iot1_sql(5);
418: JTF_DIAGNOSTIC_COREAPI.insert_html('');
419: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');
420: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
421: JTF_DIAGNOSTIC_COREAPI.BRPrint;
422:
423: