APPS.CTO_WORKBENCH_UTIL_PK dependencies on MFG_LOOKUPS

Line 194: from mfg_lookups

190: IF (l_result <> 0) THEN
191: l_result := 7;
192: select meaning
193: into x_result
194: from mfg_lookups
195: where lookup_type = 'CTO_WB_SUPPLY_TYPE'
196: and lookup_code = l_result;
197:
198: return x_result;

Line 206: from mfg_lookups

202: END IF;
203:
204: select meaning
205: into x_result
206: from mfg_lookups
207: where lookup_type = 'CTO_WB_SUPPLY_TYPE'
208: and lookup_code = l_result;
209:
210: --

Line 246: from mfg_lookups

242: IF (l_result <> 0) THEN
243: l_result := 7;
244: select meaning
245: into x_result
246: from mfg_lookups
247: where lookup_type = 'CTO_WB_SUPPLY_TYPE'
248: and lookup_code = l_result;
249:
250: return x_result;

Line 270: from mfg_lookups

266: IF (l_result <> 0) THEN
267: l_result := 7;
268: select meaning
269: into x_result
270: from mfg_lookups
271: where lookup_type = 'CTO_WB_SUPPLY_TYPE'
272: and lookup_code = l_result;
273:
274: return x_result;

Line 294: from mfg_lookups

290: IF (l_result <> 0) THEN
291: l_result := 7;
292: select meaning
293: into x_result
294: from mfg_lookups
295: where lookup_type = 'CTO_WB_SUPPLY_TYPE'
296: and lookup_code = l_result;
297:
298: return x_result;

Line 319: from mfg_lookups

315: IF (l_result <> 0) THEN
316: l_result := 7;
317: select meaning
318: into x_result
319: from mfg_lookups
320: where lookup_type = 'CTO_WB_SUPPLY_TYPE'
321: and lookup_code = l_result;
322:
323: return x_result;

Line 344: from mfg_lookups

340: IF (l_result <> 0) THEN
341: l_result := 7;
342: select meaning
343: into x_result
344: from mfg_lookups
345: where lookup_type = 'CTO_WB_SUPPLY_TYPE'
346: and lookup_code = l_result;
347:
348: return x_result;

Line 356: from mfg_lookups

352: END IF;
353:
354: select meaning
355: into x_result
356: from mfg_lookups
357: where lookup_type = 'CTO_WB_SUPPLY_TYPE'
358: and lookup_code = l_result;
359:
360: END IF; /* internal source type */