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: TableAR.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_CMGT_CASE_FOLDERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCASE_FOLDER_ID
AR_CMGT_CASE_FOLDERS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCREDIT_REQUEST_ID
AR_CMGT_CASE_FOLDERS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHECK_LIST_ID
AR_CMGT_CASE_FOLDERS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTY_ID
ColumnCUST_ACCOUNT_ID
ColumnSITE_USE_ID
AR_CMGT_CASE_FOLDERS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCREDIT_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
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
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:

SchemaAPPS
SynonymAR_CMGT_CASE_FOLDERS