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_LOC_COMBINATIONS_OLD

Object Details

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

The AR_LOCATION_COMBINATIONS table stores the combinations of taxing jurisdictions that together define a tax authority. Rows in this table can be manually created using the Tax Authorities window or automatically created by database triggers against the RA_ADDRESSES_ALL table.
.
Each address that exists within the default country, as defined by Oracle Receivables system parameters, will have a set of taxing jurisdictions that are automatically created for that address. Database triggers automatically perform the combination of these jurisdictions into an authority.
.
Whenever new records are created in the AR_LOCATION_COMBINATIONS table, more database
triggers automatically create compiled sales tax rates for this taxing authority into the AR_SALES_TAX table. Only those locations and rates that have overlapping postal code and effective date ranges are combined into a single record in the AR_SALES_TAX table.
.
The primary key for this table is LOCATION_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_LOCATION_COMBINATIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LOCATION_ID
AR_LOCATION_COMBINATIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_ID_SEGMENT_1
AR_LOCATION_COMBINATIONS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_ID_SEGMENT_10
AR_LOCATION_COMBINATIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_ID_SEGMENT_2
AR_LOCATION_COMBINATIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_ID_SEGMENT_3
AR_LOCATION_COMBINATIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_ID_SEGMENT_4
AR_LOCATION_COMBINATIONS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_ID_SEGMENT_5
AR_LOCATION_COMBINATIONS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_ID_SEGMENT_6
AR_LOCATION_COMBINATIONS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_ID_SEGMENT_7
AR_LOCATION_COMBINATIONS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_ID_SEGMENT_8
AR_LOCATION_COMBINATIONS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_ID_SEGMENT_9

Columns

Name	Datatype	Length	Mandatory	Comments
LOCATION_ID	NUMBER	(15)	Yes	Internal location code combination ID
LOCATION_STRUCTURE_ID	NUMBER	(15)	Yes	Identifies which structure of the Sales Tax Location Flexfield that this combination of locations belongs to
ENABLED_FLAG	VARCHAR2	(1)	Yes	Flag that enables or disables a location code combination
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.
START_DATE_ACTIVE	DATE			Date when code combination becomes active
END_DATE_ACTIVE	DATE			Date when code combination is deactivated
SUMMARY_FLAG	VARCHAR2	(1)	Yes	Required by AOL
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).
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).
LOCATION_ID_SEGMENT_1	NUMBER	(15)		Foreign key to the AR_LOCATION_VALUES table for this segment of the Sales Tax Location Flexfield
LOCATION_ID_SEGMENT_2	NUMBER	(15)		Foreign key to the AR_LOCATION_VALUES table for this segment of the Sales Tax Location Flexfield
LOCATION_ID_SEGMENT_3	NUMBER	(15)		Foreign key to the AR_LOCATION_VALUES table for this segment of the Sales Tax Location Flexfield
LOCATION_ID_SEGMENT_4	NUMBER	(15)		Foreign key to the AR_LOCATION_VALUES table for this segment of the Sales Tax Location Flexfield
LOCATION_ID_SEGMENT_5	NUMBER	(15)		Foreign key to the AR_LOCATION_VALUES table for this segment of the Sales Tax Location Flexfield
LOCATION_ID_SEGMENT_6	NUMBER	(15)		Foreign key to the AR_LOCATION_VALUES table for this segment of the Sales Tax Location Flexfield
LOCATION_ID_SEGMENT_7	NUMBER	(15)		Foreign key to the AR_LOCATION_VALUES table for this segment of the Sales Tax Location Flexfield
LOCATION_ID_SEGMENT_8	NUMBER	(15)		Foreign key to the AR_LOCATION_VALUES table for this segment of the Sales Tax Location Flexfield
LOCATION_ID_SEGMENT_9	NUMBER	(15)		Foreign key to the AR_LOCATION_VALUES table for this segment of the Sales Tax Location Flexfield
LOCATION_ID_SEGMENT_10	NUMBER	(15)		Foreign key to the AR_LOCATION_VALUES table for this segment of the Sales Tax Location Flexfield
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
CREATED_BY	NUMBER	(15)		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.

Query Text

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


SELECT LOCATION_ID
,      LOCATION_STRUCTURE_ID
,      ENABLED_FLAG
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      SUMMARY_FLAG
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      LOCATION_ID_SEGMENT_1
,      LOCATION_ID_SEGMENT_2
,      LOCATION_ID_SEGMENT_3
,      LOCATION_ID_SEGMENT_4
,      LOCATION_ID_SEGMENT_5
,      LOCATION_ID_SEGMENT_6
,      LOCATION_ID_SEGMENT_7
,      LOCATION_ID_SEGMENT_8
,      LOCATION_ID_SEGMENT_9
,      LOCATION_ID_SEGMENT_10
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
FROM AR.AR_LOC_COMBINATIONS_OLD;

Dependencies

[top of page]

AR.AR_LOC_COMBINATIONS_OLD does not reference any database object

AR.AR_LOC_COMBINATIONS_OLD is referenced by following:

APPS: AR_LOC_COMBINATIONS_OLD