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_TYPES_TL

Line 195: | ZX_REPORTING_TYPES_TL |

191: | DESCRIPTION |
192: | This routine inserts data into following zx reporting entities based |
193: | on data in AP_TAX_CODES_ALL GDF attributes. |
194: | ZX_REPORTING_TYPES_B |
195: | ZX_REPORTING_TYPES_TL |
196: | ZX_REPORTING_CODES_B |
197: | ZX_REPORTING_CODES_TL |
198: | ZX_REPORT_TYPES_USAGES |
199: | |

Line 672: INSERT INTO ZX_REPORTING_TYPES_TL(

668: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
669: and T.LANGUAGE = L.LANGUAGE_CODE);
670:
671:
672: INSERT INTO ZX_REPORTING_TYPES_TL(
673: REPORTING_TYPE_ID ,
674: LANGUAGE ,
675: SOURCE_LANG ,
676: REPORTING_TYPE_NAME ,

Line 745: from ZX_REPORTING_TYPES_TL T

741:
742: WHERE REPORTING_TYPE_NAME is not null
743: AND not exists
744: (select NULL
745: from ZX_REPORTING_TYPES_TL T
746: where T.REPORTING_TYPE_ID = TYPES.REPORTING_TYPE_ID
747: and T.LANGUAGE = TYPES.LANGUAGE_CODE);
748:
749: --BugFix 3557652 REPORTING CODE_TL IMPL FOR ARGENTINE DGI TRANSACTION CODE

Line 4906: DELETE FROM ZX_REPORTING_TYPES_TL

4902: AND zx_rates.record_type_code = 'MIGRATED';
4903:
4904: --Need to Delete Seeded records if there is a source for reporting type to get created using 11i Migrated Regimes.
4905: IF ( l_exists_cnt > 0 ) THEN
4906: DELETE FROM ZX_REPORTING_TYPES_TL
4907: WHERE reporting_type_id IN ( SELECT reporting_type_id FROM ZX_REPORTING_TYPES_B
4908: WHERE reporting_type_code= 'ZX_ADJ_TAX_CLASSIF_CODE' AND record_type_code = 'SEEDED' );
4909:
4910: DELETE FROM ZX_REPORT_TYPES_USAGES

Line 5167: INSERT INTO ZX_REPORTING_TYPES_TL(

5163:
5164: --Creation Of Reporting Type Usages for
5165:
5166:
5167: INSERT INTO ZX_REPORTING_TYPES_TL(
5168: REPORTING_TYPE_ID ,
5169: LANGUAGE ,
5170: SOURCE_LANG ,
5171: REPORTING_TYPE_NAME ,

Line 5236: from ZX_REPORTING_TYPES_TL T

5232:
5233: WHERE REPORTING_TYPE_NAME is not null
5234: AND not exists
5235: (select NULL
5236: from ZX_REPORTING_TYPES_TL T
5237: where T.REPORTING_TYPE_ID = TYPES.REPORTING_TYPE_ID
5238: and T.LANGUAGE = TYPES.LANGUAGE_CODE);
5239:
5240: -- Creation of records in Reporting_Usages

Line 6118: -- Insert into ZX_REPORTING_TYPES_TL

6114: WHERE NOT EXISTS (select 1 from zx_reporting_types_b
6115: where reporting_type_code= p_reporting_type_code
6116: );
6117:
6118: -- Insert into ZX_REPORTING_TYPES_TL
6119:
6120: INSERT INTO ZX_REPORTING_TYPES_TL(
6121: REPORTING_TYPE_ID ,
6122: LANGUAGE ,

Line 6120: INSERT INTO ZX_REPORTING_TYPES_TL(

6116: );
6117:
6118: -- Insert into ZX_REPORTING_TYPES_TL
6119:
6120: INSERT INTO ZX_REPORTING_TYPES_TL(
6121: REPORTING_TYPE_ID ,
6122: LANGUAGE ,
6123: SOURCE_LANG ,
6124: REPORTING_TYPE_NAME ,

Line 6207: from ZX_REPORTING_TYPES_TL T

6203: ) TYPES
6204: WHERE REPORTING_TYPE_NAME is not null
6205: AND not exists
6206: (select NULL
6207: from ZX_REPORTING_TYPES_TL T
6208: where T.REPORTING_TYPE_ID = TYPES.REPORTING_TYPE_ID
6209: and T.LANGUAGE = TYPES.LANGUAGE_CODE);
6210:
6211: arp_util_tax.debug('CREATE_REPORT_TYPE_PTP(+)');

Line 7014: arp_util_tax.debug('Inserting into ZX_REPORTING_TYPES_TL table');

7010: AND zx_regimes.country_code in ('BE','CH','CZ','DE','ES','FR','HU',
7011: 'IT','KP','KR','NO','PL','PT','SK')
7012: AND zx_rates.record_type_code = 'MIGRATED';
7013:
7014: arp_util_tax.debug('Inserting into ZX_REPORTING_TYPES_TL table');
7015:
7016: INSERT INTO ZX_REPORTING_TYPES_TL(
7017: REPORTING_TYPE_ID ,
7018: LANGUAGE ,

Line 7016: INSERT INTO ZX_REPORTING_TYPES_TL(

7012: AND zx_rates.record_type_code = 'MIGRATED';
7013:
7014: arp_util_tax.debug('Inserting into ZX_REPORTING_TYPES_TL table');
7015:
7016: INSERT INTO ZX_REPORTING_TYPES_TL(
7017: REPORTING_TYPE_ID ,
7018: LANGUAGE ,
7019: SOURCE_LANG ,
7020: REPORTING_TYPE_NAME ,

Line 7052: from ZX_REPORTING_TYPES_TL T

7048: ) TYPES
7049:
7050: WHERE not exists
7051: (select NULL
7052: from ZX_REPORTING_TYPES_TL T
7053: where T.REPORTING_TYPE_ID = TYPES.REPORTING_TYPE_ID
7054: and T.LANGUAGE = TYPES.LANGUAGE_CODE);
7055:
7056: arp_util_tax.debug('CREATE_REPORTING_TYPE_EMEA(-)');

Line 7527: arp_util_tax.debug('Inserting into ZX_REPORTING_TYPES_TL table...');

7523: AND codes.tax_type = 'REVERSE_CHARGE_VAT'
7524: AND rates.record_type_code = 'MIGRATED'
7525: GROUP BY rates.tax_regime_code, rates.tax;
7526:
7527: arp_util_tax.debug('Inserting into ZX_REPORTING_TYPES_TL table...');
7528:
7529: INSERT INTO ZX_REPORTING_TYPES_TL(
7530: REPORTING_TYPE_ID ,
7531: LANGUAGE ,

Line 7529: INSERT INTO ZX_REPORTING_TYPES_TL(

7525: GROUP BY rates.tax_regime_code, rates.tax;
7526:
7527: arp_util_tax.debug('Inserting into ZX_REPORTING_TYPES_TL table...');
7528:
7529: INSERT INTO ZX_REPORTING_TYPES_TL(
7530: REPORTING_TYPE_ID ,
7531: LANGUAGE ,
7532: SOURCE_LANG ,
7533: REPORTING_TYPE_NAME ,

Line 7564: from ZX_REPORTING_TYPES_TL T

7560: AND L.INSTALLED_FLAG in ('I', 'B')
7561: ) TYPES
7562: WHERE not exists
7563: (select NULL
7564: from ZX_REPORTING_TYPES_TL T
7565: where T.REPORTING_TYPE_ID = TYPES.REPORTING_TYPE_ID
7566: and T.LANGUAGE = TYPES.LANGUAGE_CODE);
7567:
7568: arp_util_tax.debug('Inserting into ZX_REPORT_TYPES_USAGES table...');