DBA Data[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: ViewPER.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
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER (15) Yes
ROW_ID ROWID (10)

BUSINESS_GROUP_ID NUMBER (15) Yes
COST_ALLOCATION_KEYFLEX_ID NUMBER (9)

LOCATION_ID NUMBER (15)

LOCATION_CODE VARCHAR2 (60)

STYLE VARCHAR2 (7)

COUNTRY VARCHAR2 (60)

ADDRESS_LINE_1 VARCHAR2 (240)

ADDRESS_LINE_2 VARCHAR2 (240)

ADDRESS_LINE_3 VARCHAR2 (240)

REGION_1 VARCHAR2 (120)

REGION_2 VARCHAR2 (120)

REGION_3 VARCHAR2 (120)

TELEPHONE_NUMBER_1 VARCHAR2 (60)

TELEPHONE_NUMBER_2 VARCHAR2 (60)

TELEPHONE_NUMBER_3 VARCHAR2 (60)

POSTAL_CODE VARCHAR2 (30)

TOWN_OR_CITY VARCHAR2 (30)

LOC_INFORMATION13 VARCHAR2 (150)
LOC_INFORMATION14 VARCHAR2 (150)
LOC_INFORMATION15 VARCHAR2 (150)
LOC_INFORMATION16 VARCHAR2 (150)
LOC_INFORMATION17 VARCHAR2 (150)
LOC_INFORMATION18 VARCHAR2 (150)
LOC_INFORMATION19 VARCHAR2 (150)
LOC_INFORMATION20 VARCHAR2 (150)
SOFT_CODING_KEYFLEX_ID NUMBER (15)

DATE_FROM DATE
Yes
NAME VARCHAR2 (240) Yes
COMMENTS CLOB (4000)

DATE_TO DATE


INTERNAL_EXTERNAL_FLAG VARCHAR2 (30)

INTERNAL_EXTERNAL_MEANING VARCHAR2 (80)

INTERNAL_ADDRESS_LINE VARCHAR2 (80)

TYPE VARCHAR2 (30)

ORGANIZATION_TYPE VARCHAR2 (80)

REQUEST_ID NUMBER (15)

PROGRAM_APPLICATION_ID NUMBER (15)

PROGRAM_ID NUMBER (15)

PROGRAM_UPDATE_DATE DATE


ATTRIBUTE_CATEGORY VARCHAR2 (30)

ATTRIBUTE1 VARCHAR2 (150)

ATTRIBUTE2 VARCHAR2 (150)

ATTRIBUTE3 VARCHAR2 (150)

ATTRIBUTE4 VARCHAR2 (150)

ATTRIBUTE5 VARCHAR2 (150)

ATTRIBUTE6 VARCHAR2 (150)

ATTRIBUTE7 VARCHAR2 (150)

ATTRIBUTE8 VARCHAR2 (150)

ATTRIBUTE9 VARCHAR2 (150)

ATTRIBUTE10 VARCHAR2 (150)

ATTRIBUTE11 VARCHAR2 (150)

ATTRIBUTE12 VARCHAR2 (150)

ATTRIBUTE13 VARCHAR2 (150)

ATTRIBUTE14 VARCHAR2 (150)

ATTRIBUTE15 VARCHAR2 (150)

ATTRIBUTE16 VARCHAR2 (150)

ATTRIBUTE17 VARCHAR2 (150)

ATTRIBUTE18 VARCHAR2 (150)

ATTRIBUTE19 VARCHAR2 (150)

ATTRIBUTE20 VARCHAR2 (150)

LAST_UPDATE_DATE DATE


LAST_UPDATED_BY NUMBER (15)

LAST_UPDATE_LOGIN NUMBER (15)

CREATED_BY NUMBER (15)

CREATION_DATE DATE


OBJECT_VERSION_NUMBER NUMBER (9)
ATTRIBUTE21 VARCHAR2 (150)

ATTRIBUTE22 VARCHAR2 (150)

ATTRIBUTE23 VARCHAR2 (150)

ATTRIBUTE24 VARCHAR2 (150)

ATTRIBUTE25 VARCHAR2 (150)

ATTRIBUTE26 VARCHAR2 (150)

ATTRIBUTE27 VARCHAR2 (150)

ATTRIBUTE28 VARCHAR2 (150)

ATTRIBUTE29 VARCHAR2 (150)

ATTRIBUTE30 VARCHAR2 (150)

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_ORGANIZATION_UNITS_V references the following:

SchemaAPPS
PL/SQL PackageHR_API - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS_ALL_V
ViewHR_LOOKUPS
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_SECURITY - show dependent code
APPS.HR_ORGANIZATION_UNITS_V is referenced by following:

SchemaAPPS
ViewBEN_ELIG_LGL_ENTY_PRTE_D
ViewBEN_ELIG_ORG_UNIT_PRTE_D
Package BodyBEN_PD_RATE_AND_CVG_MODULE - show dependent code
Package BodyBEN_PLAN_DESIGN_ELPRO_MODULE - show dependent code
Package BodyCST_MGD_MSTR_BOOK_RPT - show dependent code
Package BodyHXT_RETRO_PA - show dependent code
Package BodyHXT_TRAN_PA - show dependent code
ViewICX_HR_ORGS_LOV_V
Package BodyINV_ONHAND_BALANCE - show dependent code
Package BodyINV_TRANSACTIONS_UTIL2 - show dependent code
ViewITG_PO_HEADER_ARCH_V
ViewITG_PO_LINE_LOC_ARCH_V
ViewITG_UPDEL_HEADERS_V
Package BodyJA_JAINARDR_XMLP_PKG - show dependent code
Package BodyJA_JAINDTBR_XMLP_PKG - show dependent code
Package BodyOKC_ARTICLES_IMPORT_GRP - show dependent code
Package BodyOKC_ARTWF_PVT - show dependent code
Package BodyOKC_TERMS_TMPL_APPROVAL_PVT - show dependent code
Package BodyPER_CA_EE_EXTRACT_PKG - show dependent code
Package BodyPER_US_EEO5_PKG - show dependent code
Package BodyPO_COMMUNICATION_PVT - show dependent code
ViewPO_CXML_HEADER_ARCH_V
ViewPO_CXML_LINE_LOC_ARCH_V
ViewPO_ECX_HEADER_ARCH_V
ViewPO_ECX_HEADER_V
ViewPO_ECX_LINE_LOC_ARCH_V
ViewPO_ECX_LINE_LOC_V
Package BodyPO_EMAIL_GENERATE - show dependent code
Package BodyPQH_BDGT_REALLOC_UTILITY - show dependent code
PL/SQL PackagePQH_BDGT_REALLOC_UTILITY - show dependent code
Package BodyPQH_PQHEEO5_XMLP_PKG - show dependent code
Package BodyPQP_GB_TP_EXT_PROCESS - show dependent code
PL/SQL PackagePQP_GB_TP_PENSION_EXTRACTS - show dependent code
Package BodyPQP_PENSION_PROVIDERS - show dependent code
ViewRCV_OPSM_MANUFACT_ADDRESS_V
Package BodyRCV_TRANSACTIONS_UTIL2 - show dependent code
ViewWSH_OPSM_ASN_ORDERS_COMM_V