Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AST_CUST_PROFILE_CREDIT_V |
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
, LK1.MEANING
, LK2.MEANING
, LK3.MEANING
, LK4.MEANING
, 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.SITE_USE_ID
, 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
FROM HZ_CUSTOMER_PROFILES CUST_PROFILE
, HZ_CUST_ACCOUNTS CUST_ACCT
, RA_TERMS STD_TERMS
, AR_COLLECTORS C
, RA_TERMS_VL PAY_TERMS
, FND_LOOKUPS LK1
, FND_LOOKUPS LK2
, FND_LOOKUPS LK3
, FND_LOOKUPS LK4
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.OVERRIDE_TERMS = LK1.LOOKUP_CODE(+)
AND LK1.LOOKUP_TYPE(+) = 'YES_NO'
AND CUST_PROFILE.DISCOUNT_TERMS = LK2.LOOKUP_CODE(+)
AND LK2.LOOKUP_TYPE(+) = 'YES_NO'
AND CUST_PROFILE.INTEREST_CHARGES = LK3.LOOKUP_CODE(+)
AND LK3.LOOKUP_TYPE(+)= 'YES_NO'
AND CUST_PROFILE.CREDIT_CHECKING = LK4.LOOKUP_CODE(+)
AND LK4.LOOKUP_TYPE(+) = 'YES_NO'