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

Line 8488: INSERT INTO FND_LOOKUP_VALUES

8484: |
8485: +==========================================================================*/
8486: PROCEDURE migrate_fnd_lookups AS
8487: BEGIN
8488: INSERT INTO FND_LOOKUP_VALUES
8489: (
8490: LOOKUP_TYPE ,
8491: LANGUAGE ,
8492: LOOKUP_CODE ,

Line 8561: FROM FND_LOOKUP_VALUES ap_lookups

8557: fnd_global.user_id ,
8558: SYSDATE ,
8559: fnd_global.user_id ,
8560: fnd_global.conc_login_id
8561: FROM FND_LOOKUP_VALUES ap_lookups
8562: WHERE ap_lookups.LOOKUP_TYPE = 'TAX TYPE'
8563: AND NOT EXISTS
8564: (select 1 from FND_LOOKUP_VALUES
8565: where lookup_type = 'ZX_TAX_TYPE_CATEGORY'

Line 8564: (select 1 from FND_LOOKUP_VALUES

8560: fnd_global.conc_login_id
8561: FROM FND_LOOKUP_VALUES ap_lookups
8562: WHERE ap_lookups.LOOKUP_TYPE = 'TAX TYPE'
8563: AND NOT EXISTS
8564: (select 1 from FND_LOOKUP_VALUES
8565: where lookup_type = 'ZX_TAX_TYPE_CATEGORY'
8566: and lookup_code = ap_lookups.lookup_code
8567: and view_application_id = ap_lookups.view_application_id
8568: and meaning = ap_lookups.meaning

Line 8610: FROM FND_LOOKUP_VALUES ar_lookups

8606: fnd_global.user_id ,
8607: SYSDATE ,
8608: fnd_global.user_id ,
8609: fnd_global.conc_login_id
8610: FROM FND_LOOKUP_VALUES ar_lookups
8611: WHERE ar_lookups.LOOKUP_TYPE = 'TAX_TYPE'
8612: /* AND NOT EXISTS
8613: (select 1 from FND_LOOKUP_VALUES
8614: where lookup_type = 'ZX_TAX_TYPE_CATEGORY'

Line 8613: (select 1 from FND_LOOKUP_VALUES

8609: fnd_global.conc_login_id
8610: FROM FND_LOOKUP_VALUES ar_lookups
8611: WHERE ar_lookups.LOOKUP_TYPE = 'TAX_TYPE'
8612: /* AND NOT EXISTS
8613: (select 1 from FND_LOOKUP_VALUES
8614: where lookup_type = 'ZX_TAX_TYPE_CATEGORY'
8615: and lookup_code = ar_lookups.lookup_code
8616: and view_application_id = ar_lookups.view_application_id
8617: and meaning = ar_lookups.meaning

Line 8622: (select 1 from FND_LOOKUP_VALUES

8618: and security_group_id = ar_lookups.security_group_id
8619: and language = ar_lookups.language);*/
8620: -- Changed the re-runnability check
8621: AND NOT EXISTS
8622: (select 1 from FND_LOOKUP_VALUES
8623: where lookup_type = 'ZX_TAX_TYPE_CATEGORY'
8624: and lookup_code = ar_lookups.lookup_code)
8625: and NOT EXISTS
8626: (select 1 from FND_LOOKUP_VALUES

Line 8626: (select 1 from FND_LOOKUP_VALUES

8622: (select 1 from FND_LOOKUP_VALUES
8623: where lookup_type = 'ZX_TAX_TYPE_CATEGORY'
8624: and lookup_code = ar_lookups.lookup_code)
8625: and NOT EXISTS
8626: (select 1 from FND_LOOKUP_VALUES
8627: where lookup_type = 'ZX_TAX_TYPE_CATEGORY'
8628: and meaning = ar_lookups.meaning) ;
8629:
8630: --Bug 5517908 : Creating the AR lookupcodes with Meaning as MEANING||' '||LOOKUP_CODE

Line 8631: -- to avoid the FND_LOOKUP_VALUES_U2 violation when ap and ar lookup codes have the same meaning with different lookup_codes.

8627: where lookup_type = 'ZX_TAX_TYPE_CATEGORY'
8628: and meaning = ar_lookups.meaning) ;
8629:
8630: --Bug 5517908 : Creating the AR lookupcodes with Meaning as MEANING||' '||LOOKUP_CODE
8631: -- to avoid the FND_LOOKUP_VALUES_U2 violation when ap and ar lookup codes have the same meaning with different lookup_codes.
8632:
8633: INSERT INTO FND_LOOKUP_VALUES
8634: (
8635: LOOKUP_TYPE ,

Line 8633: INSERT INTO FND_LOOKUP_VALUES

8629:
8630: --Bug 5517908 : Creating the AR lookupcodes with Meaning as MEANING||' '||LOOKUP_CODE
8631: -- to avoid the FND_LOOKUP_VALUES_U2 violation when ap and ar lookup codes have the same meaning with different lookup_codes.
8632:
8633: INSERT INTO FND_LOOKUP_VALUES
8634: (
8635: LOOKUP_TYPE ,
8636: LANGUAGE ,
8637: LOOKUP_CODE ,

Line 8705: FROM FND_LOOKUP_VALUES ar_lookups

8701: fnd_global.user_id ,
8702: SYSDATE ,
8703: fnd_global.user_id ,
8704: fnd_global.conc_login_id
8705: FROM FND_LOOKUP_VALUES ar_lookups
8706: WHERE ar_lookups.LOOKUP_TYPE = 'TAX_TYPE'
8707: -- Changed the re-runnability check
8708: AND NOT EXISTS
8709: (select 1 from FND_LOOKUP_VALUES

Line 8709: (select 1 from FND_LOOKUP_VALUES

8705: FROM FND_LOOKUP_VALUES ar_lookups
8706: WHERE ar_lookups.LOOKUP_TYPE = 'TAX_TYPE'
8707: -- Changed the re-runnability check
8708: AND NOT EXISTS
8709: (select 1 from FND_LOOKUP_VALUES
8710: where lookup_type = 'ZX_TAX_TYPE_CATEGORY'
8711: and lookup_code = ar_lookups.lookup_code)
8712: and EXISTS
8713: (select 1 from FND_LOOKUP_VALUES

Line 8713: (select 1 from FND_LOOKUP_VALUES

8709: (select 1 from FND_LOOKUP_VALUES
8710: where lookup_type = 'ZX_TAX_TYPE_CATEGORY'
8711: and lookup_code = ar_lookups.lookup_code)
8712: and EXISTS
8713: (select 1 from FND_LOOKUP_VALUES
8714: where lookup_type = 'ZX_TAX_TYPE_CATEGORY'
8715: and meaning = ar_lookups.meaning) ;
8716:
8717: EXCEPTION

Line 9000: INSERT INTO FND_LOOKUP_VALUES

8996: )
8997:
8998: LOOP
8999:
9000: INSERT INTO FND_LOOKUP_VALUES
9001: (
9002: LOOKUP_TYPE ,
9003: LANGUAGE ,
9004: LOOKUP_CODE ,

Line 9098: from fnd_lookup_values flv

9094: ) codes,fnd_languages fln
9095: where fln.installed_flag in ('I','B')
9096: AND NOT EXISTS
9097: (select 1
9098: from fnd_lookup_values flv
9099: where SUBSTRB(flv.lookup_code, 1, 24) = CASE WHEN LENGTHB(codes.lookup_code) > 30
9100: THEN SUBSTRB(codes.lookup_code, 1, 24)
9101: ELSE codes.lookup_code
9102: END

Line 9364: fnd_lookup_values flv,

9360: taxes.tax_id
9361: FROM
9362: zx_taxes_b taxes,
9363: zx_rates_b rates,
9364: fnd_lookup_values flv,
9365: ar_vat_tax_all_b ar_code
9366: WHERE
9367: taxes.CONTENT_OWNER_ID = rates.CONTENT_OWNER_ID
9368: AND taxes.TAX_REGIME_CODE = rates.TAX_REGIME_CODE

Line 9412: fnd_lookup_values flv,

9408: taxes.tax_id
9409: FROM
9410: zx_taxes_b taxes,
9411: zx_rates_b rates,
9412: fnd_lookup_values flv,
9413: ar_vat_tax_all_b ar_code
9414: WHERE
9415: taxes.CONTENT_OWNER_ID = rates.CONTENT_OWNER_ID
9416: AND taxes.TAX_REGIME_CODE = rates.TAX_REGIME_CODE

Line 9459: fnd_lookup_values flv,

9455: taxes.tax_id
9456: FROM
9457: zx_taxes_b taxes,
9458: zx_rates_b rates,
9459: fnd_lookup_values flv,
9460: ar_vat_tax_all_b ar_code
9461: WHERE
9462: taxes.CONTENT_OWNER_ID = rates.CONTENT_OWNER_ID
9463: AND taxes.TAX_REGIME_CODE = rates.TAX_REGIME_CODE

Line 9779: fnd_lookup_values flv

9775: userenv('LANG')
9776: from zx_rates_b rates,
9777: zx_status_b status,
9778: ar_vat_tax_all_b codes,
9779: fnd_lookup_values flv
9780: where rates.tax_regime_code = status.tax_regime_code
9781: and rates.tax = status.tax
9782: and rates.tax_status_code = status.tax_status_code
9783: and rates.content_owner_id = status.content_owner_id