APPS.MSC_BI2EBS_PKG dependencies on MFG_LOOKUPS

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

109: and plan_id = p_plan_id;
110:
111: cursor c_res_id (p_plan_id number, p_res_name varchar2) is
112: SELECT unique MDR.RESOURCE_ID
113: FROM MSC_DEPARTMENT_RESOURCES MDR, MFG_LOOKUPS ML1,MFG_LOOKUPS ML2
114: where MDR.RESOURCE_CODE = p_res_name
115: and mdr.plan_id =p_plan_id
116: and ML1.LOOKUP_CODE = nvl(MDR.BOTTLENECK_FLAG,2)
117: AND ML1.LOOKUP_TYPE = 'SYS_YES_NO'

Line 122: SELECT lookup_code exception_type_id FROM mfg_lookups

118: AND ML2.LOOKUP_CODE = MDR.RESOURCE_TYPE
119: AND ML2.LOOKUP_TYPE = 'BOM_RESOURCE_TYPE';
120:
121: cursor c_exp_id (p_exp_name varchar2) is
122: SELECT lookup_code exception_type_id FROM mfg_lookups
123: WHERE lookup_type = 'MRP_EXCEPTION_CODE_TYPE'
124: and lookup_code not in (101,102,103,104)
125: and meaning =p_exp_name;
126: