VIEW: APPS.IBC_CITEM_LABELS_V

Source

View Text - Preformatted

SELECT CVL.LABEL_CODE, CI.CONTENT_ITEM_ID, CI.CONTENT_ITEM_STATUS, CI.CONTENT_TYPE_CODE, CI.ITEM_REFERENCE_CODE, CI.DIRECTORY_NODE_ID, CI.PARENT_ITEM_ID, CI.LIVE_CITEM_VERSION_ID, CI.LOCKED_BY_USER_ID, CI.WD_RESTRICTED_FLAG, CI.BASE_LANGUAGE, CI.TRANSLATION_REQUIRED_FLAG, CI.OWNER_RESOURCE_ID, CI.OWNER_RESOURCE_TYPE, CI.APPLICATION_ID, CI.CREATED_BY, CI.CREATION_DATE, CI.LAST_UPDATED_BY, CI.LAST_UPDATE_DATE, CI.LAST_UPDATE_LOGIN, CI.REQUEST_ID, CI.PROGRAM_UPDATE_DATE, CI.PROGRAM_APPLICATION_ID, CI.PROGRAM_ID, CI.OBJECT_VERSION_NUMBER, CI.SECURITY_GROUP_ID, CVB.CITEM_VERSION_ID, CVB.VERSION_NUMBER, CVB.CITEM_VERSION_STATUS, CVB.CREATED_BY, CVB.CREATION_DATE, CVB.LAST_UPDATED_BY, CVB.LAST_UPDATE_DATE, CVB.LAST_UPDATE_LOGIN, CVB.START_DATE, CVB.END_DATE, CVTL.CONTENT_ITEM_NAME, CVTL.DESCRIPTION, CVTL.LANGUAGE, CTTL.CONTENT_TYPE_NAME, CVTL.ATTRIBUTE_FILE_ID, CVTL.ATTACHMENT_FILE_ID, CVTL.ATTACHMENT_FILE_NAME, CVTL.SOURCE_LANG FROM IBC_CONTENT_ITEMS CI, IBC_CONTENT_TYPES_TL CTTL, IBC_CITEM_VERSIONS_B CVB, IBC_CITEM_VERSIONS_TL CVTL, IBC_CITEM_VERSION_LABELS CVL WHERE CVL.content_item_id = CVB.content_item_id AND CVL.citem_version_id = CVB.citem_version_id AND CVB.content_item_id = CI.content_item_id AND CI.content_type_code = CTTL.content_type_code AND CVB.citem_version_id = CVTL.citem_version_id AND CVTL.LANGUAGE = CTTL.LANGUAGE

View Text - HTML Formatted

SELECT CVL.LABEL_CODE
, CI.CONTENT_ITEM_ID
, CI.CONTENT_ITEM_STATUS
, CI.CONTENT_TYPE_CODE
, CI.ITEM_REFERENCE_CODE
, CI.DIRECTORY_NODE_ID
, CI.PARENT_ITEM_ID
, CI.LIVE_CITEM_VERSION_ID
, CI.LOCKED_BY_USER_ID
, CI.WD_RESTRICTED_FLAG
, CI.BASE_LANGUAGE
, CI.TRANSLATION_REQUIRED_FLAG
, CI.OWNER_RESOURCE_ID
, CI.OWNER_RESOURCE_TYPE
, CI.APPLICATION_ID
, CI.CREATED_BY
, CI.CREATION_DATE
, CI.LAST_UPDATED_BY
, CI.LAST_UPDATE_DATE
, CI.LAST_UPDATE_LOGIN
, CI.REQUEST_ID
, CI.PROGRAM_UPDATE_DATE
, CI.PROGRAM_APPLICATION_ID
, CI.PROGRAM_ID
, CI.OBJECT_VERSION_NUMBER
, CI.SECURITY_GROUP_ID
, CVB.CITEM_VERSION_ID
, CVB.VERSION_NUMBER
, CVB.CITEM_VERSION_STATUS
, CVB.CREATED_BY
, CVB.CREATION_DATE
, CVB.LAST_UPDATED_BY
, CVB.LAST_UPDATE_DATE
, CVB.LAST_UPDATE_LOGIN
, CVB.START_DATE
, CVB.END_DATE
, CVTL.CONTENT_ITEM_NAME
, CVTL.DESCRIPTION
, CVTL.LANGUAGE
, CTTL.CONTENT_TYPE_NAME
, CVTL.ATTRIBUTE_FILE_ID
, CVTL.ATTACHMENT_FILE_ID
, CVTL.ATTACHMENT_FILE_NAME
, CVTL.SOURCE_LANG
FROM IBC_CONTENT_ITEMS CI
, IBC_CONTENT_TYPES_TL CTTL
, IBC_CITEM_VERSIONS_B CVB
, IBC_CITEM_VERSIONS_TL CVTL
, IBC_CITEM_VERSION_LABELS CVL
WHERE CVL.CONTENT_ITEM_ID = CVB.CONTENT_ITEM_ID
AND CVL.CITEM_VERSION_ID = CVB.CITEM_VERSION_ID
AND CVB.CONTENT_ITEM_ID = CI.CONTENT_ITEM_ID
AND CI.CONTENT_TYPE_CODE = CTTL.CONTENT_TYPE_CODE
AND CVB.CITEM_VERSION_ID = CVTL.CITEM_VERSION_ID
AND CVTL.LANGUAGE = CTTL.LANGUAGE