APPS.INV_DIAG_RCV_IO dependencies on PO_REQUISITION_LINES_ALL

Line 101: l_line_num po_requisition_lines_all.line_num%TYPE;

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;
105: l_count NUMBER := 1;

Line 242: po_requisition_lines_all prl,

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
246: AND prh.org_id = l_ou_id

Line 271: po_requisition_lines_all prl,

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
275: AND prh.org_id = l_ou_id

Line 297: po_requisition_lines_all prl

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
301: AND prl.line_num = l_line_num

Line 338: po_requisition_lines_all prl

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
342: AND prl.source_type_code = 'INVENTORY';