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 1178: zx_rates_b rates,

1174: po_lines_all pol,
1175: po_line_locations_all poll,
1176: zx_party_tax_profile ptp,
1177: ap_tax_codes_all atc,
1178: zx_rates_b rates,
1179: zx_regimes_b regimes,
1180: zx_taxes_b taxes,
1181: zx_status_b status
1182: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)

Line 1889: zx_rates_b rates,

1885: zx_party_tax_profile ptp,
1886: ap_tax_codes_all atc,
1887: ar_tax_group_codes_all atg,
1888: ap_tax_codes_all atc1,
1889: zx_rates_b rates,
1890: zx_regimes_b regimes,
1891: zx_taxes_b taxes,
1892: zx_status_b status
1893: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)

Line 2249: FROM zx_rates_b zrb

2245: ) RECOVERY_RATE_CODE
2246: ,DECODE(tmp.rec_flag,'N', NULL,
2247: NVL(rates.tax_rate_id,
2248: (SELECT tax_rate_id
2249: FROM zx_rates_b zrb
2250: WHERE zrb.tax_rate_code = 'AD_HOC_RECOVERY'
2251: AND zrb.tax_regime_code = pohzd.tax_regime_code
2252: AND zrb.tax = pohzd.tax
2253: AND zrb.content_owner_id = pohzd.content_owner_id

Line 2387: zx_rates_b rates,

2383: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
2384: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id
2385: ) pohzd,
2386: fnd_currencies fc,
2387: zx_rates_b rates,
2388: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp
2389: WHERE pohzd.trx_currency_code = fc.currency_code(+)
2390: AND rates.tax_regime_code(+) = pohzd.tax_regime_code
2391: AND rates.tax(+) = pohzd.tax

Line 3525: zx_rates_b rates,

3521: fnd_currencies fc,
3522: po_lines_all pol,
3523: zx_party_tax_profile ptp,
3524: ap_tax_codes_all atc,
3525: zx_rates_b rates,
3526: zx_regimes_b regimes,
3527: zx_taxes_b taxes,
3528: zx_status_b status
3529: WHERE NVL(poll.poh_currency_code, poll.aps_base_currency_code) = fc.currency_code(+)

Line 4249: zx_rates_b rates,

4245: zx_party_tax_profile ptp,
4246: ap_tax_codes_all atc,
4247: ar_tax_group_codes_all atg,
4248: ap_tax_codes_all atc1,
4249: zx_rates_b rates,
4250: zx_regimes_b regimes,
4251: zx_taxes_b taxes,
4252: zx_status_b status
4253: WHERE NVL(poll.poh_currency_code, poll.aps_base_currency_code) = fc.currency_code(+)

Line 4610: FROM zx_rates_b zrb

4606: ) RECOVERY_RATE_CODE
4607: ,DECODE(tmp.rec_flag,'N', NULL,
4608: NVL(rates.tax_rate_id,
4609: (SELECT tax_rate_id
4610: FROM zx_rates_b zrb
4611: WHERE zrb.tax_rate_code = 'AD_HOC_RECOVERY'
4612: AND zrb.tax_regime_code = pohzd.tax_regime_code
4613: AND zrb.tax = pohzd.tax
4614: AND zrb.content_owner_id = pohzd.content_owner_id

Line 4749: zx_rates_b rates,

4745: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
4746: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id
4747: ) pohzd,
4748: fnd_currencies fc,
4749: zx_rates_b rates,
4750: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp
4751: WHERE pohzd.trx_currency_code = fc.currency_code(+)
4752: AND rates.tax_regime_code(+) = pohzd.tax_regime_code
4753: AND rates.tax(+) = pohzd.tax

Line 5942: zx_rates_b rates,

5938: po_lines_all pol,
5939: po_line_locations_all poll,
5940: zx_party_tax_profile ptp,
5941: ap_tax_codes_all atc,
5942: zx_rates_b rates,
5943: zx_regimes_b regimes,
5944: zx_taxes_b taxes,
5945: zx_status_b status
5946: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)

Line 6652: zx_rates_b rates,

6648: zx_party_tax_profile ptp,
6649: ap_tax_codes_all atc,
6650: ar_tax_group_codes_all atg,
6651: ap_tax_codes_all atc1,
6652: zx_rates_b rates,
6653: zx_regimes_b regimes,
6654: zx_taxes_b taxes,
6655: zx_status_b status
6656: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)

Line 7001: FROM zx_rates_b zrb

6997: ) RECOVERY_RATE_CODE
6998: ,DECODE(tmp.rec_flag,'N', NULL,
6999: NVL(rates.tax_rate_id,
7000: (SELECT tax_rate_id
7001: FROM zx_rates_b zrb
7002: WHERE zrb.tax_rate_code = 'AD_HOC_RECOVERY'
7003: AND zrb.tax_regime_code = pohzd.tax_regime_code
7004: AND zrb.tax = pohzd.tax
7005: AND zrb.content_owner_id = pohzd.content_owner_id

Line 7144: zx_rates_b rates,

7140: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
7141: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id
7142: ) pohzd,
7143: fnd_currencies fc,
7144: zx_rates_b rates,
7145: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp
7146: WHERE pohzd.trx_currency_code = fc.currency_code(+)
7147: AND rates.tax_regime_code(+) = pohzd.tax_regime_code
7148: AND rates.tax(+) = pohzd.tax

Line 8274: zx_rates_b rates,

8270: fnd_currencies fc,
8271: po_lines_all pol,
8272: zx_party_tax_profile ptp,
8273: ap_tax_codes_all atc,
8274: zx_rates_b rates,
8275: zx_regimes_b regimes,
8276: zx_taxes_b taxes,
8277: zx_status_b status
8278: WHERE NVL(poll.poh_currency_code, poll.aps_base_currency_code) = fc.currency_code(+)

Line 8993: zx_rates_b rates,

8989: zx_party_tax_profile ptp,
8990: ap_tax_codes_all atc,
8991: ar_tax_group_codes_all atg,
8992: ap_tax_codes_all atc1,
8993: zx_rates_b rates,
8994: zx_regimes_b regimes,
8995: zx_taxes_b taxes,
8996: zx_status_b status
8997: WHERE NVL(poll.poh_currency_code, poll.aps_base_currency_code) = fc.currency_code(+)

Line 9340: FROM zx_rates_b zrb

9336: ) RECOVERY_RATE_CODE
9337: ,DECODE(tmp.rec_flag,'N', NULL,
9338: NVL(rates.tax_rate_id,
9339: (SELECT tax_rate_id
9340: FROM zx_rates_b zrb
9341: WHERE zrb.tax_rate_code = 'AD_HOC_RECOVERY'
9342: AND zrb.tax_regime_code = pohzd.tax_regime_code
9343: AND zrb.tax = pohzd.tax
9344: AND zrb.content_owner_id = pohzd.content_owner_id

Line 9484: zx_rates_b rates,

9480: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
9481: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id
9482: ) pohzd,
9483: fnd_currencies fc,
9484: zx_rates_b rates,
9485: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp
9486: WHERE pohzd.trx_currency_code = fc.currency_code(+)
9487: AND rates.tax_regime_code(+) = pohzd.tax_regime_code
9488: AND rates.tax(+) = pohzd.tax