[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select CONTENT_ITEM_ID
from IBC_ASSOCIATIONS
where ASSOCIATION_TYPE_CODE = p_association_type_code
and ASSOCIATED_OBJECT_VAL1 = p_associated_object_val1
and NVL(ASSOCIATED_OBJECT_VAL2, '0') = NVL(p_associated_object_val2, '0')
and NVL(ASSOCIATED_OBJECT_VAL3, '0') = NVL(p_associated_object_val3, '0')
and NVL(ASSOCIATED_OBJECT_VAL4, '0') = NVL(p_associated_object_val4, '0')
and NVL(ASSOCIATED_OBJECT_VAL5, '0') = NVL(p_associated_object_val5, '0');
select c.CONTENT_ITEM_ID
from IBC_ASSOCIATIONS a, IBC_CONTENT_ITEMS c
where a.ASSOCIATION_TYPE_CODE = p_association_type_code
and a.ASSOCIATED_OBJECT_VAL1 = p_associated_object_val1
and NVL(a.ASSOCIATED_OBJECT_VAL2, '0') = NVL(p_associated_object_val2, '0')
and NVL(a.ASSOCIATED_OBJECT_VAL3, '0') = NVL(p_associated_object_val3, '0')
and NVL(a.ASSOCIATED_OBJECT_VAL4, '0') = NVL(p_associated_object_val4, '0')
and NVL(a.ASSOCIATED_OBJECT_VAL5, '0') = NVL(p_associated_object_val5, '0')
and a.CONTENT_ITEM_ID = c.CONTENT_ITEM_ID
and c.CONTENT_TYPE_CODE = p_content_type_code;
select citem_version_id
from IBC_CITEM_VERSION_LABELS
where label_code = p_label_code and
content_item_id = p_content_item_id;
select ATTRIBUTE_FILE_ID, CONTENT_ITEM_NAME, DESCRIPTION,
DEFAULT_RENDITION_MIME_TYPE, ATTACHMENT_FILE_NAME, ATTACHMENT_FILE_ID
from IBC_CITEM_VERSIONS_TL
where citem_version_id = l_citem_version_id
and language = userenv('LANG');
select FILE_ID, FILE_NAME, MIME_TYPE
from IBC_RENDITIONS
where citem_version_id = l_citem_version_id and
language = userenv('LANG');
SELECT NVL(DESCRIPTION, MEANING)
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = IBC_UTILITIES_PVT.G_REND_LOOKUP_TYPE
AND LANGUAGE = userenv('LANG')
AND LOOKUP_CODE = l_mime_type;
select ATTRIBUTE_TYPE_CODE, CONTENT_ITEM_ID
from IBC_COMPOUND_RELATIONS
where CITEM_VERSION_ID = l_citem_version_id
order by SORT_ORDER;