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.

[Home] [Help]

APPS.ZX_MIGRATE_REP_ENTITIES_PKG dependencies on ZX_REPORTING_CODES_TL

Line 197: | ZX_REPORTING_CODES_TL |

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: | |
200: | SCOPE - PUBLIC |
201: | |

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

618: REPORTING_CODE_CHAR_VALUE=lookups.LOOKUP_CODE
619: )
620: );
621:
622: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');
623:
624: INSERT INTO ZX_REPORTING_CODES_TL(
625: REPORTING_CODE_ID ,
626: LANGUAGE ,

Line 624: INSERT INTO ZX_REPORTING_CODES_TL(

620: );
621:
622: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');
623:
624: INSERT INTO ZX_REPORTING_CODES_TL(
625: REPORTING_CODE_ID ,
626: LANGUAGE ,
627: SOURCE_LANG ,
628: REPORTING_CODE_NAME ,

Line 667: from ZX_REPORTING_CODES_TL T

663: AND lookups.LANGUAGE = L.LANGUAGE_CODE(+)
664: AND L.INSTALLED_FLAG in ('I', 'B')
665: AND not exists
666: (select NULL
667: from ZX_REPORTING_CODES_TL T
668: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
669: and T.LANGUAGE = L.LANGUAGE_CODE);
670:
671:

Line 752: INSERT INTO ZX_REPORTING_CODES_TL(

748:
749: --BugFix 3557652 REPORTING CODE_TL IMPL FOR ARGENTINE DGI TRANSACTION CODE
750: --Bug# 4952838. Moved this logic to common procedure CREATE_REPORTING_CODES
751: /*
752: INSERT INTO ZX_REPORTING_CODES_TL(
753: REPORTING_CODE_ID ,
754: LANGUAGE ,
755: SOURCE_LANG ,
756: REPORTING_CODE_NAME ,

Line 791: from ZX_REPORTING_CODES_TL T

787: AND lookups.LANGUAGE = L.LANGUAGE_CODE(+)
788: AND L.INSTALLED_FLAG in ('I', 'B')
789: AND not exists
790: (select NULL
791: from ZX_REPORTING_CODES_TL T
792: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
793: and T.LANGUAGE = L.LANGUAGE_CODE);
794: */
795:

Line 796: INSERT INTO ZX_REPORTING_CODES_TL(

792: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
793: and T.LANGUAGE = L.LANGUAGE_CODE);
794: */
795:
796: INSERT INTO ZX_REPORTING_CODES_TL(
797: REPORTING_CODE_ID ,
798: LANGUAGE ,
799: SOURCE_LANG ,
800: REPORTING_CODE_NAME ,

Line 839: from ZX_REPORTING_CODES_TL T

835: CODES.RECORD_TYPE_CODE = 'MIGRATED'
836: AND L.INSTALLED_FLAG in ('I', 'B')
837: AND not exists
838: (select NULL
839: from ZX_REPORTING_CODES_TL T
840: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
841: and T.LANGUAGE = L.LANGUAGE_CODE);
842:
843:

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

1110: REPORTING_CODE_CHAR_VALUE=lookups.LOOKUP_CODE
1111: )
1112: );
1113:
1114: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');
1115:
1116: INSERT INTO ZX_REPORTING_CODES_TL(
1117: REPORTING_CODE_ID ,
1118: LANGUAGE ,

Line 1116: INSERT INTO ZX_REPORTING_CODES_TL(

1112: );
1113:
1114: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');
1115:
1116: INSERT INTO ZX_REPORTING_CODES_TL(
1117: REPORTING_CODE_ID ,
1118: LANGUAGE ,
1119: SOURCE_LANG ,
1120: REPORTING_CODE_NAME ,

Line 1159: from ZX_REPORTING_CODES_TL T

1155: AND lookups.LANGUAGE = L.LANGUAGE_CODE(+)
1156: AND L.INSTALLED_FLAG in ('I', 'B')
1157: AND not exists
1158: (select NULL
1159: from ZX_REPORTING_CODES_TL T
1160: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
1161: and T.LANGUAGE = L.LANGUAGE_CODE);
1162:
1163:

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

4684: zx_rates.tax_regime_code;
4685: --Bug 4705196
4686: /*
4687: --Bug 4422813
4688: --The creation of zx_reporting_types_b , zx_reporting_codes_b and zx_reporting_codes_tl has been put together for
4689: --easy understanding
4690:
4691: INSERT ALL
4692: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

Line 4844: ZX_REPORTING_CODES_TL

4840:
4841:
4842: INSERT ALL
4843: INTO
4844: ZX_REPORTING_CODES_TL
4845: (
4846: REPORTING_CODE_ID ,
4847: LANGUAGE ,
4848: SOURCE_LANG ,

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

4878: ar_vat_tax_all_tl avtl
4879: where avtl.vat_tax_id = cursor_rec.vat_tax_id
4880: and avtl.printed_tax_name is not null
4881: and not exists
4882: (select 1 from zx_reporting_codes_tl where reporting_code_id = l_seqid
4883: and language = avtl.language);
4884: END LOOP;
4885:
4886:

Line 5356: INSERT INTO ZX_REPORTING_CODES_TL (

5352:
5353: --Bug Fix 4930895 Populate FND_LOOKUPS.MEANING INTO REPORTING_CODE_NAME
5354: -- Moved this logic to common procedure CREATE_REPORTING_CODES
5355: /*
5356: INSERT INTO ZX_REPORTING_CODES_TL (
5357: REPORTING_CODE_ID ,
5358: LANGUAGE ,
5359: SOURCE_LANG ,
5360: REPORTING_CODE_NAME ,

Line 5394: from ZX_REPORTING_CODES_TL T

5390: AND lookups.LANGUAGE = L.LANGUAGE_CODE(+)
5391: AND L.INSTALLED_FLAG in ('I', 'B')
5392: AND not exists
5393: (select NULL
5394: from ZX_REPORTING_CODES_TL T
5395: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
5396: and T.LANGUAGE = L.LANGUAGE_CODE);
5397: */
5398:

Line 5404: INSERT INTO ZX_REPORTING_CODES_TL (

5400:
5401: --Bug Fix 4930895 Populate FND_LOOKUPS.MEANING INTO REPORTING_CODE_NAME
5402: -- Moved this logic to common procedure CREATE_REPORTING_CODES
5403: /*
5404: INSERT INTO ZX_REPORTING_CODES_TL (
5405: REPORTING_CODE_ID ,
5406: LANGUAGE ,
5407: SOURCE_LANG ,
5408: REPORTING_CODE_NAME ,

Line 5442: from ZX_REPORTING_CODES_TL T

5438: AND lookups.LANGUAGE = L.LANGUAGE_CODE(+)
5439: AND L.INSTALLED_FLAG in ('I', 'B')
5440: AND not exists
5441: (select NULL
5442: from ZX_REPORTING_CODES_TL T
5443: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
5444: and T.LANGUAGE = L.LANGUAGE_CODE);
5445: */
5446:

Line 5518: INSERT INTO ZX_REPORTING_CODES_TL(

5514: )
5515:
5516: ); --YK:9/22/2004: Synch is taken care by checking NOT EXISTS.
5517: /* Bug 5031787
5518: INSERT INTO ZX_REPORTING_CODES_TL(
5519: REPORTING_CODE_ID ,
5520: LANGUAGE ,
5521: SOURCE_LANG ,
5522: REPORTING_CODE_NAME ,

Line 5556: from ZX_REPORTING_CODES_TL T

5552: AND lookups.LANGUAGE = L.LANGUAGE_CODE(+)
5553: AND L.INSTALLED_FLAG in ('I', 'B')
5554: AND not exists
5555: (select NULL
5556: from ZX_REPORTING_CODES_TL T
5557: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
5558: and T.LANGUAGE = L.LANGUAGE_CODE);
5559: */
5560: -- End of Korean GDF

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

6308: REPORTING_CODE_CHAR_VALUE=lookups.LOOKUP_CODE
6309: )
6310: );
6311:
6312: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');
6313:
6314: INSERT INTO ZX_REPORTING_CODES_TL(
6315: REPORTING_CODE_ID ,
6316: LANGUAGE ,

Line 6314: INSERT INTO ZX_REPORTING_CODES_TL(

6310: );
6311:
6312: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');
6313:
6314: INSERT INTO ZX_REPORTING_CODES_TL(
6315: REPORTING_CODE_ID ,
6316: LANGUAGE ,
6317: SOURCE_LANG ,
6318: REPORTING_CODE_NAME ,

Line 6357: from ZX_REPORTING_CODES_TL T

6353: AND lookups.LANGUAGE = L.LANGUAGE_CODE(+)
6354: AND L.INSTALLED_FLAG in ('I', 'B')
6355: AND not exists
6356: (select NULL
6357: from ZX_REPORTING_CODES_TL T
6358: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
6359: and T.LANGUAGE = L.LANGUAGE_CODE);
6360:
6361:

Line 6570: INSERT INTO ZX_REPORTING_CODES_TL(

6566: );
6567: END LOOP ;
6568:
6569: --Create Reporting Codes TL for PT_LOCATION
6570: INSERT INTO ZX_REPORTING_CODES_TL(
6571: REPORTING_CODE_ID ,
6572: LANGUAGE ,
6573: SOURCE_LANG ,
6574: REPORTING_CODE_NAME ,

Line 6614: from ZX_REPORTING_CODES_TL T

6610: WHERE REPORTING_TYPE_CODE = 'PT_LOCATION' AND record_type_code = 'SEEDED' )
6611: AND L.INSTALLED_FLAG in ('I', 'B')
6612: AND not exists
6613: (select NULL
6614: from ZX_REPORTING_CODES_TL T
6615: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
6616: and T.LANGUAGE = L.LANGUAGE_CODE);
6617: END IF ;
6618:

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

6728: REPORTING_CODE_CHAR_VALUE=lookups.LOOKUP_CODE
6729: )
6730: );
6731:
6732: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');
6733:
6734: INSERT INTO ZX_REPORTING_CODES_TL(
6735: REPORTING_CODE_ID ,
6736: LANGUAGE ,

Line 6734: INSERT INTO ZX_REPORTING_CODES_TL(

6730: );
6731:
6732: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');
6733:
6734: INSERT INTO ZX_REPORTING_CODES_TL(
6735: REPORTING_CODE_ID ,
6736: LANGUAGE ,
6737: SOURCE_LANG ,
6738: REPORTING_CODE_NAME ,

Line 6777: from ZX_REPORTING_CODES_TL T

6773: AND lookups.LANGUAGE = L.LANGUAGE_CODE(+)
6774: AND L.INSTALLED_FLAG in ('I', 'B')
6775: AND not exists
6776: (select NULL
6777: from ZX_REPORTING_CODES_TL T
6778: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
6779: and T.LANGUAGE = L.LANGUAGE_CODE);
6780:
6781: END IF ;

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

7210: UPPER(lookups.lookup_code))
7211: )
7212: );
7213:
7214: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');
7215:
7216: INSERT INTO ZX_REPORTING_CODES_TL(
7217: REPORTING_CODE_ID ,
7218: LANGUAGE ,

Line 7216: INSERT INTO ZX_REPORTING_CODES_TL(

7212: );
7213:
7214: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');
7215:
7216: INSERT INTO ZX_REPORTING_CODES_TL(
7217: REPORTING_CODE_ID ,
7218: LANGUAGE ,
7219: SOURCE_LANG ,
7220: REPORTING_CODE_NAME ,

Line 7265: from ZX_REPORTING_CODES_TL T

7261: AND lookups.LANGUAGE = L.LANGUAGE_CODE(+)
7262: AND L.INSTALLED_FLAG in ('I', 'B')
7263: AND not exists
7264: (select NULL
7265: from ZX_REPORTING_CODES_TL T
7266: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
7267: and T.LANGUAGE = L.LANGUAGE_CODE);
7268:
7269: arp_util_tax.debug('CREATE_REPORTING_CODES_EMEA(-)');

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

7666: AND REPORTING_CODE_CHAR_VALUE = UPPER(lookups.lookup_code)
7667: )
7668: );
7669:
7670: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table...');
7671:
7672: INSERT INTO ZX_REPORTING_CODES_TL(
7673: REPORTING_CODE_ID ,
7674: LANGUAGE ,

Line 7672: INSERT INTO ZX_REPORTING_CODES_TL(

7668: );
7669:
7670: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table...');
7671:
7672: INSERT INTO ZX_REPORTING_CODES_TL(
7673: REPORTING_CODE_ID ,
7674: LANGUAGE ,
7675: SOURCE_LANG ,
7676: REPORTING_CODE_NAME ,

Line 7715: from ZX_REPORTING_CODES_TL T

7711: AND lookups.LANGUAGE = L.LANGUAGE_CODE(+)
7712: AND L.INSTALLED_FLAG in ('I', 'B')
7713: AND not exists
7714: (select NULL
7715: from ZX_REPORTING_CODES_TL T
7716: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
7717: and T.LANGUAGE = L.LANGUAGE_CODE);
7718:
7719: arp_util_tax.debug('Inserting into ZX_REPORT_CODES_ASSOC table...');