[Home] [Help] [Dependency Information]

VIEW: APPS.HR_ORGANIZATION_UNITS_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Query Text

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

SELECT ORGANIZATION_ID
,      ROW_ID
,      BUSINESS_GROUP_ID
,      COST_ALLOCATION_KEYFLEX_ID
,      LOCATION_ID
,      LOCATION_CODE
,      STYLE
,      COUNTRY
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      REGION_1
,      REGION_2
,      REGION_3
,      TELEPHONE_NUMBER_1
,      TELEPHONE_NUMBER_2
,      TELEPHONE_NUMBER_3
,      POSTAL_CODE
,      TOWN_OR_CITY
,      LOC_INFORMATION13
,      LOC_INFORMATION14
,      LOC_INFORMATION15
,      LOC_INFORMATION16
,      LOC_INFORMATION17
,      LOC_INFORMATION18
,      LOC_INFORMATION19
,      LOC_INFORMATION20
,      SOFT_CODING_KEYFLEX_ID
,      DATE_FROM
,      NAME
,      COMMENTS
,      DATE_TO
,      INTERNAL_EXTERNAL_FLAG
,      INTERNAL_EXTERNAL_MEANING
,      INTERNAL_ADDRESS_LINE
,      TYPE
,      ORGANIZATION_TYPE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
FROM APPS.HR_ORGANIZATION_UNITS_V;

Dependencies

[top of page]

APPS

HR_API - show dependent code

HR_GENERAL - show dependent code

HR_LOCATIONS_ALL_V

HR_LOOKUPS

HR_ORGANIZATION_UNITS

HR_SECURITY - show dependent code

APPS

BEN_ELIG_LGL_ENTY_PRTE_D

BEN_ELIG_ORG_UNIT_PRTE_D

BEN_PD_RATE_AND_CVG_MODULE - show dependent code

BEN_PLAN_DESIGN_ELPRO_MODULE - show dependent code

CST_MGD_MSTR_BOOK_RPT - show dependent code

HXT_RETRO_PA - show dependent code

HXT_TRAN_PA - show dependent code

ICX_HR_ORGS_LOV_V

INV_ONHAND_BALANCE - show dependent code

INV_TRANSACTIONS_UTIL2 - show dependent code

ITG_PO_HEADER_ARCH_V

ITG_PO_LINE_LOC_ARCH_V

ITG_UPDEL_HEADERS_V

JA_JAINARDR_XMLP_PKG - show dependent code

JA_JAINDTBR_XMLP_PKG - show dependent code

OKC_ARTICLES_IMPORT_GRP - show dependent code

OKC_ARTWF_PVT - show dependent code

OKC_TERMS_TMPL_APPROVAL_PVT - show dependent code

PER_CA_EE_EXTRACT_PKG - show dependent code

PER_US_EEO5_PKG - show dependent code

PO_COMMUNICATION_PVT - show dependent code

PO_CXML_HEADER_ARCH_V

PO_CXML_LINE_LOC_ARCH_V

PO_ECX_HEADER_ARCH_V

PO_ECX_HEADER_V

PO_ECX_LINE_LOC_ARCH_V

PO_ECX_LINE_LOC_V

PO_EMAIL_GENERATE - show dependent code

PQH_BDGT_REALLOC_UTILITY - show dependent code

PQH_BDGT_REALLOC_UTILITY - show dependent code

PQH_PQHEEO5_XMLP_PKG - show dependent code

PQP_GB_TP_EXT_PROCESS - show dependent code

PQP_GB_TP_PENSION_EXTRACTS - show dependent code

PQP_PENSION_PROVIDERS - show dependent code

RCV_OPSM_MANUFACT_ADDRESS_V

RCV_TRANSACTIONS_UTIL2 - show dependent code

WSH_OPSM_ASN_ORDERS_COMM_V