APPS.IBC_CONTENT_CTX_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 69

SELECT
  ctl.citem_version_id,
  language,
  content_item_name,
  description,
  attachment_file_name,
  attachment_file_id,
  attribute_file_id
FROM IBC_CITEM_VERSIONS_TL ctl
where ctl.ROWID=p_rowid;

Line: 128

SELECT
   file_data attachment_file_data,
   file_content_type
FROM
  fnd_lobs flob
WHERE
 flob.file_id = p_file_id;

Line: 178

SELECT
    attribute_bundle_data
FROM
  IBC_ATTRIBUTE_BUNDLES att
WHERE
att.attribute_bundle_id = p_attribute_bundle_id;

Line: 230

SELECT
  keyword
FROM
  IBC_CITEM_VERSIONS_B  cb,
  IBC_CITEM_KEYWORDS k
WHERE
 cb.citem_version_id = p_citem_version_id
AND  k.content_item_id = cb.content_item_id;

Line: 267

SELECT
  ren.citem_version_id,
  flob.file_data rendition_file_data,
  flob.file_name rendition_file_name,
  flob.file_content_type file_content_type
FROM
  IBC_RENDiTIONS ren,
  fnd_lobs flob
WHERE
ren.citem_version_id = p_citem_version_id
AND ren.file_id = flob.file_id
AND ren.LANGUAGE = USERENV('LANG');