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_ALL_ORGANIZATION_UNITS

Object Details

Object Name:	PER_ALL_ORGANIZATION_UNITS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.PER_ALL_ORGANIZATION_UNITS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Unsecured version of PER_ORGANIZATION_UNITS.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER	(15)	Yes	Refer to base table.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Refer to base table.
NAME	VARCHAR2	(240)	Yes	Refer to base table.
DATE_FROM	DATE		Yes	Refer to base table.
DATE_TO	DATE			Refer to base table.
INTERNAL_ADDRESS_LINE	VARCHAR2	(80)		Refer to base table.
COMMENTS	LONG	(0)		Refer to base table.
DEFAULT_START_TIME	VARCHAR2	(150)		Refer to base table.
DEFAULT_END_TIME	VARCHAR2	(150)		Refer to base table.
WORKING_HOURS	VARCHAR2	(150)		Refer to base table.
FREQUENCY	VARCHAR2	(150)		Refer to base table.
INTERNAL_EXTERNAL_FLAG	VARCHAR2	(30)		Refer to base table.
TYPE	VARCHAR2	(30)		Refer to base table.
LOCATION_ID	NUMBER	(15)		Refer to base table.
COST_ALLOCATION_KEYFLEX_ID	NUMBER	(9)		Refer to base table.
SOFT_CODING_KEYFLEX_ID	NUMBER	(15)		Refer to base table.
OPERATING_UNIT_ID	VARCHAR2	(150)		Refer to base table.

Query Text

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


SELECT ORGANIZATION_ID
,      BUSINESS_GROUP_ID
,      NAME
,      DATE_FROM
,      DATE_TO
,      INTERNAL_ADDRESS_LINE
,      COMMENTS
,      DEFAULT_START_TIME
,      DEFAULT_END_TIME
,      WORKING_HOURS
,      FREQUENCY
,      INTERNAL_EXTERNAL_FLAG
,      TYPE
,      LOCATION_ID
,      COST_ALLOCATION_KEYFLEX_ID
,      SOFT_CODING_KEYFLEX_ID
,      OPERATING_UNIT_ID
FROM APPS.PER_ALL_ORGANIZATION_UNITS;

Dependencies

[top of page]

APPS.PER_ALL_ORGANIZATION_UNITS references the following:

APPS: HR_ALL_ORGANIZATION_UNITS; HR_ALL_ORGANIZATION_UNITS_TL; HR_ORGANIZATION_INFORMATION

APPS.PER_ALL_ORGANIZATION_UNITS is referenced by following:

APPS: BEN_EXT_PERSON - show dependent code; HXT_INTERFACE_UTILITIES - show dependent code; HXT_INTERFACE_UTILITIES - show dependent code; PAFV_EXPENDITURE_ITEMS; PER_APPLICANT_PKG - show dependent code; PER_BUDGET_ELEMENTS_PKG - show dependent code; PQH_LENGTH_OF_SERVICE_PKG - show dependent code; PQH_LENGTH_OF_SERVICE_PKG - show dependent code
PUBLIC: PER_ALL_ORGANIZATION_UNITS