APPS.INV_RCV_COMMON_APIS dependencies on PO_REQUISITION_LINES_ALL

Line 6344: FROM po_requisition_lines_all prl, mtl_supply ms

6340: CONNECT BY parent_lpn_id = PRIOR lpn_id)
6341: AND wlc.parent_lpn_id = wln.lpn_id
6342: AND EXISTS(
6343: SELECT 1
6344: FROM po_requisition_lines_all prl, mtl_supply ms
6345: WHERE prl.requisition_header_id = p_requiition_header_id
6346: AND prl.requisition_header_id = ms.req_header_id
6347: AND prl.requisition_line_id = ms.req_line_id
6348: AND ms.supply_type_code = 'SHIPMENT'

Line 6368: FROM po_requisition_lines_all prl, mtl_supply ms

6364: START WITH lpn_id = p_lpn_id
6365: CONNECT BY parent_lpn_id = PRIOR lpn_id)
6366: AND EXISTS(
6367: SELECT 1
6368: FROM po_requisition_lines_all prl, mtl_supply ms
6369: WHERE prl.requisition_header_id = p_requiition_header_id
6370: AND prl.requisition_header_id = ms.req_header_id
6371: AND prl.requisition_line_id = ms.req_line_id
6372: AND ms.supply_type_code = 'SHIPMENT'

Line 6760: FROM po_req_distributions_all pod, po_requisition_lines_all pol

6756: GROUP BY project_id, task_id;
6757: ELSIF p_document_type = 'REQ' THEN
6758: SELECT COUNT(COUNT(*))
6759: INTO l_project_tasks_count
6760: FROM po_req_distributions_all pod, po_requisition_lines_all pol
6761: WHERE pol.requisition_header_id = p_req_header_id
6762: AND pod.requisition_line_id = pol.requisition_line_id
6763: AND pod.project_id IS NOT NULL
6764: AND (p_item_id IS NULL OR pol.item_id = p_item_id)

Line 6773: FROM po_req_distributions_all pod, po_requisition_lines_all pol

6769: GROUP BY project_id, task_id;
6770:
6771: SELECT COUNT(*)
6772: INTO l_distributions_count
6773: FROM po_req_distributions_all pod, po_requisition_lines_all pol
6774: WHERE pol.requisition_header_id = p_req_header_id
6775: AND pod.requisition_line_id = pol.requisition_line_id
6776: AND (p_item_id IS NULL OR pol.item_id = p_item_id)
6777: AND ( (p_item_rev IS NULL OR pol.item_revision IS NULL) OR

Line 6793: FROM po_req_distributions_all pod, po_requisition_lines_all pol

6789: END IF;
6790:
6791: SELECT COUNT(COUNT(*))
6792: INTO l_project_tasks_count
6793: FROM po_req_distributions_all pod, po_requisition_lines_all pol
6794: WHERE pol.requisition_header_id = p_req_header_id
6795: AND pod.requisition_line_id = pol.requisition_line_id
6796: AND pod.project_id IS NOT NULL
6797: AND (p_item_id IS NULL OR pol.item_id = p_item_id)

Line 6810: FROM po_req_distributions_all pod, po_requisition_lines_all pol

6806:
6807:
6808: SELECT COUNT(*)
6809: INTO l_distributions_count
6810: FROM po_req_distributions_all pod, po_requisition_lines_all pol
6811: WHERE pol.requisition_header_id = p_req_header_id
6812: AND pod.requisition_line_id = pol.requisition_line_id
6813: AND (p_item_id IS NULL OR pol.item_id = p_item_id)
6814: AND ( (p_item_rev IS NULL OR pol.item_revision IS NULL) OR

Line 7307: FROM po_req_distributions_all pod, po_requisition_lines_all pol

7303: ELSIF p_document_type = 'REQ' THEN
7304: BEGIN
7305: SELECT pod.task_id
7306: INTO l_task_id
7307: FROM po_req_distributions_all pod, po_requisition_lines_all pol
7308: WHERE pol.requisition_header_id = p_req_header_id
7309: AND pod.requisition_line_id = pol.requisition_line_id
7310: AND pod.project_id = p_project_id
7311: AND(p_item_id IS NULL

Line 8058: from po_requisition_lines_all

8054: IF p_req_line_id IS NOT NULL THEN
8055:
8056: Select org_id
8057: into l_operating_unit_id
8058: from po_requisition_lines_all
8059: where requisition_line_id = p_req_line_id;
8060:
8061: END IF;
8062: