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_LINES

Line 2009: FROM po_line_locations poll, po_lines pol

2005: -- searching mechanism will not
2006: -- go to item/org level.
2007: SELECT poll.receiving_routing_id
2008: -- p_po_release_id is null and p_po_line_id is null
2009: FROM po_line_locations poll, po_lines pol
2010: WHERE pol.po_header_id = p_po_header_id
2011: AND poll.po_line_id = pol.po_line_id
2012: AND p_po_release_id is NULL
2013: AND p_po_line_id is null

Line 2024: FROM po_line_locations poll, po_lines pol

2020: AND poll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')
2021: UNION ALL
2022: SELECT poll.receiving_routing_id
2023: -- p_po_release_id is null and p_po_line_id is not null
2024: FROM po_line_locations poll, po_lines pol
2025: WHERE poll.po_header_id = p_po_header_id
2026: AND poll.po_line_id = pol.po_line_id
2027: AND p_po_release_id is NULL
2028: AND (p_po_line_id is not null AND poll.po_line_id = p_po_line_id)

Line 2039: FROM po_line_locations poll, po_lines pol

2035: AND poll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')
2036: UNION ALL
2037: SELECT poll.receiving_routing_id
2038: -- p_po_release_id is not null
2039: FROM po_line_locations poll, po_lines pol
2040: WHERE poll.po_header_id = p_po_header_id
2041: AND poll.po_line_id = pol.po_line_id
2042: AND (p_po_release_id is NOT NULL AND poll.po_release_id = p_po_release_id)
2043: AND (p_po_line_id is null or poll.po_line_id = p_po_line_id)

Line 2053: FROM po_line_locations poll, po_lines pol

