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 926: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),

922: zxpt.tax_code tax,
923: zxpt.tax_precedence tax_precedence,
924: zxpt.regime_precedence regime_precedence,
925: DECODE(codes.global_attribute_category,
926: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),
927: DECODE(codes.tax_class,
928: 'O', 'STANDARD',
929: 'I', 'STANDARD-AR-INPUT',
930: 'STANDARD')) tax_status_code,

Line 928: 'O', 'STANDARD',

924: zxpt.regime_precedence regime_precedence,
925: DECODE(codes.global_attribute_category,
926: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),
927: DECODE(codes.tax_class,
928: 'O', 'STANDARD',
929: 'I', 'STANDARD-AR-INPUT',
930: 'STANDARD')) tax_status_code,
931: NULL recovery_type_code,
932: 'N' frozen,

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

925: DECODE(codes.global_attribute_category,
926: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),
927: DECODE(codes.tax_class,
928: 'O', 'STANDARD',
929: 'I', 'STANDARD-AR-INPUT',
930: 'STANDARD')) tax_status_code,
931: NULL recovery_type_code,
932: 'N' frozen,
933: zx_migrate_util.get_country(codes.org_id) country_code,

Line 930: 'STANDARD')) tax_status_code,

926: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),
927: DECODE(codes.tax_class,
928: 'O', 'STANDARD',
929: 'I', 'STANDARD-AR-INPUT',
930: 'STANDARD')) tax_status_code,
931: NULL recovery_type_code,
932: 'N' frozen,
933: zx_migrate_util.get_country(codes.org_id) country_code,
934: codes.start_date effective_from,

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

1004: zxpt.tax_code tax,
1005: zxpt.tax_precedence tax_precedence,
1006: zxpt.regime_precedence regime_precedence,
1007: DECODE(codes.global_attribute_category,
1008: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),
1009: DECODE(codes.tax_class,
1010: 'O', 'STANDARD',
1011: 'I', 'STANDARD-AR-INPUT',
1012: 'STANDARD')) tax_status_code,

Line 1010: 'O', 'STANDARD',

1006: zxpt.regime_precedence regime_precedence,
1007: DECODE(codes.global_attribute_category,
1008: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),
1009: DECODE(codes.tax_class,
1010: 'O', 'STANDARD',
1011: 'I', 'STANDARD-AR-INPUT',
1012: 'STANDARD')) tax_status_code,
1013: NULL recovery_type_code,
1014: 'N' frozen,

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

1007: DECODE(codes.global_attribute_category,
1008: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),
1009: DECODE(codes.tax_class,
1010: 'O', 'STANDARD',
1011: 'I', 'STANDARD-AR-INPUT',
1012: 'STANDARD')) tax_status_code,
1013: NULL recovery_type_code,
1014: 'N' frozen,
1015: zx_migrate_util.get_country(codes.org_id) country_code,

Line 1012: 'STANDARD')) tax_status_code,

1008: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(codes.global_attribute1,'STANDARD'),
1009: DECODE(codes.tax_class,
1010: 'O', 'STANDARD',
1011: 'I', 'STANDARD-AR-INPUT',
1012: 'STANDARD')) tax_status_code,
1013: NULL recovery_type_code,
1014: 'N' frozen,
1015: zx_migrate_util.get_country(codes.org_id) country_code,
1016: codes.start_date effective_from,

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

1125: ap_codes.tax_type),1,30))
1126: ) tax,
1127: DECODE(ap_codes.global_attribute_category,
1128: 'JA.TW.ARXSUVAT.VAT_TAX',
1129: nvl(ap_codes.global_attribute1,'STANDARD'),
1130: 'STANDARD') tax_status_code,
1131: 'STANDARD' recovery_type_code,
1132: 'N' frozen,
1133: zx_migrate_util.get_country(ap_codes.org_id) country_code,

Line 1130: 'STANDARD') tax_status_code,

1126: ) tax,
1127: DECODE(ap_codes.global_attribute_category,
1128: 'JA.TW.ARXSUVAT.VAT_TAX',
1129: nvl(ap_codes.global_attribute1,'STANDARD'),
1130: 'STANDARD') tax_status_code,
1131: 'STANDARD' recovery_type_code,
1132: 'N' frozen,
1133: zx_migrate_util.get_country(ap_codes.org_id) country_code,
1134: fnd_global.user_id created_by,

Line 1131: 'STANDARD' recovery_type_code,

