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_MIGRATE_TAX_DEF_COMMON dependencies on STANDARD

Line 101: nvl(codes.global_attribute1,'STANDARD'),

97: END
98: ) tax,
99: DECODE(codes.global_attribute_category,
100: 'JA.TW.APXTADTC.TAX_CODES',
101: nvl(codes.global_attribute1,'STANDARD'),
102: 'STANDARD') tax_status_code,
103: NULL recovery_type_code, --Bug Fix 5028009
104: 'N' frozen,
105: zx_migrate_util.get_country(codes.org_id) country_code,

Line 102: 'STANDARD') tax_status_code,

98: ) tax,
99: DECODE(codes.global_attribute_category,
100: 'JA.TW.APXTADTC.TAX_CODES',
101: nvl(codes.global_attribute1,'STANDARD'),
102: 'STANDARD') tax_status_code,
103: NULL recovery_type_code, --Bug Fix 5028009
104: 'N' frozen,
105: zx_migrate_util.get_country(codes.org_id) country_code,
106: codes.start_date effective_from,

Line 207: nvl(codes.global_attribute1,'STANDARD'),

203: END
204: ) tax,
205: DECODE(codes.global_attribute_category,
206: 'JA.TW.APXTADTC.TAX_CODES',
207: nvl(codes.global_attribute1,'STANDARD'),
208: 'STANDARD') tax_status_code,
209: NULL recovery_type_code, --Bug Fix 5028009
210: 'N' frozen,
211: zx_migrate_util.get_country(codes.org_id) country_code,

Line 208: 'STANDARD') tax_status_code,

204: ) tax,
205: DECODE(codes.global_attribute_category,
206: 'JA.TW.APXTADTC.TAX_CODES',
207: nvl(codes.global_attribute1,'STANDARD'),
208: 'STANDARD') tax_status_code,
209: NULL recovery_type_code, --Bug Fix 5028009
210: 'N' frozen,
211: zx_migrate_util.get_country(codes.org_id) country_code,
212: codes.start_date effective_from,

Line 312: nvl(offset.global_attribute1,'STANDARD'),

308: ||'-OFFST'
309: END )tax,
310: DECODE(offset.global_attribute_category,
311: 'JA.TW.APXTADTC.TAX_CODES',
312: nvl(offset.global_attribute1,'STANDARD'),
313: 'STANDARD') tax_status_code,
314: NULL recovery_type_code, --Bug Fix 5028009
315: 'N' frozen,
316: zx_migrate_util.get_country(offset.org_id) country_code,

Line 313: 'STANDARD') tax_status_code,

309: END )tax,
310: DECODE(offset.global_attribute_category,
311: 'JA.TW.APXTADTC.TAX_CODES',
312: nvl(offset.global_attribute1,'STANDARD'),
313: 'STANDARD') tax_status_code,
314: NULL recovery_type_code, --Bug Fix 5028009
315: 'N' frozen,
316: zx_migrate_util.get_country(offset.org_id) country_code,
317: offset.start_date effective_from,

Line 416: nvl(offset.global_attribute1,'STANDARD'),

412: ||'-OFFST'
413: END ) tax,
414: DECODE(offset.global_attribute_category,
415: 'JA.TW.APXTADTC.TAX_CODES',
416: nvl(offset.global_attribute1,'STANDARD'),
417: 'STANDARD') tax_status_code,
418: NULL recovery_type_code, --Bug Fix 5028009
419: 'N' frozen,
420: zx_migrate_util.get_country(offset.org_id) country_code,

Line 417: 'STANDARD') tax_status_code,

413: END ) tax,
414: DECODE(offset.global_attribute_category,
415: 'JA.TW.APXTADTC.TAX_CODES',
416: nvl(offset.global_attribute1,'STANDARD'),
417: 'STANDARD') tax_status_code,
418: NULL recovery_type_code, --Bug Fix 5028009
419: 'N' frozen,
420: zx_migrate_util.get_country(offset.org_id) country_code,
421: offset.start_date effective_from,

