DBA Data[Home] [Help]

APPS.WSMPUTIL dependencies on MTL_ITEM_LOCATIONS_KFV

Line 6053: l_locator MTL_ITEM_LOCATIONS_KFV.CONCATENATED_SEGMENTS%TYPE;

6049: )
6050: return varchar2 is
6051: l_status_applicable VARCHAR2(1) := 'Y';
6052: l_item MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
6053: l_locator MTL_ITEM_LOCATIONS_KFV.CONCATENATED_SEGMENTS%TYPE;
6054: BEGIN
6055: IF (p_inventory_item_id IS NOT NULL and p_sub_code IS NOT NULL) THEN
6056: l_status_applicable := INV_MATERIAL_STATUS_GRP.is_status_applicable(p_wms_installed => p_wms_installed,
6057: p_trx_status_enabled => p_trx_status_enabled ,

Line 6097: from mtl_item_locations_kfv

6093:
6094: IF l_status_applicable = 'N' THEN
6095: select concatenated_segments
6096: into l_locator
6097: from mtl_item_locations_kfv
6098: where inventory_location_id = p_locator_id
6099: and organization_id = p_organization_id;
6100:
6101: FND_MESSAGE.SET_NAME('INV','INV_TRX_LOCATOR_NA_DUE_MS');