eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IBC_CITEMS_V

Source

View Text - Preformatted


SELECT IBC_CONTENT_ITEMS.content_item_id citem_id ,IBC_CONTENT_ITEMS.item_reference_code ref_code ,IBC_CONTENT_ITEMS.content_type_code ctype_code ,IBC_CONTENT_ITEMS.directory_node_id dir_node_id ,IBC_CONTENT_ITEMS.Parent_item_id Parent_id ,IBC_CONTENT_ITEMS.locked_by_user_id locked_by ,IBC_CONTENT_ITEMS.wd_restricted_flag wd_restricted ,IBC_CONTENT_ITEMS.translation_required_flag trans_required ,IBC_CONTENT_ITEMS.owner_resource_id owner ,IBC_CONTENT_ITEMS.owner_resource_type owner_type ,IBC_CONTENT_ITEMS.content_item_status item_status ,IBC_CONTENT_ITEMS.object_version_number object_version_number ,IBC_CONTENT_TYPES_TL.content_type_name ctype_name ,IBC_DIRECTORY_NODES_B.directory_node_code dir_node_code ,IBC_DIRECTORY_NODES_TL.directory_node_name dir_node_name ,IBC_CITEM_VERSIONS_B.citem_version_id citem_ver_id ,IBC_CITEM_VERSIONS_B.version_number version ,IBC_CITEM_VERSIONS_B.citem_version_status version_status ,IBC_CITEM_VERSIONS_B.start_date start_date ,IBC_CITEM_VERSIONS_B.end_date end_date ,IBC_CITEM_VERSIONS_TL.LANGUAGE LANGUAGE ,IBC_CITEM_VERSIONS_TL.attribute_file_id attrib_fid ,IBC_CITEM_VERSIONS_TL.attachment_file_id attach_fid ,IBC_CITEM_VERSIONS_TL.content_item_name name ,IBC_CITEM_VERSIONS_TL.attachment_file_name attach_file_name ,IBC_CITEM_VERSIONS_TL.description description ,IBC_CITEM_VERSIONS_TL.DEFAULT_RENDITION_MIME_TYPE DEFAULT_RENDITION_MIME_TYPE ,IBC_CITEM_VERSIONS_TL.source_lang source_lang ,IBC_CITEM_VERSIONS_TL.created_by created_by ,IBC_CITEM_VERSIONS_TL.creation_date creation_date ,IBC_CITEM_VERSIONS_TL.last_updated_by last_updated_by ,IBC_CITEM_VERSIONS_TL.last_update_date last_update_date ,IBC_CITEM_VERSIONS_TL.last_update_login last_update_login ,IBC_CONTENT_ITEMS.BASE_LANGUAGE , IBC_DIRECTORY_NODES_B.NODE_STATUS , DIRECTORY_PATH , IBC_CONTENT_ITEMS.LIVE_CITEM_VERsion_ID , IBC_CONTENT_ITEMS.ENCRYPT_FLAG , IBC_CITEM_VERSIONS_TL.CITEM_TRANSLATION_STATUS , IBC_CONTENT_ITEMS.CREATED_BY , IBC_CONTENT_ITEMS.CREATION_DATE , IBC_CONTENT_ITEMS.LAST_UPDATED_BY , IBC_CONTENT_ITEMS.LAST_UPDATE_DATE ,IBC_CONTENT_ITEMS.ROWID FROM IBC_CONTENT_ITEMS ,IBC_CONTENT_TYPES_TL ,IBC_CITEM_VERSIONS_B ,IBC_CITEM_VERSIONS_TL ,IBC_DIRECTORY_NODES_B ,IBC_DIRECTORY_NODES_TL WHERE IBC_CONTENT_ITEMS.content_item_id = IBC_CITEM_VERSIONS_B.content_item_id AND IBC_CONTENT_ITEMS.content_type_code = IBC_CONTENT_TYPES_TL.content_type_code AND IBC_CONTENT_ITEMS.directory_node_id = IBC_DIRECTORY_NODES_B.directory_node_id AND IBC_CONTENT_ITEMS.directory_node_id = IBC_DIRECTORY_NODES_TL.directory_node_id AND IBC_CITEM_VERSIONS_B.citem_version_id = IBC_CITEM_VERSIONS_TL.citem_version_id AND IBC_CITEM_VERSIONS_TL.LANGUAGE = IBC_DIRECTORY_NODES_TL.LANGUAGE AND IBC_CITEM_VERSIONS_TL.LANGUAGE = IBC_CONTENT_TYPES_TL.LANGUAGE

View Text - HTML Formatted