1127: DECODE(ap_codes.global_attribute_category,
1128: 'JA.TW.ARXSUVAT.VAT_TAX',
1129: nvl(ap_codes.global_attribute1,'STANDARD'),
1130: 'STANDARD') tax_status_code,
1131: 'STANDARD' recovery_type_code,
1132: 'N' frozen,
1133: zx_migrate_util.get_country(ap_codes.org_id) country_code,
1134: fnd_global.user_id created_by,
1135: sysdate creation_date,

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

1243: RTRIM(SUBSTRB(Zx_Migrate_Util.GET_TAX(
1244: ar_codes.tax_code,
1245: ar_codes.tax_type),1,30))) tax,
1246: DECODE(ar_codes.global_attribute_category,
1247: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(ar_codes.global_attribute1,'STANDARD'),
1248: DECODE(ar_codes.tax_class,
1249: 'O', 'STANDARD',
1250: 'I', 'STANDARD-AR-INPUT',
1251: 'STANDARD')) tax_status_code,

Line 1249: 'O', 'STANDARD',

1245: ar_codes.tax_type),1,30))) tax,
1246: DECODE(ar_codes.global_attribute_category,
1247: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(ar_codes.global_attribute1,'STANDARD'),
1248: DECODE(ar_codes.tax_class,
1249: 'O', 'STANDARD',
1250: 'I', 'STANDARD-AR-INPUT',
1251: 'STANDARD')) tax_status_code,
1252: NULL recovery_type_code,
1253: 'N' frozen,

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

1246: DECODE(ar_codes.global_attribute_category,
1247: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(ar_codes.global_attribute1,'STANDARD'),
1248: DECODE(ar_codes.tax_class,
1249: 'O', 'STANDARD',
1250: 'I', 'STANDARD-AR-INPUT',
1251: 'STANDARD')) tax_status_code,
1252: NULL recovery_type_code,
1253: 'N' frozen,
1254: zx_migrate_util.get_country(decode(l_multi_org_flag,'N',l_org_id,ar_codes.org_id)) country_code,

Line 1251: 'STANDARD')) tax_status_code,

1247: 'JA.TW.ARXSUVAT.VAT_TAX', nvl(ar_codes.global_attribute1,'STANDARD'),
1248: DECODE(ar_codes.tax_class,
1249: 'O', 'STANDARD',
1250: 'I', 'STANDARD-AR-INPUT',
1251: 'STANDARD')) tax_status_code,
1252: NULL recovery_type_code,
1253: 'N' frozen,
1254: zx_migrate_util.get_country(decode(l_multi_org_flag,'N',l_org_id,ar_codes.org_id)) country_code,
1255: fnd_global.user_id created_by,

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

2658: (
2659: SELECT tax_regime_code,tax,tax_status_code,org_id ,tax_code,effective_from FROM zx_update_criteria_results WHERE tax_class = 'INPUT'
2660: INTERSECT
2661: SELECT tax_regime_code,tax,tax_status_code,org_id ,tax_code,effective_from FROM zx_update_criteria_results WHERE tax_class = 'OUTPUT'
2662: AND tax_status_code <> 'STANDARD-AR-INPUT')
2663: LOOP
2664: 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
2665: tax_status_code = cursor_rec.tax_status_code AND org_id = cursor_rec.org_id AND tax_class = 'INPUT';
2666:

Line 2664: 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

2660: INTERSECT
2661: SELECT tax_regime_code,tax,tax_status_code,org_id ,tax_code,effective_from FROM zx_update_criteria_results WHERE tax_class = 'OUTPUT'
2662: AND tax_status_code <> 'STANDARD-AR-INPUT')
2663: LOOP
2664: 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
2665: tax_status_code = cursor_rec.tax_status_code AND org_id = cursor_rec.org_id AND tax_class = 'INPUT';
2666:
2667: 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
2668: tax_status_code = cursor_rec.tax_status_code AND org_id = cursor_rec.org_id AND tax_class = 'OUTPUT';

Line 2667: 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

2663: LOOP
2664: 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
2665: tax_status_code = cursor_rec.tax_status_code AND org_id = cursor_rec.org_id AND tax_class = 'INPUT';
2666:
2667: 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
2668: tax_status_code = cursor_rec.tax_status_code AND org_id = cursor_rec.org_id AND tax_class = 'OUTPUT';
2669:
2670: END LOOP;
2671: EXCEPTION WHEN OTHERS THEN