[Home] [Help] [Dependency Information]

VIEW: APPS.PN_LOCATIONS_V

Object Details

Object Name:	PN_LOCATIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PN.PN_LOCATIONS_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 ROW_ID
,      ORG_ID
,      LOCATION_ID
,      LOCATION_CODE
,      LOCATION_ALIAS
,      LOCATION_NAME
,      PROPERTY_ID
,      PROPERTY_NAME
,      BUILDING_ID
,      BUILDING
,      BUILDING_LOCATION_CODE
,      FLOOR_ID
,      FLOOR
,      FLOOR_LOCATION_CODE
,      OFFICE_ID
,      OFFICE
,      OFFICE_LOCATION_CODE
,      OFFICE_COMMON_AREA_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LOCATION_PARK_ID
,      LOCATION_TYPE_LOOKUP_CODE
,      LEASE_OR_OWNED
,      LEASE_OR_OWNED_TENURE
,      MAX_CAPACITY
,      OPTIMUM_CAPACITY
,      RENTABLE_AREA
,      USABLE_AREA
,      BUILDING_MAX_CAPACITY
,      BUILDING_OPTIMUM_CAPACITY
,      BUILDING_RENTABLE_AREA
,      BUILDING_USABLE_AREA
,      FLOOR_MAX_CAPACITY
,      FLOOR_OPTIMUM_CAPACITY
,      FLOOR_RENTABLE_AREA
,      FLOOR_USABLE_AREA
,      UOM_CODE
,      STATUS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      UNIT_OF_MEASURE
,      ADDRESS_ID
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      ADDRESS_LINE4
,      COUNTY
,      CITY
,      STATE
,      PROVINCE
,      ZIP_CODE
,      COUNTRY
,      ADDRESS_STYLE
,      TERRITORY_ID
,      ADDR_ATTRIBUTE_CATEGORY
,      ADDR_ATTRIBUTE1
,      ADDR_ATTRIBUTE2
,      ADDR_ATTRIBUTE3
,      ADDR_ATTRIBUTE4
,      ADDR_ATTRIBUTE5
,      ADDR_ATTRIBUTE6
,      ADDR_ATTRIBUTE7
,      ADDR_ATTRIBUTE8
,      ADDR_ATTRIBUTE9
,      ADDR_ATTRIBUTE10
,      ADDR_ATTRIBUTE11
,      ADDR_ATTRIBUTE12
,      ADDR_ATTRIBUTE13
,      ADDR_ATTRIBUTE14
,      ADDR_ATTRIBUTE15
,      TERRITORY_SHORT_NAME
,      CONCATENATED_ADDRESS
,      LOCATION_TYPE
,      OFFICE_PARK_ID
,      OFFICE_PARK_NAME
,      REGION_ID
,      REGION_NAME
,      ACTIVE_START_DATE
,      ACTIVE_END_DATE
,      OCCUPANCY_STATUS_CODE
,      OCCUPANCY_STATUS
,      ASSIGNABLE_EMP
,      ASSIGNABLE_CC
,      ASSIGNABLE_CUST
,      DISPOSITION_CODE
,      DISPOSITION
,      ACC_TREATMENT_CODE
,      ACC_TREATMENT
FROM APPS.PN_LOCATIONS_V;

Dependencies

[top of page]

APPS

FND_GLOBAL - show dependent code

FND_LOOKUPS

FND_TERRITORIES_VL

MTL_UNITS_OF_MEASURE

PNP_UTIL_FUNC - show dependent code

PN_ADDRESSES_ALL

PN_LOCATIONS

PN_LOCATIONS_ALL

PN_LOCATION_PARKS

PN_PROPERTIES_ALL

APPS

PN_TERM_TEMPLATES_V