Line 494: nvl(offset.global_attribute1,'STANDARD'),

490: offset.tax_type),1,24))
491: ) ||'-OFFST' tax,
492: DECODE(offset.global_attribute_category,
493: 'JA.TW.APXTADTC.TAX_CODES',
494: nvl(offset.global_attribute1,'STANDARD'),
495: 'STANDARD') tax_status_code,
496: NULL recovery_type_code, --Bug Fix 5028009
497: 'N' frozen,
498: zx_migrate_util.get_country(offset.org_id) country_code,

Line 495: 'STANDARD') tax_status_code,

491: ) ||'-OFFST' tax,
492: DECODE(offset.global_attribute_category,
493: 'JA.TW.APXTADTC.TAX_CODES',
494: nvl(offset.global_attribute1,'STANDARD'),
495: 'STANDARD') tax_status_code,
496: NULL recovery_type_code, --Bug Fix 5028009
497: 'N' frozen,
498: zx_migrate_util.get_country(offset.org_id) country_code,
499: offset.start_date effective_from,

Line 564: nvl(offset.global_attribute1,'STANDARD'),

560: offset.tax_type),1,24))
561: ) ||'-OFFST' tax,
562: DECODE(offset.global_attribute_category,
563: 'JA.TW.APXTADTC.TAX_CODES',
564: nvl(offset.global_attribute1,'STANDARD'),
565: 'STANDARD') tax_status_code,
566: NULL recovery_type_code, --Bug Fix 5028009
567: 'N' frozen,
568: zx_migrate_util.get_country(offset.org_id) country_code,

Line 565: 'STANDARD') tax_status_code,

561: ) ||'-OFFST' tax,
562: DECODE(offset.global_attribute_category,
563: 'JA.TW.APXTADTC.TAX_CODES',
564: nvl(offset.global_attribute1,'STANDARD'),
565: 'STANDARD') tax_status_code,
566: NULL recovery_type_code, --Bug Fix 5028009
567: 'N' frozen,
568: zx_migrate_util.get_country(offset.org_id) country_code,
569: offset.start_date effective_from,

Line 684: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),

680: END
681:
682: ) tax,
683: DECODE(codes.global_attribute_category,
684: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),
685: DECODE(codes.tax_class,
686: 'O', 'STANDARD',
687: 'I', 'STANDARD-AR-INPUT',
688: 'STANDARD')) tax_status_code,

Line 686: 'O', 'STANDARD',

682: ) tax,
683: DECODE(codes.global_attribute_category,
684: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),
685: DECODE(codes.tax_class,
686: 'O', 'STANDARD',
687: 'I', 'STANDARD-AR-INPUT',
688: 'STANDARD')) tax_status_code,
689: NULL recovery_type_code,
690: 'N' frozen,

Line 687: 'I', 'STANDARD-AR-INPUT',

683: DECODE(codes.global_attribute_category,
684: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),
685: DECODE(codes.tax_class,
686: 'O', 'STANDARD',
687: 'I', 'STANDARD-AR-INPUT',
688: 'STANDARD')) tax_status_code,
689: NULL recovery_type_code,
690: 'N' frozen,
691: zx_migrate_util.get_country(codes.org_id) country_code,

Line 688: 'STANDARD')) tax_status_code,

684: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),
685: DECODE(codes.tax_class,
686: 'O', 'STANDARD',
687: 'I', 'STANDARD-AR-INPUT',
688: 'STANDARD')) tax_status_code,
689: NULL recovery_type_code,
690: 'N' frozen,
691: zx_migrate_util.get_country(codes.org_id) country_code,
692: codes.start_date effective_from,

Line 806: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),

802: END
803:
804: END) tax,
805: DECODE(codes.global_attribute_category,
806: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),
807: DECODE(codes.tax_class,
808: 'O', 'STANDARD',
809: 'I', 'STANDARD-AR-INPUT',
810: 'STANDARD')) tax_status_code,

