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_PTP_IMPORT dependencies on FND_LOOKUPS

Line 1316: FROM fnd_lookups fndlookup

1312: WHERE (( registration_type_code IS NOT NULL
1313: AND NOT EXISTS
1314: (
1315: SELECT 1
1316: FROM fnd_lookups fndlookup
1317: WHERE fndlookup.lookup_type = 'ZX_REGISTRATIONS_TYPE'
1318: AND NVL(fndlookup.start_date_active, SYSDATE) <= SYSDATE
1319: AND NVL(fndlookup.end_date_active, SYSDATE) >= SYSDATE
1320: AND NVL(fndlookup.enabled_flag, 'N') = 'Y'

Line 1329: FROM fnd_lookups fndlookup

1325: ( registration_type_code IS NULL
1326: AND registration_type_name IS NOT NULL
1327: AND NOT EXISTS
1328: ( SELECT 1
1329: FROM fnd_lookups fndlookup
1330: WHERE fndlookup.lookup_type = 'ZX_REGISTRATIONS_TYPE'
1331: AND NVL(fndlookup.start_date_active, SYSDATE) <= SYSDATE
1332: AND NVL(fndlookup.end_date_active, SYSDATE) >= SYSDATE
1333: AND NVL(fndlookup.enabled_flag, 'N') = 'Y'

Line 1350: FROM fnd_lookups fndlookup

1346: -- value to id conversion for registration_type_code
1347: UPDATE zx_party_tax_profile_int ptp_int
1348: SET registration_type_code = (
1349: SELECT fndlookup.lookup_code
1350: FROM fnd_lookups fndlookup
1351: WHERE fndlookup.lookup_type = 'ZX_REGISTRATIONS_TYPE'
1352: AND NVL(fndlookup.start_date_active, SYSDATE) <= SYSDATE
1353: AND NVL(fndlookup.end_date_active, SYSDATE) >= SYSDATE
1354: AND NVL(fndlookup.enabled_flag, 'N') = 'Y'

Line 1375: FROM fnd_lookups

1371: WHERE (( rounding_level_code IS NOT NULL
1372: AND NOT EXISTS
1373: (
1374: SELECT 1
1375: FROM fnd_lookups
1376: WHERE lookup_type = 'ZX_ROUNDING_LEVEL'
1377: AND NVL(start_date_active, SYSDATE) <= SYSDATE
1378: AND NVL(end_date_active, SYSDATE) >= SYSDATE
1379: AND NVL(enabled_flag, 'N') = 'Y'

Line 1388: FROM fnd_lookups

1384: ( rounding_level_code IS NULL
1385: AND rounding_level_name IS NOT NULL
1386: AND NOT EXISTS
1387: ( SELECT 1
1388: FROM fnd_lookups
1389: WHERE lookup_type = 'ZX_ROUNDING_LEVEL'
1390: AND NVL(start_date_active, SYSDATE) <= SYSDATE
1391: AND NVL(end_date_active, SYSDATE) >= SYSDATE
1392: AND NVL(enabled_flag, 'N') = 'Y'

Line 1410: FROM fnd_lookups

1406: UPDATE zx_party_tax_profile_int ptp_int
1407: SET rounding_level_code =
1408: (
1409: SELECT lookup_code
1410: FROM fnd_lookups
1411: WHERE lookup_type = 'ZX_ROUNDING_LEVEL'
1412: AND NVL(start_date_active, SYSDATE) <= SYSDATE
1413: AND NVL(end_date_active, SYSDATE) >= SYSDATE
1414: AND NVL(enabled_flag, 'N') = 'Y'

Line 1435: FROM fnd_lookups

1431: WHERE (( rounding_rule_code IS NOT NULL
1432: AND NOT EXISTS
1433: (
1434: SELECT 1
1435: FROM fnd_lookups
1436: WHERE lookup_type = 'ZX_ROUNDING_RULE'
1437: AND NVL(start_date_active, SYSDATE) <= SYSDATE
1438: AND NVL(end_date_active, SYSDATE) >= SYSDATE
1439: AND NVL(enabled_flag, 'N') = 'Y'

Line 1448: FROM fnd_lookups

1444: ( rounding_rule_code IS NULL
1445: AND rounding_rule_name IS NOT NULL
1446: AND NOT EXISTS
1447: ( SELECT 1
1448: FROM fnd_lookups
1449: WHERE lookup_type = 'ZX_ROUNDING_RULE'
1450: AND NVL(start_date_active, SYSDATE) <= SYSDATE
1451: AND NVL(end_date_active, SYSDATE) >= SYSDATE
1452: AND NVL(enabled_flag, 'N') = 'Y'

Line 1469: FROM fnd_lookups

1465: -- value to id conversion for rounding_rule_code
1466: UPDATE zx_party_tax_profile_int ptp_int
1467: SET rounding_rule_code = (
1468: SELECT lookup_code
1469: FROM fnd_lookups
1470: WHERE lookup_type = 'ZX_ROUNDING_RULE'
1471: AND NVL(start_date_active, SYSDATE) <= SYSDATE
1472: AND NVL(end_date_active, SYSDATE) >= SYSDATE
1473: AND NVL(enabled_flag, 'N') = 'Y'

Line 2979: FROM fnd_lookups fndlookup

2975: WHERE (( REGISTRATION_TYPE_CODE IS NOT NULL
2976: AND NOT EXISTS
2977: (
2978: SELECT 1
2979: FROM fnd_lookups fndlookup
2980: WHERE fndlookup.lookup_type = 'ZX_REGISTRATIONS_TYPE'
2981: AND NVL(fndlookup.start_date_active, SYSDATE) <= SYSDATE
2982: AND NVL(fndlookup.end_date_active, SYSDATE) >= SYSDATE
2983: AND NVL(fndlookup.enabled_flag, 'N') = 'Y'

Line 2992: FROM fnd_lookups fndlookup

2988: ( REGISTRATION_TYPE_CODE IS NULL
2989: AND REGISTRATION_TYPE_NAME IS NOT NULL
2990: AND NOT EXISTS
2991: ( SELECT 1
2992: FROM fnd_lookups fndlookup
2993: WHERE fndlookup.lookup_type = 'ZX_REGISTRATIONS_TYPE'
2994: AND NVL(fndlookup.start_date_active, SYSDATE) <= SYSDATE
2995: AND NVL(fndlookup.end_date_active, SYSDATE) >= SYSDATE
2996: AND NVL(fndlookup.enabled_flag, 'N') = 'Y'

Line 3013: FROM fnd_lookups fndlookup

3009: -- value to id conversion for registration_type_code
3010: UPDATE zx_registrations_int reg_int
3011: SET registration_type_code = (
3012: SELECT fndlookup.lookup_code
3013: FROM fnd_lookups fndlookup
3014: WHERE fndlookup.lookup_type = 'ZX_REGISTRATIONS_TYPE'
3015: AND NVL(fndlookup.start_date_active, SYSDATE) <= SYSDATE
3016: AND NVL(fndlookup.end_date_active, SYSDATE) >= SYSDATE
3017: AND NVL(fndlookup.enabled_flag, 'N') = 'Y'

Line 3038: FROM fnd_lookups fndlookup

3034: WHERE (( registration_status_code IS NOT NULL
3035: AND NOT EXISTS
3036: (
3037: SELECT 1
3038: FROM fnd_lookups fndlookup
3039: WHERE fndlookup.lookup_type = 'ZX_REGISTRATIONS_STATUS'
3040: AND NVL(fndlookup.start_date_active, SYSDATE) <= SYSDATE
3041: AND NVL(fndlookup.end_date_active, SYSDATE) >= SYSDATE
3042: AND NVL(fndlookup.enabled_flag, 'N') = 'Y'

Line 3051: FROM fnd_lookups fndlookup

3047: ( registration_status_code IS NULL
3048: AND registration_status_name IS NOT NULL
3049: AND NOT EXISTS
3050: ( SELECT 1
3051: FROM fnd_lookups fndlookup
3052: WHERE fndlookup.lookup_type = 'ZX_REGISTRATIONS_STATUS'
3053: AND NVL(fndlookup.start_date_active, SYSDATE) <= SYSDATE
3054: AND NVL(fndlookup.end_date_active, SYSDATE) >= SYSDATE
3055: AND NVL(fndlookup.enabled_flag, 'N') = 'Y'

Line 3072: FROM fnd_lookups fndlookup

3068: -- value to id conversion for registration_status_code
3069: UPDATE zx_registrations_int reg_int
3070: SET registration_status_code = (
3071: SELECT fndlookup.lookup_code
3072: FROM fnd_lookups fndlookup
3073: WHERE fndlookup.lookup_type = 'ZX_REGISTRATIONS_STATUS'
3074: AND NVL(fndlookup.start_date_active, SYSDATE) <= SYSDATE
3075: AND NVL(fndlookup.end_date_active, SYSDATE) >= SYSDATE
3076: AND NVL(fndlookup.enabled_flag, 'N') = 'Y'

Line 3097: FROM fnd_lookups fndlookup

3093: WHERE (( registration_source_code IS NOT NULL
3094: AND NOT EXISTS
3095: (
3096: SELECT 1
3097: FROM fnd_lookups fndlookup
3098: WHERE fndlookup.lookup_type = 'ZX_REGISTRATIONS_SOURCE'
3099: AND NVL(fndlookup.start_date_active, SYSDATE) <= SYSDATE
3100: AND NVL(fndlookup.end_date_active, SYSDATE) >= SYSDATE
3101: AND NVL(fndlookup.enabled_flag, 'N') = 'Y'

Line 3110: FROM fnd_lookups fndlookup

3106: ( registration_source_code IS NULL
3107: AND registration_source_name IS NOT NULL
3108: AND NOT EXISTS
3109: ( SELECT 1
3110: FROM fnd_lookups fndlookup
3111: WHERE fndlookup.lookup_type = 'ZX_REGISTRATIONS_SOURCE'
3112: AND NVL(fndlookup.start_date_active, SYSDATE) <= SYSDATE
3113: AND NVL(fndlookup.end_date_active, SYSDATE) >= SYSDATE
3114: AND NVL(fndlookup.enabled_flag, 'N') = 'Y'

Line 3131: FROM fnd_lookups fndlookup

3127: -- value to id conversion for registration_source_code
3128: UPDATE zx_registrations_int reg_int
3129: SET registration_source_code = (
3130: SELECT fndlookup.lookup_code
3131: FROM fnd_lookups fndlookup
3132: WHERE fndlookup.lookup_type = 'ZX_REGISTRATIONS_SOURCE'
3133: AND NVL(fndlookup.start_date_active, SYSDATE) <= SYSDATE
3134: AND NVL(fndlookup.end_date_active, SYSDATE) >= SYSDATE
3135: AND NVL(fndlookup.enabled_flag, 'N') = 'Y'

Line 3156: FROM fnd_lookups fndlookup

3152: WHERE (( registration_reason_code IS NOT NULL
3153: AND NOT EXISTS
3154: (
3155: SELECT 1
3156: FROM fnd_lookups fndlookup
3157: WHERE fndlookup.lookup_type = 'ZX_REGISTRATIONS_REASON'
3158: AND NVL(fndlookup.start_date_active, SYSDATE) <= SYSDATE
3159: AND NVL(fndlookup.end_date_active, SYSDATE) >= SYSDATE
3160: AND NVL(fndlookup.enabled_flag, 'N') = 'Y'

Line 3169: FROM fnd_lookups fndlookup

3165: ( registration_reason_code IS NULL
3166: AND registration_reason_name IS NOT NULL
3167: AND NOT EXISTS
3168: ( SELECT 1
3169: FROM fnd_lookups fndlookup
3170: WHERE fndlookup.lookup_type = 'ZX_REGISTRATIONS_REASON'
3171: AND NVL(fndlookup.start_date_active, SYSDATE) <= SYSDATE
3172: AND NVL(fndlookup.end_date_active, SYSDATE) >= SYSDATE
3173: AND NVL(fndlookup.enabled_flag, 'N') = 'Y'

Line 3190: FROM fnd_lookups fndlookup

3186: -- value to id conversion for registration_reason_code
3187: UPDATE zx_registrations_int reg_int
3188: SET registration_reason_code = (
3189: SELECT fndlookup.lookup_code
3190: FROM fnd_lookups fndlookup
3191: WHERE fndlookup.lookup_type = 'ZX_REGISTRATIONS_REASON'
3192: AND NVL(fndlookup.start_date_active, SYSDATE) <= SYSDATE
3193: AND NVL(fndlookup.end_date_active, SYSDATE) >= SYSDATE
3194: AND NVL(fndlookup.enabled_flag, 'N') = 'Y'

Line 3284: FROM fnd_lookups

3280: WHERE (( rounding_rule_code IS NOT NULL
3281: AND NOT EXISTS
3282: (
3283: SELECT 1
3284: FROM fnd_lookups
3285: WHERE lookup_type = 'ZX_ROUNDING_RULE'
3286: AND NVL(start_date_active, SYSDATE) <= SYSDATE
3287: AND NVL(end_date_active, SYSDATE) >= SYSDATE
3288: AND NVL(enabled_flag, 'N') = 'Y'

Line 3297: FROM fnd_lookups

3293: ( rounding_rule_code IS NULL
3294: AND rounding_rule_name IS NOT NULL
3295: AND NOT EXISTS
3296: ( SELECT 1
3297: FROM fnd_lookups
3298: WHERE lookup_type = 'ZX_ROUNDING_RULE'
3299: AND NVL(start_date_active, SYSDATE) <= SYSDATE
3300: AND NVL(end_date_active, SYSDATE) >= SYSDATE
3301: AND NVL(enabled_flag, 'N') = 'Y'

Line 3318: FROM fnd_lookups

3314: -- value to id conversion for rounding_rule_code
3315: UPDATE zx_registrations_int reg_int
3316: SET rounding_rule_code = (
3317: SELECT lookup_code
3318: FROM fnd_lookups
3319: WHERE lookup_type = 'ZX_ROUNDING_RULE'
3320: AND NVL(start_date_active, SYSDATE) <= SYSDATE
3321: AND NVL(end_date_active, SYSDATE) >= SYSDATE
3322: AND NVL(enabled_flag, 'N') = 'Y'

Line 4248: FROM fnd_lookups fndlookup

4244: WHERE (( exempt_reason_code IS NOT NULL
4245: AND NOT EXISTS
4246: (
4247: SELECT 1
4248: FROM fnd_lookups fndlookup
4249: WHERE fndlookup.lookup_type = 'ZX_EXEMPTION_REASON_CODE'
4250: AND NVL(fndlookup.start_date_active, SYSDATE) <= SYSDATE
4251: AND NVL(fndlookup.end_date_active, SYSDATE) >= SYSDATE
4252: AND NVL(fndlookup.enabled_flag, 'N') = 'Y'

Line 4261: FROM fnd_lookups fndlookup

4257: ( exempt_reason_code IS NULL
4258: AND exempt_reason_name IS NOT NULL
4259: AND NOT EXISTS
4260: ( SELECT 1
4261: FROM fnd_lookups fndlookup
4262: WHERE fndlookup.lookup_type = 'ZX_EXEMPTION_REASON_CODE'
4263: AND NVL(fndlookup.start_date_active, SYSDATE) <= SYSDATE
4264: AND NVL(fndlookup.end_date_active, SYSDATE) >= SYSDATE
4265: AND NVL(fndlookup.enabled_flag, 'N') = 'Y'

Line 4282: FROM fnd_lookups fndlookup

4278: -- value to id conversion for registration_reason_code
4279: UPDATE zx_exemptions_int exe_int
4280: SET exempt_reason_code = (
4281: SELECT fndlookup.lookup_code
4282: FROM fnd_lookups fndlookup
4283: WHERE fndlookup.lookup_type = 'ZX_EXEMPTION_REASON_CODE'
4284: AND NVL(fndlookup.start_date_active, SYSDATE) <= SYSDATE
4285: AND NVL(fndlookup.end_date_active, SYSDATE) >= SYSDATE
4286: AND NVL(fndlookup.enabled_flag, 'N') = 'Y'

Line 4307: FROM fnd_lookups fndlookup

4303: WHERE (( exemption_status_code IS NOT NULL
4304: AND NOT EXISTS
4305: (
4306: SELECT 1
4307: FROM fnd_lookups fndlookup
4308: WHERE fndlookup.lookup_type = 'ZX_EXEMPTION_STATUS'
4309: AND NVL(fndlookup.start_date_active, SYSDATE) <= SYSDATE
4310: AND NVL(fndlookup.end_date_active, SYSDATE) >= SYSDATE
4311: AND NVL(fndlookup.enabled_flag, 'N') = 'Y'

Line 4320: FROM fnd_lookups fndlookup

4316: ( exemption_status_code IS NULL
4317: AND exemption_status_name IS NOT NULL
4318: AND NOT EXISTS
4319: ( SELECT 1
4320: FROM fnd_lookups fndlookup
4321: WHERE fndlookup.lookup_type = 'ZX_EXEMPTION_STATUS'
4322: AND NVL(fndlookup.start_date_active, SYSDATE) <= SYSDATE
4323: AND NVL(fndlookup.end_date_active, SYSDATE) >= SYSDATE
4324: AND NVL(fndlookup.enabled_flag, 'N') = 'Y'

Line 4341: FROM fnd_lookups fndlookup

4337: -- value to id conversion for exempt_status_code
4338: UPDATE zx_exemptions_int exe_int
4339: SET exemption_status_code = (
4340: SELECT fndlookup.lookup_code
4341: FROM fnd_lookups fndlookup
4342: WHERE fndlookup.lookup_type = 'ZX_EXEMPTION_STATUS'
4343: AND NVL(fndlookup.start_date_active, SYSDATE) <= SYSDATE
4344: AND NVL(fndlookup.end_date_active, SYSDATE) >= SYSDATE
4345: AND NVL(fndlookup.enabled_flag, 'N') = 'Y'

Line 4419: fnd_lookups LKP,

4415: AND NOT EXISTS
4416: (
4417: SELECT 1
4418: FROM zx_first_party_orgs_moac_v fpo,
4419: fnd_lookups LKP,
4420: zx_regimes_usages REG
4421: WHERE fpo.party_tax_profile_id <> -99
4422: AND lkp.lookup_type = 'ZX_PTP_PARTY_TYPE'
4423: AND lkp.lookup_code = fpo.party_type_code

Line 4439: fnd_lookups lkp,

4435: AND NOT EXISTS
4436: (
4437: SELECT 1
4438: FROM zx_first_party_orgs_moac_v fpo,
4439: fnd_lookups lkp,
4440: zx_regimes_usages reg
4441: WHERE fpo.party_tax_profile_id <> -99
4442: AND lkp.lookup_type = 'ZX_PTP_PARTY_TYPE'
4443: AND lkp.lookup_code = fpo.party_type_code

Line 4467: fnd_lookups lkp,

4463: UPDATE zx_exemptions_int exe_int
4464: SET content_owner_id = (
4465: SELECT fpo.party_tax_profile_id
4466: FROM zx_first_party_orgs_moac_v fpo,
4467: fnd_lookups lkp,
4468: zx_regimes_usages reg
4469: WHERE FPO.party_tax_profile_id <> -99
4470: AND lkp.lookup_type = 'ZX_PTP_PARTY_TYPE'
4471: AND lkp.lookup_code = fpo.party_type_code

Line 5121: FROM fnd_lookups fndlookup

5117: WHERE (( exemption_type_code IS NOT NULL
5118: AND NOT EXISTS
5119: (
5120: SELECT 1
5121: FROM fnd_lookups fndlookup
5122: WHERE fndlookup.lookup_type = 'ZX_EXEMPTION_TYPE'
5123: AND NVL(fndlookup.start_date_active, SYSDATE) <= SYSDATE
5124: AND NVL(fndlookup.end_date_active, SYSDATE) >= SYSDATE
5125: AND NVL(fndlookup.enabled_flag, 'N') = 'Y'

Line 5135: FROM fnd_lookups fndlookup

5131: AND exemption_type_name IS NOT NULL
5132: AND NOT EXISTS
5133: (
5134: SELECT 1
5135: FROM fnd_lookups fndlookup
5136: WHERE fndlookup.lookup_type = 'ZX_EXEMPTION_TYPE'
5137: AND NVL(fndlookup.start_date_active, SYSDATE) <= SYSDATE
5138: AND NVL(fndlookup.end_date_active, SYSDATE) >= SYSDATE
5139: AND NVL(fndlookup.enabled_flag, 'N') = 'Y'

Line 5156: FROM fnd_lookups fndlookup

5152: -- value to id conversion for exemption_type_code
5153: UPDATE zx_exemptions_int exe_int
5154: SET exemption_type_code = (
5155: SELECT fndlookup.lookup_code
5156: FROM fnd_lookups fndlookup
5157: WHERE fndlookup.lookup_type = 'ZX_EXEMPTION_TYPE'
5158: AND NVL(fndlookup.start_date_active, SYSDATE) <= SYSDATE
5159: AND NVL(fndlookup.end_date_active, SYSDATE) >= SYSDATE
5160: AND NVL(fndlookup.enabled_flag, 'N') = 'Y'