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_MIGR_AR_TAX_GROUP_LOOKUPS dependencies on FND_LOOKUP_VALUES

Line 495: arp_util_tax.debug('creating records in FND_LOOKUP_VALUES...');

491: and sub.language = l.language_code);
492:
493:
494: IF PG_DEBUG = 'Y' THEN
495: arp_util_tax.debug('creating records in FND_LOOKUP_VALUES...');
496: END IF;
497:
498: /* Insert lookup codes for the lookup types */
499: INSERT INTO FND_LOOKUP_VALUES

Line 499: INSERT INTO FND_LOOKUP_VALUES

495: arp_util_tax.debug('creating records in FND_LOOKUP_VALUES...');
496: END IF;
497:
498: /* Insert lookup codes for the lookup types */
499: INSERT INTO FND_LOOKUP_VALUES
500: (
501: LOOKUP_TYPE ,
502: LANGUAGE ,
503: LOOKUP_CODE ,

Line 571: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l

567: fnd_global.user_id ,
568: SYSDATE ,
569: fnd_global.user_id ,
570: fnd_global.conc_login_id
571: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
572: WHERE lk.lookup_type = 'TAX_CONDITION_TYPE'
573: AND view_application_id = 222
574: AND lk.language = 'US'
575: AND l.installed_flag in ('I', 'B')

Line 578: from FND_LOOKUP_VALUES

574: AND lk.language = 'US'
575: AND l.installed_flag in ('I', 'B')
576: AND not exists
577: (select '1'
578: from FND_LOOKUP_VALUES
579: where lookup_code = lk.lookup_code
580: and lookup_type = 'ZX_CONDITION_TYPE'
581: and language = l.LANGUAGE_CODE);
582:

Line 584: INSERT INTO FND_LOOKUP_VALUES

580: and lookup_type = 'ZX_CONDITION_TYPE'
581: and language = l.LANGUAGE_CODE);
582:
583: /* Insert lookup codes for the lookup types */
584: INSERT INTO FND_LOOKUP_VALUES
585: (
586: LOOKUP_TYPE ,
587: LANGUAGE ,
588: LOOKUP_CODE ,

Line 656: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l

652: fnd_global.user_id ,
653: SYSDATE ,
654: fnd_global.user_id ,
655: fnd_global.conc_login_id
656: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
657: WHERE lk.lookup_type = 'TAX_CONDITION_OPERATOR'
658: AND view_application_id = 222
659: AND lk.language = 'US'
660: AND l.installed_flag in ('I', 'B')

Line 663: from FND_LOOKUP_VALUES

659: AND lk.language = 'US'
660: AND l.installed_flag in ('I', 'B')
661: AND not exists
662: (select '1'
663: from FND_LOOKUP_VALUES
664: where lookup_code = lk.lookup_code
665: and lookup_type = 'ZX_CONDITION_OPERATOR'
666: and language = l.LANGUAGE_CODE);
667:

Line 669: INSERT INTO FND_LOOKUP_VALUES

665: and lookup_type = 'ZX_CONDITION_OPERATOR'
666: and language = l.LANGUAGE_CODE);
667:
668: /* Insert lookup codes for the lookup types */
669: INSERT INTO FND_LOOKUP_VALUES
670: (
671: LOOKUP_TYPE ,
672: LANGUAGE ,
673: LOOKUP_CODE ,

Line 741: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l

737: fnd_global.user_id ,
738: SYSDATE ,
739: fnd_global.user_id ,
740: fnd_global.conc_login_id
741: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
742: WHERE lk.lookup_type = 'TAX_CONDITION_FIELD'
743: AND view_application_id = 222
744: AND lk.language = 'US'
745: AND l.installed_flag in ('I', 'B')

Line 748: from FND_LOOKUP_VALUES

744: AND lk.language = 'US'
745: AND l.installed_flag in ('I', 'B')
746: AND not exists
747: (select '1'
748: from FND_LOOKUP_VALUES
749: where lookup_code = lk.lookup_code
750: and lookup_type = 'ZX_CONDITION_FIELD'
751: and language = l.LANGUAGE_CODE);
752:

Line 754: INSERT INTO FND_LOOKUP_VALUES

750: and lookup_type = 'ZX_CONDITION_FIELD'
751: and language = l.LANGUAGE_CODE);
752:
753: /* Insert lookup codes for the lookup types */
754: INSERT INTO FND_LOOKUP_VALUES
755: (
756: LOOKUP_TYPE ,
757: LANGUAGE ,
758: LOOKUP_CODE ,

Line 826: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l

822: fnd_global.user_id ,
823: SYSDATE ,
824: fnd_global.user_id ,
825: fnd_global.conc_login_id
826: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
827: WHERE lk.lookup_type = 'TAX_CONDITION_ENTITY'
828: AND view_application_id = 222
829: AND lk.language = 'US'
830: AND l.installed_flag in ('I', 'B')

Line 833: from FND_LOOKUP_VALUES

829: AND lk.language = 'US'
830: AND l.installed_flag in ('I', 'B')
831: AND not exists
832: (select '1'
833: from FND_LOOKUP_VALUES
834: where lookup_code = lk.lookup_code
835: and lookup_type = 'ZX_CONDITION_ENTITY'
836: and language = l.LANGUAGE_CODE);
837:

Line 839: INSERT INTO FND_LOOKUP_VALUES

835: and lookup_type = 'ZX_CONDITION_ENTITY'
836: and language = l.LANGUAGE_CODE);
837:
838: /* Insert lookup codes for the lookup types */
839: INSERT INTO FND_LOOKUP_VALUES
840: (
841: LOOKUP_TYPE ,
842: LANGUAGE ,
843: LOOKUP_CODE ,

Line 911: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l

907: fnd_global.user_id ,
908: SYSDATE ,
909: fnd_global.user_id ,
910: fnd_global.conc_login_id
911: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
912: WHERE lk.lookup_type = 'TAX_CONDITION_CLAUSE'
913: AND view_application_id = 222
914: AND lk.language = 'US'
915: AND l.installed_flag in ('I', 'B')

Line 918: from FND_LOOKUP_VALUES

914: AND lk.language = 'US'
915: AND l.installed_flag in ('I', 'B')
916: AND not exists
917: (select '1'
918: from FND_LOOKUP_VALUES
919: where lookup_code = lk.lookup_code
920: and lookup_type = 'ZX_CONDITION_CLAUSE'
921: and language = l.LANGUAGE_CODE);
922:

Line 924: INSERT INTO FND_LOOKUP_VALUES

920: and lookup_type = 'ZX_CONDITION_CLAUSE'
921: and language = l.LANGUAGE_CODE);
922:
923: /* Insert lookup codes for the lookup types */
924: INSERT INTO FND_LOOKUP_VALUES
925: (
926: LOOKUP_TYPE ,
927: LANGUAGE ,
928: LOOKUP_CODE ,

Line 996: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l

992: fnd_global.user_id ,
993: SYSDATE ,
994: fnd_global.user_id ,
995: fnd_global.conc_login_id
996: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
997: WHERE lk.lookup_type = 'TAX_CONDITION_ACTION_TYPE'
998: AND view_application_id = 222
999: AND lk.language = 'US'
1000: AND l.installed_flag in ('I', 'B')

Line 1003: from FND_LOOKUP_VALUES

999: AND lk.language = 'US'
1000: AND l.installed_flag in ('I', 'B')
1001: AND not exists
1002: (select '1'
1003: from FND_LOOKUP_VALUES
1004: where lookup_code = lk.lookup_code
1005: and lookup_type = 'ZX_CONDITION_ACTION_TYPE'
1006: and language = l.LANGUAGE_CODE);
1007:

Line 1009: INSERT INTO FND_LOOKUP_VALUES

1005: and lookup_type = 'ZX_CONDITION_ACTION_TYPE'
1006: and language = l.LANGUAGE_CODE);
1007:
1008: /* Insert lookup codes for the lookup types */
1009: INSERT INTO FND_LOOKUP_VALUES
1010: (
1011: LOOKUP_TYPE ,
1012: LANGUAGE ,
1013: LOOKUP_CODE ,

Line 1081: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l

1077: fnd_global.user_id ,
1078: SYSDATE ,
1079: fnd_global.user_id ,
1080: fnd_global.conc_login_id
1081: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
1082: WHERE lk.lookup_type = 'TAX_CONDITION_ACTION_CODE'
1083: AND view_application_id = 222
1084: AND lk.language = 'US'
1085: AND l.installed_flag in ('I', 'B')

Line 1088: from FND_LOOKUP_VALUES

1084: AND lk.language = 'US'
1085: AND l.installed_flag in ('I', 'B')
1086: AND not exists
1087: (select '1'
1088: from FND_LOOKUP_VALUES
1089: where lookup_code = lk.lookup_code
1090: and lookup_type = 'ZX_CONDITION_ACTION_CODE'
1091: and language = l.LANGUAGE_CODE);
1092:

Line 1094: INSERT INTO FND_LOOKUP_VALUES

1090: and lookup_type = 'ZX_CONDITION_ACTION_CODE'
1091: and language = l.LANGUAGE_CODE);
1092:
1093: /* Insert lookup codes for the lookup types */
1094: INSERT INTO FND_LOOKUP_VALUES
1095: (
1096: LOOKUP_TYPE ,
1097: LANGUAGE ,
1098: LOOKUP_CODE ,

Line 1166: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l

1162: fnd_global.user_id ,
1163: SYSDATE ,
1164: fnd_global.user_id ,
1165: fnd_global.conc_login_id
1166: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
1167: WHERE lk.lookup_type = 'TAX_CONDITION_VALUE'
1168: AND view_application_id = 222
1169: AND lk.language = 'US'
1170: AND l.installed_flag in ('I', 'B')

Line 1173: from FND_LOOKUP_VALUES

1169: AND lk.language = 'US'
1170: AND l.installed_flag in ('I', 'B')
1171: AND not exists
1172: (select '1'
1173: from FND_LOOKUP_VALUES
1174: where lookup_code = lk.lookup_code
1175: and lookup_type = 'ZX_CONDITION_VALUE'
1176: and language = l.LANGUAGE_CODE);
1177:

Line 1179: INSERT INTO FND_LOOKUP_VALUES

1175: and lookup_type = 'ZX_CONDITION_VALUE'
1176: and language = l.LANGUAGE_CODE);
1177:
1178: /* Insert lookup codes for the lookup types */
1179: INSERT INTO FND_LOOKUP_VALUES
1180: (
1181: LOOKUP_TYPE ,
1182: LANGUAGE ,
1183: LOOKUP_CODE ,

Line 1251: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l

1247: fnd_global.user_id ,
1248: SYSDATE ,
1249: fnd_global.user_id ,
1250: fnd_global.conc_login_id
1251: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
1252: WHERE lk.lookup_type = 'AR_TAX_CLASSIFICATION'
1253: AND view_application_id = 222
1254: AND lk.language = 'US'
1255: AND l.installed_flag in ('I', 'B')

Line 1258: from FND_LOOKUP_VALUES

1254: AND lk.language = 'US'
1255: AND l.installed_flag in ('I', 'B')
1256: AND not exists
1257: (select '1'
1258: from FND_LOOKUP_VALUES
1259: where lookup_code = lk.lookup_code
1260: and lookup_type = 'ZX_TAX_CLASSIFICATION'
1261: and language = l.LANGUAGE_CODE);
1262:

Line 1304: UPDATE fnd_lookup_values

1300: IF PG_DEBUG = 'Y' THEN
1301: arp_util_tax.debug('ZX_MIGRATE_AR_TAX_GROUPS.end_date_cond_cons_lk(+)');
1302: END IF;
1303:
1304: UPDATE fnd_lookup_values
1305: SET ENABLED_FLAG = 'N',
1306: END_DATE_ACTIVE = SYSDATE
1307: WHERE lookup_type in (
1308: 'ZX_CONDITION_TYPE',