APPS.MSC_WS_DRP dependencies on MFG_LOOKUPS

Line 117: FROM MFG_LOOKUPS

113: -- validate launchPlanner
114: BEGIN
115: SELECT lookup_code
116: INTO l_val_launchPlanner
117: FROM MFG_LOOKUPS
118: WHERE lookup_type = 'SYS_YES_NO'
119: AND ((lookup_code = 1 AND l_val_launchSnapshot = 1) OR
120: (l_val_launchSnapshot = 2))
121: AND lookup_code = decode(launchPlanner, 'Y', msc_ws_common.sys_yes, msc_ws_common.sys_no);

Line 156: FROM MFG_LOOKUPS

152: -- validating enable24x7atp
153: BEGIN
154: SELECT lookup_code
155: INTO l_val_enable24x7Atp
156: FROM MFG_LOOKUPS
157: WHERE LOOKUP_TYPE = 'MSC_24X7_PURGE'
158: AND (( LOOKUP_CODE IN (1,2,3) and NVL(l_val_inventory_atp_flag,2) = 1 )
159: OR LOOKUP_CODE=2)
160: AND LOOKUP_CODE = decode(enable24x7atp,'YES_PURGE',1,'NO',2,'YES_NO_PURGE',3,-1);

Line 181: FROM MFG_LOOKUPS

177: -- validating releaseReschedules
178: BEGIN
179: SELECT lookup_code
180: INTO l_val_releaseReschedules
181: FROM MFG_LOOKUPS
182: WHERE lookup_type='SYS_YES_NO'
183: AND (NVL(l_val_production,2)=1 or lookup_code=2)
184: AND lookup_code = decode(releaseReschedules,'Y',msc_ws_common.sys_yes, msc_ws_common.sys_no);
185: EXCEPTION