APPS.INV_RCV_COMMON_APIS dependencies on PO_REQUISITION_LINES_ALL

Line 5812: FROM po_requisition_lines_all prl, mtl_supply ms

5808: CONNECT BY parent_lpn_id = PRIOR lpn_id)
5809: AND wlc.parent_lpn_id = wln.lpn_id
5810: AND EXISTS(
5811: SELECT 1
5812: FROM po_requisition_lines_all prl, mtl_supply ms
5813: WHERE prl.requisition_header_id = p_requiition_header_id
5814: AND prl.requisition_header_id = ms.req_header_id
5815: AND prl.requisition_line_id = ms.req_line_id
5816: AND ms.supply_type_code = 'SHIPMENT'

Line 5836: FROM po_requisition_lines_all prl, mtl_supply ms

5832: START WITH lpn_id = p_lpn_id
5833: CONNECT BY parent_lpn_id = PRIOR lpn_id)
5834: AND EXISTS(
5835: SELECT 1
5836: FROM po_requisition_lines_all prl, mtl_supply ms
5837: WHERE prl.requisition_header_id = p_requiition_header_id
5838: AND prl.requisition_header_id = ms.req_header_id
5839: AND prl.requisition_line_id = ms.req_line_id
5840: AND ms.supply_type_code = 'SHIPMENT'

Line 6228: FROM po_req_distributions_all pod, po_requisition_lines_all pol

6224: GROUP BY project_id, task_id;
6225: ELSIF p_document_type = 'REQ' THEN
6226: SELECT COUNT(COUNT(*))
6227: INTO l_project_tasks_count
6228: FROM po_req_distributions_all pod, po_requisition_lines_all pol
6229: WHERE pol.requisition_header_id = p_req_header_id
6230: AND pod.requisition_line_id = pol.requisition_line_id
6231: AND pod.project_id IS NOT NULL
6232: AND (p_item_id IS NULL OR pol.item_id = p_item_id)

Line 6241: FROM po_req_distributions_all pod, po_requisition_lines_all pol

6237: GROUP BY project_id, task_id;
6238:
6239: SELECT COUNT(*)
6240: INTO l_distributions_count
6241: FROM po_req_distributions_all pod, po_requisition_lines_all pol
6242: WHERE pol.requisition_header_id = p_req_header_id
6243: AND pod.requisition_line_id = pol.requisition_line_id
6244: AND (p_item_id IS NULL OR pol.item_id = p_item_id)
6245: AND ( (p_item_rev IS NULL OR pol.item_revision IS NULL) OR

Line 6261: FROM po_req_distributions_all pod, po_requisition_lines_all pol

6257: END IF;
6258:
6259: SELECT COUNT(COUNT(*))
6260: INTO l_project_tasks_count
6261: FROM po_req_distributions_all pod, po_requisition_lines_all pol
6262: WHERE pol.requisition_header_id = p_req_header_id
6263: AND pod.requisition_line_id = pol.requisition_line_id
6264: AND pod.project_id IS NOT NULL
6265: AND (p_item_id IS NULL OR pol.item_id = p_item_id)

Line 6278: FROM po_req_distributions_all pod, po_requisition_lines_all pol

6274:
6275:
6276: SELECT COUNT(*)
6277: INTO l_distributions_count
6278: FROM po_req_distributions_all pod, po_requisition_lines_all pol
6279: WHERE pol.requisition_header_id = p_req_header_id
6280: AND pod.requisition_line_id = pol.requisition_line_id
6281: AND (p_item_id IS NULL OR pol.item_id = p_item_id)
6282: AND ( (p_item_rev IS NULL OR pol.item_revision IS NULL) OR

Line 6775: FROM po_req_distributions_all pod, po_requisition_lines_all pol

6771: ELSIF p_document_type = 'REQ' THEN
6772: BEGIN
6773: SELECT pod.task_id
6774: INTO l_task_id
6775: FROM po_req_distributions_all pod, po_requisition_lines_all pol
6776: WHERE pol.requisition_header_id = p_req_header_id
6777: AND pod.requisition_line_id = pol.requisition_line_id
6778: AND pod.project_id = p_project_id
6779: AND(p_item_id IS NULL

Line 7526: from po_requisition_lines_all

7522: IF p_req_line_id IS NOT NULL THEN
7523:
7524: Select org_id
7525: into l_operating_unit_id
7526: from po_requisition_lines_all
7527: where requisition_line_id = p_req_line_id;
7528:
7529: END IF;
7530: