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 WMS_LPN_LOVS

Line 1: PACKAGE BODY WMS_LPN_LOVS AS

1: PACKAGE BODY WMS_LPN_LOVS AS
2: /* $Header: WMSLPNLB.pls 120.13.12020000.6 2013/03/01 07:01:21 ssingams ship $ */
3:
4: -- Name: GET_LPN_LOV
5: --

Line 29: p_module => 'WMS_LPN_LOVS',

25: l_msg := msg;
26:
27: inv_mobile_helper_functions.tracelog
28: (p_err_msg => l_msg,
29: p_module => 'WMS_LPN_LOVS',
30: p_level => 4);
31:
32: --dbms_output.put_line(l_msg);
33: END;

Line 242: inv_log_util.trace('In Get_WHERE_PJM_LPN_LOV', 'WMS_LPN_LOVs',1);

238: ' AND wlc.parent_lpn_id (+) = wlpn.lpn_id ';
239: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
240: BEGIN
241: IF (l_debug = 1) THEN
242: inv_log_util.trace('In Get_WHERE_PJM_LPN_LOV', 'WMS_LPN_LOVs',1);
243: END IF;
244: l_sql_stmt := l_sql_stmt ||
245: 'AND wlpn.license_plate_number LIKE :p_lpn ' ||
246: p_where_clause;

Line 1478: AND wms_lpn_lovs.SUB_LPN_CONTROLLED(wlpn.subinventory_code, p_org_id ) = 'Y' */

1474: AND NVL(wlpn.parent_lpn_id, 0) = NVL(TO_NUMBER(p_parent_lpn_id),
1475: NVL(wlpn.parent_lpn_id, 0))
1476: AND wlpn.license_plate_number LIKE (p_lpn)
1477: /* Bug 3980914 -For LPN's with context 5, the following condition is not required
1478: AND wms_lpn_lovs.SUB_LPN_CONTROLLED(wlpn.subinventory_code, p_org_id ) = 'Y' */
1479: AND (wlpn.lpn_context = 5)
1480: UNION ALL
1481: SELECT wlpn.license_plate_number,
1482: wlpn.lpn_id,

Line 1503: AND wms_lpn_lovs.SUB_LPN_CONTROLLED(wlpn.subinventory_code, p_org_id ) = 'Y'

1499: AND NOT wlpn.lpn_id = NVL(TO_NUMBER(p_not_lpn_id), -999)
1500: AND NVL(wlpn.parent_lpn_id, 0) = NVL(TO_NUMBER(p_parent_lpn_id),
1501: NVL(wlpn.parent_lpn_id, 0))
1502: AND wlpn.license_plate_number LIKE (p_lpn)
1503: AND wms_lpn_lovs.SUB_LPN_CONTROLLED(wlpn.subinventory_code, p_org_id ) = 'Y'
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

Line 1548: AND (wms_lpn_lovs.SUB_LPN_CONTROLLED(wlpn.subinventory_code, p_org_id ) = 'Y')

1544: AND NOT wlpn.lpn_id = NVL(TO_NUMBER(p_not_lpn_id), -999)
1545: AND NVL(wlpn.parent_lpn_id, 0) = NVL(TO_NUMBER(p_parent_lpn_id),
1546: NVL(wlpn.parent_lpn_id, 0))
1547: AND wlpn.license_plate_number LIKE (p_lpn)
1548: AND (wms_lpn_lovs.SUB_LPN_CONTROLLED(wlpn.subinventory_code, p_org_id ) = 'Y')
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

Line 1619: AND wms_lpn_lovs.SUB_LPN_CONTROLLED(wlpn.subinventory_code, p_org_id ) = 'Y' */

1615: AND NVL(wlpn.parent_lpn_id, 0) = NVL(TO_NUMBER(p_parent_lpn_id),
1616: NVL(wlpn.parent_lpn_id, 0))
1617: AND wlpn.license_plate_number LIKE (p_lpn)
1618: /* Bug 3980914 - For LPN's with context 5, no check for subinventory required.
1619: AND wms_lpn_lovs.SUB_LPN_CONTROLLED(wlpn.subinventory_code, p_org_id ) = 'Y' */
1620: AND (wlpn.lpn_context = 5)
1621: UNION ALL
1622: SELECT wlpn.license_plate_number,
1623: wlpn.lpn_id,

