APPS.BOM_ROUTINGHEADER_PVT dependencies on MTL_ITEM_LOCATIONS

Line 463: from mtl_item_locations

459: select 1 dummy
460: from sys.dual
461: where not exists(
462: select null
463: from mtl_item_locations
464: where inventory_location_id = P_Location
465: and organization_id = P_OrgId
466: and subinventory_code = P_SubInventory
467: and nvl(disable_date, trunc(SYSDATE)+1) > trunc(SYSDATE));

Line 474: from mtl_item_locations loc,

470: Select 1 dummy
471: from dual
472: where not exists(
473: select null
474: from mtl_item_locations loc,
475: mtl_secondary_locators item
476: where loc.inventory_location_id = P_Location
477: and loc.organization_id = P_OrgId
478: and loc.subinventory_code = P_SubInventory