View: AR_TA_CR_AGEN_INF_V

View Text

SELECT SUBSTRB(PARTY.PARTY_NAME
, 1
, 50)
, CUST_ACCT.ACCOUNT_NUMBER
, SU.LOCATION
, CA.CREDIT_AGENCY_NUMBER
, CA.CURRENT_RATING
, CA.PREVIOUS_RATING
, CA.FINANCING
, CA.CONDITION
, CA.SALES
, CA.WORTH
, CA.TREND
, CA.START_DATE
, CA.TOTAL_EMPLOYEES
, CA.HISTORY
, CA.LAST_FINANCIAL_DATE
, CA.LAST_DATE_REPORT
, CA.CREDIT_SCORE
, CA.STRESS_SCORE
, CA.PAYDEX_SCORE
, CA.CUSTOMER_ID
, CA.CUSTOMER_SITE_USE_ID
, CA.CREATION_DATE
, CA.CREATED_BY
, CA.LAST_UPDATE_DATE
, CA.LAST_UPDATED_BY
, CA.LAST_UPDATE_LOGIN
, CA.ATTRIBUTE_CATEGORY
, CA.ATTRIBUTE1
, CA.ATTRIBUTE2
, CA.ATTRIBUTE3
, CA.ATTRIBUTE4
, CA.ATTRIBUTE5
, CA.ATTRIBUTE6
, CA.ATTRIBUTE7
, CA.ATTRIBUTE8
, CA.ATTRIBUTE9
, CA.ATTRIBUTE10
, CA.ATTRIBUTE11
, CA.ATTRIBUTE12
, CA.ATTRIBUTE13
, CA.ATTRIBUTE14
, CA.ATTRIBUTE15
, CA.ORG_ID
, CA.ROW_ID
FROM HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTIES PARTY
, HZ_CUST_SITE_USES SU
, HZ_CUST_ACCT_SITES ACCT_SITE
, AR_TA_CR_AGEN_INF CA
WHERE ACCT_SITE.CUST_ACCOUNT_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
AND UPPER(SU.SITE_USE_CODE) = 'BILL_TO'
AND SU.STATUS = 'A'
AND ACCT_SITE.CUST_ACCOUNT_ID = CA.CUSTOMER_ID
AND SU.SITE_USE_ID = CA.CUSTOMER_SITE_USE_ID

Columns