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]

TYPE: APPS.HZ_CREDIT_RATING_OBJ

Object Details

Object Name:	HZ_CREDIT_RATING_OBJ
Object Type:	TYPE
Owner:	APPS
Subobject Name:
Status:	VALID

Type Details

Type Code:	OBJECT
Predefined:	NO
Incomplete:	NO

Attributes

Name	Datatype	Length
ACTION_TYPE	VARCHAR2	(30)
COMMON_OBJ_ID	VARCHAR2	(255)
CREDIT_RATING_ID	NUMBER
DESCRIPTION	VARCHAR2	(2000)
ORGANIZATION_ID	NUMBER
RATING	VARCHAR2	(60)
RATED_AS_OF_DATE	DATE
RATING_ORGANIZATION	VARCHAR2	(240)
COMMENTS	VARCHAR2	(240)
DET_HISTORY_IND	VARCHAR2	(5)
FINCL_EMBT_IND	VARCHAR2	(5)
CRIMINAL_PROCEEDING_IND	VARCHAR2	(5)
CLAIMS_IND	VARCHAR2	(5)
SECURED_FLNG_IND	VARCHAR2	(5)
FINCL_LGL_EVENT_IND	VARCHAR2	(5)
DISASTER_IND	VARCHAR2	(5)
OPRG_SPEC_EVNT_IND	VARCHAR2	(5)
OTHER_SPEC_EVNT_IND	VARCHAR2	(5)
STATUS	VARCHAR2	(1)
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
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_PER	NUMBER
FAILURE_SCORE_OVERRIDE_CODE	VARCHAR2	(30)
GLOBAL_FAILURE_SCORE	VARCHAR2	(30)
DEBARMENT_IND	VARCHAR2	(30)
DEBARMENTS_COUNT	NUMBER
DEBARMENTS_DATE	DATE
HIGH_CREDIT	NUMBER
MAXIMUM_CREDIT_CURRENCY_CODE	VARCHAR2	(240)
MAXIMUM_CREDIT_RCMD	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	(5)
LIEN_IND	VARCHAR2	(5)
JUDGEMENT_IND	VARCHAR2	(5)
BANKRUPTCY_IND	VARCHAR2	(5)
NO_TRADE_IND	VARCHAR2	(5)
PRNT_HQ_BKCY_IND	VARCHAR2	(5)
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)
ACTUAL_CONTENT_SOURCE	VARCHAR2	(30)
PROGRAM_UPDATE_DATE	DATE
CREATED_BY_MODULE	VARCHAR2	(150)
CREATED_BY_NAME	VARCHAR2	(100)
CREATION_DATE	DATE
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY_NAME	VARCHAR2	(100)

Methods

