255: ,0)
256: ,P_MIN_PRECISION) VAT_AMOUNT
257: INTO V_VAT_AMOUNT
258: FROM
259: AP_TAX_CODES_ALL ATC,
260: JL_ZZ_AP_SUP_AWT_CD_ALL JZSAC,
261: JL_ZZ_AP_INV_DIS_WH_ALL JZIDW,
262: AP_TAX_CODES_ALL ATC2,
263: AP_INVOICES_ALL AI,
258: FROM
259: AP_TAX_CODES_ALL ATC,
260: JL_ZZ_AP_SUP_AWT_CD_ALL JZSAC,
261: JL_ZZ_AP_INV_DIS_WH_ALL JZIDW,
262: AP_TAX_CODES_ALL ATC2,
263: AP_INVOICES_ALL AI,
264: AP_INVOICE_DISTRIBUTIONS_ALL AID
265: WHERE AI.LEGAL_ENTITY_ID = DECODE(P_REPORTING_LEVEL
266: ,'2000'
307: ,AID.AMOUNT) * ATC2.TAX_RATE) / 100)
308: ,P_MIN_PRECISION) VAT_AMOUNT
309: INTO V_VAT_AMOUNT
310: FROM
311: AP_TAX_CODES_ALL ATC,
312: JL_ZZ_AP_SUP_AWT_CD_ALL JZSAC,
313: JL_ZZ_AP_INV_DIS_WH_ALL JZIDW,
314: AP_TAX_CODES_ALL ATC2,
315: AP_INVOICES_ALL AI,
310: FROM
311: AP_TAX_CODES_ALL ATC,
312: JL_ZZ_AP_SUP_AWT_CD_ALL JZSAC,
313: JL_ZZ_AP_INV_DIS_WH_ALL JZIDW,
314: AP_TAX_CODES_ALL ATC2,
315: AP_INVOICES_ALL AI,
316: AP_INVOICE_DISTRIBUTIONS_ALL AID
317: WHERE '0' NOT IN (
318: SELECT