[Home] [Help] [Dependency Information]
Object Name: | AR_CMGT_DATA_POINTS_B |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.AR_CMGT_DATA_POINTS_B |
Subobject Name: | |
Status: | VALID |
The AR_CMGT_DATA_POINTS_B table stores information about the details of each data point in Oracle Credit Management. Each data point may be selected for display on a checklist or may be used in a scoring model, determined by the DISPLAY_ON_CHECKLIST_FLAG and SCORABLE_FLAG fields, respectively. Each data point is logically grouped in one of six categories, such as References, Aging, Credit, and so on, and is used when displaying data points by categories in the case folder.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AR_CMGT_DATA_POINTS_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | DATA_POINT_ID |
AR_CMGT_DATA_POINTS_B_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DATA_POINT_CATEGORY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DATA_POINT_ID | NUMBER | (15) | Yes | Identifier of the data point |
DATA_POINT_CATEGORY | VARCHAR2 | (30) | Yes | Data point categories |
USER_DEFINED_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the data point is user defined |
SCORABLE_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the data point is scorable |
DISPLAY_ON_CHECKLIST_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the data point is displayed on the checklist |
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. | |
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). |
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). | |
APPLICATION_ID | NUMBER | (15) | Yes | Application identifier |
PACKAGE_NAME | VARCHAR2 | (60) | PL/SQL package name | |
FUNCTION_NAME | VARCHAR2 | (60) | PL/SQL function name | |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | Indicates if data point is enabled, Y or N |
PARENT_DATA_POINT_ID | NUMBER | (15) | Parent data point identifier | |
RETURN_DATA_TYPE | VARCHAR2 | (30) | Data type of data points: D for date, N for number, or C for varchar | |
RETURN_DATE_FORMAT | VARCHAR2 | (60) | Indicates date format, when RETURN_DATA_TYPE column is date(D) | |
FUNCTION_TYPE | VARCHAR2 | (10) | Type of function | |
DATA_POINT_SUB_CATEGORY | VARCHAR2 | (30) | Data point subcategory | |
DATA_POINT_CODE | VARCHAR2 | (60) | Data point internal name |
Cut, paste (and edit) the following text to query this object:
SELECT DATA_POINT_ID
, DATA_POINT_CATEGORY
, USER_DEFINED_FLAG
, SCORABLE_FLAG
, DISPLAY_ON_CHECKLIST_FLAG
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, APPLICATION_ID
, PACKAGE_NAME
, FUNCTION_NAME
, ENABLED_FLAG
, PARENT_DATA_POINT_ID
, RETURN_DATA_TYPE
, RETURN_DATE_FORMAT
, FUNCTION_TYPE
, DATA_POINT_SUB_CATEGORY
, DATA_POINT_CODE
FROM AR.AR_CMGT_DATA_POINTS_B;
AR.AR_CMGT_DATA_POINTS_B does not reference any database object
AR.AR_CMGT_DATA_POINTS_B is referenced by following:
|
|
|