APPS.INV_DIAG_RCV_PO dependencies on RCV_SHIPMENT_LINES

Line 167: rcv_shipment_lines rsl

163: FROM po_headers_all ph,
164: po_lines_all pl,
165: po_line_locations_all pll,
166: rcv_shipment_headers rsh,
167: rcv_shipment_lines rsl
168: WHERE rsh.shipment_header_id=rsl.shipment_header_id
169: AND rsl.po_header_id=ph.po_header_id
170: AND rsl.po_line_id=pl.po_line_id
171: AND rsl.po_line_location_id=pll.line_location_id

Line 196: rcv_shipment_lines rsl

192: SELECT Count(1)
193: INTO l_count
194: FROM po_headers_all ph,
195: rcv_shipment_headers rsh,
196: rcv_shipment_lines rsl
197: WHERE rsh.shipment_header_id=rsl.shipment_header_id
198: AND rsl.po_header_id=ph.po_header_id
199: AND ph.segment1=l_po_number
200: AND ph.org_id=l_operating_id

Line 305: RCV_SHIPMENT_LINES'||'

301: AP_INVOICES_INTERFACE'||'
302: '||'
303: '||'
304: RCV_SHIPMENT_HEADERS'||'
305: RCV_SHIPMENT_LINES'||'
306: RCV_TRANSACTIONS'||'
307: '||'
308: '||'
309: MTL_SUPPLY'||'

Line 434: JTF_DIAGNOSTIC_COREAPI.insert_html('');

430: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
431: JTF_DIAGNOSTIC_COREAPI.BRPrint;
432:
433: sql_text:= po_sql(12);
434: JTF_DIAGNOSTIC_COREAPI.insert_html('');
435: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');
436: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
437: JTF_DIAGNOSTIC_COREAPI.BRPrint;
438:

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

431: JTF_DIAGNOSTIC_COREAPI.BRPrint;
432:
433: sql_text:= po_sql(12);
434: JTF_DIAGNOSTIC_COREAPI.insert_html('');
435: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');
436: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
437: JTF_DIAGNOSTIC_COREAPI.BRPrint;
438:
439: sql_text:= po_sql(13);