Line 808: 'O', 'STANDARD',

804: END) tax,
805: DECODE(codes.global_attribute_category,
806: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),
807: DECODE(codes.tax_class,
808: 'O', 'STANDARD',
809: 'I', 'STANDARD-AR-INPUT',
810: 'STANDARD')) tax_status_code,
811: NULL recovery_type_code,
812: 'N' frozen,

Line 809: 'I', 'STANDARD-AR-INPUT',

805: DECODE(codes.global_attribute_category,
806: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),
807: DECODE(codes.tax_class,
808: 'O', 'STANDARD',
809: 'I', 'STANDARD-AR-INPUT',
810: 'STANDARD')) tax_status_code,
811: NULL recovery_type_code,
812: 'N' frozen,
813: zx_migrate_util.get_country(codes.org_id) country_code,

Line 810: 'STANDARD')) tax_status_code,

806: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),
807: DECODE(codes.tax_class,
808: 'O', 'STANDARD',
809: 'I', 'STANDARD-AR-INPUT',
810: 'STANDARD')) tax_status_code,
811: NULL recovery_type_code,
812: 'N' frozen,
813: zx_migrate_util.get_country(codes.org_id) country_code,
814: codes.start_date effective_from,

Line 966: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),

962: --zxpt.tax_code tax,
963: zxpt.tax_precedence tax_precedence,
964: zxpt.regime_precedence regime_precedence,
965: DECODE(codes.global_attribute_category,
966: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),
967: DECODE(codes.tax_class,
968: 'O', 'STANDARD',
969: 'I', 'STANDARD-AR-INPUT',
970: 'STANDARD')) tax_status_code,

Line 968: 'O', 'STANDARD',

964: zxpt.regime_precedence regime_precedence,
965: DECODE(codes.global_attribute_category,
966: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),
967: DECODE(codes.tax_class,
968: 'O', 'STANDARD',
969: 'I', 'STANDARD-AR-INPUT',
970: 'STANDARD')) tax_status_code,
971: NULL recovery_type_code,
972: 'N' frozen,

Line 969: 'I', 'STANDARD-AR-INPUT',

965: DECODE(codes.global_attribute_category,
966: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),
967: DECODE(codes.tax_class,
968: 'O', 'STANDARD',
969: 'I', 'STANDARD-AR-INPUT',
970: 'STANDARD')) tax_status_code,
971: NULL recovery_type_code,
972: 'N' frozen,
973: zx_migrate_util.get_country(codes.org_id) country_code,

Line 970: 'STANDARD')) tax_status_code,

966: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),
967: DECODE(codes.tax_class,
968: 'O', 'STANDARD',
969: 'I', 'STANDARD-AR-INPUT',
970: 'STANDARD')) tax_status_code,
971: NULL recovery_type_code,
972: 'N' frozen,
973: zx_migrate_util.get_country(codes.org_id) country_code,
974: codes.start_date effective_from,

Line 1085: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),

1081: --zxpt.tax_code tax,
1082: zxpt.tax_precedence tax_precedence,
1083: zxpt.regime_precedence regime_precedence,
1084: DECODE(codes.global_attribute_category,
1085: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),
1086: DECODE(codes.tax_class,
1087: 'O', 'STANDARD',
1088: 'I', 'STANDARD-AR-INPUT',
1089: 'STANDARD')) tax_status_code,

Line 1087: 'O', 'STANDARD',

1083: zxpt.regime_precedence regime_precedence,
1084: DECODE(codes.global_attribute_category,
1085: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),
1086: DECODE(codes.tax_class,
1087: 'O', 'STANDARD',
1088: 'I', 'STANDARD-AR-INPUT',
1089: 'STANDARD')) tax_status_code,
1090: NULL recovery_type_code,
1091: 'N' frozen,

Line 1088: 'I', 'STANDARD-AR-INPUT',

