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_REP_ENTITIES_PKG dependencies on ZX_REPORTING_CODES_TL

Line 212: | ZX_REPORTING_CODES_TL |

208: | on data in AP_TAX_CODES_ALL GDF attributes. |
209: | ZX_REPORTING_TYPES_B |
210: | ZX_REPORTING_TYPES_TL |
211: | ZX_REPORTING_CODES_B |
212: | ZX_REPORTING_CODES_TL |
213: | ZX_REPORT_TYPES_USAGES |
214: | |
215: | SCOPE - PUBLIC |
216: | |

Line 637: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');

633: REPORTING_CODE_CHAR_VALUE=lookups.LOOKUP_CODE
634: )
635: );
636:
637: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');
638:
639: INSERT INTO ZX_REPORTING_CODES_TL(
640: REPORTING_CODE_ID ,
641: LANGUAGE ,

Line 639: INSERT INTO ZX_REPORTING_CODES_TL(

635: );
636:
637: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');
638:
639: INSERT INTO ZX_REPORTING_CODES_TL(
640: REPORTING_CODE_ID ,
641: LANGUAGE ,
642: SOURCE_LANG ,
643: REPORTING_CODE_NAME ,

Line 682: from ZX_REPORTING_CODES_TL T

678: AND lookups.LANGUAGE = L.LANGUAGE_CODE(+)
679: AND L.INSTALLED_FLAG in ('I', 'B')
680: AND not exists
681: (select NULL
682: from ZX_REPORTING_CODES_TL T
683: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
684: and T.LANGUAGE = L.LANGUAGE_CODE);
685:
686:

Line 767: INSERT INTO ZX_REPORTING_CODES_TL(

763:
764: --BugFix 3557652 REPORTING CODE_TL IMPL FOR ARGENTINE DGI TRANSACTION CODE
765: --Bug# 4952838. Moved this logic to common procedure CREATE_REPORTING_CODES
766: /*
767: INSERT INTO ZX_REPORTING_CODES_TL(
768: REPORTING_CODE_ID ,
769: LANGUAGE ,
770: SOURCE_LANG ,
771: REPORTING_CODE_NAME ,

Line 806: from ZX_REPORTING_CODES_TL T

802: AND lookups.LANGUAGE = L.LANGUAGE_CODE(+)
803: AND L.INSTALLED_FLAG in ('I', 'B')
804: AND not exists
805: (select NULL
806: from ZX_REPORTING_CODES_TL T
807: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
808: and T.LANGUAGE = L.LANGUAGE_CODE);
809: */
810:

Line 811: INSERT INTO ZX_REPORTING_CODES_TL(

807: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
808: and T.LANGUAGE = L.LANGUAGE_CODE);
809: */
810:
811: INSERT INTO ZX_REPORTING_CODES_TL(
812: REPORTING_CODE_ID ,
813: LANGUAGE ,
814: SOURCE_LANG ,
815: REPORTING_CODE_NAME ,

Line 854: from ZX_REPORTING_CODES_TL T

850: CODES.RECORD_TYPE_CODE = 'MIGRATED'
851: AND L.INSTALLED_FLAG in ('I', 'B')
852: AND not exists
853: (select NULL
854: from ZX_REPORTING_CODES_TL T
855: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
856: and T.LANGUAGE = L.LANGUAGE_CODE);
857:
858:

Line 1129: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');

1125: REPORTING_CODE_CHAR_VALUE=lookups.LOOKUP_CODE
1126: )
1127: );
1128:
1129: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');
1130:
1131: INSERT INTO ZX_REPORTING_CODES_TL(
1132: REPORTING_CODE_ID ,
1133: LANGUAGE ,

Line 1131: INSERT INTO ZX_REPORTING_CODES_TL(

1127: );
1128:
1129: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');
1130:
1131: INSERT INTO ZX_REPORTING_CODES_TL(
1132: REPORTING_CODE_ID ,
1133: LANGUAGE ,
1134: SOURCE_LANG ,
1135: REPORTING_CODE_NAME ,

Line 1174: from ZX_REPORTING_CODES_TL T

1170: AND lookups.LANGUAGE = L.LANGUAGE_CODE(+)
1171: AND L.INSTALLED_FLAG in ('I', 'B')
1172: AND not exists
1173: (select NULL
1174: from ZX_REPORTING_CODES_TL T
1175: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
1176: and T.LANGUAGE = L.LANGUAGE_CODE);
1177:
1178:

Line 4715: --The creation of zx_reporting_types_b , zx_reporting_codes_b and zx_reporting_codes_tl has been put together for

4711: zx_rates.tax_regime_code;
4712: --Bug 4705196
4713: /*
4714: --Bug 4422813
4715: --The creation of zx_reporting_types_b , zx_reporting_codes_b and zx_reporting_codes_tl has been put together for
4716: --easy understanding
4717:
4718: INSERT ALL
4719: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

Line 4871: ZX_REPORTING_CODES_TL

4867:
4868:
4869: INSERT ALL
4870: INTO
4871: ZX_REPORTING_CODES_TL
4872: (
4873: REPORTING_CODE_ID ,
4874: LANGUAGE ,
4875: SOURCE_LANG ,

Line 4909: (select 1 from zx_reporting_codes_tl where reporting_code_id = l_seqid

4905: ar_vat_tax_all_tl avtl
4906: where avtl.vat_tax_id = cursor_rec.vat_tax_id
4907: and avtl.printed_tax_name is not null
4908: and not exists
4909: (select 1 from zx_reporting_codes_tl where reporting_code_id = l_seqid
4910: and language = avtl.language);
4911: END LOOP;
4912:
4913:

Line 5385: INSERT INTO ZX_REPORTING_CODES_TL (

5381:
5382: --Bug Fix 4930895 Populate FND_LOOKUPS.MEANING INTO REPORTING_CODE_NAME
5383: -- Moved this logic to common procedure CREATE_REPORTING_CODES
5384: /*
5385: INSERT INTO ZX_REPORTING_CODES_TL (
5386: REPORTING_CODE_ID ,
5387: LANGUAGE ,
5388: SOURCE_LANG ,
5389: REPORTING_CODE_NAME ,

Line 5423: from ZX_REPORTING_CODES_TL T

5419: AND lookups.LANGUAGE = L.LANGUAGE_CODE(+)
5420: AND L.INSTALLED_FLAG in ('I', 'B')
5421: AND not exists
5422: (select NULL
5423: from ZX_REPORTING_CODES_TL T
5424: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
5425: and T.LANGUAGE = L.LANGUAGE_CODE);
5426: */
5427:

Line 5433: INSERT INTO ZX_REPORTING_CODES_TL (

5429:
5430: --Bug Fix 4930895 Populate FND_LOOKUPS.MEANING INTO REPORTING_CODE_NAME
5431: -- Moved this logic to common procedure CREATE_REPORTING_CODES
5432: /*
5433: INSERT INTO ZX_REPORTING_CODES_TL (
5434: REPORTING_CODE_ID ,
5435: LANGUAGE ,
5436: SOURCE_LANG ,
5437: REPORTING_CODE_NAME ,

Line 5471: from ZX_REPORTING_CODES_TL T

5467: AND lookups.LANGUAGE = L.LANGUAGE_CODE(+)
5468: AND L.INSTALLED_FLAG in ('I', 'B')
5469: AND not exists
5470: (select NULL
5471: from ZX_REPORTING_CODES_TL T
5472: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
5473: and T.LANGUAGE = L.LANGUAGE_CODE);
5474: */
5475:

Line 5547: INSERT INTO ZX_REPORTING_CODES_TL(

5543: )
5544:
5545: ); --YK:9/22/2004: Synch is taken care by checking NOT EXISTS.
5546: /* Bug 5031787
5547: INSERT INTO ZX_REPORTING_CODES_TL(
5548: REPORTING_CODE_ID ,
5549: LANGUAGE ,
5550: SOURCE_LANG ,
5551: REPORTING_CODE_NAME ,

Line 5585: from ZX_REPORTING_CODES_TL T

5581: AND lookups.LANGUAGE = L.LANGUAGE_CODE(+)
5582: AND L.INSTALLED_FLAG in ('I', 'B')
5583: AND not exists
5584: (select NULL
5585: from ZX_REPORTING_CODES_TL T
5586: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
5587: and T.LANGUAGE = L.LANGUAGE_CODE);
5588: */
5589: -- End of Korean GDF

Line 6341: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');

6337: REPORTING_CODE_CHAR_VALUE=lookups.LOOKUP_CODE
6338: )
6339: );
6340:
6341: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');
6342:
6343: INSERT INTO ZX_REPORTING_CODES_TL(
6344: REPORTING_CODE_ID ,
6345: LANGUAGE ,

Line 6343: INSERT INTO ZX_REPORTING_CODES_TL(

6339: );
6340:
6341: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');
6342:
6343: INSERT INTO ZX_REPORTING_CODES_TL(
6344: REPORTING_CODE_ID ,
6345: LANGUAGE ,
6346: SOURCE_LANG ,
6347: REPORTING_CODE_NAME ,

Line 6386: from ZX_REPORTING_CODES_TL T

6382: AND lookups.LANGUAGE = L.LANGUAGE_CODE(+)
6383: AND L.INSTALLED_FLAG in ('I', 'B')
6384: AND not exists
6385: (select NULL
6386: from ZX_REPORTING_CODES_TL T
6387: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
6388: and T.LANGUAGE = L.LANGUAGE_CODE);
6389:
6390:

Line 6599: INSERT INTO ZX_REPORTING_CODES_TL(

6595: );
6596: END LOOP ;
6597:
6598: --Create Reporting Codes TL for PT_LOCATION
6599: INSERT INTO ZX_REPORTING_CODES_TL(
6600: REPORTING_CODE_ID ,
6601: LANGUAGE ,
6602: SOURCE_LANG ,
6603: REPORTING_CODE_NAME ,

Line 6643: from ZX_REPORTING_CODES_TL T

6639: WHERE REPORTING_TYPE_CODE = 'PT_LOCATION' AND record_type_code = 'SEEDED' )
6640: AND L.INSTALLED_FLAG in ('I', 'B')
6641: AND not exists
6642: (select NULL
6643: from ZX_REPORTING_CODES_TL T
6644: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
6645: and T.LANGUAGE = L.LANGUAGE_CODE);
6646: END IF ;
6647:

Line 6761: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');

6757: REPORTING_CODE_CHAR_VALUE=lookups.LOOKUP_CODE
6758: )
6759: );
6760:
6761: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');
6762:
6763: INSERT INTO ZX_REPORTING_CODES_TL(
6764: REPORTING_CODE_ID ,
6765: LANGUAGE ,

Line 6763: INSERT INTO ZX_REPORTING_CODES_TL(

6759: );
6760:
6761: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');
6762:
6763: INSERT INTO ZX_REPORTING_CODES_TL(
6764: REPORTING_CODE_ID ,
6765: LANGUAGE ,
6766: SOURCE_LANG ,
6767: REPORTING_CODE_NAME ,

Line 6806: from ZX_REPORTING_CODES_TL T

6802: AND lookups.LANGUAGE = L.LANGUAGE_CODE(+)
6803: AND L.INSTALLED_FLAG in ('I', 'B')
6804: AND not exists
6805: (select NULL
6806: from ZX_REPORTING_CODES_TL T
6807: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
6808: and T.LANGUAGE = L.LANGUAGE_CODE);
6809:
6810: END IF ;

Line 7244: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');

7240: UPPER(lookups.lookup_code))
7241: )
7242: );
7243:
7244: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');
7245:
7246: INSERT INTO ZX_REPORTING_CODES_TL(
7247: REPORTING_CODE_ID ,
7248: LANGUAGE ,

Line 7246: INSERT INTO ZX_REPORTING_CODES_TL(

7242: );
7243:
7244: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');
7245:
7246: INSERT INTO ZX_REPORTING_CODES_TL(
7247: REPORTING_CODE_ID ,
7248: LANGUAGE ,
7249: SOURCE_LANG ,
7250: REPORTING_CODE_NAME ,

Line 7295: from ZX_REPORTING_CODES_TL T

7291: AND lookups.LANGUAGE = L.LANGUAGE_CODE(+)
7292: AND L.INSTALLED_FLAG in ('I', 'B')
7293: AND not exists
7294: (select NULL
7295: from ZX_REPORTING_CODES_TL T
7296: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
7297: and T.LANGUAGE = L.LANGUAGE_CODE);
7298:
7299: arp_util_tax.debug('CREATE_REPORTING_CODES_EMEA(-)');

Line 7700: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table...');

7696: AND REPORTING_CODE_CHAR_VALUE = UPPER(lookups.lookup_code)
7697: )
7698: );
7699:
7700: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table...');
7701:
7702: INSERT INTO ZX_REPORTING_CODES_TL(
7703: REPORTING_CODE_ID ,
7704: LANGUAGE ,

Line 7702: INSERT INTO ZX_REPORTING_CODES_TL(

7698: );
7699:
7700: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table...');
7701:
7702: INSERT INTO ZX_REPORTING_CODES_TL(
7703: REPORTING_CODE_ID ,
7704: LANGUAGE ,
7705: SOURCE_LANG ,
7706: REPORTING_CODE_NAME ,

Line 7745: from ZX_REPORTING_CODES_TL T

7741: AND lookups.LANGUAGE = L.LANGUAGE_CODE(+)
7742: AND L.INSTALLED_FLAG in ('I', 'B')
7743: AND not exists
7744: (select NULL
7745: from ZX_REPORTING_CODES_TL T
7746: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
7747: and T.LANGUAGE = L.LANGUAGE_CODE);
7748:
7749: arp_util_tax.debug('Inserting into ZX_REPORT_CODES_ASSOC table...');

Line 8174: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');

8170: AND REPORTING_CODE_CHAR_VALUE = UPPER(lookups.lookup_code)
8171: )
8172: );
8173:
8174: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');
8175:
8176: INSERT
8177: INTO ZX_REPORTING_CODES_TL
8178: (

Line 8177: INTO ZX_REPORTING_CODES_TL

8173:
8174: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');
8175:
8176: INSERT
8177: INTO ZX_REPORTING_CODES_TL
8178: (
8179: REPORTING_CODE_ID ,
8180: LANGUAGE ,
8181: SOURCE_LANG ,

Line 8221: FROM ZX_REPORTING_CODES_TL T

8217: AND L.INSTALLED_FLAG IN ('I',
8218: 'B')
8219: AND NOT EXISTS
8220: (SELECT NULL
8221: FROM ZX_REPORTING_CODES_TL T
8222: WHERE T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
8223: AND T.LANGUAGE = L.LANGUAGE_CODE
8224: );
8225: arp_util_tax.debug('CREATE_REPORTING_CODES_EUVAT(-)');