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_TAX_RELATIONS_T

Line 18: l_content_owner_id zx_tax_relations_t.content_owner_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;
21: l_parent_tax_code zx_tax_relations_t.parent_tax_code %TYPE;
22: l_parent_precedence zx_tax_relations_t.parent_precedence%TYPE;

Line 19: l_group_id zx_tax_relations_t.tax_group_id%TYPE;

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;
21: l_parent_tax_code zx_tax_relations_t.parent_tax_code %TYPE;
22: l_parent_precedence zx_tax_relations_t.parent_precedence%TYPE;
23: l_parent_regime_code zx_tax_relations_t.parent_regime_code %TYPE;

Line 20: l_tax_group_code zx_tax_relations_t.tax_group_code%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;
21: l_parent_tax_code zx_tax_relations_t.parent_tax_code %TYPE;
22: l_parent_precedence zx_tax_relations_t.parent_precedence%TYPE;
23: l_parent_regime_code zx_tax_relations_t.parent_regime_code %TYPE;
24: l_child_tax_code zx_tax_relations_t.child_tax_code %TYPE;

Line 21: l_parent_tax_code zx_tax_relations_t.parent_tax_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;
21: l_parent_tax_code zx_tax_relations_t.parent_tax_code %TYPE;
22: l_parent_precedence zx_tax_relations_t.parent_precedence%TYPE;
23: l_parent_regime_code zx_tax_relations_t.parent_regime_code %TYPE;
24: l_child_tax_code zx_tax_relations_t.child_tax_code %TYPE;
25: l_child_precedence zx_tax_relations_t.child_precedence%TYPE;

Line 22: l_parent_precedence zx_tax_relations_t.parent_precedence%TYPE;

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;
21: l_parent_tax_code zx_tax_relations_t.parent_tax_code %TYPE;
22: l_parent_precedence zx_tax_relations_t.parent_precedence%TYPE;
23: l_parent_regime_code zx_tax_relations_t.parent_regime_code %TYPE;
24: l_child_tax_code zx_tax_relations_t.child_tax_code %TYPE;
25: l_child_precedence zx_tax_relations_t.child_precedence%TYPE;
26: l_child_regime_code zx_tax_relations_t.child_regime_code %TYPE;

Line 23: l_parent_regime_code zx_tax_relations_t.parent_regime_code %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;
21: l_parent_tax_code zx_tax_relations_t.parent_tax_code %TYPE;
22: l_parent_precedence zx_tax_relations_t.parent_precedence%TYPE;
23: l_parent_regime_code zx_tax_relations_t.parent_regime_code %TYPE;
24: l_child_tax_code zx_tax_relations_t.child_tax_code %TYPE;
25: l_child_precedence zx_tax_relations_t.child_precedence%TYPE;
26: l_child_regime_code zx_tax_relations_t.child_regime_code %TYPE;
27: l_branch zx_tax_relations_t.branch_flag%TYPE;

Line 24: l_child_tax_code zx_tax_relations_t.child_tax_code %TYPE;

20: l_tax_group_code zx_tax_relations_t.tax_group_code%TYPE;
21: l_parent_tax_code zx_tax_relations_t.parent_tax_code %TYPE;
22: l_parent_precedence zx_tax_relations_t.parent_precedence%TYPE;
23: l_parent_regime_code zx_tax_relations_t.parent_regime_code %TYPE;
24: l_child_tax_code zx_tax_relations_t.child_tax_code %TYPE;
25: l_child_precedence zx_tax_relations_t.child_precedence%TYPE;
26: l_child_regime_code zx_tax_relations_t.child_regime_code %TYPE;
27: l_branch zx_tax_relations_t.branch_flag%TYPE;
28:

Line 25: l_child_precedence zx_tax_relations_t.child_precedence%TYPE;

