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_DISTRIBUTIONS

Line 2074: FROM PO_DISTRIBUTIONS POD, PO_LINES POL, PO_LINE_LOCATIONS POLL

2070:
2071: CURSOR pod_dest_context_cur IS
2072: SELECT DISTINCT NVL(POD.DESTINATION_TYPE_CODE,POD.DESTINATION_CONTEXT)
2073: -- p_po_release_id is null and p_po_line_id is null
2074: FROM PO_DISTRIBUTIONS POD, PO_LINES POL, PO_LINE_LOCATIONS POLL
2075: WHERE POL.PO_HEADER_ID = p_po_header_id
2076: AND POLL.PO_LINE_ID = POL.PO_LINE_ID
2077: AND POD.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
2078: AND p_po_release_id is NULL

Line 2089: FROM PO_DISTRIBUTIONS POD, PO_LINES POL, PO_LINE_LOCATIONS POLL

2085: AND POLL.SHIPMENT_TYPE IN ( 'STANDARD','BLANKET','SCHEDULED' )
2086: UNION ALL
2087: SELECT DISTINCT NVL(POD.DESTINATION_TYPE_CODE,POD.DESTINATION_CONTEXT)
2088: -- p_po_release_id is null and p_po_line_id is not null
2089: FROM PO_DISTRIBUTIONS POD, PO_LINES POL, PO_LINE_LOCATIONS POLL
2090: WHERE POLL.PO_HEADER_ID = p_po_header_id
2091: AND POLL.PO_LINE_ID = POL.PO_LINE_ID
2092: AND POD.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
2093: AND p_po_release_id is NULL

Line 2104: FROM PO_DISTRIBUTIONS POD, PO_LINES POL, PO_LINE_LOCATIONS POLL

2100: AND POLL.SHIPMENT_TYPE IN ( 'STANDARD','BLANKET','SCHEDULED' )
2101: UNION ALL
2102: SELECT DISTINCT NVL(POD.DESTINATION_TYPE_CODE,POD.DESTINATION_CONTEXT)
2103: -- p_po_release_id is not NULL
2104: FROM PO_DISTRIBUTIONS POD, PO_LINES POL, PO_LINE_LOCATIONS POLL
2105: WHERE POLL.PO_HEADER_ID = p_po_header_id
2106: AND POLL.PO_LINE_ID = POL.PO_LINE_ID
2107: AND POD.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
2108: AND (p_po_release_id is NOT NULL AND POLL.PO_RELEASE_ID = p_po_release_id)

Line 2118: FROM po_distributions pod, po_lines pol, po_line_locations poll

2114: AND NVL(POLL.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
2115: AND POLL.SHIPMENT_TYPE IN ( 'STANDARD','BLANKET','SCHEDULED' );
2116: /*
2117: SELECT DISTINCT Nvl(pod.destination_type_code,pod.destination_context)
2118: FROM po_distributions pod, po_lines pol, po_line_locations poll
2119: WHERE pod.po_header_id = p_po_header_id
2120: AND NVL(poll.po_release_id, -1) = NVL(p_po_release_id, NVL(poll.po_release_id, -1))
2121: AND NVL(poll.po_line_id, -1) = NVL(p_po_line_id, NVL(poll.po_line_id, -1))
2122: --AND pol.item_id = p_item_id

Line 3868: FROM po_distributions pod

3864:
3865: BEGIN
3866: SELECT COUNT(DISTINCT pod.destination_subinventory)
3867: INTO l_count
3868: FROM po_distributions pod
3869: WHERE pod.po_header_id = p_po_header_id
3870: AND pod.po_line_id = NVL(p_po_line_id, pod.po_line_id)
3871: AND NVL(pod.po_release_id, -1) = NVL(p_po_release_id, NVL(pod.po_release_id, -1))
3872: AND pod.destination_subinventory IS NOT NULL

Line 3884: FROM po_distributions pod

3880: l_progress := '35';
3881: BEGIN
3882: SELECT pod.destination_subinventory, nvl(kanban_card_id, -999) --Bug 4671198
3883: INTO x_sub_code, l_kanban_card_id --Bug 4671198
3884: FROM po_distributions pod
3885: WHERE pod.po_header_id = p_po_header_id
3886: AND pod.po_line_id = NVL(p_po_line_id, pod.po_line_id)
3887: AND NVL(pod.po_release_id, -1) = NVL(p_po_release_id, NVL(pod.po_release_id, -1))
3888: AND pod.destination_subinventory IS NOT NULL

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