DBA Data[Home] [Help]

APPS.MSD_DEM_COLLECT_BOM_DATA dependencies on MSC_BOM_COMPONENTS

Line 160: msc_bom_components mbc

156: (mbc.usage_quantity / mbc.Component_Yield_Factor))
157: * msd_dem_common_utilities.uom_conv(msi.sr_instance_id, msi.uom_code,msi.sr_inventory_item_id) usage_quantity,
158: mbc.disable_date disable_date
159: FROM msc_system_items msi,
160: msc_bom_components mbc
161: WHERE msi.plan_id = -1
162: AND msi.sr_instance_id = p_instance
163: AND msi.organization_id = p_sr_org_pk
164: AND msi.inventory_item_id = p_asmb_ascp_pk

Line 284: msc_bom_components mbc,

280: mbc.planning_factor,
281: mb.bill_sequence_id,
282: mbc.optional_component
283: FROM msc_boms mb,
284: msc_bom_components mbc,
285: msc_system_items assemble,
286: msc_system_items ascp_comp
287: WHERE mb.plan_id = -1
288: AND mb.sr_instance_id = p_sr_instance_id