[Home] [Help] [Dependency Information]
Object Name: | PER_CAGR_ENTITLEMENT_ITEMS |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PER.PER_CAGR_ENTITLEMENT_ITEMS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PER_CAGR_ENTITLEMENT_ITEMS_UK1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ELEMENT_TYPE_ID
INPUT_VALUE_ID |
PER_CAGR_ENTITLEMENT_ITMES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | CAGR_ENTITLEMENT_ITEM_ID |
PER_CAGR_ENTITLEMENT_ITEMS_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CAGR_API_ID |
PER_CAGR_ENTITLEMENT_ITEMS_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CAGR_API_PARAM_ID |
PER_CAGR_ENTITLEMENT_ITEMS_FK4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | INPUT_VALUE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CAGR_ENTITLEMENT_ITEM_ID | NUMBER | (15) | Yes | |
BUSINESS_GROUP_ID | NUMBER | (15) | ||
ITEM_NAME | VARCHAR2 | (80) | Yes | |
ELEMENT_TYPE_ID | NUMBER | (15) | ||
INPUT_VALUE_ID | VARCHAR2 | (15) | ||
COLUMN_TYPE | VARCHAR2 | (30) | Yes | |
COLUMN_SIZE | NUMBER | (15) | Yes | |
LEGISLATION_CODE | VARCHAR2 | (30) | ||
BENEFICIAL_RULE | VARCHAR2 | (30) | ||
CAGR_API_ID | NUMBER | (10) | ||
CAGR_API_PARAM_ID | NUMBER | (10) | ||
CATEGORY_NAME | VARCHAR2 | (30) | Yes | Category of the Entitlement Item. |
UOM | VARCHAR2 | (30) | Unit of measure for the entitlement item. | |
BENEFICIAL_FORMULA_ID | NUMBER | (15) | ||
FLEX_VALUE_SET_ID | NUMBER | (10) | ||
BENEFICIAL_RULE_VALUE_SET_ID | NUMBER | (10) | FK to FND value sets. | |
MULTIPLE_ENTRIES_ALLOWED_FLAG | VARCHAR2 | (30) | Indicates whether an entitlement item can have multiple normal entries for this element at any one time. | |
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | |
OPT_ID | NUMBER | (15) | ||
AUTO_CREATE_ENTRIES_FLAG | VARCHAR2 | (30) | Indicates whether the Entitlement Item can have entries automatically created. |
Cut, paste (and edit) the following text to query this object:
SELECT CAGR_ENTITLEMENT_ITEM_ID
, BUSINESS_GROUP_ID
, ITEM_NAME
, ELEMENT_TYPE_ID
, INPUT_VALUE_ID
, COLUMN_TYPE
, COLUMN_SIZE
, LEGISLATION_CODE
, BENEFICIAL_RULE
, CAGR_API_ID
, CAGR_API_PARAM_ID
, CATEGORY_NAME
, UOM
, BENEFICIAL_FORMULA_ID
, FLEX_VALUE_SET_ID
, BENEFICIAL_RULE_VALUE_SET_ID
, MULTIPLE_ENTRIES_ALLOWED_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, OPT_ID
, AUTO_CREATE_ENTRIES_FLAG
FROM HR.PER_CAGR_ENTITLEMENT_ITEMS;
HR.PER_CAGR_ENTITLEMENT_ITEMS does not reference any database object
HR.PER_CAGR_ENTITLEMENT_ITEMS is referenced by following:
|
|
|