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 FND_LOOKUPS

Line 42: P_lookup_type IN FND_LOOKUPS.LOOKUP_TYPE%TYPE

38:
39: /* Common procedure used to create Reporting Codes */
40: PROCEDURE CREATE_REPORTING_CODES (
41: p_reporting_type_code IN ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE %TYPE,
42: P_lookup_type IN FND_LOOKUPS.LOOKUP_TYPE%TYPE
43: );
44:
45: /*Common procedure used to create Reporting types for bug fix 3722296*/
46: PROCEDURE CREATE_REPORT_TYPE_PTP

Line 62: P_lookup_type IN FND_LOOKUPS.LOOKUP_TYPE%TYPE

58: );
59:
60: PROCEDURE CREATE_REPORTING_CODES_SEED (
61: p_reporting_type_code IN ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE %TYPE,
62: P_lookup_type IN FND_LOOKUPS.LOOKUP_TYPE%TYPE
63: );
64:
65: PROCEDURE CREATE_REPORTTYPE_USAGES_SEED;
66:

Line 470: fnd_lookups

466: 1
467:
468: FROM
469: zx_reporting_types_b rep_type,
470: fnd_lookups
471:
472: WHERE
473: reporting_type_code = 'FISCAL PRINTER'
474: AND LOOKUP_TYPE= 'ZX_REPORTING_TABLE_USE'

