[Home] [Help] [Dependency Information]
Object Name: | PER_CAGR_ENTITLEMENT_RESULTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PER.PER_CAGR_ENTITLEMENT_RESULTS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CAGR_ENTITLEMENT_RESULT_ID | NUMBER | (15) | Yes | collective agreement entitlement result |
CAGR_REQUEST_ID | NUMBER | (15) | Yes | collective eagreement request |
START_DATE | DATE | Yes | start date | |
END_DATE | DATE | end date | ||
COLLECTIVE_AGREEMENT_ID | NUMBER | (10) | Yes | collective agreement identifier |
COLLECTIVE_AGREEMENT_NAME | VARCHAR2 | (80) | Yes | collective agreement name |
CAGR_ENTITLEMENT_ITEM_ID | NUMBER | (10) | Yes | collective agreement entitlement item identifier |
ITEM_NAME | VARCHAR2 | (80) | Yes | collective agreement entitlement item name |
ELEMENT_TYPE_ID | NUMBER | (10) | collective agreement element type | |
INPUT_VALUE_ID | NUMBER | (10) | collective agreement element input value | |
CAGR_API_ID | NUMBER | (15) | identifier of collective agreement API | |
CAGR_API_PARAM_ID | NUMBER | (15) | identifier of collective agreement API parameter | |
CATEGORY_NAME | VARCHAR2 | (30) | Yes | category name |
CATEGORY_NAME_D | VARCHAR2 | (80) | category name for display | |
CAGR_ENTITLEMENT_ID | NUMBER | (15) | Yes | collective agreement entitlement |
CAGR_ENTITLEMENT_LINE_ID | NUMBER | (10) | collective agreement entitlement line | |
ASSIGNMENT_ID | NUMBER | (11) | Yes | assignment identifier |
VALUE | VARCHAR2 | (4000) | value | |
UNITS_OF_MEASURE | VARCHAR2 | (60) | unit of measure | |
UNITS_OF_MEASURE_D | VARCHAR2 | (80) | unit of measure | |
RANGE_FROM | VARCHAR2 | (240) | range from | |
RANGE_TO | VARCHAR2 | (240) | range to | |
PARENT_SPINE_ID | NUMBER | (10) | parent spine identifier | |
PARENT_SPINE_NAME | VARCHAR2 | (30) | parent spine name | |
GRADE_SPINE_ID | NUMBER | grade spine identifier | ||
GRADE_SPINE_NAME | VARCHAR2 | (240) | grade spine name | |
STEP_ID | NUMBER | (15) | step identifier | |
STEP_NAME | VARCHAR2 | (30) | step name | |
FROM_STEP_ID | NUMBER | (15) | step from | |
FROM_STEP_NAME | VARCHAR2 | (30) | step from | |
TO_STEP_ID | NUMBER | (15) | step to | |
TO_STEP_NAME | VARCHAR2 | (30) | step to | |
RETAINED_ENT_RESULT_ID | NUMBER | (15) | retained entitlement result | |
RETAINED_FLAG | VARCHAR2 | (1) | retained flag | |
BENEFICIAL_FLAG | VARCHAR2 | (1) | beneficial flag | |
CHOSEN_FLAG | VARCHAR2 | (3) | chosen flag | |
COLUMN_TYPE | VARCHAR2 | (30) | Yes | column type |
COLUMN_SIZE | NUMBER | Yes | column size | |
OIPL_ID | NUMBER | (10) | option or plan identifier | |
ELIGIBILITY_SOURCE | VARCHAR2 | (240) | eligibility source | |
FORMULA_OR_CRITERIA | VARCHAR2 | (1) | formula or criteria | |
FLEX_VALUE_SET_ID | NUMBER | (15) | flex value set identifier | |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | internal use for APIs |
CAGR_RETAINED_RIGHT_ID | NUMBER | retained right identifier | ||
RET_OBJECT_VERSION_NUMBER | NUMBER | internal use for APIs | ||
FREEZE_FLAG | VARCHAR2 | (30) | freeze flag | |
RETAINED_DATE_FROM | DATE | reatined date from | ||
RETAINED_DATE_TO | DATE | retained date to |
Cut, paste (and edit) the following text to query this object:
SELECT CAGR_ENTITLEMENT_RESULT_ID
, CAGR_REQUEST_ID
, START_DATE
, END_DATE
, COLLECTIVE_AGREEMENT_ID
, COLLECTIVE_AGREEMENT_NAME
, CAGR_ENTITLEMENT_ITEM_ID
, ITEM_NAME
, ELEMENT_TYPE_ID
, INPUT_VALUE_ID
, CAGR_API_ID
, CAGR_API_PARAM_ID
, CATEGORY_NAME
, CATEGORY_NAME_D
, CAGR_ENTITLEMENT_ID
, CAGR_ENTITLEMENT_LINE_ID
, ASSIGNMENT_ID
, VALUE
, UNITS_OF_MEASURE
, UNITS_OF_MEASURE_D
, RANGE_FROM
, RANGE_TO
, PARENT_SPINE_ID
, PARENT_SPINE_NAME
, GRADE_SPINE_ID
, GRADE_SPINE_NAME
, STEP_ID
, STEP_NAME
, FROM_STEP_ID
, FROM_STEP_NAME
, TO_STEP_ID
, TO_STEP_NAME
, RETAINED_ENT_RESULT_ID
, RETAINED_FLAG
, BENEFICIAL_FLAG
, CHOSEN_FLAG
, COLUMN_TYPE
, COLUMN_SIZE
, OIPL_ID
, ELIGIBILITY_SOURCE
, FORMULA_OR_CRITERIA
, FLEX_VALUE_SET_ID
, OBJECT_VERSION_NUMBER
, CAGR_RETAINED_RIGHT_ID
, RET_OBJECT_VERSION_NUMBER
, FREEZE_FLAG
, RETAINED_DATE_FROM
, RETAINED_DATE_TO
FROM APPS.PER_CAGR_ENTITLEMENT_RESULTS_V;
APPS.PER_CAGR_ENTITLEMENT_RESULTS_V is not referenced by any database object
|
|
|