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 173: FROM mtl_system_items msi

169: SELECT atp_components_flag,
170: atp_flag
171: INTO l_atp_comps_flag,
172: l_atp_flag
173: FROM mtl_system_items msi
174: WHERE inventory_item_id = X_Component_Item_Id
175: AND organization_id = X_Organization_Id;
176:
177: IF(( X_Atp_Comps_Flag = 'N' AND