VIEW: APPS.IBC_RESOURCES_VL

Source

View Text - Preformatted

SELECT content_item_id, USER_ID USER_ID, UPPER(USER_NAME) USER_NAME, 'USER' USER_TYPE, DESCRIPTION DESCRIPTION, user_id owner_resource_id , user_name owner_resource_name, 'USER' owner_resource_type, email_address owner_resource_email FROM fnd_user a, ibc_content_items WHERE user_id=owner_resource_id AND owner_resource_type='USER' UNION ALL SELECT content_item_id, resource_id, UPPER(resource_name), 'GROUP' NAME, NULL description, resource_id, resource_name, resource_type, email FROM JTF_RS_ALL_RESOURCES_VL , ibc_content_items WHERE resource_id = owner_resource_id AND owner_resource_type =resource_type

View Text - HTML Formatted

SELECT CONTENT_ITEM_ID
, USER_ID USER_ID
, UPPER(USER_NAME) USER_NAME
, 'USER' USER_TYPE
, DESCRIPTION DESCRIPTION
, USER_ID OWNER_RESOURCE_ID
, USER_NAME OWNER_RESOURCE_NAME
, 'USER' OWNER_RESOURCE_TYPE
, EMAIL_ADDRESS OWNER_RESOURCE_EMAIL
FROM FND_USER A
, IBC_CONTENT_ITEMS
WHERE USER_ID=OWNER_RESOURCE_ID
AND OWNER_RESOURCE_TYPE='USER' UNION ALL SELECT CONTENT_ITEM_ID
, RESOURCE_ID
, UPPER(RESOURCE_NAME)
, 'GROUP' NAME
, NULL DESCRIPTION
, RESOURCE_ID
, RESOURCE_NAME
, RESOURCE_TYPE
, EMAIL
FROM JTF_RS_ALL_RESOURCES_VL
, IBC_CONTENT_ITEMS
WHERE RESOURCE_ID = OWNER_RESOURCE_ID
AND OWNER_RESOURCE_TYPE =RESOURCE_TYPE