21: l_parent_tax_code zx_tax_relations_t.parent_tax_code %TYPE;
22: l_parent_precedence zx_tax_relations_t.parent_precedence%TYPE;
23: l_parent_regime_code zx_tax_relations_t.parent_regime_code %TYPE;
24: l_child_tax_code zx_tax_relations_t.child_tax_code %TYPE;
25: l_child_precedence zx_tax_relations_t.child_precedence%TYPE;
26: l_child_regime_code zx_tax_relations_t.child_regime_code %TYPE;
27: l_branch zx_tax_relations_t.branch_flag%TYPE;
28:
29: l_tax_condition_id ar_tax_group_codes_all.tax_condition_id%TYPE;

Line 26: l_child_regime_code zx_tax_relations_t.child_regime_code %TYPE;

22: l_parent_precedence zx_tax_relations_t.parent_precedence%TYPE;
23: l_parent_regime_code zx_tax_relations_t.parent_regime_code %TYPE;
24: l_child_tax_code zx_tax_relations_t.child_tax_code %TYPE;
25: l_child_precedence zx_tax_relations_t.child_precedence%TYPE;
26: l_child_regime_code zx_tax_relations_t.child_regime_code %TYPE;
27: l_branch zx_tax_relations_t.branch_flag%TYPE;
28:
29: l_tax_condition_id ar_tax_group_codes_all.tax_condition_id%TYPE;
30: l_tax_exception_id ar_tax_group_codes_all.tax_exception_id%TYPE;

Line 27: l_branch zx_tax_relations_t.branch_flag%TYPE;

23: l_parent_regime_code zx_tax_relations_t.parent_regime_code %TYPE;
24: l_child_tax_code zx_tax_relations_t.child_tax_code %TYPE;
25: l_child_precedence zx_tax_relations_t.child_precedence%TYPE;
26: l_child_regime_code zx_tax_relations_t.child_regime_code %TYPE;
27: l_branch zx_tax_relations_t.branch_flag%TYPE;
28:
29: l_tax_condition_id ar_tax_group_codes_all.tax_condition_id%TYPE;
30: l_tax_exception_id ar_tax_group_codes_all.tax_exception_id%TYPE;
31: l_tax_group_id ar_tax_group_codes_all.tax_group_id%TYPE;

Line 41: g_group_id zx_tax_relations_t.tax_group_id%TYPE;

37: l_charge_flag CHAR;
38:
39: l_alphanumeric_result zx_process_results.alphanumeric_result%TYPE;
40:
41: g_group_id zx_tax_relations_t.tax_group_id%TYPE;
42: g_child_tax_code zx_tax_relations_t.child_tax_code%TYPE;
43: g_child_regime_code zx_tax_relations_t.child_regime_code%TYPE;
44:
45: l_condition_grp_id zx_condition_groups_b.condition_group_id%TYPE;

Line 42: g_child_tax_code zx_tax_relations_t.child_tax_code%TYPE;

38:
39: l_alphanumeric_result zx_process_results.alphanumeric_result%TYPE;
40:
41: g_group_id zx_tax_relations_t.tax_group_id%TYPE;
42: g_child_tax_code zx_tax_relations_t.child_tax_code%TYPE;
43: g_child_regime_code zx_tax_relations_t.child_regime_code%TYPE;
44:
45: l_condition_grp_id zx_condition_groups_b.condition_group_id%TYPE;
46: l_condition_grp_cd zx_condition_groups_b.condition_group_code%TYPE;

Line 43: g_child_regime_code zx_tax_relations_t.child_regime_code%TYPE;

