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


VIEW: APPS.PER_ORGANIZATION_UNITS

Object Details
Object Name: PER_ORGANIZATION_UNITS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.PER_ORGANIZATION_UNITS
Subobject Name:
Status: VALID

View Type

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


PER_ORGANIZATION_UNITS are Organizations filtered based on work day
information.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER (15) Yes System-generated primary key column.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign-key to HR_ORGANIZATION_UNITS.
NAME VARCHAR2 (240) Yes Name of the organization.
DATE_FROM DATE
Yes Start date of the organization.
DATE_TO DATE

End date of the organization.
INTERNAL_ADDRESS_LINE VARCHAR2 (80)
Internal address line.
COMMENTS CLOB (4000)
General remark.
DEFAULT_START_TIME VARCHAR2 (150)
Default working day start time.
DEFAULT_END_TIME VARCHAR2 (150)
Default working day end time.
WORKING_HOURS VARCHAR2 (150)
Working hours worked
FREQUENCY VARCHAR2 (150)
Frequency with which the WORKING_HOURS are worked, for example weekly, monthly.
INTERNAL_EXTERNAL_FLAG VARCHAR2 (30)
Identifies whether the organization is treated as an employment unit within the business group.
TYPE VARCHAR2 (30)
User defined organization types.
LOCATION_ID NUMBER (15)
Foreign key to HR_LOCATIONS. Default work site location for all assignments to this organization.
COST_ALLOCATION_KEYFLEX_ID NUMBER (9)
Foreign key to PAY_COST_ALLOCATION_KEYFLEX.
SOFT_CODING_KEYFLEX_ID NUMBER (15)
Foreign key to HR_SOFT_CODING_KEYFLEX.
OPERATING_UNIT_ID VARCHAR2 (150)
Operating unit id
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_ORGANIZATION_UNITS;

Dependencies

[top of page]

APPS.PER_ORGANIZATION_UNITS references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_ORGANIZATION_INFORMATION
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_SECURITY - show dependent code
APPS.PER_ORGANIZATION_UNITS is referenced by following:

SchemaAPPS
Package BodyAP_WEB_INACTIVE_EMP_WF_PKG - show dependent code
Package BodyBEN_EXTRACT_SEED - show dependent code
Package BodyCSD_RULES_ENGINE_PVT - show dependent code
Package BodyGHR_GHRCPDFO_XMLP_PKG - show dependent code
Package BodyGHR_MASS_SEL_NOA - show dependent code
Package BodyGHR_MLC_PKG - show dependent code
Package BodyGHR_MRE_PKG - show dependent code
Package BodyGHR_MTO_PKG - show dependent code
Package BodyGHR_RIF_PKG - show dependent code
PL/SQL PackageGHR_RIF_PKG - show dependent code
Package BodyGHR_SF52_POS_UPDATE - show dependent code
PL/SQL PackageGHR_SF52_POS_UPDATE - show dependent code
Package BodyHRWSECI - show dependent code
PL/SQL PackageHR_API - show dependent code
Package BodyHR_API - show dependent code
Package BodyHR_MASS_MOVE_API - show dependent code
Package BodyHR_NL_LAW_SAMEN_REPORT - show dependent code
Package BodyHR_PDT_BUS - show dependent code
Package BodyHR_PPVOL - show dependent code
Package BodyHR_PSF_BUS - show dependent code
Package BodyHR_USER_ACCT_EMP_EXTRACT - show dependent code
PL/SQL PackageHR_USER_ACCT_EMP_EXTRACT - show dependent code
Package BodyHXC_APPROVAL_REPORT_PKG - show dependent code
ViewICX_PER_ORGANIZATION_UNITS_V
ViewICX_PO_OPEN_REQS_BY_USERS_V
ViewICX_PO_REQS_BY_USERS_V
ViewICX_PO_REQ_DIST_V
Package BodyPAY_CA_WF_PKG - show dependent code
Package BodyPAY_DB_PAY_SETUP - show dependent code
Package BodyPAY_FR_DB_PAY_SETUP - show dependent code
Package BodyPAY_MONETARY_UNITS_PKG - show dependent code
Package BodyPAY_US_DB_PER_SETUP - show dependent code
Package BodyPAY_US_EMPLOYEE_PAYSLIP_WEB - show dependent code
Package BodyPA_AP_INTEGRATION - show dependent code
PL/SQL PackagePA_ASSIGNMENTS_PUB - show dependent code
Package BodyPA_ASSIGNMENTS_PUB - show dependent code
PL/SQL PackagePA_ASSIGNMENT_APPROVAL_PUB - show dependent code
Package BodyPA_ASSIGNMENT_APPROVAL_PUB - show dependent code
ViewPA_CUR_EMP_V
Package BodyPA_MASS_ASGMT_TRX - show dependent code
PL/SQL PackagePA_MASS_ASGMT_TRX - show dependent code
Package BodyPER_ASG_BUS1 - show dependent code
Package BodyPER_ASG_BUS2 - show dependent code
Package BodyPER_COBRA_ECI - show dependent code
Package BodyPER_DB_PER_ADDITIONAL - show dependent code
Package BodyPER_DB_PER_SETUP - show dependent code
Package BodyPER_MM_POSITIONS_PKG - show dependent code
ViewPER_ORGANIZATION_UNITS_LOV
ViewPER_POSITION_STRUCTURES_ALL_V
Package BodyPER_POS_BUS - show dependent code
Package BodyPER_PSO_BUS - show dependent code
Package BodyPER_PYP_BUS - show dependent code
Package BodyPO_PDOI_DISTRIBUTIONS_SV3 - show dependent code
ViewPO_POSITIONS_VAL_V