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.ZX_ON_FLY_TRX_UPGRADE_AP_PKG dependencies on ZX_TAXES_B

Line 1801: index(taxes,ZX_TAXES_B_U2) */

1797: ,ACCOUNT_SOURCE_TAX_RATE_ID
1798: )
1799: (SELECT /*+ ROWID(inv) NO_EXPAND ORDERED
1800: use_nl(fnd_curr,ap_dists,ap_dists1,lines1,rates,regimes,taxes,status,ptp)
1801: index(taxes,ZX_TAXES_B_U2) */
1802: NVL(lines1.org_id,-99) INTERNAL_ORGANIZATION_ID
1803: ,200 APPLICATION_ID
1804: ,'AP_INVOICES' ENTITY_CODE
1805: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE ,

Line 2125: zx_taxes_b taxes,

2121: ap_invoice_lines_all lines1,
2122: ap_invoice_lines_all lines,
2123: zx_rates_b rates,
2124: zx_regimes_b regimes,
2125: zx_taxes_b taxes,
2126: zx_status_b status,
2127: zx_party_tax_profile ptp
2128: WHERE inv.invoice_id = p_upg_trx_info_rec.trx_id
2129: AND fnd_curr.currency_code = inv.invoice_currency_code

Line 3949: index(taxes,ZX_TAXES_B_U2) */

3945: ,ACCOUNT_SOURCE_TAX_RATE_ID
3946: )
3947: (SELECT /*+ ROWID(inv) NO_EXPAND ORDERED
3948: use_nl(fnd_curr,ap_dists,ap_dists1,lines1,rates,regimes,taxes,status,ptp)
3949: index(taxes,ZX_TAXES_B_U2) */
3950: NVL(lines1.org_id,-99) INTERNAL_ORGANIZATION_ID
3951: ,200 APPLICATION_ID
3952: ,'AP_INVOICES' ENTITY_CODE
3953: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE ,

Line 4269: zx_taxes_b taxes,

4265: ap_invoice_lines_all lines1,
4266: ap_invoice_lines_all lines,
4267: zx_rates_b rates,
4268: zx_regimes_b regimes,
4269: zx_taxes_b taxes,
4270: zx_status_b status,
4271: zx_party_tax_profile ptp
4272: WHERE zxvalerr.other_doc_application_id = 200
4273: AND inv.invoice_id = zxvalerr.other_doc_trx_id