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_AR_FORMULA_MIG_PKG dependencies on ZX_RATES_B

Line 15: l_tax zx_rates_b.tax%TYPE;

11: l_start_date ar_vat_tax_all.start_date%TYPE;
12: l_end_date ar_vat_tax_all.end_date%TYPE;
13: l_tax_constraint_id ar_vat_tax_all.tax_constraint_id%TYPE;
14:
15: l_tax zx_rates_b.tax%TYPE;
16: l_tax_regime_code zx_rates_b.tax_regime_code%TYPE;
17:
18: l_content_owner_id zx_tax_relations_t.content_owner_id%TYPE;
19: l_group_id zx_tax_relations_t.tax_group_id%TYPE;

Line 16: l_tax_regime_code zx_rates_b.tax_regime_code%TYPE;

12: l_end_date ar_vat_tax_all.end_date%TYPE;
13: l_tax_constraint_id ar_vat_tax_all.tax_constraint_id%TYPE;
14:
15: l_tax zx_rates_b.tax%TYPE;
16: l_tax_regime_code zx_rates_b.tax_regime_code%TYPE;
17:
18: l_content_owner_id zx_tax_relations_t.content_owner_id%TYPE;
19: l_group_id zx_tax_relations_t.tax_group_id%TYPE;
20: l_tax_group_code zx_tax_relations_t.tax_group_code%TYPE;

Line 63: FROM ar_vat_tax_all vat, zx_rates_b rate

59: vat.end_date,
60: rate.tax,
61: rate.tax_regime_code,
62: rate.content_owner_id
63: FROM ar_vat_tax_all vat, zx_rates_b rate
64: WHERE vat.taxable_basis IN ('AFTER_EPD', 'QUANTITY')
65: AND vat.tax_class = 'O'
66: AND vat.global_attribute_category is null
67: AND vat.tax_type <> 'TAX_GROUP'

Line 94: FROM zx_tax_relations_t tax_rel_upg, ar_tax_group_codes_all grp, zx_rates_b zx_rate,

90: grp.tax_exception_id,
91: grp.tax_group_id,
92: zx_rate.tax_regime_code,
93: zx_rate.tax
94: FROM zx_tax_relations_t tax_rel_upg, ar_tax_group_codes_all grp, zx_rates_b zx_rate,
95: zx_rates_b zx_par_rate -- 8726049
96: WHERE tax_rel_upg.tax_group_id NOT IN (SELECT tax_group_id
97: FROM zx_tax_relations_t
98: WHERE TRUNC(child_precedence) <> child_precedence )

Line 95: zx_rates_b zx_par_rate -- 8726049

91: grp.tax_group_id,
92: zx_rate.tax_regime_code,
93: zx_rate.tax
94: FROM zx_tax_relations_t tax_rel_upg, ar_tax_group_codes_all grp, zx_rates_b zx_rate,
95: zx_rates_b zx_par_rate -- 8726049
96: WHERE tax_rel_upg.tax_group_id NOT IN (SELECT tax_group_id
97: FROM zx_tax_relations_t
98: WHERE TRUNC(child_precedence) <> child_precedence )
99: AND grp.compounding_precedence is not null

Line 135: FROM zx_tax_relations_t tax_rel_upg, ar_tax_group_codes_all grp, zx_rates_b zx_rate,

131: grp.tax_exception_id,
132: grp.tax_group_id,
133: zx_rate.tax_regime_code,
134: zx_rate.tax
135: FROM zx_tax_relations_t tax_rel_upg, ar_tax_group_codes_all grp, zx_rates_b zx_rate,
136: zx_rates_b zx_par_rate -- 8726049
137: WHERE tax_rel_upg.tax_group_id IN (SELECT tax_group_id
138: FROM zx_tax_relations_t
139: WHERE child_precedence > TRUNC(child_precedence) )

Line 136: zx_rates_b zx_par_rate -- 8726049

132: grp.tax_group_id,
133: zx_rate.tax_regime_code,
134: zx_rate.tax
135: FROM zx_tax_relations_t tax_rel_upg, ar_tax_group_codes_all grp, zx_rates_b zx_rate,
136: zx_rates_b zx_par_rate -- 8726049
137: WHERE tax_rel_upg.tax_group_id IN (SELECT tax_group_id
138: FROM zx_tax_relations_t
139: WHERE child_precedence > TRUNC(child_precedence) )
140: AND grp.compounding_precedence is not null

