Product: | GCS - Financial Consolidation Hub |
---|---|
Description: | Categories information. |
Implementation/DBA Data: | APPS.GCS_CATEGORIES_VL |
SELECT B.CATEGORY_CODE CATEGORY_CODE
, B.GL_CATEGORY_CODE GL_CATEGORY_CODE
, B.CATEGORY_NUMBER CATEGORY_NUMBER
, B.NET_TO_RE_FLAG NET_TO_RE_FLAG
, B.TARGET_ENTITY_CODE TARGET_ENTITY_CODE
, B.CATEGORY_TYPE_CODE CATEGORY_TYPE_CODE
, B.ASSOCIATED_OBJECT_ID ASSOCIATED_OBJECT_ID
, B.ORG_OUTPUT_CODE ORG_OUTPUT_CODE
, B.SUPPORT_MULTI_PARENTS_FLAG SUPPORT_MULTI_PARENTS_FLAG
, B.ENABLED_FLAG ENABLED_FLAG
, B.SPECIFIC_INTERCOMPANY_ID SPECIFIC_INTERCOMPANY_ID
, B.CREATION_DATE CREATION_DATE
, B.CREATED_BY CREATED_BY
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, T.CATEGORY_NAME CATEGORY_NAME
, T.DESCRIPTION DESCRIPTION
FROM GCS_CATEGORIES_B B
, GCS_CATEGORIES_TL T
WHERE B.CATEGORY_CODE = T.CATEGORY_CODE
AND T.LANGUAGE = USERENV('LANG')