VIEW: APPS.BIL_TX_OPTY_STATUS_V

Source

View Text - Preformatted

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'