eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.AR_CUSTOMER_PROFILES_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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