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_REPORT_TYPES_USAGES

Line 213: | ZX_REPORT_TYPES_USAGES |

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: | |
217: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 442: INSERT INTO ZX_REPORT_TYPES_USAGES(

438: CREATE_REPORT_TYPE_PTP('JE - REG NUMBER', 'TEXT', 'N');
439: CREATE_REPORT_TYPE_PTP('AR-SYSTEM-PARAM-REG-NUM', 'TEXT', 'N');
440: CREATE_REPORT_TYPE_PTP('FSO-REG-NUM', 'TEXT', 'N');
441:
442: INSERT INTO ZX_REPORT_TYPES_USAGES(
443: REPORTING_TYPE_USAGE_ID ,
444: ENTITY_CODE ,
445: ENABLED_FLAG ,
446: CREATED_BY ,

Line 454: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

450: LAST_UPDATE_LOGIN ,
451: REPORTING_TYPE_ID ,
452: OBJECT_VERSION_NUMBER
453: )
454: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
455: LOOKUP_CODE ,--ENTITY_CODE
456: decode(LOOKUP_CODE,
457: 'ZX_PARTY_TAX_PROFILE',
458: 'Y',

Line 476: AND NOT EXISTS ( select 1 from zx_report_types_usages

472: WHERE
473: reporting_type_code = 'FISCAL PRINTER'
474: AND LOOKUP_TYPE= 'ZX_REPORTING_TABLE_USE'
475:
476: AND NOT EXISTS ( select 1 from zx_report_types_usages
477: where reporting_type_id = rep_type.reporting_type_id and
478: entity_code = fnd_lookups.lookup_code );
479:
480:

Line 481: INSERT INTO ZX_REPORT_TYPES_USAGES(

477: where reporting_type_id = rep_type.reporting_type_id and
478: entity_code = fnd_lookups.lookup_code );
479:
480:
481: INSERT INTO ZX_REPORT_TYPES_USAGES(
482: REPORTING_TYPE_USAGE_ID ,
483: ENTITY_CODE ,
484: ENABLED_FLAG ,
485: CREATED_BY ,

Line 493: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

489: LAST_UPDATE_LOGIN ,
490: REPORTING_TYPE_ID ,
491: OBJECT_VERSION_NUMBER
492: )
493: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
494: LOOKUP_CODE ,--ENTITY_CODE
495: decode(LOOKUP_CODE,
496: 'ZX_PARTY_TAX_PROFILE',
497: 'Y',

Line 514: AND NOT EXISTS ( select 1 from zx_report_types_usages

510: WHERE
511: reporting_type_code = 'CAI NUMBER'
512: AND LOOKUP_TYPE= 'ZX_REPORTING_TABLE_USE'
513:
514: AND NOT EXISTS ( select 1 from zx_report_types_usages
515: where reporting_type_id = rep_type.reporting_type_id and
516: entity_code = fnd_lookups.lookup_code );
517:
518: --BugFix 3604885

Line 519: INSERT INTO ZX_REPORT_TYPES_USAGES(

515: where reporting_type_id = rep_type.reporting_type_id and
516: entity_code = fnd_lookups.lookup_code );
517:
518: --BugFix 3604885
519: INSERT INTO ZX_REPORT_TYPES_USAGES(
520: REPORTING_TYPE_USAGE_ID,
521: REPORTING_TYPE_ID ,
522: ENTITY_CODE ,
523: ENABLED_FLAG ,

Line 532: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

528: LAST_UPDATE_LOGIN ,
529: OBJECT_VERSION_NUMBER
530: )
531: SELECT
532: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
533: types.reporting_type_id ,--REPORTING_TYPE_ID
534: lookups.lookup_code ,--ENTITY_CODE
535: DECODE(lookups.lookup_code,
536: 'ZX_RATES','Y', --Bug 5528045

Line 561: AND NOT EXISTS ( select 1 from zx_report_types_usages

557: AND types.record_type_code = 'MIGRATED'
558:
559: AND lookups.LOOKUP_TYPE = 'ZX_REPORTING_TABLE_USE'
560:
561: AND NOT EXISTS ( select 1 from zx_report_types_usages
562: where reporting_type_id = types.reporting_type_id
563: and entity_code = lookups.lookup_code );
564:
565:

Line 4937: DELETE FROM ZX_REPORT_TYPES_USAGES

4933: DELETE FROM ZX_REPORTING_TYPES_TL
4934: WHERE reporting_type_id IN ( SELECT reporting_type_id FROM ZX_REPORTING_TYPES_B
4935: WHERE reporting_type_code= 'ZX_ADJ_TAX_CLASSIF_CODE' AND record_type_code = 'SEEDED' );
4936:
4937: DELETE FROM ZX_REPORT_TYPES_USAGES
4938: WHERE reporting_type_id IN ( SELECT reporting_type_id FROM ZX_REPORTING_TYPES_B
4939: WHERE reporting_type_code= 'ZX_ADJ_TAX_CLASSIF_CODE' AND record_type_code = 'SEEDED' );
4940:
4941: DELETE FROM ZX_REPORTING_TYPES_B WHERE reporting_type_code= 'ZX_ADJ_TAX_CLASSIF_CODE' AND record_type_code = 'SEEDED';

Line 5155: INSERT INTO ZX_REPORT_TYPES_USAGES(

5151:
5152: --Bug Fix 4466085
5153: --Creation of Reporting Types Usages for Reporting Type ZX_ADJ_TAX_CLASSIF_CODE
5154:
5155: INSERT INTO ZX_REPORT_TYPES_USAGES(
5156: REPORTING_TYPE_USAGE_ID ,
5157: ENTITY_CODE ,
5158: ENABLED_FLAG ,
5159: CREATED_BY ,

Line 5167: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

5163: LAST_UPDATE_LOGIN ,
5164: REPORTING_TYPE_ID ,
5165: OBJECT_VERSION_NUMBER
5166: )
5167: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
5168: lookups.lookup_code , --ENTITY_CODE --Bug 5528045
5169: DECODE(lookups.lookup_code,
5170: 'ZX_RATES','Y',
5171: 'N') ,--ENABLED_FLAG --Bug 5528045

Line 5186: AND NOT EXISTS ( select 1 from zx_report_types_usages

5182: WHERE
5183: reporting_type_code = 'ZX_ADJ_TAX_CLASSIF_CODE'
5184: AND record_type_code = 'MIGRATED'
5185: AND lookup_type = 'ZX_REPORTING_TABLE_USE'
5186: AND NOT EXISTS ( select 1 from zx_report_types_usages
5187: where reporting_type_id = rep_type.reporting_type_id
5188: and entity_code = lookups.lookup_code );
5189:
5190:

Line 5270: INSERT INTO ZX_REPORT_TYPES_USAGES(

5266: where T.REPORTING_TYPE_ID = TYPES.REPORTING_TYPE_ID
5267: and T.LANGUAGE = TYPES.LANGUAGE_CODE);
5268:
5269: -- Creation of records in Reporting_Usages
5270: INSERT INTO ZX_REPORT_TYPES_USAGES(
5271: REPORTING_TYPE_USAGE_ID,
5272: REPORTING_TYPE_ID ,
5273: ENTITY_CODE ,
5274: ENABLED_FLAG ,

Line 5283: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

5279: LAST_UPDATE_LOGIN ,
5280: OBJECT_VERSION_NUMBER
5281: )
5282: SELECT
5283: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
5284: types.reporting_type_id ,--REPORTING_TYPE_ID
5285: lookups.lookup_code ,--ENTITY_CODE
5286: DECODE(lookups.lookup_code,
5287: 'ZX_RATES','Y', --Bug 5528045

Line 5309: AND NOT EXISTS ( select 1 from zx_report_types_usages

5305: 'KR_LOCATION' --YK:9/22/2004: Korean GDF
5306: )
5307: AND lookups.LOOKUP_TYPE = 'ZX_REPORTING_TABLE_USE'
5308: AND types.record_type_code = 'MIGRATED'
5309: AND NOT EXISTS ( select 1 from zx_report_types_usages
5310: where reporting_type_id = types.reporting_type_id
5311: and entity_code = lookups.lookup_code );
5312:
5313: -- Call the common procedure to create the reporting codes

Line 5824: INSERT INTO ZX_REPORT_TYPES_USAGES(

5820: -- Bug Fix 4671652
5821: -- Creation of reporting types usages for KR_BUSINESS_LOCATIONS
5822:
5823:
5824: INSERT INTO ZX_REPORT_TYPES_USAGES(
5825: REPORTING_TYPE_USAGE_ID ,
5826: ENTITY_CODE ,
5827: ENABLED_FLAG ,
5828: CREATED_BY ,

Line 5836: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

5832: LAST_UPDATE_LOGIN ,
5833: REPORTING_TYPE_ID ,
5834: OBJECT_VERSION_NUMBER
5835: )
5836: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
5837: 'ZX_RATES_B' ,--ENTITY_CODE
5838: 'Y' ,--ENABLED_FLAG
5839: fnd_global.user_id ,--CREATED_BY
5840: SYSDATE ,--CREATION_DATE

Line 5852: AND NOT EXISTS ( select 1 from zx_report_types_usages

5848: zx_reporting_types_b rep_type
5849:
5850: WHERE
5851: reporting_type_code = 'KR_BUSINESS_LOCATIONS'
5852: AND NOT EXISTS ( select 1 from zx_report_types_usages
5853: where reporting_type_id = rep_type.reporting_type_id and
5854: entity_code = 'ZX_RATES_B' );
5855: */
5856:

Line 6423: INSERT INTO ZX_REPORT_TYPES_USAGES(

6419:
6420: PROCEDURE CREATE_REPORTTYPE_USAGES_SEED IS
6421:
6422: BEGIN
6423: INSERT INTO ZX_REPORT_TYPES_USAGES(
6424: REPORTING_TYPE_USAGE_ID ,
6425: ENTITY_CODE ,
6426: ENABLED_FLAG ,
6427: CREATED_BY ,

Line 6435: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

6431: LAST_UPDATE_LOGIN ,
6432: REPORTING_TYPE_ID ,
6433: OBJECT_VERSION_NUMBER
6434: )
6435: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
6436: 'ZX_RATES' ,--ENTITY_CODE --Bug 5528484
6437: 'Y' ,--ENABLED_FLAG
6438: 120 ,--CREATED_BY
6439: SYSDATE ,--CREATION_DATE

Line 6456: AND NOT EXISTS ( select 1 from zx_report_types_usages

6452: 'PRINT TAX LINE','AR_MUNICIPAL_JUR','AR_TURN_OVER_JUR_CODE',
6453: 'CL_TAX_CODE_CLASSIF','CL_BILLS_OF_EXCH_TAX','KR_LOCATION'
6454: )
6455: AND record_type_code = 'SEEDED'
6456: AND NOT EXISTS ( select 1 from zx_report_types_usages
6457: where reporting_type_id = rep_type.reporting_type_id and
6458: entity_code = 'ZX_RATES' );
6459:
6460:

Line 6461: INSERT INTO ZX_REPORT_TYPES_USAGES(

6457: where reporting_type_id = rep_type.reporting_type_id and
6458: entity_code = 'ZX_RATES' );
6459:
6460:
6461: INSERT INTO ZX_REPORT_TYPES_USAGES(
6462: REPORTING_TYPE_USAGE_ID ,
6463: ENTITY_CODE ,
6464: ENABLED_FLAG ,
6465: CREATED_BY ,

Line 6473: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

6469: LAST_UPDATE_LOGIN ,
6470: REPORTING_TYPE_ID ,
6471: OBJECT_VERSION_NUMBER
6472: )
6473: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
6474: 'ZX_PARTY_TAX_PROFILE' ,--ENTITY_CODE
6475: 'Y' ,--ENABLED_FLAG
6476: 120 ,--CREATED_BY
6477: SYSDATE ,--CREATION_DATE

Line 6488: AND NOT EXISTS ( select 1 from zx_report_types_usages

6484: zx_reporting_types_b rep_type
6485: WHERE
6486: reporting_type_code IN ('FISCAL PRINTER','CAI NUMBER')
6487: AND record_type_code = 'SEEDED'
6488: AND NOT EXISTS ( select 1 from zx_report_types_usages
6489: where reporting_type_id = rep_type.reporting_type_id and
6490: entity_code = 'ZX_PARTY_TAX_PROFILE' );
6491:
6492: END CREATE_REPORTTYPE_USAGES_SEED;

Line 6859: INSERT INTO ZX_REPORT_TYPES_USAGES(

6855:
6856: PROCEDURE CREATE_REPORT_TYPES_USAGES
6857: IS
6858: BEGIN
6859: INSERT INTO ZX_REPORT_TYPES_USAGES(
6860: REPORTING_TYPE_USAGE_ID ,
6861: REPORTING_TYPE_ID ,
6862: ENTITY_CODE ,
6863: ENABLED_FLAG ,

Line 6872: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

6868: LAST_UPDATE_LOGIN ,
6869: OBJECT_VERSION_NUMBER
6870: )
6871: SELECT
6872: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
6873: types.reporting_type_id ,--REPORTING_TYPE_ID
6874: lookups.lookup_code ,--ENTITY_CODE
6875: DECODE(lookups.lookup_code,
6876: 'ZX_RATES','Y',

Line 6900: AND NOT EXISTS ( select 1 from zx_report_types_usages

6896: AND types.record_type_code = 'MIGRATED'
6897:
6898: AND lookups.LOOKUP_TYPE = 'ZX_REPORTING_TABLE_USE'
6899:
6900: AND NOT EXISTS ( select 1 from zx_report_types_usages
6901: where reporting_type_id = types.reporting_type_id
6902: and entity_code = lookups.lookup_code );
6903:
6904: INSERT INTO ZX_REPORT_TYPES_USAGES(

Line 6904: INSERT INTO ZX_REPORT_TYPES_USAGES(

6900: AND NOT EXISTS ( select 1 from zx_report_types_usages
6901: where reporting_type_id = types.reporting_type_id
6902: and entity_code = lookups.lookup_code );
6903:
6904: INSERT INTO ZX_REPORT_TYPES_USAGES(
6905: REPORTING_TYPE_USAGE_ID ,
6906: REPORTING_TYPE_ID,
6907: ENTITY_CODE ,
6908: ENABLED_FLAG ,

Line 6917: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

6913: LAST_UPDATE_LOGIN ,
6914: OBJECT_VERSION_NUMBER
6915: )
6916: SELECT
6917: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
6918: types.reporting_type_id ,--REPORTING_TYPE_ID
6919: lookups.lookup_code ,--ENTITY_CODE
6920: DECODE(lookups.lookup_code,
6921: 'ZX_PARTY_TAX_PROFILE','Y',

Line 6945: AND NOT EXISTS ( select 1 from zx_report_types_usages

6941: AND types.record_type_code = 'MIGRATED'
6942:
6943: AND lookups.LOOKUP_TYPE = 'ZX_REPORTING_TABLE_USE'
6944:
6945: AND NOT EXISTS ( select 1 from zx_report_types_usages
6946: where reporting_type_id = types.reporting_type_id
6947: and entity_code = lookups.lookup_code );
6948:
6949:

Line 7108: INSERT INTO ZX_REPORT_TYPES_USAGES(

7104: IS
7105: BEGIN
7106: arp_util_tax.debug('CREATE_REPORT_TYP_USAGES_EMEA(+)');
7107:
7108: INSERT INTO ZX_REPORT_TYPES_USAGES(
7109: REPORTING_TYPE_USAGE_ID,
7110: REPORTING_TYPE_ID ,
7111: ENTITY_CODE ,
7112: ENABLED_FLAG ,

Line 7121: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

7117: LAST_UPDATE_LOGIN ,
7118: OBJECT_VERSION_NUMBER
7119: )
7120: SELECT
7121: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
7122: types.reporting_type_id ,--REPORTING_TYPE_ID
7123: 'ZX_RATES' ,--ENTITY_CODE
7124: 'Y' ,--ENABLED_FLAG
7125: fnd_global.user_id ,--CREATED_BY

Line 7135: AND NOT EXISTS ( select 1 from zx_report_types_usages

7131: FROM
7132: zx_reporting_types_b types
7133: WHERE types.reporting_type_code IN('EMEA_VAT_REPORTING_TYPE')
7134: --AND types.record_type_code = 'MIGRATED'
7135: AND NOT EXISTS ( select 1 from zx_report_types_usages
7136: where reporting_type_id = types.reporting_type_id
7137: and entity_code = 'ZX_RATES');
7138:
7139: arp_util_tax.debug('CREATE_REPORT_TYP_USAGES_EMEA(-)');

Line 7598: arp_util_tax.debug('Inserting into ZX_REPORT_TYPES_USAGES table...');

7594: from ZX_REPORTING_TYPES_TL T
7595: where T.REPORTING_TYPE_ID = TYPES.REPORTING_TYPE_ID
7596: and T.LANGUAGE = TYPES.LANGUAGE_CODE);
7597:
7598: arp_util_tax.debug('Inserting into ZX_REPORT_TYPES_USAGES table...');
7599:
7600: INSERT INTO ZX_REPORT_TYPES_USAGES(
7601: REPORTING_TYPE_USAGE_ID,
7602: REPORTING_TYPE_ID ,

Line 7600: INSERT INTO ZX_REPORT_TYPES_USAGES(

7596: and T.LANGUAGE = TYPES.LANGUAGE_CODE);
7597:
7598: arp_util_tax.debug('Inserting into ZX_REPORT_TYPES_USAGES table...');
7599:
7600: INSERT INTO ZX_REPORT_TYPES_USAGES(
7601: REPORTING_TYPE_USAGE_ID,
7602: REPORTING_TYPE_ID ,
7603: ENTITY_CODE ,
7604: ENABLED_FLAG ,

Line 7613: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

7609: LAST_UPDATE_LOGIN ,
7610: OBJECT_VERSION_NUMBER
7611: )
7612: SELECT
7613: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
7614: types.reporting_type_id ,--REPORTING_TYPE_ID
7615: 'ZX_RATES' ,--ENTITY_CODE
7616: 'Y' ,--ENABLED_FLAG
7617: fnd_global.user_id ,--CREATED_BY

Line 7627: AND NOT EXISTS ( select 1 from zx_report_types_usages

7623: FROM
7624: zx_reporting_types_b types
7625: WHERE types.reporting_type_code = 'REVERSE_CHARGE_VAT'
7626: --AND types.record_type_code = 'MIGRATED'
7627: AND NOT EXISTS ( select 1 from zx_report_types_usages
7628: where reporting_type_id = types.reporting_type_id
7629: and entity_code = 'ZX_RATES');
7630:
7631: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_B table...');

Line 8050: INTO ZX_REPORT_TYPES_USAGES

8046: BEGIN
8047: arp_util_tax.debug('CREATE_REPORT_TYP_USAGES_EUVAT(+)');
8048:
8049: INSERT
8050: INTO ZX_REPORT_TYPES_USAGES
8051: (
8052: REPORTING_TYPE_USAGE_ID ,
8053: ENTITY_CODE ,
8054: ENABLED_FLAG ,

Line 8063: SELECT zx_report_types_usages_s.nextval , --REPORTING_TYPE_USAGE_ID

8059: LAST_UPDATE_LOGIN ,
8060: REPORTING_TYPE_ID ,
8061: OBJECT_VERSION_NUMBER
8062: )
8063: SELECT zx_report_types_usages_s.nextval , --REPORTING_TYPE_USAGE_ID
8064: lookups.lookup_code , --ENTITY_CODE
8065: DECODE(lookups.lookup_code,
8066: 'ZX_RATES','Y',
8067: 'ZX_STATUS','Y',

Line 8085: FROM zx_report_types_usages

8081: AND record_type_code = 'MIGRATED'
8082: AND lookup_type = 'ZX_REPORTING_TABLE_USE'
8083: AND NOT EXISTS
8084: ( SELECT 1
8085: FROM zx_report_types_usages
8086: WHERE reporting_type_id = rep_type.reporting_type_id
8087: AND entity_code = lookups.lookup_code
8088: );
8089: