VIEW: APPS.GCS_CATEGORIES_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')