[Home] [Help]
[Dependency Information]
| Object Name: | BEN_ICD_SS_CONFIG_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| 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 |
|---|---|---|---|---|
| INPUT_VALUE_ID | NUMBER | (9) | Yes | Foreign key to PAY_INPUT_VALUES_F |
| ELEMENT_TYPE_ID | NUMBER | (9) | Yes | Element Type Identifier. Foreign key to PAY_ELEMENT_TYPES_F |
| INPUT_VALUE | VARCHAR2 | (80) | Yes | Input Value |
| COLUMN_SEQ_NUM | NUMBER | (3) | Yes | Order Number |
| SELFSERVICE_DISPLAY_PROMPT | VARCHAR2 | (80) | Yes | Prompt shown on selfservice page |
| HIDDEN_IN_SELFSERVICE | VARCHAR2 | (1) | Flag to show or hide Input value | |
| USER_ENTERABLE_FLAG | VARCHAR2 | (30) | User Enterable Y or N Flag | |
| SHOW_ON_OVERVIEW_FLAG | VARCHAR2 | (30) | Y or N Flag to Show or Hide Input value on Overview page | |
| DESCRIPTIVE_FLEX_CONTEXT_CODE | VARCHAR2 | (30) | Yes | Descriptive Flexfield context |
| EFFECTIVE_START_DATE | DATE | Yes | Effective Start Date | |
| EFFECTIVE_END_DATE | DATE | Yes | Effective End Date | |
| LANGUAGE | VARCHAR2 | (4) | Yes | Language |
Cut, paste (and edit) the following text to query this object:
SELECT INPUT_VALUE_ID
, ELEMENT_TYPE_ID
, INPUT_VALUE
, COLUMN_SEQ_NUM
, SELFSERVICE_DISPLAY_PROMPT
, HIDDEN_IN_SELFSERVICE
, USER_ENTERABLE_FLAG
, SHOW_ON_OVERVIEW_FLAG
, DESCRIPTIVE_FLEX_CONTEXT_CODE
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, LANGUAGE
FROM APPS.BEN_ICD_SS_CONFIG_V;
APPS
BEN_ICD_SS_CONFIG
FND_DESCR_FLEX_COLUMN_USAGES
FND_DESCR_FLEX_COL_USAGE_TL
PAY_INPUT_VALUES_F
PAY_INPUT_VALUES_F_TL
APPS.BEN_ICD_SS_CONFIG_V is not referenced by any database object
|
|
|
|