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 8500: INSERT INTO FND_LOOKUP_VALUES

8496: |
8497: +==========================================================================*/
8498: PROCEDURE migrate_fnd_lookups AS
8499: BEGIN
8500: INSERT INTO FND_LOOKUP_VALUES
8501: (
8502: LOOKUP_TYPE ,
8503: LANGUAGE ,
8504: LOOKUP_CODE ,

Line 8573: FROM FND_LOOKUP_VALUES ap_lookups

8569: fnd_global.user_id ,
8570: SYSDATE ,
8571: fnd_global.user_id ,
8572: fnd_global.conc_login_id
8573: FROM FND_LOOKUP_VALUES ap_lookups
8574: WHERE ap_lookups.LOOKUP_TYPE = 'TAX TYPE'
8575: AND NOT EXISTS
8576: (select 1 from FND_LOOKUP_VALUES
8577: where lookup_type = 'ZX_TAX_TYPE_CATEGORY'

Line 8576: (select 1 from FND_LOOKUP_VALUES

8572: fnd_global.conc_login_id
8573: FROM FND_LOOKUP_VALUES ap_lookups
8574: WHERE ap_lookups.LOOKUP_TYPE = 'TAX TYPE'
8575: AND NOT EXISTS
8576: (select 1 from FND_LOOKUP_VALUES
8577: where lookup_type = 'ZX_TAX_TYPE_CATEGORY'
8578: and lookup_code = ap_lookups.lookup_code
8579: and view_application_id = ap_lookups.view_application_id
8580: and meaning = ap_lookups.meaning

Line 8622: FROM FND_LOOKUP_VALUES ar_lookups

8618: fnd_global.user_id ,
8619: SYSDATE ,
8620: fnd_global.user_id ,
8621: fnd_global.conc_login_id
8622: FROM FND_LOOKUP_VALUES ar_lookups
8623: WHERE ar_lookups.LOOKUP_TYPE = 'TAX_TYPE'
8624: /* AND NOT EXISTS
8625: (select 1 from FND_LOOKUP_VALUES
8626: where lookup_type = 'ZX_TAX_TYPE_CATEGORY'

Line 8625: (select 1 from FND_LOOKUP_VALUES

8621: fnd_global.conc_login_id
8622: FROM FND_LOOKUP_VALUES ar_lookups
8623: WHERE ar_lookups.LOOKUP_TYPE = 'TAX_TYPE'
8624: /* AND NOT EXISTS
8625: (select 1 from FND_LOOKUP_VALUES
8626: where lookup_type = 'ZX_TAX_TYPE_CATEGORY'
8627: and lookup_code = ar_lookups.lookup_code
8628: and view_application_id = ar_lookups.view_application_id
8629: and meaning = ar_lookups.meaning

Line 8634: (select 1 from FND_LOOKUP_VALUES

8630: and security_group_id = ar_lookups.security_group_id
8631: and language = ar_lookups.language);*/
8632: -- Changed the re-runnability check
8633: AND NOT EXISTS
8634: (select 1 from FND_LOOKUP_VALUES
8635: where lookup_type = 'ZX_TAX_TYPE_CATEGORY'
8636: and lookup_code = ar_lookups.lookup_code)
8637: and NOT EXISTS
8638: (select 1 from FND_LOOKUP_VALUES

Line 8638: (select 1 from FND_LOOKUP_VALUES

8634: (select 1 from FND_LOOKUP_VALUES
8635: where lookup_type = 'ZX_TAX_TYPE_CATEGORY'
8636: and lookup_code = ar_lookups.lookup_code)
8637: and NOT EXISTS
8638: (select 1 from FND_LOOKUP_VALUES
8639: where lookup_type = 'ZX_TAX_TYPE_CATEGORY'
8640: and meaning = ar_lookups.meaning) ;
8641:
8642: --Bug 5517908 : Creating the AR lookupcodes with Meaning as MEANING||' '||LOOKUP_CODE

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

8639: where lookup_type = 'ZX_TAX_TYPE_CATEGORY'
8640: and meaning = ar_lookups.meaning) ;
8641:
8642: --Bug 5517908 : Creating the AR lookupcodes with Meaning as MEANING||' '||LOOKUP_CODE
8643: -- to avoid the FND_LOOKUP_VALUES_U2 violation when ap and ar lookup codes have the same meaning with different lookup_codes.
8644:
8645: INSERT INTO FND_LOOKUP_VALUES
8646: (
8647: LOOKUP_TYPE ,

Line 8645: INSERT INTO FND_LOOKUP_VALUES

8641:
8642: --Bug 5517908 : Creating the AR lookupcodes with Meaning as MEANING||' '||LOOKUP_CODE
8643: -- to avoid the FND_LOOKUP_VALUES_U2 violation when ap and ar lookup codes have the same meaning with different lookup_codes.
8644:
8645: INSERT INTO FND_LOOKUP_VALUES
8646: (
8647: LOOKUP_TYPE ,
8648: LANGUAGE ,
8649: LOOKUP_CODE ,

Line 8717: FROM FND_LOOKUP_VALUES ar_lookups

8713: fnd_global.user_id ,
8714: SYSDATE ,
8715: fnd_global.user_id ,
8716: fnd_global.conc_login_id
8717: FROM FND_LOOKUP_VALUES ar_lookups
8718: WHERE ar_lookups.LOOKUP_TYPE = 'TAX_TYPE'
8719: -- Changed the re-runnability check
8720: AND NOT EXISTS
8721: (select 1 from FND_LOOKUP_VALUES

Line 8721: (select 1 from FND_LOOKUP_VALUES

8717: FROM FND_LOOKUP_VALUES ar_lookups
8718: WHERE ar_lookups.LOOKUP_TYPE = 'TAX_TYPE'
8719: -- Changed the re-runnability check
8720: AND NOT EXISTS
8721: (select 1 from FND_LOOKUP_VALUES
8722: where lookup_type = 'ZX_TAX_TYPE_CATEGORY'
8723: and lookup_code = ar_lookups.lookup_code)
8724: and EXISTS
8725: (select 1 from FND_LOOKUP_VALUES

Line 8725: (select 1 from FND_LOOKUP_VALUES

8721: (select 1 from FND_LOOKUP_VALUES
8722: where lookup_type = 'ZX_TAX_TYPE_CATEGORY'
8723: and lookup_code = ar_lookups.lookup_code)
8724: and EXISTS
8725: (select 1 from FND_LOOKUP_VALUES
8726: where lookup_type = 'ZX_TAX_TYPE_CATEGORY'
8727: and meaning = ar_lookups.meaning) ;
8728:
8729: EXCEPTION

Line 9012: INSERT INTO FND_LOOKUP_VALUES

9008: )
9009:
9010: LOOP
9011:
9012: INSERT INTO FND_LOOKUP_VALUES
9013: (
9014: LOOKUP_TYPE ,
9015: LANGUAGE ,
9016: LOOKUP_CODE ,

Line 9110: from fnd_lookup_values flv

9106: ) codes,fnd_languages fln
9107: where fln.installed_flag in ('I','B')
9108: AND NOT EXISTS
9109: (select 1
9110: from fnd_lookup_values flv
9111: where SUBSTRB(flv.lookup_code, 1, 24) = CASE WHEN LENGTHB(codes.lookup_code) > 30
9112: THEN SUBSTRB(codes.lookup_code, 1, 24)
9113: ELSE codes.lookup_code
9114: END

Line 9376: fnd_lookup_values flv,

9372: taxes.tax_id
9373: FROM
9374: zx_taxes_b taxes,
9375: zx_rates_b rates,
9376: fnd_lookup_values flv,
9377: ar_vat_tax_all_b ar_code
9378: WHERE
9379: taxes.CONTENT_OWNER_ID = rates.CONTENT_OWNER_ID
9380: AND taxes.TAX_REGIME_CODE = rates.TAX_REGIME_CODE

Line 9424: fnd_lookup_values flv,

9420: taxes.tax_id
9421: FROM
9422: zx_taxes_b taxes,
9423: zx_rates_b rates,
9424: fnd_lookup_values flv,
9425: ar_vat_tax_all_b ar_code
9426: WHERE
9427: taxes.CONTENT_OWNER_ID = rates.CONTENT_OWNER_ID
9428: AND taxes.TAX_REGIME_CODE = rates.TAX_REGIME_CODE

Line 9471: fnd_lookup_values flv,

9467: taxes.tax_id
9468: FROM
9469: zx_taxes_b taxes,
9470: zx_rates_b rates,
9471: fnd_lookup_values flv,
9472: ar_vat_tax_all_b ar_code
9473: WHERE
9474: taxes.CONTENT_OWNER_ID = rates.CONTENT_OWNER_ID
9475: AND taxes.TAX_REGIME_CODE = rates.TAX_REGIME_CODE

Line 9791: fnd_lookup_values flv

9787: userenv('LANG')
9788: from zx_rates_b rates,
9789: zx_status_b status,
9790: ar_vat_tax_all_b codes,
9791: fnd_lookup_values flv
9792: where rates.tax_regime_code = status.tax_regime_code
9793: and rates.tax = status.tax
9794: and rates.tax_status_code = status.tax_status_code
9795: and rates.content_owner_id = status.content_owner_id