98: ,a.CITEM_VERSION_ID
99: ,a.CITEM_VERSION_STATUS
100: ,a.version_number
101: FROM
102: ibc_citem_versions_vl a,
103: ibc_content_items b
104: WHERE
105: a.content_item_id=b.content_item_id AND
106: b.directory_node_id = l_dir_node_id AND
190: ,'US' language_code
191: ,NULL content_creation_status
192: ,'IBC_UPLOAD_ITEMEXIST_NEW' user_option_for_item
193: ,'IBC_UPLOAD_FILEAS_RENDITION' citem_upload_as
194: FROM ibc_content_items a, ibc_citem_versions_vl b
195: WHERE content_type_code='IBC_FILE'
196: AND a.content_item_id=b.content_item_id
197: AND citem_version_id=16799;
198: