APPS.MSC_REL_PLAN_PUB dependencies on MSC_BOM_COMPONENTS

Line 193: from msc_supplies coprod, msc_bom_components mbc

189: BEGIN
190:
191: select sum(coprod.new_order_quantity)
192: into lv_total
193: from msc_supplies coprod, msc_bom_components mbc
194: where coprod.sr_instance_id = inst_id
195: and coprod.plan_id = pln_id
196: and mbc.sr_instance_id = coprod.sr_instance_id
197: and mbc.plan_id = coprod.plan_id

Line 388: FROM MSC_BOM_COMPONENTS mbc

384: BEGIN
385:
386: SELECT mbc.USAGE_QUANTITY
387: INTO lv_USAGE_QUANTITY
388: FROM MSC_BOM_COMPONENTS mbc
389: WHERE mbc.plan_id = p_plan_id
390: AND mbc.sr_instance_id = p_inst_id
391: AND mbc.organization_id = p_org_id
392: AND mbc.using_assembly_id = p_using_assy_id

Line 414: FROM MSC_BOM_COMPONENTS mbc,

410: BEGIN
411:
412: SELECT mbc.WIP_SUPPLY_TYPE
413: INTO lv_wip_sup_type
414: FROM MSC_BOM_COMPONENTS mbc,
415: msc_process_effectivity mpe
416: where mpe.sr_instance_id = p_inst_id
417: and mpe.plan_id = p_plan_id
418: and mpe.process_sequence_id = p_process_seq_id

Line 7395: msc_bom_components subcomp,

7391: nvl(s.implement_uom_code,msi.uom_code),
7392: s.sr_instance_id
7393: FROM msc_trading_partners tp,
7394: msc_item_id_lid sr_item,
7395: msc_bom_components subcomp,
7396: msc_component_substitutes bsub,
7397: /* msc_bom_components bcomp, */
7398: msc_boms bom,
7399: msc_system_items icomp,

Line 7397: /* msc_bom_components bcomp, */

7393: FROM msc_trading_partners tp,
7394: msc_item_id_lid sr_item,
7395: msc_bom_components subcomp,
7396: msc_component_substitutes bsub,
7397: /* msc_bom_components bcomp, */
7398: msc_boms bom,
7399: msc_system_items icomp,
7400: msc_demands md,
7401: msc_parameters param,