DBA Data[Home] [Help]

APPS.WSM_WLT_VALIDATE_PVT dependencies on MTL_ITEM_LOCATIONS_KFV

Line 6548: FROM mtl_item_locations_kfv

6544: l_stmt_num := 30;
6545: BEGIN
6546: SELECT inventory_location_id
6547: INTO p_rj_completion_locator_id
6548: FROM mtl_item_locations_kfv
6549: WHERE inventory_item_id = l_rtg_item_id -- p_primary_item_id
6550: AND organization_id = p_organization_id
6551: AND subinventory_code = p_rj_completion_subinventory
6552: AND concatenated_segments = nvl(p_rj_completion_locator,concatenated_segments);

Line 6623: from mtl_item_locations_kfv

6619: l_stmt_num := 50;
6620: BEGIN
6621: select inventory_location_id
6622: into p_rj_completion_locator_id
6623: from mtl_item_locations_kfv
6624: where inventory_item_id = l_rtg_item_id -- p_primary_item_id
6625: and organization_id = p_organization_id
6626: and subinventory_code = p_rj_completion_subinventory
6627: and concatenated_segments = p_rj_completion_locator;