[Home] [Help] [Dependency Information]
Object Name: | AR_CMGT_CF_RECOMMENDS |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.AR_CMGT_CF_RECOMMENDS |
Subobject Name: | |
Status: | VALID |
The AR_CMGT_CF_RECOMMENDS table stores the credit recommendations submitted for each case folder. Credit recommendations represent the actions to be implemented based upon the credit analysis and review, such as setting new credit limits, removing customers from credit hold, or modifying a customer's credit classification. Credit recommendations may be routed through a management approval hierarchy before being implemented.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AR_CMGT_CF_RECOMMENDS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | RECOMMENDATION_ID |
AR_CMGT_CF_RECOMMENDS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CREDIT_REQUEST_ID |
AR_CMGT_CF_RECOMMENDS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CASE_FOLDER_ID
CREDIT_RECOMMENDATION |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECOMMENDATION_ID | NUMBER | (15) | Yes | Identifier of the recommendation |
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). |
CASE_FOLDER_ID | NUMBER | (15) | Yes | Identifier of the case folder associated with the recommendation |
CREDIT_REQUEST_ID | NUMBER | (15) | Identifier of the credit request associated with the recommendation | |
CREDIT_REVIEW_DATE | DATE | Credit review date | ||
CREDIT_RECOMMENDATION | VARCHAR2 | (30) | Credit recommendation | |
RECOMMENDATION_VALUE1 | VARCHAR2 | (60) | Recommendation value | |
RECOMMENDATION_VALUE2 | VARCHAR2 | (60) | Recommendation value | |
STATUS | VARCHAR2 | (15) | Indicates whether this recommendation is implemented or not | |
CREDIT_TYPE | VARCHAR2 | (30) | Credit Type | |
RECOMMENDATION_NAME | VARCHAR2 | (60) | Custom recommendation lookup type | |
APPLICATION_ID | NUMBER | (15) | FND application ID | |
APPEALED_FLAG | VARCHAR2 | (1) | Indicates if a recommendation has been appealed |
Cut, paste (and edit) the following text to query this object:
SELECT RECOMMENDATION_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, CASE_FOLDER_ID
, CREDIT_REQUEST_ID
, CREDIT_REVIEW_DATE
, CREDIT_RECOMMENDATION
, RECOMMENDATION_VALUE1
, RECOMMENDATION_VALUE2
, STATUS
, CREDIT_TYPE
, RECOMMENDATION_NAME
, APPLICATION_ID
, APPEALED_FLAG
FROM AR.AR_CMGT_CF_RECOMMENDS;
AR.AR_CMGT_CF_RECOMMENDS does not reference any database object
AR.AR_CMGT_CF_RECOMMENDS is referenced by following:
|
|
|