APPS.IBC_LOAD_CITEMS_PVT SQL Statements

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

Line: 22

	SELECT content_item_id, citem_version_id, label_code
	FROM ibc_citem_version_labels
	WHERE content_item_id IN (select distinct a.CONTENT_ITEM_ID
                          from ibc_associations a, ibc_content_items c
                          where a.content_item_id = c.content_item_id
                          and c.content_item_status = 'APPROVED'
                          and c.WD_RESTRICTED_FLAG = 'F'
                          and c.LIVE_CITEM_VERSION_ID IS NOT NULL)
	AND ROWID IN (SELECT MAX(ROWID)
              FROM ibc_citem_version_labels
              GROUP BY content_item_id, citem_version_id)
	UNION
	SELECT a.*
	FROM (select distinct a.CONTENT_ITEM_ID, c.live_citem_version_id as citem_version_id,
	      NULL as label_code
	from ibc_associations a, ibc_content_items c
	where a.content_item_id = c.content_item_id
	and c.content_item_status = 'APPROVED'
	and c.WD_RESTRICTED_FLAG = 'F'
	and c.LIVE_CITEM_VERSION_ID IS NOT NULL) a
	WHERE NOT EXISTS (SELECT NULL
	FROM  ibc_citem_version_labels b
	WHERE b.citem_version_id = a.citem_version_id);