DBA Data[Home] [Help]

APPS.EAM_OPERATIONS_JSP dependencies on MTL_ITEM_LOCATIONS_KFV

Line 2348: from mtl_item_locations_kfv

2344:
2345:
2346: CURSOR c_locator_cur IS --rhshriva
2347: select concatenated_segments
2348: from mtl_item_locations_kfv
2349: where (disable_date > sysdate or disable_date is null)
2350: and organization_id = p_organization_id
2351: and subinventory_code = p_subinventory_code ;
2352:

Line 2654: from mtl_item_locations_kfv

2650: if (p_locator is not null) then
2651:
2652: select inventory_location_id
2653: into l_locator
2654: from mtl_item_locations_kfv
2655: where organization_id = p_organization_id
2656: and concatenated_segments = p_locator
2657: and subinventory_code = p_supply_subinventory ;
2658: