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]

TABLE: AR.AR_CMGT_CASE_FOLDERS

Object Details

Object Name:	AR_CMGT_CASE_FOLDERS
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.AR_CMGT_CASE_FOLDERS
Subobject Name:
Status:	VALID

The AR_CMGT_CASE_FOLDERS table stores information for each case folder. A case folder is the repository for all data, credit analyst notes, and credit score results for a credit review, from which credit recommendations are made. Oracle Credit Management uses the information contained in case folders to provide credit performance trends and to assess credit policy effectiveness.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_CMGT_CASE_FOLDERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CASE_FOLDER_ID
AR_CMGT_CASE_FOLDERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREDIT_REQUEST_ID
AR_CMGT_CASE_FOLDERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHECK_LIST_ID
AR_CMGT_CASE_FOLDERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTY_ID CUST_ACCOUNT_ID SITE_USE_ID
AR_CMGT_CASE_FOLDERS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREDIT_ANALYST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CASE_FOLDER_ID	NUMBER	(15)	Yes	Identifier of the this case folder
CASE_FOLDER_NUMBER	VARCHAR2	(30)	Yes	Case folder number
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREDIT_REQUEST_ID	NUMBER	(15)		Identifier of the credit request associated with the this case folder
CHECK_LIST_ID	NUMBER	(15)		Identifier of the check list associated with this case folder
STATUS	VARCHAR2	(15)		Identifies whether the this case folder is open or closed.
CUST_ACCOUNT_ID	NUMBER	(15)		Customer account identifier
PARTY_ID	NUMBER	(15)		Party identifier
SCORE_MODEL_ID	NUMBER	(15)		Identifier of the score scoring model associated with this case folder
SITE_USE_ID	NUMBER	(15)		Identifies the customers location
CREDIT_CLASSIFICATION	VARCHAR2	(30)		Credit classification
REVIEW_TYPE	VARCHAR2	(30)		Credit review Ttype
CREDIT_ANALYST_ID	NUMBER	(15)		Credit analyst Iidentifier
TYPE	VARCHAR2	(15)	Yes	Identifier of the Ccase folder type, either whether CASE_FOLDER/ or DATA
DISPLAY_FLAG	VARCHAR2	(1)		Identifies whether to display the this case folder.
CREATION_DATE_TIME	DATE			Case folder creation date and time
LAST_UPDATED	DATE			Last updated date
LIMIT_CURRENCY	VARCHAR2	(30)		Currency of the credit limit defined
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Exchange rate type of the this case folder
REVIEW_CYCLE	VARCHAR2	(30)		Stores the periodic credit review cycles
REQUEST_ID	NUMBER	(15)		Concurrent request ID
PREVIOUS_CREDIT_ANALYST_ID	NUMBER	(15)		Previous Credit Analyst Identifier
ORIGINAL_CREDIT_ANALYST_ID	NUMBER	(15)		Original Credit Analyst Identifier

Query Text

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


SELECT CASE_FOLDER_ID
,      CASE_FOLDER_NUMBER
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      CREDIT_REQUEST_ID
,      CHECK_LIST_ID
,      STATUS
,      CUST_ACCOUNT_ID
,      PARTY_ID
,      SCORE_MODEL_ID
,      SITE_USE_ID
,      CREDIT_CLASSIFICATION
,      REVIEW_TYPE
,      CREDIT_ANALYST_ID
,      TYPE
,      DISPLAY_FLAG
,      CREATION_DATE_TIME
,      LAST_UPDATED
,      LIMIT_CURRENCY
,      EXCHANGE_RATE_TYPE
,      REVIEW_CYCLE
,      REQUEST_ID
,      PREVIOUS_CREDIT_ANALYST_ID
,      ORIGINAL_CREDIT_ANALYST_ID
FROM AR.AR_CMGT_CASE_FOLDERS;

Dependencies

[top of page]

AR.AR_CMGT_CASE_FOLDERS does not reference any database object

AR.AR_CMGT_CASE_FOLDERS is referenced by following:

AR: AR_CMGT_CASE_FOLDERS#