APPS.INV_DIAG_RCV_PO dependencies on PO_LINES_ALL

Line 103: l_line_num po_lines_all.line_num%TYPE;

99:
100: dummy_num NUMBER;
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:

Line 164: po_lines_all pl,

160: AND (l_line_num IS NOT NULL OR l_line_loc_num IS NOT NULL) THEN
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

Line 290: PO_LINES_ALL'||'

286: INDEX OF QUERIES'||'
287: '||'
288: '||'
289: PO_HEADERS_ALL'||'
290: PO_LINES_ALL'||'
291: PO_LINE_LOCATIONS_ALL'||'
292: '||'
293: '||'
294: GL_CODE_COMBINATIONS'||'

Line 371: JTF_DIAGNOSTIC_COREAPI.insert_html('');

367: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
368: JTF_DIAGNOSTIC_COREAPI.BRPrint;
369:
370: sql_text := po_sql(2);
371: JTF_DIAGNOSTIC_COREAPI.insert_html('');
372: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINES_ALL  [Top]');
373: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
374: JTF_DIAGNOSTIC_COREAPI.BRPrint;
375:

Line 372: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINES_ALL  [Top]');

368: JTF_DIAGNOSTIC_COREAPI.BRPrint;
369:
370: sql_text := po_sql(2);
371: JTF_DIAGNOSTIC_COREAPI.insert_html('');
372: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_LINES_ALL  [Top]');
373: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
374: JTF_DIAGNOSTIC_COREAPI.BRPrint;
375:
376: sql_text := po_sql(3);