DBA Data[Home] [Help]

APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on MFG_LOOKUPS

Line 298: FROM mfg_lookups

294: IS
295: BEGIN
296: SELECT REPLACE (meaning, '''', ''''''), meaning
297: BULK COLLECT INTO g_status_codes, g_status_codes_orig
298: FROM mfg_lookups
299: WHERE lookup_type = 'WMS_TASK_STATUS'
300: ORDER BY lookup_code;
301: END;
302:

Line 308: FROM mfg_lookups

304: IS
305: BEGIN
306: SELECT REPLACE (meaning, '''', ''''''), meaning
307: BULK COLLECT INTO g_task_types, g_task_types_orig
308: FROM mfg_lookups
309: WHERE lookup_type = 'WMS_TASK_TYPES'
310: ORDER BY lookup_code;
311: END;
312:

Line 319: FROM mfg_lookups

315: IS
316: BEGIN
317: SELECT REPLACE (meaning, '''', '''''')
318: BULK COLLECT INTO g_plan_task_types
319: FROM mfg_lookups
320: WHERE lookup_type = 'WMS_PLAN_TASK_TYPES'
321: ORDER BY lookup_code;
322: END set_plan_task_types;
323:

Line 329: FROM mfg_lookups

325: IS
326: BEGIN
327: SELECT REPLACE (meaning, '''', '''''')
328: BULK COLLECT INTO g_plan_status_codes
329: FROM mfg_lookups
330: WHERE lookup_type = 'WMS_OP_PLAN_INSTANCE_STATUS'
331: ORDER BY lookup_code;
332: END;
333: