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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: AR.HZ_CREDIT_RATINGS#

Object Details

Object Name:	HZ_CREDIT_RATINGS#
Object Type:	VIEW
Owner:	AR
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
CREDIT_RATING_ID	NUMBER	(15)	Yes
DESCRIPTION	VARCHAR2	(2000)
PARTY_ID	NUMBER	(15)	Yes
RATING	VARCHAR2	(60)
RATED_AS_OF_DATE	DATE
RATING_ORGANIZATION	VARCHAR2	(240)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
REQUEST_ID	NUMBER	(15)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
WH_UPDATE_DATE	DATE
COMMENTS	VARCHAR2	(240)
DET_HISTORY_IND	VARCHAR2	(30)
FINCL_EMBT_IND	VARCHAR2	(30)
CRIMINAL_PROCEEDING_IND	VARCHAR2	(30)
SUIT_JUDGE_IND	VARCHAR2	(30)
CLAIMS_IND	VARCHAR2	(30)
SECURED_FLNG_IND	VARCHAR2	(30)
FINCL_LGL_EVENT_IND	VARCHAR2	(30)
DISASTER_IND	VARCHAR2	(30)
OPRG_SPEC_EVNT_IND	VARCHAR2	(30)
OTHER_SPEC_EVNT_IND	VARCHAR2	(30)
CONTENT_SOURCE_TYPE	VARCHAR2	(30)	Yes
STATUS	VARCHAR2	(1)
OBJECT_VERSION_NUMBER	NUMBER
CREATED_BY_MODULE	VARCHAR2	(150)
APPLICATION_ID	NUMBER
AVG_HIGH_CREDIT	NUMBER
CREDIT_SCORE	VARCHAR2	(30)
CREDIT_SCORE_AGE	NUMBER
CREDIT_SCORE_CLASS	NUMBER
CREDIT_SCORE_COMMENTARY	VARCHAR2	(30)
CREDIT_SCORE_COMMENTARY2	VARCHAR2	(30)
CREDIT_SCORE_COMMENTARY3	VARCHAR2	(30)
CREDIT_SCORE_COMMENTARY4	VARCHAR2	(30)
CREDIT_SCORE_COMMENTARY5	VARCHAR2	(30)
CREDIT_SCORE_COMMENTARY6	VARCHAR2	(30)
CREDIT_SCORE_COMMENTARY7	VARCHAR2	(30)
CREDIT_SCORE_COMMENTARY8	VARCHAR2	(30)
CREDIT_SCORE_COMMENTARY9	VARCHAR2	(30)
CREDIT_SCORE_COMMENTARY10	VARCHAR2	(30)
CREDIT_SCORE_DATE	DATE
CREDIT_SCORE_INCD_DEFAULT	NUMBER
CREDIT_SCORE_NATL_PERCENTILE	NUMBER
DEBARMENT_IND	VARCHAR2	(1)
DEBARMENTS_COUNT	NUMBER
DEBARMENTS_DATE	DATE
HIGH_CREDIT	NUMBER
MAXIMUM_CREDIT_CURRENCY_CODE	VARCHAR2	(240)
MAXIMUM_CREDIT_RECOMMENDATION	NUMBER
PAYDEX_NORM	VARCHAR2	(3)
PAYDEX_SCORE	VARCHAR2	(3)
PAYDEX_THREE_MONTHS_AGO	VARCHAR2	(3)
CREDIT_SCORE_OVERRIDE_CODE	VARCHAR2	(30)
CR_SCR_CLAS_EXPL	VARCHAR2	(30)
LOW_RNG_DELQ_SCR	NUMBER
HIGH_RNG_DELQ_SCR	NUMBER
DELQ_PMT_RNG_PRCNT	NUMBER
DELQ_PMT_PCTG_FOR_ALL_FIRMS	NUMBER
NUM_TRADE_EXPERIENCES	NUMBER
PAYDEX_FIRM_DAYS	VARCHAR2	(15)
PAYDEX_FIRM_COMMENT	VARCHAR2	(60)
PAYDEX_INDUSTRY_DAYS	VARCHAR2	(15)
PAYDEX_INDUSTRY_COMMENT	VARCHAR2	(50)
PAYDEX_COMMENT	VARCHAR2	(240)
SUIT_IND	VARCHAR2	(1)
LIEN_IND	VARCHAR2	(1)
JUDGEMENT_IND	VARCHAR2	(1)
BANKRUPTCY_IND	VARCHAR2	(1)
NO_TRADE_IND	VARCHAR2	(1)
PRNT_HQ_BKCY_IND	VARCHAR2	(1)
NUM_PRNT_BKCY_FILING	NUMBER
PRNT_BKCY_FILG_TYPE	VARCHAR2	(20)
PRNT_BKCY_FILG_CHAPTER	NUMBER
PRNT_BKCY_FILG_DATE	DATE
NUM_PRNT_BKCY_CONVS	NUMBER
PRNT_BKCY_CONV_DATE	DATE
PRNT_BKCY_CHAPTER_CONV	VARCHAR2	(60)
SLOW_TRADE_EXPL	VARCHAR2	(100)
NEGV_PMT_EXPL	VARCHAR2	(150)
PUB_REC_EXPL	VARCHAR2	(150)
BUSINESS_DISCONTINUED	VARCHAR2	(240)
SPCL_EVENT_COMMENT	VARCHAR2	(150)
NUM_SPCL_EVENT	NUMBER
SPCL_EVENT_UPDATE_DATE	DATE
SPCL_EVNT_TXT	VARCHAR2	(2000)
FAILURE_SCORE	VARCHAR2	(30)
FAILURE_SCORE_AGE	NUMBER
FAILURE_SCORE_CLASS	NUMBER
FAILURE_SCORE_COMMENTARY	VARCHAR2	(30)
FAILURE_SCORE_COMMENTARY2	VARCHAR2	(30)
FAILURE_SCORE_COMMENTARY3	VARCHAR2	(30)
FAILURE_SCORE_COMMENTARY4	VARCHAR2	(30)
FAILURE_SCORE_COMMENTARY5	VARCHAR2	(30)
FAILURE_SCORE_COMMENTARY6	VARCHAR2	(30)
FAILURE_SCORE_COMMENTARY7	VARCHAR2	(30)
FAILURE_SCORE_COMMENTARY8	VARCHAR2	(30)
FAILURE_SCORE_COMMENTARY9	VARCHAR2	(30)
FAILURE_SCORE_COMMENTARY10	VARCHAR2	(30)
FAILURE_SCORE_DATE	DATE
FAILURE_SCORE_INCD_DEFAULT	NUMBER
FAILURE_SCORE_NATNL_PERCENTILE	NUMBER
FAILURE_SCORE_OVERRIDE_CODE	VARCHAR2	(30)
GLOBAL_FAILURE_SCORE	VARCHAR2	(5)
ACTUAL_CONTENT_SOURCE	VARCHAR2	(30)	Yes

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CREDIT_RATING_ID
,      DESCRIPTION
,      PARTY_ID
,      RATING
,      RATED_AS_OF_DATE
,      RATING_ORGANIZATION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      WH_UPDATE_DATE
,      COMMENTS
,      DET_HISTORY_IND
,      FINCL_EMBT_IND
,      CRIMINAL_PROCEEDING_IND
,      SUIT_JUDGE_IND
,      CLAIMS_IND
,      SECURED_FLNG_IND
,      FINCL_LGL_EVENT_IND
,      DISASTER_IND
,      OPRG_SPEC_EVNT_IND
,      OTHER_SPEC_EVNT_IND
,      CONTENT_SOURCE_TYPE
,      STATUS
,      OBJECT_VERSION_NUMBER
,      CREATED_BY_MODULE
,      APPLICATION_ID
,      AVG_HIGH_CREDIT
,      CREDIT_SCORE
,      CREDIT_SCORE_AGE
,      CREDIT_SCORE_CLASS
,      CREDIT_SCORE_COMMENTARY
,      CREDIT_SCORE_COMMENTARY2
,      CREDIT_SCORE_COMMENTARY3
,      CREDIT_SCORE_COMMENTARY4
,      CREDIT_SCORE_COMMENTARY5
,      CREDIT_SCORE_COMMENTARY6
,      CREDIT_SCORE_COMMENTARY7
,      CREDIT_SCORE_COMMENTARY8
,      CREDIT_SCORE_COMMENTARY9
,      CREDIT_SCORE_COMMENTARY10
,      CREDIT_SCORE_DATE
,      CREDIT_SCORE_INCD_DEFAULT
,      CREDIT_SCORE_NATL_PERCENTILE
,      DEBARMENT_IND
,      DEBARMENTS_COUNT
,      DEBARMENTS_DATE
,      HIGH_CREDIT
,      MAXIMUM_CREDIT_CURRENCY_CODE
,      MAXIMUM_CREDIT_RECOMMENDATION
,      PAYDEX_NORM
,      PAYDEX_SCORE
,      PAYDEX_THREE_MONTHS_AGO
,      CREDIT_SCORE_OVERRIDE_CODE
,      CR_SCR_CLAS_EXPL
,      LOW_RNG_DELQ_SCR
,      HIGH_RNG_DELQ_SCR
,      DELQ_PMT_RNG_PRCNT
,      DELQ_PMT_PCTG_FOR_ALL_FIRMS
,      NUM_TRADE_EXPERIENCES
,      PAYDEX_FIRM_DAYS
,      PAYDEX_FIRM_COMMENT
,      PAYDEX_INDUSTRY_DAYS
,      PAYDEX_INDUSTRY_COMMENT
,      PAYDEX_COMMENT
,      SUIT_IND
,      LIEN_IND
,      JUDGEMENT_IND
,      BANKRUPTCY_IND
,      NO_TRADE_IND
,      PRNT_HQ_BKCY_IND
,      NUM_PRNT_BKCY_FILING
,      PRNT_BKCY_FILG_TYPE
,      PRNT_BKCY_FILG_CHAPTER
,      PRNT_BKCY_FILG_DATE
,      NUM_PRNT_BKCY_CONVS
,      PRNT_BKCY_CONV_DATE
,      PRNT_BKCY_CHAPTER_CONV
,      SLOW_TRADE_EXPL
,      NEGV_PMT_EXPL
,      PUB_REC_EXPL
,      BUSINESS_DISCONTINUED
,      SPCL_EVENT_COMMENT
,      NUM_SPCL_EVENT
,      SPCL_EVENT_UPDATE_DATE
,      SPCL_EVNT_TXT
,      FAILURE_SCORE
,      FAILURE_SCORE_AGE
,      FAILURE_SCORE_CLASS
,      FAILURE_SCORE_COMMENTARY
,      FAILURE_SCORE_COMMENTARY2
,      FAILURE_SCORE_COMMENTARY3
,      FAILURE_SCORE_COMMENTARY4
,      FAILURE_SCORE_COMMENTARY5
,      FAILURE_SCORE_COMMENTARY6
,      FAILURE_SCORE_COMMENTARY7
,      FAILURE_SCORE_COMMENTARY8
,      FAILURE_SCORE_COMMENTARY9
,      FAILURE_SCORE_COMMENTARY10
,      FAILURE_SCORE_DATE
,      FAILURE_SCORE_INCD_DEFAULT
,      FAILURE_SCORE_NATNL_PERCENTILE
,      FAILURE_SCORE_OVERRIDE_CODE
,      GLOBAL_FAILURE_SCORE
,      ACTUAL_CONTENT_SOURCE
FROM AR.HZ_CREDIT_RATINGS#;

Dependencies

[top of page]

AR.HZ_CREDIT_RATINGS# references the following:

AR: HZ_CREDIT_RATINGS

AR.HZ_CREDIT_RATINGS# is referenced by following:

APPS: HZ_CREDIT_RATINGS