APPS.INV_RCV_COMMON_APIS dependencies on PO_DISTRIBUTIONS_ALL

Line 6172: FROM po_distributions_all pod, po_lines_all pol

6168:
6169: IF p_document_type = 'PO' THEN
6170: SELECT COUNT(COUNT(*)) -- get the no of project/tasks combinations
6171: INTO l_project_tasks_count
6172: FROM po_distributions_all pod, po_lines_all pol
6173: WHERE pod.po_header_id = p_po_header_id
6174: AND pod.po_line_id = NVL(p_po_line_id, pod.po_line_id)
6175: AND pod.project_id IS NOT NULL
6176: AND pod.po_header_id = pol.po_header_id

Line 6187: FROM po_distributions_all pod, po_lines_all pol

6183: GROUP BY pod.project_id, pod.task_id;
6184:
6185: SELECT COUNT(*)
6186: INTO l_distributions_count
6187: FROM po_distributions_all pod, po_lines_all pol
6188: WHERE pod.po_header_id = p_po_header_id
6189: AND pod.po_line_id = NVL(p_po_line_id, pod.po_line_id)
6190: AND pod.po_header_id = pol.po_header_id
6191: AND pod.po_line_id = pol.po_line_id

Line 6201: FROM po_distributions_all pod, rcv_shipment_lines rsl

6197:
6198: ELSIF p_document_type = 'ASN' THEN
6199: SELECT COUNT(COUNT(*))
6200: INTO l_project_tasks_count
6201: FROM po_distributions_all pod, rcv_shipment_lines rsl
6202: WHERE pod.po_header_id = rsl.po_header_id
6203: AND rsl.shipment_header_id = p_shipment_header_id
6204: AND (p_item_id IS NULL OR rsl.item_id = p_item_id)
6205: AND ( (p_item_rev IS NULL OR rsl.item_revision IS NULL) OR

Line 6214: FROM po_distributions_all pod, rcv_shipment_lines rsl

6210: GROUP BY project_id, task_id;
6211:
6212: SELECT COUNT(COUNT(*))
6213: INTO l_distributions_count
6214: FROM po_distributions_all pod, rcv_shipment_lines rsl
6215: WHERE pod.po_header_id = rsl.po_header_id
6216: AND rsl.po_line_id = pod.po_line_id(+)
6217: AND rsl.po_line_location_id = pod.line_location_id(+)
6218: AND rsl.shipment_header_id = p_shipment_header_id

Line 6319: FROM po_distributions_all pod, po_lines_all pol

6315: ELSIF p_document_type = 'RECEIPT' THEN
6316: IF p_po_header_id IS NOT NULL THEN
6317: SELECT COUNT(COUNT(*)) -- get the no of project/tasks combinations
6318: INTO l_project_tasks_count
6319: FROM po_distributions_all pod, po_lines_all pol
6320: WHERE pod.po_header_id = p_po_header_id
6321: AND pod.project_id IS NOT NULL
6322: AND pod.po_header_id = pol.po_header_id
6323: AND pod.po_line_id = pol.po_line_id

Line 6333: FROM po_distributions_all pod, po_lines_all pol

6329: GROUP BY pod.project_id, pod.task_id;
6330:
6331: SELECT COUNT(*)
6332: INTO l_distributions_count
6333: FROM po_distributions_all pod, po_lines_all pol
6334: WHERE pod.po_header_id = p_po_header_id
6335: AND pod.po_header_id = pol.po_header_id
6336: AND pod.po_line_id = pol.po_line_id
6337: AND (p_item_id IS NULL OR pol.item_id = p_item_id)

Line 6728: FROM po_distributions_all pod, po_lines_all pol

6724: IF p_document_type = 'PO' THEN
6725: BEGIN
6726: SELECT pod.task_id
6727: INTO l_task_id
6728: FROM po_distributions_all pod, po_lines_all pol
6729: WHERE pod.po_header_id = p_po_header_id
6730: AND pod.po_line_id = NVL(p_po_line_id, pod.po_line_id)
6731: AND pod.project_id = p_project_id
6732: AND pod.po_header_id = pol.po_header_id

Line 6754: FROM po_distributions_all pod, rcv_shipment_lines rsl

6750: ELSIF p_document_type = 'ASN' THEN
6751: BEGIN
6752: SELECT pod.task_id
6753: INTO l_task_id
6754: FROM po_distributions_all pod, rcv_shipment_lines rsl
6755: WHERE pod.po_header_id = rsl.po_header_id
6756: AND rsl.po_line_id = pod.po_line_id(+)
6757: AND rsl.po_line_location_id = pod.line_location_id(+)
6758: AND rsl.shipment_header_id = p_shipment_header_id

Line 6814: FROM po_distributions_all pod, po_lines_all pol

6810: IF p_po_header_id IS NOT NULL THEN
6811: BEGIN
6812: SELECT pod.task_id
6813: INTO l_task_id
6814: FROM po_distributions_all pod, po_lines_all pol
6815: WHERE pod.po_header_id = p_po_header_id
6816: AND pod.project_id = p_project_id
6817: AND pod.po_header_id = pol.po_header_id
6818: AND pod.po_line_id = pol.po_line_id