DBA Data[Home] [Help]

APPS.EAM_OPERATIONS_JSP dependencies on MTL_ITEM_LOCATIONS_KFV

Line 2348: from mtl_item_locations_kfv milk

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

Line 2654: from mtl_item_locations_kfv milk

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

Line 3122: from mtl_item_locations_kfv

3118: if (p_locator is not null) then
3119:
3120: /*select inventory_location_id
3121: into l_locator
3122: from mtl_item_locations_kfv
3123: where organization_id = p_organization_id
3124: and concatenated_segments = p_locator
3125: and subinventory_code = p_supply_subinventory ;*/
3126:

Line 3129: from mtl_item_locations_kfv milk

3125: and subinventory_code = p_supply_subinventory ;*/
3126:
3127: select milk.inventory_location_id
3128: into l_locator
3129: from mtl_item_locations_kfv milk
3130: where milk.organization_id = p_organization_id
3131: and inv_project.Get_locator(milk.inventory_location_id, milk.organization_id) = p_locator
3132: and milk.subinventory_code = p_supply_subinventory ;
3133: