View: CSC_CUSTOMERS_V

Product:	CSC - Customer Care
Description:	View of CSC_CUSTOMERS. This view is used in Customer Override Criticallity form.
Implementation/DBA Data:	APPS.CSC_CUSTOMERS_V

View Text

SELECT CC.ROWID ROW_ID
, CC.PARTY_ID
, CC.CUST_ACCOUNT_ID
, CC.LAST_UPDATE_DATE
, CC.LAST_UPDATED_BY
, CC.LAST_UPDATE_LOGIN
, CC.CREATION_DATE
, CC.CREATED_BY
, CC.OVERRIDE_FLAG
, CC.OVERRIDDEN_CRITICAL_FLAG
, CC.OVERRIDE_REASON_CODE
, CC.ATTRIBUTE1
, CC.ATTRIBUTE2
, CC.ATTRIBUTE3
, CC.ATTRIBUTE4
, CC.ATTRIBUTE5
, CC.ATTRIBUTE6
, CC.ATTRIBUTE7
, CC.ATTRIBUTE8
, CC.ATTRIBUTE9
, CC.ATTRIBUTE10
, CC.ATTRIBUTE11
, CC.ATTRIBUTE12
, CC.ATTRIBUTE13
, CC.ATTRIBUTE14
, CC.ATTRIBUTE15
, CC.CONTEXT
, HZ.PARTY_NAME
, HZ.PARTY_NUMBER
, HZ.STATUS
, DECODE(CC.OVERRIDDEN_CRITICAL_FLAG
, 'Y'
, 'N'
, 'Y') OVERRIDDEN_NONCRITICAL_FLAG
, DECODE(CC.OVERRIDE_FLAG
, 'Y'
, CC.OVERRIDDEN_CRITICAL_FLAG
, NVL(PC.VALUE
, 'N')) NET_CRITICAL_FLAG
, PC.VALUE SYS_DET_CRITICAL_FLAG
, CL.MEANING OVERRIDE_REASON_DESC
FROM CSC_LOOKUPS CL
, CSC_PROF_CHECK_RESULTS PC
, HZ_PARTIES HZ
, CSC_CUSTOMERS CC
WHERE CC.PARTY_ID = PC.PARTY_ID(+) AND PC.CHECK_ID(+) = FND_PROFILE.VALUE_WNPS('CSC_CRITICAL_CUSTOMER_CHECK') AND CC.PARTY_ID = HZ.PARTY_ID AND CC.OVERRIDE_REASON_CODE = CL.LOOKUP_CODE(+) AND CL.LOOKUP_TYPE(+) = 'CSC_CRITCUST_OVERRIDE_REASONS'
AND PC.CUST_ACCOUNT_ID IS NULL

Columns