SELECT IBC_CONTENT_ITEMS.CONTENT_ITEM_ID CITEM_ID
, IBC_CONTENT_ITEMS.ITEM_REFERENCE_CODE REF_CODE
, IBC_CONTENT_ITEMS.CONTENT_TYPE_CODE CTYPE_CODE
, IBC_CONTENT_ITEMS.DIRECTORY_NODE_ID DIR_NODE_ID
, IBC_CONTENT_ITEMS.PARENT_ITEM_ID PARENT_ID
, IBC_CONTENT_ITEMS.LOCKED_BY_USER_ID LOCKED_BY
, IBC_CONTENT_ITEMS.WD_RESTRICTED_FLAG WD_RESTRICTED
, IBC_CONTENT_ITEMS.TRANSLATION_REQUIRED_FLAG TRANS_REQUIRED
, IBC_CONTENT_ITEMS.OWNER_RESOURCE_ID OWNER
, IBC_CONTENT_ITEMS.OWNER_RESOURCE_TYPE OWNER_TYPE
, IBC_CONTENT_ITEMS.CONTENT_ITEM_STATUS ITEM_STATUS
, IBC_CONTENT_ITEMS.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, IBC_CONTENT_TYPES_TL.CONTENT_TYPE_NAME CTYPE_NAME
, IBC_DIRECTORY_NODES_B.DIRECTORY_NODE_CODE DIR_NODE_CODE
, IBC_DIRECTORY_NODES_TL.DIRECTORY_NODE_NAME DIR_NODE_NAME
, IBC_CITEM_VERSIONS_B.CITEM_VERSION_ID CITEM_VER_ID
, IBC_CITEM_VERSIONS_B.VERSION_NUMBER VERSION
, IBC_CITEM_VERSIONS_B.CITEM_VERSION_STATUS VERSION_STATUS
, IBC_CITEM_VERSIONS_B.START_DATE START_DATE
, IBC_CITEM_VERSIONS_B.END_DATE END_DATE
, IBC_CITEM_VERSIONS_TL.LANGUAGE LANGUAGE
, IBC_CITEM_VERSIONS_TL.ATTRIBUTE_FILE_ID ATTRIB_FID
, IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_ID ATTACH_FID
, IBC_CITEM_VERSIONS_TL.CONTENT_ITEM_NAME NAME
, IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_NAME ATTACH_FILE_NAME
, IBC_CITEM_VERSIONS_TL.DESCRIPTION DESCRIPTION
, IBC_CITEM_VERSIONS_TL.DEFAULT_RENDITION_MIME_TYPE DEFAULT_RENDITION_MIME_TYPE
, IBC_CITEM_VERSIONS_TL.SOURCE_LANG SOURCE_LANG
, IBC_CITEM_VERSIONS_TL.CREATED_BY CREATED_BY
, IBC_CITEM_VERSIONS_TL.CREATION_DATE CREATION_DATE
, IBC_CITEM_VERSIONS_TL.LAST_UPDATED_BY LAST_UPDATED_BY
, IBC_CITEM_VERSIONS_TL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IBC_CITEM_VERSIONS_TL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, IBC_CONTENT_ITEMS.BASE_LANGUAGE
, IBC_DIRECTORY_NODES_B.NODE_STATUS
, DIRECTORY_PATH
, IBC_CONTENT_ITEMS.LIVE_CITEM_VERSION_ID
, IBC_CONTENT_ITEMS.ENCRYPT_FLAG
, IBC_CITEM_VERSIONS_TL.CITEM_TRANSLATION_STATUS
, IBC_CONTENT_ITEMS.CREATED_BY
, IBC_CONTENT_ITEMS.CREATION_DATE
, IBC_CONTENT_ITEMS.LAST_UPDATED_BY
, IBC_CONTENT_ITEMS.LAST_UPDATE_DATE
, IBC_CONTENT_ITEMS.ROWID
FROM IBC_CONTENT_ITEMS
, IBC_CONTENT_TYPES_TL
, IBC_CITEM_VERSIONS_B
, IBC_CITEM_VERSIONS_TL
, IBC_DIRECTORY_NODES_B
, IBC_DIRECTORY_NODES_TL
WHERE IBC_CONTENT_ITEMS.CONTENT_ITEM_ID = IBC_CITEM_VERSIONS_B.CONTENT_ITEM_ID
AND IBC_CONTENT_ITEMS.CONTENT_TYPE_CODE = IBC_CONTENT_TYPES_TL.CONTENT_TYPE_CODE
AND IBC_CONTENT_ITEMS.DIRECTORY_NODE_ID = IBC_DIRECTORY_NODES_B.DIRECTORY_NODE_ID
AND IBC_CONTENT_ITEMS.DIRECTORY_NODE_ID = IBC_DIRECTORY_NODES_TL.DIRECTORY_NODE_ID
AND IBC_CITEM_VERSIONS_B.CITEM_VERSION_ID = IBC_CITEM_VERSIONS_TL.CITEM_VERSION_ID
AND IBC_CITEM_VERSIONS_TL.LANGUAGE = IBC_DIRECTORY_NODES_TL.LANGUAGE
AND IBC_CITEM_VERSIONS_TL.LANGUAGE = IBC_CONTENT_TYPES_TL.LANGUAGE