DBA Data[Home] [Help]

APPS.WMS_CONTROL_BOARD dependencies on MFG_LOOKUPS

Line 63: FROM mfg_lookups

59: i := 1;
60: LOOP
61: SELECT meaning
62: INTO l_temp_status_code
63: FROM mfg_lookups
64: WHERE lookup_type = 'WMS_TASK_STATUS'
65: AND lookup_code = i;
66: l_status_code_table(i) := l_temp_status_code;
67: EXIT WHEN i = 7;

Line 228: FROM mfg_lookups

224: l_loop_index := 1;
225: LOOP
226: SELECT meaning
227: INTO l_temp_task_type
228: FROM mfg_lookups
229: WHERE lookup_type = 'WMS_TASK_TYPES'
230: AND lookup_code = l_loop_index;
231: l_task_type_table(l_loop_index) := l_temp_task_type;
232: EXIT WHEN l_loop_index = 6;

Line 883: from mfg_lookups mlk1, mfg_lookups mlk2

879: --dbms_output.put_line('in task_mani');
880:
881: /*select mlk1.meaning, mlk2.meaning
882: into from_status_code, to_status_code
883: from mfg_lookups mlk1, mfg_lookups mlk2
884: where mlk1.lookup_type = 'WMS_TASK_TYPES'
885: and mlk2.lookup_type = 'WMS_TASK_TYPES'
886: and mlk1.lookup_code = from_status
887: and mlk2.lookup_code = to_status;*/