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_TCM_TAX_RATE_PKG dependencies on ZX_SCO_RATES_B_V

Line 167: FROM ZX_SCO_RATES_B_V rate, ZX_JURISDICTIONS_GT jur

163: rate.taxable_basis_formula_code,
164: rate.adj_for_adhoc_amt_code,
165: rate.inclusive_tax_flag,
166: rate.tax_class
167: FROM ZX_SCO_RATES_B_V rate, ZX_JURISDICTIONS_GT jur
168: WHERE rate.tax_jurisdiction_code = jur.tax_jurisdiction_code
169: AND rate.tax = jur.tax
170: AND rate.tax_regime_code = jur.tax_regime_code
171: AND rate.effective_from <= p_tax_date

Line 206: FROM ZX_SCO_RATES_B_V rate, ZX_JURISDICTIONS_GT jur

202: taxable_basis_formula_code,
203: adj_for_adhoc_amt_code,
204: inclusive_tax_flag,
205: tax_class
206: FROM ZX_SCO_RATES_B_V rate, ZX_JURISDICTIONS_GT jur
207: WHERE rate.tax_jurisdiction_code = jur.tax_jurisdiction_code
208: AND rate.tax = jur.tax
209: AND rate.tax_regime_code = jur.tax_regime_code
210: AND rate.effective_from <= p_tax_date

Line 427: FROM ZX_SCO_RATES_B_V rate, ZX_JURISDICTIONS_GT jur

423: taxable_basis_formula_code,
424: adj_for_adhoc_amt_code,
425: inclusive_tax_flag,
426: tax_class
427: FROM ZX_SCO_RATES_B_V rate, ZX_JURISDICTIONS_GT jur
428: WHERE rate.tax_jurisdiction_code = jur.tax_jurisdiction_code
429: AND rate.tax = jur.tax
430: AND rate.tax_regime_code = jur.tax_regime_code
431: AND rate.tax_status_code = p_tax_status_code

Line 467: FROM ZX_SCO_RATES_B_V rate, ZX_JURISDICTIONS_GT jur

463: taxable_basis_formula_code,
464: adj_for_adhoc_amt_code,
465: inclusive_tax_flag,
466: tax_class
467: FROM ZX_SCO_RATES_B_V rate, ZX_JURISDICTIONS_GT jur
468: WHERE rate.tax_jurisdiction_code = jur.tax_jurisdiction_code
469: AND rate.tax = jur.tax
470: AND rate.tax_regime_code = jur.tax_regime_code
471: AND rate.tax_status_code = p_tax_status_code

Line 682: FROM ZX_SCO_RATES_B_V -- Bug#5395227

678: taxable_basis_formula_code,
679: adj_for_adhoc_amt_code,
680: inclusive_tax_flag,
681: tax_class
682: FROM ZX_SCO_RATES_B_V -- Bug#5395227
683: WHERE tax_jurisdiction_code = p_tax_jurisdiction_code
684: AND effective_from <= p_tax_date
685: AND (effective_to >= p_tax_date OR effective_to IS NULL )
686: AND tax_rate_code = p_tax_rate_code

Line 719: FROM ZX_SCO_RATES_B_V -- Bug#5395227

715: taxable_basis_formula_code,
716: adj_for_adhoc_amt_code,
717: inclusive_tax_flag,
718: tax_class
719: FROM ZX_SCO_RATES_B_V -- Bug#5395227
720: WHERE tax_jurisdiction_code = p_tax_jurisdiction_code
721: AND effective_from <= p_tax_date
722: AND (effective_to >= p_tax_date OR effective_to IS NULL )
723: AND tax_rate_code = p_tax_rate_code

Line 930: FROM ZX_SCO_RATES_B_V -- Bug#5395227

926: taxable_basis_formula_code,
927: adj_for_adhoc_amt_code,
928: inclusive_tax_flag,
929: tax_class
930: FROM ZX_SCO_RATES_B_V -- Bug#5395227
931: WHERE tax_jurisdiction_code IS NULL
932: AND effective_from <= p_tax_date
933: AND ( effective_to >= p_tax_date OR effective_to IS NULL)
934: AND tax_rate_code = p_tax_rate_code

Line 967: FROM ZX_SCO_RATES_B_V -- Bug#5395227

963: taxable_basis_formula_code,
964: adj_for_adhoc_amt_code,
965: inclusive_tax_flag,
966: tax_class
967: FROM ZX_SCO_RATES_B_V -- Bug#5395227
968: WHERE tax_jurisdiction_code IS NULL
969: AND effective_from <= p_tax_date
970: AND ( effective_to >= p_tax_date OR effective_to IS NULL)
971: AND tax_rate_code = p_tax_rate_code

Line 1169: FROM ZX_SCO_RATES_B_V -- Bug#5395227

1165: taxable_basis_formula_code,
1166: adj_for_adhoc_amt_code,
1167: inclusive_tax_flag,
1168: tax_class
1169: FROM ZX_SCO_RATES_B_V -- Bug#5395227
1170: WHERE tax_status_code = p_tax_status_code
1171: AND tax = p_tax
1172: AND tax_regime_code = p_tax_regime_code
1173: AND tax_jurisdiction_code = p_tax_jurisdiction_code

Line 1207: FROM ZX_SCO_RATES_B_V -- Bug#5395227

1203: taxable_basis_formula_code,
1204: adj_for_adhoc_amt_code,
1205: inclusive_tax_flag,
1206: tax_class
1207: FROM ZX_SCO_RATES_B_V -- Bug#5395227
1208: WHERE tax_status_code = p_tax_status_code
1209: AND tax = p_tax
1210: AND tax_regime_code = p_tax_regime_code
1211: AND tax_jurisdiction_code = p_tax_jurisdiction_code

Line 1411: FROM ZX_SCO_RATES_B_V -- Bug#5395227

1407: taxable_basis_formula_code,
1408: adj_for_adhoc_amt_code,
1409: inclusive_tax_flag,
1410: tax_class
1411: FROM ZX_SCO_RATES_B_V -- Bug#5395227
1412: WHERE tax_status_code = p_tax_status_code
1413: AND tax = p_tax
1414: AND tax_regime_code = p_tax_regime_code
1415: AND tax_jurisdiction_code IS NULL

Line 1449: FROM ZX_SCO_RATES_B_V -- Bug#5395227

1445: taxable_basis_formula_code,
1446: adj_for_adhoc_amt_code,
1447: inclusive_tax_flag,
1448: tax_class
1449: FROM ZX_SCO_RATES_B_V -- Bug#5395227
1450: WHERE tax_status_code = p_tax_status_code
1451: AND tax = p_tax
1452: AND tax_regime_code = p_tax_regime_code
1453: AND tax_jurisdiction_code IS NULL