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 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 92


   UPDATE FND_LOOKUP_TYPES
   SET    CUSTOMIZATION_LEVEL = 'S'
   WHERE  lookup_type in (
        'TAX_CONDITION_TYPE',
        'TAX_CONDITION_OPERATOR',
        'TAX_CONDITION_FIELD',
        'TAX_CONDITION_ENTITY',
        'TAX_CONDITION_CLAUSE',
        'TAX_CONDITION_ACTION_TYPE',
        'TAX_CONDITION_ACTION_CODE',
        'TAX_CONDITION_VALUE',
        'AR_TAX_CLASSIFICATION')
   AND  CUSTOMIZATION_LEVEL = 'E'
   AND  APPLICATION_ID = 222;

Line: 157


INSERT ALL
WHEN (NOT EXISTS
      (SELECT 1 FROM FND_LOOKUP_TYPES
       WHERE LOOKUP_TYPE = 'ZX_CONDITION_TYPE'
         AND APPLICATION_ID = 235)
      ) THEN
INTO FND_LOOKUP_TYPES
(
 APPLICATION_ID         ,
 LOOKUP_TYPE            ,
 CUSTOMIZATION_LEVEL    ,
 SECURITY_GROUP_ID      ,
 VIEW_APPLICATION_ID    ,
 CREATION_DATE          ,
 CREATED_BY             ,
 LAST_UPDATE_DATE       ,
 LAST_UPDATED_BY        ,
 LAST_UPDATE_LOGIN
)
VALUES
(
 235                    ,
'ZX_CONDITION_TYPE'      ,
'S'                      ,
 0                       ,
 0                       ,
 SYSDATE                 ,
 fnd_global.user_id      ,
 SYSDATE                 ,
 fnd_global.user_id      ,
 fnd_global.conc_login_id
)
WHEN (NOT EXISTS
      (SELECT 1 FROM FND_LOOKUP_TYPES
       WHERE LOOKUP_TYPE = 'ZX_CONDITION_OPERATOR'
         AND APPLICATION_ID = 235)
      ) THEN
INTO FND_LOOKUP_TYPES
(
 APPLICATION_ID         ,
 LOOKUP_TYPE            ,
 CUSTOMIZATION_LEVEL    ,
 SECURITY_GROUP_ID      ,
 VIEW_APPLICATION_ID    ,
 CREATION_DATE          ,
 CREATED_BY             ,
 LAST_UPDATE_DATE       ,
 LAST_UPDATED_BY        ,
 LAST_UPDATE_LOGIN
)
VALUES
(
 235                    ,
'ZX_CONDITION_OPERATOR' ,
'S'                      ,
 0                       ,
 0                    ,
 SYSDATE                 ,
 fnd_global.user_id      ,
 SYSDATE                 ,
 fnd_global.user_id      ,
 fnd_global.conc_login_id
)
WHEN (NOT EXISTS
      (SELECT 1 FROM FND_LOOKUP_TYPES
       WHERE LOOKUP_TYPE = 'ZX_CONDITION_FIELD'
         AND APPLICATION_ID = 235)
      ) THEN
INTO FND_LOOKUP_TYPES
(
 APPLICATION_ID         ,
 LOOKUP_TYPE            ,
 CUSTOMIZATION_LEVEL    ,
 SECURITY_GROUP_ID      ,
 VIEW_APPLICATION_ID    ,
 CREATION_DATE          ,
 CREATED_BY             ,
 LAST_UPDATE_DATE       ,
 LAST_UPDATED_BY        ,
 LAST_UPDATE_LOGIN
)
VALUES
(
 235                    ,
'ZX_CONDITION_FIELD' ,
'S'                      ,
 0                       ,
 0                       ,
 SYSDATE                 ,
 fnd_global.user_id      ,
 SYSDATE                 ,
 fnd_global.user_id      ,
 fnd_global.conc_login_id
)
WHEN (NOT EXISTS
      (SELECT 1 FROM FND_LOOKUP_TYPES
       WHERE LOOKUP_TYPE = 'ZX_CONDITION_ENTITY'
         AND APPLICATION_ID = 235)
      ) THEN
INTO FND_LOOKUP_TYPES
(
 APPLICATION_ID         ,
 LOOKUP_TYPE            ,
 CUSTOMIZATION_LEVEL    ,
 SECURITY_GROUP_ID      ,
 VIEW_APPLICATION_ID    ,
 CREATION_DATE          ,
 CREATED_BY             ,
 LAST_UPDATE_DATE       ,
 LAST_UPDATED_BY        ,
 LAST_UPDATE_LOGIN
)
VALUES
(
 235                    ,
'ZX_CONDITION_ENTITY' ,
'S'                      ,
 0                       ,
 0                       ,
 SYSDATE                 ,
 fnd_global.user_id      ,
 SYSDATE                 ,
 fnd_global.user_id      ,
 fnd_global.conc_login_id
)
WHEN (NOT EXISTS
      (SELECT 1 FROM FND_LOOKUP_TYPES
       WHERE LOOKUP_TYPE = 'ZX_CONDITION_CLAUSE'
         AND APPLICATION_ID = 235)
      ) THEN