39: l_alphanumeric_result zx_process_results.alphanumeric_result%TYPE;
40:
41: g_group_id zx_tax_relations_t.tax_group_id%TYPE;
42: g_child_tax_code zx_tax_relations_t.child_tax_code%TYPE;
43: g_child_regime_code zx_tax_relations_t.child_regime_code%TYPE;
44:
45: l_condition_grp_id zx_condition_groups_b.condition_group_id%TYPE;
46: l_condition_grp_cd zx_condition_groups_b.condition_group_code%TYPE;
47:

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 97: FROM zx_tax_relations_t

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
100: AND grp.tax_group_id = tax_rel_upg.tax_group_id
101: AND grp.tax_code_id = decode(grp.tax_group_type

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 138: FROM zx_tax_relations_t

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
141: AND grp.tax_group_id = tax_rel_upg.tax_group_id
142: AND grp.tax_code_id = decode(grp.tax_group_type

Line 166: FROM zx_tax_relations_t

162: Child_regime_code ,
163: Child_Taxable_basis ,
164: branch ,
165: content_owner_id
166: FROM zx_tax_relations_t
167: -- START WITH Parent_Regime_code IS NULL --* changed crsr
168: CONNECT BY PRIOR child_tax_code = parent_Tax_code
169: ORDER BY group_id, child_tax_code, child_precedence DESC;
170: */

Line 738: p_child_regime_code IN zx_tax_relations_t.child_regime_code %TYPE,

734: PROCEDURE CREATE_FORMULA
735: (--for zx_formula_b
736: p_taxable_basis IN ar_vat_tax_all.taxable_basis%TYPE,
737: p_formula_code IN zx_formula_b.formula_code%TYPE,
738: p_child_regime_code IN zx_tax_relations_t.child_regime_code %TYPE,
739: p_child_tax_code IN zx_tax_relations_t.child_tax_code %TYPE,
740: p_enabled_flag IN ar_vat_tax_all.enabled_flag%TYPE,
741: p_discount_flag IN CHAR,
742: p_charge_flag IN CHAR,

Line 739: p_child_tax_code IN zx_tax_relations_t.child_tax_code %TYPE,

735: (--for zx_formula_b
736: p_taxable_basis IN ar_vat_tax_all.taxable_basis%TYPE,
737: p_formula_code IN zx_formula_b.formula_code%TYPE,
738: p_child_regime_code IN zx_tax_relations_t.child_regime_code %TYPE,
739: p_child_tax_code IN zx_tax_relations_t.child_tax_code %TYPE,
740: p_enabled_flag IN ar_vat_tax_all.enabled_flag%TYPE,
741: p_discount_flag IN CHAR,
742: p_charge_flag IN CHAR,
743: -- for zx_formula_details

Line 744: p_parent_regime_code IN zx_tax_relations_t.parent_regime_code %TYPE,

740: p_enabled_flag IN ar_vat_tax_all.enabled_flag%TYPE,
741: p_discount_flag IN CHAR,
742: p_charge_flag IN CHAR,
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,

Line 745: p_parent_tax_code IN zx_tax_relations_t.parent_tax_code %TYPE,

741: p_discount_flag IN CHAR,
742: p_charge_flag IN CHAR,
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,

Line 746: p_group_id IN zx_tax_relations_t.tax_group_id%TYPE, --(used in where condition)

742: p_charge_flag IN CHAR,
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,

Line 948: FROM zx_tax_relations_t t

944: fnd_global.prog_appl_id, --Program Application ID
945: fnd_global.conc_program_id, --Program Id
946: fnd_global.conc_login_id, --Program Login ID
947: 1
948: FROM zx_tax_relations_t t
949: WHERE t.child_regime_code = p_child_regime_code
950: AND t.child_tax_code = p_child_tax_code
951: AND t.tax_group_id = p_group_id
952: AND NOT EXISTS (SELECT 1

Line 1008: FROM zx_tax_relations_t t

1004: fnd_global.prog_appl_id, --Program Application ID
1005: fnd_global.conc_program_id, --Program Id
1006: fnd_global.conc_login_id, --Program Login ID
1007: 1
1008: FROM zx_tax_relations_t t
1009: WHERE t.child_regime_code = p_child_regime_code
1010: AND t.child_tax_code = p_child_tax_code
1011: AND t.tax_group_id = p_group_id
1012: AND NOT EXISTS (SELECT 1