DBA Data[Home] [Help]

APPS.MSC_WS_SRP dependencies on MFG_LOOKUPS

Line 109: FROM mfg_lookups

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

Line 131: FROM MFG_LOOKUPS

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

Line 167: FROM MFG_LOOKUPS

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

Line 194: FROM MFG_LOOKUPS

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

Line 208: FROM MFG_LOOKUPS

204:
205: BEGIN
206: SELECT lookup_code
207: INTO l_val_generateForecast
208: FROM MFG_LOOKUPS
209: where lookup_type = 'SYS_YES_NO'
210: AND ( (l_val_launchplanner = 1 and lookup_code in (1,2) ) OR
211: (l_val_launchplanner = 2 and lookup_code in (1) ) )
212: AND lookup_code = decode(generateForecast, 'Y', msc_ws_common.sys_yes, msc_ws_common.sys_no);