VIEW: APPS.OKE_K_COMMUNICATIONS_V

Source

View Text - Preformatted

SELECT COMM.ROWID , COMM.K_HEADER_ID , COMM.COMMUNICATION_NUM , COMM.CREATION_DATE , COMM.CREATED_BY , COMM.LAST_UPDATE_DATE , COMM.LAST_UPDATED_BY , COMM.LAST_UPDATE_LOGIN , COMM.COMMUNICATION_DATE , REAS.MEANING , COMM.REASON_CODE , CTYP.MEANING , COMM.TYPE , COMM.K_PARTY_ID , COMM.PARTY_LOCATION , COMM.PARTY_ROLE , COMM.PARTY_CONTACT , CACT.COMM_ACTION_NAME , COMM.ACTION_CODE , CPR.MEANING , COMM.PRIORITY_CODE , EMP.FULL_NAME , COMM.OWNER , COMM.WF_ITEM_TYPE , COMM.WF_PROCESS , COMM.WF_ITEM_KEY , LIN.LINE_NUMBER , COMM.K_LINE_ID , DLV.DELIVERABLE_NUM , COMM.DELIVERABLE_ID , COMM.FUNDING_SOURCE_ID , COMM.FUNDING_REF1 , COMM.FUNDING_REF2 , COMM.FUNDING_REF3 , CRQ.CHG_REQUEST_NUM , COMM.CHG_REQUEST_ID , PROJ.SEGMENT1 , COMM.PROJECT_ID , TASK.TASK_NUMBER , COMM.TASK_ID , COMM.DELETE_IND , COMM.ATTRIBUTE_CATEGORY , COMM.ATTRIBUTE1 , COMM.ATTRIBUTE2 , COMM.ATTRIBUTE3 , COMM.ATTRIBUTE4 , COMM.ATTRIBUTE5 , COMM.ATTRIBUTE6 , COMM.ATTRIBUTE7 , COMM.ATTRIBUTE8 , COMM.ATTRIBUTE9 , COMM.ATTRIBUTE10 , COMM.ATTRIBUTE11 , COMM.ATTRIBUTE12 , COMM.ATTRIBUTE13 , COMM.ATTRIBUTE14 , COMM.ATTRIBUTE15 , COMM.TEXT FROM OKE_K_COMMUNICATIONS COMM , OKE_COMM_ACTIONS_TL CACT , PER_ALL_PEOPLE_F EMP , OKC_K_LINES_B LIN , OKE_K_DELIVERABLES_B DLV , OKE_CHG_REQUESTS CRQ , PA_PROJECTS_ALL PROJ , PA_TASKS TASK , FND_LOOKUP_VALUES_VL REAS , FND_LOOKUP_VALUES_VL CTYP , FND_LOOKUP_VALUES_VL CPR WHERE CACT.COMM_ACTION_CODE = COMM.ACTION_CODE AND CACT.LANGUAGE = USERENV('LANG') AND EMP.PERSON_ID (+) = COMM.OWNER AND TRUNC(SYSDATE) BETWEEN NVL( EFFECTIVE_START_DATE , SYSDATE - 1 ) AND NVL( EFFECTIVE_END_DATE , SYSDATE + 1 ) AND LIN.ID (+) = COMM.K_LINE_ID AND DLV.DELIVERABLE_ID (+) = COMM.DELIVERABLE_ID AND CRQ.CHG_REQUEST_ID (+) = COMM.CHG_REQUEST_ID AND PROJ.PROJECT_ID (+) = COMM.PROJECT_ID AND TASK.TASK_ID (+) = COMM.TASK_ID AND CTYP.VIEW_APPLICATION_ID = 777 AND CTYP.LOOKUP_TYPE = 'COMMUNICATION_TYPE' AND CTYP.LOOKUP_CODE = COMM.TYPE AND REAS.VIEW_APPLICATION_ID (+) = 777 AND REAS.LOOKUP_TYPE (+) = 'COMMUNICATION_REASON_CODE' AND REAS.LOOKUP_CODE (+) = COMM.REASON_CODE AND CPR.VIEW_APPLICATION_ID (+) = 777 AND CPR.LOOKUP_TYPE (+) = 'COMMUNICATION_PRIORITY' AND CPR.LOOKUP_CODE (+) = COMM.PRIORITY_CODE

View Text - HTML Formatted

