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_X_USER_EXCEP_GEN dependencies on MSC_PLANNERS

Line 3107: from msc_planners pl,

3103: lNtfId Number;
3104: cursor planner_c(p_item IN VARCHAR2) is
3105: select distinct pl.user_name,
3106: pl.planner_code
3107: from msc_planners pl,
3108: msc_system_items itm
3109: where itm.plan_id = -1
3110: --and itm.organization_id = p_organization_id
3111: and itm.item_name = p_item

Line 3120: from msc_planners pl,

3116: --if item and org are there
3117: cursor planner_c1(p_item IN VARCHAR2,p_org IN VARCHAR2) is
3118: select distinct pl.user_name,
3119: pl.planner_code
3120: from msc_planners pl,
3121: msc_system_items itm,
3122: msc_trading_partners mtp
3123: where itm.plan_id = -1
3124: and itm.organization_id = pl.organization_id

Line 3138: from msc_planners pl,

3134:
3135: cursor planner_c2(p_item IN VARCHAR2) is
3136: select distinct pl.user_name,
3137: pl.planner_code
3138: from msc_planners pl,
3139: msc_system_items itm,
3140: msc_trading_partners mtp
3141: where itm.plan_id = -1
3142: and itm.organization_id = pl.organization_id