APPS.MSD_DEM_SR_UTIL dependencies on BOM_BILL_OF_MATERIALS

Line 269: bom_bill_of_materials bbm,

265: CURSOR c_optional IS
266: select 1
267: from
268: msd_dem_app_instance_orgs morg,
269: bom_bill_of_materials bbm,
270: mtl_system_items msi, -- Parent
271: bom_inventory_components bic
272: where
273: bic.bill_sequence_id = bbm.bill_sequence_id

Line 315: bom_bill_of_materials bom

311: count(1)
312: FROM
313: mtl_system_items parent,
314: bom_inventory_components bic,
315: bom_bill_of_materials bom
316: WHERE
317: parent.bom_item_type = 5 and
318: parent.organization_id = bom.organization_id and
319: bom.ASSEMBLY_ITEM_ID = parent.inventory_item_id and