INTO FND_LOOKUP_TYPES
(
 APPLICATION_ID         ,
 LOOKUP_TYPE            ,
 CUSTOMIZATION_LEVEL    ,
 SECURITY_GROUP_ID      ,
 VIEW_APPLICATION_ID    ,
 CREATION_DATE          ,
 CREATED_BY             ,
 LAST_UPDATE_DATE       ,
 LAST_UPDATED_BY        ,
 LAST_UPDATE_LOGIN
)
VALUES
(
 235                    ,
'ZX_CONDITION_CLAUSE'    ,
'S'                      ,
 0                       ,
 0                       ,
 SYSDATE                 ,
 fnd_global.user_id      ,
 SYSDATE                 ,
 fnd_global.user_id      ,
 fnd_global.conc_login_id
)
WHEN (NOT EXISTS
      (SELECT 1 FROM FND_LOOKUP_TYPES
       WHERE LOOKUP_TYPE = 'ZX_CONDITION_ACTION_TYPE'
         AND APPLICATION_ID = 235)
      ) THEN
INTO FND_LOOKUP_TYPES
(
 APPLICATION_ID         ,
 LOOKUP_TYPE            ,
 CUSTOMIZATION_LEVEL    ,
 SECURITY_GROUP_ID      ,
 VIEW_APPLICATION_ID    ,
 CREATION_DATE          ,
 CREATED_BY             ,
 LAST_UPDATE_DATE       ,
 LAST_UPDATED_BY        ,
 LAST_UPDATE_LOGIN
)
VALUES
(
 235                    ,
'ZX_CONDITION_ACTION_TYPE' ,
'S'                      ,
 0                       ,
 0                       ,
 SYSDATE                 ,
 fnd_global.user_id      ,
 SYSDATE                 ,
 fnd_global.user_id      ,
 fnd_global.conc_login_id
)
WHEN (NOT EXISTS
      (SELECT 1 FROM FND_LOOKUP_TYPES
       WHERE LOOKUP_TYPE = 'ZX_CONDITION_ACTION_CODE'
         AND APPLICATION_ID = 235)
      ) THEN
INTO FND_LOOKUP_TYPES
(
 APPLICATION_ID         ,
 LOOKUP_TYPE            ,
 CUSTOMIZATION_LEVEL    ,
 SECURITY_GROUP_ID      ,
 VIEW_APPLICATION_ID    ,
 CREATION_DATE          ,
 CREATED_BY             ,
 LAST_UPDATE_DATE       ,
 LAST_UPDATED_BY        ,
 LAST_UPDATE_LOGIN
)
VALUES
(
 235                   ,
'ZX_CONDITION_ACTION_CODE' ,
'S'                      ,
 0                       ,
 0                       ,
 SYSDATE                 ,
 fnd_global.user_id      ,
 SYSDATE                 ,
 fnd_global.user_id      ,
 fnd_global.conc_login_id
)
WHEN (NOT EXISTS
      (SELECT 1 FROM FND_LOOKUP_TYPES
       WHERE LOOKUP_TYPE = 'ZX_CONDITION_VALUE'
         AND APPLICATION_ID = 235)
      ) THEN
INTO FND_LOOKUP_TYPES
(
 APPLICATION_ID         ,
 LOOKUP_TYPE            ,
 CUSTOMIZATION_LEVEL    ,
 SECURITY_GROUP_ID      ,
 VIEW_APPLICATION_ID    ,
 CREATION_DATE          ,
 CREATED_BY             ,
 LAST_UPDATE_DATE       ,
 LAST_UPDATED_BY        ,
 LAST_UPDATE_LOGIN
)
VALUES
(
 235                     ,
'ZX_CONDITION_VALUE'     ,
'E'                      ,
 0                       ,
 0                       ,
 SYSDATE                 ,
 fnd_global.user_id      ,
 SYSDATE                 ,
 fnd_global.user_id      ,
 fnd_global.conc_login_id
)
WHEN (NOT EXISTS
      (SELECT 1 FROM FND_LOOKUP_TYPES
       WHERE LOOKUP_TYPE = 'ZX_TAX_CLASSIFICATION'
         AND APPLICATION_ID = 235)
      ) THEN
INTO FND_LOOKUP_TYPES
(
 APPLICATION_ID         ,
 LOOKUP_TYPE            ,
 CUSTOMIZATION_LEVEL    ,
 SECURITY_GROUP_ID      ,
 VIEW_APPLICATION_ID    ,
 CREATION_DATE          ,
 CREATED_BY             ,
 LAST_UPDATE_DATE       ,
 LAST_UPDATED_BY        ,
 LAST_UPDATE_LOGIN
)
VALUES
(
 235                    ,
'ZX_TAX_CLASSIFICATION'  ,
'E'                      ,
 0                       ,
 0                       ,
 SYSDATE                 ,
 fnd_global.user_id      ,
 SYSDATE                 ,
 fnd_global.user_id      ,
 fnd_global.conc_login_id
)
SELECT 1  FROM DUAL;

Line: 444


INSERT INTO FND_LOOKUP_TYPES_TL
(
            LOOKUP_TYPE,
            SECURITY_GROUP_ID,
            VIEW_APPLICATION_ID,
            LANGUAGE,
            SOURCE_LANG,
            MEANING,
            DESCRIPTION,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
)
SELECT
            types.lookup_type,
            0                ,--SECURITY_GROUP_ID
            0                ,--VIEW_APPLICATION_ID
            L.LANGUAGE_CODE  ,
            userenv('LANG')  ,
            Initcap(types.lookup_type),--MEANING
            types.lookup_type,--DESCRIPTION
            fnd_global.user_id             ,
            SYSDATE                        ,
            fnd_global.user_id             ,
            SYSDATE                        ,
            fnd_global.conc_login_id
FROM        FND_LOOKUP_TYPES types,
            FND_LANGUAGES L
