APPS.INV_TXN_VALIDATIONS dependencies on MTL_ITEM_LOCATIONS

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 3518: FROM mtl_item_locations a, mtl_secondary_locators b

3514: OPEN x_locators FOR
3515: SELECT a.inventory_location_id
3516: , inv_project.get_locsegs(a.inventory_location_id,l_org)
3517: , NVL(a.description, -1)
3518: FROM mtl_item_locations a, mtl_secondary_locators b
3519: WHERE b.organization_id = l_org
3520: AND b.inventory_item_id = p_inventory_item_id
3521: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3522: AND b.subinventory_code = p_subinventory_code

Line 3534: FROM mtl_item_locations

3530: OPEN x_locators FOR
3531: SELECT inventory_location_id
3532: , inv_project.get_locsegs(inventory_location_id, l_org)
3533: , description
3534: FROM mtl_item_locations
3535: WHERE organization_id = l_org
3536: AND subinventory_code = p_subinventory_code
3537: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3538: AND inv_project.get_locsegs(inventory_location_id, l_org) 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;