DBA Data[Home] [Help]

APPS.WSMPUTIL dependencies on MTL_ITEM_LOCATIONS_KFV

Line 6056: l_locator MTL_ITEM_LOCATIONS_KFV.CONCATENATED_SEGMENTS%TYPE;

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

Line 6100: from mtl_item_locations_kfv

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