APPS.INV_DIAG_RCV_IO dependencies on PO_REQUISITION_HEADERS_ALL

Line 99: l_req_num po_requisition_headers_all.segment1%TYPE;

95:
96: io1_sql INV_DIAG_RCV_PO_COMMON.sqls_list;
97:
98: dummy_num NUMBER;
99: l_req_num po_requisition_headers_all.segment1%TYPE;
100: l_ou_id po_requisition_headers_all.org_id%TYPE;
101: l_line_num po_requisition_lines_all.line_num%TYPE;
102: l_org_id rcv_shipment_headers.organization_id%TYPE;
103: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;

Line 100: l_ou_id po_requisition_headers_all.org_id%TYPE;

96: io1_sql INV_DIAG_RCV_PO_COMMON.sqls_list;
97:
98: dummy_num NUMBER;
99: l_req_num po_requisition_headers_all.segment1%TYPE;
100: l_ou_id po_requisition_headers_all.org_id%TYPE;
101: l_line_num po_requisition_lines_all.line_num%TYPE;
102: l_org_id rcv_shipment_headers.organization_id%TYPE;
103: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
104: l_shipment_num rcv_shipment_headers.shipment_num%TYPE;

Line 241: FROM po_requisition_headers_all prh,

237: l_shipment_num is NOT NULL AND l_org_id is NOT NULL) THEN
238:
239: SELECT Count(*)
240: INTO l_count
241: FROM po_requisition_headers_all prh,
242: po_requisition_lines_all prl,
243: rcv_shipment_headers rsh,
244: rcv_shipment_lines rsl
245: WHERE prh.segment1 = l_req_num

Line 270: FROM po_requisition_headers_all prh,

266: l_org_id is NOT NULL ) THEN
267:
268: SELECT Count(*)
269: INTO l_count
270: FROM po_requisition_headers_all prh,
271: po_requisition_lines_all prl,
272: rcv_shipment_headers rsh,
273: rcv_shipment_lines rsl
274: WHERE prh.segment1 = l_req_num

Line 296: FROM po_requisition_headers_all prh,

292: IF (l_req_num is NOT NULL AND l_ou_id is NOT NULL AND l_line_num is NOT NULL )THEN
293:
294: SELECT Count(*)
295: INTO l_count
296: FROM po_requisition_headers_all prh,
297: po_requisition_lines_all prl
298: WHERE prh.segment1 = l_req_num
299: AND prh.org_id = l_ou_id
300: AND prh.requisition_header_id = prl.requisition_header_id

Line 337: FROM po_requisition_headers_all prh,

333: IF (l_req_num is NOT NULL AND l_ou_id is NOT NULL )THEN
334:
335: SELECT Count(*)
336: INTO l_count
337: FROM po_requisition_headers_all prh,
338: po_requisition_lines_all prl
339: WHERE prh.segment1 = l_req_num
340: AND prh.org_id = l_ou_id
341: AND prh.requisition_header_id = prl.requisition_header_id