[Home] [Help] [Dependency Information]
Object Name: | PER_CAGR_ENTITLEMENT_ITEMS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PER.PER_CAGR_ENTITLEMENT_ITEMS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CAGR_ENTITLEMENT_ITEM_ID | NUMBER | (15) | Yes | |
BUSINESS_GROUP_ID | NUMBER | (15) | ||
ITEM_NAME | VARCHAR2 | (80) | ||
ELEMENT_TYPE_ID | NUMBER | (15) | ||
ELEMENT_NAME | VARCHAR2 | (80) | ||
INPUT_VALUE_ID | VARCHAR2 | (15) | ||
INPUT_VALUE_NAME | VARCHAR2 | (80) | ||
LEGISLATION | VARCHAR2 | (30) | ||
BENEFICIAL_RULE | VARCHAR2 | (30) | ||
BENEFICIAL_RULE_DESC | VARCHAR2 | (80) | ||
CAGR_API_ID | NUMBER | (10) | ||
API_NAME | VARCHAR2 | (60) | ||
CAGR_API_PARAM_ID | NUMBER | (10) | ||
COLUMN_TYPE | VARCHAR2 | (30) | Yes | |
COLUMN_TYPE_DESC | VARCHAR2 | (80) | ||
COLUMN_SIZE | NUMBER | (15) | Yes | |
DISPLAY_NAME | VARCHAR2 | (60) | ||
CATEGORY_NAME | VARCHAR2 | (30) | Yes | |
CATEGORY_NAME_DESC | VARCHAR2 | (80) | ||
BENEFICIAL_FORMULA_ID | NUMBER | (15) | ||
UOM | VARCHAR2 | (30) | ||
UOM_DESC | VARCHAR2 | (80) | ||
FLEX_VALUE_SET_ID | NUMBER | (10) | ||
DEFAULT_UOM | VARCHAR2 | (30) | ||
FLEX_VALUE_SET_NAME | VARCHAR2 | (60) | ||
MULTIPLE_ENTRIES_ALLOWED_FLAG | VARCHAR2 | (30) | ||
AUTO_CREATE_ENTRIES_FLAG | VARCHAR2 | (30) | ||
BEN_RULE_VALUE_SET_ID | NUMBER | (10) | ||
BEN_RULE_VALUE_SET_NAME | VARCHAR2 | (60) | ||
UOM_PARAMETER | VARCHAR2 | (60) | ||
PARAMETER_LOOKUP_TYPE | VARCHAR2 | (30) | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | |
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT CAGR_ENTITLEMENT_ITEM_ID
, BUSINESS_GROUP_ID
, ITEM_NAME
, ELEMENT_TYPE_ID
, ELEMENT_NAME
, INPUT_VALUE_ID
, INPUT_VALUE_NAME
, LEGISLATION
, BENEFICIAL_RULE
, BENEFICIAL_RULE_DESC
, CAGR_API_ID
, API_NAME
, CAGR_API_PARAM_ID
, COLUMN_TYPE
, COLUMN_TYPE_DESC
, COLUMN_SIZE
, DISPLAY_NAME
, CATEGORY_NAME
, CATEGORY_NAME_DESC
, BENEFICIAL_FORMULA_ID
, UOM
, UOM_DESC
, FLEX_VALUE_SET_ID
, DEFAULT_UOM
, FLEX_VALUE_SET_NAME
, MULTIPLE_ENTRIES_ALLOWED_FLAG
, AUTO_CREATE_ENTRIES_FLAG
, BEN_RULE_VALUE_SET_ID
, BEN_RULE_VALUE_SET_NAME
, UOM_PARAMETER
, PARAMETER_LOOKUP_TYPE
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM APPS.PER_CAGR_ENTITLEMENT_ITEMS_V;
|
|
|