Name	Parameters	Result
CREATE_OBJECT	P_CREDIT_RATING_ID(NUMBER) P_DESCRIPTION(VARCHAR2) P_RATING(VARCHAR2) P_RATED_AS_OF_DATE(DATE) P_RATING_ORGANIZATION(VARCHAR2) P_COMMENTS(VARCHAR2) P_DET_HISTORY_IND(VARCHAR2) P_FINCL_EMBT_IND(VARCHAR2) P_CRIMINAL_PROCEEDING_IND(VARCHAR2) P_CLAIMS_IND(VARCHAR2) P_SECURED_FLNG_IND(VARCHAR2) P_FINCL_LGL_EVENT_IND(VARCHAR2) P_DISASTER_IND(VARCHAR2) P_OPRG_SPEC_EVNT_IND(VARCHAR2) P_OTHER_SPEC_EVNT_IND(VARCHAR2) P_STATUS(VARCHAR2) P_AVG_HIGH_CREDIT(NUMBER) P_CREDIT_SCORE(VARCHAR2) P_CREDIT_SCORE_AGE(NUMBER) P_CREDIT_SCORE_CLASS(NUMBER) P_CREDIT_SCORE_COMMENTARY(VARCHAR2) P_CREDIT_SCORE_COMMENTARY2(VARCHAR2) P_CREDIT_SCORE_COMMENTARY3(VARCHAR2) P_CREDIT_SCORE_COMMENTARY4(VARCHAR2) P_CREDIT_SCORE_COMMENTARY5(VARCHAR2) P_CREDIT_SCORE_COMMENTARY6(VARCHAR2) P_CREDIT_SCORE_COMMENTARY7(VARCHAR2) P_CREDIT_SCORE_COMMENTARY8(VARCHAR2) P_CREDIT_SCORE_COMMENTARY9(VARCHAR2) P_CREDIT_SCORE_COMMENTARY10(VARCHAR2) P_CREDIT_SCORE_DATE(DATE) P_CREDIT_SCORE_INCD_DEFAULT(NUMBER) P_CREDIT_SCORE_NATL_PERCENTILE(NUMBER) P_FAILURE_SCORE(VARCHAR2) P_FAILURE_SCORE_AGE(NUMBER) P_FAILURE_SCORE_CLASS(NUMBER) P_FAILURE_SCORE_COMMENTARY(VARCHAR2) P_FAILURE_SCORE_COMMENTARY2(VARCHAR2) P_FAILURE_SCORE_COMMENTARY3(VARCHAR2) P_FAILURE_SCORE_COMMENTARY4(VARCHAR2) P_FAILURE_SCORE_COMMENTARY5(VARCHAR2) P_FAILURE_SCORE_COMMENTARY6(VARCHAR2) P_FAILURE_SCORE_COMMENTARY7(VARCHAR2) P_FAILURE_SCORE_COMMENTARY8(VARCHAR2) P_FAILURE_SCORE_COMMENTARY9(VARCHAR2) P_FAILURE_SCORE_COMMENTARY10(VARCHAR2) P_FAILURE_SCORE_DATE(DATE) P_FAILURE_SCORE_INCD_DEFAULT(NUMBER) P_FAILURE_SCORE_NATNL_PER(NUMBER) P_FAILURE_SCORE_OVERRIDE_CODE(VARCHAR2) P_GLOBAL_FAILURE_SCORE(VARCHAR2) P_DEBARMENT_IND(VARCHAR2) P_DEBARMENTS_COUNT(NUMBER) P_DEBARMENTS_DATE(DATE) P_HIGH_CREDIT(NUMBER) P_MAXIMUM_CREDIT_CURRENCY_CODE(VARCHAR2) P_MAXIMUM_CREDIT_RCMD(NUMBER) P_PAYDEX_NORM(VARCHAR2) P_PAYDEX_SCORE(VARCHAR2) P_PAYDEX_THREE_MONTHS_AGO(VARCHAR2) P_CREDIT_SCORE_OVERRIDE_CODE(VARCHAR2) P_CR_SCR_CLAS_EXPL(VARCHAR2) P_LOW_RNG_DELQ_SCR(NUMBER) P_HIGH_RNG_DELQ_SCR(NUMBER) P_DELQ_PMT_RNG_PRCNT(NUMBER) P_DELQ_PMT_PCTG_FOR_ALL_FIRMS(NUMBER) P_NUM_TRADE_EXPERIENCES(NUMBER) P_PAYDEX_FIRM_DAYS(VARCHAR2) P_PAYDEX_FIRM_COMMENT(VARCHAR2) P_PAYDEX_INDUSTRY_DAYS(VARCHAR2) P_PAYDEX_INDUSTRY_COMMENT(VARCHAR2) P_PAYDEX_COMMENT(VARCHAR2) P_SUIT_IND(VARCHAR2) P_LIEN_IND(VARCHAR2) P_JUDGEMENT_IND(VARCHAR2) P_BANKRUPTCY_IND(VARCHAR2) P_NO_TRADE_IND(VARCHAR2) P_PRNT_HQ_BKCY_IND(VARCHAR2) P_NUM_PRNT_BKCY_FILING(NUMBER) P_PRNT_BKCY_FILG_TYPE(VARCHAR2) P_PRNT_BKCY_FILG_CHAPTER(NUMBER) P_PRNT_BKCY_FILG_DATE(DATE) P_NUM_PRNT_BKCY_CONVS(NUMBER) P_PRNT_BKCY_CONV_DATE(DATE) P_PRNT_BKCY_CHAPTER_CONV(VARCHAR2) P_SLOW_TRADE_EXPL(VARCHAR2) P_NEGV_PMT_EXPL(VARCHAR2) P_PUB_REC_EXPL(VARCHAR2) P_BUSINESS_DISCONTINUED(VARCHAR2) P_SPCL_EVENT_COMMENT(VARCHAR2) P_NUM_SPCL_EVENT(NUMBER) P_SPCL_EVENT_UPDATE_DATE(DATE) P_SPCL_EVNT_TXT(VARCHAR2) P_ACTUAL_CONTENT_SOURCE(VARCHAR2)	HZ_CREDIT_RATING_OBJ

Dependencies

[top of page]

APPS.HZ_CREDIT_RATING_OBJ references the following:

SYS: STANDARD - show dependent code

APPS.HZ_CREDIT_RATING_OBJ is referenced by following:

APPS: HZ_CREDIT_RATING_OBJ; HZ_CREDIT_RATING_OBJ_TBL; HZ_EXTRACT_ORGANIZATION_BO_PVT - show dependent code; HZ_ORGANIZATION_BO_PUB - show dependent code; POS_SUPPLIER_BO_DEP_PKG - show dependent code