[Home] [Help]
| Product: | GCS - Financial Consolidation Hub (Obsolete) |
|---|---|
| Description: | Currency treatments information |
| Implementation/DBA Data: | Not implemented in this database |
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')