eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_RCV_COMMON_APIS dependencies on PO_REQ_DISTRIBUTIONS_ALL

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