[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
AR.AR_CMGT_CASE_FOLDERS does not reference any database object
AR.AR_CMGT_CASE_FOLDERS is referenced by following:
|
|
|