APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on MTL_ITEM_LOCATIONS_KFV

Line 79: FROM mtl_item_locations_kfv

75: SELECT inventory_location_type
76: , concatenated_segments
77: INTO l_loc_type
78: , l_phys_loc_segs
79: FROM mtl_item_locations_kfv
80: WHERE organization_id = p_org_id
81: AND inventory_location_id = l_physical_loc_id;
82: EXCEPTION
83: WHEN OTHERS THEN

Line 1288: FROM mtl_item_locations_kfv

1284: SELECT 'failed'
1285: INTO l_validity_check
1286: FROM DUAL
1287: WHERE EXISTS( SELECT subinventory_code
1288: FROM mtl_item_locations_kfv
1289: WHERE concatenated_segments = p_concat_segs
1290: AND p_sub_code <> subinventory_code
1291: AND organization_id = p_org_id);
1292: EXCEPTION

Line 1532: * Use the table mtl_item_locations instead of mtl_item_locations_kfv.

1528: AND NVL(mil.task_id, -9999) = NVL(p_task_id, -9999);
1529: END get_mo_toloc_lov;
1530:
1531: /* PJM-WMS Integration:Return only the the physical locators.
1532: * Use the table mtl_item_locations instead of mtl_item_locations_kfv.
1533: * Use the function INV_PROJECT.get_locsegs() to retrieve the
1534: * concatenated segments.Filter the locators based on the Project
1535: * and Task passed to the procedure.
1536: */

Line 3640: * Use the table mtl_item_locations instead of mtl_item_locations_kfv.

3636: -- Functions: This API returns the valid locators associated with a
3637: -- cycle count
3638: --
3639: /* PJM-WMS Integration:Return only the the physical locators.
3640: * Use the table mtl_item_locations instead of mtl_item_locations_kfv.
3641: * Use the function INV_PROJECT.get_locsegs() to retrieve the
3642: * concatenated segments.
3643: */
3644: PROCEDURE get_cgupdate_locs(x_locators OUT NOCOPY t_genref, p_organization_id IN NUMBER, p_subinventory_code IN VARCHAR2, p_concatenated_segments IN VARCHAR2, p_inventory_item_id IN NUMBER, p_revision IN VARCHAR2) IS