Line 478: entity_code = fnd_lookups.lookup_code );

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:
481: INSERT INTO ZX_REPORT_TYPES_USAGES(
482: REPORTING_TYPE_USAGE_ID ,

Line 508: fnd_lookups

504: reporting_type_id ,--REPORTING_TYPE_ID
505: 1
506: FROM
507: zx_reporting_types_b rep_type,
508: fnd_lookups
509:
510: WHERE
511: reporting_type_code = 'CAI NUMBER'
512: AND LOOKUP_TYPE= 'ZX_REPORTING_TABLE_USE'

Line 516: entity_code = fnd_lookups.lookup_code );

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
519: INSERT INTO ZX_REPORT_TYPES_USAGES(
520: REPORTING_TYPE_USAGE_ID,

Line 546: fnd_lookups lookups

542: fnd_global.conc_login_id,
543: 1
544: FROM
545: zx_reporting_types_b types,
546: fnd_lookups lookups
547:
548: WHERE
549: types.reporting_type_code IN('PT_LOCATION' ,
550: 'PT_PRD_TAXABLE_BOX' ,

Line 1058: P_lookup_type IN FND_LOOKUPS.LOOKUP_TYPE%TYPE

1054: /*THIS IS THE COMMON PROCEDURE USED TO INSERT THE REPORTING CODES */
1055:
1056: PROCEDURE CREATE_REPORTING_CODES (
1057: p_reporting_type_code IN ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE %TYPE,
1058: P_lookup_type IN FND_LOOKUPS.LOOKUP_TYPE%TYPE
1059: ) IS
1060:
1061: BEGIN
1062: arp_util_tax.debug('CREATE_REPORTING_CODES(+)');

Line 1117: FND_LOOKUPS lookups

1113: report_types.REPORTING_TYPE_ID REPORTING_TYPE_ID,
1114: report_types.REPORTING_TYPE_DATATYPE_CODE DATATYPE
1115: FROM
1116: ZX_REPORTING_TYPES_B report_types,
1117: FND_LOOKUPS lookups
1118: WHERE
1119: report_types.REPORTING_TYPE_CODE = p_reporting_type_code
1120: AND report_types.RECORD_TYPE_CODE = 'MIGRATED'
1121: AND lookups.LOOKUP_TYPE = p_lookup_type

Line 3579: the REPORTING CODES needs to pick up from FND_LOOKUPS */

3575:
3576: /*Insert into ZX_REPORTING_CODES_B for PORTUGAL Global Attribute 1.
3577: BugFix 3557652 REPORTING CODE IMPL FOR ARGENTINE DGI TRANSACTION CODE.
3578: Following Insert will take care of both of ABOVE since for both these
3579: the REPORTING CODES needs to pick up from FND_LOOKUPS */
3580:
3581: /* Commented for the Bug 4936036 : as the below logic is wrong and is based on the lookup_type = 'PT_LOCATION'
3582: which doesn't exist
3583: INSERT

Line 3637: FND_LOOKUPS lookups

3633:
3634: FROM
3635:
3636: ZX_REPORTING_TYPES_B report_types,
3637: FND_LOOKUPS lookups
3638:
3639: WHERE
3640:
3641: report_types.REPORTING_TYPE_CODE = 'PT_LOCATION'

Line 5181: fnd_lookups lookups

5177: reporting_type_id ,--REPORTING_TYPE_ID
5178: 1
5179: FROM
5180: zx_reporting_types_b rep_type,
5181: fnd_lookups lookups
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'

Line 5297: fnd_lookups lookups

5293: fnd_global.conc_login_id,
5294: 1
5295: FROM
5296: zx_reporting_types_b types,
5297: fnd_lookups lookups
5298:
5299: WHERE types.reporting_type_code IN(
5300: 'AR_MUNICIPAL_JUR',
5301: 'CL_TAX_CODE_CLASSIF',

Line 5382: --Bug Fix 4930895 Populate FND_LOOKUPS.MEANING INTO REPORTING_CODE_NAME

5378:
5379:
5380: CREATE_REPORTING_CODES('CL_TAX_CODE_CLASSIF', 'JLCL_TAX_CODE_CLASS');
5381:
5382: --Bug Fix 4930895 Populate FND_LOOKUPS.MEANING INTO REPORTING_CODE_NAME
5383: -- Moved this logic to common procedure CREATE_REPORTING_CODES
5384: /*
5385: INSERT INTO ZX_REPORTING_CODES_TL (
5386: REPORTING_CODE_ID ,

Line 5430: --Bug Fix 4930895 Populate FND_LOOKUPS.MEANING INTO REPORTING_CODE_NAME

5426: */
5427:
5428: CREATE_REPORTING_CODES('AR_TURN_OVER_JUR_CODE', 'JLZZ_AR_TO_JURISDICTION_CODE');
5429:
5430: --Bug Fix 4930895 Populate FND_LOOKUPS.MEANING INTO REPORTING_CODE_NAME
5431: -- Moved this logic to common procedure CREATE_REPORTING_CODES
5432: /*
5433: INSERT INTO ZX_REPORTING_CODES_TL (
5434: REPORTING_CODE_ID ,

Line 6270: P_lookup_type IN FND_LOOKUPS.LOOKUP_TYPE%TYPE

6266: | |
6267: |=========================================================================*/
6268: PROCEDURE CREATE_REPORTING_CODES_SEED (
6269: p_reporting_type_code IN ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE %TYPE,
6270: P_lookup_type IN FND_LOOKUPS.LOOKUP_TYPE%TYPE
6271: ) IS
6272:
6273: BEGIN
6274: arp_util_tax.debug('CREATE_REPORTING_CODES(+)');

Line 6329: FND_LOOKUPS lookups

6325: report_types.REPORTING_TYPE_ID REPORTING_TYPE_ID,
6326: report_types.REPORTING_TYPE_DATATYPE_CODE DATATYPE
6327: FROM
6328: ZX_REPORTING_TYPES_B report_types,
6329: FND_LOOKUPS lookups
6330: WHERE
6331: report_types.REPORTING_TYPE_CODE = p_reporting_type_code
6332: AND report_types.RECORD_TYPE_CODE = 'SEEDED'
6333: AND lookups.LOOKUP_TYPE = p_lookup_type

Line 6886: fnd_lookups lookups

6882: fnd_global.conc_login_id,
6883: 1
6884: FROM
6885: zx_reporting_types_b types,
6886: fnd_lookups lookups
6887:
6888: WHERE
6889: types.reporting_type_code IN('PL_TAX_ORIGIN',
6890: 'CH_VAT_REGIME',

Line 6931: fnd_lookups lookups

6927: fnd_global.conc_login_id,
6928: 1
6929: FROM
6930: zx_reporting_types_b types,
6931: fnd_lookups lookups
6932:
6933: WHERE
6934: types.reporting_type_code IN('MEMBER STATE',
6935: 'AR-SYSTEM-PARAM-REG-NUM',

Line 7220: FND_LOOKUPS lookups

7216: report_types.REPORTING_TYPE_ID REPORTING_TYPE_ID,
7217: report_types.REPORTING_TYPE_DATATYPE_CODE DATATYPE
7218: FROM
7219: ZX_REPORTING_TYPES_B report_types,
7220: FND_LOOKUPS lookups
7221: WHERE
7222: report_types.REPORTING_TYPE_CODE = 'EMEA_VAT_REPORTING_TYPE'
7223: --AND report_types.RECORD_TYPE_CODE = 'MIGRATED'
7224: AND lookups.LOOKUP_TYPE = 'ZX_TAX_TYPE_CATEGORY'

Line 7685: FND_LOOKUPS lookups

7681: report_types.REPORTING_TYPE_ID REPORTING_TYPE_ID,
7682: report_types.REPORTING_TYPE_DATATYPE_CODE DATATYPE
7683: FROM
7684: ZX_REPORTING_TYPES_B report_types,
7685: FND_LOOKUPS lookups
7686: WHERE
7687: report_types.REPORTING_TYPE_CODE = 'REVERSE_CHARGE_VAT'
7688: --AND report_types.RECORD_TYPE_CODE = 'MIGRATED'
7689: AND lookups.LOOKUP_TYPE = 'ZX_TAX_TYPE_CATEGORY'

Line 8078: fnd_lookups lookups

8074: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN
8075: reporting_type_id , --REPORTING_TYPE_ID
8076: 1 --OBJECT_VERSION_NUMBER
8077: FROM zx_reporting_types_b rep_type,
8078: fnd_lookups lookups
8079: WHERE reporting_type_code in ('ZX_INTRA_EU_TRX_TYPE',
8080: 'ZX_LGL_JUSTIFICATN_MSG_TYPE')
8081: AND record_type_code = 'MIGRATED'
8082: AND lookup_type = 'ZX_REPORTING_TABLE_USE'