APPS.AHL_RA_SETUPS_PVT dependencies on MTL_MATERIAL_STATUSES_VL

Line 126: FROM MTL_MATERIAL_STATUSES_VL

122: IF l_setup_data_rec.SETUP_CODE = 'ITEM_STATUS' THEN
123: BEGIN
124: SELECT STATUS_CODE
125: INTO l_code
126: FROM MTL_MATERIAL_STATUSES_VL
127: WHERE STATUS_ID = l_setup_data_rec.STATUS_ID;
128:
129: FND_MESSAGE.Set_Name('AHL','AHL_RA_DUP_STATUS_CODE');
130: FND_MESSAGE.Set_Token('ITEM_STATUS',l_code);

Line 179: FROM MTL_MATERIAL_STATUSES_VL

175: SELECT 'X'
176: INTO l_dummy
177: FROM DUAL
178: WHERE EXISTS (SELECT 1
179: FROM MTL_MATERIAL_STATUSES_VL
180: WHERE STATUS_ID = l_setup_data_rec.STATUS_ID);
181:
182: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
183: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Valid Status Id Passed. -- CONTINUE ... ' || l_setup_data_rec.STATUS_ID);