SELECT asb.status_code , ast.meaning value FROM as_statuses_b asb, as_statuses_tl ast WHERE asb.status_code = ast.status_code AND ast.language= userenv('LANG') AND asb.enabled_flag = 'Y' AND asb.opp_flag = 'Y'
View Text - HTML Formatted
SELECT ASB.STATUS_CODE , AST.MEANING VALUE FROM AS_STATUSES_B ASB , AS_STATUSES_TL AST WHERE ASB.STATUS_CODE = AST.STATUS_CODE AND AST.LANGUAGE= USERENV('LANG') AND ASB.ENABLED_FLAG = 'Y' AND ASB.OPP_FLAG = 'Y'