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.WMS_LPN_LOVS dependencies on INV_MATERIAL_STATUS_GRP

Line 1387: AND inv_material_status_grp.is_status_applicable(

1383: --AND wlpn.locator_id = mil.inventory_location_id
1384: --AND NVL(mil.project_id, -1) = NVL(p_project_id, -1)
1385: --AND NVL(mil.task_id, -1) = NVL(p_task_id, -1)
1386: AND NOT wlpn.lpn_id = NVL(TO_NUMBER(p_orig_lpn_id), -999)
1387: AND inv_material_status_grp.is_status_applicable(
1388: 'TRUE',
1389: NULL,
1390: INV_GLOBALS.G_TYPE_CONTAINER_PACK,
1391: NULL,

Line 1401: AND inv_material_status_grp.is_status_applicable(

1397: NULL,
1398: NULL,
1399: 'Z'
1400: ) = 'Y'
1401: AND inv_material_status_grp.is_status_applicable(
1402: 'TRUE',
1403: NULL,
1404: INV_GLOBALS.G_TYPE_CONTAINER_PACK,
1405: NULL,

Line 1508: AND inv_material_status_grp.is_status_applicable

1504: AND wlpn.lpn_context = 1
1505: AND NVL(wlpn.subinventory_code, '@') = NVL(p_sub, NVL(wlpn.subinventory_code, '@'))
1506: AND NVL(wlpn.locator_id, '0') = NVL(TO_NUMBER(p_loc_id), NVL(wlpn.locator_id, '0'))
1507: AND ( ( p_mtrl_sts_check = 'Y' -- Bug 3980914
1508: AND inv_material_status_grp.is_status_applicable
1509: ('TRUE', NULL, p_txn_type_id, NULL,
1510: NULL, p_org_id, NULL, wlpn.subinventory_code,
1511: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
1512: AND inv_material_status_grp.is_status_applicable

Line 1512: AND inv_material_status_grp.is_status_applicable

1508: AND inv_material_status_grp.is_status_applicable
1509: ('TRUE', NULL, p_txn_type_id, NULL,
1510: NULL, p_org_id, NULL, wlpn.subinventory_code,
1511: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
1512: AND inv_material_status_grp.is_status_applicable
1513: ('TRUE', NULL, p_txn_type_id, NULL,
1514: NULL, p_org_id, NULL, wlpn.subinventory_code,
1515: wlpn.locator_id, NULL, NULL, 'L') = 'Y'
1516: )

Line 1553: AND inv_material_status_grp.is_status_applicable

1549: AND wlpn.lpn_context = 1
1550: AND NVL(wlpn.subinventory_code, '@') = NVL(p_sub, NVL(wlpn.subinventory_code, '@'))
1551: AND NVL(wlpn.locator_id, '0') = NVL(TO_NUMBER(p_loc_id), NVL(wlpn.locator_id, '0'))
1552: AND ( ( p_mtrl_sts_check = 'Y' -- Bug 3980914
1553: AND inv_material_status_grp.is_status_applicable
1554: ('TRUE', NULL, p_txn_type_id, NULL,
1555: NULL, p_org_id, NULL, wlpn.subinventory_code,
1556: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
1557: AND inv_material_status_grp.is_status_applicable

Line 1557: AND inv_material_status_grp.is_status_applicable

1553: AND inv_material_status_grp.is_status_applicable
1554: ('TRUE', NULL, p_txn_type_id, NULL,
1555: NULL, p_org_id, NULL, wlpn.subinventory_code,
1556: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
1557: AND inv_material_status_grp.is_status_applicable
1558: ('TRUE', NULL, p_txn_type_id, NULL,
1559: NULL, p_org_id, NULL, wlpn.subinventory_code,
1560: wlpn.locator_id, NULL, NULL, 'L') = 'Y'
1561: )

Line 1668: AND inv_material_status_grp.is_status_applicable

1664: (p_task_id IS NULL
1665: AND (Nvl(p_calling,-1)='SHIP_UNPACK' OR NVL(mil.SEGMENT20,-1) = -1)) -- Bug 7210544
1666: )
1667: AND (( p_mtrl_sts_check = 'Y' --Bug 3980914
1668: AND inv_material_status_grp.is_status_applicable
1669: ('TRUE', NULL, p_txn_type_id, NULL,
1670: NULL, p_org_id, NULL, wlpn.subinventory_code,
1671: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
1672: AND inv_material_status_grp.is_status_applicable

Line 1672: AND inv_material_status_grp.is_status_applicable

1668: AND inv_material_status_grp.is_status_applicable
1669: ('TRUE', NULL, p_txn_type_id, NULL,
1670: NULL, p_org_id, NULL, wlpn.subinventory_code,
1671: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
1672: AND inv_material_status_grp.is_status_applicable
1673: ('TRUE', NULL, p_txn_type_id, NULL,
1674: NULL, p_org_id, NULL, wlpn.subinventory_code,
1675: wlpn.locator_id, NULL, NULL, 'L') = 'Y'
1676: )

Line 1733: AND inv_material_status_grp.is_status_applicable

1729: (p_task_id IS NULL
1730: AND (Nvl(p_calling,-1)='SHIP_UNPACK' OR NVL(mil.SEGMENT20,-1) = -1)) -- Bug 7210544
1731: )
1732: AND ( ( p_mtrl_sts_check = 'Y' --Bug 3980914
1733: AND inv_material_status_grp.is_status_applicable
1734: ('TRUE', NULL, p_txn_type_id, NULL,
1735: NULL, p_org_id, NULL, wlpn.subinventory_code,
1736: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
1737: AND inv_material_status_grp.is_status_applicable

Line 1737: AND inv_material_status_grp.is_status_applicable

1733: AND inv_material_status_grp.is_status_applicable
1734: ('TRUE', NULL, p_txn_type_id, NULL,
1735: NULL, p_org_id, NULL, wlpn.subinventory_code,
1736: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
1737: AND inv_material_status_grp.is_status_applicable
1738: ('TRUE', NULL, p_txn_type_id, NULL,
1739: NULL, p_org_id, NULL, wlpn.subinventory_code,
1740: wlpn.locator_id, NULL, NULL, 'L') = 'Y'
1741: )

Line 1954: AND inv_material_status_grp.is_status_applicable

1950: AND wlpn.lpn_context = 1
1951: AND NVL(wlpn.subinventory_code, '@') = NVL(p_sub, NVL(subinventory_code, '@'))
1952: AND NVL(wlpn.locator_id, '0') = NVL(TO_NUMBER(p_loc_id), NVL(wlpn.locator_id, '0'))
1953: AND (( p_mtrl_sts_check = 'Y' --Bug 3980914
1954: AND inv_material_status_grp.is_status_applicable
1955: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,
1956: NULL, p_org_id, NULL, wlpn.subinventory_code,
1957: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
1958: AND inv_material_status_grp.is_status_applicable

Line 1958: AND inv_material_status_grp.is_status_applicable

1954: AND inv_material_status_grp.is_status_applicable
1955: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,
1956: NULL, p_org_id, NULL, wlpn.subinventory_code,
1957: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
1958: AND inv_material_status_grp.is_status_applicable
1959: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,
1960: NULL, p_org_id, NULL, wlpn.subinventory_code,
1961: wlpn.locator_id, NULL, NULL, 'L') = 'Y'
1962: AND inv_material_status_grp.is_status_applicable

Line 1962: AND inv_material_status_grp.is_status_applicable

1958: AND inv_material_status_grp.is_status_applicable
1959: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,
1960: NULL, p_org_id, NULL, wlpn.subinventory_code,
1961: wlpn.locator_id, NULL, NULL, 'L') = 'Y'
1962: AND inv_material_status_grp.is_status_applicable
1963: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,
1964: NULL, NULL, p_org_id, NULL, wlpn.subinventory_code,
1965: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
1966: AND inv_material_status_grp.is_status_applicable

Line 1966: AND inv_material_status_grp.is_status_applicable

1962: AND inv_material_status_grp.is_status_applicable
1963: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,
1964: NULL, NULL, p_org_id, NULL, wlpn.subinventory_code,
1965: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
1966: AND inv_material_status_grp.is_status_applicable
1967: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,
1968: NULL, NULL, p_org_id, NULL, wlpn.subinventory_code,
1969: wlpn.locator_id, NULL, NULL, 'L') = 'Y'
1970: )

Line 2007: AND inv_material_status_grp.is_status_applicable

2003: AND wlpn.lpn_context = 1
2004: AND NVL(wlpn.subinventory_code, '@') = NVL(p_sub, NVL(subinventory_code, '@'))
2005: AND NVL(wlpn.locator_id, '0') = NVL(TO_NUMBER(p_loc_id), NVL(wlpn.locator_id, '0'))
2006: AND ( ( p_mtrl_sts_check = 'Y' --Bug 3980914
2007: AND inv_material_status_grp.is_status_applicable
2008: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,
2009: NULL, p_org_id, NULL, wlpn.subinventory_code,
2010: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
2011: AND inv_material_status_grp.is_status_applicable

Line 2011: AND inv_material_status_grp.is_status_applicable

2007: AND inv_material_status_grp.is_status_applicable
2008: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,
2009: NULL, p_org_id, NULL, wlpn.subinventory_code,
2010: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
2011: AND inv_material_status_grp.is_status_applicable
2012: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,
2013: NULL, p_org_id, NULL, wlpn.subinventory_code,
2014: wlpn.locator_id, NULL, NULL, 'L') = 'Y'
2015: AND inv_material_status_grp.is_status_applicable

Line 2015: AND inv_material_status_grp.is_status_applicable

2011: AND inv_material_status_grp.is_status_applicable
2012: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,
2013: NULL, p_org_id, NULL, wlpn.subinventory_code,
2014: wlpn.locator_id, NULL, NULL, 'L') = 'Y'
2015: AND inv_material_status_grp.is_status_applicable
2016: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,
2017: NULL, NULL, p_org_id, NULL, wlpn.subinventory_code,
2018: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
2019: AND inv_material_status_grp.is_status_applicable

Line 2019: AND inv_material_status_grp.is_status_applicable

2015: AND inv_material_status_grp.is_status_applicable
2016: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,
2017: NULL, NULL, p_org_id, NULL, wlpn.subinventory_code,
2018: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
2019: AND inv_material_status_grp.is_status_applicable
2020: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,
2021: NULL, NULL, p_org_id, NULL, wlpn.subinventory_code,
2022: wlpn.locator_id, NULL, NULL, 'L') = 'Y'
2023: )

Line 2112: AND inv_material_status_grp.is_status_applicable

2108: AND mil.inventory_location_id = wlpn.locator_id
2109: AND NVL(mil.SEGMENT19, -1) = NVL(p_project_id, NVL(mil.SEGMENT19, -1))
2110: AND NVL(mil.SEGMENT20, -1) = NVL(p_task_id, NVL(mil.SEGMENT20, -1))
2111: AND ( ( p_mtrl_sts_check = 'Y' --Bug 3980914
2112: AND inv_material_status_grp.is_status_applicable
2113: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,
2114: NULL, p_org_id, NULL, wlpn.subinventory_code,
2115: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
2116: AND inv_material_status_grp.is_status_applicable

Line 2116: AND inv_material_status_grp.is_status_applicable

2112: AND inv_material_status_grp.is_status_applicable
2113: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,
2114: NULL, p_org_id, NULL, wlpn.subinventory_code,
2115: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
2116: AND inv_material_status_grp.is_status_applicable
2117: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,
2118: NULL, p_org_id, NULL, wlpn.subinventory_code,
2119: wlpn.locator_id, NULL, NULL, 'L') = 'Y'
2120: AND inv_material_status_grp.is_status_applicable

Line 2120: AND inv_material_status_grp.is_status_applicable

2116: AND inv_material_status_grp.is_status_applicable
2117: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,
2118: NULL, p_org_id, NULL, wlpn.subinventory_code,
2119: wlpn.locator_id, NULL, NULL, 'L') = 'Y'
2120: AND inv_material_status_grp.is_status_applicable
2121: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,
2122: NULL, NULL, p_org_id, NULL, wlpn.subinventory_code,
2123: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
2124: AND inv_material_status_grp.is_status_applicable

Line 2124: AND inv_material_status_grp.is_status_applicable

2120: AND inv_material_status_grp.is_status_applicable
2121: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,
2122: NULL, NULL, p_org_id, NULL, wlpn.subinventory_code,
2123: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
2124: AND inv_material_status_grp.is_status_applicable
2125: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,
2126: NULL, NULL, p_org_id, NULL, wlpn.subinventory_code,
2127: wlpn.locator_id, NULL, NULL, 'L') = 'Y'
2128: )

Line 2169: AND inv_material_status_grp.is_status_applicable

2165: AND mil.inventory_location_id = wlpn.locator_id
2166: AND NVL(mil.SEGMENT19, -1) = NVL(p_project_id, NVL(mil.SEGMENT19, -1))
2167: ANd NVL(mil.SEGMENT20, -1) = NVL(p_task_id, NVL(mil.SEGMENT20, -1))
2168: AND ( ( p_mtrl_sts_check = 'Y' --Bug 3980914
2169: AND inv_material_status_grp.is_status_applicable
2170: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,
2171: NULL, p_org_id, NULL, wlpn.subinventory_code,
2172: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
2173: AND inv_material_status_grp.is_status_applicable

Line 2173: AND inv_material_status_grp.is_status_applicable

2169: AND inv_material_status_grp.is_status_applicable
2170: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,
2171: NULL, p_org_id, NULL, wlpn.subinventory_code,
2172: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
2173: AND inv_material_status_grp.is_status_applicable
2174: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,
2175: NULL, p_org_id, NULL, wlpn.subinventory_code,
2176: wlpn.locator_id, NULL, NULL, 'L') = 'Y'
2177: AND inv_material_status_grp.is_status_applicable

Line 2177: AND inv_material_status_grp.is_status_applicable

2173: AND inv_material_status_grp.is_status_applicable
2174: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,
2175: NULL, p_org_id, NULL, wlpn.subinventory_code,
2176: wlpn.locator_id, NULL, NULL, 'L') = 'Y'
2177: AND inv_material_status_grp.is_status_applicable
2178: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,
2179: NULL, NULL, p_org_id, NULL, wlpn.subinventory_code,
2180: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
2181: AND inv_material_status_grp.is_status_applicable

Line 2181: AND inv_material_status_grp.is_status_applicable

2177: AND inv_material_status_grp.is_status_applicable
2178: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,
2179: NULL, NULL, p_org_id, NULL, wlpn.subinventory_code,
2180: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
2181: AND inv_material_status_grp.is_status_applicable
2182: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,
2183: NULL, NULL, p_org_id, NULL, wlpn.subinventory_code,
2184: wlpn.locator_id, NULL, NULL, 'L') = 'Y'
2185: )

Line 3253: AND inv_material_status_grp.is_status_applicable

3249: and wlpn.locator_id = mil.inventory_location_id
3250: and nvl(task_id,-9999) = nvl(p_task_id,-9999)
3251: )
3252: and wlpn.lpn_context = 1
3253: AND inv_material_status_grp.is_status_applicable
3254: ('TRUE',
3255: NULL,
3256: INV_GLOBALS.G_TYPE_CONTAINER_PACK,
3257: NULL,

Line 3266: AND inv_material_status_grp.is_status_applicable

3262: wlpn.locator_id,
3263: NULL,
3264: NULL,
3265: 'Z') = 'Y'
3266: AND inv_material_status_grp.is_status_applicable
3267: ('TRUE',
3268: NULL,
3269: INV_GLOBALS.G_TYPE_CONTAINER_PACK,
3270: NULL,

Line 3358: AND inv_material_status_grp.is_status_applicable

3354: and mil.project_id is null
3355: and wlpn.locator_id = mil.inventory_location_id
3356: and nvl(task_id,-9999) = nvl(p_task_id,-9999)
3357: )
3358: AND inv_material_status_grp.is_status_applicable
3359: ('TRUE',
3360: NULL,
3361: INV_GLOBALS.G_TYPE_CONTAINER_PACK,
3362: NULL,

Line 3371: AND inv_material_status_grp.is_status_applicable

3367: wlpn.locator_id,
3368: NULL,
3369: NULL,
3370: 'Z') = 'Y'
3371: AND inv_material_status_grp.is_status_applicable
3372: ('TRUE',
3373: NULL,
3374: INV_GLOBALS.G_TYPE_CONTAINER_PACK,
3375: NULL,

Line 4409: AND inv_material_status_grp.is_status_applicable (

4405: WHERE wlpn.organization_id = p_organization_id
4406: AND wlpn.lpn_context = 11
4407: AND wlpn.license_plate_number LIKE (p_lpn_id)
4408: AND wms_lpn_lovs.SUB_LPN_CONTROLLED(wlpn.subinventory_code, p_organization_id) ='Y'
4409: AND inv_material_status_grp.is_status_applicable (
4410: 'TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_SPLIT, NULL,
4411: NULL, p_organization_id, NULL, wlpn.subinventory_code,
4412: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
4413: AND inv_material_status_grp.is_status_applicable (

Line 4413: AND inv_material_status_grp.is_status_applicable (

4409: AND inv_material_status_grp.is_status_applicable (
4410: 'TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_SPLIT, NULL,
4411: NULL, p_organization_id, NULL, wlpn.subinventory_code,
4412: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
4413: AND inv_material_status_grp.is_status_applicable (
4414: 'TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_SPLIT, NULL,
4415: NULL, p_organization_id, NULL, wlpn.subinventory_code,
4416: wlpn.locator_id, NULL, NULL, 'L') = 'Y'
4417: AND wdd.lpn_id = wlpn.lpn_id

Line 4488: AND inv_material_status_grp.is_status_applicable('TRUE',

4484: )
4485: )
4486: )
4487: AND wlpn.license_plate_number LIKE (p_into_lpn)
4488: AND inv_material_status_grp.is_status_applicable('TRUE',
4489: NULL,
4490: INV_GLOBALS.G_TYPE_CONTAINER_PACK,
4491: NULL,
4492: NULL,

Line 4500: AND inv_material_status_grp.is_status_applicable('TRUE',

4496: wlpn.locator_id,
4497: NULL,
4498: NULL,
4499: 'Z') = 'Y'
4500: AND inv_material_status_grp.is_status_applicable('TRUE',
4501: NULL,
4502: INV_GLOBALS.G_TYPE_CONTAINER_PACK,
4503: NULL,
4504: NULL,