DBA Data[Home] [Help]

APPS.MSC_ATP_PEG dependencies on MSC_BOM_COMPONENTS

Line 2606: msc_bom_components mbc

2602: msc_full_pegging peg1 ,
2603: msc_demands d1,
2604: msc_system_items msi,
2605: msc_process_effectivity proc,
2606: msc_bom_components mbc
2607: WHERE adpt.plan_id = p_plan_id
2608: AND adpt.reference_item_id = c_items_rec.inventory_item_id
2609: AND adpt.sales_order_line_id = c_items_rec.sales_order_line_id
2610: AND decode(adpt.demand_source_type,100,adpt.demand_source_type,-1)

Line 2653: -- Join to msc_bom_components to exclude any exploded items underneath phantoms

2649: AND msi.organization_id = d1.organization_id
2650: -- Join to msc_process_effectivity to get the bill sequence
2651: AND proc.plan_id = adpt.plan_id
2652: AND proc.process_sequence_id = adpt.process_seq_id
2653: -- Join to msc_bom_components to exclude any exploded items underneath phantoms
2654: AND mbc.plan_id = msi.plan_id
2655: AND mbc.sr_instance_id = msi.sr_instance_id
2656: AND mbc.organization_id = msi.organization_id
2657: AND mbc.bill_sequence_id = proc.bill_sequence_id