[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
content_type_code
FROM
ibc_content_items
WHERE
content_item_id = f_content_item_id;
SELECT description
FROM fnd_user
WHERE user_id = p_user_id;
SELECT group_id group_id, resource_id group_resource_id, 'INDIVIDUAL' resource_type
FROM jtf_rs_group_members
WHERE group_id = p_resource_id
AND delete_flag = 'N'
UNION
SELECT rgm.group_id group_id, rgr.group_id group_resource_id, 'GROUP' resource_type
FROM jtf_rs_group_members rgm, jtf_rs_grp_relations rgr
WHERE rgm.group_id = rgr.related_group_id
AND rgm.group_id = p_resource_id
AND rgm.delete_flag = 'N'
AND rgr.delete_flag = 'N';
SELECT resource_number, user_name
FROM jtf_rs_resource_extns
WHERE resource_id = p_resource_id;
SELECT content_item_id
FROM ibc_citem_versions_b
WHERE citem_version_id = f_citem_version_id;
SELECT citem.directory_node_id, dirnode.directory_path
FROM ibc_content_items citem,
ibc_directory_nodes_b dirnode
WHERE citem.content_item_id = p_content_item_id
AND citem.directory_node_id = dirnode.directory_node_id;
SELECT resource_id,
DECODE(category ,'EMPLOYEE', 'RS_EMPLOYEE',
'PARTNER','RS_PARTNER',
'SUPPLIER_CONTACT', 'RS_SUPPLIER' ,
'PARTY', 'RS_PARTY' ,
'OTHER','RS_OTHER',
'TBH', 'RS_TBH') resource_type
FROM jtf_rs_resource_extns
WHERE user_id = FND_GLOBAL.USER_ID;
SELECT owner_resource_id,
owner_resource_type,
civer.version_number,
citem.created_by
FROM ibc_citem_versions_b civer,
ibc_content_items citem
WHERE civer.citem_version_id = p_citem_ver_id
AND civer.content_item_id = citem.content_item_id;
SELECT content_item_name
FROM ibc_citem_versions_tl
WHERE citem_version_id = p_citem_ver_id
AND language = p_language;
SELECT user_name
FROM FND_USER
WHERE USER_ID = p_user_id;
SELECT INITCAP(user_name)
FROM fnd_user
WHERE USER_ID = FND_GLOBAL.USER_ID;
SELECT 'X'
FROM ibc_citem_versions_b a,
ibc_compound_relations b,
ibc_content_items c
WHERE a.citem_version_id = b.citem_version_id
AND b.content_item_id = c.content_item_id
AND a.citem_version_id = p_citem_ver_id
AND c.content_item_status <> p_status;
SELECT ci.content_item_id,
ci.base_language,
ci.translation_required_flag,
ci.directory_node_id,
civ.version_number
FROM ibc_citem_versions_b civ,
ibc_content_items ci
WHERE ci.content_item_id = civ.content_item_id
AND civ.citem_version_id = p_citem_version_id;
SELECT content_item_name
FROM ibc_citem_versions_tl
WHERE citem_version_id = p_citem_ver_id
AND language = p_language;
SELECT citem.directory_node_id, dirnode.directory_path
FROM ibc_content_items citem,
ibc_directory_nodes_b dirnode
WHERE citem.content_item_id = p_content_item_id
AND citem.directory_node_id = dirnode.directory_node_id;
SELECT 'X'
FROM ibc_pending_approvals_v
WHERE item_key = p_item_key;
SELECT *
FROM IBC_PENDING_APPROVALS_V
WHERE USER_NAME = FND_GLOBAL.USER_NAME;
SELECT *
FROM IBC_PENDING_TRANSLATIONS_V
WHERE USER_NAME = FND_GLOBAL.USER_NAME;
SELECT citem.directory_node_id, dirnode.directory_path
FROM ibc_content_items citem,
ibc_directory_nodes_b dirnode
WHERE citem.content_item_id = p_content_item_id
AND citem.directory_node_id = dirnode.directory_node_id;
SELECT resource_id
,DECODE(category ,'EMPLOYEE', 'RS_EMPLOYEE'
,'PARTNER','RS_PARTNER'
,'SUPPLIER_CONTACT', 'RS_SUPPLIER'
,'PARTY', 'RS_PARTY'
,'OTHER','RS_OTHER'
,'TBH', 'RS_TBH') resource_type
FROM jtf_rs_resource_extns
WHERE user_id = FND_GLOBAL.USER_ID;
SELECT CITEM.owner_resource_id
,CITEM.owner_resource_type
,CIVER.version_number
,CITEM.created_by
FROM ibc_citem_versions_b CIVER
,ibc_content_items CITEM
WHERE CIVER.citem_version_id = p_citem_ver_id
AND CIVER.content_item_id = CITEM.content_item_id;
SELECT content_item_name
FROM ibc_citem_versions_tl
WHERE citem_version_id = p_citem_ver_id
AND language = p_language;
SELECT user_name
FROM FND_USER
WHERE USER_ID = p_user_id;
SELECT INITCAP(user_name)
FROM fnd_user
WHERE USER_ID = FND_GLOBAL.USER_ID;
SELECT 'X'
FROM ibc_citem_versions_b a
,ibc_compound_relations b
,ibc_content_items c
WHERE a.citem_version_id = b.citem_version_id
AND b.content_item_id = c.content_item_id
AND a.citem_version_id = p_citem_ver_id
AND c.content_item_status <> p_status;
select IAS.ITEM_KEY
from WF_LOOKUPS L_AT, WF_LOOKUPS L_AS, WF_ACTIVITIES_VL A, WF_PROCESS_ACTIVITIES PA,
WF_ITEM_TYPES_VL IT, WF_ITEMS I, WF_ITEM_ACTIVITY_STATUSES IAS,
ibc_citem_versions_b civb,
ibc_content_items citem
WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
and IAS.ITEM_KEY = I.ITEM_KEY
and I.BEGIN_DATE between A.BEGIN_DATE and nvl(A.END_DATE, I.BEGIN_DATE)
and I.ITEM_TYPE = IT.NAME
and IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
and PA.ACTIVITY_NAME = A.NAME
and PA.ACTIVITY_ITEM_TYPE = A.ITEM_TYPE
and L_AT.LOOKUP_TYPE = 'WFENG_ACTIVITY_TYPE'
and L_AT.LOOKUP_CODE = A.TYPE
and L_AS.LOOKUP_TYPE = 'WFENG_STATUS'
and L_AS.LOOKUP_CODE = IAS.ACTIVITY_STATUS
AND A.NAME = 'IBC_CITEM_APPROVE_NOTIFICATION'
AND SUBSTR(IAS.ITEM_KEY ,1 ,INSTR(IAS.ITEM_KEY,'@') - 1) = civb.citem_version_id
AND civb.content_item_id = citem.content_item_id
AND directory_node_id = p_directory_node_id AND
IAS.ITEM_TYPE = 'IBC_WF'
AND IAS.ACTIVITY_STATUS = 'NOTIFIED'
GROUP BY IAS.ITEM_KEY
MINUS
select IAS.ITEM_KEY
from WF_LOOKUPS L_AT, WF_LOOKUPS L_AS, WF_ACTIVITIES_VL A, WF_PROCESS_ACTIVITIES PA,
WF_ITEM_TYPES_VL IT, WF_ITEMS I, WF_ITEM_ACTIVITY_STATUSES IAS, WF_USER_ROLES U,
ibc_citem_versions_b civb,
ibc_content_items citem
WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
and IAS.ITEM_KEY = I.ITEM_KEY
and I.BEGIN_DATE between A.BEGIN_DATE and nvl(A.END_DATE, I.BEGIN_DATE)
and I.ITEM_TYPE = IT.NAME
and IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
and PA.ACTIVITY_NAME = A.NAME
and PA.ACTIVITY_ITEM_TYPE = A.ITEM_TYPE
and L_AT.LOOKUP_TYPE = 'WFENG_ACTIVITY_TYPE'
and L_AT.LOOKUP_CODE = A.TYPE
and L_AS.LOOKUP_TYPE = 'WFENG_STATUS'
and L_AS.LOOKUP_CODE = IAS.ACTIVITY_STATUS
AND A.NAME = 'IBC_CITEM_APPROVE_NOTIFICATION'
AND SUBSTR(IAS.ITEM_KEY ,1 ,INSTR(IAS.ITEM_KEY,'@') - 1) = civb.citem_version_id
AND civb.content_item_id = citem.content_item_id
AND directory_node_id = p_directory_node_id AND
IAS.ITEM_TYPE = 'IBC_WF'
AND IAS.ACTIVITY_STATUS = 'NOTIFIED'
AND IAS.ASSIGNED_USER = U.ROLE_NAME
AND NOT EXISTS(SELECT 'X'
FROM ibc_pending_approvals_v pav2
WHERE pav2.item_key = IAS.item_key
AND p_user_pattern NOT LIKE '%[' || U.user_name || ']%'
)
GROUP BY IAS.ITEM_KEY;
SELECT content_item_name
FROM ibc_citem_versions_vl civ
WHERE civ.content_item_id = p_content_item_id;
SELECT dirnode.directory_path
FROM ibc_content_items citem,
ibc_directory_nodes_b dirnode
WHERE citem.content_item_id = p_content_item_id
AND citem.directory_node_id = dirnode.directory_node_id;
SELECT dirnode.directory_path
FROM ibc_directory_nodes_b dirnode
WHERE directory_node_id = p_directory_node_id;
SELECT content_item_name
FROM ibc_citem_versions_vl civ
WHERE civ.content_item_id = p_content_item_id;
SELECT dirnode.directory_path, dirnode.directory_node_id
FROM ibc_content_items citem,
ibc_directory_nodes_b dirnode
WHERE citem.content_item_id = p_content_item_id
AND citem.directory_node_id = dirnode.directory_node_id;