Line 747: p_content_owner_id IN zx_rates_b.content_owner_id%TYPE,

743: -- for zx_formula_details
744: p_parent_regime_code IN zx_tax_relations_t.parent_regime_code %TYPE,
745: p_parent_tax_code IN zx_tax_relations_t.parent_tax_code %TYPE,
746: p_group_id IN zx_tax_relations_t.tax_group_id%TYPE, --(used in where condition)
747: p_content_owner_id IN zx_rates_b.content_owner_id%TYPE,
748: p_start_date IN ar_vat_tax_all.start_date%TYPE,
749: p_end_date IN ar_vat_tax_all.end_date%TYPE,
750: p_tax_regime_code IN zx_rates_b.tax_regime_code %TYPE,
751: p_tax_code IN zx_rates_b.tax %TYPE,

Line 750: p_tax_regime_code IN zx_rates_b.tax_regime_code %TYPE,

746: p_group_id IN zx_tax_relations_t.tax_group_id%TYPE, --(used in where condition)
747: p_content_owner_id IN zx_rates_b.content_owner_id%TYPE,
748: p_start_date IN ar_vat_tax_all.start_date%TYPE,
749: p_end_date IN ar_vat_tax_all.end_date%TYPE,
750: p_tax_regime_code IN zx_rates_b.tax_regime_code %TYPE,
751: p_tax_code IN zx_rates_b.tax %TYPE,
752: x_return_status OUT NOCOPY VARCHAR2) IS
753:
754: l_formula_id zx_formula_b.formula_id%TYPE;

Line 751: p_tax_code IN zx_rates_b.tax %TYPE,

747: p_content_owner_id IN zx_rates_b.content_owner_id%TYPE,
748: p_start_date IN ar_vat_tax_all.start_date%TYPE,
749: p_end_date IN ar_vat_tax_all.end_date%TYPE,
750: p_tax_regime_code IN zx_rates_b.tax_regime_code %TYPE,
751: p_tax_code IN zx_rates_b.tax %TYPE,
752: x_return_status OUT NOCOPY VARCHAR2) IS
753:
754: l_formula_id zx_formula_b.formula_id%TYPE;
755:

Line 1041: p_tax IN zx_rates_b.tax%TYPE,

1037: *****************************************************************************************/
1038:
1039: PROCEDURE CREATE_RULES
1040: ( --parameters rqrd for zx_rules_b
1041: p_tax IN zx_rates_b.tax%TYPE,
1042: p_tax_regime_code IN zx_rates_b.tax_regime_code%TYPE,
1043: p_effective_from IN ar_vat_tax_all.start_date%TYPE,
1044: p_effective_to IN ar_vat_tax_all.end_date%TYPE,
1045: p_enabled_flag IN ar_tax_group_codes.enabled_flag%TYPE,

Line 1042: p_tax_regime_code IN zx_rates_b.tax_regime_code%TYPE,

1038:
1039: PROCEDURE CREATE_RULES
1040: ( --parameters rqrd for zx_rules_b
1041: p_tax IN zx_rates_b.tax%TYPE,
1042: p_tax_regime_code IN zx_rates_b.tax_regime_code%TYPE,
1043: p_effective_from IN ar_vat_tax_all.start_date%TYPE,
1044: p_effective_to IN ar_vat_tax_all.end_date%TYPE,
1045: p_enabled_flag IN ar_tax_group_codes.enabled_flag%TYPE,
1046: p_content_owner_id IN zx_rates_b.content_owner_id%TYPE, -- for zx_process_results

Line 1046: p_content_owner_id IN zx_rates_b.content_owner_id%TYPE, -- for zx_process_results

1042: p_tax_regime_code IN zx_rates_b.tax_regime_code%TYPE,
1043: p_effective_from IN ar_vat_tax_all.start_date%TYPE,
1044: p_effective_to IN ar_vat_tax_all.end_date%TYPE,
1045: p_enabled_flag IN ar_tax_group_codes.enabled_flag%TYPE,
1046: p_content_owner_id IN zx_rates_b.content_owner_id%TYPE, -- for zx_process_results
1047: p_condition_grp_cd IN fnd_lookups.lookup_code%TYPE,
1048: p_alphanumeric_result IN zx_process_results.alphanumeric_result%TYPE,
1049: p_condition_group_id IN zx_condition_groups_b.condition_group_id%TYPE,
1050: p_tax_condition_id IN ar_tax_group_codes_all.tax_condition_id%TYPE,