DBA Data[Home] [Help]

APPS.MSD_DEM_SR_UTIL dependencies on BOM_INVENTORY_COMPONENTS

Line 295: bom_inventory_components bic

291: from
292: msd_dem_app_instance_orgs morg,
293: bom_bill_of_materials bbm,
294: mtl_system_items msi, -- Parent
295: bom_inventory_components bic
296: where
297: bic.bill_sequence_id = bbm.bill_sequence_id
298: and bbm.organization_id = morg.organization_id
299: and msi.organization_id = bbm.organization_id

Line 338: bom_inventory_components bic,

334: SELECT
335: count(1)
336: FROM
337: mtl_system_items parent,
338: bom_inventory_components bic,
339: bom_bill_of_materials bom
340: WHERE
341: parent.bom_item_type = 5 and
342: parent.organization_id = bom.organization_id and

Line 753: bom_inventory_components bic

749: SELECT 1
750: FROM msd_dem_app_instance_orgs mdaio,
751: bom_bill_of_materials bbm,
752: mtl_system_items msi,
753: bom_inventory_components bic
754: WHERE
755: bic.component_sequence_id = x_component_sequence_id
756: AND bic.bill_sequence_id = bbm.bill_sequence_id
757: AND bbm.organization_id = mdaio.organization_id

Line 777: bom_inventory_components bic

773: 1
774: FROM msd_dem_app_instance_orgs mdaio,
775: bom_bill_of_materials bbm,
776: mtl_system_items msi,
777: bom_inventory_components bic
778: WHERE
779: bic.component_sequence_id = x_component_sequence_id
780: AND bic.bill_sequence_id = bbm.bill_sequence_id
781: AND bbm.organization_id = mdaio.organization_id