APPS.INV_RCV_COMMON_APIS dependencies on PO_REQ_DISTRIBUTIONS_ALL

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