DBA Data[Home] [Help]

APPS.MSD_DEM_SR_UTIL dependencies on BOM_BILL_OF_MATERIALS

Line 293: bom_bill_of_materials bbm,

289: CURSOR c_optional IS
290: select 1
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

Line 339: bom_bill_of_materials bom

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
343: bom.ASSEMBLY_ITEM_ID = parent.inventory_item_id and

Line 751: bom_bill_of_materials bbm,

747: CURSOR C_IS_OPTIONAL
748: IS
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

Line 775: bom_bill_of_materials bbm,

771: IS
772: SELECT
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