eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: AP.AP_EXP_LOCATIONS

Object Details

Object Name:	AP_EXP_LOCATIONS
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_EXP_LOCATIONS
Subobject Name:
Status:	VALID

The AP_EXP_LOCATIONS table stores information about all unique locations used by Expenses. Currently, this table only stores locations used by credit card transactions. This table can store partial addresses as well.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_EXP_LOCATIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LOCATION_ID
AP_EXP_LOCATIONS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ADDRESS_KEY
SYS_IL0000322921C00024$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000322921C00025$$	LOB	UNIQUE	APPS_TS_TX_DATA

Columns

Name	Datatype	Length	Mandatory	Comments
LOCATION_ID	NUMBER	(15)	Yes	Location identifier
ADDRESS_KEY	VARCHAR2	(660)	Yes	Derived key that facilitates searches and uniqueness checks
ADDRESS1	VARCHAR2	(80)		First line for address
ADDRESS2	VARCHAR2	(80)		Second line for address
ADDRESS3	VARCHAR2	(80)		Third line for address
ADDRESS4	VARCHAR2	(80)		Fourth line for address
CITY	VARCHAR2	(80)		City
PROVINCE_STATE	VARCHAR2	(80)		Province or State
POSTAL_CODE	VARCHAR2	(80)		Postal Code
COUNTRY	VARCHAR2	(80)		Country
GEOMETRY_STATUS_CODE	VARCHAR2	(30)		Spatial data integration status for given location
ORG_ID	NUMBER	(15)		Organization identifier
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
GEOMETRY	SDO_GEOMETRY	(1)

Query Text

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


SELECT LOCATION_ID
,      ADDRESS_KEY
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      PROVINCE_STATE
,      POSTAL_CODE
,      COUNTRY
,      GEOMETRY_STATUS_CODE
,      ORG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      GEOMETRY
FROM AP.AP_EXP_LOCATIONS;

Dependencies

[top of page]

AP.AP_EXP_LOCATIONS references the following:

MDSYS: SDO_ELEM_INFO_ARRAY; SDO_GEOMETRY; SDO_ORDINATE_ARRAY
SYS: STANDARD - show dependent code

AP.AP_EXP_LOCATIONS is referenced by following:

AP: AP_EXP_LOCATIONS#