DBA Data[Home] [Help]

APPS.MSD_BOM_COLLECTIONS dependencies on MSC_BOM_COMPONENTS

Line 133: FROM msc_bom_components mbc,

129: (mbc.usage_quantity / mbc.Component_Yield_Factor))*msd_common_utilities.uom_conv(ascp_comp.uom_code,ascp_comp.inventory_item_id) usage_quantity,
130: mbc.planning_factor,
131: mb.bill_sequence_id,
132: mbc.optional_component
133: FROM msc_bom_components mbc,
134: msc_boms mb,
135: msc_system_items assemble,
136: msc_system_items ascp_comp
137: WHERE mbc.plan_id = -1

Line 549: from msc_bom_components mbc,

545: 0,1,
546: abs(mbc.usage_quantity)),
547: 1, (mbc.usage_quantity * mbc.Component_Yield_Factor),
548: (mbc.usage_quantity / mbc.Component_Yield_Factor))*msd_sr_util.uom_conv(msi.uom_code,msi.sr_inventory_item_id) usage_quantity
549: from msc_bom_components mbc,
550: msc_system_items msi
551: where mbc.plan_id = -1
552: and msi.plan_id = -1
553: and msi.organization_id = mbc.organization_id