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 455: fnd_lookups

451: 1
452:
453: FROM
454: zx_reporting_types_b rep_type,
455: fnd_lookups
456:
457: WHERE
458: reporting_type_code = 'FISCAL PRINTER'
459: AND LOOKUP_TYPE= 'ZX_REPORTING_TABLE_USE'

Line 463: entity_code = fnd_lookups.lookup_code );

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:
466: INSERT INTO ZX_REPORT_TYPES_USAGES(
467: REPORTING_TYPE_USAGE_ID ,

Line 493: fnd_lookups

489: reporting_type_id ,--REPORTING_TYPE_ID
490: 1
491: FROM
492: zx_reporting_types_b rep_type,
493: fnd_lookups
494:
495: WHERE
496: reporting_type_code = 'CAI NUMBER'
497: AND LOOKUP_TYPE= 'ZX_REPORTING_TABLE_USE'

Line 501: entity_code = fnd_lookups.lookup_code );

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
504: INSERT INTO ZX_REPORT_TYPES_USAGES(
505: REPORTING_TYPE_USAGE_ID,

Line 531: fnd_lookups lookups

527: fnd_global.conc_login_id,
528: 1
529: FROM
530: zx_reporting_types_b types,
531: fnd_lookups lookups
532:
533: WHERE
534: types.reporting_type_code IN('PT_LOCATION' ,
535: 'PT_PRD_TAXABLE_BOX' ,

Line 1043: P_lookup_type IN FND_LOOKUPS.LOOKUP_TYPE%TYPE

1039: /*THIS IS THE COMMON PROCEDURE USED TO INSERT THE REPORTING CODES */
1040:
1041: PROCEDURE CREATE_REPORTING_CODES (
1042: p_reporting_type_code IN ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE %TYPE,
1043: P_lookup_type IN FND_LOOKUPS.LOOKUP_TYPE%TYPE
1044: ) IS
1045:
1046: BEGIN
1047: arp_util_tax.debug('CREATE_REPORTING_CODES(+)');

Line 1102: FND_LOOKUPS lookups

1098: report_types.REPORTING_TYPE_ID REPORTING_TYPE_ID,
1099: report_types.REPORTING_TYPE_DATATYPE_CODE DATATYPE
1100: FROM
1101: ZX_REPORTING_TYPES_B report_types,
1102: FND_LOOKUPS lookups
1103: WHERE
1104: report_types.REPORTING_TYPE_CODE = p_reporting_type_code
1105: AND report_types.RECORD_TYPE_CODE = 'MIGRATED'
1106: AND lookups.LOOKUP_TYPE = p_lookup_type

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

3548:
3549: /*Insert into ZX_REPORTING_CODES_B for PORTUGAL Global Attribute 1.
3550: BugFix 3557652 REPORTING CODE IMPL FOR ARGENTINE DGI TRANSACTION CODE.
3551: Following Insert will take care of both of ABOVE since for both these
3552: the REPORTING CODES needs to pick up from FND_LOOKUPS */
3553:
3554: /* Commented for the Bug 4936036 : as the below logic is wrong and is based on the lookup_type = 'PT_LOCATION'
3555: which doesn't exist
3556: INSERT

Line 3610: FND_LOOKUPS lookups

3606:
3607: FROM
3608:
3609: ZX_REPORTING_TYPES_B report_types,
3610: FND_LOOKUPS lookups
3611:
3612: WHERE
3613:
3614: report_types.REPORTING_TYPE_CODE = 'PT_LOCATION'

Line 5152: fnd_lookups lookups

5148: reporting_type_id ,--REPORTING_TYPE_ID
5149: 1
5150: FROM
5151: zx_reporting_types_b rep_type,
5152: fnd_lookups lookups
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'

Line 5268: fnd_lookups lookups

5264: fnd_global.conc_login_id,
5265: 1
5266: FROM
5267: zx_reporting_types_b types,
5268: fnd_lookups lookups
5269:
5270: WHERE types.reporting_type_code IN(
5271: 'AR_MUNICIPAL_JUR',
5272: 'CL_TAX_CODE_CLASSIF',

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

5349:
5350:
5351: CREATE_REPORTING_CODES('CL_TAX_CODE_CLASSIF', 'JLCL_TAX_CODE_CLASS');
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 ,

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

5397: */
5398:
5399: CREATE_REPORTING_CODES('AR_TURN_OVER_JUR_CODE', 'JLZZ_AR_TO_JURISDICTION_CODE');
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 ,

Line 6241: P_lookup_type IN FND_LOOKUPS.LOOKUP_TYPE%TYPE

6237: | |
6238: |=========================================================================*/
6239: PROCEDURE CREATE_REPORTING_CODES_SEED (
6240: p_reporting_type_code IN ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE %TYPE,
6241: P_lookup_type IN FND_LOOKUPS.LOOKUP_TYPE%TYPE
6242: ) IS
6243:
6244: BEGIN
6245: arp_util_tax.debug('CREATE_REPORTING_CODES(+)');

Line 6300: FND_LOOKUPS lookups

6296: report_types.REPORTING_TYPE_ID REPORTING_TYPE_ID,
6297: report_types.REPORTING_TYPE_DATATYPE_CODE DATATYPE
6298: FROM
6299: ZX_REPORTING_TYPES_B report_types,
6300: FND_LOOKUPS lookups
6301: WHERE
6302: report_types.REPORTING_TYPE_CODE = p_reporting_type_code
6303: AND report_types.RECORD_TYPE_CODE = 'SEEDED'
6304: AND lookups.LOOKUP_TYPE = p_lookup_type

Line 6857: fnd_lookups lookups

6853: fnd_global.conc_login_id,
6854: 1
6855: FROM
6856: zx_reporting_types_b types,
6857: fnd_lookups lookups
6858:
6859: WHERE
6860: types.reporting_type_code IN('PL_TAX_ORIGIN',
6861: 'CH_VAT_REGIME',

Line 6902: fnd_lookups lookups

6898: fnd_global.conc_login_id,
6899: 1
6900: FROM
6901: zx_reporting_types_b types,
6902: fnd_lookups lookups
6903:
6904: WHERE
6905: types.reporting_type_code IN('MEMBER STATE',
6906: 'AR-SYSTEM-PARAM-REG-NUM',

Line 7191: FND_LOOKUPS lookups

7187: report_types.REPORTING_TYPE_ID REPORTING_TYPE_ID,
7188: report_types.REPORTING_TYPE_DATATYPE_CODE DATATYPE
7189: FROM
7190: ZX_REPORTING_TYPES_B report_types,
7191: FND_LOOKUPS lookups
7192: WHERE
7193: report_types.REPORTING_TYPE_CODE = 'EMEA_VAT_REPORTING_TYPE'
7194: --AND report_types.RECORD_TYPE_CODE = 'MIGRATED'
7195: AND lookups.LOOKUP_TYPE = 'ZX_TAX_TYPE_CATEGORY'

Line 7655: FND_LOOKUPS lookups

7651: report_types.REPORTING_TYPE_ID REPORTING_TYPE_ID,
7652: report_types.REPORTING_TYPE_DATATYPE_CODE DATATYPE
7653: FROM
7654: ZX_REPORTING_TYPES_B report_types,
7655: FND_LOOKUPS lookups
7656: WHERE
7657: report_types.REPORTING_TYPE_CODE = 'REVERSE_CHARGE_VAT'
7658: --AND report_types.RECORD_TYPE_CODE = 'MIGRATED'
7659: AND lookups.LOOKUP_TYPE = 'ZX_TAX_TYPE_CATEGORY'