1084: DECODE(codes.global_attribute_category,
1085: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),
1086: DECODE(codes.tax_class,
1087: 'O', 'STANDARD',
1088: 'I', 'STANDARD-AR-INPUT',
1089: 'STANDARD')) tax_status_code,
1090: NULL recovery_type_code,
1091: 'N' frozen,
1092: zx_migrate_util.get_country(codes.org_id) country_code,

Line 1089: 'STANDARD')) tax_status_code,

1085: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),
1086: DECODE(codes.tax_class,
1087: 'O', 'STANDARD',
1088: 'I', 'STANDARD-AR-INPUT',
1089: 'STANDARD')) tax_status_code,
1090: NULL recovery_type_code,
1091: 'N' frozen,
1092: zx_migrate_util.get_country(codes.org_id) country_code,
1093: codes.start_date effective_from,

Line 1206: nvl(ap_codes.global_attribute1,'STANDARD'),

1202: ap_codes.tax_type),1,30))
1203: ) tax,
1204: DECODE(ap_codes.global_attribute_category,
1205: 'JA.TW.ARXSUVAT.VAT_TAX',
1206: nvl(ap_codes.global_attribute1,'STANDARD'),
1207: 'STANDARD') tax_status_code,
1208: 'STANDARD' recovery_type_code,
1209: 'N' frozen,
1210: zx_migrate_util.get_country(ap_codes.org_id) country_code,

Line 1207: 'STANDARD') tax_status_code,

1203: ) tax,
1204: DECODE(ap_codes.global_attribute_category,
1205: 'JA.TW.ARXSUVAT.VAT_TAX',
1206: nvl(ap_codes.global_attribute1,'STANDARD'),
1207: 'STANDARD') tax_status_code,
1208: 'STANDARD' recovery_type_code,
1209: 'N' frozen,
1210: zx_migrate_util.get_country(ap_codes.org_id) country_code,
1211: fnd_global.user_id created_by,

Line 1208: 'STANDARD' recovery_type_code,

1204: DECODE(ap_codes.global_attribute_category,
1205: 'JA.TW.ARXSUVAT.VAT_TAX',
1206: nvl(ap_codes.global_attribute1,'STANDARD'),
1207: 'STANDARD') tax_status_code,
1208: 'STANDARD' recovery_type_code,
1209: 'N' frozen,
1210: zx_migrate_util.get_country(ap_codes.org_id) country_code,
1211: fnd_global.user_id created_by,
1212: sysdate creation_date,

Line 1324: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(ar_codes.global_attribute1,'STANDARD'),

1320: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(
1321: ar_codes.tax_code,
1322: ar_codes.tax_type),1,30))) tax,
1323: DECODE(ar_codes.global_attribute_category,
1324: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(ar_codes.global_attribute1,'STANDARD'),
1325: DECODE(ar_codes.tax_class,
1326: 'O', 'STANDARD',
1327: 'I', 'STANDARD-AR-INPUT',
1328: 'STANDARD')) tax_status_code,

Line 1326: 'O', 'STANDARD',

1322: ar_codes.tax_type),1,30))) tax,
1323: DECODE(ar_codes.global_attribute_category,
1324: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(ar_codes.global_attribute1,'STANDARD'),
1325: DECODE(ar_codes.tax_class,
1326: 'O', 'STANDARD',
1327: 'I', 'STANDARD-AR-INPUT',
1328: 'STANDARD')) tax_status_code,
1329: NULL recovery_type_code,
1330: 'N' frozen,

Line 1327: 'I', 'STANDARD-AR-INPUT',

1323: DECODE(ar_codes.global_attribute_category,
1324: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(ar_codes.global_attribute1,'STANDARD'),
1325: DECODE(ar_codes.tax_class,
1326: 'O', 'STANDARD',
1327: 'I', 'STANDARD-AR-INPUT',
1328: 'STANDARD')) tax_status_code,
1329: NULL recovery_type_code,
1330: 'N' frozen,
1331: zx_migrate_util.get_country(decode(l_multi_org_flag,'N',l_org_id,ar_codes.org_id)) country_code,