SELECT COMM.ROWID
, COMM.K_HEADER_ID
, COMM.COMMUNICATION_NUM
, COMM.CREATION_DATE
, COMM.CREATED_BY
, COMM.LAST_UPDATE_DATE
, COMM.LAST_UPDATED_BY
, COMM.LAST_UPDATE_LOGIN
, COMM.COMMUNICATION_DATE
, REAS.MEANING
, COMM.REASON_CODE
, CTYP.MEANING
, COMM.TYPE
, COMM.K_PARTY_ID
, COMM.PARTY_LOCATION
, COMM.PARTY_ROLE
, COMM.PARTY_CONTACT
, CACT.COMM_ACTION_NAME
, COMM.ACTION_CODE
, CPR.MEANING
, COMM.PRIORITY_CODE
, EMP.FULL_NAME
, COMM.OWNER
, COMM.WF_ITEM_TYPE
, COMM.WF_PROCESS
, COMM.WF_ITEM_KEY
, LIN.LINE_NUMBER
, COMM.K_LINE_ID
, DLV.DELIVERABLE_NUM
, COMM.DELIVERABLE_ID
, COMM.FUNDING_SOURCE_ID
, COMM.FUNDING_REF1
, COMM.FUNDING_REF2
, COMM.FUNDING_REF3
, CRQ.CHG_REQUEST_NUM
, COMM.CHG_REQUEST_ID
, PROJ.SEGMENT1
, COMM.PROJECT_ID
, TASK.TASK_NUMBER
, COMM.TASK_ID
, COMM.DELETE_IND
, COMM.ATTRIBUTE_CATEGORY
, COMM.ATTRIBUTE1
, COMM.ATTRIBUTE2
, COMM.ATTRIBUTE3
, COMM.ATTRIBUTE4
, COMM.ATTRIBUTE5
, COMM.ATTRIBUTE6
, COMM.ATTRIBUTE7
, COMM.ATTRIBUTE8
, COMM.ATTRIBUTE9
, COMM.ATTRIBUTE10
, COMM.ATTRIBUTE11
, COMM.ATTRIBUTE12
, COMM.ATTRIBUTE13
, COMM.ATTRIBUTE14
, COMM.ATTRIBUTE15
, COMM.TEXT
FROM OKE_K_COMMUNICATIONS COMM
, OKE_COMM_ACTIONS_TL CACT
, PER_ALL_PEOPLE_F EMP
, OKC_K_LINES_B LIN
, OKE_K_DELIVERABLES_B DLV
, OKE_CHG_REQUESTS CRQ
, PA_PROJECTS_ALL PROJ
, PA_TASKS TASK
, FND_LOOKUP_VALUES_VL REAS
, FND_LOOKUP_VALUES_VL CTYP
, FND_LOOKUP_VALUES_VL CPR
WHERE CACT.COMM_ACTION_CODE = COMM.ACTION_CODE
AND CACT.LANGUAGE = USERENV('LANG')
AND EMP.PERSON_ID (+) = COMM.OWNER
AND TRUNC(SYSDATE) BETWEEN NVL( EFFECTIVE_START_DATE
, SYSDATE - 1 )
AND NVL( EFFECTIVE_END_DATE
, SYSDATE + 1 )
AND LIN.ID (+) = COMM.K_LINE_ID
AND DLV.DELIVERABLE_ID (+) = COMM.DELIVERABLE_ID
AND CRQ.CHG_REQUEST_ID (+) = COMM.CHG_REQUEST_ID
AND PROJ.PROJECT_ID (+) = COMM.PROJECT_ID
AND TASK.TASK_ID (+) = COMM.TASK_ID
AND CTYP.VIEW_APPLICATION_ID = 777
AND CTYP.LOOKUP_TYPE = 'COMMUNICATION_TYPE'
AND CTYP.LOOKUP_CODE = COMM.TYPE
AND REAS.VIEW_APPLICATION_ID (+) = 777
AND REAS.LOOKUP_TYPE (+) = 'COMMUNICATION_REASON_CODE'
AND REAS.LOOKUP_CODE (+) = COMM.REASON_CODE
AND CPR.VIEW_APPLICATION_ID (+) = 777
AND CPR.LOOKUP_TYPE (+) = 'COMMUNICATION_PRIORITY'
AND CPR.LOOKUP_CODE (+) = COMM.PRIORITY_CODE