APPS.INV_DIAG_RCV_IPROC dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 167: po_req_distributions_all prd

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
170: and prl.requisition_line_id = prd.requisition_line_id
171: AND prl.line_num=Nvl(l_line_num,prl.line_num)

Line 272: PO_REQ_DISTRIBUTIONS_ALL'||'

268: '||'
269: '||'
270: PO_REQUISITION_HEADERS_ALL'||'
271: PO_REQUISITION_LINES_ALL'||'
272: PO_REQ_DISTRIBUTIONS_ALL'||'
273: '||'
274: '||'
275: PO_HEADERS_ALL'||'
276: PO_LINES_ALL'||'

Line 366: JTF_DIAGNOSTIC_COREAPI.insert_html('');

362: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
363: JTF_DIAGNOSTIC_COREAPI.BRPrint;
364:
365: sql_text := po_sql(3);
366: JTF_DIAGNOSTIC_COREAPI.insert_html('');
367: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQ_DISTRIBUTIONS_ALL  [Top]');
368: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
369: JTF_DIAGNOSTIC_COREAPI.BRPrint;
370:

Line 367: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQ_DISTRIBUTIONS_ALL  [Top]');

363: JTF_DIAGNOSTIC_COREAPI.BRPrint;
364:
365: sql_text := po_sql(3);
366: JTF_DIAGNOSTIC_COREAPI.insert_html('');
367: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQ_DISTRIBUTIONS_ALL  [Top]');
368: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
369: JTF_DIAGNOSTIC_COREAPI.BRPrint;
370:
371: sql_text := po_sql(4);