VIEW: APPS.GCS_INTERCO_RULES_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.RULE_ID, B.ENABLED_FLAG, B.THRESHOLD_AMOUNT, B.THRESHOLD_CURRENCY, B.OBJECT_VERSION_NUMBER, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_LOGIN, B.SUS_FINANCIAL_ELEM_ID, B.SUS_PRODUCT_ID, B.SUS_NATURAL_ACCOUNT_ID, B.SUS_CHANNEL_ID, B.SUS_LINE_ITEM_ID, B.SUS_PROJECT_ID, B.SUS_CUSTOMER_ID, B.sus_task_id, B.SUS_USER_DIM1_ID, B.SUS_USER_DIM2_ID, B.SUS_USER_DIM3_ID, B.SUS_USER_DIM4_ID, B.SUS_USER_DIM5_ID, B.SUS_USER_DIM6_ID, B.SUS_USER_DIM7_ID, B.SUS_USER_DIM8_ID, B.SUS_USER_DIM9_ID, B.SUS_USER_DIM10_ID, T.RULE_NAME, T.DESCRIPTION FROM GCS_INTERCO_RULES_B B, GCS_INTERCO_RULES_TL T WHERE B.RULE_ID = T.RULE_ID AND T.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.RULE_ID
, B.ENABLED_FLAG
, B.THRESHOLD_AMOUNT
, B.THRESHOLD_CURRENCY
, B.OBJECT_VERSION_NUMBER
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.SUS_FINANCIAL_ELEM_ID
, B.SUS_PRODUCT_ID
, B.SUS_NATURAL_ACCOUNT_ID
, B.SUS_CHANNEL_ID
, B.SUS_LINE_ITEM_ID
, B.SUS_PROJECT_ID
, B.SUS_CUSTOMER_ID
, B.SUS_TASK_ID
, B.SUS_USER_DIM1_ID
, B.SUS_USER_DIM2_ID
, B.SUS_USER_DIM3_ID
, B.SUS_USER_DIM4_ID
, B.SUS_USER_DIM5_ID
, B.SUS_USER_DIM6_ID
, B.SUS_USER_DIM7_ID
, B.SUS_USER_DIM8_ID
, B.SUS_USER_DIM9_ID
, B.SUS_USER_DIM10_ID
, T.RULE_NAME
, T.DESCRIPTION
FROM GCS_INTERCO_RULES_B B
, GCS_INTERCO_RULES_TL T
WHERE B.RULE_ID = T.RULE_ID
AND T.LANGUAGE = USERENV('LANG')