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

VIEW: APPS.HR_DM_EXP_HR_LOC_ALL_V

Object Details
Object Name: HR_DM_EXP_HR_LOC_ALL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HR_DM_EXP_HR_LOC_ALL_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
LOCATION_ID VARCHAR2 (2000)
column from hr_locations_all
LOCATION_CODE VARCHAR2 (2000)
column from hr_locations_all
BUSINESS_GROUP_ID VARCHAR2 (2000)
column from hr_locations_all
DESCRIPTION VARCHAR2 (2000)
column from hr_locations_all
SHIP_TO_LOCATION_ID VARCHAR2 (2000)
column from hr_locations_all
SHIP_TO_SITE_FLAG VARCHAR2 (2000)
column from hr_locations_all
RECEIVING_SITE_FLAG VARCHAR2 (2000)
column from hr_locations_all
BILL_TO_SITE_FLAG VARCHAR2 (2000)
column from hr_locations_all
IN_ORGANIZATION_FLAG VARCHAR2 (2000)
column from hr_locations_all
OFFICE_SITE_FLAG VARCHAR2 (2000)
column from hr_locations_all
DESIGNATED_RECEIVER_ID VARCHAR2 (2000)
column from hr_locations_all
INVENTORY_ORGANIZATION_ID VARCHAR2 (2000)
column from hr_locations_all
TAX_NAME VARCHAR2 (2000)
column from hr_locations_all
INACTIVE_DATE VARCHAR2 (2000)
column from hr_locations_all
STYLE VARCHAR2 (2000)
column from hr_locations_all
ADDRESS_LINE_1 VARCHAR2 (2000)
column from hr_locations_all
ADDRESS_LINE_2 VARCHAR2 (2000)
column from hr_locations_all
ADDRESS_LINE_3 VARCHAR2 (2000)
column from hr_locations_all
TOWN_OR_CITY VARCHAR2 (2000)
column from hr_locations_all
COUNTRY VARCHAR2 (2000)
column from hr_locations_all
POSTAL_CODE VARCHAR2 (2000)
column from hr_locations_all
REGION_1 VARCHAR2 (2000)
column from hr_locations_all
REGION_2 VARCHAR2 (2000)
column from hr_locations_all
REGION_3 VARCHAR2 (2000)
column from hr_locations_all
TELEPHONE_NUMBER_1 VARCHAR2 (2000)
column from hr_locations_all
TELEPHONE_NUMBER_2 VARCHAR2 (2000)
column from hr_locations_all
TELEPHONE_NUMBER_3 VARCHAR2 (2000)
column from hr_locations_all
LOC_INFORMATION13 VARCHAR2 (2000)
column from hr_locations_all
LOC_INFORMATION14 VARCHAR2 (2000)
column from hr_locations_all
LOC_INFORMATION15 VARCHAR2 (2000)
column from hr_locations_all
LOC_INFORMATION16 VARCHAR2 (2000)
column from hr_locations_all
LOC_INFORMATION17 VARCHAR2 (2000)
column from hr_locations_all
ATTRIBUTE_CATEGORY VARCHAR2 (2000)
column from hr_locations_all
ATTRIBUTE1 VARCHAR2 (2000)
column from hr_locations_all
ATTRIBUTE2 VARCHAR2 (2000)
column from hr_locations_all
ATTRIBUTE3 VARCHAR2 (2000)
column from hr_locations_all
ATTRIBUTE4 VARCHAR2 (2000)
column from hr_locations_all
ATTRIBUTE5 VARCHAR2 (2000)
column from hr_locations_all
ATTRIBUTE6 VARCHAR2 (2000)
column from hr_locations_all
ATTRIBUTE7 VARCHAR2 (2000)
column from hr_locations_all
ATTRIBUTE8 VARCHAR2 (2000)
column from hr_locations_all
ATTRIBUTE9 VARCHAR2 (2000)
column from hr_locations_all
ATTRIBUTE10 VARCHAR2 (2000)
column from hr_locations_all
ATTRIBUTE11 VARCHAR2 (2000)
column from hr_locations_all
ATTRIBUTE12 VARCHAR2 (2000)
column from hr_locations_all
ATTRIBUTE13 VARCHAR2 (2000)
column from hr_locations_all
ATTRIBUTE14 VARCHAR2 (2000)
column from hr_locations_all
ATTRIBUTE15 VARCHAR2 (2000)
column from hr_locations_all
ATTRIBUTE16 VARCHAR2 (2000)
column from hr_locations_all
ATTRIBUTE17 VARCHAR2 (2000)
column from hr_locations_all
ATTRIBUTE18 VARCHAR2 (2000)
column from hr_locations_all
ATTRIBUTE19 VARCHAR2 (2000)
column from hr_locations_all
ATTRIBUTE20 VARCHAR2 (2000)
column from hr_locations_all
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (2000)
column from hr_locations_all
GLOBAL_ATTRIBUTE1 VARCHAR2 (2000)
column from hr_locations_all
GLOBAL_ATTRIBUTE2 VARCHAR2 (2000)
column from hr_locations_all
GLOBAL_ATTRIBUTE3 VARCHAR2 (2000)
column from hr_locations_all
GLOBAL_ATTRIBUTE4 VARCHAR2 (2000)
column from hr_locations_all
GLOBAL_ATTRIBUTE5 VARCHAR2 (2000)
column from hr_locations_all
GLOBAL_ATTRIBUTE6 VARCHAR2 (2000)
column from hr_locations_all
GLOBAL_ATTRIBUTE7 VARCHAR2 (2000)
column from hr_locations_all
GLOBAL_ATTRIBUTE8 VARCHAR2 (2000)
column from hr_locations_all
GLOBAL_ATTRIBUTE9 VARCHAR2 (2000)
column from hr_locations_all
GLOBAL_ATTRIBUTE10 VARCHAR2 (2000)
column from hr_locations_all
GLOBAL_ATTRIBUTE11 VARCHAR2 (2000)
column from hr_locations_all
GLOBAL_ATTRIBUTE12 VARCHAR2 (2000)
column from hr_locations_all
GLOBAL_ATTRIBUTE13 VARCHAR2 (2000)
column from hr_locations_all
GLOBAL_ATTRIBUTE14 VARCHAR2 (2000)
column from hr_locations_all
GLOBAL_ATTRIBUTE15 VARCHAR2 (2000)
column from hr_locations_all
GLOBAL_ATTRIBUTE16 VARCHAR2 (2000)
column from hr_locations_all
GLOBAL_ATTRIBUTE17 VARCHAR2 (2000)
column from hr_locations_all
GLOBAL_ATTRIBUTE18 VARCHAR2 (2000)
column from hr_locations_all
GLOBAL_ATTRIBUTE19 VARCHAR2 (2000)
column from hr_locations_all
GLOBAL_ATTRIBUTE20 VARCHAR2 (2000)
column from hr_locations_all
LONGITUDE VARCHAR2 (2000)
column from hr_locations_all
LATITUDE VARCHAR2 (2000)
column from hr_locations_all
LAST_UPDATE_DATE VARCHAR2 (2000)
column from hr_locations_all
LAST_UPDATED_BY VARCHAR2 (2000)
column from hr_locations_all
LAST_UPDATE_LOGIN VARCHAR2 (2000)
column from hr_locations_all
CREATED_BY VARCHAR2 (2000)
column from hr_locations_all
CREATION_DATE VARCHAR2 (2000)
column from hr_locations_all
ENTERED_BY VARCHAR2 (2000)
column from hr_locations_all
TP_HEADER_ID VARCHAR2 (2000)
column from hr_locations_all
ECE_TP_LOCATION_CODE VARCHAR2 (2000)
column from hr_locations_all
OBJECT_VERSION_NUMBER VARCHAR2 (2000)
column from hr_locations_all
Query Text

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


