eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.JL_ZZ_TAX_VALIDATE_PKG dependencies on AR_VAT_TAX_ALL_B

Line 292: AR_VAT_TAX_ALL_B rates

288: TaxLines.trx_id trx_id
289: FROM
290: ZX_IMPORT_TAX_LINES_GT TaxLines,
291: ZX_TRX_HEADERS_GT Header,
292: AR_VAT_TAX_ALL_B rates
293: WHERE
294: TaxLines.tax_rate_code = rates.tax_code(+)
295: AND Header.trx_date between nvl(rates.start_date,Header.trx_date)
296: and nvl(rates.end_date,Header.trx_date)

Line 389: AR_VAT_TAX_ALL_B Rates,

385: Rates.vat_tax_id ,
386: Rates.tax_rate ,
387: TaxLines.trx_id
388: FROM
389: AR_VAT_TAX_ALL_B Rates,
390: ZX_IMPORT_TAX_LINES_GT TaxLines,
391: ZX_TRX_HEADERS_GT Header
392: WHERE
393: Taxlines.tax_regime_Code = Rates.tax_regime_code

Line 622: AR_VAT_TAX_ALL_B VT

618: USING (SELECT CTT.global_attribute4 output_tax_classification_code,
619: H.trx_id
620: FROM ZX_TRX_HEADERS_GT H,
621: RA_CUST_TRX_TYPES_ALL CTT,
622: AR_VAT_TAX_ALL_B VT
623: WHERE CTT.cust_trx_type_id = H.receivables_trx_type_id
624: AND CTT.org_id = VT.org_id
625: AND CTT.org_id = H.internal_organization_id
626: AND CTT.global_attribute4 = VT.tax_code

Line 1946: AR_VAT_TAX_ALL_B rate ,

1942: ZX_EVNT_CLS_MAPPINGS evntmap,
1943: ZX_REGIMES_B regime ,
1944: ZX_TAXES_B tax ,
1945: ZX_STATUS_B status ,
1946: AR_VAT_TAX_ALL_B rate ,
1947: -- zx_import_tax_lines_gt temp_gt,
1948: ZX_TRANSACTION_LINES_GT lines_gt,
1949: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
1950: GL_SETS_OF_BOOKS gsob