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
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
|
|
|