DBA Data[Home] [Help]

APPS.MSC_ATP_PEG dependencies on MSC_BOM_COMPONENTS

Line 2604: msc_bom_components mbc

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

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

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