VIEW: APPS.IBC_CITEM_LIVE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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