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)
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:
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);