Line 1645: AND (wms_lpn_lovs.SUB_LPN_CONTROLLED(wlpn.subinventory_code, p_org_id ) = 'Y')

1641: AND NOT wlpn.lpn_id = NVL(TO_NUMBER(p_not_lpn_id), -999)
1642: AND NVL(wlpn.parent_lpn_id, 0) = NVL(TO_NUMBER(p_parent_lpn_id),
1643: NVL(wlpn.parent_lpn_id, 0))
1644: AND wlpn.license_plate_number LIKE (p_lpn)
1645: AND (wms_lpn_lovs.SUB_LPN_CONTROLLED(wlpn.subinventory_code, p_org_id ) = 'Y')
1646: AND wlpn.lpn_context = p_context
1647: AND NVL(wlpn.subinventory_code, '@') = NVL(p_sub, NVL(wlpn.subinventory_code, '@'))
1648: AND NVL(wlpn.locator_id, '0') = NVL(TO_NUMBER(p_loc_id), NVL(wlpn.locator_id, '0'))
1649: AND mil.inventory_location_id = wlpn.locator_id

Line 1710: AND (wms_lpn_lovs.SUB_LPN_CONTROLLED(wlpn.subinventory_code, p_org_id ) = 'Y')

1706: AND NOT wlpn.lpn_id = NVL(TO_NUMBER(p_not_lpn_id), -999)
1707: AND NVL(wlpn.parent_lpn_id, 0) = NVL(TO_NUMBER(p_parent_lpn_id),
1708: NVL(wlpn.parent_lpn_id, 0))
1709: AND wlpn.license_plate_number LIKE (p_lpn)
1710: AND (wms_lpn_lovs.SUB_LPN_CONTROLLED(wlpn.subinventory_code, p_org_id ) = 'Y')
1711: AND wlpn.lpn_context = p_context
1712: AND NVL(wlpn.subinventory_code, '@') = NVL(p_sub, NVL(wlpn.subinventory_code, '@'))
1713: AND NVL(wlpn.locator_id, '0') = NVL(TO_NUMBER(p_loc_id), NVL(wlpn.locator_id, '0'))
1714: AND mil.inventory_location_id = wlpn.locator_id

Line 1934: AND wms_lpn_lovs.SUB_LPN_CONTROLLED(wlpn.subinventory_code, p_org_id ) = 'Y' */

1930: AND NVL(wlpn.parent_lpn_id, 0) = NVL(TO_NUMBER(p_parent_lpn_id),
1931: NVL(wlpn.parent_lpn_id, 0))
1932: AND wlpn.license_plate_number LIKE (p_lpn)
1933: /* Bug 3980914 -For LPN's with context 5, the following condition is not required
1934: AND wms_lpn_lovs.SUB_LPN_CONTROLLED(wlpn.subinventory_code, p_org_id ) = 'Y' */
1935: AND (wlpn.lpn_context = 5)
1936: UNION ALL
1937: SELECT wlpn.license_plate_number,
1938: wlpn.lpn_id,

Line 1959: AND (wms_lpn_lovs.SUB_LPN_CONTROLLED(wlpn.subinventory_code, p_org_id) ='Y')

1955: AND NOT wlpn.lpn_id = NVL(TO_NUMBER(p_not_lpn_id), -999)
1956: AND NVL(wlpn.parent_lpn_id, 0) = NVL(TO_NUMBER(p_parent_lpn_id),
1957: NVL(wlpn.parent_lpn_id, 0))
1958: AND wlpn.license_plate_number LIKE (p_lpn)
1959: AND (wms_lpn_lovs.SUB_LPN_CONTROLLED(wlpn.subinventory_code, p_org_id) ='Y')
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

Line 2013: AND wms_lpn_lovs.sub_lpn_controlled(wlpn.subinventory_code, p_org_id) = 'Y'

