APPS.INV_TXN_VALIDATIONS dependencies on MTL_ITEM_LOCATIONS_KFV

Line 137: FROM mtl_item_locations_kfv

133:
134:
135: IF x_Current_Locator_Id IS NOT NULL THEN
136: SELECT concatenated_segments INTO x_Concatenated_Segments
137: FROM mtl_item_locations_kfv
138: WHERE inventory_location_id = x_Current_Locator_Id AND
139: organization_id = p_Current_Organization_Id;
140:
141: END IF;

Line 3452: FROM mtl_item_locations_kfv a, mtl_secondary_locators b

3448: OPEN x_locators FOR
3449: SELECT a.inventory_location_id
3450: , a.concatenated_segments
3451: , a.description
3452: FROM mtl_item_locations_kfv a, mtl_secondary_locators b
3453: WHERE b.organization_id = l_org
3454: AND b.inventory_item_id = p_inventory_item_id
3455: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3456: AND b.subinventory_code = p_subinventory_code

Line 3466: FROM mtl_item_locations_kfv

3462: OPEN x_locators FOR
3463: SELECT inventory_location_id
3464: , concatenated_segments
3465: , description
3466: FROM mtl_item_locations_kfv
3467: WHERE organization_id = l_org
3468: AND subinventory_code = p_subinventory_code
3469: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3470: AND concatenated_segments LIKE (p_concatenated_segments||'%')

Line 3621: l_to_locator mtl_item_locations_kfv.concatenated_segments%TYPE;

3617:
3618: l_to_subinventory_code VARCHAR2(10);
3619: l_locator_type NUMBER;
3620: l_to_locator_id NUMBER;
3621: l_to_locator mtl_item_locations_kfv.concatenated_segments%TYPE;
3622: l_description mtl_secondary_inventories.description%TYPE;
3623: l_asset_inventory mtl_secondary_inventories.asset_inventory%TYPE;
3624: l_lpn_controlled_flag mtl_secondary_inventories.lpn_controlled_flag%TYPE;
3625: l_enable_locator_alias mtl_secondary_inventories.enable_locator_alias%TYPE;