Product: | IBC - Content Manager |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IBC_CONTENT_ITEMS_V |
SELECT 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
FROM IBC_CONTENT_ITEMS CI
, IBC_CONTENT_TYPES_TL CTTL
, IBC_CITEM_VERSIONS_B CVB
, IBC_CITEM_VERSIONS_TL CVTL
WHERE CI.CONTENT_ITEM_ID = CVB.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