227: SELECT
228: ML.MEANING
229: INTO STATUS_NAME
230: FROM
231: MFG_LOOKUPS ML
232: WHERE ML.LOOKUP_CODE = 6
233: AND ML.LOOKUP_TYPE = 'ECG_ECN_STATUS';
234: END IF;
235: ELSE
237: ML.MEANING
238: INTO STATUS_NAME
239: FROM
240: ENG_REVISED_ITEMS ERI,
241: MFG_LOOKUPS ML
242: WHERE ERI.REVISED_ITEM_SEQUENCE_ID = REVISED_ITEM_SEQUENCE_ID
243: AND ML.LOOKUP_CODE = ERI.STATUS_TYPE
244: AND ML.LOOKUP_TYPE = 'ECG_ECN_STATUS';
245: END IF;