WHERE  L.INSTALLED_FLAG in ('I', 'B')
AND    types.lookup_type in (
        'ZX_CONDITION_TYPE',
        'ZX_CONDITION_OPERATOR',
        'ZX_CONDITION_FIELD',
        'ZX_CONDITION_ENTITY',
        'ZX_CONDITION_CLAUSE',
        'ZX_CONDITION_ACTION_TYPE',
        'ZX_CONDITION_ACTION_CODE',
        'ZX_CONDITION_VALUE',
        'ZX_TAX_CLASSIFICATION')
AND    not exists
       (select 1
        from   fnd_lookup_types_tl sub
        where  sub.lookup_type = types.lookup_type
        and    sub.security_group_id = 0
        and    sub.view_application_id = 0
        and    sub.language = l.language_code);

Line: 498


/* Insert lookup codes for the lookup types */
INSERT INTO FND_LOOKUP_VALUES
(
      LOOKUP_TYPE            ,
      LANGUAGE               ,
      LOOKUP_CODE            ,
      MEANING                ,
      DESCRIPTION            ,
      ENABLED_FLAG           ,
      START_DATE_ACTIVE      ,
      END_DATE_ACTIVE        ,
      SOURCE_LANG            ,
      SECURITY_GROUP_ID      ,
      VIEW_APPLICATION_ID    ,
      TERRITORY_CODE         ,
      ATTRIBUTE_CATEGORY     ,
      ATTRIBUTE1             ,
      ATTRIBUTE2             ,
      ATTRIBUTE3             ,
      ATTRIBUTE4             ,
      ATTRIBUTE5             ,
      ATTRIBUTE6             ,
      ATTRIBUTE7             ,
      ATTRIBUTE8             ,
      ATTRIBUTE9             ,
      ATTRIBUTE10            ,
      ATTRIBUTE11            ,
      ATTRIBUTE12            ,
      ATTRIBUTE13            ,
      ATTRIBUTE14            ,
      ATTRIBUTE15            ,
      TAG                    ,
      CREATION_DATE          ,
      CREATED_BY             ,
      LAST_UPDATE_DATE       ,
      LAST_UPDATED_BY        ,
      LAST_UPDATE_LOGIN
)
SELECT
     'ZX_CONDITION_TYPE',
      l.language_code , -- LANGUAGE
      lk.LOOKUP_CODE             ,
      lk.MEANING                 ,
      lk.DESCRIPTION             ,
      'Y'                     ,--ENABLED_FLAG
      lk.START_DATE_ACTIVE       ,
      NULL                    ,--END_DATE_ACTIVE
      userenv('LANG')         ,--SOURCE_LANG
      0                       ,--SECURITY_GROUP_ID
      0                       ,--VIEW_APPLICATION_ID
      NULL                    ,--TERRITORY_CODE
      NULL                    ,--ATTRIBUTE_CATEGORY
      NULL                    ,--ATTRIBUTE1
      NULL                    ,--ATTRIBUTE2
      NULL                    ,--ATTRIBUTE3
      NULL                    ,--ATTRIBUTE4
      NULL                    ,--ATTRIBUTE5
      NULL                    ,--ATTRIBUTE6
      NULL                    ,--ATTRIBUTE7
      NULL                    ,--ATTRIBUTE8
      NULL                    ,--ATTRIBUTE9
      NULL                    ,--ATTRIBUTE10
      NULL                    ,--ATTRIBUTE11
      NULL                    ,--ATTRIBUTE12
      NULL                    ,--ATTRIBUTE13
      NULL                    ,--ATTRIBUTE14
      NULL                    ,--ATTRIBUTE15
      NULL                    ,--TAG
      SYSDATE                 ,
      fnd_global.user_id      ,
      SYSDATE                 ,
      fnd_global.user_id      ,
      fnd_global.conc_login_id
   FROM  FND_LOOKUP_VALUES lk, FND_LANGUAGES l
   WHERE lk.lookup_type = 'TAX_CONDITION_TYPE'
	  AND view_application_id = 222
	  AND lk.language = 'US'
	  AND l.installed_flag in ('I', 'B')
	  AND not exists
	    (select '1'
	    from FND_LOOKUP_VALUES
	    where lookup_code = lk.lookup_code
	    and   lookup_type = 'ZX_CONDITION_TYPE'
	    and   language    = l.LANGUAGE_CODE);

Line: 583


