DBA Data[Home] [Help]

APPS.INV_DIAG_RCV_IPROC dependencies on RCV_SHIPMENT_LINES

Line 164: rcv_shipment_lines rsl,

160: INTO l_count
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')

Line 292: RCV_SHIPMENT_LINES'||'

288: '||'
289: '||'
290: AP_INVOICE_LINES_INTERFACE'||'
291: RCV_SHIPMENT_HEADERS'||'
292: RCV_SHIPMENT_LINES'||'
293: '||'
294: '||'
295: RCV_TRANSACTIONS'||'
296: MTL_SUPPLY'||'

Line 444: JTF_DIAGNOSTIC_COREAPI.insert_html('');

440: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
441: JTF_DIAGNOSTIC_COREAPI.BRPrint;
442:
443: sql_text:= po_sql(15);
444: JTF_DIAGNOSTIC_COREAPI.insert_html('');
445: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');
446: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
447: JTF_DIAGNOSTIC_COREAPI.BRPrint;
448:

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

441: JTF_DIAGNOSTIC_COREAPI.BRPrint;
442:
443: sql_text:= po_sql(15);
444: JTF_DIAGNOSTIC_COREAPI.insert_html('');
445: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');
446: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
447: JTF_DIAGNOSTIC_COREAPI.BRPrint;
448:
449: sql_text:= po_sql(16);