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

VIEW: APPS.PAY_ADDL_EMP_ACTION_INFO_V

Object Details
Object Name: PAY_ADDL_EMP_ACTION_INFO_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAY_ADDL_EMP_ACTION_INFO_V
Subobject Name:
Status: VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


The view displays addition employee information that is
used in Online Payslip


[View Source]

Columns
Name Datatype Length Mandatory Comments
ACTION_CONTEXT_ID NUMBER (15) Yes Action Context Id
ACTION_CONTEXT_TYPE VARCHAR2 (15) Yes Action Context Type
TAX_UNIT_ID NUMBER (15)
Tax Unit Id
ACTION_INFORMATION_CATEGORY VARCHAR2 (80) Yes Action Information Category
ACTION_INFORMATION1 VARCHAR2 (240)
Action Information 1
ACTION_INFORMATION2 VARCHAR2 (240)
Action Information 2
ACTION_INFORMATION3 VARCHAR2 (240)
Action Information 3
ACTION_INFORMATION4 VARCHAR2 (240)
Action Information 4
ACTION_INFORMATION5 VARCHAR2 (240)
Action Information 5
ACTION_INFORMATION6 VARCHAR2 (240)
Action Information 6
ACTION_INFORMATION7 VARCHAR2 (240)
Action Information 7
ACTION_INFORMATION8 VARCHAR2 (240)
Action Information 8
ACTION_INFORMATION9 VARCHAR2 (240)
Action Information 9
ACTION_INFORMATION10 VARCHAR2 (240)
Action Information 10
ACTION_INFORMATION11 VARCHAR2 (240)
Action Information 11
ACTION_INFORMATION12 VARCHAR2 (240)
Action Information 12
ACTION_INFORMATION13 VARCHAR2 (240)
Action Information 13
ACTION_INFORMATION14 VARCHAR2 (240)
Action Information 14
ACTION_INFORMATION15 VARCHAR2 (240)
Action Information 15
ACTION_INFORMATION16 VARCHAR2 (240)
Action Information 16
ACTION_INFORMATION17 VARCHAR2 (240)
Action Information 17
ACTION_INFORMATION18 VARCHAR2 (240)
Action Information 18
ACTION_INFORMATION19 VARCHAR2 (240)
Action Information 19
ACTION_INFORMATION20 VARCHAR2 (240)
Action Information 20
Query Text

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


SELECT ACTION_CONTEXT_ID
,      ACTION_CONTEXT_TYPE
,      TAX_UNIT_ID
,      ACTION_INFORMATION_CATEGORY
,      ACTION_INFORMATION1
,      ACTION_INFORMATION2
,      ACTION_INFORMATION3
,      ACTION_INFORMATION4
,      ACTION_INFORMATION5
,      ACTION_INFORMATION6
,      ACTION_INFORMATION7
,      ACTION_INFORMATION8
,      ACTION_INFORMATION9
,      ACTION_INFORMATION10
,      ACTION_INFORMATION11
,      ACTION_INFORMATION12
,      ACTION_INFORMATION13
,      ACTION_INFORMATION14
,      ACTION_INFORMATION15
,      ACTION_INFORMATION16
,      ACTION_INFORMATION17
,      ACTION_INFORMATION18
,      ACTION_INFORMATION19
,      ACTION_INFORMATION20
FROM APPS.PAY_ADDL_EMP_ACTION_INFO_V;

Dependencies

[top of page]

APPS.PAY_ADDL_EMP_ACTION_INFO_V references the following:

SchemaAPPS
SynonymPAY_ACTION_INFORMATION

APPS.PAY_ADDL_EMP_ACTION_INFO_V is not referenced by any database object