/* Insert lookup codes for the lookup types */
INSERT INTO FND_LOOKUP_VALUES
(
      LOOKUP_TYPE            ,
      LANGUAGE               ,
      LOOKUP_CODE            ,
      MEANING                ,
      DESCRIPTION            ,
      ENABLED_FLAG           ,
      START_DATE_ACTIVE      ,
      END_DATE_ACTIVE        ,
      SOURCE_LANG            ,
      SECURITY_GROUP_ID      ,
      VIEW_APPLICATION_ID    ,
      TERRITORY_CODE         ,
      ATTRIBUTE_CATEGORY     ,
      ATTRIBUTE1             ,
      ATTRIBUTE2             ,
      ATTRIBUTE3             ,
      ATTRIBUTE4             ,
      ATTRIBUTE5             ,
      ATTRIBUTE6             ,
      ATTRIBUTE7             ,
      ATTRIBUTE8             ,
      ATTRIBUTE9             ,
      ATTRIBUTE10            ,
      ATTRIBUTE11            ,
      ATTRIBUTE12            ,
      ATTRIBUTE13            ,
      ATTRIBUTE14            ,
      ATTRIBUTE15            ,
      TAG                    ,
      CREATION_DATE          ,
      CREATED_BY             ,
      LAST_UPDATE_DATE       ,
      LAST_UPDATED_BY        ,
      LAST_UPDATE_LOGIN
)
SELECT
     'ZX_CONDITION_OPERATOR',
      l.language_code , -- LANGUAGE
      lk.LOOKUP_CODE             ,
      lk.MEANING                 ,
      lk.DESCRIPTION             ,
      'Y'                     ,--ENABLED_FLAG
      lk.START_DATE_ACTIVE       ,
      NULL                    ,--END_DATE_ACTIVE
      userenv('LANG')         ,--SOURCE_LANG
      0                       ,--SECURITY_GROUP_ID
      0                       ,--VIEW_APPLICATION_ID
      NULL                    ,--TERRITORY_CODE
      NULL                    ,--ATTRIBUTE_CATEGORY
      NULL                    ,--ATTRIBUTE1
      NULL                    ,--ATTRIBUTE2
      NULL                    ,--ATTRIBUTE3
      NULL                    ,--ATTRIBUTE4
      NULL                    ,--ATTRIBUTE5
      NULL                    ,--ATTRIBUTE6
      NULL                    ,--ATTRIBUTE7
      NULL                    ,--ATTRIBUTE8
      NULL                    ,--ATTRIBUTE9
      NULL                    ,--ATTRIBUTE10
      NULL                    ,--ATTRIBUTE11
      NULL                    ,--ATTRIBUTE12
      NULL                    ,--ATTRIBUTE13
      NULL                    ,--ATTRIBUTE14
      NULL                    ,--ATTRIBUTE15
      NULL                    ,--TAG
      SYSDATE                 ,
      fnd_global.user_id      ,
      SYSDATE                 ,
      fnd_global.user_id      ,
      fnd_global.conc_login_id
   FROM  FND_LOOKUP_VALUES lk, FND_LANGUAGES l
   WHERE lk.lookup_type = 'TAX_CONDITION_OPERATOR'
	  AND view_application_id = 222
	  AND lk.language = 'US'
	  AND l.installed_flag in ('I', 'B')
	  AND not exists
	    (select '1'
	    from FND_LOOKUP_VALUES
	    where lookup_code = lk.lookup_code
	    and   lookup_type = 'ZX_CONDITION_OPERATOR'
	    and   language    = l.LANGUAGE_CODE);

Line: 668


/* Insert lookup codes for the lookup types */
INSERT INTO FND_LOOKUP_VALUES
(
      LOOKUP_TYPE            ,
      LANGUAGE               ,
      LOOKUP_CODE            ,
      MEANING                ,
      DESCRIPTION            ,
      ENABLED_FLAG           ,
      START_DATE_ACTIVE      ,
      END_DATE_ACTIVE        ,
      SOURCE_LANG            ,
      SECURITY_GROUP_ID      ,
      VIEW_APPLICATION_ID    ,
      TERRITORY_CODE         ,
      ATTRIBUTE_CATEGORY     ,
      ATTRIBUTE1             ,
      ATTRIBUTE2             ,
      ATTRIBUTE3             ,
      ATTRIBUTE4             ,
      ATTRIBUTE5             ,
      ATTRIBUTE6             ,
      ATTRIBUTE7             ,
      ATTRIBUTE8             ,
      ATTRIBUTE9             ,
      ATTRIBUTE10            ,
      ATTRIBUTE11            ,
      ATTRIBUTE12            ,
      ATTRIBUTE13            ,
      ATTRIBUTE14            ,
      ATTRIBUTE15            ,
      TAG                    ,
      CREATION_DATE          ,
      CREATED_BY             ,
      LAST_UPDATE_DATE       ,
      LAST_UPDATED_BY        ,
      LAST_UPDATE_LOGIN
)
SELECT
     'ZX_CONDITION_FIELD',
      l.language_code , -- LANGUAGE
      lk.LOOKUP_CODE             ,
      lk.MEANING                 ,
      lk.DESCRIPTION             ,
      'Y'                     ,--ENABLED_FLAG
      lk.START_DATE_ACTIVE       ,
      NULL                    ,--END_DATE_ACTIVE
      userenv('LANG')         ,--SOURCE_LANG
      0                       ,--SECURITY_GROUP_ID
      0                       ,--VIEW_APPLICATION_ID
      NULL                    ,--TERRITORY_CODE
      NULL                    ,--ATTRIBUTE_CATEGORY
      NULL                    ,--ATTRIBUTE1
      NULL                    ,--ATTRIBUTE2
      NULL                    ,--ATTRIBUTE3
      NULL                    ,--ATTRIBUTE4
      NULL                    ,--ATTRIBUTE5
      NULL                    ,--ATTRIBUTE6
      NULL                    ,--ATTRIBUTE7
      NULL                    ,--ATTRIBUTE8
      NULL                    ,--ATTRIBUTE9
      NULL                    ,--ATTRIBUTE10
      NULL                    ,--ATTRIBUTE11
      NULL                    ,--ATTRIBUTE12
      NULL                    ,--ATTRIBUTE13
      NULL                    ,--ATTRIBUTE14
      NULL                    ,--ATTRIBUTE15
      NULL                    ,--TAG
      SYSDATE                 ,
      fnd_global.user_id      ,
      SYSDATE                 ,
      fnd_global.user_id      ,
      fnd_global.conc_login_id
   FROM  FND_LOOKUP_VALUES lk, FND_LANGUAGES l
   WHERE lk.lookup_type = 'TAX_CONDITION_FIELD'
	  AND view_application_id = 222
	  AND lk.language = 'US'
	  AND l.installed_flag in ('I', 'B')
	  AND not exists
	    (select '1'
	    from FND_LOOKUP_VALUES
	    where lookup_code = lk.lookup_code
	    and   lookup_type = 'ZX_CONDITION_FIELD'
	    and   language    = l.LANGUAGE_CODE);

