VIEW: APPS.CSC_CUSTOMERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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