DBA Data[Home] [Help]

APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on MTL_ITEM_LOCATIONS_KFV

Line 951: FROM mtl_item_locations_kfv

947: SELECT 'failed'
948: INTO l_validity_check
949: FROM DUAL
950: WHERE EXISTS( SELECT subinventory_code
951: FROM mtl_item_locations_kfv
952: WHERE concatenated_segments = p_concat_segs
953: AND p_sub_code <> subinventory_code
954: AND organization_id = p_org_id);
955: EXCEPTION

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

1153: AND NVL(mil.task_id, -9999) = NVL(p_task_id, -9999);
1154: END;
1155:
1156: /* PJM-WMS Integration:Return only the the physical locators.
1157: * Use the table mtl_item_locations instead of mtl_item_locations_kfv.
1158: * Use the function INV_PROJECT.get_locsegs() to retrieve the
1159: * concatenated segments.Filter the locators based on the Project
1160: * and Task passed to the procedure.
1161: */

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

3239: -- Functions: This API returns the valid locators associated with a
3240: -- cycle count
3241: --
3242: /* PJM-WMS Integration:Return only the the physical locators.
3243: * Use the table mtl_item_locations instead of mtl_item_locations_kfv.
3244: * Use the function INV_PROJECT.get_locsegs() to retrieve the
3245: * concatenated segments.
3246: */
3247: 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