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


VIEW: APPS.HR_DM_EXP_ORG_INFO_V

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
EXP_IMP_ID NUMBER (15) Yes Foreign key to hr_dm_exp_imps
TABLE_NAME VARCHAR2 (30) Yes table name
ORG_INFORMATION_ID VARCHAR2 (2000)
column from hr_organization_information
ORG_INFORMATION_CONTEXT VARCHAR2 (2000)
column from hr_organization_information
ORGANIZATION_ID VARCHAR2 (2000)
column from hr_organization_information
ORG_INFORMATION1 VARCHAR2 (2000)
column from hr_organization_information
ORG_INFORMATION10 VARCHAR2 (2000)
column from hr_organization_information
ORG_INFORMATION11 VARCHAR2 (2000)
column from hr_organization_information
ORG_INFORMATION12 VARCHAR2 (2000)
column from hr_organization_information
ORG_INFORMATION13 VARCHAR2 (2000)
column from hr_organization_information
ORG_INFORMATION14 VARCHAR2 (2000)
column from hr_organization_information
ORG_INFORMATION15 VARCHAR2 (2000)
column from hr_organization_information
ORG_INFORMATION16 VARCHAR2 (2000)
column from hr_organization_information
ORG_INFORMATION17 VARCHAR2 (2000)
column from hr_organization_information
ORG_INFORMATION18 VARCHAR2 (2000)
column from hr_organization_information
ORG_INFORMATION19 VARCHAR2 (2000)
column from hr_organization_information
ORG_INFORMATION2 VARCHAR2 (2000)
column from hr_organization_information
ORG_INFORMATION20 VARCHAR2 (2000)
column from hr_organization_information
ORG_INFORMATION3 VARCHAR2 (2000)
column from hr_organization_information
ORG_INFORMATION4 VARCHAR2 (2000)
column from hr_organization_information
ORG_INFORMATION5 VARCHAR2 (2000)
column from hr_organization_information
ORG_INFORMATION6 VARCHAR2 (2000)
column from hr_organization_information
ORG_INFORMATION7 VARCHAR2 (2000)
column from hr_organization_information
ORG_INFORMATION8 VARCHAR2 (2000)
column from hr_organization_information
ORG_INFORMATION9 VARCHAR2 (2000)
column from hr_organization_information
REQUEST_ID VARCHAR2 (2000)
column from hr_organization_information
PROGRAM_APPLICATION_ID VARCHAR2 (2000)
column from hr_organization_information
PROGRAM_ID VARCHAR2 (2000)
column from hr_organization_information
PROGRAM_UPDATE_DATE VARCHAR2 (2000)
column from hr_organization_information
ATTRIBUTE_CATEGORY VARCHAR2 (2000)
column from hr_organization_information
ATTRIBUTE1 VARCHAR2 (2000)
column from hr_organization_information
ATTRIBUTE2 VARCHAR2 (2000)
column from hr_organization_information
ATTRIBUTE3 VARCHAR2 (2000)
column from hr_organization_information
ATTRIBUTE4 VARCHAR2 (2000)
column from hr_organization_information
ATTRIBUTE5 VARCHAR2 (2000)
column from hr_organization_information
ATTRIBUTE6 VARCHAR2 (2000)
column from hr_organization_information
ATTRIBUTE7 VARCHAR2 (2000)
column from hr_organization_information
ATTRIBUTE8 VARCHAR2 (2000)
column from hr_organization_information
ATTRIBUTE9 VARCHAR2 (2000)
column from hr_organization_information
ATTRIBUTE10 VARCHAR2 (2000)
column from hr_organization_information
ATTRIBUTE11 VARCHAR2 (2000)
column from hr_organization_information
ATTRIBUTE12 VARCHAR2 (2000)
column from hr_organization_information
ATTRIBUTE13 VARCHAR2 (2000)
column from hr_organization_information
ATTRIBUTE14 VARCHAR2 (2000)
column from hr_organization_information
ATTRIBUTE15 VARCHAR2 (2000)
column from hr_organization_information
ATTRIBUTE16 VARCHAR2 (2000)
column from hr_organization_information
ATTRIBUTE17 VARCHAR2 (2000)
column from hr_organization_information
ATTRIBUTE18 VARCHAR2 (2000)
column from hr_organization_information
ATTRIBUTE19 VARCHAR2 (2000)
column from hr_organization_information
ATTRIBUTE20 VARCHAR2 (2000)
column from hr_organization_information
LAST_UPDATE_DATE VARCHAR2 (2000)
column from hr_organization_information
LAST_UPDATED_BY VARCHAR2 (2000)
column from hr_organization_information
LAST_UPDATE_LOGIN VARCHAR2 (2000)
column from hr_organization_information
CREATED_BY VARCHAR2 (2000)
column from hr_organization_information
CREATION_DATE VARCHAR2 (2000)
column from hr_organization_information
Query Text

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


SELECT EXP_IMP_ID
,      TABLE_NAME
,      ORG_INFORMATION_ID
,      ORG_INFORMATION_CONTEXT
,      ORGANIZATION_ID
,      ORG_INFORMATION1
,      ORG_INFORMATION10
,      ORG_INFORMATION11
,      ORG_INFORMATION12
,      ORG_INFORMATION13
,      ORG_INFORMATION14
,      ORG_INFORMATION15
,      ORG_INFORMATION16
,      ORG_INFORMATION17
,      ORG_INFORMATION18
,      ORG_INFORMATION19
,      ORG_INFORMATION2
,      ORG_INFORMATION20
,      ORG_INFORMATION3
,      ORG_INFORMATION4
,      ORG_INFORMATION5
,      ORG_INFORMATION6
,      ORG_INFORMATION7
,      ORG_INFORMATION8
,      ORG_INFORMATION9
,      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
FROM APPS.HR_DM_EXP_ORG_INFO_V;

Dependencies

[top of page]

APPS.HR_DM_EXP_ORG_INFO_V references the following:

SchemaAPPS
SynonymHR_DM_EXP_IMPS
APPS.HR_DM_EXP_ORG_INFO_V is referenced by following:

SchemaAPPS
Package BodyHR_DM_COPY - show dependent code