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_COMPOUND_PKG dependencies on AR_VAT_TAX_ALL

Line 161: ar_vat_tax_all_b aa,

157: fnd_global.user_id last_updated_by,
158: sysdate last_update_date
159: FROM ar_tax_group_codes_all a,
160: ar_tax_group_codes_all b,
161: ar_vat_tax_all_b aa,
162: ar_vat_tax_all_b bb,
163: zx_tax_priorities_t rega,
164: zx_tax_priorities_t regb,
165: zx_party_tax_profile ptp,

Line 162: ar_vat_tax_all_b bb,

158: sysdate last_update_date
159: FROM ar_tax_group_codes_all a,
160: ar_tax_group_codes_all b,
161: ar_vat_tax_all_b aa,
162: ar_vat_tax_all_b bb,
163: zx_tax_priorities_t rega,
164: zx_tax_priorities_t regb,
165: zx_party_tax_profile ptp,
166: ar_vat_tax_all_b grp

Line 166: ar_vat_tax_all_b grp

162: ar_vat_tax_all_b bb,
163: zx_tax_priorities_t rega,
164: zx_tax_priorities_t regb,
165: zx_party_tax_profile ptp,
166: ar_vat_tax_all_b grp
167: WHERE decode(l_multi_org_flag,'N',l_org_id,a.org_id) = decode(l_multi_org_flag,'N',l_org_id,b.org_id)
168: AND decode(l_multi_org_flag,'N',l_org_id,a.org_id) = decode(l_multi_org_flag,'N',l_org_id,aa.org_id)
169: AND decode(l_multi_org_flag,'N',l_org_id,b.org_id) = decode(l_multi_org_flag,'N',l_org_id,bb.org_id)
170: AND a.tax_group_id=b.tax_group_id

Line 209: FROM ar_vat_tax_all grp,

205: error_number,
206: error_message)
207: SELECT tax_group_id, grp.tax_code group_code,
208: ROWNUM, 'Conflicting priority group '
209: FROM ar_vat_tax_all grp,
210: (SELECT min(a.tax_group_id) tax_group_id
211: FROM zx_tax_relations_t a
212: , zx_tax_relations_t b
213: WHERE a.org_id = b.org_id

Line 280: FROM ar_vat_tax_all_b ) temp_regime;

276: fnd_global.user_id last_updated_by,
277: sysdate last_update_date
278: FROM
279: (SELECT UNIQUE DECODE(l_multi_org_flag,'N',l_org_id,org_id) org_id , tax_type
280: FROM ar_vat_tax_all_b ) temp_regime;
281:
282: END load_regime_list;
283:
284:

Line 331: ar_vat_tax_all_b aa,

327: aa.tax_type tax_type,
328: 'Y' group_flag,
329: decode(l_multi_org_flag,'N',l_org_id,aa.org_id) org_id
330: FROM ar_tax_group_codes_all a,
331: ar_vat_tax_all_b aa,
332: zx_tax_priorities_t reg
333: WHERE aa.vat_tax_id = a.tax_code_id
334: AND aa.tax_type = reg.tax_type
335: AND decode(l_multi_org_flag,'N',l_org_id,aa.org_id) = reg.org_id

Line 355: ar_vat_tax_all_b aa,

351: aa.tax_type tax_type,
352: 'N' group_flag,
353: decode(l_multi_org_flag,'N',l_org_id,aa.org_id) org_id
354: FROM ar_tax_group_codes_all a,
355: ar_vat_tax_all_b aa,
356: zx_tax_priorities_t reg
357: WHERE aa.vat_tax_id = a.tax_code_id
358: AND a.compounding_precedence IS NULL
359: AND aa.tax_type = reg.tax_type