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 2081: FROM PO_DISTRIBUTIONS POD, PO_LINES POL, PO_LINE_LOCATIONS POLL

2077:
2078: CURSOR pod_dest_context_cur IS
2079: SELECT DISTINCT NVL(POD.DESTINATION_TYPE_CODE,POD.DESTINATION_CONTEXT)
2080: -- p_po_release_id is null and p_po_line_id is null
2081: FROM PO_DISTRIBUTIONS POD, PO_LINES POL, PO_LINE_LOCATIONS POLL
2082: WHERE POL.PO_HEADER_ID = p_po_header_id
2083: AND POLL.PO_LINE_ID = POL.PO_LINE_ID
2084: AND POLL.SHIP_TO_ORGANIZATION_ID = NVL(p_organization_id, POLL.SHIP_TO_ORGANIZATION_ID) -- Bug 8242448
2085: AND POD.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID

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

2095: AND POLL.SHIPMENT_TYPE IN ( 'STANDARD','BLANKET','SCHEDULED' )
2096: UNION ALL
2097: SELECT DISTINCT NVL(POD.DESTINATION_TYPE_CODE,POD.DESTINATION_CONTEXT)
2098: -- p_po_release_id is null and p_po_line_id is not null
2099: FROM PO_DISTRIBUTIONS POD, PO_LINES POL, PO_LINE_LOCATIONS POLL
2100: WHERE POLL.PO_HEADER_ID = p_po_header_id
2101: AND POLL.PO_LINE_ID = POL.PO_LINE_ID
2102: AND POLL.SHIP_TO_ORGANIZATION_ID = NVL(p_organization_id, POLL.SHIP_TO_ORGANIZATION_ID) -- Bug 8242448
2103: AND POD.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID

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

2113: AND POLL.SHIPMENT_TYPE IN ( 'STANDARD','BLANKET','SCHEDULED' )
2114: UNION ALL
2115: SELECT DISTINCT NVL(POD.DESTINATION_TYPE_CODE,POD.DESTINATION_CONTEXT)
2116: -- p_po_release_id is not NULL
2117: FROM PO_DISTRIBUTIONS POD, PO_LINES POL, PO_LINE_LOCATIONS POLL
2118: WHERE POLL.PO_HEADER_ID = p_po_header_id
2119: AND POLL.PO_LINE_ID = POL.PO_LINE_ID
2120: AND POLL.SHIP_TO_ORGANIZATION_ID = NVL(p_organization_id, POLL.SHIP_TO_ORGANIZATION_ID) -- Bug 8242448
2121: AND POD.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID

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

2139: -- distributions against po line locations whose closed_code <> 'FINALLY CLOSED'.
2140:
2141: CURSOR pod_dest_context_inv_cur IS
2142: SELECT DISTINCT NVL(POD.DESTINATION_TYPE_CODE,POD.DESTINATION_CONTEXT)
2143: FROM PO_DISTRIBUTIONS POD, PO_LINES POL, PO_LINE_LOCATIONS POLL
2144: WHERE POL.PO_HEADER_ID = p_po_header_id
2145: AND POLL.PO_LINE_ID = POL.PO_LINE_ID
2146: AND POLL.SHIP_TO_ORGANIZATION_ID = NVL(p_organization_id, POLL.SHIP_TO_ORGANIZATION_ID)
2147: AND POD.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID

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