SELECT EXP_IMP_ID
,      TABLE_NAME
,      LOCATION_ID
,      LOCATION_CODE
,      BUSINESS_GROUP_ID
,      DESCRIPTION
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_SITE_FLAG
,      RECEIVING_SITE_FLAG
,      BILL_TO_SITE_FLAG
,      IN_ORGANIZATION_FLAG
,      OFFICE_SITE_FLAG
,      DESIGNATED_RECEIVER_ID
,      INVENTORY_ORGANIZATION_ID
,      TAX_NAME
,      INACTIVE_DATE
,      STYLE
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      TOWN_OR_CITY
,      COUNTRY
,      POSTAL_CODE
,      REGION_1
,      REGION_2
,      REGION_3
,      TELEPHONE_NUMBER_1
,      TELEPHONE_NUMBER_2
,      TELEPHONE_NUMBER_3
,      LOC_INFORMATION13
,      LOC_INFORMATION14
,      LOC_INFORMATION15
,      LOC_INFORMATION16
,      LOC_INFORMATION17
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      LONGITUDE
,      LATITUDE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      ENTERED_BY
,      TP_HEADER_ID
,      ECE_TP_LOCATION_CODE
,      OBJECT_VERSION_NUMBER
FROM APPS.HR_DM_EXP_HR_LOC_ALL_V;

Dependencies

[top of page]

APPS.HR_DM_EXP_HR_LOC_ALL_V references the following:

SchemaAPPS
SynonymHR_DM_EXP_IMPS
APPS.HR_DM_EXP_HR_LOC_ALL_V is referenced by following:

SchemaAPPS
Package BodyHR_DM_COPY - show dependent code