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 92: from msc_process_effectivity

88: END IF;
89:
90: select preference
91: into var_process_priority
92: from msc_process_effectivity
93: where plan_id = arg_plan_id
94: and process_sequence_id = arg_process_sequence_id
95: and sr_instance_id = arg_sr_instance_id
96: and organization_id = arg_organization_id

Line 3376: msc_process_effectivity eff

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

Line 3406: msc_process_effectivity eff

3402: p_sr_instance_id number) return varchar2 is
3403: CURSOR ALT_RTG_C IS
3404: SELECT rt.alternate_routing_designator
3405: FROM msc_routings rt,
3406: msc_process_effectivity eff
3407: WHERE rt.plan_id = eff.plan_id
3408: AND rt.sr_instance_id = eff.sr_instance_id
3409: AND rt.routing_sequence_id = eff.routing_sequence_id
3410: AND eff.plan_id=p_plan_id