APPS.BOM_INV_COMPS1_PKG dependencies on MTL_SYSTEM_ITEMS

Line 80: mtl_system_items msi1

76: end if;
77:
78: SELECT 1 INTO dummy
79: FROM bom_bill_of_materials bbom,
80: mtl_system_items msi1
81: WHERE bbom.source_bill_sequence_id = X_Bill_Sequence_Id
82: AND bbom.organization_id <> X_Organization_Id
83: AND msi1.inventory_item_id = bbom.assembly_item_id
84: AND msi1.organization_id = bbom.organization_id

Line 86: FROM mtl_system_items msi2

82: AND bbom.organization_id <> X_Organization_Id
83: AND msi1.inventory_item_id = bbom.assembly_item_id
84: AND msi1.organization_id = bbom.organization_id
85: AND NOT EXISTS (SELECT null
86: FROM mtl_system_items msi2
87: WHERE msi2.organization_id = bbom.organization_id
88: AND msi2.inventory_item_id = X_Component_Item_Id
89: --AND msi2.bom_enabled_flag = 'Y'
90: --Not a required condition.

Line 181: FROM mtl_system_items msi

177: SELECT atp_components_flag,
178: atp_flag
179: INTO l_atp_comps_flag,
180: l_atp_flag
181: FROM mtl_system_items msi
182: WHERE inventory_item_id = X_Component_Item_Id
183: AND organization_id = X_Organization_Id;
184:
185: IF(( X_Atp_Comps_Flag = 'N' AND