2154: AND NVL(POLL.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
2155: AND POLL.SHIPMENT_TYPE IN ( 'STANDARD','BLANKET','SCHEDULED' )
2156: UNION ALL
2157: SELECT DISTINCT NVL(POD.DESTINATION_TYPE_CODE,POD.DESTINATION_CONTEXT)
2158: FROM PO_DISTRIBUTIONS POD, PO_LINES POL, PO_LINE_LOCATIONS POLL
2159: WHERE POLL.PO_HEADER_ID = p_po_header_id
2160: AND POLL.PO_LINE_ID = POL.PO_LINE_ID
2161: AND POLL.SHIP_TO_ORGANIZATION_ID = NVL(p_organization_id, POLL.SHIP_TO_ORGANIZATION_ID)
2162: AND POD.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID

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

2169: AND NVL(POLL.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
2170: AND POLL.SHIPMENT_TYPE IN ( 'STANDARD','BLANKET','SCHEDULED' )
2171: UNION ALL
2172: SELECT DISTINCT NVL(POD.DESTINATION_TYPE_CODE,POD.DESTINATION_CONTEXT)
2173: FROM PO_DISTRIBUTIONS POD, PO_LINES POL, PO_LINE_LOCATIONS POLL
2174: WHERE POLL.PO_HEADER_ID = p_po_header_id
2175: AND POLL.PO_LINE_ID = POL.PO_LINE_ID
2176: AND POLL.SHIP_TO_ORGANIZATION_ID = NVL(p_organization_id, POLL.SHIP_TO_ORGANIZATION_ID)
2177: AND POD.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID

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

2187: -- Bug 8242448 - Code changes end
2188:
2189: /*
2190: SELECT DISTINCT Nvl(pod.destination_type_code,pod.destination_context)
2191: FROM po_distributions pod, po_lines pol, po_line_locations poll
2192: WHERE pod.po_header_id = p_po_header_id
2193: AND NVL(poll.po_release_id, -1) = NVL(p_po_release_id, NVL(poll.po_release_id, -1))
2194: AND NVL(poll.po_line_id, -1) = NVL(p_po_line_id, NVL(poll.po_line_id, -1))
2195: --AND pol.item_id = p_item_id

Line 4351: FROM po_distributions pod

4347:
4348: BEGIN
4349: SELECT COUNT(DISTINCT pod.destination_subinventory)
4350: INTO l_count
4351: FROM po_distributions pod
4352: WHERE pod.po_header_id = p_po_header_id
4353: AND pod.po_line_id = NVL(p_po_line_id, pod.po_line_id)
4354: AND NVL(pod.po_release_id, -1) = NVL(p_po_release_id, NVL(pod.po_release_id, -1))
4355: AND pod.destination_subinventory IS NOT NULL

Line 4367: FROM po_distributions pod

4363: l_progress := '35';
4364: BEGIN
4365: SELECT pod.destination_subinventory, nvl(kanban_card_id, -999) --Bug 4671198
4366: INTO x_sub_code, l_kanban_card_id --Bug 4671198
4367: FROM po_distributions pod
4368: WHERE pod.po_header_id = p_po_header_id
4369: AND pod.po_line_id = NVL(p_po_line_id, pod.po_line_id)
4370: AND NVL(pod.po_release_id, -1) = NVL(p_po_release_id, NVL(pod.po_release_id, -1))
4371: AND pod.destination_subinventory IS NOT NULL

Line 4681: FROM po_distributions_all pda,po_lines_all pol, po_line_locations_all pll, hr_locations hl

4677: BEGIN
4678: /* bug 14305407 modified the query to improve the performance */
4679: SELECT distinct(hl.location_code)
4680: INTO x_location_code
4681: FROM po_distributions_all pda,po_lines_all pol, po_line_locations_all pll, hr_locations hl
4682: WHERE pda.po_header_id = pll.po_header_id
4683: AND pda.line_location_id = pll.line_location_id
4684: AND pda.po_line_id = pll.po_line_id
4685: AND pda.po_header_id = pol.po_header_id

Line 6704: FROM po_distributions_all pod, po_lines_all pol

6700:
6701: IF p_document_type = 'PO' THEN
6702: SELECT COUNT(COUNT(*)) -- get the no of project/tasks combinations
6703: INTO l_project_tasks_count
6704: FROM po_distributions_all pod, po_lines_all pol
6705: WHERE pod.po_header_id = p_po_header_id
6706: AND pod.po_line_id = NVL(p_po_line_id, pod.po_line_id)
6707: AND pod.project_id IS NOT NULL
6708: AND pod.po_header_id = pol.po_header_id

Line 6719: FROM po_distributions_all pod, po_lines_all pol

6715: GROUP BY pod.project_id, pod.task_id;
6716:
6717: SELECT COUNT(*)
6718: INTO l_distributions_count
6719: FROM po_distributions_all pod, po_lines_all pol
6720: WHERE pod.po_header_id = p_po_header_id
6721: AND pod.po_line_id = NVL(p_po_line_id, pod.po_line_id)
6722: AND pod.po_header_id = pol.po_header_id
6723: AND pod.po_line_id = pol.po_line_id

Line 6733: FROM po_distributions_all pod, rcv_shipment_lines rsl

6729:
6730: ELSIF p_document_type = 'ASN' THEN
6731: SELECT COUNT(COUNT(*))
6732: INTO l_project_tasks_count
6733: FROM po_distributions_all pod, rcv_shipment_lines rsl
6734: WHERE pod.po_header_id = rsl.po_header_id
6735: AND rsl.shipment_header_id = p_shipment_header_id
6736: AND (p_item_id IS NULL OR rsl.item_id = p_item_id)
6737: AND ( (p_item_rev IS NULL OR rsl.item_revision IS NULL) OR

Line 6746: FROM po_distributions_all pod, rcv_shipment_lines rsl

6742: GROUP BY project_id, task_id;
6743:
6744: SELECT COUNT(COUNT(*))
6745: INTO l_distributions_count
6746: FROM po_distributions_all pod, rcv_shipment_lines rsl
6747: WHERE pod.po_header_id = rsl.po_header_id
6748: AND rsl.po_line_id = pod.po_line_id(+)
6749: AND rsl.po_line_location_id = pod.line_location_id(+)
6750: AND rsl.shipment_header_id = p_shipment_header_id

Line 6851: FROM po_distributions_all pod, po_lines_all pol

6847: ELSIF p_document_type = 'RECEIPT' THEN
6848: IF p_po_header_id IS NOT NULL THEN
6849: SELECT COUNT(COUNT(*)) -- get the no of project/tasks combinations
6850: INTO l_project_tasks_count
6851: FROM po_distributions_all pod, po_lines_all pol
6852: WHERE pod.po_header_id = p_po_header_id
6853: AND pod.project_id IS NOT NULL
6854: AND pod.po_header_id = pol.po_header_id
6855: AND pod.po_line_id = pol.po_line_id

Line 6865: FROM po_distributions_all pod, po_lines_all pol

6861: GROUP BY pod.project_id, pod.task_id;
6862:
6863: SELECT COUNT(*)
6864: INTO l_distributions_count
6865: FROM po_distributions_all pod, po_lines_all pol
6866: WHERE pod.po_header_id = p_po_header_id
6867: AND pod.po_header_id = pol.po_header_id
6868: AND pod.po_line_id = pol.po_line_id
6869: AND (p_item_id IS NULL OR pol.item_id = p_item_id)

Line 7260: FROM po_distributions_all pod, po_lines_all pol

7256: IF p_document_type = 'PO' THEN
7257: BEGIN
7258: SELECT pod.task_id
7259: INTO l_task_id
7260: FROM po_distributions_all pod, po_lines_all pol
7261: WHERE pod.po_header_id = p_po_header_id
7262: AND pod.po_line_id = NVL(p_po_line_id, pod.po_line_id)
7263: AND pod.project_id = p_project_id
7264: AND pod.po_header_id = pol.po_header_id

Line 7286: FROM po_distributions_all pod, rcv_shipment_lines rsl

7282: ELSIF p_document_type = 'ASN' THEN
7283: BEGIN
7284: SELECT pod.task_id
7285: INTO l_task_id
7286: FROM po_distributions_all pod, rcv_shipment_lines rsl
7287: WHERE pod.po_header_id = rsl.po_header_id
7288: AND rsl.po_line_id = pod.po_line_id(+)
7289: AND rsl.po_line_location_id = pod.line_location_id(+)
7290: AND rsl.shipment_header_id = p_shipment_header_id

Line 7346: FROM po_distributions_all pod, po_lines_all pol

7342: IF p_po_header_id IS NOT NULL THEN
7343: BEGIN
7344: SELECT pod.task_id
7345: INTO l_task_id
7346: FROM po_distributions_all pod, po_lines_all pol
7347: WHERE pod.po_header_id = p_po_header_id
7348: AND pod.project_id = p_project_id
7349: AND pod.po_header_id = pol.po_header_id
7350: AND pod.po_line_id = pol.po_line_id