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_PO_PKG dependencies on DUAL

Line 2332: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp

2328: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id
2329: ) pohzd,
2330: fnd_currencies fc,
2331: zx_rates_b rates,
2332: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp
2333: WHERE pohzd.trx_currency_code = fc.currency_code(+)
2334: AND rates.tax_regime_code(+) = pohzd.tax_regime_code
2335: AND rates.tax(+) = pohzd.tax
2336: AND rates.content_owner_id(+) = pohzd.content_owner_id

Line 4666: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp

4662: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id
4663: ) pohzd,
4664: fnd_currencies fc,
4665: zx_rates_b rates,
4666: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp
4667: WHERE pohzd.trx_currency_code = fc.currency_code(+)
4668: AND rates.tax_regime_code(+) = pohzd.tax_regime_code
4669: AND rates.tax(+) = pohzd.tax
4670: AND rates.content_owner_id(+) = pohzd.content_owner_id

Line 7035: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp

7031: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id
7032: ) pohzd,
7033: fnd_currencies fc,
7034: zx_rates_b rates,
7035: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp
7036: WHERE pohzd.trx_currency_code = fc.currency_code(+)
7037: AND rates.tax_regime_code(+) = pohzd.tax_regime_code
7038: AND rates.tax(+) = pohzd.tax
7039: AND rates.content_owner_id(+) = pohzd.content_owner_id

Line 9349: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp

9345: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id
9346: ) pohzd,
9347: fnd_currencies fc,
9348: zx_rates_b rates,
9349: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp
9350: WHERE pohzd.trx_currency_code = fc.currency_code(+)
9351: AND rates.tax_regime_code(+) = pohzd.tax_regime_code
9352: AND rates.tax(+) = pohzd.tax
9353: AND rates.content_owner_id(+) = pohzd.content_owner_id