DBA Data[Home] [Help]

VIEW: APPS.AR_POSTAL_CODE_RANGES_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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