VIEW: APPS.CSF_M_NOTES_V

Source

View Text - Preformatted

SELECT CSM_UTIL_PKG.get_number(acc.access_id), jtf.jtf_note_id, CSM_UTIL_PKG.get_number(jtf.source_object_id), CSM_UTIL_PKG.get_varchar(jtf.source_object_code), CSM_UTIL_PKG.get_varchar( jtf_tl.notes), jtf.note_status, CSM_UTIL_PKG.get_number( jtf.entered_by), CSM_UTIL_PKG.get_date( jtf.entered_date), jtf.note_type, CSM_UTIL_PKG.get_date( jtf.last_update_date), JTF.PARENT_NOTE_ID, res.SOURCE_NAME, CSM_UTIL_PKG.GET_NUMBER(jtf.created_by) AS CREATED_BY, CSM_UTIL_PKG.GET_NUMBER(jtf.last_updated_by) AS LAST_UPDATED_BY, CSM_UTIL_PKG.get_date( jtf.last_update_date) AS SERVER_LAST_UPDATE_DATE, jtf_tl.notes_detail from JTF_NOTES_B jtf, JTF_NOTES_TL jtf_tl, CSM_NOTES_ACC acc, JTF_RS_RESOURCE_EXTNS res,asg_user au WHERE jtf.JTF_NOTE_ID = acc.JTF_NOTE_ID and jtf.JTF_NOTE_ID = jtf_tl.JTF_NOTE_ID and acc.USER_ID = asg_base.get_user_id and jtf_tl.LANGUAGE = asg_base.get_language and acc.user_id=res.user_id and au.user_id=acc.user_id and ((nvl(au.multi_platform,'N')='N') Or (nvl(au.multi_platform,'N')='Y' AND jtf.source_object_code='TASK' ))

View Text - HTML Formatted

SELECT CSM_UTIL_PKG.GET_NUMBER(ACC.ACCESS_ID)
, JTF.JTF_NOTE_ID
, CSM_UTIL_PKG.GET_NUMBER(JTF.SOURCE_OBJECT_ID)
, CSM_UTIL_PKG.GET_VARCHAR(JTF.SOURCE_OBJECT_CODE)
, CSM_UTIL_PKG.GET_VARCHAR( JTF_TL.NOTES)
, JTF.NOTE_STATUS
, CSM_UTIL_PKG.GET_NUMBER( JTF.ENTERED_BY)
, CSM_UTIL_PKG.GET_DATE( JTF.ENTERED_DATE)
, JTF.NOTE_TYPE
, CSM_UTIL_PKG.GET_DATE( JTF.LAST_UPDATE_DATE)
, JTF.PARENT_NOTE_ID
, RES.SOURCE_NAME
, CSM_UTIL_PKG.GET_NUMBER(JTF.CREATED_BY) AS CREATED_BY
, CSM_UTIL_PKG.GET_NUMBER(JTF.LAST_UPDATED_BY) AS LAST_UPDATED_BY
, CSM_UTIL_PKG.GET_DATE( JTF.LAST_UPDATE_DATE) AS SERVER_LAST_UPDATE_DATE
, JTF_TL.NOTES_DETAIL
FROM JTF_NOTES_B JTF
, JTF_NOTES_TL JTF_TL
, CSM_NOTES_ACC ACC
, JTF_RS_RESOURCE_EXTNS RES
, ASG_USER AU
WHERE JTF.JTF_NOTE_ID = ACC.JTF_NOTE_ID
AND JTF.JTF_NOTE_ID = JTF_TL.JTF_NOTE_ID
AND ACC.USER_ID = ASG_BASE.GET_USER_ID
AND JTF_TL.LANGUAGE = ASG_BASE.GET_LANGUAGE
AND ACC.USER_ID=RES.USER_ID
AND AU.USER_ID=ACC.USER_ID
AND ((NVL(AU.MULTI_PLATFORM
, 'N')='N') OR (NVL(AU.MULTI_PLATFORM
, 'N')='Y'
AND JTF.SOURCE_OBJECT_CODE='TASK' ))