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.

APPS.JL_ZZ_TAX_VALIDATE_PKG dependencies on ZX_STATUS_B

Line 329: ZX_STATUS_B Status,

325: USING (SELECT Status.tax_status_code tax_status_code,
326: TaxLines.trx_id trx_id
327: FROM
328: ZX_IMPORT_TAX_LINES_GT TaxLines,
329: ZX_STATUS_B Status,
330: ZX_TRX_HEADERS_GT Header
331: WHERE
332: Status.tax_regime_code = TaxLines.tax_regime_code
333: AND Status.tax = TaxLines.tax

Line 355: ZX_STATUS_B Status,

351: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines
352: SET tax_status_code =
353: (SELECT tax_status_code
354: FROM
355: ZX_STATUS_B Status,
356: ZX_TRX_HEADERS_GT Header
357: WHERE
358: Status.tax_regime_code = TaxLines.tax_regime_code
359: AND Status.tax = TaxLines.tax

Line 1945: ZX_STATUS_B status ,

1941: ZX_TRX_HEADERS_GT header,
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,

Line 1987: from ZX_status_B

1983: nvl(status.effective_from,header.trx_date) AND
1984: nvl(status.effective_to, header.trx_date)
1985: OR
1986: status.effective_from = (select min(effective_from)
1987: from ZX_status_B
1988: where tax_status_code =
1989: status.tax_status_code)
1990: )
1991: and rate.vat_tax_id(+) = taxlines_gt.tax_rate_id