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_UI_RCV_LOVS dependencies on STANDARD

Line 189: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')

185: WHERE poh.po_header_id = poll.po_header_id
186: AND Nvl(poll.approved_flag,'N') = 'Y'
187: AND Nvl(poll.cancel_flag,'N') = 'N'
188: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
189: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
190: AND poll.ship_to_organization_id = p_organization_id
191: -- For Bug 7440217 Checking if it is LCM enabled
192: AND mp.organization_id = p_organization_id
193: AND rp.organization_id = p_organization_id

Line 201: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')

197: )
198: -- End for Bug 7440217
199: )
200: AND poh.segment1 LIKE (p_po_number||l_append)
201: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')
202: AND NVL(POH.CANCEL_FLAG, 'N') IN ('N', 'I')
203: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
204: ORDER BY decode(rtrim(poh.segment1,'0123456789'),null,null,poh.segment1),
205: decode(rtrim(poh.segment1,'0123456789'),null,to_number(poh.segment1),null);--

Line 232: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')

228: -- End for Bug 7440217
229: WHERE poh.po_header_id = poll.po_header_id
230: AND Nvl(poll.approved_flag,'N') = 'Y'
231: AND Nvl(poll.cancel_flag,'N') = 'N'
232: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
233: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
234: AND poll.ship_to_organization_id = p_organization_id
235: -- For Bug 7440217 Checking if it is LCM enabled
236: AND mp.organization_id = p_organization_id

Line 246: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')

242: -- End for Bug 7440217
243: )
244: AND poh.segment1 LIKE (p_po_number||l_append)
245: AND poh.po_header_id = rsl.po_header_id
246: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')
247: AND NVL(POH.CANCEL_FLAG, 'N') IN ('N', 'I')
248: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
249: AND rsl.shipment_header_id = Nvl(To_number(p_shipment_header_id), rsl.shipment_header_id)
250: ORDER BY Decode(rtrim(poh.segment1,'0123456789'),null,null,poh.segment1),

Line 360: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')

356: WHERE pr.po_header_id = poll.po_header_id
357: AND pr.po_release_id = poll.po_release_id
358: AND Nvl(poll.approved_flag,'N') = 'Y'
359: AND Nvl(poll.cancel_flag,'N') = 'N'
360: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
361: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')
362: AND poll.ship_to_organization_id = p_organization_id
363: -- For Bug 7440217 Checking if it is LCM enabled
364: AND mp.organization_id = p_organization_id

Line 459: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')

455: AND Nvl(poll.approved_flag,'N') = 'Y'
456: AND Nvl(poll.cancel_flag,'N') = 'N'
457: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
458: --AND poll.closed_code = 'OPEN'
459: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
460: AND poll.ship_to_organization_id = p_organization_id
461: -- For Bug 7440217 Checking if it is LCM enabled
462: AND mp.organization_id = p_organization_id
463: AND rp.organization_id = p_organization_id

Line 1557: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')

1553: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
1554: AND nvl(flv.end_date_active,sysdate) >= SYSDATE
1555: AND flv.enabled_flag = 'Y'
1556: -- Bug 2859355 Added the Extra conditions for poh.
1557: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')
1558: AND NVL(POH.CANCEL_FLAG, 'N') IN ('N', 'I')
1559: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
1560: AND poh.segment1 LIKE (p_doc_number||l_append)
1561: AND EXISTS

Line 1580: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')

1576: AND poll.approved_flag = 'Y'
1577: AND Nvl(poll.cancel_flag,'N') = 'N'
1578: -- AND poll.closed_code = 'OPEN' -- Bug 2859335
1579: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
1580: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
1581: AND poll.ship_to_organization_id = p_organization_id
1582: AND poll.payment_type IS NULL --R12 excludes all Complex Work POs (Bug4236155)
1583: -- For Bug 7440217 Checking if it is LCM enabled
1584: AND mp.organization_id = p_organization_id

Line 1621: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')

1617: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
1618: AND nvl(flv.end_date_active,sysdate) >= SYSDATE
1619: AND flv.enabled_flag = 'Y'
1620: -- Bug 2859355 Added the Extra conditions for poh.
1621: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')
1622: AND NVL(POH.CANCEL_FLAG, 'N') IN ('N', 'I')
1623: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
1624: AND poh.segment1 LIKE (p_doc_number||l_append)
1625: AND EXISTS

Line 1661: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')

1657: AND poll.approved_flag = 'Y'
1658: AND Nvl(poll.cancel_flag,'N') = 'N'
1659: -- AND poll.closed_code = 'OPEN' -- Bug 2859355
1660: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
1661: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
1662: AND poll.ship_to_organization_id = p_organization_id
1663: AND poll.payment_type IS NULL --R12 excludes all Complex Work POs (Bug4236155)
1664: -- For Bug 7440217 Checking if it is LCM enabled
1665: AND mp.organization_id = p_organization_id

