APPS.MSC_REL_PLAN_PUB dependencies on MSC_BOM_COMPONENTS

Line 185: from msc_supplies coprod, msc_bom_components mbc

181: BEGIN
182:
183: select sum(coprod.new_order_quantity)
184: into lv_total
185: from msc_supplies coprod, msc_bom_components mbc
186: where coprod.sr_instance_id = inst_id
187: and coprod.plan_id = pln_id
188: and mbc.sr_instance_id = coprod.sr_instance_id
189: and mbc.plan_id = coprod.plan_id

Line 380: FROM MSC_BOM_COMPONENTS mbc

376: BEGIN
377:
378: SELECT mbc.USAGE_QUANTITY
379: INTO lv_USAGE_QUANTITY
380: FROM MSC_BOM_COMPONENTS mbc
381: WHERE mbc.plan_id = p_plan_id
382: AND mbc.sr_instance_id = p_inst_id
383: AND mbc.organization_id = p_org_id
384: AND mbc.using_assembly_id = p_using_assy_id

Line 406: FROM MSC_BOM_COMPONENTS mbc,

402: BEGIN
403:
404: SELECT mbc.WIP_SUPPLY_TYPE
405: INTO lv_wip_sup_type
406: FROM MSC_BOM_COMPONENTS mbc,
407: msc_process_effectivity mpe
408: where mpe.sr_instance_id = p_inst_id
409: and mpe.plan_id = p_plan_id
410: and mpe.process_sequence_id = p_process_seq_id

Line 6716: msc_bom_components subcomp,

6712: nvl(s.implement_uom_code,msi.uom_code),
6713: s.sr_instance_id
6714: FROM msc_trading_partners tp,
6715: msc_item_id_lid sr_item,
6716: msc_bom_components subcomp,
6717: msc_component_substitutes bsub,
6718: /* msc_bom_components bcomp, */
6719: msc_boms bom,
6720: msc_system_items icomp,

Line 6718: /* msc_bom_components bcomp, */

6714: FROM msc_trading_partners tp,
6715: msc_item_id_lid sr_item,
6716: msc_bom_components subcomp,
6717: msc_component_substitutes bsub,
6718: /* msc_bom_components bcomp, */
6719: msc_boms bom,
6720: msc_system_items icomp,
6721: msc_demands md,
6722: msc_parameters param,