View: AR_CUSTOMER_PROFILES_V

Product:	AR - Receivables
Description:	(Release 11.5 Only)
Implementation/DBA Data:	APPS.AR_CUSTOMER_PROFILES_V

View Text

SELECT CP.ROWID ROW_ID
, CP.CUST_ACCOUNT_PROFILE_ID CUSTOMER_PROFILE_ID
, CP.CUST_ACCOUNT_ID CUSTOMER_ID
, CP.SITE_USE_ID SITE_USE_ID
, CP.PROFILE_CLASS_ID CUSTOMER_PROFILE_CLASS_ID
, CP.STATUS STATUS
, CPC.NAME PROFILE_CLASS_NAME
, CPC.DESCRIPTION PROFILE_CLASS_DESCRIPTION
, CP.LAST_UPDATED_BY LAST_UPDATED_BY
, CP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CP.OBJECT_VERSION_NUMBER OBJECT_VERSION
, CP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CP.CREATED_BY CREATED_BY
, CP.CREATION_DATE CREATION_DATE
, CP.COLLECTOR_ID COLLECTOR_ID
, COL.NAME COLLECTOR_NAME
, CP.CREDIT_CHECKING CREDIT_CHECKING
, CP.TOLERANCE TOLERANCE
, CP.DISCOUNT_TERMS DISCOUNT_TERMS
, CP.DUNNING_LETTERS DUNNING_LETTERS
, CP.INTEREST_CHARGES INTEREST_CHARGES
, CP.SEND_STATEMENTS STATEMENTS
, CP.CREDIT_BALANCE_STATEMENTS CREDIT_BALANCE_STATEMENTS
, CP.CREDIT_HOLD CREDIT_HOLD
, CP.CREDIT_RATING CREDIT_RATING
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('CREDIT_RATING'
, CP.CREDIT_RATING) CREDIT_RATING_MEANING
, CP.RISK_CODE RISK_CODE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('RISK_CODE'
, CP.RISK_CODE) RISK_MEANING
, CP.STANDARD_TERMS STANDARD_TERMS
, TERM.NAME STANDARD_TERMS_NAME
, CP.OVERRIDE_TERMS OVERRIDE_TERMS
, CP.DUNNING_LETTER_SET_ID DUNNING_LETTER_SET_ID
, DUN_SET.NAME DUNNING_LETTER_SET_NAME
, CP.INTEREST_PERIOD_DAYS INTEREST_PERIOD_DAYS
, CP.PAYMENT_GRACE_DAYS PAYMENT_GRACE_DAYS
, CP.DISCOUNT_GRACE_DAYS DISCOUNT_GRACE_DAYS
, CP.STATEMENT_CYCLE_ID STATEMENT_CYCLE_ID
, CYC.NAME STATEMENT_CYCLE_NAME
, CP.ACCOUNT_STATUS ACCOUNT_STATUS
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('ACCOUNT_STATUS'
, CP.ACCOUNT_STATUS) ACCOUNT_STATUS_MEANING
, CP.AUTOCASH_HIERARCHY_ID AUTOCASH_HIERARCHY_ID
, HIER.HIERARCHY_NAME AUTOCASH_HIERARCHY_NAME
, CP.AUTO_REC_INCL_DISPUTED_FLAG AUTO_REC_INCL_DISPUTED_FLAG
, CP.TAX_PRINTING_OPTION TAX_PRINTING_OPTION
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('TAX_PRINTING_OPTION'
, CP.TAX_PRINTING_OPTION) TAX_PRINTING_OPTION_MEANING
, CP.CHARGE_ON_FINANCE_CHARGE_FLAG CHARGE_ON_FINANCE_CHARGE_FLAG
, CP.GROUPING_RULE_ID GROUPING_RULE_ID
, GRP.NAME GROUPING_RULE_NAME
, NVL(CP.CONS_INV_FLAG
, 'N' ) CONS_INV_FLAG
, CP.CONS_INV_TYPE CONS_INV_TYPE
, CP.PERCENT_COLLECTABLE PERCENT_COLLECTABLE
, CP.CLEARING_DAYS CLEARING_DAYS
, CP.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CP.ATTRIBUTE1 ATTRIBUTE1
, CP.ATTRIBUTE2 ATTRIBUTE2
, CP.ATTRIBUTE3 ATTRIBUTE3
, CP.ATTRIBUTE4 ATTRIBUTE4
, CP.ATTRIBUTE5 ATTRIBUTE5
, CP.ATTRIBUTE6 ATTRIBUTE6
, CP.ATTRIBUTE7 ATTRIBUTE7
, CP.ATTRIBUTE8 ATTRIBUTE8
, CP.ATTRIBUTE9 ATTRIBUTE9
, CP.ATTRIBUTE10 ATTRIBUTE10
, CP.ATTRIBUTE11 ATTRIBUTE11
, CP.ATTRIBUTE12 ATTRIBUTE12
, CP.ATTRIBUTE13 ATTRIBUTE13
, CP.ATTRIBUTE14 ATTRIBUTE14
, CP.ATTRIBUTE15 ATTRIBUTE15
, CP.JGZZ_ATTRIBUTE_CATEGORY JGZZ_ATTRIBUTE_CATEGORY
, CP.JGZZ_ATTRIBUTE1 JGZZ_ATTRIBUTE1
, CP.JGZZ_ATTRIBUTE2 JGZZ_ATTRIBUTE2
, CP.JGZZ_ATTRIBUTE3 JGZZ_ATTRIBUTE3
, CP.JGZZ_ATTRIBUTE4 JGZZ_ATTRIBUTE4
, CP.JGZZ_ATTRIBUTE5 JGZZ_ATTRIBUTE5
, CP.JGZZ_ATTRIBUTE6 JGZZ_ATTRIBUTE6
, CP.JGZZ_ATTRIBUTE7 JGZZ_ATTRIBUTE7
, CP.JGZZ_ATTRIBUTE8 JGZZ_ATTRIBUTE8
, CP.JGZZ_ATTRIBUTE9 JGZZ_ATTRIBUTE9
, CP.JGZZ_ATTRIBUTE10 JGZZ_ATTRIBUTE10
, CP.JGZZ_ATTRIBUTE11 JGZZ_ATTRIBUTE11
, CP.JGZZ_ATTRIBUTE12 JGZZ_ATTRIBUTE12
, CP.JGZZ_ATTRIBUTE13 JGZZ_ATTRIBUTE13
, CP.JGZZ_ATTRIBUTE14 JGZZ_ATTRIBUTE14
, CP.JGZZ_ATTRIBUTE15 JGZZ_ATTRIBUTE15
, CP.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, CP.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, CP.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, CP.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, CP.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, CP.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, CP.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, CP.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, CP.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, CP.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, CP.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, CP.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, CP.GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, CP.GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, CP.GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, CP.GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, CP.GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, CP.GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, CP.GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, CP.GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, CP.GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, CP.AUTOCASH_HIERARCHY_ID_FOR_ADR AUTOCASH_HIERARCHY_ID_FOR_ADR
, HIER_ADR.HIERARCHY_NAME AUTOCASH_HIERARCHY_NAME_ADR
, CP.LOCKBOX_MATCHING_OPTION LOCKBOX_MATCHING_OPTION
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('ARLPLB_MATCHING_OPTION'
, CP.LOCKBOX_MATCHING_OPTION) LOCKBOX_MATCHING_OPTION_NAME
, CP.REVIEW_CYCLE REVIEW_CYCLE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('PERIODIC_REVIEW_CYCLE'
, CP.REVIEW_CYCLE) REVIEW_CYCLE_NAME
, CP.LAST_CREDIT_REVIEW_DATE
, CP.NEXT_CREDIT_REVIEW_DATE
, CP.CREDIT_ANALYST_ID CREDIT_ANALYST_ID
, CA.PARTY_NAME CREDIT_ANALYST_NAME
, CP.PARTY_ID PROFILE_PARTY_ID
, CP.CREDIT_CLASSIFICATION CREDIT_CLASSIFICATION
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('AR_CMGT_CREDIT_CLASSIFICATION'
, CP.CREDIT_CLASSIFICATION) CREDIT_CLASSIFICATION_MEANING
, SU.SITE_USE_CODE SITE_USE_CODE
FROM HZ_CUSTOMER_PROFILES CP
, HZ_CUST_PROFILE_CLASSES CPC
, AR_COLLECTORS COL
, AR_STATEMENT_CYCLES CYC
, RA_TERMS TERM
, AR_DUNNING_LETTER_SETS DUN_SET
, AR_AUTOCASH_HIERARCHIES HIER
, AR_AUTOCASH_HIERARCHIES HIER_ADR
, RA_GROUPING_RULES GRP
, HZ_PARTIES CA
, HZ_CUST_SITE_USES SU
WHERE CP.PROFILE_CLASS_ID = CPC.PROFILE_CLASS_ID(+)
AND CP.COLLECTOR_ID = COL.COLLECTOR_ID
AND CP.STATEMENT_CYCLE_ID = CYC.STATEMENT_CYCLE_ID(+)
AND CP.STANDARD_TERMS = TERM.TERM_ID(+)
AND CP.DUNNING_LETTER_SET_ID = DUN_SET.DUNNING_LETTER_SET_ID(+)
AND CP.AUTOCASH_HIERARCHY_ID = HIER.AUTOCASH_HIERARCHY_ID(+)
AND CP.AUTOCASH_HIERARCHY_ID_FOR_ADR = HIER_ADR.AUTOCASH_HIERARCHY_ID(+)
AND CP.GROUPING_RULE_ID = GRP.GROUPING_RULE_ID(+)
AND CP.CREDIT_ANALYST_ID = CA.PARTY_ID(+)
AND CP.SITE_USE_ID = SU.SITE_USE_ID (+)
AND (SU.SITE_USE_CODE IS NULL OR SU.SITE_USE_CODE IN ('BILL_TO'
, 'DUN'
, 'STMTS')) ORDER BY DECODE(NVL(SU.SITE_USE_CODE
, 'XX')
, 'XX'
, 0
, 'BILL_TO'
, 1
, 'DUN'
, 2
, 'STMTS'
, 3
, 4) ASC

Columns