VIEW: APPS.CSC_PROF_CHECK_RULES_VL

Source

View Text - Preformatted

SELECT B.rowid ROW_ID , B.check_id , B.sequence , B.logical_operator , B.left_paren , B.block_id , B.comparison_operator , T.expression , B.expr_to_block_id , B.right_paren , B.created_by , B.creation_date , B.last_updated_by , B.last_update_date , B.last_update_login , B.object_version_number FROM csc_prof_check_rules_b B , csc_prof_check_rules_tl T WHERE B.check_id = T.check_id AND B.sequence = T.sequence AND T.language = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.CHECK_ID
, B.SEQUENCE
, B.LOGICAL_OPERATOR
, B.LEFT_PAREN
, B.BLOCK_ID
, B.COMPARISON_OPERATOR
, T.EXPRESSION
, B.EXPR_TO_BLOCK_ID
, B.RIGHT_PAREN
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
FROM CSC_PROF_CHECK_RULES_B B
, CSC_PROF_CHECK_RULES_TL T
WHERE B.CHECK_ID = T.CHECK_ID
AND B.SEQUENCE = T.SEQUENCE
AND T.LANGUAGE = USERENV('LANG')