DBA Data[Home] [Help]

APPS.BOM_ROUTINGHEADER_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 430: From mtl_secondary_inventories

426: and mp.organization_id = msi.organization_id;
427: Cursor l_NonRestrictedSubinv_csr (P_SubInv varchar2, P_OrgId number,
428: P_Asset number, P_Inv_Asst varchar2) is
429: Select locator_type
430: From mtl_secondary_inventories
431: Where secondary_inventory_name = P_SubInv
432: And organization_id = P_OrgId
433: And nvl(disable_date,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE)
434: And ((P_Asset = 1 and quantity_tracked = 1) or

Line 443: From mtl_secondary_inventories sub,

439: );
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