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_IMP_CREDITRTNGS_INT#

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
BATCH_ID	NUMBER	(15)	Yes
PARTY_ORIG_SYSTEM	VARCHAR2	(30)	Yes
PARTY_ORIG_SYSTEM_REFERENCE	VARCHAR2	(240)	Yes
RATED_AS_OF_DATE	DATE		Yes
RATING_ORGANIZATION	VARCHAR2	(240)	Yes
INSERT_UPDATE_FLAG	VARCHAR2	(1)
AVG_HIGH_CREDIT	NUMBER
BANKRUPTCY_IND	VARCHAR2	(1)
BUSINESS_DISCONTINUED	VARCHAR2	(240)
CLAIMS_IND	VARCHAR2	(30)
COMMENTS	VARCHAR2	(240)
CR_SCR_CLAS_EXPL	VARCHAR2	(30)
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
CREDIT_SCORE_OVERRIDE_CODE	VARCHAR2	(30)
CRIMINAL_PROCEEDING_IND	VARCHAR2	(30)
DEBARMENT_IND	VARCHAR2	(1)
DEBARMENTS_COUNT	NUMBER
DEBARMENTS_DATE	DATE
DELQ_PMT_PCTG_FOR_ALL_FIRMS	NUMBER
DELQ_PMT_RNG_PRCNT	NUMBER
DESCRIPTION	VARCHAR2	(2000)
DET_HISTORY_IND	VARCHAR2	(30)
DISASTER_IND	VARCHAR2	(30)
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)
FINCL_EMBT_IND	VARCHAR2	(30)
FINCL_LGL_EVENT_IND	VARCHAR2	(30)
GLOBAL_FAILURE_SCORE	VARCHAR2	(5)
HIGH_CREDIT	NUMBER
HIGH_RNG_DELQ_SCR	NUMBER
JUDGEMENT_IND	VARCHAR2	(1)
LIEN_IND	VARCHAR2	(1)
LOW_RNG_DELQ_SCR	NUMBER
MAXIMUM_CREDIT_CURRENCY_CODE	VARCHAR2	(240)
MAXIMUM_CREDIT_RECOMMENDATION	NUMBER
NEGV_PMT_EXPL	VARCHAR2	(150)
NO_TRADE_IND	VARCHAR2	(1)
NUM_PRNT_BKCY_CONVS	NUMBER
NUM_PRNT_BKCY_FILING	NUMBER
NUM_SPCL_EVENT	NUMBER
NUM_TRADE_EXPERIENCES	NUMBER
OPRG_SPEC_EVNT_IND	VARCHAR2	(30)
OTHER_SPEC_EVNT_IND	VARCHAR2	(30)
PAYDEX_COMMENT	VARCHAR2	(240)
PAYDEX_FIRM_COMMENT	VARCHAR2	(60)
PAYDEX_FIRM_DAYS	VARCHAR2	(15)
PAYDEX_INDUSTRY_COMMENT	VARCHAR2	(50)
PAYDEX_INDUSTRY_DAYS	VARCHAR2	(15)
PAYDEX_NORM	VARCHAR2	(3)
PAYDEX_SCORE	VARCHAR2	(3)
PAYDEX_THREE_MONTHS_AGO	VARCHAR2	(3)
PRNT_BKCY_CHAPTER_CONV	VARCHAR2	(60)
PRNT_BKCY_CONV_DATE	DATE
PRNT_BKCY_FILG_DATE	DATE
PRNT_BKCY_FILG_TYPE	VARCHAR2	(20)
PRNT_BKCY_FILG_CHAPTER	NUMBER
PRNT_HQ_BKCY_IND	VARCHAR2	(1)
PUB_REC_EXPL	VARCHAR2	(150)
RATING	VARCHAR2	(60)
SECURED_FLNG_IND	VARCHAR2	(30)
SLOW_TRADE_EXPL	VARCHAR2	(100)
SPCL_EVENT_COMMENT	VARCHAR2	(150)
SPCL_EVENT_UPDATE_DATE	DATE
SPCL_EVNT_TXT	VARCHAR2	(2000)
SUIT_IND	VARCHAR2	(1)
INTERFACE_STATUS	VARCHAR2	(30)
ERROR_ID	NUMBER	(15)
CREATION_DATE	DATE
CREATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
REQUEST_ID	NUMBER	(15)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
CREATED_BY_MODULE	VARCHAR2	(30)
PARTY_ID	NUMBER	(15)

Query Text

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


SELECT BATCH_ID
,      PARTY_ORIG_SYSTEM
,      PARTY_ORIG_SYSTEM_REFERENCE
,      RATED_AS_OF_DATE
,      RATING_ORGANIZATION
,      INSERT_UPDATE_FLAG
,      AVG_HIGH_CREDIT
,      BANKRUPTCY_IND
,      BUSINESS_DISCONTINUED
,      CLAIMS_IND
,      COMMENTS
,      CR_SCR_CLAS_EXPL
,      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
,      CREDIT_SCORE_OVERRIDE_CODE
,      CRIMINAL_PROCEEDING_IND
,      DEBARMENT_IND
,      DEBARMENTS_COUNT
,      DEBARMENTS_DATE
,      DELQ_PMT_PCTG_FOR_ALL_FIRMS
,      DELQ_PMT_RNG_PRCNT
,      DESCRIPTION
,      DET_HISTORY_IND
,      DISASTER_IND
,      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
,      FINCL_EMBT_IND
,      FINCL_LGL_EVENT_IND
,      GLOBAL_FAILURE_SCORE
,      HIGH_CREDIT
,      HIGH_RNG_DELQ_SCR
,      JUDGEMENT_IND
,      LIEN_IND
,      LOW_RNG_DELQ_SCR
,      MAXIMUM_CREDIT_CURRENCY_CODE
,      MAXIMUM_CREDIT_RECOMMENDATION
,      NEGV_PMT_EXPL
,      NO_TRADE_IND
,      NUM_PRNT_BKCY_CONVS
,      NUM_PRNT_BKCY_FILING
,      NUM_SPCL_EVENT
,      NUM_TRADE_EXPERIENCES
,      OPRG_SPEC_EVNT_IND
,      OTHER_SPEC_EVNT_IND
,      PAYDEX_COMMENT
,      PAYDEX_FIRM_COMMENT
,      PAYDEX_FIRM_DAYS
,      PAYDEX_INDUSTRY_COMMENT
,      PAYDEX_INDUSTRY_DAYS
,      PAYDEX_NORM
,      PAYDEX_SCORE
,      PAYDEX_THREE_MONTHS_AGO
,      PRNT_BKCY_CHAPTER_CONV
,      PRNT_BKCY_CONV_DATE
,      PRNT_BKCY_FILG_DATE
,      PRNT_BKCY_FILG_TYPE
,      PRNT_BKCY_FILG_CHAPTER
,      PRNT_HQ_BKCY_IND
,      PUB_REC_EXPL
,      RATING
,      SECURED_FLNG_IND
,      SLOW_TRADE_EXPL
,      SPCL_EVENT_COMMENT
,      SPCL_EVENT_UPDATE_DATE
,      SPCL_EVNT_TXT
,      SUIT_IND
,      INTERFACE_STATUS
,      ERROR_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CREATED_BY_MODULE
,      PARTY_ID
FROM AR.HZ_IMP_CREDITRTNGS_INT#;

Dependencies

[top of page]

AR.HZ_IMP_CREDITRTNGS_INT# references the following:

AR: HZ_IMP_CREDITRTNGS_INT

AR.HZ_IMP_CREDITRTNGS_INT# is referenced by following:

APPS: HZ_IMP_CREDITRTNGS_INT