VIEW: APPS.CSF_M_LOBS_V

Source

View Text - Preformatted

SELECT acc.access_id, lobs.file_id, to_number(1) task_assignment_id, acc.description, acc.language, acc.entity_name, acc.pk1_value, acc.pk2_value, acc.seq_num, lobs.file_name, csm_util_pkg.get_varchar(lobs.file_content_type) as FILE_CONTENT_TYPE, acc.name as user_name, decode (asg_base.allow_attachment_download(ROWNUM, FILE_DATA),'Y', FILE_DATA, (select blob_col from asg_temp_lob where rownum=1)) as file_data, acc.last_update_date, acc.last_updated_by, acc.update_user, acc.category, acc.usage_type, acc.data_type, NULL as URL, NULL as SHORT_TEXT, acc.data_type_id, csm_util_pkg.get_number(acc.document_id) as document_id, acc.title, CSM_UTIL_PKG.GET_NUMBER(acc.created_by) AS CREATED_BY FROM fnd_lobs lobs, csm_fnd_lobs_acc acc WHERE lobs.file_id = acc.file_id AND acc.user_id = asg_base.get_user_id AND acc.data_type_id = 6 UNION ALL SELECT acc.access_id, acc.file_id, to_number(1) task_assignment_id, acc.description, acc.language, acc.entity_name, acc.pk1_value, acc.pk2_value, acc.seq_num, NULL as file_name, NULL as file_content_type, acc.name as user_name, NULL as file_data, acc.last_update_date, acc.last_updated_by, acc.update_user, acc.category, acc.usage_type, acc.data_type, docs.URL, NULL as SHORT_TEXT, acc.data_type_id, csm_util_pkg.get_number(acc.document_id) as document_id, acc.title, CSM_UTIL_PKG.GET_NUMBER(acc.created_by) AS CREATED_BY FROM fnd_documents docs, csm_fnd_lobs_acc acc WHERE docs.document_id = acc.document_id AND acc.user_id = asg_base.get_user_id AND acc.data_type_id = 5 UNION ALL SELECT acc.access_id, acc.file_id, to_number(1) task_assignment_id, acc.description, acc.language, acc.entity_name, acc.pk1_value, acc.pk2_value, acc.seq_num, NULL as file_name, NULL as file_content_type, acc.name as user_name, NULL as file_data, acc.last_update_date, acc.last_updated_by, acc.update_user, acc.category, acc.usage_type, acc.data_type, NULL as URL, csm_util_pkg.get_varchar(txt.SHORT_TEXT) as SHORT_TEXT, acc.data_type_id, csm_util_pkg.get_number(acc.document_id) as document_id, acc.title, CSM_UTIL_PKG.GET_NUMBER(acc.created_by) AS CREATED_BY FROM FND_DOCUMENTS_SHORT_TEXT txt, csm_fnd_lobs_acc acc WHERE txt.media_id = acc.file_id AND acc.user_id = asg_base.get_user_id AND acc.data_type_id = 1

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, LOBS.FILE_ID
, TO_NUMBER(1) TASK_ASSIGNMENT_ID
, ACC.DESCRIPTION
, ACC.LANGUAGE
, ACC.ENTITY_NAME
, ACC.PK1_VALUE
, ACC.PK2_VALUE
, ACC.SEQ_NUM
, LOBS.FILE_NAME
, CSM_UTIL_PKG.GET_VARCHAR(LOBS.FILE_CONTENT_TYPE) AS FILE_CONTENT_TYPE
, ACC.NAME AS USER_NAME
, DECODE (ASG_BASE.ALLOW_ATTACHMENT_DOWNLOAD(ROWNUM
, FILE_DATA)
, 'Y'
, FILE_DATA
, (SELECT BLOB_COL
FROM ASG_TEMP_LOB
WHERE ROWNUM=1)) AS FILE_DATA
, ACC.LAST_UPDATE_DATE
, ACC.LAST_UPDATED_BY
, ACC.UPDATE_USER
, ACC.CATEGORY
, ACC.USAGE_TYPE
, ACC.DATA_TYPE
, NULL AS URL
, NULL AS SHORT_TEXT
, ACC.DATA_TYPE_ID
, CSM_UTIL_PKG.GET_NUMBER(ACC.DOCUMENT_ID) AS DOCUMENT_ID
, ACC.TITLE
, CSM_UTIL_PKG.GET_NUMBER(ACC.CREATED_BY) AS CREATED_BY
FROM FND_LOBS LOBS
, CSM_FND_LOBS_ACC ACC
WHERE LOBS.FILE_ID = ACC.FILE_ID
AND ACC.USER_ID = ASG_BASE.GET_USER_ID
AND ACC.DATA_TYPE_ID = 6 UNION ALL SELECT ACC.ACCESS_ID
, ACC.FILE_ID
, TO_NUMBER(1) TASK_ASSIGNMENT_ID
, ACC.DESCRIPTION
, ACC.LANGUAGE
, ACC.ENTITY_NAME
, ACC.PK1_VALUE
, ACC.PK2_VALUE
, ACC.SEQ_NUM
, NULL AS FILE_NAME
, NULL AS FILE_CONTENT_TYPE
, ACC.NAME AS USER_NAME
, NULL AS FILE_DATA
, ACC.LAST_UPDATE_DATE
, ACC.LAST_UPDATED_BY
, ACC.UPDATE_USER
, ACC.CATEGORY
, ACC.USAGE_TYPE
, ACC.DATA_TYPE
, DOCS.URL
, NULL AS SHORT_TEXT
, ACC.DATA_TYPE_ID
, CSM_UTIL_PKG.GET_NUMBER(ACC.DOCUMENT_ID) AS DOCUMENT_ID
, ACC.TITLE
, CSM_UTIL_PKG.GET_NUMBER(ACC.CREATED_BY) AS CREATED_BY
FROM FND_DOCUMENTS DOCS
, CSM_FND_LOBS_ACC ACC
WHERE DOCS.DOCUMENT_ID = ACC.DOCUMENT_ID
AND ACC.USER_ID = ASG_BASE.GET_USER_ID
AND ACC.DATA_TYPE_ID = 5 UNION ALL SELECT ACC.ACCESS_ID
, ACC.FILE_ID
, TO_NUMBER(1) TASK_ASSIGNMENT_ID
, ACC.DESCRIPTION
, ACC.LANGUAGE
, ACC.ENTITY_NAME
, ACC.PK1_VALUE
, ACC.PK2_VALUE
, ACC.SEQ_NUM
, NULL AS FILE_NAME
, NULL AS FILE_CONTENT_TYPE
, ACC.NAME AS USER_NAME
, NULL AS FILE_DATA
, ACC.LAST_UPDATE_DATE
, ACC.LAST_UPDATED_BY
, ACC.UPDATE_USER
, ACC.CATEGORY
, ACC.USAGE_TYPE
, ACC.DATA_TYPE
, NULL AS URL
, CSM_UTIL_PKG.GET_VARCHAR(TXT.SHORT_TEXT) AS SHORT_TEXT
, ACC.DATA_TYPE_ID
, CSM_UTIL_PKG.GET_NUMBER(ACC.DOCUMENT_ID) AS DOCUMENT_ID
, ACC.TITLE
, CSM_UTIL_PKG.GET_NUMBER(ACC.CREATED_BY) AS CREATED_BY
FROM FND_DOCUMENTS_SHORT_TEXT TXT
, CSM_FND_LOBS_ACC ACC
WHERE TXT.MEDIA_ID = ACC.FILE_ID
AND ACC.USER_ID = ASG_BASE.GET_USER_ID
AND ACC.DATA_TYPE_ID = 1