FND Design Data [Home] [Help]

View: AR_POSTAL_CODE_RANGES_V

Product: AR - Receivables
Description: (Release 115 Only)
Implementation/DBA Data: ViewAPPS.AR_POSTAL_CODE_RANGES_V
View Text

SELECT LOCATION_RATE_ID LOCATION_RATE_ID
, FROM_POSTAL_CODE FROM_POSTAL_CODE
, TO_POSTAL_CODE TO_POSTAL_CODE
, LOCATION_SEGMENT_ID LOCATION_SEGMENT_ID
, ATTRIBUTE1 SALES_TAX_GEOCODE
, TAX_RATE TAX_RATE
FROM AR_LOCATION_RATES
WHERE SYSDATE BETWEEN START_DATE
AND END_DATE

Columns

Name
LOCATION_RATE_ID
FROM_POSTAL_CODE
TO_POSTAL_CODE
LOCATION_SEGMENT_ID
SALES_TAX_GEOCODE
TAX_RATE