DBA Data[Home] [Help]

APPS.EAM_OPERATIONS_JSP dependencies on INV_PROJECT

Line 2347: select inv_project.Get_locator(milk.inventory_location_id, milk.organization_id) as concatenated_segments

2343: order by msinv.secondary_inventory_name;
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 ;

Line 2656: and inv_project.Get_locator(milk.inventory_location_id, milk.organization_id) = p_locator

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:
2659: end if;
2660: -- Get MRP Net Flag

Line 3131: and inv_project.Get_locator(milk.inventory_location_id, milk.organization_id) = p_locator

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:
3134: end if;
3135: -- Get MRP Net Flag