View: ASO_APR_RULE_STEPS_VL

View Text

SELECT B.ROWID ROW_ID
, B.ASO_APR_RULE_STEP_ID
, B.ASO_APR_RULE_ID
, B.LOGICAL_OPERATOR
, B.PREFIX
, B.LHS_OPERAND_TYPE
, DECODE(LHS_OPERAND_TYPE
, 'ATTRIBUTE'
, AOA.COLUMN_NAME
, 'FUNCTION'
, F.PACKAGE_NAME||'.' ||F.FUNCTION_NAME
, NULL) LHS_ATTRIBUTE_FUNCTION
, DECODE(LHS_OPERAND_TYPE
, 'ATTRIBUTE'
, AA.DATA_TYPE
, 'FUNCTION'
, F.RETURN_DATATYPE
, NULL) LHS_DATA_TYPE
, B.LHS_AK_OBJECT
, B.LHS_AK_ATTRIBUTE_CODE
, B.LHS_AK_ATTR_APPLIC_ID
, B.LHS_FUNCTION_ID
, B.RELATIONAL_OPERATOR
, B.RHS_OPERAND_TYPE
, DECODE(RHS_OPERAND_TYPE
, 'ATTRIBUTE'
, AOA1.COLUMN_NAME
, 'FUNCTION'
, F1.PACKAGE_NAME||'.' ||F1.FUNCTION_NAME
, NULL) RHS_ATTRIBUTE_FUNCTION
, DECODE(RHS_OPERAND_TYPE
, 'ATTRIBUTE'
, AA1.DATA_TYPE
, 'FUNCTION'
, F1.RETURN_DATATYPE
, NULL) RHS_DATA_TYPE
, B.RHS_AK_OBJECT
, B.RHS_AK_ATTRIBUTE_CODE
, B.RHS_AK_ATTR_APPLIC_ID
, B.RHS_FUNCTION_ID
, B.RHS_NUM_CONST
, B.RHS_DATE_CONST
, B.RHS_CHAR_CONST
, B.SUFFIX
, B.CASE_SENSITIVE_FLAG
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.CONTEXT
, T.RHS_CHAR_TL_CONST
, RB.AK_OBJECT
, RT.NAME
, RT.DESCRIPTION
, AOA.COLUMN_NAME
, AOA.TABLE_NAME
, AOA.BASE_TABLE_COLUMN_NAME
, AA.NAME
, AA.DATA_TYPE
, AOA1.COLUMN_NAME
, AOA1.TABLE_NAME
, AOA1.BASE_TABLE_COLUMN_NAME
, AA1.NAME
, AA1.DATA_TYPE
, F.FUNCTION_NAME
, F.PACKAGE_NAME
, F.RETURN_DATATYPE
, F.USER_FUNCTION_NAME
, F.DESCRIPTION
, F1.FUNCTION_NAME
, F1.PACKAGE_NAME
, F1.RETURN_DATATYPE
, F.USER_FUNCTION_NAME
, F.DESCRIPTION
FROM ASO_APR_RULE_STEPS_TL T
, ASO_APR_RULE_STEPS_B B
, ASO_APR_RULES_B RB
, ASO_APR_RULES_TL RT
, AK_OBJECT_ATTRIBUTES AOA
, AK_ATTRIBUTES_VL AA
, ASO_APR_FUNCTION_VL F
, AK_OBJECT_ATTRIBUTES AOA1
, AK_ATTRIBUTES_VL AA1
, ASO_APR_FUNCTION_VL F1
WHERE B.ASO_APR_RULE_STEP_ID = T.ASO_APR_RULE_STEP_ID
AND T.LANGUAGE = USERENV('LANG')
AND B.ASO_APR_RULE_ID = RB.ASO_APR_RULE_ID
AND RB.ASO_APR_RULE_ID = RT.ASO_APR_RULE_ID
AND RT.LANGUAGE = USERENV('LANG')
AND B.LHS_AK_OBJECT = AOA.DATABASE_OBJECT_NAME (+)
AND B.LHS_AK_ATTRIBUTE_CODE = AOA.ATTRIBUTE_CODE (+)
AND B.LHS_AK_ATTR_APPLIC_ID = AOA.ATTRIBUTE_APPLICATION_ID (+)
AND AOA.ATTRIBUTE_CODE = AA.ATTRIBUTE_CODE (+)
AND AOA.ATTRIBUTE_APPLICATION_ID = AA.ATTRIBUTE_APPLICATION_ID (+)
AND B.LHS_FUNCTION_ID = F.ASO_APR_FUNCTION_ID (+)
AND B.RHS_AK_OBJECT = AOA1.DATABASE_OBJECT_NAME (+)
AND B.RHS_AK_ATTRIBUTE_CODE = AOA1.ATTRIBUTE_CODE (+)
AND B.RHS_AK_ATTR_APPLIC_ID = AOA1.ATTRIBUTE_APPLICATION_ID (+)
AND AOA1.ATTRIBUTE_CODE = AA1.ATTRIBUTE_CODE (+)
AND AOA1.ATTRIBUTE_APPLICATION_ID = AA1.ATTRIBUTE_APPLICATION_ID (+)
AND B.RHS_FUNCTION_ID = F1.ASO_APR_FUNCTION_ID (+)

Columns