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 ZX_RATES_B

Line 1148: zx_rates_b rates,

1144: po_lines_all pol,
1145: po_line_locations_all poll,
1146: zx_party_tax_profile ptp,
1147: ap_tax_codes_all atc,
1148: zx_rates_b rates,
1149: zx_regimes_b regimes,
1150: zx_taxes_b taxes,
1151: zx_status_b status
1152: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)

Line 1863: zx_rates_b rates,

1859: zx_party_tax_profile ptp,
1860: ap_tax_codes_all atc,
1861: ar_tax_group_codes_all atg,
1862: ap_tax_codes_all atc1,
1863: zx_rates_b rates,
1864: zx_regimes_b regimes,
1865: zx_taxes_b taxes,
1866: zx_status_b status
1867: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)

Line 2331: zx_rates_b rates,

2327: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
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

Line 3467: zx_rates_b rates,

3463: fnd_currencies fc,
3464: po_lines_all pol,
3465: zx_party_tax_profile ptp,
3466: ap_tax_codes_all atc,
3467: zx_rates_b rates,
3468: zx_regimes_b regimes,
3469: zx_taxes_b taxes,
3470: zx_status_b status
3471: WHERE NVL(poll.poh_currency_code, poll.aps_base_currency_code) = fc.currency_code(+)

Line 4194: zx_rates_b rates,

4190: zx_party_tax_profile ptp,
4191: ap_tax_codes_all atc,
4192: ar_tax_group_codes_all atg,
4193: ap_tax_codes_all atc1,
4194: zx_rates_b rates,
4195: zx_regimes_b regimes,
4196: zx_taxes_b taxes,
4197: zx_status_b status
4198: WHERE NVL(poll.poh_currency_code, poll.aps_base_currency_code) = fc.currency_code(+)

Line 4665: zx_rates_b rates,

4661: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
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

Line 5856: zx_rates_b rates,

5852: po_lines_all pol,
5853: po_line_locations_all poll,
5854: zx_party_tax_profile ptp,
5855: ap_tax_codes_all atc,
5856: zx_rates_b rates,
5857: zx_regimes_b regimes,
5858: zx_taxes_b taxes,
5859: zx_status_b status
5860: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)

Line 6569: zx_rates_b rates,

6565: zx_party_tax_profile ptp,
6566: ap_tax_codes_all atc,
6567: ar_tax_group_codes_all atg,
6568: ap_tax_codes_all atc1,
6569: zx_rates_b rates,
6570: zx_regimes_b regimes,
6571: zx_taxes_b taxes,
6572: zx_status_b status
6573: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)

Line 7034: zx_rates_b rates,

7030: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
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

Line 8162: zx_rates_b rates,

8158: fnd_currencies fc,
8159: po_lines_all pol,
8160: zx_party_tax_profile ptp,
8161: ap_tax_codes_all atc,
8162: zx_rates_b rates,
8163: zx_regimes_b regimes,
8164: zx_taxes_b taxes,
8165: zx_status_b status
8166: WHERE NVL(poll.poh_currency_code, poll.aps_base_currency_code) = fc.currency_code(+)

Line 8884: zx_rates_b rates,

8880: zx_party_tax_profile ptp,
8881: ap_tax_codes_all atc,
8882: ar_tax_group_codes_all atg,
8883: ap_tax_codes_all atc1,
8884: zx_rates_b rates,
8885: zx_regimes_b regimes,
8886: zx_taxes_b taxes,
8887: zx_status_b status
8888: WHERE NVL(poll.poh_currency_code, poll.aps_base_currency_code) = fc.currency_code(+)

Line 9348: zx_rates_b rates,

9344: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
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