VIEW: APPS.GCS_CURR_TREATMENTS_VL

Source

View Text - Preformatted

SELECT b.rowid ROW_ID, b.curr_treatment_id CURR_TREATMENT_ID, b.ending_rate_type ENDING_RATE_TYPE, b.average_rate_type AVERAGE_RATE_TYPE, b.equity_mode_code EQUITY_MODE_CODE, b.inc_stmt_mode_code INC_STMT_MODE_CODE, b.enabled_flag ENABLED_FLAG, b.default_flag DEFAULT_FLAG, b.last_update_date LAST_UPDATE_DATE, b.last_updated_by LAST_UPDATED_BY, b.creation_date CREATION_DATE, b.created_by CREATED_BY, b.last_update_login LAST_UPDATE_LOGIN, b.financial_elem_id FINANCIAL_ELEM_ID, b.product_id PRODUCT_ID, b.natural_account_id NATURAL_ACCOUNT_ID, b.channel_id CHANNEL_ID, b.line_item_id LINE_ITEM_ID, b.project_id PROJECT_ID, b.customer_id CUSTOMER_ID, b.cta_user_dim1_id CTA_USER_DIM1_ID, b.cta_user_dim2_id CTA_USER_DIM2_ID, b.cta_user_dim3_id CTA_USER_DIM3_ID, b.cta_user_dim4_id CTA_USER_DIM4_ID, b.cta_user_dim5_id CTA_USER_DIM5_ID, b.cta_user_dim6_id CTA_USER_DIM6_ID, b.cta_user_dim7_id CTA_USER_DIM7_ID, b.cta_user_dim8_id CTA_USER_DIM8_ID, b.cta_user_dim9_id CTA_USER_DIM9_ID, b.cta_user_dim10_id CTA_USER_DIM10_ID, b.task_id TASK_ID, b.object_version_number OBJECT_VERSION_NUMBER, t.curr_treatment_name CURR_TREATMENT_NAME, t.description DESCRIPTION FROM gcs_curr_treatments_b b, gcs_curr_treatments_tl t WHERE b.curr_treatment_id = t.curr_treatment_id AND t.language = USERENV('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.CURR_TREATMENT_ID CURR_TREATMENT_ID
, B.ENDING_RATE_TYPE ENDING_RATE_TYPE
, B.AVERAGE_RATE_TYPE AVERAGE_RATE_TYPE
, B.EQUITY_MODE_CODE EQUITY_MODE_CODE
, B.INC_STMT_MODE_CODE INC_STMT_MODE_CODE
, B.ENABLED_FLAG ENABLED_FLAG
, B.DEFAULT_FLAG DEFAULT_FLAG
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.CREATION_DATE CREATION_DATE
, B.CREATED_BY CREATED_BY
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, B.FINANCIAL_ELEM_ID FINANCIAL_ELEM_ID
, B.PRODUCT_ID PRODUCT_ID
, B.NATURAL_ACCOUNT_ID NATURAL_ACCOUNT_ID
, B.CHANNEL_ID CHANNEL_ID
, B.LINE_ITEM_ID LINE_ITEM_ID
, B.PROJECT_ID PROJECT_ID
, B.CUSTOMER_ID CUSTOMER_ID
, B.CTA_USER_DIM1_ID CTA_USER_DIM1_ID
, B.CTA_USER_DIM2_ID CTA_USER_DIM2_ID
, B.CTA_USER_DIM3_ID CTA_USER_DIM3_ID
, B.CTA_USER_DIM4_ID CTA_USER_DIM4_ID
, B.CTA_USER_DIM5_ID CTA_USER_DIM5_ID
, B.CTA_USER_DIM6_ID CTA_USER_DIM6_ID
, B.CTA_USER_DIM7_ID CTA_USER_DIM7_ID
, B.CTA_USER_DIM8_ID CTA_USER_DIM8_ID
, B.CTA_USER_DIM9_ID CTA_USER_DIM9_ID
, B.CTA_USER_DIM10_ID CTA_USER_DIM10_ID
, B.TASK_ID TASK_ID
, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, T.CURR_TREATMENT_NAME CURR_TREATMENT_NAME
, T.DESCRIPTION DESCRIPTION
FROM GCS_CURR_TREATMENTS_B B
, GCS_CURR_TREATMENTS_TL T
WHERE B.CURR_TREATMENT_ID = T.CURR_TREATMENT_ID
AND T.LANGUAGE = USERENV('LANG')