Product: | IBC - Content Manager |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IBC_CITEM_LIVE_V |
SELECT CI.CONTENT_ITEM_ID
, CI.ITEM_REFERENCE_CODE
, CI.CONTENT_TYPE_CODE
, CI.PARENT_ITEM_ID
, CTT.CONTENT_TYPE_NAME
, CI.WD_RESTRICTED_FLAG
, CI.TRANSLATION_REQUIRED_FLAG
, CI.OWNER_RESOURCE_ID
, CI.OWNER_RESOURCE_TYPE
, CVB.CITEM_VERSION_ID
, CVB.VERSION_NUMBER
, CVB.CITEM_VERSION_STATUS
, CVB.START_DATE
, CVB.END_DATE
, CVT.LANGUAGE
, CVT.ATTRIBUTE_FILE_ID
, CVT.ATTACHMENT_FILE_ID
, CI.OBJECT_VERSION_NUMBER
, CVT.ATTACHMENT_FILE_NAME
, CVT.CONTENT_ITEM_NAME
, CVT.DESCRIPTION
, CVT.SOURCE_LANG
FROM IBC_CONTENT_ITEMS CI
, IBC_CONTENT_TYPES_TL CTT
, IBC_CITEM_VERSIONS_B CVB
, IBC_CITEM_VERSIONS_TL CVT
WHERE CI.CONTENT_ITEM_ID = CVB.CONTENT_ITEM_ID
AND CI.LIVE_CITEM_VERSION_ID = CVB.CITEM_VERSION_ID
AND CI.CONTENT_TYPE_CODE = CTT.CONTENT_TYPE_CODE
AND CVB.CITEM_VERSION_ID = CVT.CITEM_VERSION_ID
AND CVT.LANGUAGE = CTT.LANGUAGE