View: CSC_CUST_PROFILE_CREDIT_V

Product:	CSC - Customer Care
Description:
Implementation/DBA Data:	APPS.CSC_CUST_PROFILE_CREDIT_V

View Text

SELECT CUST_PROFILE.ROWID
, CUST_ACCOUNT_PROFILE_ID
, CUST_PROFILE.CUST_ACCOUNT_ID
, RISK_CODE
, PROFILE_CLASS_ID
, CREDIT_RATING
, CUST_PROFILE.STATUS
, RESTRICTION_LIMIT_AMOUNT
, TOLERANCE
, CLEARING_DAYS
, STANDARD_TERMS
, STD_TERMS.NAME
, DECODE(UPPER(OVERRIDE_TERMS)
, 'Y'
, 'YES'
, 'N'
, 'NO')
, DECODE(UPPER(DISCOUNT_TERMS)
, 'Y'
, 'YES'
, 'N'
, 'NO')
, DECODE(UPPER(INTEREST_CHARGES)
, 'Y'
, 'YES'
, 'N'
, 'NO')
, DECODE(UPPER(CREDIT_CHECKING)
, 'Y'
, 'YES'
, 'N'
, 'NO')
, NEXT_CREDIT_REVIEW_DATE
, INTEREST_PERIOD_DAYS
, PAYMENT_GRACE_DAYS
, DISCOUNT_GRACE_DAYS
, CUST_PROFILE.COLLECTOR_ID
, C.NAME
, CREDIT_ANALYST_ID
, CUST_ACCT.WRITE_OFF_PAYMENT_AMOUNT
, CUST_ACCT.WRITE_OFF_AMOUNT
, CUST_ACCT.PAYMENT_TERM_ID
, PAY_TERMS.NAME
, CUST_ACCT.DEPOSIT_REFUND_METHOD
, CUST_ACCT.CREDIT_CLASSIFICATION_CODE
, CUST_ACCT.LAST_UPDATE_DATE
, CUST_PROFILE.LAST_UPDATE_DATE
, CUST_PROFILE.LAST_UPDATED_BY
, CUST_PROFILE.CREATION_DATE
, CUST_PROFILE.CREATED_BY
, CUST_PROFILE.LAST_UPDATE_LOGIN
, CUST_PROFILE.ATTRIBUTE_CATEGORY
, CUST_PROFILE.ATTRIBUTE1
, CUST_PROFILE.ATTRIBUTE2
, CUST_PROFILE.ATTRIBUTE3
, CUST_PROFILE.ATTRIBUTE4
, CUST_PROFILE.ATTRIBUTE5
, CUST_PROFILE.ATTRIBUTE6
, CUST_PROFILE.ATTRIBUTE7
, CUST_PROFILE.ATTRIBUTE8
, CUST_PROFILE.ATTRIBUTE9
, CUST_PROFILE.ATTRIBUTE10
, CUST_PROFILE.ATTRIBUTE11
, CUST_PROFILE.ATTRIBUTE12
, CUST_PROFILE.ATTRIBUTE13
, CUST_PROFILE.ATTRIBUTE14
, CUST_PROFILE.ATTRIBUTE15
, CUST_PROFILE.CREDIT_HOLD
, CUST_PROFILE.SITE_USE_ID
FROM HZ_CUSTOMER_PROFILES CUST_PROFILE
, HZ_CUST_ACCOUNTS CUST_ACCT
, RA_TERMS STD_TERMS
, AR_COLLECTORS C
, RA_TERMS_VL PAY_TERMS
WHERE CUST_PROFILE.CUST_ACCOUNT_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND CUST_PROFILE.STANDARD_TERMS = STD_TERMS.TERM_ID(+)
AND TRUNC(SYSDATE) BETWEEN NVL(STD_TERMS.START_DATE_ACTIVE
, SYSDATE-1)
AND NVL(STD_TERMS.END_DATE_ACTIVE
, TRUNC(SYSDATE))
AND CUST_PROFILE.COLLECTOR_ID = C.COLLECTOR_ID
AND C.STATUS = 'A'
AND CUST_ACCT.PAYMENT_TERM_ID = PAY_TERMS.TERM_ID(+)

Columns