Line 1717: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')

1713: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
1714: AND nvl(flv.end_date_active,sysdate) >= SYSDATE
1715: AND flv.enabled_flag = 'Y'
1716: -- Bug 2859355 Added the Extra conditions for poh.
1717: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')
1718: AND NVL(POH.CANCEL_FLAG, 'N') IN ('N', 'I')
1719: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
1720: AND poh.segment1 LIKE (p_doc_number||l_append)
1721: AND pl.item_id = p_inventory_item_id

Line 1730: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')

1726: AND poll.approved_flag = 'Y'
1727: AND Nvl(poll.cancel_flag,'N') = 'N'
1728: -- AND poll.closed_code = 'OPEN' -- Bug 2859335
1729: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
1730: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
1731: AND poll.ship_to_organization_id = p_organization_id
1732: AND poll.payment_type IS NULL --R12 excludes all Complex Work POs (Bug4236155)
1733: -- For Bug 7440217 Checking if it is LCM enabled
1734: AND mp.organization_id = p_organization_id

Line 1778: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')

1774: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
1775: AND nvl(flv.end_date_active,sysdate) >= SYSDATE
1776: AND flv.enabled_flag = 'Y'
1777: -- Bug 2859355 Added the Extra conditions for poh.
1778: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')
1779: AND NVL(POH.CANCEL_FLAG, 'N') IN ('N', 'I')
1780: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
1781: AND poh.segment1 LIKE (p_doc_number||l_append)
1782: AND msi.organization_id = p_organization_id

Line 1794: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')

1790: AND poll.approved_flag = 'Y'
1791: AND Nvl(poll.cancel_flag,'N') = 'N'
1792: -- AND poll.closed_code = 'OPEN' -- Bug 2859355
1793: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
1794: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
1795: AND poll.ship_to_organization_id = p_organization_id
1796: AND poll.payment_type IS NULL --R12 excludes all Complex Work POs (Bug4236155)
1797: -- For Bug 7440217 Checking if it is LCM enabled
1798: AND mp.organization_id = p_organization_id

Line 1841: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')

1837: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
1838: AND nvl(flv.end_date_active,sysdate) >= SYSDATE
1839: AND flv.enabled_flag = 'Y'
1840: -- Bug 2859355 Added the Extra conditions for poh.
1841: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')
1842: AND NVL(POH.CANCEL_FLAG, 'N') IN ('N', 'I')
1843: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
1844: AND poh.segment1 LIKE (p_doc_number||l_append)
1845: AND msi.organization_id = p_organization_id

Line 1858: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')

1854: AND poll.approved_flag = 'Y'
1855: AND Nvl(poll.cancel_flag,'N') = 'N'
1856: -- AND poll.closed_code = 'OPEN' -- Bug 2859355
1857: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
1858: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
1859: AND poll.ship_to_organization_id = p_organization_id
1860: AND poll.payment_type IS NULL --R12 excludes all Complex Work POs (Bug4236155)
1861: -- For Bug 7440217 Checking if it is LCM enabled
1862: AND mp.organization_id = p_organization_id

Line 1901: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')

1897: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
1898: AND nvl(flv.end_date_active,sysdate) >= SYSDATE
1899: AND flv.enabled_flag = 'Y'
1900: -- Bug 2859355 Added the Extra conditions for poh.
1901: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')
1902: AND NVL(POH.CANCEL_FLAG, 'N') IN ('N', 'I')
1903: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
1904: AND poh.segment1 LIKE (p_doc_number||l_append)
1905: AND EXISTS

Line 1925: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')

1921: AND poll.approved_flag = 'Y'
1922: AND Nvl(poll.cancel_flag,'N') = 'N'
1923: -- AND poll.closed_code = 'OPEN' --Bug 2859355
1924: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
1925: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
1926: AND poll.ship_to_organization_id = p_organization_id
1927: AND poll.payment_type IS NULL --R12 excludes all Complex Work POs (Bug4236155)
1928: -- For Bug 7440217 Checking if it is LCM enabled
1929: AND mp.organization_id = p_organization_id

Line 1969: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')

1965: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
1966: AND nvl(flv.end_date_active,sysdate) >= SYSDATE
1967: AND flv.enabled_flag = 'Y'
1968: -- Bug 2859355 Added the Extra conditions for poh.
1969: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')
1970: AND NVL(POH.CANCEL_FLAG, 'N') IN ('N', 'I')
1971: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
1972: AND poh.segment1 LIKE (p_doc_number||l_append)
1973: AND EXISTS

