APPS.INV_DIAG_RCV_PO dependencies on PO_LINE_LOCATIONS_ALL

Line 105: l_line_loc_num po_line_locations_all.shipment_num%TYPE;

101: l_operating_id po_headers_all.org_id%TYPE;
102: l_po_number po_headers_all.segment1%TYPE;
103: l_line_num po_lines_all.line_num%TYPE;
104: l_org_id rcv_shipment_headers.organization_id%TYPE;
105: l_line_loc_num po_line_locations_all.shipment_num%TYPE;
106: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
107:
108: BEGIN
109: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

Line 165: po_line_locations_all pll,

161: SELECT Count(1)
162: INTO l_count
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

Line 291: PO_LINE_LOCATIONS_ALL'||'

287: '||'
288: '||'
289: PO_HEADERS_ALL'||'
290: PO_LINES_ALL'||'
291: PO_LINE_LOCATIONS_ALL'||'
292: '||'
293: '||'
294: GL_CODE_COMBINATIONS'||'
295: RCV_RECEIVING_SUB_LEDGER'||'

Line 377: JTF_DIAGNOSTIC_COREAPI.insert_html('');

373: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
374: JTF_DIAGNOSTIC_COREAPI.BRPrint;
375:
376: sql_text := po_sql(3);
377: JTF_DIAGNOSTIC_COREAPI.insert_html('');
378: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINE_LOCATIONS_ALL  [Top]');
379: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
380: JTF_DIAGNOSTIC_COREAPI.BRPrint;
381:

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

374: JTF_DIAGNOSTIC_COREAPI.BRPrint;
375:
376: sql_text := po_sql(3);
377: JTF_DIAGNOSTIC_COREAPI.insert_html('');
378: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINE_LOCATIONS_ALL  [Top]');
379: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
380: JTF_DIAGNOSTIC_COREAPI.BRPrint;
381:
382: sql_text := po_sql(4);