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 198: | ZX_REPORT_TYPES_USAGES |

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: | |
200: | SCOPE - PUBLIC |
201: | |
202: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 427: INSERT INTO ZX_REPORT_TYPES_USAGES(

423: CREATE_REPORT_TYPE_PTP('JE - REG NUMBER', 'TEXT', 'N');
424: CREATE_REPORT_TYPE_PTP('AR-SYSTEM-PARAM-REG-NUM', 'TEXT', 'N');
425: CREATE_REPORT_TYPE_PTP('FSO-REG-NUM', 'TEXT', 'N');
426:
427: INSERT INTO ZX_REPORT_TYPES_USAGES(
428: REPORTING_TYPE_USAGE_ID ,
429: ENTITY_CODE ,
430: ENABLED_FLAG ,
431: CREATED_BY ,

Line 439: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

435: LAST_UPDATE_LOGIN ,
436: REPORTING_TYPE_ID ,
437: OBJECT_VERSION_NUMBER
438: )
439: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
440: LOOKUP_CODE ,--ENTITY_CODE
441: decode(LOOKUP_CODE,
442: 'ZX_PARTY_TAX_PROFILE',
443: 'Y',

Line 461: AND NOT EXISTS ( select 1 from zx_report_types_usages

457: WHERE
458: reporting_type_code = 'FISCAL PRINTER'
459: AND LOOKUP_TYPE= 'ZX_REPORTING_TABLE_USE'
460:
461: AND NOT EXISTS ( select 1 from zx_report_types_usages
462: where reporting_type_id = rep_type.reporting_type_id and
463: entity_code = fnd_lookups.lookup_code );
464:
465:

Line 466: INSERT INTO ZX_REPORT_TYPES_USAGES(

462: where reporting_type_id = rep_type.reporting_type_id and
463: entity_code = fnd_lookups.lookup_code );
464:
465:
466: INSERT INTO ZX_REPORT_TYPES_USAGES(
467: REPORTING_TYPE_USAGE_ID ,
468: ENTITY_CODE ,
469: ENABLED_FLAG ,
470: CREATED_BY ,

Line 478: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

474: LAST_UPDATE_LOGIN ,
475: REPORTING_TYPE_ID ,
476: OBJECT_VERSION_NUMBER
477: )
478: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
479: LOOKUP_CODE ,--ENTITY_CODE
480: decode(LOOKUP_CODE,
481: 'ZX_PARTY_TAX_PROFILE',
482: 'Y',

Line 499: AND NOT EXISTS ( select 1 from zx_report_types_usages

495: WHERE
496: reporting_type_code = 'CAI NUMBER'
497: AND LOOKUP_TYPE= 'ZX_REPORTING_TABLE_USE'
498:
499: AND NOT EXISTS ( select 1 from zx_report_types_usages
500: where reporting_type_id = rep_type.reporting_type_id and
501: entity_code = fnd_lookups.lookup_code );
502:
503: --BugFix 3604885

Line 504: INSERT INTO ZX_REPORT_TYPES_USAGES(

500: where reporting_type_id = rep_type.reporting_type_id and
501: entity_code = fnd_lookups.lookup_code );
502:
503: --BugFix 3604885
504: INSERT INTO ZX_REPORT_TYPES_USAGES(
505: REPORTING_TYPE_USAGE_ID,
506: REPORTING_TYPE_ID ,
507: ENTITY_CODE ,
508: ENABLED_FLAG ,

Line 517: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

513: LAST_UPDATE_LOGIN ,
514: OBJECT_VERSION_NUMBER
515: )
516: SELECT
517: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
518: types.reporting_type_id ,--REPORTING_TYPE_ID
519: lookups.lookup_code ,--ENTITY_CODE
520: DECODE(lookups.lookup_code,
521: 'ZX_RATES','Y', --Bug 5528045

Line 546: AND NOT EXISTS ( select 1 from zx_report_types_usages

542: AND types.record_type_code = 'MIGRATED'
543:
544: AND lookups.LOOKUP_TYPE = 'ZX_REPORTING_TABLE_USE'
545:
546: AND NOT EXISTS ( select 1 from zx_report_types_usages
547: where reporting_type_id = types.reporting_type_id
548: and entity_code = lookups.lookup_code );
549:
550:

Line 4910: DELETE FROM ZX_REPORT_TYPES_USAGES

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
4911: WHERE reporting_type_id IN ( SELECT reporting_type_id FROM ZX_REPORTING_TYPES_B
4912: WHERE reporting_type_code= 'ZX_ADJ_TAX_CLASSIF_CODE' AND record_type_code = 'SEEDED' );
4913:
4914: DELETE FROM ZX_REPORTING_TYPES_B WHERE reporting_type_code= 'ZX_ADJ_TAX_CLASSIF_CODE' AND record_type_code = 'SEEDED';

Line 5126: INSERT INTO ZX_REPORT_TYPES_USAGES(

5122:
5123: --Bug Fix 4466085
5124: --Creation of Reporting Types Usages for Reporting Type ZX_ADJ_TAX_CLASSIF_CODE
5125:
5126: INSERT INTO ZX_REPORT_TYPES_USAGES(
5127: REPORTING_TYPE_USAGE_ID ,
5128: ENTITY_CODE ,
5129: ENABLED_FLAG ,
5130: CREATED_BY ,

Line 5138: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

5134: LAST_UPDATE_LOGIN ,
5135: REPORTING_TYPE_ID ,
5136: OBJECT_VERSION_NUMBER
5137: )
5138: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
5139: lookups.lookup_code , --ENTITY_CODE --Bug 5528045
5140: DECODE(lookups.lookup_code,
5141: 'ZX_RATES','Y',
5142: 'N') ,--ENABLED_FLAG --Bug 5528045

Line 5157: AND NOT EXISTS ( select 1 from zx_report_types_usages

5153: WHERE
5154: reporting_type_code = 'ZX_ADJ_TAX_CLASSIF_CODE'
5155: AND record_type_code = 'MIGRATED'
5156: AND lookup_type = 'ZX_REPORTING_TABLE_USE'
5157: AND NOT EXISTS ( select 1 from zx_report_types_usages
5158: where reporting_type_id = rep_type.reporting_type_id
5159: and entity_code = lookups.lookup_code );
5160:
5161:

Line 5241: INSERT INTO ZX_REPORT_TYPES_USAGES(

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
5241: INSERT INTO ZX_REPORT_TYPES_USAGES(
5242: REPORTING_TYPE_USAGE_ID,
5243: REPORTING_TYPE_ID ,
5244: ENTITY_CODE ,
5245: ENABLED_FLAG ,

Line 5254: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

5250: LAST_UPDATE_LOGIN ,
5251: OBJECT_VERSION_NUMBER
5252: )
5253: SELECT
5254: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
5255: types.reporting_type_id ,--REPORTING_TYPE_ID
5256: lookups.lookup_code ,--ENTITY_CODE
5257: DECODE(lookups.lookup_code,
5258: 'ZX_RATES','Y', --Bug 5528045

Line 5280: AND NOT EXISTS ( select 1 from zx_report_types_usages

5276: 'KR_LOCATION' --YK:9/22/2004: Korean GDF
5277: )
5278: AND lookups.LOOKUP_TYPE = 'ZX_REPORTING_TABLE_USE'
5279: AND types.record_type_code = 'MIGRATED'
5280: AND NOT EXISTS ( select 1 from zx_report_types_usages
5281: where reporting_type_id = types.reporting_type_id
5282: and entity_code = lookups.lookup_code );
5283:
5284: -- Call the common procedure to create the reporting codes

Line 5795: INSERT INTO ZX_REPORT_TYPES_USAGES(

5791: -- Bug Fix 4671652
5792: -- Creation of reporting types usages for KR_BUSINESS_LOCATIONS
5793:
5794:
5795: INSERT INTO ZX_REPORT_TYPES_USAGES(
5796: REPORTING_TYPE_USAGE_ID ,
5797: ENTITY_CODE ,
5798: ENABLED_FLAG ,
5799: CREATED_BY ,

Line 5807: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

5803: LAST_UPDATE_LOGIN ,
5804: REPORTING_TYPE_ID ,
5805: OBJECT_VERSION_NUMBER
5806: )
5807: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
5808: 'ZX_RATES_B' ,--ENTITY_CODE
5809: 'Y' ,--ENABLED_FLAG
5810: fnd_global.user_id ,--CREATED_BY
5811: SYSDATE ,--CREATION_DATE

Line 5823: AND NOT EXISTS ( select 1 from zx_report_types_usages

5819: zx_reporting_types_b rep_type
5820:
5821: WHERE
5822: reporting_type_code = 'KR_BUSINESS_LOCATIONS'
5823: AND NOT EXISTS ( select 1 from zx_report_types_usages
5824: where reporting_type_id = rep_type.reporting_type_id and
5825: entity_code = 'ZX_RATES_B' );
5826: */
5827:

Line 6394: INSERT INTO ZX_REPORT_TYPES_USAGES(

6390:
6391: PROCEDURE CREATE_REPORTTYPE_USAGES_SEED IS
6392:
6393: BEGIN
6394: INSERT INTO ZX_REPORT_TYPES_USAGES(
6395: REPORTING_TYPE_USAGE_ID ,
6396: ENTITY_CODE ,
6397: ENABLED_FLAG ,
6398: CREATED_BY ,

Line 6406: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

6402: LAST_UPDATE_LOGIN ,
6403: REPORTING_TYPE_ID ,
6404: OBJECT_VERSION_NUMBER
6405: )
6406: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
6407: 'ZX_RATES' ,--ENTITY_CODE --Bug 5528484
6408: 'Y' ,--ENABLED_FLAG
6409: 120 ,--CREATED_BY
6410: SYSDATE ,--CREATION_DATE

Line 6427: AND NOT EXISTS ( select 1 from zx_report_types_usages

6423: 'PRINT TAX LINE','AR_MUNICIPAL_JUR','AR_TURN_OVER_JUR_CODE',
6424: 'CL_TAX_CODE_CLASSIF','CL_BILLS_OF_EXCH_TAX','KR_LOCATION'
6425: )
6426: AND record_type_code = 'SEEDED'
6427: AND NOT EXISTS ( select 1 from zx_report_types_usages
6428: where reporting_type_id = rep_type.reporting_type_id and
6429: entity_code = 'ZX_RATES' );
6430:
6431:

Line 6432: INSERT INTO ZX_REPORT_TYPES_USAGES(

6428: where reporting_type_id = rep_type.reporting_type_id and
6429: entity_code = 'ZX_RATES' );
6430:
6431:
6432: INSERT INTO ZX_REPORT_TYPES_USAGES(
6433: REPORTING_TYPE_USAGE_ID ,
6434: ENTITY_CODE ,
6435: ENABLED_FLAG ,
6436: CREATED_BY ,

Line 6444: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

6440: LAST_UPDATE_LOGIN ,
6441: REPORTING_TYPE_ID ,
6442: OBJECT_VERSION_NUMBER
6443: )
6444: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
6445: 'ZX_PARTY_TAX_PROFILE' ,--ENTITY_CODE
6446: 'Y' ,--ENABLED_FLAG
6447: 120 ,--CREATED_BY
6448: SYSDATE ,--CREATION_DATE

Line 6459: AND NOT EXISTS ( select 1 from zx_report_types_usages

6455: zx_reporting_types_b rep_type
6456: WHERE
6457: reporting_type_code IN ('FISCAL PRINTER','CAI NUMBER')
6458: AND record_type_code = 'SEEDED'
6459: AND NOT EXISTS ( select 1 from zx_report_types_usages
6460: where reporting_type_id = rep_type.reporting_type_id and
6461: entity_code = 'ZX_PARTY_TAX_PROFILE' );
6462:
6463: END CREATE_REPORTTYPE_USAGES_SEED;

Line 6830: INSERT INTO ZX_REPORT_TYPES_USAGES(

6826:
6827: PROCEDURE CREATE_REPORT_TYPES_USAGES
6828: IS
6829: BEGIN
6830: INSERT INTO ZX_REPORT_TYPES_USAGES(
6831: REPORTING_TYPE_USAGE_ID ,
6832: REPORTING_TYPE_ID ,
6833: ENTITY_CODE ,
6834: ENABLED_FLAG ,

Line 6843: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

6839: LAST_UPDATE_LOGIN ,
6840: OBJECT_VERSION_NUMBER
6841: )
6842: SELECT
6843: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
6844: types.reporting_type_id ,--REPORTING_TYPE_ID
6845: lookups.lookup_code ,--ENTITY_CODE
6846: DECODE(lookups.lookup_code,
6847: 'ZX_RATES','Y',

Line 6871: AND NOT EXISTS ( select 1 from zx_report_types_usages

6867: AND types.record_type_code = 'MIGRATED'
6868:
6869: AND lookups.LOOKUP_TYPE = 'ZX_REPORTING_TABLE_USE'
6870:
6871: AND NOT EXISTS ( select 1 from zx_report_types_usages
6872: where reporting_type_id = types.reporting_type_id
6873: and entity_code = lookups.lookup_code );
6874:
6875: INSERT INTO ZX_REPORT_TYPES_USAGES(

Line 6875: INSERT INTO ZX_REPORT_TYPES_USAGES(

6871: AND NOT EXISTS ( select 1 from zx_report_types_usages
6872: where reporting_type_id = types.reporting_type_id
6873: and entity_code = lookups.lookup_code );
6874:
6875: INSERT INTO ZX_REPORT_TYPES_USAGES(
6876: REPORTING_TYPE_USAGE_ID ,
6877: REPORTING_TYPE_ID,
6878: ENTITY_CODE ,
6879: ENABLED_FLAG ,

Line 6888: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

6884: LAST_UPDATE_LOGIN ,
6885: OBJECT_VERSION_NUMBER
6886: )
6887: SELECT
6888: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
6889: types.reporting_type_id ,--REPORTING_TYPE_ID
6890: lookups.lookup_code ,--ENTITY_CODE
6891: DECODE(lookups.lookup_code,
6892: 'ZX_PARTY_TAX_PROFILE','Y',

Line 6916: AND NOT EXISTS ( select 1 from zx_report_types_usages

6912: AND types.record_type_code = 'MIGRATED'
6913:
6914: AND lookups.LOOKUP_TYPE = 'ZX_REPORTING_TABLE_USE'
6915:
6916: AND NOT EXISTS ( select 1 from zx_report_types_usages
6917: where reporting_type_id = types.reporting_type_id
6918: and entity_code = lookups.lookup_code );
6919:
6920:

Line 7079: INSERT INTO ZX_REPORT_TYPES_USAGES(

7075: IS
7076: BEGIN
7077: arp_util_tax.debug('CREATE_REPORT_TYP_USAGES_EMEA(+)');
7078:
7079: INSERT INTO ZX_REPORT_TYPES_USAGES(
7080: REPORTING_TYPE_USAGE_ID,
7081: REPORTING_TYPE_ID ,
7082: ENTITY_CODE ,
7083: ENABLED_FLAG ,

Line 7092: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

7088: LAST_UPDATE_LOGIN ,
7089: OBJECT_VERSION_NUMBER
7090: )
7091: SELECT
7092: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
7093: types.reporting_type_id ,--REPORTING_TYPE_ID
7094: 'ZX_RATES' ,--ENTITY_CODE
7095: 'Y' ,--ENABLED_FLAG
7096: fnd_global.user_id ,--CREATED_BY

Line 7106: AND NOT EXISTS ( select 1 from zx_report_types_usages

7102: FROM
7103: zx_reporting_types_b types
7104: WHERE types.reporting_type_code IN('EMEA_VAT_REPORTING_TYPE')
7105: --AND types.record_type_code = 'MIGRATED'
7106: AND NOT EXISTS ( select 1 from zx_report_types_usages
7107: where reporting_type_id = types.reporting_type_id
7108: and entity_code = 'ZX_RATES');
7109:
7110: arp_util_tax.debug('CREATE_REPORT_TYP_USAGES_EMEA(-)');

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

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...');
7569:
7570: INSERT INTO ZX_REPORT_TYPES_USAGES(
7571: REPORTING_TYPE_USAGE_ID,
7572: REPORTING_TYPE_ID ,

Line 7570: INSERT INTO ZX_REPORT_TYPES_USAGES(

7566: and T.LANGUAGE = TYPES.LANGUAGE_CODE);
7567:
7568: arp_util_tax.debug('Inserting into ZX_REPORT_TYPES_USAGES table...');
7569:
7570: INSERT INTO ZX_REPORT_TYPES_USAGES(
7571: REPORTING_TYPE_USAGE_ID,
7572: REPORTING_TYPE_ID ,
7573: ENTITY_CODE ,
7574: ENABLED_FLAG ,

Line 7583: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID

7579: LAST_UPDATE_LOGIN ,
7580: OBJECT_VERSION_NUMBER
7581: )
7582: SELECT
7583: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
7584: types.reporting_type_id ,--REPORTING_TYPE_ID
7585: 'ZX_RATES' ,--ENTITY_CODE
7586: 'Y' ,--ENABLED_FLAG
7587: fnd_global.user_id ,--CREATED_BY

Line 7597: AND NOT EXISTS ( select 1 from zx_report_types_usages

7593: FROM
7594: zx_reporting_types_b types
7595: WHERE types.reporting_type_code = 'REVERSE_CHARGE_VAT'
7596: --AND types.record_type_code = 'MIGRATED'
7597: AND NOT EXISTS ( select 1 from zx_report_types_usages
7598: where reporting_type_id = types.reporting_type_id
7599: and entity_code = 'ZX_RATES');
7600:
7601: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_B table...');