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_B_S

Line 280: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

276: REPORTING_TYPE_ID ,
277: OBJECT_VERSION_NUMBER
278: )
279: SELECT
280: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
281: NULL ,--EXCEPTION_CODE
282: report_types.EFFECTIVE_FROM ,
283: NULL ,--EFFECTIVE_TO
284: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 596: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

592: REPORTING_TYPE_ID ,
593: OBJECT_VERSION_NUMBER
594: )
595: SELECT
596: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
597: NULL ,--EXCEPTION_CODE
598: EFFECTIVE_FROM ,
599: NULL ,--EFFECTIVE_TO
600: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 1088: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

1084: REPORTING_TYPE_ID ,
1085: OBJECT_VERSION_NUMBER
1086: )
1087: SELECT
1088: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
1089: NULL ,--EXCEPTION_CODE
1090: EFFECTIVE_FROM ,
1091: NULL ,--EFFECTIVE_TO
1092: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 3534: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

3530: REPORTING_TYPE_ID ,
3531: OBJECT_VERSION_NUMBER
3532: )
3533: SELECT
3534: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
3535: NULL ,--EXCEPTION_CODE
3536: EFFECTIVE_FROM ,
3537: NULL ,--EFFECTIVE_TO
3538: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 3606: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

3602: REPORTING_TYPE_ID,
3603: OBJECT_VERSION_NUMBER
3604: )
3605: SELECT
3606: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
3607: NULL ,--EXCEPTION_CODE
3608: EFFECTIVE_FROM ,
3609: NULL ,--EFFECTIVE_TO
3610: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 3679: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

3675: REPORTING_TYPE_ID ,
3676: OBJECT_VERSION_NUMBER
3677: )
3678: SELECT
3679: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
3680: NULL ,--EXCEPTION_CODE
3681: effective_from ,
3682: NULL ,--EFFECTIVE_TO
3683: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 3960: ZX_REPORTING_CODES_B_S.NEXTVAL,

3956: OBJECT_VERSION_NUMBER
3957: )
3958: VALUES
3959: (
3960: ZX_REPORTING_CODES_B_S.NEXTVAL,
3961: NULL,
3962: l_start_date,
3963: NULL,
3964: 'MIGRATED',

Line 4801: select zx_reporting_codes_b_s.nextval into l_seqid from dual;

4797: (select vat_tax_id from ar_vat_tax_all_b )
4798:
4799:
4800: LOOP
4801: select zx_reporting_codes_b_s.nextval into l_seqid from dual;
4802:
4803: INSERT ALL
4804: INTO
4805: ZX_REPORTING_CODES_B

Line 5045: ZX_REPORTING_CODES_B_S.NEXTVAL,

5041: OBJECT_VERSION_NUMBER
5042: )
5043: VALUES
5044: (
5045: ZX_REPORTING_CODES_B_S.NEXTVAL,
5046: NULL,
5047: l_start_date,
5048: NULL,
5049: 'MIGRATED',

Line 5111: ZX_REPORTING_CODES_B_S.NEXTVAL,

5107: OBJECT_VERSION_NUMBER
5108: )
5109: VALUES
5110: (
5111: ZX_REPORTING_CODES_B_S.NEXTVAL,
5112: NULL,
5113: l_start_date,
5114: NULL,
5115: 'MIGRATED',

Line 5347: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

5343: REPORTING_TYPE_ID ,
5344: OBJECT_VERSION_NUMBER
5345: )
5346: SELECT
5347: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
5348: NULL ,--EXCEPTION_CODE
5349: report_types.EFFECTIVE_FROM ,
5350: NULL ,--EFFECTIVE_TO
5351: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 5500: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

5496: PROGRAM_LOGIN_ID ,
5497: OBJECT_VERSION_NUMBER
5498: )
5499: SELECT
5500: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
5501: global_attribute ,--REPORTING_CODE_CHAR_VALUE
5502: NULL ,--REPORTING_CODE_NUM_VALUE
5503: NULL ,--REPORTING_CODE_DATE_VALUE
5504: reporting_type_id ,--REPORTING_TYPE_ID

Line 5696: ZX_REPORTING_CODES_B_S.NEXTVAL,

5692: OBJECT_VERSION_NUMBER
5693: )
5694: VALUES
5695: (
5696: ZX_REPORTING_CODES_B_S.NEXTVAL,
5697: NULL,
5698: l_start_date,
5699: NULL,
5700: 'MIGRATED',

Line 6300: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

6296: REPORTING_TYPE_ID ,
6297: OBJECT_VERSION_NUMBER
6298: )
6299: SELECT
6300: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
6301: NULL ,--EXCEPTION_CODE
6302: EFFECTIVE_FROM ,
6303: NULL ,--EFFECTIVE_TO
6304: 'SEEDED' ,--RECORD_TYPE_CODE

Line 6567: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

6563: REPORTING_TYPE_ID ,
6564: OBJECT_VERSION_NUMBER
6565: )
6566: SELECT
6567: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
6568: NULL ,--EXCEPTION_CODE
6569: report_types.EFFECTIVE_FROM ,
6570: NULL ,--EFFECTIVE_TO
6571: 'SEEDED' ,--RECORD_TYPE_CODE

Line 6720: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

6716: REPORTING_TYPE_ID ,
6717: OBJECT_VERSION_NUMBER
6718: )
6719: SELECT
6720: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
6721: NULL ,--EXCEPTION_CODE
6722: EFFECTIVE_FROM ,
6723: NULL ,--EFFECTIVE_TO
6724: 'SEEDED' ,--RECORD_TYPE_CODE

Line 7187: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

7183: REPORTING_TYPE_ID ,
7184: OBJECT_VERSION_NUMBER
7185: )
7186: SELECT
7187: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
7188: NULL ,--EXCEPTION_CODE
7189: EFFECTIVE_FROM ,--EFFECTIVE_FROM
7190: NULL ,--EFFECTIVE_TO
7191: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 7656: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID

7652: REPORTING_TYPE_ID ,
7653: OBJECT_VERSION_NUMBER
7654: )
7655: SELECT
7656: zx_reporting_codes_b_s.nextval,--REPORTING_CODE_ID
7657: NULL ,--EXCEPTION_CODE
7658: EFFECTIVE_FROM ,--EFFECTIVE_FROM
7659: NULL ,--EFFECTIVE_TO
7660: 'MIGRATED' ,--RECORD_TYPE_CODE

Line 8135: SELECT zx_reporting_codes_b_s.nextval ,--REPORTING_CODE_ID

8131: REPORTING_CODE_NUM_VALUE ,
8132: REPORTING_TYPE_ID ,
8133: OBJECT_VERSION_NUMBER
8134: )
8135: SELECT zx_reporting_codes_b_s.nextval ,--REPORTING_CODE_ID
8136: NULL ,--EXCEPTION_CODE
8137: EFFECTIVE_FROM ,--EFFECTIVE_FROM
8138: NULL ,--EFFECTIVE_TO
8139: 'MIGRATED' ,--RECORD_TYPE_CODE