APPS.MSC_BI2EBS_PKG dependencies on MFG_LOOKUPS

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 138: SELECT lookup_code exception_type_id FROM mfg_lookups

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
138: SELECT lookup_code exception_type_id FROM mfg_lookups
139: WHERE lookup_type = 'MRP_EXCEPTION_CODE_TYPE'
140: and lookup_code not in (101,102,103,104)
141: and meaning =p_exp_name;
142: