My Portfolio

1) Below is the query to get tax details from invoice:   SELECT  lines.TAX_AMT,lines.tax_rate             FROM zx_lines lines,ra_customer_trx_all rct,ra_customer_trx_lines_all rl,  ZX_TAXES_B ZTB,GL_DAILY_CONVERSION_TYPES gc   where rct.trx_number=:TRX_NUMBER  and rct.customer_trx_id=lines.trx_id  and rct.customer_trx_id       = rl.customer_trx_id   and ZTB.Exchange_Rate_Type=gc.conversion_type   and ztb.tax_id=lines.tax_id   AND RL.LINE_TYPE='LINE'   and rct.org_id=:P_ORG_ID   and lines.trx_line_id=rl.customer_trx_line_id   and rl.customer_trx_line_id=:customer_trx_line_id; 2) For Standard and Blanket PO:     ---for tax rate and amount       SELECT tax_rate  , tax_amt  (SELECT  lines.tax_rate  ,lines.tax_amt       FROM   po_headers_all poh,        po_lines_all pol , po_line_location...

Resources / Technical / Oracle R12 SQL Queries The following are some SQL queries to run to pull Oracle eBTax (Oracle eBusiness Tax) information directly from the tables. a. Tax Regimes: ZX_REGIMES_B b. Taxes: ZX_TAXES_B c. Tax Status: ZX_STATUS_B d. Tax Rates: ZX_RATES_B e. Tax Jurisdictions: ZX_JURISDICTIONS_B f. Tax Rules: ZX_RULES_B You will most likely need to refine your extracts based on the data you have, whether you have migrated data or multiple countries etc. SELECT * FROM zx_regimes_b WHERE tax_regime_code = ‘&tax_regime_code’; SELECT * FROM zx_taxes_b WHERE DECODE(‘&tax_name’,null,’xxx’,tax) = nvl(‘&tax_name’,’xxx’) AND tax_regime_code = ‘&tax_regime_code’; SELECT * FROM zx_status_b WHERE tax = ‘&tax_name’ AND tax_regime_code = ‘&tax_regime_code’; SELECT * FROM zx_rates_b WHERE tax = ‘&tax_name’ AND tax_regime_code = ‘&tax_regime_code’; SELECT * FROM zx_jurisdictions_b WHERE DECODE(‘&tax_name’,null,’xxx’,tax) = nvl(‘&tax_name’,’xxx’)...

Qlikabc123()(][]