DBA Data[Home] [Help]

APPS.MSC_GET_NAME dependencies on MSC_BOMS

Line 1935: FROM msc_boms

1931: p_seq_id IN NUMBER) return varchar2 IS
1932:
1933: CURSOR ALT_BOM_C IS
1934: SELECT alternate_bom_designator
1935: FROM msc_boms
1936: WHERE plan_id = p_plan_id
1937: AND sr_instance_id = p_instance_id
1938: AND bill_sequence_id = p_seq_id;
1939:

Line 3832: FROM msc_boms bom,

3828: p_plan_id number,
3829: p_sr_instance_id number) return varchar2 is
3830: CURSOR ALT_bom_C IS
3831: SELECT bom.alternate_bom_designator
3832: FROM msc_boms bom,
3833: msc_process_effectivity eff
3834: WHERE bom.plan_id = eff.plan_id
3835: AND bom.sr_instance_id = eff.sr_instance_id
3836: AND bom.bill_sequence_id = eff.bill_sequence_id