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 170: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')

166: WHERE poh.po_header_id = poll.po_header_id
167: AND Nvl(poll.approved_flag,'N') = 'Y'
168: AND Nvl(poll.cancel_flag,'N') = 'N'
169: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
170: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
171: AND poll.ship_to_organization_id = p_organization_id
172: -- For Bug 7440217 Checking if it is LCM enabled
173: AND mp.organization_id = p_organization_id
174: AND rp.organization_id = p_organization_id

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

178: )
179: -- End for Bug 7440217
180: )
181: AND poh.segment1 LIKE (p_po_number)
182: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')
183: AND NVL(POH.CANCEL_FLAG, 'N') IN ('N', 'I')
184: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
185: ORDER BY decode(rtrim(poh.segment1,'0123456789'),null,null,poh.segment1),
186: decode(rtrim(poh.segment1,'0123456789'),null,to_number(poh.segment1),null);--

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

208: -- End for Bug 7440217
209: WHERE poh.po_header_id = poll.po_header_id
210: AND Nvl(poll.approved_flag,'N') = 'Y'
211: AND Nvl(poll.cancel_flag,'N') = 'N'
212: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
213: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
214: AND poll.ship_to_organization_id = p_organization_id
215: -- For Bug 7440217 Checking if it is LCM enabled
216: AND mp.organization_id = p_organization_id

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

222: -- End for Bug 7440217
223: )
224: AND poh.segment1 LIKE (p_po_number)
225: AND poh.po_header_id = rsl.po_header_id
226: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')
227: AND NVL(POH.CANCEL_FLAG, 'N') IN ('N', 'I')
228: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
229: AND rsl.shipment_header_id = Nvl(To_number(p_shipment_header_id), rsl.shipment_header_id)
230: ORDER BY Decode(rtrim(poh.segment1,'0123456789'),null,null,poh.segment1),

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

335: WHERE pr.po_header_id = poll.po_header_id
336: AND pr.po_release_id = poll.po_release_id
337: AND Nvl(poll.approved_flag,'N') = 'Y'
338: AND Nvl(poll.cancel_flag,'N') = 'N'
339: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
340: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')
341: AND poll.ship_to_organization_id = p_organization_id
342: -- For Bug 7440217 Checking if it is LCM enabled
343: AND mp.organization_id = p_organization_id

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

427: AND Nvl(poll.approved_flag,'N') = 'Y'
428: AND Nvl(poll.cancel_flag,'N') = 'N'
429: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
430: --AND poll.closed_code = 'OPEN'
431: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
432: AND poll.ship_to_organization_id = p_organization_id
433: -- For Bug 7440217 Checking if it is LCM enabled
434: AND mp.organization_id = p_organization_id
435: AND rp.organization_id = p_organization_id

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

1518: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
1519: AND nvl(flv.end_date_active,sysdate) >= SYSDATE
1520: AND flv.enabled_flag = 'Y'
1521: -- Bug 2859355 Added the Extra conditions for poh.
1522: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')
1523: AND NVL(POH.CANCEL_FLAG, 'N') IN ('N', 'I')
1524: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
1525: AND poh.segment1 LIKE (p_doc_number)
1526: AND EXISTS

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

1541: AND poll.approved_flag = 'Y'
1542: AND Nvl(poll.cancel_flag,'N') = 'N'
1543: -- AND poll.closed_code = 'OPEN' -- Bug 2859335
1544: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
1545: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
1546: AND poll.ship_to_organization_id = p_organization_id
1547: AND poll.payment_type IS NULL --R12 excludes all Complex Work POs (Bug4236155)
1548: -- For Bug 7440217 Checking if it is LCM enabled
1549: AND mp.organization_id = p_organization_id

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

1581: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
1582: AND nvl(flv.end_date_active,sysdate) >= SYSDATE
1583: AND flv.enabled_flag = 'Y'
1584: -- Bug 2859355 Added the Extra conditions for poh.
1585: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')
1586: AND NVL(POH.CANCEL_FLAG, 'N') IN ('N', 'I')
1587: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
1588: AND poh.segment1 LIKE (p_doc_number)
1589: AND EXISTS

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

1621: AND poll.approved_flag = 'Y'
1622: AND Nvl(poll.cancel_flag,'N') = 'N'
1623: -- AND poll.closed_code = 'OPEN' -- Bug 2859355
1624: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
1625: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
1626: AND poll.ship_to_organization_id = p_organization_id
1627: AND poll.payment_type IS NULL --R12 excludes all Complex Work POs (Bug4236155)
1628: -- For Bug 7440217 Checking if it is LCM enabled
1629: AND mp.organization_id = p_organization_id

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

