DBA Data[Home] [Help]

APPS.MSC_ATP_PEG dependencies on MSC_PROCESS_EFFECTIVITY

Line 2603: msc_process_effectivity proc,

2599: msc_atp_detail_peg_temp adpt,
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

Line 2648: -- Join to msc_process_effectivity to get the bill sequence

2644: AND msi.plan_id = d1.plan_id
2645: AND msi.sr_instance_id = d1.sr_instance_id
2646: AND msi.inventory_item_id = d1.inventory_item_id
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