Line: 753


/* Insert lookup codes for the lookup types */
INSERT INTO FND_LOOKUP_VALUES
(
      LOOKUP_TYPE            ,
      LANGUAGE               ,
      LOOKUP_CODE            ,
      MEANING                ,
      DESCRIPTION            ,
      ENABLED_FLAG           ,
      START_DATE_ACTIVE      ,
      END_DATE_ACTIVE        ,
      SOURCE_LANG            ,
      SECURITY_GROUP_ID      ,
      VIEW_APPLICATION_ID    ,
      TERRITORY_CODE         ,
      ATTRIBUTE_CATEGORY     ,
      ATTRIBUTE1             ,
      ATTRIBUTE2             ,
      ATTRIBUTE3             ,
      ATTRIBUTE4             ,
      ATTRIBUTE5             ,
      ATTRIBUTE6             ,
      ATTRIBUTE7             ,
      ATTRIBUTE8             ,
      ATTRIBUTE9             ,
      ATTRIBUTE10            ,
      ATTRIBUTE11            ,
      ATTRIBUTE12            ,
      ATTRIBUTE13            ,
      ATTRIBUTE14            ,
      ATTRIBUTE15            ,
      TAG                    ,
      CREATION_DATE          ,
      CREATED_BY             ,
      LAST_UPDATE_DATE       ,
      LAST_UPDATED_BY        ,
      LAST_UPDATE_LOGIN
)
SELECT
     'ZX_CONDITION_ENTITY',
      l.language_code , -- LANGUAGE
      lk.LOOKUP_CODE             ,
      lk.MEANING                 ,
      lk.DESCRIPTION             ,
      'Y'                     ,--ENABLED_FLAG
      lk.START_DATE_ACTIVE       ,
      NULL                    ,--END_DATE_ACTIVE
      userenv('LANG')         ,--SOURCE_LANG
      0                       ,--SECURITY_GROUP_ID
      0                       ,--VIEW_APPLICATION_ID
      NULL                    ,--TERRITORY_CODE
      NULL                    ,--ATTRIBUTE_CATEGORY
      NULL                    ,--ATTRIBUTE1
      NULL                    ,--ATTRIBUTE2
      NULL                    ,--ATTRIBUTE3
      NULL                    ,--ATTRIBUTE4
      NULL                    ,--ATTRIBUTE5
      NULL                    ,--ATTRIBUTE6
      NULL                    ,--ATTRIBUTE7
      NULL                    ,--ATTRIBUTE8
      NULL                    ,--ATTRIBUTE9
      NULL                    ,--ATTRIBUTE10
      NULL                    ,--ATTRIBUTE11
      NULL                    ,--ATTRIBUTE12
      NULL                    ,--ATTRIBUTE13
      NULL                    ,--ATTRIBUTE14
      NULL                    ,--ATTRIBUTE15
      NULL                    ,--TAG
      SYSDATE                 ,
      fnd_global.user_id      ,
      SYSDATE                 ,
      fnd_global.user_id      ,
      fnd_global.conc_login_id
   FROM  FND_LOOKUP_VALUES lk, FND_LANGUAGES l
   WHERE lk.lookup_type = 'TAX_CONDITION_ENTITY'
	  AND view_application_id = 222
	  AND lk.language = 'US'
	  AND l.installed_flag in ('I', 'B')
	  AND not exists
	    (select '1'
	    from FND_LOOKUP_VALUES
	    where lookup_code = lk.lookup_code
	    and   lookup_type = 'ZX_CONDITION_ENTITY'
	    and   language    = l.LANGUAGE_CODE);

Line: 838


/* Insert lookup codes for the lookup types */
INSERT INTO FND_LOOKUP_VALUES
(
      LOOKUP_TYPE            ,
      LANGUAGE               ,
      LOOKUP_CODE            ,
      MEANING                ,
      DESCRIPTION            ,
      ENABLED_FLAG           ,
      START_DATE_ACTIVE      ,
      END_DATE_ACTIVE        ,
      SOURCE_LANG            ,
      SECURITY_GROUP_ID      ,
      VIEW_APPLICATION_ID    ,
      TERRITORY_CODE         ,
      ATTRIBUTE_CATEGORY     ,
      ATTRIBUTE1             ,
      ATTRIBUTE2             ,
      ATTRIBUTE3             ,
      ATTRIBUTE4             ,
      ATTRIBUTE5             ,
      ATTRIBUTE6             ,
      ATTRIBUTE7             ,
      ATTRIBUTE8             ,
      ATTRIBUTE9             ,
      ATTRIBUTE10            ,
      ATTRIBUTE11            ,
      ATTRIBUTE12            ,
      ATTRIBUTE13            ,
      ATTRIBUTE14            ,
      ATTRIBUTE15            ,
      TAG                    ,
      CREATION_DATE          ,
      CREATED_BY             ,
      LAST_UPDATE_DATE       ,
      LAST_UPDATED_BY        ,
      LAST_UPDATE_LOGIN
)
SELECT
     'ZX_CONDITION_CLAUSE',
      l.language_code , -- LANGUAGE
      lk.LOOKUP_CODE             ,
      lk.MEANING                 ,
      lk.DESCRIPTION             ,
      'Y'                     ,--ENABLED_FLAG
      lk.START_DATE_ACTIVE       ,
      NULL                    ,--END_DATE_ACTIVE
      userenv('LANG')         ,--SOURCE_LANG
      0                       ,--SECURITY_GROUP_ID
      0                       ,--VIEW_APPLICATION_ID
      NULL                    ,--TERRITORY_CODE
      NULL                    ,--ATTRIBUTE_CATEGORY
      NULL                    ,--ATTRIBUTE1
      NULL                    ,--ATTRIBUTE2
      NULL                    ,--ATTRIBUTE3
      NULL                    ,--ATTRIBUTE4
      NULL                    ,--ATTRIBUTE5
      NULL                    ,--ATTRIBUTE6
      NULL                    ,--ATTRIBUTE7
      NULL                    ,--ATTRIBUTE8
      NULL                    ,--ATTRIBUTE9
      NULL                    ,--ATTRIBUTE10
      NULL                    ,--ATTRIBUTE11
      NULL                    ,--ATTRIBUTE12
      NULL                    ,--ATTRIBUTE13
      NULL                    ,--ATTRIBUTE14
      NULL                    ,--ATTRIBUTE15
      NULL                    ,--TAG
      SYSDATE                 ,
      fnd_global.user_id      ,
      SYSDATE                 ,
      fnd_global.user_id      ,
      fnd_global.conc_login_id
   FROM  FND_LOOKUP_VALUES lk, FND_LANGUAGES l
   WHERE lk.lookup_type = 'TAX_CONDITION_CLAUSE'
	  AND view_application_id = 222
	  AND lk.language = 'US'
	  AND l.installed_flag in ('I', 'B')
	  AND not exists
	    (select '1'
	    from FND_LOOKUP_VALUES
	    where lookup_code = lk.lookup_code
	    and   lookup_type = 'ZX_CONDITION_CLAUSE'
	    and   language    = l.LANGUAGE_CODE);

