DBA Data[Home] [Help]

APPS.WMS_ZONES_PVT dependencies on MFG_LOOKUPS

Line 29: TYPE lookup_meaning_table IS TABLE OF mfg_lookups.meaning%TYPE

25: *
26: */
27: g_initialized BOOLEAN := FALSE;
28:
29: TYPE lookup_meaning_table IS TABLE OF mfg_lookups.meaning%TYPE
30: INDEX BY BINARY_INTEGER;
31:
32: TYPE locator_status_table IS TABLE OF mtl_material_statuses.status_code%TYPE
33: INDEX BY BINARY_INTEGER;

Line 83: FROM mfg_lookups

79: BEGIN
80:
81: SELECT meaning BULK COLLECT
82: INTO g_locator_types
83: FROM mfg_lookups
84: WHERE lookup_type = 'MTL_LOCATOR_TYPES'
85: ORDER BY lookup_code;
86:
87: END set_locator_types;

Line 94: FROM mfg_lookups

90: BEGIN
91:
92: SELECT meaning BULK COLLECT
93: INTO g_subinventory_types
94: FROM mfg_lookups
95: WHERE lookup_type = 'MTL_SUB_TYPES'
96: ORDER BY lookup_code;
97:
98: END;