DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.BEN_ICD_SS_CONFIG_V

Object Details
Object Name: BEN_ICD_SS_CONFIG_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.BEN_ICD_SS_CONFIG_V references the following:

SchemaAPPS
SynonymBEN_ICD_SS_CONFIG
SynonymFND_DESCR_FLEX_COLUMN_USAGES
SynonymFND_DESCR_FLEX_COL_USAGE_TL
SynonymPAY_INPUT_VALUES_F
SynonymPAY_INPUT_VALUES_F_TL

APPS.BEN_ICD_SS_CONFIG_V is not referenced by any database object