1676: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
1677: AND nvl(flv.end_date_active,sysdate) >= SYSDATE
1678: AND flv.enabled_flag = 'Y'
1679: -- Bug 2859355 Added the Extra conditions for poh.
1680: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')
1681: AND NVL(POH.CANCEL_FLAG, 'N') IN ('N', 'I')
1682: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
1683: AND poh.segment1 LIKE (p_doc_number)
1684: AND pl.item_id = p_inventory_item_id

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

1689: AND poll.approved_flag = 'Y'
1690: AND Nvl(poll.cancel_flag,'N') = 'N'
1691: -- AND poll.closed_code = 'OPEN' -- Bug 2859335
1692: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
1693: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
1694: AND poll.ship_to_organization_id = p_organization_id
1695: AND poll.payment_type IS NULL --R12 excludes all Complex Work POs (Bug4236155)
1696: -- For Bug 7440217 Checking if it is LCM enabled
1697: AND mp.organization_id = p_organization_id

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

1736: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
1737: AND nvl(flv.end_date_active,sysdate) >= SYSDATE
1738: AND flv.enabled_flag = 'Y'
1739: -- Bug 2859355 Added the Extra conditions for poh.
1740: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')
1741: AND NVL(POH.CANCEL_FLAG, 'N') IN ('N', 'I')
1742: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
1743: AND poh.segment1 LIKE (p_doc_number)
1744: AND msi.organization_id = p_organization_id

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

1752: AND poll.approved_flag = 'Y'
1753: AND Nvl(poll.cancel_flag,'N') = 'N'
1754: -- AND poll.closed_code = 'OPEN' -- Bug 2859355
1755: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
1756: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
1757: AND poll.ship_to_organization_id = p_organization_id
1758: AND poll.payment_type IS NULL --R12 excludes all Complex Work POs (Bug4236155)
1759: -- For Bug 7440217 Checking if it is LCM enabled
1760: AND mp.organization_id = p_organization_id

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

1798: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
1799: AND nvl(flv.end_date_active,sysdate) >= SYSDATE
1800: AND flv.enabled_flag = 'Y'
1801: -- Bug 2859355 Added the Extra conditions for poh.
1802: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')
1803: AND NVL(POH.CANCEL_FLAG, 'N') IN ('N', 'I')
1804: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
1805: AND poh.segment1 LIKE (p_doc_number)
1806: AND msi.organization_id = p_organization_id

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

1815: AND poll.approved_flag = 'Y'
1816: AND Nvl(poll.cancel_flag,'N') = 'N'
1817: -- AND poll.closed_code = 'OPEN' -- Bug 2859355
1818: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
1819: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
1820: AND poll.ship_to_organization_id = p_organization_id
1821: AND poll.payment_type IS NULL --R12 excludes all Complex Work POs (Bug4236155)
1822: -- For Bug 7440217 Checking if it is LCM enabled
1823: AND mp.organization_id = p_organization_id

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

1857: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
1858: AND nvl(flv.end_date_active,sysdate) >= SYSDATE
1859: AND flv.enabled_flag = 'Y'
1860: -- Bug 2859355 Added the Extra conditions for poh.
1861: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')
1862: AND NVL(POH.CANCEL_FLAG, 'N') IN ('N', 'I')
1863: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
1864: AND poh.segment1 LIKE (p_doc_number)
1865: AND EXISTS

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

1881: AND poll.approved_flag = 'Y'
1882: AND Nvl(poll.cancel_flag,'N') = 'N'
1883: -- AND poll.closed_code = 'OPEN' --Bug 2859355
1884: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
1885: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
1886: AND poll.ship_to_organization_id = p_organization_id
1887: AND poll.payment_type IS NULL --R12 excludes all Complex Work POs (Bug4236155)
1888: -- For Bug 7440217 Checking if it is LCM enabled
1889: AND mp.organization_id = p_organization_id

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

1924: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
1925: AND nvl(flv.end_date_active,sysdate) >= SYSDATE
1926: AND flv.enabled_flag = 'Y'
1927: -- Bug 2859355 Added the Extra conditions for poh.
1928: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')
1929: AND NVL(POH.CANCEL_FLAG, 'N') IN ('N', 'I')
1930: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
1931: AND poh.segment1 LIKE (p_doc_number)
1932: AND EXISTS

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

