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 2016: FROM po_line_locations poll, po_lines pol

2012: -- searching mechanism will not
2013: -- go to item/org level.
2014: SELECT poll.receiving_routing_id
2015: -- p_po_release_id is null and p_po_line_id is null
2016: FROM po_line_locations poll, po_lines pol
2017: WHERE pol.po_header_id = p_po_header_id
2018: AND poll.po_line_id = pol.po_line_id
2019: AND p_po_release_id is NULL
2020: AND p_po_line_id is null

Line 2031: FROM po_line_locations poll, po_lines pol

2027: AND poll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')
2028: UNION ALL
2029: SELECT poll.receiving_routing_id
2030: -- p_po_release_id is null and p_po_line_id is not null
2031: FROM po_line_locations poll, po_lines pol
2032: WHERE poll.po_header_id = p_po_header_id
2033: AND poll.po_line_id = pol.po_line_id
2034: AND p_po_release_id is NULL
2035: AND (p_po_line_id is not null AND poll.po_line_id = p_po_line_id)

Line 2046: FROM po_line_locations poll, po_lines pol

2042: AND poll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')
2043: UNION ALL
2044: SELECT poll.receiving_routing_id
2045: -- p_po_release_id is not null
2046: FROM po_line_locations poll, po_lines pol
2047: WHERE poll.po_header_id = p_po_header_id
2048: AND poll.po_line_id = pol.po_line_id
2049: AND (p_po_release_id is NOT NULL AND poll.po_release_id = p_po_release_id)
2050: AND (p_po_line_id is null or poll.po_line_id = p_po_line_id)

Line 2060: FROM po_line_locations poll, po_lines pol

