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_BI2EBS_PKG dependencies on MSC_DEPARTMENT_RESOURCES

Line 123: FROM MSC_DEPARTMENT_RESOURCES MDR, MFG_LOOKUPS ML1,MFG_LOOKUPS ML2

119: and plan_id = p_plan_id;
120:
121: cursor c_res_id (p_plan_id number, p_res_name varchar2) is
122: SELECT unique MDR.RESOURCE_ID
123: FROM MSC_DEPARTMENT_RESOURCES MDR, MFG_LOOKUPS ML1,MFG_LOOKUPS ML2
124: where MDR.RESOURCE_CODE = p_res_name
125: and mdr.plan_id =p_plan_id
126: and ML1.LOOKUP_CODE = nvl(MDR.BOTTLENECK_FLAG,2)
127: AND ML1.LOOKUP_TYPE = 'SYS_YES_NO'

Line 133: FROM MSC_DEPARTMENT_RESOURCES MDR

129: AND ML2.LOOKUP_TYPE = 'BOM_RESOURCE_TYPE';
130:
131: cursor c_dept_id (p_plan_id number, p_dept_name varchar2) is
132: SELECT unique MDR.department_id
133: FROM MSC_DEPARTMENT_RESOURCES MDR
134: where MDR.RESOURCE_CODE = p_dept_name
135: and mdr.plan_id =p_plan_id;
136:
137: cursor c_exp_id (p_exp_name varchar2) is