Line 1987: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')

1983: AND poll.approved_flag = 'Y'
1984: AND Nvl(poll.cancel_flag,'N') = 'N'
1985: -- AND poll.closed_code = 'OPEN' --Bug 2859355
1986: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
1987: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
1988: AND poll.ship_to_organization_id = p_organization_id
1989: AND poll.payment_type IS NULL --R12 excludes all Complex Work POs (Bug4236155)
1990: -- For Bug 7440217 Checking if it is LCM enabled
1991: AND mp.organization_id = p_organization_id

Line 2457: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')

2453: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2454: AND nvl(flv.end_date_active,sysdate) >= SYSDATE
2455: AND flv.enabled_flag = 'Y'
2456: -- Bug 2859355 Added the Extra conditions for poh.
2457: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')
2458: AND NVL(POH.CANCEL_FLAG, 'N') IN ('N', 'I')
2459: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
2460: AND poh.segment1 LIKE (p_doc_number||l_append)
2461: AND EXISTS

Line 2480: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')

2476: AND poll.approved_flag = 'Y'
2477: AND Nvl(poll.cancel_flag,'N') = 'N'
2478: -- AND poll.closed_code = 'OPEN' -- Bug 2859335
2479: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
2480: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
2481: AND poll.ship_to_organization_id = p_organization_id
2482: AND poll.payment_type IS NULL --R12 excludes all Complex Work POs (Bug4236155)
2483: -- For Bug 7440217 Checking if it is LCM enabled
2484: AND mp.organization_id = p_organization_id

Line 2522: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')

2518: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2519: AND nvl(flv.end_date_active,sysdate) >= SYSDATE
2520: AND flv.enabled_flag = 'Y'
2521: -- Bug 2859355 Added the Extra conditions for poh.
2522: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')
2523: AND NVL(POH.CANCEL_FLAG, 'N') IN ('N', 'I')
2524: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
2525: AND poh.segment1 LIKE (p_doc_number||l_append)
2526: AND EXISTS

Line 2562: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')

2558: AND poll.approved_flag = 'Y'
2559: AND Nvl(poll.cancel_flag,'N') = 'N'
2560: -- AND poll.closed_code = 'OPEN' -- Bug 2859355
2561: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
2562: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
2563: AND poll.ship_to_organization_id = p_organization_id
2564: AND poll.payment_type IS NULL --R12 excludes all Complex Work POs (Bug4236155)
2565: -- For Bug 7440217 Checking if it is LCM enabled
2566: AND mp.organization_id = p_organization_id

Line 2604: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')

2600: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2601: AND nvl(flv.end_date_active,sysdate) >= SYSDATE
2602: AND flv.enabled_flag = 'Y'
2603: -- Bug 2859355 Added the Extra conditions for poh.
2604: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')
2605: AND NVL(POH.CANCEL_FLAG, 'N') IN ('N', 'I')
2606: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
2607: AND poh.segment1 LIKE (p_doc_number||l_append)
2608: AND EXISTS

Line 2628: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')

2624: AND Nvl(poll.approved_flag,'N') = 'Y'
2625: AND Nvl(poll.cancel_flag,'N') = 'N'
2626: -- AND poll.closed_code = 'OPEN' --Bug 2859355
2627: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
2628: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
2629: AND poll.ship_to_organization_id = p_organization_id
2630: AND poll.payment_type IS NULL --R12 excludes all Complex Work POs (Bug4236155)
2631: -- For Bug 7440217 Checking if it is LCM enabled
2632: AND mp.organization_id = p_organization_id

Line 2996: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')

2992: AND Nvl(poll.approved_flag,'N') = 'Y'
2993: AND Nvl(poll.cancel_flag,'N') = 'N'
2994: -- AND poll.closed_code = 'OPEN' -- Bug 2859355
2995: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
2996: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
2997: AND poll.ship_to_organization_id = p_organization_id
2998: -- For Bug 7440217 Checking if it is LCM enabled
2999: AND mp.organization_id = p_organization_id
3000: AND rp.organization_id = p_organization_id

Line 3042: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')

3038: AND Nvl(poll.approved_flag,'N') = 'Y'
3039: AND Nvl(poll.cancel_flag,'N') = 'N'
3040: -- AND poll.closed_code = 'OPEN' --Bug 2859355
3041: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
3042: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
3043: AND poll.ship_to_organization_id = p_organization_id
3044: -- For Bug 7440217 Checking if it is LCM enabled
3045: AND mp.organization_id = p_organization_id
3046: AND rp.organization_id = p_organization_id