Product: | OKE - Project Contracts |
---|---|
Description: | Contract communications view |
Implementation/DBA Data: | APPS.OKE_K_COMMUNICATIONS_V |
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