VIEW: APPS.CSC_CUSTOMERS_AUDIT_HIST_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'