VIEW: APPS.CSL_LOBS_V

Source

View Text - Preformatted

SELECT lob.file_id AS access_id, lob.file_id AS file_id, to_number(1) as task_assignment_id, fnddoc_tl.description, fnddoc_tl.language, 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, fndatt.entity_name, fndatt.pk1_value, fndatt.pk2_value, fndatt.seq_num, lob.file_name, lob.file_content_type, (DECODE(fnddoccat_tl.name,'MISC', 'Miscellaneous', 'SIGNATURE', 'Signature')) user_name FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc, fnd_document_categories_tl fnddoccat_tl, fnd_attached_documents fndatt, fnd_lobs lob WHERE fndatt.document_id = fnddoc_tl.document_id AND fnddoc_tl.language = asg_base.get_language AND fnddoc_tl.document_id = fnddoc.document_id AND fnddoc_tl.media_id = lob.file_id AND fnddoccat_tl.category_id = fnddoc.category_id AND fnddoccat_tl.language = asg_base.get_language AND fnddoccat_tl.name IN ('SIGNATURE','MISC') AND fnddoc.datatype_id=6 AND EXISTS (SELECT 1 FROM CSL_JTF_TASK_ASS_ACC ta_acc, CSF_DEBRIEF_HEADERS dbfhdr WHERE ta_acc.resource_id = asg_base.get_resource_id AND ta_acc.task_assignment_id = dbfhdr.task_assignment_id AND fndatt.entity_name = 'CSF_DEBRIEF_HEADERS' AND fndatt.pk1_value = to_char(dbfhdr.debrief_header_id) AND fnddoc_tl.document_id = (SELECT MIN(b.document_id) FROM fnd_attached_documents b WHERE b.entity_name = 'CSF_DEBRIEF_HEADERS' AND b.pk1_value = to_char(dbfhdr.debrief_header_id)) UNION ALL SELECT 1 FROM csl_cs_incidents_all_acc sr_acc WHERE sr_acc.resource_id = asg_base.get_resource_id AND fndatt.entity_name = 'CS_INCIDENTS' AND fndatt.pk1_value = to_char(sr_acc.incident_id) UNION ALL SELECT 1 FROM csl_jtf_tasks_acc task_acc WHERE task_acc.resource_id = asg_base.get_resource_id AND fndatt.entity_name = 'JTF_TASKS_B' AND fndatt.pk1_value = to_char(task_acc.task_id) )

View Text - HTML Formatted

SELECT LOB.FILE_ID AS ACCESS_ID
, LOB.FILE_ID AS FILE_ID
, TO_NUMBER(1) AS TASK_ASSIGNMENT_ID
, FNDDOC_TL.DESCRIPTION
, FNDDOC_TL.LANGUAGE
, 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
, FNDATT.ENTITY_NAME
, FNDATT.PK1_VALUE
, FNDATT.PK2_VALUE
, FNDATT.SEQ_NUM
, LOB.FILE_NAME
, LOB.FILE_CONTENT_TYPE
, (DECODE(FNDDOCCAT_TL.NAME
, 'MISC'
, 'MISCELLANEOUS'
, 'SIGNATURE'
, 'SIGNATURE')) USER_NAME
FROM FND_DOCUMENTS_TL FNDDOC_TL
, FND_DOCUMENTS FNDDOC
, FND_DOCUMENT_CATEGORIES_TL FNDDOCCAT_TL
, FND_ATTACHED_DOCUMENTS FNDATT
, FND_LOBS LOB
WHERE FNDATT.DOCUMENT_ID = FNDDOC_TL.DOCUMENT_ID
AND FNDDOC_TL.LANGUAGE = ASG_BASE.GET_LANGUAGE
AND FNDDOC_TL.DOCUMENT_ID = FNDDOC.DOCUMENT_ID
AND FNDDOC_TL.MEDIA_ID = LOB.FILE_ID
AND FNDDOCCAT_TL.CATEGORY_ID = FNDDOC.CATEGORY_ID
AND FNDDOCCAT_TL.LANGUAGE = ASG_BASE.GET_LANGUAGE
AND FNDDOCCAT_TL.NAME IN ('SIGNATURE'
, 'MISC')
AND FNDDOC.DATATYPE_ID=6
AND EXISTS (SELECT 1
FROM CSL_JTF_TASK_ASS_ACC TA_ACC
, CSF_DEBRIEF_HEADERS DBFHDR
WHERE TA_ACC.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID
AND TA_ACC.TASK_ASSIGNMENT_ID = DBFHDR.TASK_ASSIGNMENT_ID
AND FNDATT.ENTITY_NAME = 'CSF_DEBRIEF_HEADERS'
AND FNDATT.PK1_VALUE = TO_CHAR(DBFHDR.DEBRIEF_HEADER_ID)
AND FNDDOC_TL.DOCUMENT_ID = (SELECT MIN(B.DOCUMENT_ID)
FROM FND_ATTACHED_DOCUMENTS B
WHERE B.ENTITY_NAME = 'CSF_DEBRIEF_HEADERS'
AND B.PK1_VALUE = TO_CHAR(DBFHDR.DEBRIEF_HEADER_ID)) UNION ALL SELECT 1
FROM CSL_CS_INCIDENTS_ALL_ACC SR_ACC
WHERE SR_ACC.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID
AND FNDATT.ENTITY_NAME = 'CS_INCIDENTS'
AND FNDATT.PK1_VALUE = TO_CHAR(SR_ACC.INCIDENT_ID) UNION ALL SELECT 1
FROM CSL_JTF_TASKS_ACC TASK_ACC
WHERE TASK_ACC.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID
AND FNDATT.ENTITY_NAME = 'JTF_TASKS_B'
AND FNDATT.PK1_VALUE = TO_CHAR(TASK_ACC.TASK_ID) )