Line: 923


/* Insert lookup codes for the lookup types */
INSERT INTO FND_LOOKUP_VALUES
(
      LOOKUP_TYPE            ,
      LANGUAGE               ,
      LOOKUP_CODE            ,
      MEANING                ,
      DESCRIPTION            ,
      ENABLED_FLAG           ,
      START_DATE_ACTIVE      ,
      END_DATE_ACTIVE        ,
      SOURCE_LANG            ,
      SECURITY_GROUP_ID      ,
      VIEW_APPLICATION_ID    ,
      TERRITORY_CODE         ,
      ATTRIBUTE_CATEGORY     ,
      ATTRIBUTE1             ,
      ATTRIBUTE2             ,
      ATTRIBUTE3             ,
      ATTRIBUTE4             ,
      ATTRIBUTE5             ,
      ATTRIBUTE6             ,
      ATTRIBUTE7             ,
      ATTRIBUTE8             ,
      ATTRIBUTE9             ,
      ATTRIBUTE10            ,
      ATTRIBUTE11            ,
      ATTRIBUTE12            ,
      ATTRIBUTE13            ,
      ATTRIBUTE14            ,
      ATTRIBUTE15            ,
      TAG                    ,
      CREATION_DATE          ,
      CREATED_BY             ,
      LAST_UPDATE_DATE       ,
      LAST_UPDATED_BY        ,
      LAST_UPDATE_LOGIN
)
SELECT
     'ZX_CONDITION_ACTION_TYPE',
      l.language_code , -- LANGUAGE
      lk.LOOKUP_CODE             ,
      lk.MEANING                 ,
      lk.DESCRIPTION             ,
      'Y'                     ,--ENABLED_FLAG
      lk.START_DATE_ACTIVE       ,
      NULL                    ,--END_DATE_ACTIVE
      userenv('LANG')         ,--SOURCE_LANG
      0                       ,--SECURITY_GROUP_ID
      0                       ,--VIEW_APPLICATION_ID
      NULL                    ,--TERRITORY_CODE
      NULL                    ,--ATTRIBUTE_CATEGORY
      NULL                    ,--ATTRIBUTE1
      NULL                    ,--ATTRIBUTE2
      NULL                    ,--ATTRIBUTE3
      NULL                    ,--ATTRIBUTE4
      NULL                    ,--ATTRIBUTE5
      NULL                    ,--ATTRIBUTE6
      NULL                    ,--ATTRIBUTE7
      NULL                    ,--ATTRIBUTE8
      NULL                    ,--ATTRIBUTE9
      NULL                    ,--ATTRIBUTE10
      NULL                    ,--ATTRIBUTE11
      NULL                    ,--ATTRIBUTE12
      NULL                    ,--ATTRIBUTE13
      NULL                    ,--ATTRIBUTE14
      NULL                    ,--ATTRIBUTE15
      NULL                    ,--TAG
      SYSDATE                 ,
      fnd_global.user_id      ,
      SYSDATE                 ,
      fnd_global.user_id      ,
      fnd_global.conc_login_id
   FROM  FND_LOOKUP_VALUES lk, FND_LANGUAGES l
   WHERE lk.lookup_type = 'TAX_CONDITION_ACTION_TYPE'
	  AND view_application_id = 222
	  AND lk.language = 'US'
	  AND l.installed_flag in ('I', 'B')
	  AND not exists
	    (select '1'
	    from FND_LOOKUP_VALUES
	    where lookup_code = lk.lookup_code
	    and   lookup_type = 'ZX_CONDITION_ACTION_TYPE'
	    and   language    = l.LANGUAGE_CODE);

Line: 1008