2009: AND NOT wlpn.lpn_id = NVL(TO_NUMBER(p_not_lpn_id), -999)
2010: AND NVL(wlpn.parent_lpn_id, 0) = NVL(TO_NUMBER(p_parent_lpn_id), NVL(wlpn.parent_lpn_id, 0))
2011: AND wlpn.license_plate_number LIKE (p_lpn)
2012: AND wlpn.lpn_id = wlc.parent_lpn_id -- Bug 14345460
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,

Line 2075: AND wms_lpn_lovs.SUB_LPN_CONTROLLED(wlpn.subinventory_code, p_org_id ) = 'Y' */

2071: AND NVL(wlpn.parent_lpn_id, 0) = NVL(TO_NUMBER(p_parent_lpn_id),
2072: NVL(wlpn.parent_lpn_id, 0))
2073: AND wlpn.license_plate_number LIKE (p_lpn)
2074: /* Bug 3980914 -For LPN's with context 5, the following condition is not required
2075: AND wms_lpn_lovs.SUB_LPN_CONTROLLED(wlpn.subinventory_code, p_org_id ) = 'Y' */
2076: AND (wlpn.lpn_context = 5)
2077: UNION ALL
2078: SELECT wlpn.license_plate_number,
2079: wlpn.lpn_id,

Line 2101: AND (wms_lpn_lovs.SUB_LPN_CONTROLLED(wlpn.subinventory_code, p_org_id) ='Y')

2097: AND NOT wlpn.lpn_id = NVL(TO_NUMBER(p_not_lpn_id), -999)
2098: AND NVL(wlpn.parent_lpn_id, 0) = NVL(TO_NUMBER(p_parent_lpn_id),
2099: NVL(wlpn.parent_lpn_id, 0))
2100: AND wlpn.license_plate_number LIKE (p_lpn)
2101: AND (wms_lpn_lovs.SUB_LPN_CONTROLLED(wlpn.subinventory_code, p_org_id) ='Y')
2102: AND wlpn.lpn_context = p_context
2103: AND NVL(wlpn.subinventory_code, '@') = NVL(p_sub, NVL(wlpn.subinventory_code, '@'))
2104: AND NVL(wlpn.locator_id, '0') = NVL(TO_NUMBER(p_loc_id), NVL(wlpn.locator_id, '0'))
2105: AND mil.inventory_location_id = wlpn.locator_id

Line 2158: AND (wms_lpn_lovs.SUB_LPN_CONTROLLED(wlpn.subinventory_code, p_org_id) ='Y')

2154: AND NOT wlpn.lpn_id = NVL(TO_NUMBER(p_not_lpn_id), -999)
2155: AND NVL(wlpn.parent_lpn_id, 0) = NVL(TO_NUMBER(p_parent_lpn_id),
2156: NVL(wlpn.parent_lpn_id, 0))
2157: AND wlpn.license_plate_number LIKE (p_lpn)
2158: AND (wms_lpn_lovs.SUB_LPN_CONTROLLED(wlpn.subinventory_code, p_org_id) ='Y')
2159: AND wlpn.lpn_context = p_context
2160: AND NVL(wlpn.subinventory_code, '@') = NVL(p_sub, NVL(wlpn.subinventory_code, '@'))
2161: AND NVL(wlpn.locator_id, '0') = NVL(TO_NUMBER(p_loc_id), NVL(wlpn.locator_id, '0'))
2162: AND mil.inventory_location_id = wlpn.locator_id

Line 4410: AND wms_lpn_lovs.SUB_LPN_CONTROLLED(wlpn.subinventory_code, p_organization_id) ='Y'

4406: wsh_delivery_details wdd
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'

Line 4465: AND wms_lpn_lovs.SUB_LPN_CONTROLLED(wlpn.subinventory_code, p_organization_id) ='Y'

4461: AND wlpn.lpn_id = wlc.parent_lpn_id
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'

Line 4750: END WMS_LPN_LOVS;

4746: ORDER BY license_plate_number;
4747:
4748: END GET_PICK_DROP_SUBXFR_LPN_LOV;
4749:
4750: END WMS_LPN_LOVS;