DBA Data[Home] [Help]

APPS.MSC_GET_NAME dependencies on MSC_BOMS

Line 1606: FROM msc_boms

1602: p_seq_id IN NUMBER) return varchar2 IS
1603:
1604: CURSOR ALT_BOM_C IS
1605: SELECT alternate_bom_designator
1606: FROM msc_boms
1607: WHERE plan_id = p_plan_id
1608: AND sr_instance_id = p_instance_id
1609: AND bill_sequence_id = p_seq_id;
1610:

Line 3375: FROM msc_boms bom,

3371: p_plan_id number,
3372: p_sr_instance_id number) return varchar2 is
3373: CURSOR ALT_bom_C IS
3374: SELECT bom.alternate_bom_designator
3375: FROM msc_boms bom,
3376: msc_process_effectivity eff
3377: WHERE bom.plan_id = eff.plan_id
3378: AND bom.sr_instance_id = eff.sr_instance_id
3379: AND bom.bill_sequence_id = eff.bill_sequence_id