APPS.INV_DIAG_RCV_IPROC dependencies on PO_LINE_LOCATIONS_ALL

Line 165: po_line_locations_all pll ,

161: FROM po_requisition_headers_all prh,
162: po_requisition_lines_all prl,
163: rcv_shipment_headers rsh,
164: rcv_shipment_lines rsl,
165: po_line_locations_all pll ,
166: po_distributions_all pd,
167: po_req_distributions_all prd
168: WHERE prh.type_lookup_code IN ('PURCHASE','INTERNAL')
169: and prh.requisition_header_id = prl.requisition_header_id

Line 277: PO_LINE_LOCATIONS_ALL'||'

273: '||'
274: '||'
275: PO_HEADERS_ALL'||'
276: PO_LINES_ALL'||'
277: PO_LINE_LOCATIONS_ALL'||'
278: '||'
279: '||'
280: PO_DISTRIBUTIONS_ALL'||'
281: GL_CODE_COMBINATIONS'||'

Line 386: JTF_DIAGNOSTIC_COREAPI.insert_html('');

382: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
383: JTF_DIAGNOSTIC_COREAPI.BRPrint;
384:
385: sql_text := po_sql(6);
386: JTF_DIAGNOSTIC_COREAPI.insert_html('');
387: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINE_LOCATIONS_ALL  [Top]');
388: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
389: JTF_DIAGNOSTIC_COREAPI.BRPrint;
390:

Line 387: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINE_LOCATIONS_ALL  [Top]');

383: JTF_DIAGNOSTIC_COREAPI.BRPrint;
384:
385: sql_text := po_sql(6);
386: JTF_DIAGNOSTIC_COREAPI.insert_html('');
387: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINE_LOCATIONS_ALL  [Top]');
388: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
389: JTF_DIAGNOSTIC_COREAPI.BRPrint;
390:
391: sql_text := po_sql(7);