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]

TABLE: HR.PER_FORM_FUNCTIONS

Object Details

Object Name:	PER_FORM_FUNCTIONS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.PER_FORM_FUNCTIONS
Subobject Name:
Status:	VALID

PER_FORM_FUNCTIONS is a generic table used:(a) in PERWSEPI
for person type picklist (function = CHANGE_PERSON_TYPE) (b) in
PERWSEPI for navigation zone picklist (function = NAVIGATE).

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Unique Key: PER_FORM_FUNCTION_UK

FORM
FUNCTION
RESULT
INPUT
RESTRICTION_CODE
RESTRICTION_VALUE

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_FORM_FUNCTION_UK	NORMAL	UNIQUE	APPS_TS_TX_IDX	FORM FUNCTION RESULT INPUT RESTRICTION_CODE RESTRICTION_VALUE

Columns

Name	Datatype	Length	Mandatory	Comments
FORM	VARCHAR2	(30)	Yes	Form name eg. PERPEEPI.
FUNCTION	VARCHAR2	(40)	Yes	Function to be carried out eg. CHANGE_PERSON_TYPE, NAVIGATE.
RESULT	VARCHAR2	(40)	Yes	The expected result eg. person type to appear on picklist.
INPUT	VARCHAR2	(30)		Value used as a reference eg. existing person type.
RESTRICTION_CODE	VARCHAR2	(10)		Form customization restriction code e.g. value relating to PERSON_TYPE.
RESTRICTION_VALUE	VARCHAR2	(80)		Value that is restricted by the customization.

Query Text

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


SELECT FORM
,      FUNCTION
,      RESULT
,      INPUT
,      RESTRICTION_CODE
,      RESTRICTION_VALUE
FROM HR.PER_FORM_FUNCTIONS;

Dependencies

[top of page]

HR.PER_FORM_FUNCTIONS does not reference any database object

HR.PER_FORM_FUNCTIONS is referenced by following:

APPS: PER_FORM_FUNCTIONS
PUBLIC: PER_FORM_FUNCTIONS