2056: /*Fix for bug #4755862*/
2057: AND poll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED');
2058: /*
2059: SELECT poll.receiving_routing_id
2060: FROM po_line_locations poll, po_lines pol
2061: WHERE poll.po_header_id = p_po_header_id
2062: AND NVL(poll.po_release_id, -1) = NVL(p_po_release_id, NVL(poll.po_release_id, -1))
2063: AND NVL(poll.po_line_id, -1) = NVL(p_po_line_id, NVL(poll.po_line_id, -1))
2064: --AND pol.item_id = p_item_id

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

4000: l_progress := '20';
4001: BEGIN
4002: SELECT mum.uom_code, mum.uom_class
4003: INTO x_uom_code, l_class
4004: FROM po_lines pol, mtl_units_of_measure mum
4005: WHERE pol.po_header_id = p_po_header_id
4006: AND pol.unit_meas_lookup_code IS NOT NULL
4007: AND pol.line_num = p_line_no
4008: AND pol.unit_meas_lookup_code = mum.unit_of_measure

Line 4010: FROM po_line_locations_all poll, po_lines_all po

4006: AND pol.unit_meas_lookup_code IS NOT NULL
4007: AND pol.line_num = p_line_no
4008: AND pol.unit_meas_lookup_code = mum.unit_of_measure
4009: AND pol.po_line_id IN (SELECT poll.po_line_id
4010: FROM po_line_locations_all poll, po_lines_all po
4011: WHERE poll.po_header_id = po.po_header_id
4012: AND Nvl(poll.approved_flag,'N') = 'Y'
4013: AND Nvl(poll.cancel_flag,'N') = 'N'
4014: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING')

Line 4041: FROM po_lines pol, mtl_units_of_measure mum

4037: l_progress := '30';
4038: BEGIN
4039: SELECT mum.uom_code, mum.uom_class
4040: INTO x_uom_code, l_class
4041: FROM po_lines pol, mtl_units_of_measure mum
4042: WHERE pol.po_header_id = p_po_header_id
4043: AND pol.unit_meas_lookup_code IS NOT NULL
4044: AND pol.unit_meas_lookup_code = mum.unit_of_measure
4045: AND pol.item_description = p_item_desc

Line 4047: FROM po_line_locations_all poll, po_lines_all po

4043: AND pol.unit_meas_lookup_code IS NOT NULL
4044: AND pol.unit_meas_lookup_code = mum.unit_of_measure
4045: AND pol.item_description = p_item_desc
4046: AND pol.po_line_id IN (SELECT poll.po_line_id
4047: FROM po_line_locations_all poll, po_lines_all po
4048: WHERE poll.po_header_id = po.po_header_id
4049: AND Nvl(poll.approved_flag,'N') = 'Y'
4050: AND Nvl(poll.cancel_flag,'N') = 'N'
4051: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING')

Line 4080: FROM po_lines pol

4076: l_progress := '20';
4077: BEGIN
4078: SELECT COUNT(DISTINCT pol.unit_meas_lookup_code)
4079: INTO l_count
4080: FROM po_lines pol
4081: WHERE pol.po_header_id = p_po_header_id
4082: AND pol.unit_meas_lookup_code IS NOT NULL
4083: AND pol.item_id = p_item_id
4084: AND pol.po_line_id IN (SELECT poll.po_line_id

Line 4085: FROM po_line_locations_all poll, po_lines_all po

4081: WHERE pol.po_header_id = p_po_header_id
4082: AND pol.unit_meas_lookup_code IS NOT NULL
4083: AND pol.item_id = p_item_id
4084: AND pol.po_line_id IN (SELECT poll.po_line_id
4085: FROM po_line_locations_all poll, po_lines_all po
4086: WHERE poll.po_header_id = po.po_header_id
4087: AND Nvl(poll.approved_flag,'N') = 'Y'
4088: AND Nvl(poll.cancel_flag,'N') = 'N'
4089: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING')

Line 4107: FROM po_lines pol

4103: SELECT inv_ui_item_lovs.get_conversion_rate(mum.uom_code,
4104: p_organization_id,
4105: pol.item_id)
4106: INTO x_uom_code
4107: FROM po_lines pol
4108: , mtl_units_of_measure mum
4109: WHERE pol.po_header_id = p_po_header_id
4110: AND pol.unit_meas_lookup_code IS NOT NULL
4111: AND pol.item_id = p_item_id

Line 4114: FROM po_line_locations_all poll, po_lines_all po

4110: AND pol.unit_meas_lookup_code IS NOT NULL
4111: AND pol.item_id = p_item_id
4112: AND mum.UNIT_OF_MEASURE(+) = pol.UNIT_MEAS_LOOKUP_CODE
4113: AND pol.po_line_id IN (SELECT poll.po_line_id
4114: FROM po_line_locations_all poll, po_lines_all po
4115: WHERE poll.po_header_id = po.po_header_id
4116: AND Nvl(poll.approved_flag,'N') = 'Y'
4117: AND Nvl(poll.cancel_flag,'N') = 'N'
4118: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING')

Line 4357: FROM po_lines pol

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
4356: AND pod.po_line_id IN(SELECT pol.po_line_id
4357: FROM po_lines pol
4358: WHERE pol.item_id = p_item_id);
4359: EXCEPTION
4360: WHEN NO_DATA_FOUND THEN
4361: l_count := 0;

Line 4373: FROM po_lines pol

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
4372: AND pod.po_line_id IN(SELECT pol.po_line_id
4373: FROM po_lines pol
4374: WHERE pol.item_id = p_item_id)
4375: AND ROWNUM = 1;
4376: EXCEPTION
4377: WHEN OTHERS THEN

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 4714: FROM hr_locations hl, po_line_locations poll,po_lines pol

4710: -- bug 864331
4711: /* bug 14305407 modified the query to improve the performance */
4712: SELECT distinct( hl.location_code )
4713: INTO x_location_code
4714: FROM hr_locations hl, po_line_locations poll,po_lines pol
4715: WHERE hl.location_id = poll.ship_to_location_id
4716: AND poll.po_header_id = pol.po_header_id
4717: AND poll.po_line_id = pol.po_line_id
4718: AND poll.po_header_id = p_po_header_id

Line 4840: FROM po_line_locations poll,po_lines pol

4836: END IF;
4837:
4838: SELECT DISTINCT (pol.item_revision)
4839: INTO x_revision_code
4840: FROM po_line_locations poll,po_lines pol
4841: WHERE pol.po_header_id = p_po_header_id
4842: AND NVL(poll.po_line_id,-1) = NVL(p_po_line_id, NVL(poll.po_line_id, -1))
4843: AND NVL(pol.item_id,-1) = NVL(p_item_id,NVL(pol.item_id, -1))
4844: AND poll.ship_to_organization_id= p_organization_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 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 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