APPS.INV_TXN_VALIDATIONS dependencies on MTL_ITEM_LOCATIONS_KFV

Line 134: FROM mtl_item_locations_kfv

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

Line 3731: FROM mtl_item_locations_kfv a, mtl_secondary_locators b

3727: OPEN x_locators FOR
3728: SELECT a.inventory_location_id
3729: , a.concatenated_segments
3730: , a.description
3731: FROM mtl_item_locations_kfv a, mtl_secondary_locators b
3732: WHERE b.organization_id = l_org
3733: AND b.inventory_item_id = p_inventory_item_id
3734: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3735: AND b.subinventory_code = p_subinventory_code

Line 3745: FROM mtl_item_locations_kfv

3741: OPEN x_locators FOR
3742: SELECT inventory_location_id
3743: , concatenated_segments
3744: , description
3745: FROM mtl_item_locations_kfv
3746: WHERE organization_id = l_org
3747: AND subinventory_code = p_subinventory_code
3748: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3749: AND concatenated_segments LIKE (p_concatenated_segments||'%')

Line 3900: l_to_locator mtl_item_locations_kfv.concatenated_segments%TYPE;

3896:
3897: l_to_subinventory_code VARCHAR2(10);
3898: l_locator_type NUMBER;
3899: l_to_locator_id NUMBER;
3900: l_to_locator mtl_item_locations_kfv.concatenated_segments%TYPE;
3901: l_description mtl_secondary_inventories.description%TYPE;
3902: l_asset_inventory mtl_secondary_inventories.asset_inventory%TYPE;
3903: l_lpn_controlled_flag mtl_secondary_inventories.lpn_controlled_flag%TYPE;
3904: l_enable_locator_alias mtl_secondary_inventories.enable_locator_alias%TYPE;