DBA Data[Home] [Help]

APPS.JL_JLCOPCWT_XMLP_PKG dependencies on AP_TAX_CODES_ALL

Line 259: AP_TAX_CODES_ALL ATC,

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,

Line 262: AP_TAX_CODES_ALL ATC2,

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'

Line 311: AP_TAX_CODES_ALL ATC,

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,

Line 314: AP_TAX_CODES_ALL ATC2,

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