[Home] [Help] [Dependency Information]
Object Name: | BEN_VRBL_RT_PRFL_D |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BEN.BEN_VRBL_RT_PRFL_D |
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 |
---|---|---|---|---|
VRBL_RT_PRFL_ID | NUMBER | (15) | Yes | System generated primary key column. |
EFFECTIVE_START_DATE | DATE | Yes | Effective start date. | |
EFFECTIVE_END_DATE | DATE | Yes | Effective end date. | |
ACTIVITY_TYPE | VARCHAR2 | (4000) | ||
OPERATOR | VARCHAR2 | (4000) | ||
COVERAGE_OPERATOR | VARCHAR2 | (4000) | ||
TAX_TYPE | VARCHAR2 | (4000) | ||
TREATMENT | VARCHAR2 | (4000) | ||
REFERENCE_PERIOD | VARCHAR2 | (4000) | ||
CALCULATION_METHOD | VARCHAR2 | (4000) | ||
INCREMENT_VALUE | NUMBER | |||
DEFAULT_VALUE | NUMBER | |||
MAX_VALUE | NUMBER | |||
MIN_VALUE | NUMBER | |||
VALUE | NUMBER | |||
NAME | VARCHAR2 | (240) | Yes | |
VALUE_RULE | VARCHAR2 | (80) | ||
STATUS | VARCHAR2 | (4000) | ||
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | VARCHAR2 | (100) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
USAGE | VARCHAR2 | (4000) | ||
ROUNDING_CODE | VARCHAR2 | (4000) | ||
ROUNDING_RULE | VARCHAR2 | (80) | ||
ULTIMATE_HIGH_LIMIT_VALUE | NUMBER | |||
ULTIMATE_LOW_LIMIT_VALUE | NUMBER | |||
ULTIMATE_HIGH_LIMIT_RULE | VARCHAR2 | (80) | ||
ULTIMATE_LOW_LIMIT_RULE | VARCHAR2 | (80) | ||
PL_TYP_OPT_TYP_NAME | VARCHAR2 | (483) | ||
OPT_PL_NAME | VARCHAR2 | (240) |
Cut, paste (and edit) the following text to query this object:
SELECT VRBL_RT_PRFL_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, ACTIVITY_TYPE
, OPERATOR
, COVERAGE_OPERATOR
, TAX_TYPE
, TREATMENT
, REFERENCE_PERIOD
, CALCULATION_METHOD
, INCREMENT_VALUE
, DEFAULT_VALUE
, MAX_VALUE
, MIN_VALUE
, VALUE
, NAME
, VALUE_RULE
, STATUS
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, USAGE
, ROUNDING_CODE
, ROUNDING_RULE
, ULTIMATE_HIGH_LIMIT_VALUE
, ULTIMATE_LOW_LIMIT_VALUE
, ULTIMATE_HIGH_LIMIT_RULE
, ULTIMATE_LOW_LIMIT_RULE
, PL_TYP_OPT_TYP_NAME
, OPT_PL_NAME
FROM APPS.BEN_VRBL_RT_PRFL_D;
APPS.BEN_VRBL_RT_PRFL_D is not referenced by any database object
|
|
|