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: AR.AR_LOCATION_VALUES_OLD

Object Details

Object Name:	AR_LOCATION_VALUES_OLD
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.AR_LOCATION_VALUES_OLD
Subobject Name:
Status:	VALID

The AR_LOCATION_VALUES table defines each jurisdiction that Oracle Receivables uses to validate segments of a customer address and compile sales tax rates.
.
The Sales Tax Location Flexfield defines the structure that Receivables uses to relate one segment of an address to another. Rows are automatically created in this table either by using the Oracle Receivables Sales Tax Interface program, or when a new customer address is created. Rows can also be manually created using the Tax Locations and Rates window.
.
Locations exist within other parent locations. Receivables uses the PARENT_SEGMENT_ID column to enforce this business rule. The first or senior segment of the Sales Tax Location Flexfield is exempt from this ownership rule.
.
The primary keys for this table are LOCATION_SEGMENT_QUALIFIER, LOCATION_SEGMENT_VALUE, and PARENT_SEGMENT_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_LOCATION_VALUES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LOCATION_SEGMENT_QUALIFIER LOCATION_SEGMENT_VALUE PARENT_SEGMENT_ID LOCATION_STRUCTURE_ID
AR_LOCATION_VALUES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	LOCATION_SEGMENT_QUALIFIER LOCATION_SEGMENT_VALUE LOCATION_SEGMENT_ID
AR_LOCATION_VALUES_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	PARENT_SEGMENT_ID LOCATION_SEGMENT_ID
AR_LOCATION_VALUES_U4	NORMAL	UNIQUE	APPS_TS_TX_IDX	LOCATION_SEGMENT_ID
AR_LOCATION_VALUES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_SEGMENT_QUALIFIER LOCATION_SEGMENT_USER_VALUE PARENT_SEGMENT_ID
AR_LOCATION_VALUES_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_SEGMENT_QUALIFIER LOCATION_SEGMENT_USER_VALUE LOCATION_SEGMENT_ID
AR_LOCATION_VALUES_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_SEGMENT_VALUE
AR_LOCATION_VALUES_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GEOGRAPHY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LOCATION_SEGMENT_ID	NUMBER		Yes	Internal location segment ID
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LOCATION_STRUCTURE_ID	NUMBER	(15)	Yes	Identifies the Sales Tax Location Structure that this hierarchy of values is used for
LOCATION_SEGMENT_QUALIFIER	VARCHAR2	(30)	Yes	Identifies which authority this location is for. Values may be sourced from the RA_ADDRESSES table.
LOCATION_SEGMENT_VALUE	VARCHAR2	(60)	Yes	Upper case of the value in AR_LOCATION_VALUES.LOCATION_SEGMENT_USER_VALUE
LOCATION_SEGMENT_DESCRIPTION	VARCHAR2	(80)		Long name for this location, used for reporting purposes only
PARENT_SEGMENT_ID	NUMBER			Identifies which location owns this location. For example, which state owns this county.
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LOCATION_SEGMENT_USER_VALUE	VARCHAR2	(60)	Yes	Short name for this location, sourced from one of the columns in the RA_ADDRESSES or AR_TAX_INTERFACE tables
TAX_ACCOUNT_CCID	NUMBER	(15)		Identifier for tax account code combination
ORG_ID	NUMBER	(15)		Organization identifier
INTERIM_TAX_CCID	NUMBER	(15)		Code combination ID of the Accounting Flexfield for the deferred tax account
ADJ_CCID	NUMBER	(15)		Code combination ID of the Accounting Flexfield for the revenue/net expense account for adjustments
EDISC_CCID	NUMBER	(15)		Code combination ID of the Accounting Flexfield for the expense account for earned discounts
UNEDISC_CCID	NUMBER	(15)		Code combination ID of the Accounting Flexfield for the expense account for unearned discounts
FINCHRG_CCID	NUMBER	(15)		Code combination ID of the Accounting Flexfield for the revenue account for finance charges
ADJ_NON_REC_TAX_CCID	NUMBER	(15)		Code combination ID of the Accounting Flexfield for the non-recoverable tax account for adjustments
EDISC_NON_REC_TAX_CCID	NUMBER	(15)		Code combination ID of the Accounting Flexfield for the non-recoverable tax account for earned discounts
UNEDISC_NON_REC_TAX_CCID	NUMBER	(15)		Code combination ID of the Accounting Flexfield for the non-recoverable tax account for unearned discounts
FINCHRG_NON_REC_TAX_CCID	NUMBER	(15)		Code combination ID of the Accounting Flexfield for the non-recoverable account for finance charges
GEOGRAPHY_ID	NUMBER	(15)		Geography Id
COUNTRY_GEOGRAPHY_ID	NUMBER	(15)		Country Geography ID

Query Text

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


SELECT LOCATION_SEGMENT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LOCATION_STRUCTURE_ID
,      LOCATION_SEGMENT_QUALIFIER
,      LOCATION_SEGMENT_VALUE
,      LOCATION_SEGMENT_DESCRIPTION
,      PARENT_SEGMENT_ID
,      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
,      LAST_UPDATE_LOGIN
,      LOCATION_SEGMENT_USER_VALUE
,      TAX_ACCOUNT_CCID
,      ORG_ID
,      INTERIM_TAX_CCID
,      ADJ_CCID
,      EDISC_CCID
,      UNEDISC_CCID
,      FINCHRG_CCID
,      ADJ_NON_REC_TAX_CCID
,      EDISC_NON_REC_TAX_CCID
,      UNEDISC_NON_REC_TAX_CCID
,      FINCHRG_NON_REC_TAX_CCID
,      GEOGRAPHY_ID
,      COUNTRY_GEOGRAPHY_ID
FROM AR.AR_LOCATION_VALUES_OLD;

Dependencies

[top of page]

AR.AR_LOCATION_VALUES_OLD does not reference any database object

AR.AR_LOCATION_VALUES_OLD is referenced by following:

APPS: AR_LOCATION_VALUES_OLD