/* Insert lookup codes for the lookup types */
INSERT INTO FND_LOOKUP_VALUES
(
      LOOKUP_TYPE            ,
      LANGUAGE               ,
      LOOKUP_CODE            ,
      MEANING                ,
      DESCRIPTION            ,
      ENABLED_FLAG           ,
      START_DATE_ACTIVE      ,
      END_DATE_ACTIVE        ,
      SOURCE_LANG            ,
      SECURITY_GROUP_ID      ,
      VIEW_APPLICATION_ID    ,
      TERRITORY_CODE         ,
      ATTRIBUTE_CATEGORY     ,
      ATTRIBUTE1             ,
      ATTRIBUTE2             ,
      ATTRIBUTE3             ,
      ATTRIBUTE4             ,
      ATTRIBUTE5             ,
      ATTRIBUTE6             ,
      ATTRIBUTE7             ,
      ATTRIBUTE8             ,
      ATTRIBUTE9             ,
      ATTRIBUTE10            ,
      ATTRIBUTE11            ,
      ATTRIBUTE12            ,
      ATTRIBUTE13            ,
      ATTRIBUTE14            ,
      ATTRIBUTE15            ,
      TAG                    ,
      CREATION_DATE          ,
      CREATED_BY             ,
      LAST_UPDATE_DATE       ,
      LAST_UPDATED_BY        ,
      LAST_UPDATE_LOGIN
)
SELECT
     'ZX_CONDITION_ACTION_CODE',
      l.language_code , -- LANGUAGE
      lk.LOOKUP_CODE             ,
      lk.MEANING                 ,
      lk.DESCRIPTION             ,
      'Y'                     ,--ENABLED_FLAG
      lk.START_DATE_ACTIVE       ,
      NULL                    ,--END_DATE_ACTIVE
      userenv('LANG')         ,--SOURCE_LANG
      0                       ,--SECURITY_GROUP_ID
      0                       ,--VIEW_APPLICATION_ID
      NULL                    ,--TERRITORY_CODE
      NULL                    ,--ATTRIBUTE_CATEGORY
      NULL                    ,--ATTRIBUTE1
      NULL                    ,--ATTRIBUTE2
      NULL                    ,--ATTRIBUTE3
      NULL                    ,--ATTRIBUTE4
      NULL                    ,--ATTRIBUTE5
      NULL                    ,--ATTRIBUTE6
      NULL                    ,--ATTRIBUTE7
      NULL                    ,--ATTRIBUTE8
      NULL                    ,--ATTRIBUTE9
      NULL                    ,--ATTRIBUTE10
      NULL                    ,--ATTRIBUTE11
      NULL                    ,--ATTRIBUTE12
      NULL                    ,--ATTRIBUTE13
      NULL                    ,--ATTRIBUTE14
      NULL                    ,--ATTRIBUTE15
      NULL                    ,--TAG
      SYSDATE                 ,
      fnd_global.user_id      ,
      SYSDATE                 ,
      fnd_global.user_id      ,
      fnd_global.conc_login_id
   FROM  FND_LOOKUP_VALUES lk, FND_LANGUAGES l
   WHERE lk.lookup_type = 'TAX_CONDITION_ACTION_CODE'
	  AND view_application_id = 222
	  AND lk.language = 'US'
	  AND l.installed_flag in ('I', 'B')
	  AND not exists
	    (select '1'
	    from FND_LOOKUP_VALUES
	    where lookup_code = lk.lookup_code
	    and   lookup_type = 'ZX_CONDITION_ACTION_CODE'
	    and   language    = l.LANGUAGE_CODE);

Line: 1093


/* Insert lookup codes for the lookup types */
INSERT INTO FND_LOOKUP_VALUES
(
      LOOKUP_TYPE            ,
      LANGUAGE               ,
      LOOKUP_CODE            ,
      MEANING                ,
      DESCRIPTION            ,
      ENABLED_FLAG           ,
      START_DATE_ACTIVE      ,
      END_DATE_ACTIVE        ,
      SOURCE_LANG            ,
      SECURITY_GROUP_ID      ,
      VIEW_APPLICATION_ID    ,
      TERRITORY_CODE         ,
      ATTRIBUTE_CATEGORY     ,
      ATTRIBUTE1             ,
      ATTRIBUTE2             ,
      ATTRIBUTE3             ,
      ATTRIBUTE4             ,
      ATTRIBUTE5             ,
      ATTRIBUTE6             ,
      ATTRIBUTE7             ,
      ATTRIBUTE8             ,
      ATTRIBUTE9             ,
      ATTRIBUTE10            ,
      ATTRIBUTE11            ,
      ATTRIBUTE12            ,
      ATTRIBUTE13            ,
      ATTRIBUTE14            ,
      ATTRIBUTE15            ,
      TAG                    ,
      CREATION_DATE          ,
      CREATED_BY             ,
      LAST_UPDATE_DATE       ,
      LAST_UPDATED_BY        ,
      LAST_UPDATE_LOGIN
)
SELECT
     'ZX_CONDITION_VALUE',
      l.language_code , -- LANGUAGE
      lk.LOOKUP_CODE             ,
      lk.MEANING                 ,
      lk.DESCRIPTION             ,
      'Y'                     ,--ENABLED_FLAG
      lk.START_DATE_ACTIVE       ,
      NULL                    ,--END_DATE_ACTIVE
      userenv('LANG')         ,--SOURCE_LANG
      0                       ,--SECURITY_GROUP_ID
      0                       ,--VIEW_APPLICATION_ID
      NULL                    ,--TERRITORY_CODE
      NULL                    ,--ATTRIBUTE_CATEGORY
      NULL                    ,--ATTRIBUTE1
      NULL                    ,--ATTRIBUTE2
      NULL                    ,--ATTRIBUTE3
      NULL                    ,--ATTRIBUTE4
      NULL                    ,--ATTRIBUTE5
      NULL                    ,--ATTRIBUTE6
      NULL                    ,--ATTRIBUTE7
      NULL                    ,--ATTRIBUTE8
      NULL                    ,--ATTRIBUTE9
      NULL                    ,--ATTRIBUTE10
      NULL                    ,--ATTRIBUTE11
      NULL                    ,--ATTRIBUTE12
      NULL                    ,--ATTRIBUTE13
      NULL                    ,--ATTRIBUTE14
      NULL                    ,--ATTRIBUTE15
      NULL                    ,--TAG
      SYSDATE                 ,
      fnd_global.user_id      ,
      SYSDATE                 ,
      fnd_global.user_id      ,
      fnd_global.conc_login_id
   FROM  FND_LOOKUP_VALUES lk, FND_LANGUAGES l
   WHERE lk.lookup_type = 'TAX_CONDITION_VALUE'
	  AND view_application_id = 222
	  AND lk.language = 'US'
	  AND l.installed_flag in ('I', 'B')
	  AND not exists
	    (select '1'
	    from FND_LOOKUP_VALUES
	    where lookup_code = lk.lookup_code
	    and   lookup_type = 'ZX_CONDITION_VALUE'
	    and   language    = l.LANGUAGE_CODE);

