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: ICX.POR_LOCATION_LOADER_VALUES

Object Details

Object Name:	POR_LOCATION_LOADER_VALUES
Object Type:	TABLE
Owner:	ICX
FND Design Data:	ICX.POR_LOCATION_LOADER_VALUES
Subobject Name:
Status:	VALID

The table stores the location information for an location and is populated by the location loader.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
POR_LOCATION_LOADER_VALUES_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	LOCATION_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
LOCATION_CODE	VARCHAR2	(30)		The location code for this location
BUSINESS_GROUP	VARCHAR2	(240)		The business group to which this location belongs to
EFFECTIVE_DATE	DATE			The date from which this location is effective
DESCRIPTION	VARCHAR2	(240)		The description associated with this location.
ADDRESS_STYLE	VARCHAR2	(30)		The address style for the address of this location
ADDRESS_LINE_1	VARCHAR2	(60)		The line 1 of the address of the location
ADDRESS_LINE_2	VARCHAR2	(60)		The line 2 of the address of the location
ADDRESS_LINE_3	VARCHAR2	(60)		The line 3 of the address of the location
CITY	VARCHAR2	(30)		The city of the address of the location
COUNTY	VARCHAR2	(30)		The county of the address of the location
STATE	VARCHAR2	(30)		The state of the address of the location
POSTAL_CODE	VARCHAR2	(30)		The postal code of the address of the location
COUNTRY	VARCHAR2	(30)		The country of the address of the location
TELEPHONE	VARCHAR2	(30)		The telephone number at the address of the location
FAX	VARCHAR2	(30)		The fax number at the address of the location
SHIP_TO_LOCATION	VARCHAR2	(30)		The ship to location associated with this location
SHIP_TO_FLAG	VARCHAR2	(30)		Flag to indicate if this is a ship to location
BILL_TO_FLAG	VARCHAR2	(30)		Flag to indicate if this is a bill to location
RECEIVING_TO_FLAG	VARCHAR2	(30)		Flag to indicate if this is a receive to location
OFFICE_SITE	VARCHAR2	(30)		Flag to indicate if this is a office site
INTERNAL_SITE	VARCHAR2	(30)		Flag to indicate if this is a internal site
INVENTORY_ORG	VARCHAR2	(30)		The inventory organization to which this location is associated
TAX_NAME	VARCHAR2	(30)		The tax name associated with this location
LOADER_STATUS	VARCHAR2	(30)		This indicates if this location record was correctly loaded.
LAST_UPDATE_DATE	DATE		Yes	The date that the record was last updated.
CREATED_BY	NUMBER	(15)	Yes	The person who created the record.
CREATION_DATE	DATE		Yes	The date the record was created
LAST_UPDATE_LOGIN	NUMBER	(15)		The user name of the person who last updated it
LAST_UPDATED_BY	NUMBER	(15)	Yes	The person who last updated it

Query Text

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


SELECT LOCATION_CODE
,      BUSINESS_GROUP
,      EFFECTIVE_DATE
,      DESCRIPTION
,      ADDRESS_STYLE
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      CITY
,      COUNTY
,      STATE
,      POSTAL_CODE
,      COUNTRY
,      TELEPHONE
,      FAX
,      SHIP_TO_LOCATION
,      SHIP_TO_FLAG
,      BILL_TO_FLAG
,      RECEIVING_TO_FLAG
,      OFFICE_SITE
,      INTERNAL_SITE
,      INVENTORY_ORG
,      TAX_NAME
,      LOADER_STATUS
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
FROM ICX.POR_LOCATION_LOADER_VALUES;

Dependencies

[top of page]

ICX.POR_LOCATION_LOADER_VALUES does not reference any database object

ICX.POR_LOCATION_LOADER_VALUES is referenced by following:

APPS: POR_LOCATION_LOADER_VALUES