[Home] [Help]
View: ASO_I_TAX_CODES_V
Product: | ASO - Order Capture |
Description: | view gives information of all the tax codes recognized by AR |
Implementation/DBA Data: |
APPS.ASO_I_TAX_CODES_V
|
View Text
SELECT V.TAX_CODE
, V.TAX_RATE
, V.START_DATE
, V.END_DATE
, V.TAX_TYPE
FROM AR_VAT_TAX V
, AR_SYSTEM_PARAMETERS P
WHERE V.SET_OF_BOOKS_ID = P.SET_OF_BOOKS_ID
AND ((P.TAX_METHOD != 'SALES_TAX'
AND V.TAX_TYPE != 'LOCATION') OR(P.TAX_METHOD = 'SALES_TAX'))
Columns
Name |
TAX_CODE |
TAX_RATE |
START_DATE |
END_DATE |
TAX_TYPE |