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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2217: If p_txn_type_id IN (INV_GLOBALS.G_TYPE_CONTAINER_PACK,

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

Line 2218: INV_GLOBALS.G_TYPE_CONTAINER_UNPACK) THEN

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

Line 2283: ELSIF p_txn_type_id = INV_GLOBALS.G_TYPE_CONTAINER_SPLIT THEN

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

Line 3257: INV_GLOBALS.G_TYPE_CONTAINER_PACK,

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

Line 3270: INV_GLOBALS.G_TYPE_CONTAINER_PACK,

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

Line 3362: INV_GLOBALS.G_TYPE_CONTAINER_PACK,

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

Line 3375: INV_GLOBALS.G_TYPE_CONTAINER_PACK,

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

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

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

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

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

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

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

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

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

Line 4593: INV_GLOBALS.G_TYPE_CONTAINER_PACK,

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,
4596: p_organization_id,
4597: NULL,

Line 4605: INV_GLOBALS.G_TYPE_CONTAINER_PACK,

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,
4608: p_organization_id,
4609: NULL,