Product: | CSC - Customer Care |
---|---|
Description: | View of CSC_CUSTOMERS_AUDIT_HIST. This view is used in Customer Override Criticallity form. |
Implementation/DBA Data: | APPS.CSC_CUSTOMERS_AUDIT_HIST_V |
SELECT CH.ROWID ROW_ID
, CH.CUST_HIST_ID
, CH.PARTY_ID
, CH.CUST_ACCOUNT_ID
, CH.LAST_UPDATE_DATE
, CH.LAST_UPDATED_BY
, CH.LAST_UPDATE_LOGIN
, CH.CREATION_DATE
, CH.CREATED_BY
, CH.CHANGED_DATE
, CH.CHANGED_BY
, CH.SYS_DET_CRITICAL_FLAG
, CH.OVERRIDE_FLAG
, CH.OVERRIDDEN_CRITICAL_FLAG
, CH.OVERRIDE_REASON_CODE
, CH.ATTRIBUTE1
, CH.ATTRIBUTE2
, CH.ATTRIBUTE3
, CH.ATTRIBUTE4
, CH.ATTRIBUTE5
, CH.ATTRIBUTE6
, CH.ATTRIBUTE7
, CH.ATTRIBUTE8
, CH.ATTRIBUTE9
, CH.ATTRIBUTE10
, CH.ATTRIBUTE11
, CH.ATTRIBUTE12
, CH.ATTRIBUTE13
, CH.ATTRIBUTE14
, CH.ATTRIBUTE15
, CH.CONTEXT
, FU.USER_NAME
, HR.FULL_NAME
, CL.MEANING OVERRIDE_REASON_DESC
FROM CSC_LOOKUPS CL
, HR_EMPLOYEES HR
, FND_USER FU
, CSC_CUSTOMERS_AUDIT_HIST CH
WHERE CH.CHANGED_BY = FU.USER_ID(+) AND FU.EMPLOYEE_ID = HR.EMPLOYEE_ID(+) AND CH.OVERRIDE_REASON_CODE = CL.LOOKUP_CODE(+) AND CL.LOOKUP_TYPE(+) = 'CSC_CRITCUST_OVERRIDE_REASONS'