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.PER_SHARED_TYPES_DFV

Object Details

Object Name:	PER_SHARED_TYPES_DFV
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
ROW_ID	ROWID	(10)
TYPE	VARCHAR2	(30)
NON_WORKING_TIME___SICKNESS	VARCHAR2	(150)
NATIONALITY_GROUP	VARCHAR2	(150)
CHILD	VARCHAR2	(150)
MARK_ACTIVE_FOR_IPEDS	VARCHAR2	(150)
PROFESSIONAL_CATG	VARCHAR2	(150)
STAT_TERM_REASONS	VARCHAR2	(150)
NATIONALITY	VARCHAR2	(150)
DESCRIPTION	VARCHAR2	(150)
ELEMENT	VARCHAR2	(150)
ELEMENTS	VARCHAR2	(150)
FI_WORKINGTIME_OPTIONS	VARCHAR2	(150)
NUMBER_OF_WORKING_DAYS	NUMBER
ENTITLEMENT	VARCHAR2	(150)
ALLOW_INCOMPLETE_TIME	VARCHAR2	(150)
SALARY_SHARE	NUMBER
SYSTEM_FLAG	VARCHAR2	(150)
ALLOW_MULTIPLE_VERSION	VARCHAR2	(150)
ALLOW_DUPLICATE_NAME	VARCHAR2	(150)
PROTECT_HIERARCHY_STRUCTURE	VARCHAR2	(150)
COUNTRY	VARCHAR2	(150)
EEC_MEMBER	VARCHAR2	(150)
EMPLOYEE_CATEGORY	VARCHAR2	(150)
ASSIGNMENT_CATEGORY	VARCHAR2	(150)
NINE_BOX_LEVEL	VARCHAR2	(150)
BUDGET_FLAG	VARCHAR2	(150)
TYPE_OF_PUBLIC_SECTOR	VARCHAR2	(150)
CONVERSION_FACTOR__FOR_MONTHS_	NUMBER
EDUCATION_LEVEL	VARCHAR2	(150)
EDUCATION	VARCHAR2	(150)
CORE_MARITAL_STATUS_CODE	VARCHAR2	(150)
CONCATENATED_SEGMENTS	VARCHAR2	(634)

Query Text

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


SELECT ROW_ID
,      TYPE
,      NON_WORKING_TIME___SICKNESS
,      NATIONALITY_GROUP
,      CHILD
,      MARK_ACTIVE_FOR_IPEDS
,      PROFESSIONAL_CATG
,      STAT_TERM_REASONS
,      NATIONALITY
,      DESCRIPTION
,      ELEMENT
,      ELEMENTS
,      FI_WORKINGTIME_OPTIONS
,      NUMBER_OF_WORKING_DAYS
,      ENTITLEMENT
,      ALLOW_INCOMPLETE_TIME
,      SALARY_SHARE
,      SYSTEM_FLAG
,      ALLOW_MULTIPLE_VERSION
,      ALLOW_DUPLICATE_NAME
,      PROTECT_HIERARCHY_STRUCTURE
,      COUNTRY
,      EEC_MEMBER
,      EMPLOYEE_CATEGORY
,      ASSIGNMENT_CATEGORY
,      NINE_BOX_LEVEL
,      BUDGET_FLAG
,      TYPE_OF_PUBLIC_SECTOR
,      CONVERSION_FACTOR__FOR_MONTHS_
,      EDUCATION_LEVEL
,      EDUCATION
,      CORE_MARITAL_STATUS_CODE
,      CONCATENATED_SEGMENTS
FROM APPS.PER_SHARED_TYPES_DFV;

Dependencies

[top of page]

APPS.PER_SHARED_TYPES_DFV references the following:

APPS: FND_NUMBER - show dependent code; PER_SHARED_TYPES

APPS.PER_SHARED_TYPES_DFV is not referenced by any database object