VIEW: APPS.OKL_ACCRUAL_GNRTNS_UV

Source

View Text - Preformatted

SELECT AGN.ID ID, AGN.LINE_NUMBER LINE_NUMBER, AGN.VERSION VERSION, AGN.ARO_CODE ARO_CODE, AGN.ARLO_CODE ARLO_CODE, AGN.ACRO_CODE ACRO_CODE, AGN.RIGHT_OPERAND_LITERAL RIGHT_OPERAND_LITERAL, AGN.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, AGN.LEFT_PARENTHESES LEFT_PARENTHESES, AGN.RIGHT_PARENTHESES RIGHT_PARENTHESES, AGN.FROM_DATE FROM_DATE, AGN.TO_DATE TO_DATE, AGN.ORG_ID ORG_ID, AGN.CREATED_BY CREATED_BY, AGN.CREATION_DATE CREATION_DATE, AGN.LAST_UPDATED_BY LAST_UPDATED_BY, AGN.LAST_UPDATE_DATE LAST_UPDATE_DATE, AGN.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_ACCRUAL_RULE_OPERAND', AGN.ARO_CODE) OPERAND_MEANING, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_ACCRUAL_RULE_LOGICAL_OP', AGN.ARLO_CODE) LOGICAL_OP_MEANING, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_ACCRUAL_RULE_OPERATOR', AGN.ACRO_CODE) RELATIONAL_OP_MEANING, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_PARENTHESIS', AGN.LEFT_PARENTHESES) LEFT_PARENTHESES_MEANING, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_PARENTHESIS', AGN.RIGHT_PARENTHESES) RIGHT_PARENTHESES_MEANING FROM OKL_ACCRUAL_GNRTNS AGN

View Text - HTML Formatted

SELECT AGN.ID ID
, AGN.LINE_NUMBER LINE_NUMBER
, AGN.VERSION VERSION
, AGN.ARO_CODE ARO_CODE
, AGN.ARLO_CODE ARLO_CODE
, AGN.ACRO_CODE ACRO_CODE
, AGN.RIGHT_OPERAND_LITERAL RIGHT_OPERAND_LITERAL
, AGN.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, AGN.LEFT_PARENTHESES LEFT_PARENTHESES
, AGN.RIGHT_PARENTHESES RIGHT_PARENTHESES
, AGN.FROM_DATE FROM_DATE
, AGN.TO_DATE TO_DATE
, AGN.ORG_ID ORG_ID
, AGN.CREATED_BY CREATED_BY
, AGN.CREATION_DATE CREATION_DATE
, AGN.LAST_UPDATED_BY LAST_UPDATED_BY
, AGN.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AGN.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_ACCRUAL_RULE_OPERAND'
, AGN.ARO_CODE) OPERAND_MEANING
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_ACCRUAL_RULE_LOGICAL_OP'
, AGN.ARLO_CODE) LOGICAL_OP_MEANING
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_ACCRUAL_RULE_OPERATOR'
, AGN.ACRO_CODE) RELATIONAL_OP_MEANING
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_PARENTHESIS'
, AGN.LEFT_PARENTHESES) LEFT_PARENTHESES_MEANING
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_PARENTHESIS'
, AGN.RIGHT_PARENTHESES) RIGHT_PARENTHESES_MEANING
FROM OKL_ACCRUAL_GNRTNS AGN