[Home] [Help]
View: ICX_PANEL_CREDIT_INFO_V
Product: | ICX - Oracle iProcurement |
Description: | Customer Site Credit Profile View |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT ARF.CUSTOMER_ID
, RAS.ADDRESS_ID
, RAS.PRIMARY_FLAG
, RAS.STATUS
, RAS.LOCATION
, RAS.CONTACT_ID
, RAS.SIC_CODE
, ARF.STATUS
, ARF.COLLECTOR_ID
, ARF.CREDIT_CHECKING
, ARF.TOLERANCE
, ARF.DISCOUNT_TERMS
, ARF.DUNNING_LETTERS
, ARF.INTEREST_CHARGES
, ARF.CREDIT_HOLD
, ARF.RISK_CODE
, ARF.CREDIT_RATING
, ARF.PERCENT_COLLECTABLE
, ARF.SITE_USE_ID
FROM AR_CUSTOMER_PROFILES ARF
, RA_SITE_USES RAS
WHERE ARF.STATUS = 'A'
AND ARF.SITE_USE_ID = RAS.SITE_USE_ID
Columns
Name |
CUSTOMER_ID |
ADDRESS_ID |
PRIMARY_FLAG |
STATUS |
LOCATION |
CONTACT_ID |
SIC_CODE |
CUSTOMER_STATUS |
COLLECTOR_ID |
CREDIT_CHECKING |
TOLERANCE |
DISCOUNT_TERMS |
DUNNING_LETTERS |
INTEREST_CHARGES |
CREDIT_HOLD |
RISK_CODE |
CREDIT_RATING |
PERCENT_COLLECTABLE |
PRIMARY_SITE_USE_ID |