Line 1328: 'STANDARD')) tax_status_code,

1324: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(ar_codes.global_attribute1,'STANDARD'),
1325: DECODE(ar_codes.tax_class,
1326: 'O', 'STANDARD',
1327: 'I', 'STANDARD-AR-INPUT',
1328: 'STANDARD')) tax_status_code,
1329: NULL recovery_type_code,
1330: 'N' frozen,
1331: zx_migrate_util.get_country(decode(l_multi_org_flag,'N',l_org_id,ar_codes.org_id)) country_code,
1332: fnd_global.user_id created_by,

Line 2739: AND tax_status_code <> 'STANDARD-AR-INPUT')

2735: (
2736: SELECT tax_regime_code,tax,tax_status_code,org_id ,tax_code,effective_from FROM zx_update_criteria_results WHERE tax_class = 'INPUT'
2737: INTERSECT
2738: SELECT tax_regime_code,tax,tax_status_code,org_id ,tax_code,effective_from FROM zx_update_criteria_results WHERE tax_class = 'OUTPUT'
2739: AND tax_status_code <> 'STANDARD-AR-INPUT')
2740: LOOP
2741: UPDATE zx_update_criteria_results SET tax_status_code = 'STANDARD-INPUT' WHERE tax_regime_code = cursor_rec.tax_regime_code AND tax = cursor_rec.tax AND
2742: tax_status_code = cursor_rec.tax_status_code AND org_id = cursor_rec.org_id AND tax_class = 'INPUT';
2743:

Line 2741: UPDATE zx_update_criteria_results SET tax_status_code = 'STANDARD-INPUT' WHERE tax_regime_code = cursor_rec.tax_regime_code AND tax = cursor_rec.tax AND

2737: INTERSECT
2738: SELECT tax_regime_code,tax,tax_status_code,org_id ,tax_code,effective_from FROM zx_update_criteria_results WHERE tax_class = 'OUTPUT'
2739: AND tax_status_code <> 'STANDARD-AR-INPUT')
2740: LOOP
2741: UPDATE zx_update_criteria_results SET tax_status_code = 'STANDARD-INPUT' WHERE tax_regime_code = cursor_rec.tax_regime_code AND tax = cursor_rec.tax AND
2742: tax_status_code = cursor_rec.tax_status_code AND org_id = cursor_rec.org_id AND tax_class = 'INPUT';
2743:
2744: UPDATE zx_update_criteria_results SET tax_status_code = 'STANDARD-OUTPUT' WHERE tax_regime_code = cursor_rec.tax_regime_code AND tax = cursor_rec.tax AND
2745: tax_status_code = cursor_rec.tax_status_code AND org_id = cursor_rec.org_id AND tax_class = 'OUTPUT';

Line 2744: UPDATE zx_update_criteria_results SET tax_status_code = 'STANDARD-OUTPUT' WHERE tax_regime_code = cursor_rec.tax_regime_code AND tax = cursor_rec.tax AND

2740: LOOP
2741: UPDATE zx_update_criteria_results SET tax_status_code = 'STANDARD-INPUT' WHERE tax_regime_code = cursor_rec.tax_regime_code AND tax = cursor_rec.tax AND
2742: tax_status_code = cursor_rec.tax_status_code AND org_id = cursor_rec.org_id AND tax_class = 'INPUT';
2743:
2744: UPDATE zx_update_criteria_results SET tax_status_code = 'STANDARD-OUTPUT' WHERE tax_regime_code = cursor_rec.tax_regime_code AND tax = cursor_rec.tax AND
2745: tax_status_code = cursor_rec.tax_status_code AND org_id = cursor_rec.org_id AND tax_class = 'OUTPUT';
2746:
2747: END LOOP;
2748: EXCEPTION WHEN OTHERS THEN