DBA Data[Home] [Help]

APPS.EAM_WORKORDERS_JSP dependencies on INV_PROJECT

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

698: and organization_id = p_org_id;*/
699:
700: select milk.Inventory_Location_ID into l_locator_id
701: from mtl_item_locations_kfv milk where
702: inv_project.Get_locator(milk.inventory_location_id, milk.organization_id) = p_locator
703: and milk.subinventory_code = p_subinventory
704: and milk.organization_id = p_org_id;
705:
706: elsif(p_locator_ctrl = 1) then

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

716: and secondary_locator = inventory_location_id) ;*/
717:
718: select milk.Inventory_Location_ID into l_locator_id
719: from mtl_item_locations_kfv milk where
720: inv_project.Get_locator(milk.inventory_location_id, milk.organization_id) = p_locator
721: and milk.subinventory_code = p_subinventory
722: and milk.organization_id = p_org_id
723: and EXISTS (select '1' from mtl_secondary_locators
724: where inventory_item_id = p_item_id