eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_GET_NAME dependencies on MSC_PROCESS_EFFECTIVITY

Line 129: from msc_process_effectivity

125: END IF;
126:
127: select preference
128: into var_process_priority
129: from msc_process_effectivity
130: where plan_id = arg_plan_id
131: and process_sequence_id = arg_process_sequence_id
132: and sr_instance_id = arg_sr_instance_id
133: and organization_id = arg_organization_id

Line 3833: msc_process_effectivity eff

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
3837: AND eff.plan_id=p_plan_id

Line 3863: msc_process_effectivity eff

3859: p_sr_instance_id number) return varchar2 is
3860: CURSOR ALT_RTG_C IS
3861: SELECT rt.alternate_routing_designator
3862: FROM msc_routings rt,
3863: msc_process_effectivity eff
3864: WHERE rt.plan_id = eff.plan_id
3865: AND rt.sr_instance_id = eff.sr_instance_id
3866: AND rt.routing_sequence_id = eff.routing_sequence_id
3867: AND eff.plan_id=p_plan_id