2049: /*Fix for bug #4755862*/
2050: AND poll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED');
2051: /*
2052: SELECT poll.receiving_routing_id
2053: FROM po_line_locations poll, po_lines pol
2054: WHERE poll.po_header_id = p_po_header_id
2055: AND NVL(poll.po_release_id, -1) = NVL(p_po_release_id, NVL(poll.po_release_id, -1))
2056: AND NVL(poll.po_line_id, -1) = NVL(p_po_line_id, NVL(poll.po_line_id, -1))
2057: --AND pol.item_id = p_item_id

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 3521: FROM po_lines pol, mtl_units_of_measure mum

3517: l_progress := '20';
3518: BEGIN
3519: SELECT mum.uom_code, mum.uom_class
3520: INTO x_uom_code, l_class
3521: FROM po_lines pol, mtl_units_of_measure mum
3522: WHERE pol.po_header_id = p_po_header_id
3523: AND pol.unit_meas_lookup_code IS NOT NULL
3524: AND pol.line_num = p_line_no
3525: AND pol.unit_meas_lookup_code = mum.unit_of_measure

Line 3527: FROM po_line_locations_all poll, po_lines_all po

3523: AND pol.unit_meas_lookup_code IS NOT NULL
3524: AND pol.line_num = p_line_no
3525: AND pol.unit_meas_lookup_code = mum.unit_of_measure
3526: AND pol.po_line_id IN (SELECT poll.po_line_id
3527: FROM po_line_locations_all poll, po_lines_all po
3528: WHERE poll.po_header_id = po.po_header_id
3529: AND Nvl(poll.approved_flag,'N') = 'Y'
3530: AND Nvl(poll.cancel_flag,'N') = 'N'
3531: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING')

Line 3558: FROM po_lines pol, mtl_units_of_measure mum

3554: l_progress := '30';
3555: BEGIN
3556: SELECT mum.uom_code, mum.uom_class
3557: INTO x_uom_code, l_class
3558: FROM po_lines pol, mtl_units_of_measure mum
3559: WHERE pol.po_header_id = p_po_header_id
3560: AND pol.unit_meas_lookup_code IS NOT NULL
3561: AND pol.unit_meas_lookup_code = mum.unit_of_measure
3562: AND pol.item_description = p_item_desc

Line 3564: FROM po_line_locations_all poll, po_lines_all po

3560: AND pol.unit_meas_lookup_code IS NOT NULL
3561: AND pol.unit_meas_lookup_code = mum.unit_of_measure
3562: AND pol.item_description = p_item_desc
3563: AND pol.po_line_id IN (SELECT poll.po_line_id
3564: FROM po_line_locations_all poll, po_lines_all po
3565: WHERE poll.po_header_id = po.po_header_id
3566: AND Nvl(poll.approved_flag,'N') = 'Y'
3567: AND Nvl(poll.cancel_flag,'N') = 'N'
3568: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING')

Line 3597: FROM po_lines pol

3593: l_progress := '20';
3594: BEGIN
3595: SELECT COUNT(DISTINCT pol.unit_meas_lookup_code)
3596: INTO l_count
3597: FROM po_lines pol
3598: WHERE pol.po_header_id = p_po_header_id
3599: AND pol.unit_meas_lookup_code IS NOT NULL
3600: AND pol.item_id = p_item_id
3601: AND pol.po_line_id IN (SELECT poll.po_line_id

Line 3602: FROM po_line_locations_all poll, po_lines_all po

3598: WHERE pol.po_header_id = p_po_header_id
3599: AND pol.unit_meas_lookup_code IS NOT NULL
3600: AND pol.item_id = p_item_id
3601: AND pol.po_line_id IN (SELECT poll.po_line_id
3602: FROM po_line_locations_all poll, po_lines_all po
3603: WHERE poll.po_header_id = po.po_header_id
3604: AND Nvl(poll.approved_flag,'N') = 'Y'
3605: AND Nvl(poll.cancel_flag,'N') = 'N'
3606: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING')

Line 3624: FROM po_lines pol

3620: SELECT inv_ui_item_lovs.get_conversion_rate(mum.uom_code,
3621: p_organization_id,
3622: pol.item_id)
3623: INTO x_uom_code
3624: FROM po_lines pol
3625: , mtl_units_of_measure mum
3626: WHERE pol.po_header_id = p_po_header_id
3627: AND pol.unit_meas_lookup_code IS NOT NULL
3628: AND pol.item_id = p_item_id

Line 3631: FROM po_line_locations_all poll, po_lines_all po

3627: AND pol.unit_meas_lookup_code IS NOT NULL
3628: AND pol.item_id = p_item_id
3629: AND mum.UNIT_OF_MEASURE(+) = pol.UNIT_MEAS_LOOKUP_CODE
3630: AND pol.po_line_id IN (SELECT poll.po_line_id
3631: FROM po_line_locations_all poll, po_lines_all po
3632: WHERE poll.po_header_id = po.po_header_id
3633: AND Nvl(poll.approved_flag,'N') = 'Y'
3634: AND Nvl(poll.cancel_flag,'N') = 'N'
3635: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING')

Line 3874: FROM po_lines pol

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
3873: AND pod.po_line_id IN(SELECT pol.po_line_id
3874: FROM po_lines pol
3875: WHERE pol.item_id = p_item_id);
3876: EXCEPTION
3877: WHEN NO_DATA_FOUND THEN
3878: l_count := 0;

Line 3890: FROM po_lines pol

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
3889: AND pod.po_line_id IN(SELECT pol.po_line_id
3890: FROM po_lines pol
3891: WHERE pol.item_id = p_item_id)
3892: AND ROWNUM = 1;
3893: EXCEPTION
3894: WHEN OTHERS THEN

Line 4194: FROM hr_locations hl, po_line_locations poll,po_lines pol

4190:
4191: IF p_po_header_id IS NOT NULL THEN
4192: SELECT distinct( hl.location_code )
4193: into x_location_code
4194: FROM hr_locations hl, po_line_locations poll,po_lines pol
4195: WHERE hl.location_id = poll.ship_to_location_id
4196: AND poll.po_header_id = p_po_header_id
4197: AND poll.po_line_id = NVL(p_po_line_id, poll.po_line_id)
4198: AND Nvl(pol.item_id,-9999) = NVL(p_item_id,Nvl(pol.item_id,-9999))--BUG 4500676

Line 4317: FROM po_line_locations poll,po_lines pol

4313: END IF;
4314:
4315: SELECT DISTINCT (pol.item_revision)
4316: INTO x_revision_code
4317: FROM po_line_locations poll,po_lines pol
4318: WHERE pol.po_header_id = p_po_header_id
4319: AND NVL(poll.po_line_id,-1) = NVL(p_po_line_id, NVL(poll.po_line_id, -1))
4320: AND NVL(pol.item_id,-1) = NVL(p_item_id,NVL(pol.item_id, -1))
4321: AND poll.ship_to_organization_id= p_organization_id

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 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 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