APPS.INV_DIAG_RCV_IPROC dependencies on PO_REQUISITION_HEADERS_ALL

Line 161: FROM po_requisition_headers_all prh,

157: AND l_line_num IS NOT NULL THEN
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 ,

Line 195: FROM po_requisition_headers_all prh,

191: IF l_operating_id IS NOT NULL AND l_req_number IS NOT NULL then
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

Line 270: PO_REQUISITION_HEADERS_ALL'||'

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

Line 354: JTF_DIAGNOSTIC_COREAPI.insert_html('');

350: -- Execute the Sqls
351: -------------------
352: JTF_DIAGNOSTIC_COREAPI.insert_html('

Requisition Details

Line 355: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_REQUISITION_HEADERS_ALL  [Top]');

351: -------------------
352: JTF_DIAGNOSTIC_COREAPI.insert_html('

Requisition Details