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_RATES_OLD

Object Details

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

The AR_LOCATION_RATES table stores postal code ranges, effective dates, and sales tax rates for each jurisdiction that is defined in the AR_LOCATION_VALUES table. Records are automatically created in this table using the Oracle Receivables Sales Tax Interface program, or manually created using the Tax Locations and Rates window.
.
Whenever new records are created or old ones are updated in this table, database triggers recompile all associated sales tax rates into the AR_SALES_TAX table. Only those locations and rates that have overlapping postal code and effective date ranges for every segment of the Sales Tax Location Flexfield will have corresponding rows created in the AR_SALES_TAX table.
.
The primary keys for this table are LOCATION_SEGMENT_ID, START_DATE, END_DATE, FROM_POSTAL_CODE, TO_POSTAL_CODE, and TAX_RATE.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_LOCATION_RATES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LOCATION_RATE_ID
AR_LOCATION_RATES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	LOCATION_SEGMENT_ID FROM_POSTAL_CODE TO_POSTAL_CODE START_DATE END_DATE TAX_RATE OVERRIDE_RATE1 OVERRIDE_RATE2
AR_LOCATION_RATES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FROM_POSTAL_CODE
AR_LOCATION_RATES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	JURISDICTION_GEOGRAPHY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LOCATION_RATE_ID	NUMBER		Yes	Internal ID sequence number
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_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.
OVERRIDE_STRUCTURE_ID	NUMBER	(15)		Used by city level records, the presence of a value indicates that the Override Parent Rates Descriptive Flexfield should appear
LOCATION_SEGMENT_ID	NUMBER		Yes	Identifies parent location that owns this set of sales tax rates
START_DATE	DATE		Yes	Effective date, low end of range
END_DATE	DATE		Yes	Effective date, high end of range
FROM_POSTAL_CODE	VARCHAR2	(60)	Yes	Lowest possible postal code that this tax rate is effective for. Character, not numeric, comparison.
TO_POSTAL_CODE	VARCHAR2	(60)	Yes	Highest possible postal code that this tax rate is effective for. Character, not numeric, comparison.
TAX_RATE	NUMBER			Sales tax rate that is associated for this location within this postal code and effective date range. If null, then this is just a postal code range record.
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).
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).
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
OVERRIDE_RATE1	NUMBER			Sales tax rate that overrides Segment 1 of the Location Flexfield, or null for no override
OVERRIDE_RATE2	NUMBER			Sales tax rate that overrides Segment 2 of the Location Flexfield, or null for no override
OVERRIDE_RATE3	NUMBER			Sales tax rate that overrides Segment 3 of the Location Flexfield, or null for no override
OVERRIDE_RATE4	NUMBER			Sales tax rate that overrides Segment 4 of the Location Flexfield, or null for no override
OVERRIDE_RATE5	NUMBER			Sales tax rate that overrides Segment 5 of the Location Flexfield, or null for no override
OVERRIDE_RATE6	NUMBER			Sales tax rate that overrides Segment 6 of the Location Flexfield, or null for no override
OVERRIDE_RATE7	NUMBER			Sales tax rate that overrides Segment 7 of the Location Flexfield, or null for no override
OVERRIDE_RATE8	NUMBER			Sales tax rate that overrides Segment 8 of the Location Flexfield, or null for no override
OVERRIDE_RATE9	NUMBER			Sales tax rate that overrides Segment 9 of the Location Flexfield, or null for no override
OVERRIDE_RATE10	NUMBER			Sales tax rate that overrides Segment 10 of the Location Flexfield, or null for no override
JURISDICTION_GEOGRAPHY_ID	NUMBER	(15)		Jurisdiction Geography Id
OVERRIDE_GEOGRAPHY_ID	NUMBER	(15)		Override Geography ID
PRECEDENCE_LEVEL	NUMBER	(15)		Precedence Level
INNER_CITY_FLAG	VARCHAR2	(1)		Inner city flag
TAX_CODE	VARCHAR2	(50)		Tax Code

Query Text

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


SELECT LOCATION_RATE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      OVERRIDE_STRUCTURE_ID
,      LOCATION_SEGMENT_ID
,      START_DATE
,      END_DATE
,      FROM_POSTAL_CODE
,      TO_POSTAL_CODE
,      TAX_RATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      OVERRIDE_RATE1
,      OVERRIDE_RATE2
,      OVERRIDE_RATE3
,      OVERRIDE_RATE4
,      OVERRIDE_RATE5
,      OVERRIDE_RATE6
,      OVERRIDE_RATE7
,      OVERRIDE_RATE8
,      OVERRIDE_RATE9
,      OVERRIDE_RATE10
,      JURISDICTION_GEOGRAPHY_ID
,      OVERRIDE_GEOGRAPHY_ID
,      PRECEDENCE_LEVEL
,      INNER_CITY_FLAG
,      TAX_CODE
FROM AR.AR_LOCATION_RATES_OLD;

Dependencies

[top of page]

AR.AR_LOCATION_RATES_OLD does not reference any database object

AR.AR_LOCATION_RATES_OLD is referenced by following:

APPS: AR_LOCATION_RATES_OLD