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
170: and prl.requisition_line_id = prd.requisition_line_id
276:
388: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
389: JTF_DIAGNOSTIC_COREAPI.BRPrint;
390:
391: sql_text := po_sql(7);
392: JTF_DIAGNOSTIC_COREAPI.insert_html('');
393: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_DISTRIBUTIONS_ALL [Top]');
394: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
395: JTF_DIAGNOSTIC_COREAPI.BRPrint;
396:
389: JTF_DIAGNOSTIC_COREAPI.BRPrint;
390:
391: sql_text := po_sql(7);
392: JTF_DIAGNOSTIC_COREAPI.insert_html('');
393: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_DISTRIBUTIONS_ALL [Top]');
394: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
395: JTF_DIAGNOSTIC_COREAPI.BRPrint;
396:
397: sql_text := po_sql(8);