Product: | XNC - Sales for Communications (Obsolete) |
---|---|
Description: | XNC_CUST_PROFILE_CREDIT_V retrieves credit profiles for customer accounts. |
Implementation/DBA Data: | Not implemented in this database |
SELECT CUST_PROFILE.ROWID
, CUST_ACCOUNT_PROFILE_ID
, CUST_PROFILE.CUST_ACCOUNT_ID
, RISK_CODE
, PROFILE_CLASS_ID
, CUST_ACCT.LAST_UPDATE_DATE CUST_ACCT_LAST_UPDATE_DATE
, CUST_PROFILE.LAST_UPDATE_DATE CUST_PROFILE_LAST_UPDATE_DATE
, CREDIT_RATING
, CUST_PROFILE.STATUS
, RESTRICTION_LIMIT_AMOUNT
, TOLERANCE
, CLEARING_DAYS
, STANDARD_TERMS
, STD_TERMS.NAME STANDARD_TERMS_NAME
, OVERRIDE_TERMS
, DISCOUNT_TERMS
, INTEREST_CHARGES
, CREDIT_CHECKING
, NEXT_CREDIT_REVIEW_DATE
, INTEREST_PERIOD_DAYS
, PAYMENT_GRACE_DAYS
, DISCOUNT_GRACE_DAYS
, CUST_PROFILE.COLLECTOR_ID
, C.NAME COLLECTOR_NAME
, CREDIT_ANALYST_ID
, CUST_ACCT.WRITE_OFF_PAYMENT_AMOUNT
, CUST_ACCT.WRITE_OFF_AMOUNT
, CUST_ACCT.PAYMENT_TERM_ID
, PAY_TERMS.NAME PAYMENT_TERM_NAME
, CUST_ACCT.DEPOSIT_REFUND_METHOD
, CUST_ACCT.CREDIT_CLASSIFICATION_CODE
, CUST_PROFILE.STATEMENT_CYCLE_ID
, AR_CYCLES.NAME
FROM JTF_CUSTOMER_PROFILES_V CUST_PROFILE
, JTF_CUST_ACCOUNTS_V CUST_ACCT
, RA_TERMS STD_TERMS
, AR_COLLECTORS C
, RA_TERMS_VL PAY_TERMS
, AR_STATEMENT_CYCLES AR_CYCLES
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(+)
AND CUST_PROFILE.STATEMENT_CYCLE_ID = AR_CYCLES.STATEMENT_CYCLE_ID