APPS.MSC_WS_ASCP dependencies on MFG_LOOKUPS

Line 108: FROM mfg_lookups

104: -- validate launchSnapshot
105: BEGIN
106: SELECT lookup_code
107: INTO l_val_launchsnapshot
108: FROM mfg_lookups
109: WHERE lookup_type = 'MSC_LAUNCH_SNAPSHOT'
110: AND lookup_code in decode(lookup_code,1,1,2,2,3,
111: decode((select count(*) from msc_plan_schedules
112: where plan_id = planId

Line 130: FROM MFG_LOOKUPS

126: error_tracking_num := 1050;
127: BEGIN
128: SELECT lookup_code
129: INTO l_val_launchplanner
130: FROM MFG_LOOKUPS
131: WHERE lookup_type = 'SYS_YES_NO'
132: AND ((lookup_code = 1 AND l_val_launchsnapshot in (1,3,4)) OR
133: (l_val_launchsnapshot = 2))
134: AND lookup_code = decode(launchplanner, 'Y', msc_ws_common.sys_yes, msc_ws_common.sys_no);

Line 169: FROM MFG_LOOKUPS

165: -- validating enable24x7atp
166: BEGIN
167: SELECT lookup_code
168: INTO l_val_enable24x7atp
169: FROM MFG_LOOKUPS
170: WHERE LOOKUP_TYPE = 'MSC_24X7_PURGE'
171: AND (( LOOKUP_CODE IN (1,2,3) and NVL(l_val_inventory_atp_flag,2) = 1 )
172: OR LOOKUP_CODE=2)
173: AND LOOKUP_CODE = decode(enable24x7atp,'YES_PURGE',1,'NO',2,'YES_NO_PURGE',3,-1);

Line 196: FROM MFG_LOOKUPS

192: -- validating releasereschedules
193: BEGIN
194: SELECT lookup_code
195: INTO l_val_releasereschedules
196: FROM MFG_LOOKUPS
197: WHERE lookup_type='SYS_YES_NO'
198: AND (NVL(l_val_production,2)=1 or lookup_code=2)
199: AND lookup_code = decode(releasereschedules,'Y',msc_ws_common.sys_yes, msc_ws_common.sys_no);
200: EXCEPTION