VIEW: APPS.IBC_CTYPE_GROUPS_V

Source

View Text - Preformatted

SELECT "ROW_ID","CONTENT_TYPE_CODE","CONTENT_TYPE_STATUS","APPLICATION_ID","CREATED_BY","CREATION_DATE","LAST_UPDATED_BY","LAST_UPDATE_DATE","LAST_UPDATE_LOGIN","REQUEST_ID","OWNER_FND_USER_ID","PROGRAM_UPDATE_DATE","PROGRAM_APPLICATION_ID","PROGRAM_ID","OBJECT_VERSION_NUMBER","SECURITY_GROUP_ID","CONTENT_TYPE_NAME","DESCRIPTION","ENCRYPT_FLAG" FROM ibc_content_types_vl WHERE content_type_code IN (SELECT content_type_code FROM IBC_CTYPE_GROUP_NODES WHERE directory_node_id = FND_PROFILE.VALUE('IBC_CTYPE_GROUP') )

View Text - HTML Formatted

SELECT "ROW_ID"
, "CONTENT_TYPE_CODE"
, "CONTENT_TYPE_STATUS"
, "APPLICATION_ID"
, "CREATED_BY"
, "CREATION_DATE"
, "LAST_UPDATED_BY"
, "LAST_UPDATE_DATE"
, "LAST_UPDATE_LOGIN"
, "REQUEST_ID"
, "OWNER_FND_USER_ID"
, "PROGRAM_UPDATE_DATE"
, "PROGRAM_APPLICATION_ID"
, "PROGRAM_ID"
, "OBJECT_VERSION_NUMBER"
, "SECURITY_GROUP_ID"
, "CONTENT_TYPE_NAME"
, "DESCRIPTION"
, "ENCRYPT_FLAG"
FROM IBC_CONTENT_TYPES_VL
WHERE CONTENT_TYPE_CODE IN (SELECT CONTENT_TYPE_CODE
FROM IBC_CTYPE_GROUP_NODES
WHERE DIRECTORY_NODE_ID = FND_PROFILE.VALUE('IBC_CTYPE_GROUP') )