DBA Data[Home] [Help]

APPS.BOM_ROUTINGHEADER_PVT dependencies on MTL_ITEM_SUB_INVENTORIES

Line 444: mtl_item_sub_inventories item

440: Cursor l_RestrictedSubinv_csr (P_SubInv varchar2, P_OrgId number,
441: P_ItemId number, P_Asset number, P_Inv_Asst varchar2) is
442: Select locator_type
443: From mtl_secondary_inventories sub,
444: mtl_item_sub_inventories item
445: Where item.organization_id = sub.organization_id
446: And item.secondary_inventory = sub.secondary_inventory_name
447: And item.inventory_item_id = P_ItemId
448: And sub.secondary_inventory_name = P_SubInv