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 1964: AND inv_material_status_grp.is_status_applicable

1960: AND wlpn.lpn_context = 1
1961: AND NVL(wlpn.subinventory_code, '@') = NVL(p_sub, NVL(subinventory_code, '@'))
1962: AND NVL(wlpn.locator_id, '0') = NVL(TO_NUMBER(p_loc_id), NVL(wlpn.locator_id, '0'))
1963: AND (( p_mtrl_sts_check = 'Y' --Bug 3980914
1964: AND inv_material_status_grp.is_status_applicable
1965: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,
1966: NULL, p_org_id, NULL, wlpn.subinventory_code,
1967: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
1968: AND inv_material_status_grp.is_status_applicable

Line 1968: AND inv_material_status_grp.is_status_applicable

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

Line 1972: AND inv_material_status_grp.is_status_applicable

1968: AND inv_material_status_grp.is_status_applicable
1969: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,
1970: NULL, p_org_id, NULL, wlpn.subinventory_code,
1971: wlpn.locator_id, NULL, NULL, 'L') = 'Y'
1972: AND inv_material_status_grp.is_status_applicable
1973: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,
1974: NULL, NULL, p_org_id, NULL, wlpn.subinventory_code,
1975: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
1976: AND inv_material_status_grp.is_status_applicable

Line 1976: AND inv_material_status_grp.is_status_applicable

1972: AND inv_material_status_grp.is_status_applicable
1973: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,
1974: NULL, NULL, p_org_id, NULL, wlpn.subinventory_code,
1975: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
1976: AND inv_material_status_grp.is_status_applicable
1977: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,
1978: NULL, NULL, p_org_id, NULL, wlpn.subinventory_code,
1979: wlpn.locator_id, NULL, NULL, 'L') = 'Y'
1980: )

Line 2017: AND (( p_mtrl_sts_check = 'Y' AND inv_material_status_grp.is_status_applicable('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_SPLIT,

2013: AND wms_lpn_lovs.sub_lpn_controlled(wlpn.subinventory_code, p_org_id) = 'Y'
2014: AND wlpn.lpn_context = 1
2015: AND NVL(wlpn.subinventory_code, '@') = NVL(p_sub, NVL(subinventory_code, '@'))
2016: AND NVL(wlpn.locator_id, '0') = NVL(TO_NUMBER(p_loc_id), NVL(wlpn.locator_id, '0'))
2017: AND (( p_mtrl_sts_check = 'Y' AND inv_material_status_grp.is_status_applicable('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_SPLIT,
2018: NULL, NULL, p_org_id, wlc.inventory_item_id, wlpn.subinventory_code, wlpn.locator_id, wlc.lot_number, NULL, 'A', wlpn.lpn_id) = 'Y' -- Bug 14345460
2019: )
2020: OR p_mtrl_sts_check = 'N' --Bug 3980914
2021: )

Line 2109: AND inv_material_status_grp.is_status_applicable

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

Line 2113: AND inv_material_status_grp.is_status_applicable

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

Line 2117: AND inv_material_status_grp.is_status_applicable

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

Line 2121: AND inv_material_status_grp.is_status_applicable

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

Line 2166: AND inv_material_status_grp.is_status_applicable

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

Line 2170: AND inv_material_status_grp.is_status_applicable

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

Line 2174: AND inv_material_status_grp.is_status_applicable

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

Line 2178: AND inv_material_status_grp.is_status_applicable

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

Line 3254: AND inv_material_status_grp.is_status_applicable

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

Line 3267: AND inv_material_status_grp.is_status_applicable

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

Line 3359: AND inv_material_status_grp.is_status_applicable

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

Line 3372: AND inv_material_status_grp.is_status_applicable

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

Line 4411: AND inv_material_status_grp.is_status_applicable (

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

Line 4415: AND inv_material_status_grp.is_status_applicable (

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

Line 4466: AND inv_material_status_grp.is_status_applicable (

4462: AND wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
4463: AND wlc.source_name IS NOT null
4464: AND wlpn.license_plate_number LIKE (p_lpn_id)
4465: AND wms_lpn_lovs.SUB_LPN_CONTROLLED(wlpn.subinventory_code, p_organization_id) ='Y'
4466: AND inv_material_status_grp.is_status_applicable (
4467: 'TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_SPLIT, NULL,
4468: NULL, p_organization_id, NULL, wlpn.subinventory_code,
4469: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
4470: AND inv_material_status_grp.is_status_applicable (

Line 4470: AND inv_material_status_grp.is_status_applicable (

4466: AND inv_material_status_grp.is_status_applicable (
4467: 'TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_SPLIT, NULL,
4468: NULL, p_organization_id, NULL, wlpn.subinventory_code,
4469: wlpn.locator_id, NULL, NULL, 'Z') = 'Y'
4470: AND inv_material_status_grp.is_status_applicable (
4471: 'TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_SPLIT, NULL,
4472: NULL, p_organization_id, NULL, wlpn.subinventory_code,
4473: wlpn.locator_id, NULL, NULL, 'L') = 'Y'
4474: AND wdd.lpn_id = wlpn.lpn_id

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

4587: )
4588: )
4589: )
4590: AND wlpn.license_plate_number LIKE (p_into_lpn)
4591: AND inv_material_status_grp.is_status_applicable('TRUE',
4592: NULL,
4593: INV_GLOBALS.G_TYPE_CONTAINER_PACK,
4594: NULL,
4595: NULL,

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

4599: wlpn.locator_id,
4600: NULL,
4601: NULL,
4602: 'Z') = 'Y'
4603: AND inv_material_status_grp.is_status_applicable('TRUE',
4604: NULL,
4605: INV_GLOBALS.G_TYPE_CONTAINER_PACK,
4606: NULL,
4607: NULL,