APPS.INV_DIAG_RCV_IPROC dependencies on PO_REQUISITION_LINES_ALL

Line 162: po_requisition_lines_all prl,

158:
159: SELECT Count(1)
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,

Line 196: po_requisition_lines_all prl

192:
193: SELECT Count(1)
194: INTO l_count
195: FROM po_requisition_headers_all prh,
196: po_requisition_lines_all prl
197: WHERE prh.type_lookup_code IN ('PURCHASE','INTERNAL')
198: and prh.requisition_header_id = prl.requisition_header_id
199: and prh.segment1=l_req_number
200: AND prh.org_id=l_operating_id;

Line 271: PO_REQUISITION_LINES_ALL'||'

267: INDEX OF QUERIES'||'
268: '||'
269: '||'
270: PO_REQUISITION_HEADERS_ALL'||'
271: PO_REQUISITION_LINES_ALL'||'
272: PO_REQ_DISTRIBUTIONS_ALL'||'
273: '||'
274: '||'
275: PO_HEADERS_ALL'||'

Line 360: JTF_DIAGNOSTIC_COREAPI.insert_html('');

356: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
357: JTF_DIAGNOSTIC_COREAPI.BRPrint;
358:
359: sql_text := po_sql(2);
360: JTF_DIAGNOSTIC_COREAPI.insert_html('');
361: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQUISITION_LINES_ALL  [Top]');
362: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
363: JTF_DIAGNOSTIC_COREAPI.BRPrint;
364:

Line 361: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQUISITION_LINES_ALL  [Top]');

357: JTF_DIAGNOSTIC_COREAPI.BRPrint;
358:
359: sql_text := po_sql(2);
360: JTF_DIAGNOSTIC_COREAPI.insert_html('');
361: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQUISITION_LINES_ALL  [Top]');
362: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
363: JTF_DIAGNOSTIC_COREAPI.BRPrint;
364:
365: sql_text := po_sql(3);