Line: 1178


/* Insert lookup codes for the lookup types */
INSERT INTO FND_LOOKUP_VALUES
(
      LOOKUP_TYPE            ,
      LANGUAGE               ,
      LOOKUP_CODE            ,
      MEANING                ,
      DESCRIPTION            ,
      ENABLED_FLAG           ,
      START_DATE_ACTIVE      ,
      END_DATE_ACTIVE        ,
      SOURCE_LANG            ,
      SECURITY_GROUP_ID      ,
      VIEW_APPLICATION_ID    ,
      TERRITORY_CODE         ,
      ATTRIBUTE_CATEGORY     ,
      ATTRIBUTE1             ,
      ATTRIBUTE2             ,
      ATTRIBUTE3             ,
      ATTRIBUTE4             ,
      ATTRIBUTE5             ,
      ATTRIBUTE6             ,
      ATTRIBUTE7             ,
      ATTRIBUTE8             ,
      ATTRIBUTE9             ,
      ATTRIBUTE10            ,
      ATTRIBUTE11            ,
      ATTRIBUTE12            ,
      ATTRIBUTE13            ,
      ATTRIBUTE14            ,
      ATTRIBUTE15            ,
      TAG                    ,
      CREATION_DATE          ,
      CREATED_BY             ,
      LAST_UPDATE_DATE       ,
      LAST_UPDATED_BY        ,
      LAST_UPDATE_LOGIN
)
SELECT
     'ZX_TAX_CLASSIFICATION',
      l.language_code , -- LANGUAGE
      lk.LOOKUP_CODE             ,
      lk.MEANING                 ,
      lk.DESCRIPTION             ,
      'Y'                     ,--ENABLED_FLAG
      lk.START_DATE_ACTIVE       ,
      NULL                    ,--END_DATE_ACTIVE
      userenv('LANG')         ,--SOURCE_LANG
      0                       ,--SECURITY_GROUP_ID
      0                       ,--VIEW_APPLICATION_ID
      NULL                    ,--TERRITORY_CODE
      NULL                    ,--ATTRIBUTE_CATEGORY
      NULL                    ,--ATTRIBUTE1
      NULL                    ,--ATTRIBUTE2
      NULL                    ,--ATTRIBUTE3
      NULL                    ,--ATTRIBUTE4
      NULL                    ,--ATTRIBUTE5
      NULL                    ,--ATTRIBUTE6
      NULL                    ,--ATTRIBUTE7
      NULL                    ,--ATTRIBUTE8
      NULL                    ,--ATTRIBUTE9
      NULL                    ,--ATTRIBUTE10
      NULL                    ,--ATTRIBUTE11
      NULL                    ,--ATTRIBUTE12
      NULL                    ,--ATTRIBUTE13
      NULL                    ,--ATTRIBUTE14
      NULL                    ,--ATTRIBUTE15
      NULL                    ,--TAG
      SYSDATE                 ,
      fnd_global.user_id      ,
      SYSDATE                 ,
      fnd_global.user_id      ,
      fnd_global.conc_login_id
   FROM  FND_LOOKUP_VALUES lk, FND_LANGUAGES l
   WHERE lk.lookup_type = 'AR_TAX_CLASSIFICATION'
	  AND view_application_id = 222
	  AND lk.language = 'US'
	  AND l.installed_flag in ('I', 'B')
	  AND not exists
	    (select '1'
	    from FND_LOOKUP_VALUES
	    where lookup_code = lk.lookup_code
	    and   lookup_type = 'ZX_TAX_CLASSIFICATION'
	    and   language    = l.LANGUAGE_CODE);

Line: 1304


   UPDATE fnd_lookup_values
   SET   ENABLED_FLAG = 'N',
         END_DATE_ACTIVE = SYSDATE
   WHERE lookup_type in (
        'ZX_CONDITION_TYPE',
        'ZX_CONDITION_OPERATOR',
        'ZX_CONDITION_FIELD',
        'ZX_CONDITION_ENTITY',
        'ZX_CONDITION_CLAUSE',
        'ZX_CONDITION_ACTION_TYPE',
        'ZX_CONDITION_ACTION_CODE',
        'ZX_CONDITION_VALUE',
        'ZX_TAX_CLASSIFICATION')
   AND  view_application_id = 0;