DBA Data[Home] [Help]

VIEW: APPS.GCS_ELIM_RULE_STEPS_VL

Source

View Text - Preformatted

SELECT B.RULE_STEP_ID, B.RULE_ID, B.STEP_SEQ, B.FORMULA_TEXT, B.PARSED_FORMULA, B.COMPILED_VARIABLES, B.SQL_STATEMENT_NUM, TL.STEP_NAME, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER FROM GCS_ELIM_RULE_STEPS_B B, GCS_ELIM_RULE_STEPS_TL TL WHERE TL.RULE_STEP_ID = B.RULE_STEP_ID AND TL.LANGUAGE = USERENV('LANG')
View Text - HTML Formatted

SELECT B.RULE_STEP_ID
, B.RULE_ID
, B.STEP_SEQ
, B.FORMULA_TEXT
, B.PARSED_FORMULA
, B.COMPILED_VARIABLES
, B.SQL_STATEMENT_NUM
, TL.STEP_NAME
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
FROM GCS_ELIM_RULE_STEPS_B B
, GCS_ELIM_RULE_STEPS_TL TL
WHERE TL.RULE_STEP_ID = B.RULE_STEP_ID
AND TL.LANGUAGE = USERENV('LANG')