1942: AND poll.approved_flag = 'Y'
1943: AND Nvl(poll.cancel_flag,'N') = 'N'
1944: -- AND poll.closed_code = 'OPEN' --Bug 2859355
1945: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
1946: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
1947: AND poll.ship_to_organization_id = p_organization_id
1948: AND poll.payment_type IS NULL --R12 excludes all Complex Work POs (Bug4236155)
1949: -- For Bug 7440217 Checking if it is LCM enabled
1950: AND mp.organization_id = p_organization_id

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

2402: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2403: AND nvl(flv.end_date_active,sysdate) >= SYSDATE
2404: AND flv.enabled_flag = 'Y'
2405: -- Bug 2859355 Added the Extra conditions for poh.
2406: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')
2407: AND NVL(POH.CANCEL_FLAG, 'N') IN ('N', 'I')
2408: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
2409: AND poh.segment1 LIKE (p_doc_number)
2410: AND EXISTS

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

2425: AND poll.approved_flag = 'Y'
2426: AND Nvl(poll.cancel_flag,'N') = 'N'
2427: -- AND poll.closed_code = 'OPEN' -- Bug 2859335
2428: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
2429: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
2430: AND poll.ship_to_organization_id = p_organization_id
2431: AND poll.payment_type IS NULL --R12 excludes all Complex Work POs (Bug4236155)
2432: -- For Bug 7440217 Checking if it is LCM enabled
2433: AND mp.organization_id = p_organization_id

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

2466: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2467: AND nvl(flv.end_date_active,sysdate) >= SYSDATE
2468: AND flv.enabled_flag = 'Y'
2469: -- Bug 2859355 Added the Extra conditions for poh.
2470: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')
2471: AND NVL(POH.CANCEL_FLAG, 'N') IN ('N', 'I')
2472: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
2473: AND poh.segment1 LIKE (p_doc_number)
2474: AND EXISTS

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

2506: AND poll.approved_flag = 'Y'
2507: AND Nvl(poll.cancel_flag,'N') = 'N'
2508: -- AND poll.closed_code = 'OPEN' -- Bug 2859355
2509: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
2510: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
2511: AND poll.ship_to_organization_id = p_organization_id
2512: AND poll.payment_type IS NULL --R12 excludes all Complex Work POs (Bug4236155)
2513: -- For Bug 7440217 Checking if it is LCM enabled
2514: AND mp.organization_id = p_organization_id

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

2547: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2548: AND nvl(flv.end_date_active,sysdate) >= SYSDATE
2549: AND flv.enabled_flag = 'Y'
2550: -- Bug 2859355 Added the Extra conditions for poh.
2551: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','PLANNED', 'BLANKET','CONTRACT')
2552: AND NVL(POH.CANCEL_FLAG, 'N') IN ('N', 'I')
2553: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
2554: AND poh.segment1 LIKE (p_doc_number)
2555: AND EXISTS

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

2571: AND Nvl(poll.approved_flag,'N') = 'Y'
2572: AND Nvl(poll.cancel_flag,'N') = 'N'
2573: -- AND poll.closed_code = 'OPEN' --Bug 2859355
2574: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
2575: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
2576: AND poll.ship_to_organization_id = p_organization_id
2577: AND poll.payment_type IS NULL --R12 excludes all Complex Work POs (Bug4236155)
2578: -- For Bug 7440217 Checking if it is LCM enabled
2579: AND mp.organization_id = p_organization_id

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

2918: AND Nvl(poll.approved_flag,'N') = 'Y'
2919: AND Nvl(poll.cancel_flag,'N') = 'N'
2920: -- AND poll.closed_code = 'OPEN' -- Bug 2859355
2921: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
2922: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
2923: AND poll.ship_to_organization_id = p_organization_id
2924: -- For Bug 7440217 Checking if it is LCM enabled
2925: AND mp.organization_id = p_organization_id
2926: AND rp.organization_id = p_organization_id

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

2963: AND Nvl(poll.approved_flag,'N') = 'Y'
2964: AND Nvl(poll.cancel_flag,'N') = 'N'
2965: -- AND poll.closed_code = 'OPEN' --Bug 2859355
2966: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
2967: AND poll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED')
2968: AND poll.ship_to_organization_id = p_organization_id
2969: -- For Bug 7440217 Checking if it is LCM enabled
2970: AND mp.organization_id = p_organization_id
2971: AND rp.organization_id = p_organization_id