APPS.INV_DIAG_RCV_IO dependencies on RCV_SHIPMENT_LINES

Line 244: rcv_shipment_lines rsl

240: INTO l_count
241: FROM po_requisition_headers_all prh,
242: po_requisition_lines_all prl,
243: rcv_shipment_headers rsh,
244: rcv_shipment_lines rsl
245: WHERE prh.segment1 = l_req_num
246: AND prh.org_id = l_ou_id
247: AND prh.requisition_header_id = prl.requisition_header_id
248: AND prl.line_num = l_line_num

Line 273: rcv_shipment_lines rsl

269: INTO l_count
270: FROM po_requisition_headers_all prh,
271: po_requisition_lines_all prl,
272: rcv_shipment_headers rsh,
273: rcv_shipment_lines rsl
274: WHERE prh.segment1 = l_req_num
275: AND prh.org_id = l_ou_id
276: AND prh.requisition_header_id = prl.requisition_header_id
277: AND rsh.shipment_num = l_shipment_num

Line 318: rcv_shipment_lines rsl

314:
315: SELECT Count(*)
316: INTO l_count
317: FROM rcv_shipment_headers rsh,
318: rcv_shipment_lines rsl
319: WHERE rsh.shipment_num = l_shipment_num
320: AND rsh.receipt_num = l_receipt_num
321: AND rsh.ship_to_org_id = l_org_id
322: AND rsh.receipt_source_code = 'INTERNAL ORDER';

Line 358: rcv_shipment_lines rsl

354:
355: SELECT Count(*)
356: INTO l_count
357: FROM rcv_shipment_headers rsh,
358: rcv_shipment_lines rsl
359: WHERE rsh.receipt_num = l_receipt_num
360: AND rsh.ship_to_org_id = l_org_id
361: AND rsh.receipt_source_code = 'INTERNAL ORDER';
362: IF l_count = 0 THEN

Line 377: rcv_shipment_lines rsl

373:
374: SELECT Count(*)
375: INTO l_count
376: FROM rcv_shipment_headers rsh,
377: rcv_shipment_lines rsl
378: WHERE rsh.shipment_num = l_shipment_num
379: AND rsh.ship_to_org_id = l_org_id
380: AND rsh.receipt_source_code = 'INTERNAL ORDER';
381: IF l_count = 0 THEN

Line 472: RCV_SHIPMENT_LINES'||'

468: WSH_DELIVERY_DETAILS'||'
469: RCV_SHIPMENT_HEADERS'||'
470: '||'
471: '||'
472: RCV_SHIPMENT_LINES'||'
473: RCV_TRANSACTIONS'||'
474: MTL_SUPPLY'||'
475: '||'
476: '||'

Line 571: JTF_DIAGNOSTIC_COREAPI.insert_html('');

567: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
568: JTF_DIAGNOSTIC_COREAPI.BRPrint;
569:
570: sql_text := io1_sql(10);
571: JTF_DIAGNOSTIC_COREAPI.insert_html('');
572: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');
573: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
574: JTF_DIAGNOSTIC_COREAPI.BRPrint;
575:

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

568: JTF_DIAGNOSTIC_COREAPI.BRPrint;
569:
570: sql_text := io1_sql(10);
571: JTF_DIAGNOSTIC_COREAPI.insert_html('');
572: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');
573: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
574: JTF_DIAGNOSTIC_COREAPI.BRPrint;
575:
576: sql_text := io1_sql(11);