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_GLOBALS

Line 1390: INV_GLOBALS.G_TYPE_CONTAINER_PACK,

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,
1392: NULL,
1393: p_org_id,
1394: NULL,

Line 1404: INV_GLOBALS.G_TYPE_CONTAINER_PACK,

1400: ) = 'Y'
1401: AND inv_material_status_grp.is_status_applicable(
1402: 'TRUE',
1403: NULL,
1404: INV_GLOBALS.G_TYPE_CONTAINER_PACK,
1405: NULL,
1406: NULL,
1407: p_org_id,
1408: NULL,

Line 1955: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,

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
1959: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,

Line 1959: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,

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
1963: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,

Line 1963: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,

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
1967: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,

Line 1967: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,

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: )
1971: OR p_mtrl_sts_check = 'N' --Bug 3980914

Line 2008: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,

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
2012: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,

Line 2012: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,

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
2016: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,

Line 2016: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,

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
2020: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,

Line 2020: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,

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: )
2024: OR p_mtrl_sts_check = 'N' --Bug 3980914

Line 2113: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,

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
2117: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,

Line 2117: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,

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
2121: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,

Line 2121: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,

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
2125: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,

Line 2125: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,

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: )
2129: OR p_mtrl_sts_check = 'N' --Bug 3980914

Line 2170: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,

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
2174: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,

Line 2174: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_PACK, NULL,

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
2178: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,

Line 2178: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,

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
2182: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,

Line 2182: ('TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,

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: )
2186: OR p_mtrl_sts_check = 'N' --Bug 3980914

Line 2220: If p_txn_type_id IN (INV_GLOBALS.G_TYPE_CONTAINER_PACK,

2216:
2217: END IF;
2218:
2219:
2220: If p_txn_type_id IN (INV_GLOBALS.G_TYPE_CONTAINER_PACK,
2221: INV_GLOBALS.G_TYPE_CONTAINER_UNPACK) THEN
2222: IF p_context = 11 THEN
2223: mydebug('calling GET_PACK_PICKED_LPNS');
2224: GET_PACK_PICKED_LPNS(

Line 2221: INV_GLOBALS.G_TYPE_CONTAINER_UNPACK) THEN

2217: END IF;
2218:
2219:
2220: If p_txn_type_id IN (INV_GLOBALS.G_TYPE_CONTAINER_PACK,
2221: INV_GLOBALS.G_TYPE_CONTAINER_UNPACK) THEN
2222: IF p_context = 11 THEN
2223: mydebug('calling GET_PACK_PICKED_LPNS');
2224: GET_PACK_PICKED_LPNS(
2225: x_lpn_lov => x_lpn_lov,

Line 2286: ELSIF p_txn_type_id = INV_GLOBALS.G_TYPE_CONTAINER_SPLIT THEN

2282: p_task_id => p_task_id,
2283: p_mtrl_sts_check => p_mtrl_sts_check); --Bug 3980914
2284:
2285: END IF;
2286: ELSIF p_txn_type_id = INV_GLOBALS.G_TYPE_CONTAINER_SPLIT THEN
2287: IF p_context = 11 THEN
2288: GET_SPLIT_PICKED_LPNS(
2289: x_lpn_lov => x_lpn_lov,
2290: p_org_id => p_org_id,

Line 3256: INV_GLOBALS.G_TYPE_CONTAINER_PACK,

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,
3258: NULL,
3259: p_org_id,
3260: NULL,

Line 3269: INV_GLOBALS.G_TYPE_CONTAINER_PACK,

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,
3271: NULL,
3272: p_org_id,
3273: NULL,

Line 3361: INV_GLOBALS.G_TYPE_CONTAINER_PACK,

3357: )
3358: AND inv_material_status_grp.is_status_applicable
3359: ('TRUE',
3360: NULL,
3361: INV_GLOBALS.G_TYPE_CONTAINER_PACK,
3362: NULL,
3363: NULL,
3364: p_org_id,
3365: NULL,

Line 3374: INV_GLOBALS.G_TYPE_CONTAINER_PACK,

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,
3376: NULL,
3377: p_org_id,
3378: NULL,

Line 4410: 'TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_SPLIT, NULL,

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 (
4414: 'TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_SPLIT, NULL,

Line 4414: 'TRUE', NULL, INV_GLOBALS.G_TYPE_CONTAINER_SPLIT, NULL,

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
4418: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650

Line 4490: INV_GLOBALS.G_TYPE_CONTAINER_PACK,

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,
4493: p_organization_id,
4494: NULL,

Line 4502: INV_GLOBALS.G_TYPE_CONTAINER_PACK,

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,
4505: p_organization_id,
4506: NULL,