eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.PAY_KR_SEP_MASTER_EEV_V

Object Details

Object Name:	PAY_KR_SEP_MASTER_EEV_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PAY.PAY_KR_SEP_MASTER_EEV_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory
ELEMENT_ENTRY_ID	NUMBER	(15)	Yes
EFFECTIVE_START_DATE	DATE		Yes
EFFECTIVE_END_DATE	DATE		Yes
OBJECT_VERSION_NUMBER	NUMBER	(9)
LELEMENT_LINK_ID	NUMBER	(9)	Yes
LEFFECTIVE_START_DATE	DATE		Yes
LEFFECTIVE_END_DATE	DATE		Yes
TELEMENT_TYPE_ID	NUMBER	(9)	Yes
TEFFECTIVE_START_DATE	DATE		Yes
TEFFECTIVE_END_DATE	DATE		Yes
INPUT_VALUE_ID1	NUMBER
INPUT_VALUE_ID2	NUMBER
INPUT_VALUE_ID3	NUMBER
INPUT_VALUE_ID4	NUMBER
INPUT_VALUE_ID5	NUMBER
INPUT_VALUE_ID6	NUMBER
INPUT_VALUE_ID7	NUMBER
INPUT_VALUE_ID8	NUMBER
INPUT_VALUE_ID9	NUMBER
INPUT_VALUE_ID10	NUMBER
INPUT_VALUE_ID11	NUMBER
INPUT_VALUE_ID12	NUMBER
INPUT_VALUE_ID13	NUMBER
INPUT_VALUE_ID14	NUMBER
INPUT_VALUE_ID15	NUMBER
INPUT_VALUE_NAME1	VARCHAR2	(4000)
INPUT_VALUE_NAME2	VARCHAR2	(4000)
INPUT_VALUE_NAME3	VARCHAR2	(4000)
INPUT_VALUE_NAME4	VARCHAR2	(4000)
INPUT_VALUE_NAME5	VARCHAR2	(4000)
INPUT_VALUE_NAME6	VARCHAR2	(4000)
INPUT_VALUE_NAME7	VARCHAR2	(4000)
INPUT_VALUE_NAME8	VARCHAR2	(4000)
INPUT_VALUE_NAME9	VARCHAR2	(4000)
INPUT_VALUE_NAME10	VARCHAR2	(4000)
INPUT_VALUE_NAME11	VARCHAR2	(4000)
INPUT_VALUE_NAME12	VARCHAR2	(4000)
INPUT_VALUE_NAME13	VARCHAR2	(4000)
INPUT_VALUE_NAME14	VARCHAR2	(4000)
INPUT_VALUE_NAME15	VARCHAR2	(4000)
DISPLAY_SEQUENCE1	NUMBER
DISPLAY_SEQUENCE2	NUMBER
DISPLAY_SEQUENCE3	NUMBER
DISPLAY_SEQUENCE4	NUMBER
DISPLAY_SEQUENCE5	NUMBER
DISPLAY_SEQUENCE6	NUMBER
DISPLAY_SEQUENCE7	NUMBER
DISPLAY_SEQUENCE8	NUMBER
DISPLAY_SEQUENCE9	NUMBER
DISPLAY_SEQUENCE10	NUMBER
DISPLAY_SEQUENCE11	NUMBER
DISPLAY_SEQUENCE12	NUMBER
DISPLAY_SEQUENCE13	NUMBER
DISPLAY_SEQUENCE14	NUMBER
DISPLAY_SEQUENCE15	NUMBER
SCREEN_ENTRY_VALUE1	VARCHAR2	(4000)
SCREEN_ENTRY_VALUE2	VARCHAR2	(4000)
SCREEN_ENTRY_VALUE3	VARCHAR2	(4000)
SCREEN_ENTRY_VALUE4	VARCHAR2	(4000)
SCREEN_ENTRY_VALUE5	VARCHAR2	(4000)
SCREEN_ENTRY_VALUE6	VARCHAR2	(4000)
SCREEN_ENTRY_VALUE7	VARCHAR2	(4000)
SCREEN_ENTRY_VALUE8	VARCHAR2	(4000)
SCREEN_ENTRY_VALUE9	VARCHAR2	(4000)
SCREEN_ENTRY_VALUE10	VARCHAR2	(4000)
SCREEN_ENTRY_VALUE11	VARCHAR2	(4000)
SCREEN_ENTRY_VALUE12	VARCHAR2	(4000)
SCREEN_ENTRY_VALUE13	VARCHAR2	(4000)
SCREEN_ENTRY_VALUE14	VARCHAR2	(4000)
SCREEN_ENTRY_VALUE15	VARCHAR2	(4000)
ENTRY_VALUE1	VARCHAR2	(4000)
ENTRY_VALUE2	VARCHAR2	(4000)
ENTRY_VALUE3	VARCHAR2	(4000)
ENTRY_VALUE4	VARCHAR2	(4000)
ENTRY_VALUE5	VARCHAR2	(4000)
ENTRY_VALUE6	VARCHAR2	(4000)
ENTRY_VALUE7	VARCHAR2	(4000)
ENTRY_VALUE8	VARCHAR2	(4000)
ENTRY_VALUE9	VARCHAR2	(4000)
ENTRY_VALUE10	VARCHAR2	(4000)
ENTRY_VALUE11	VARCHAR2	(4000)
ENTRY_VALUE12	VARCHAR2	(4000)
ENTRY_VALUE13	VARCHAR2	(4000)
ENTRY_VALUE14	VARCHAR2	(4000)
ENTRY_VALUE15	VARCHAR2	(4000)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ELEMENT_ENTRY_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      OBJECT_VERSION_NUMBER
,      LELEMENT_LINK_ID
,      LEFFECTIVE_START_DATE
,      LEFFECTIVE_END_DATE
,      TELEMENT_TYPE_ID
,      TEFFECTIVE_START_DATE
,      TEFFECTIVE_END_DATE
,      INPUT_VALUE_ID1
,      INPUT_VALUE_ID2
,      INPUT_VALUE_ID3
,      INPUT_VALUE_ID4
,      INPUT_VALUE_ID5
,      INPUT_VALUE_ID6
,      INPUT_VALUE_ID7
,      INPUT_VALUE_ID8
,      INPUT_VALUE_ID9
,      INPUT_VALUE_ID10
,      INPUT_VALUE_ID11
,      INPUT_VALUE_ID12
,      INPUT_VALUE_ID13
,      INPUT_VALUE_ID14
,      INPUT_VALUE_ID15
,      INPUT_VALUE_NAME1
,      INPUT_VALUE_NAME2
,      INPUT_VALUE_NAME3
,      INPUT_VALUE_NAME4
,      INPUT_VALUE_NAME5
,      INPUT_VALUE_NAME6
,      INPUT_VALUE_NAME7
,      INPUT_VALUE_NAME8
,      INPUT_VALUE_NAME9
,      INPUT_VALUE_NAME10
,      INPUT_VALUE_NAME11
,      INPUT_VALUE_NAME12
,      INPUT_VALUE_NAME13
,      INPUT_VALUE_NAME14
,      INPUT_VALUE_NAME15
,      DISPLAY_SEQUENCE1
,      DISPLAY_SEQUENCE2
,      DISPLAY_SEQUENCE3
,      DISPLAY_SEQUENCE4
,      DISPLAY_SEQUENCE5
,      DISPLAY_SEQUENCE6
,      DISPLAY_SEQUENCE7
,      DISPLAY_SEQUENCE8
,      DISPLAY_SEQUENCE9
,      DISPLAY_SEQUENCE10
,      DISPLAY_SEQUENCE11
,      DISPLAY_SEQUENCE12
,      DISPLAY_SEQUENCE13
,      DISPLAY_SEQUENCE14
,      DISPLAY_SEQUENCE15
,      SCREEN_ENTRY_VALUE1
,      SCREEN_ENTRY_VALUE2
,      SCREEN_ENTRY_VALUE3
,      SCREEN_ENTRY_VALUE4
,      SCREEN_ENTRY_VALUE5
,      SCREEN_ENTRY_VALUE6
,      SCREEN_ENTRY_VALUE7
,      SCREEN_ENTRY_VALUE8
,      SCREEN_ENTRY_VALUE9
,      SCREEN_ENTRY_VALUE10
,      SCREEN_ENTRY_VALUE11
,      SCREEN_ENTRY_VALUE12
,      SCREEN_ENTRY_VALUE13
,      SCREEN_ENTRY_VALUE14
,      SCREEN_ENTRY_VALUE15
,      ENTRY_VALUE1
,      ENTRY_VALUE2
,      ENTRY_VALUE3
,      ENTRY_VALUE4
,      ENTRY_VALUE5
,      ENTRY_VALUE6
,      ENTRY_VALUE7
,      ENTRY_VALUE8
,      ENTRY_VALUE9
,      ENTRY_VALUE10
,      ENTRY_VALUE11
,      ENTRY_VALUE12
,      ENTRY_VALUE13
,      ENTRY_VALUE14
,      ENTRY_VALUE15
FROM APPS.PAY_KR_SEP_MASTER_EEV_V;

Dependencies

[top of page]

APPS.PAY_KR_SEP_MASTER_EEV_V references the following:

APPS: PAY_ELEMENT_ENTRIES_F; PAY_ELEMENT_LINKS_F; PAY_ELEMENT_TYPES_F; PAY_KR_SEP_FORM_PKG - show dependent code

APPS.PAY_KR_SEP_MASTER_EEV_V is referenced by following:

PUBLIC: PAY_KR_SEP_MASTER_EEV_V