View: AR_CUSTOMER_PROFILE_CLASSES_V

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

View Text

SELECT CPC.ROWID ROW_ID
, CPC.PROFILE_CLASS_ID CUSTOMER_PROFILE_CLASS_ID
, CPC.LAST_UPDATED_BY LAST_UPDATED_BY
, CPC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CPC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CPC.CREATED_BY CREATED_BY
, CPC.CREATION_DATE CREATION_DATE
, CPC.NAME PROFILE_CLASS_NAME
, CPC.DESCRIPTION PROFILE_CLASS_DESCRIPTION
, CPC.STATUS STATUS
, CPC.COLLECTOR_ID COLLECTOR_ID
, COL.NAME COLLECTOR_NAME
, CPC.CREDIT_CHECKING CREDIT_CHECKING
, CPC.TOLERANCE TOLERANCE
, CPC.INTEREST_CHARGES INTEREST_CHARGES
, CPC.CHARGE_ON_FINANCE_CHARGE_FLAG CHARGE_ON_FINANCE_CHARGE_FLAG
, CPC.INTEREST_PERIOD_DAYS INTEREST_PERIOD_DAYS
, CPC.DISCOUNT_TERMS DISCOUNT_TERMS
, CPC.DISCOUNT_GRACE_DAYS DISCOUNT_GRACE_DAYS
, CPC.STATEMENTS STATEMENTS
, CPC.STATEMENT_CYCLE_ID STATEMENT_CYCLE_ID
, CYC.NAME STATEMENT_CYCLE_NAME
, CPC.CREDIT_BALANCE_STATEMENTS CREDIT_BALANCE_STATEMENTS
, CPC.STANDARD_TERMS STANDARD_TERMS
, TERM.NAME STANDARD_TERMS_NAME
, CPC.OVERRIDE_TERMS OVERRIDE_TERMS
, CPC.PAYMENT_GRACE_DAYS PAYMENT_GRACE_DAYS
, CPC.DUNNING_LETTERS DUNNING_LETTERS
, CPC.DUNNING_LETTER_SET_ID DUNNING_LETTER_SET_ID
, DUN_SET.NAME DUNNING_LETTER_SET_NAME
, CPC.AUTOCASH_HIERARCHY_ID AUTOCASH_HIERARCHY_ID
, HIER.HIERARCHY_NAME AUTOCASH_HIERARCHY_NAME
, CPC.COPY_METHOD COPY_METHOD
, CPC.AUTO_REC_INCL_DISPUTED_FLAG AUTO_REC_INCL_DISPUTED_FLAG
, CPC.TAX_PRINTING_OPTION TAX_PRINTING_OPTION
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('TAX_PRINTING_OPTION'
, CPC.TAX_PRINTING_OPTION) TAX_PRINTING_OPTION_MEANING
, CPC.GROUPING_RULE_ID GROUPING_RULE_ID
, CPC.REQUEST_ID REQUEST_ID
, GRP.NAME GROUPING_RULE_NAME
, NVL(CPC.CONS_INV_FLAG
, 'N' ) CONS_INV_FLAG
, CPC.CONS_INV_TYPE CONS_INV_TYPE
, INITCAP(CPC.CONS_INV_TYPE) CONS_INV_TYPE_MEANING
, CPC.CONS_BILL_LEVEL
, INITCAP(CPC.CONS_BILL_LEVEL) BILL_LEVEL_MEANING
, CPC.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CPC.ATTRIBUTE1 ATTRIBUTE1
, CPC.ATTRIBUTE2 ATTRIBUTE2
, CPC.ATTRIBUTE3 ATTRIBUTE3
, CPC.ATTRIBUTE4 ATTRIBUTE4
, CPC.ATTRIBUTE5 ATTRIBUTE5
, CPC.ATTRIBUTE6 ATTRIBUTE6
, CPC.ATTRIBUTE7 ATTRIBUTE7
, CPC.ATTRIBUTE8 ATTRIBUTE8
, CPC.ATTRIBUTE9 ATTRIBUTE9
, CPC.ATTRIBUTE10 ATTRIBUTE10
, CPC.ATTRIBUTE11 ATTRIBUTE11
, CPC.ATTRIBUTE12 ATTRIBUTE12
, CPC.ATTRIBUTE13 ATTRIBUTE13
, CPC.ATTRIBUTE14 ATTRIBUTE14
, CPC.ATTRIBUTE15 ATTRIBUTE15
, CPC.JGZZ_ATTRIBUTE_CATEGORY JGZZ_ATTRIBUTE_CATEGORY
, CPC.JGZZ_ATTRIBUTE1 JGZZ_ATTRIBUTE1
, CPC.JGZZ_ATTRIBUTE2 JGZZ_ATTRIBUTE2
, CPC.JGZZ_ATTRIBUTE3 JGZZ_ATTRIBUTE3
, CPC.JGZZ_ATTRIBUTE4 JGZZ_ATTRIBUTE4
, CPC.JGZZ_ATTRIBUTE5 JGZZ_ATTRIBUTE5
, CPC.JGZZ_ATTRIBUTE6 JGZZ_ATTRIBUTE6
, CPC.JGZZ_ATTRIBUTE7 JGZZ_ATTRIBUTE7
, CPC.JGZZ_ATTRIBUTE8 JGZZ_ATTRIBUTE8
, CPC.JGZZ_ATTRIBUTE9 JGZZ_ATTRIBUTE9
, CPC.JGZZ_ATTRIBUTE10 JGZZ_ATTRIBUTE10
, CPC.JGZZ_ATTRIBUTE11 JGZZ_ATTRIBUTE11
, CPC.JGZZ_ATTRIBUTE12 JGZZ_ATTRIBUTE12
, CPC.JGZZ_ATTRIBUTE13 JGZZ_ATTRIBUTE13
, CPC.JGZZ_ATTRIBUTE14 JGZZ_ATTRIBUTE14
, CPC.JGZZ_ATTRIBUTE15 JGZZ_ATTRIBUTE15
, CPC.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, CPC.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, CPC.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, CPC.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, CPC.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, CPC.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, CPC.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, CPC.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, CPC.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, CPC.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, CPC.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, CPC.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, CPC.GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, CPC.GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, CPC.GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, CPC.GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, CPC.GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, CPC.GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, CPC.GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, CPC.GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, CPC.GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, CPC.AUTOCASH_HIERARCHY_ID_FOR_ADR AUTOCASH_HIERARCHY_ID_FOR_ADR
, HIER_ADR.HIERARCHY_NAME AUTOCASH_HIERARCHY_NAME_ADR
, CPC.LOCKBOX_MATCHING_OPTION LOCKBOX_MATCHING_OPTION
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('ARLPLB_MATCHING_OPTION'
, CPC.LOCKBOX_MATCHING_OPTION) LOCKBOX_MATCHING_OPTION_NAME
, CPC.REVIEW_CYCLE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('PERIODIC_REVIEW_CYCLE'
, CPC.REVIEW_CYCLE)
, CPC.CREDIT_ANALYST_ID
, CA.PARTY_NAME
, CPC.CREDIT_CLASSIFICATION
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('AR_CMGT_CREDIT_CLASSIFICATION'
, CPC.CREDIT_CLASSIFICATION) CREDIT_CLASSIFICATION_MEANING
, CPC.LATE_CHARGE_CALCULATION_TRX LATE_CHARGE_CALCULATION_TRX
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('AR_MANDATORY_LATE_CHARGES'
, CPC.LATE_CHARGE_CALCULATION_TRX) LATE_CHARGE_CALCULATION_TRX_M
, CPC.CREDIT_ITEMS_FLAG CREDIT_ITEMS_FLAG
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('YES/NO'
, CPC.CREDIT_ITEMS_FLAG) CREDIT_ITEMS_FLAG_M
, CPC.DISPUTED_TRANSACTIONS_FLAG DISPUTED_TRANSACTIONS_FLAG
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('YES/NO'
, CPC.DISPUTED_TRANSACTIONS_FLAG) DISPUTED_TRANSACTIONS_FLAG_M
, CPC.LATE_CHARGE_TYPE LATE_CHARGE_TYPE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('AR_LATE_CHARGE_TYPE'
, CPC.LATE_CHARGE_TYPE) LATE_CHARGE_TYPE_M
, CPC.LATE_CHARGE_TERM_ID LATE_CHARGE_TERM_ID
, LATE_TERM.NAME LATE_TERM_NAME
, CPC.INTEREST_CALCULATION_PERIOD INTEREST_CALCULATION_PERIOD
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('AR_CALCULATION_PERIOD'
, CPC.INTEREST_CALCULATION_PERIOD) INTEREST_CALCULATION_PERIOD_M
, CPC.HOLD_CHARGED_INVOICES_FLAG HOLD_CHARGED_INVOICES_FLAG
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('YES/NO'
, CPC.HOLD_CHARGED_INVOICES_FLAG) HOLD_CHARGED_INVOICES_FLAG_M
, CPC.MESSAGE_TEXT_ID MESSAGE_TEXT_ID
, ARM.NAME MESSAGE_TEXT_NAME
, ARM.TEXT MESSAGE_TEXT_TEXT
, CPC.MULTIPLE_INTEREST_RATES_FLAG MULTIPLE_INTEREST_RATES_FLAG
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('YES/NO'
, CPC.MULTIPLE_INTEREST_RATES_FLAG) MULTIPLE_INTEREST_RATES_FLAG_M
, CPC.CHARGE_BEGIN_DATE CHARGE_BEGIN_DATE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('AR_FORMULAE'
, CPC.CHARGE_ON_FINANCE_CHARGE_FLAG) CHARGE_ON_FINANCE_CHARGE_FLAGM
FROM 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
, RA_TERMS LATE_TERM
, AR_STANDARD_TEXT ARM
WHERE COL.COLLECTOR_ID = CPC.COLLECTOR_ID
AND CYC.STATEMENT_CYCLE_ID(+) = CPC.STATEMENT_CYCLE_ID
AND TERM.TERM_ID(+) = CPC.STANDARD_TERMS
AND DUN_SET.DUNNING_LETTER_SET_ID(+) = CPC.DUNNING_LETTER_SET_ID
AND HIER.AUTOCASH_HIERARCHY_ID(+) = CPC.AUTOCASH_HIERARCHY_ID
AND GRP.GROUPING_RULE_ID(+) = CPC.GROUPING_RULE_ID
AND CPC.AUTOCASH_HIERARCHY_ID_FOR_ADR = HIER_ADR.AUTOCASH_HIERARCHY_ID(+)
AND CPC.CREDIT_ANALYST_ID = CA.PARTY_ID(+)
AND CPC.LATE_CHARGE_TERM_ID = LATE_TERM.TERM_ID(+)
AND CPC.MESSAGE_TEXT_ID = ARM.STANDARD_TEXT_ID(+)

Columns