The following lines contain the word 'select', 'insert', 'update' or 'delete':
INSERT INTO FND_PROFILE_OPTION_VALUES
(
APPLICATION_ID ,
PROFILE_OPTION_ID ,
LEVEL_ID ,
LEVEL_VALUE ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
LAST_UPDATE_LOGIN ,
PROFILE_OPTION_VALUE ,
LEVEL_VALUE_APPLICATION_ID
)
SELECT
235, -- APPLICATION_ID
(select profile_option_id
from fnd_profile_options
where profile_option_name = 'ZX_ALLOW_TRX_LINE_EXEMPTIONS'), -- PROFILE_OPTION_ID
LEVEL_ID,
LEVEL_VALUE,
sysdate, --LAST_UPDATE_DATE
fnd_global.user_id, --LAST_UPDATED_BY
sysdate, --CREATION_DATE
fnd_global.user_id, --CREATED_BY
fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
PROFILE_OPTION_VALUE,
LEVEL_VALUE_APPLICATION_ID
FROM fnd_profile_option_values
WHERE profile_option_id = (select profile_option_id
from fnd_profile_options
where profile_option_name = 'AR_ALLOW_TRX_LINE_EXEMPTIONS')
AND NOT EXISTS (SELECT 1
FROM fnd_profile_option_values
WHERE profile_option_id = (SELECT profile_option_id
FROM fnd_profile_options
WHERE profile_option_name = 'ZX_ALLOW_TRX_LINE_EXEMPTIONS')
);
INSERT INTO FND_PROFILE_OPTION_VALUES
(
APPLICATION_ID ,
PROFILE_OPTION_ID ,
LEVEL_ID ,
LEVEL_VALUE ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
LAST_UPDATE_LOGIN ,
PROFILE_OPTION_VALUE ,
LEVEL_VALUE_APPLICATION_ID
)
SELECT
235, -- APPLICATION_ID
(select profile_option_id
from fnd_profile_options
where profile_option_name = 'ZX_ALLOW_TAX_UPDATE'), -- PROFILE_OPTION_ID
LEVEL_ID,
LEVEL_VALUE,
sysdate, --LAST_UPDATE_DATE
fnd_global.user_id, --LAST_UPDATED_BY
sysdate, --CREATION_DATE
fnd_global.user_id, --CREATED_BY
fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
PROFILE_OPTION_VALUE,
LEVEL_VALUE_APPLICATION_ID
FROM fnd_profile_option_values
WHERE profile_option_id = (select profile_option_id
from fnd_profile_options
where profile_option_name = 'AR_ALLOW_TAX_UPDATE')
AND APPLICATION_ID = 222
AND NOT EXISTS (SELECT 1
FROM fnd_profile_option_values
WHERE profile_option_id = (SELECT profile_option_id
FROM fnd_profile_options
WHERE profile_option_name = 'ZX_ALLOW_TAX_UPDATE')
);
INSERT INTO FND_PROFILE_OPTION_VALUES
(
APPLICATION_ID ,
PROFILE_OPTION_ID ,
LEVEL_ID ,
LEVEL_VALUE ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
LAST_UPDATE_LOGIN ,
PROFILE_OPTION_VALUE ,
LEVEL_VALUE_APPLICATION_ID
)
SELECT
235, -- APPLICATION_ID
(select profile_option_id
from fnd_profile_options
where profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES'), -- PROFILE_OPTION_ID
LEVEL_ID,
LEVEL_VALUE,
sysdate, --LAST_UPDATE_DATE
fnd_global.user_id, --LAST_UPDATED_BY
sysdate, --CREATION_DATE
fnd_global.user_id, --CREATED_BY
fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
PROFILE_OPTION_VALUE,
LEVEL_VALUE_APPLICATION_ID
FROM fnd_profile_option_values
WHERE profile_option_id = (select profile_option_id
from fnd_profile_options
where profile_option_name = 'AR_ALLOW_MANUAL_TAX_LINES')
AND NOT EXISTS (SELECT 1
FROM fnd_profile_option_values
WHERE profile_option_id = (SELECT profile_option_id
FROM fnd_profile_options
WHERE profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES')
);
INSERT INTO FND_PROFILE_OPTION_VALUES
(
APPLICATION_ID ,
PROFILE_OPTION_ID ,
LEVEL_ID ,
LEVEL_VALUE ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
LAST_UPDATE_LOGIN ,
PROFILE_OPTION_VALUE ,
LEVEL_VALUE_APPLICATION_ID
)
SELECT
235, -- APPLICATION_ID
(select profile_option_id
from fnd_profile_options
where profile_option_name = 'ZX_INVENTORY_ITEM_FOR_FREIGHT'), -- PROFILE_OPTION_ID
LEVEL_ID,
LEVEL_VALUE,
sysdate, --LAST_UPDATE_DATE
fnd_global.user_id, --LAST_UPDATED_BY
sysdate, --CREATION_DATE
fnd_global.user_id, --CREATED_BY
fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
PROFILE_OPTION_VALUE,
LEVEL_VALUE_APPLICATION_ID
FROM fnd_profile_option_values
WHERE profile_option_id = (select profile_option_id
from fnd_profile_options
where profile_option_name = 'OE_INVENTORY_ITEM_FOR_FREIGHT')
AND NOT EXISTS (SELECT 1
FROM fnd_profile_option_values
WHERE profile_option_id = (SELECT profile_option_id
FROM fnd_profile_options
WHERE profile_option_name = 'ZX_INVENTORY_ITEM_FOR_FREIGHT')
);
INSERT INTO FND_PROFILE_OPTION_VALUES
(
APPLICATION_ID ,
PROFILE_OPTION_ID ,
LEVEL_ID ,
LEVEL_VALUE ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
LAST_UPDATE_LOGIN ,
PROFILE_OPTION_VALUE ,
LEVEL_VALUE_APPLICATION_ID
)
SELECT
235, -- APPLICATION_ID
(select profile_option_id
from fnd_profile_options
where profile_option_name = 'ZX_INVOICE_FREIGHT_AS_LINE'), -- PROFILE_OPTION_ID
LEVEL_ID,
LEVEL_VALUE,
sysdate, --LAST_UPDATE_DATE
fnd_global.user_id, --LAST_UPDATED_BY
sysdate, --CREATION_DATE
fnd_global.user_id, --CREATED_BY
fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
PROFILE_OPTION_VALUE,
LEVEL_VALUE_APPLICATION_ID
FROM fnd_profile_option_values
WHERE profile_option_id = (select profile_option_id
from fnd_profile_options
where profile_option_name = 'OE_INVOICE_FREIGHT_AS_LINE')
AND NOT EXISTS (SELECT 1
FROM fnd_profile_option_values
WHERE profile_option_id = (SELECT profile_option_id
FROM fnd_profile_options
WHERE profile_option_name = 'ZX_INVOICE_FREIGHT_AS_LINE')
);
INSERT INTO FND_PROFILE_OPTION_VALUES
(
APPLICATION_ID ,
PROFILE_OPTION_ID ,
LEVEL_ID ,
LEVEL_VALUE ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
LAST_UPDATE_LOGIN ,
PROFILE_OPTION_VALUE ,
LEVEL_VALUE_APPLICATION_ID
)
SELECT
235, -- APPLICATION_ID
(select profile_option_id
from fnd_profile_options
where profile_option_name = 'ZX_ALLOW_TAX_RECVRY_RATE_OVERRIDE'), -- PROFILE_OPTION_ID
LEVEL_ID,
LEVEL_VALUE,
sysdate, --LAST_UPDATE_DATE
fnd_global.user_id, --LAST_UPDATED_BY
sysdate, --CREATION_DATE
fnd_global.user_id, --CREATED_BY
fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
PROFILE_OPTION_VALUE,
LEVEL_VALUE_APPLICATION_ID
FROM fnd_profile_option_values
WHERE profile_option_id = (select profile_option_id
from fnd_profile_options
where profile_option_name = 'AP_ALLOW_TAX_RECVRY_RATE_OVERRIDE')
AND NOT EXISTS (SELECT 1
FROM fnd_profile_option_values
WHERE profile_option_id = (SELECT profile_option_id
FROM fnd_profile_options
WHERE profile_option_name = 'ZX_ALLOW_TAX_RECVRY_RATE_OVERRIDE')
);
INSERT INTO FND_PROFILE_OPTION_VALUES
(
APPLICATION_ID ,
PROFILE_OPTION_ID ,
LEVEL_ID ,
LEVEL_VALUE ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
LAST_UPDATE_LOGIN ,
PROFILE_OPTION_VALUE ,
LEVEL_VALUE_APPLICATION_ID
)
SELECT
235, -- APPLICATION_ID
(select profile_option_id
from fnd_profile_options
where profile_option_name = 'ZX_ALLOW_TAX_CLASSIF_OVERRIDE'), -- PROFILE_OPTION_ID
LEVEL_ID,
LEVEL_VALUE,
sysdate, --LAST_UPDATE_DATE
fnd_global.user_id, --LAST_UPDATED_BY
sysdate, --CREATION_DATE
fnd_global.user_id, --CREATED_BY
fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
PROFILE_OPTION_VALUE,
LEVEL_VALUE_APPLICATION_ID
FROM fnd_profile_option_values
WHERE profile_option_id = (select profile_option_id
from fnd_profile_options
where profile_option_name = 'AR_ALLOW_TAX_CODE_OVERRIDE')
AND NOT EXISTS (SELECT 1
FROM fnd_profile_option_values
WHERE profile_option_id = (SELECT profile_option_id
FROM fnd_profile_options
WHERE profile_option_name = 'ZX_ALLOW_TAX_CLASSIF_OVERRIDE')
);
INSERT INTO FND_PROFILE_OPTION_VALUES
(
APPLICATION_ID ,
PROFILE_OPTION_ID ,
LEVEL_ID ,
LEVEL_VALUE ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
LAST_UPDATE_LOGIN ,
PROFILE_OPTION_VALUE ,
LEVEL_VALUE_APPLICATION_ID
)
SELECT
235, -- APPLICATION_ID
(select profile_option_id
from fnd_profile_options
where profile_option_name = 'ZX_TAXVDR_USENEXPRO'), -- PROFILE_OPTION_ID
LEVEL_ID,
LEVEL_VALUE,
sysdate, --LAST_UPDATE_DATE
fnd_global.user_id, --LAST_UPDATED_BY
sysdate, --CREATION_DATE
fnd_global.user_id, --CREATED_BY
fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
PROFILE_OPTION_VALUE,
LEVEL_VALUE_APPLICATION_ID
FROM fnd_profile_option_values valar
, fnd_profile_options fpoar
WHERE valar.profile_option_id = fpoar.profile_option_id
AND fpoar.profile_option_name = 'AR_TAXVDR_USENEXPRO'
AND NOT EXISTS (SELECT 1
FROM fnd_profile_option_values valzx
, fnd_profile_options fpozx
WHERE valzx.profile_option_id = fpozx.profile_option_id
AND fpozx.profile_option_name = 'ZX_TAXVDR_USENEXPRO');
INSERT INTO FND_PROFILE_OPTION_VALUES
(
APPLICATION_ID ,
PROFILE_OPTION_ID ,
LEVEL_ID ,
LEVEL_VALUE ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
LAST_UPDATE_LOGIN ,
PROFILE_OPTION_VALUE ,
LEVEL_VALUE_APPLICATION_ID
)
SELECT
235, -- APPLICATION_ID
(select profile_option_id
from fnd_profile_options
where profile_option_name = 'ZX_TAXVDR_TAXSELPARAM'), -- PROFILE_OPTION_ID
LEVEL_ID,
LEVEL_VALUE,
sysdate, --LAST_UPDATE_DATE
fnd_global.user_id, --LAST_UPDATED_BY
sysdate, --CREATION_DATE
fnd_global.user_id, --CREATED_BY
fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
PROFILE_OPTION_VALUE,
LEVEL_VALUE_APPLICATION_ID
FROM fnd_profile_option_values valar
, fnd_profile_options fpoar
WHERE valar.profile_option_id = fpoar.profile_option_id
AND fpoar.profile_option_name = 'AR_TAXVDR_TAXSELPARAM'
AND NOT EXISTS (SELECT 1
FROM fnd_profile_option_values valzx
, fnd_profile_options fpozx
WHERE valzx.profile_option_id = fpozx.profile_option_id
AND fpozx.profile_option_name = 'ZX_TAXVDR_TAXSELPARAM');
INSERT INTO FND_PROFILE_OPTION_VALUES
(
APPLICATION_ID ,
PROFILE_OPTION_ID ,
LEVEL_ID ,
LEVEL_VALUE ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
LAST_UPDATE_LOGIN ,
PROFILE_OPTION_VALUE ,
LEVEL_VALUE_APPLICATION_ID
)
SELECT
235, -- APPLICATION_ID
(select profile_option_id
from fnd_profile_options
where profile_option_name = 'ZX_TAXVDR_TAXTYPE'), -- PROFILE_OPTION_ID
LEVEL_ID,
LEVEL_VALUE,
sysdate, --LAST_UPDATE_DATE
fnd_global.user_id, --LAST_UPDATED_BY
sysdate, --CREATION_DATE
fnd_global.user_id, --CREATED_BY
fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
PROFILE_OPTION_VALUE,
LEVEL_VALUE_APPLICATION_ID
FROM fnd_profile_option_values valar
, fnd_profile_options fpoar
WHERE valar.profile_option_id = fpoar.profile_option_id
AND fpoar.profile_option_name = 'AR_TAXVDR_TAXTYPE'
AND NOT EXISTS (SELECT 1
FROM fnd_profile_option_values valzx
, fnd_profile_options fpozx
WHERE valzx.profile_option_id = fpozx.profile_option_id
AND fpozx.profile_option_name = 'ZX_TAXVDR_TAXTYPE');
INSERT INTO FND_PROFILE_OPTION_VALUES
(
APPLICATION_ID ,
PROFILE_OPTION_ID ,
LEVEL_ID ,
LEVEL_VALUE ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
LAST_UPDATE_LOGIN ,
PROFILE_OPTION_VALUE ,
LEVEL_VALUE_APPLICATION_ID
)
SELECT
235, -- APPLICATION_ID
(select profile_option_id
from fnd_profile_options
where profile_option_name = 'ZX_TAXVDR_SERVICEIND'), -- PROFILE_OPTION_ID
LEVEL_ID,
LEVEL_VALUE,
sysdate, --LAST_UPDATE_DATE
fnd_global.user_id, --LAST_UPDATED_BY
sysdate, --CREATION_DATE
fnd_global.user_id, --CREATED_BY
fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
PROFILE_OPTION_VALUE,
LEVEL_VALUE_APPLICATION_ID
FROM fnd_profile_option_values valar
, fnd_profile_options fpoar
WHERE valar.profile_option_id = fpoar.profile_option_id
AND fpoar.profile_option_name = 'AR_TAXVDR_SERVICEIND'
AND NOT EXISTS (SELECT 1
FROM fnd_profile_option_values valzx
, fnd_profile_options fpozx
WHERE valzx.profile_option_id = fpozx.profile_option_id
AND fpozx.profile_option_name = 'ZX_TAXVDR_SERVICEIND');
INSERT INTO FND_PROFILE_OPTION_VALUES
(
APPLICATION_ID ,
PROFILE_OPTION_ID ,
LEVEL_ID ,
LEVEL_VALUE ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
LAST_UPDATE_LOGIN ,
PROFILE_OPTION_VALUE ,
LEVEL_VALUE_APPLICATION_ID
)
SELECT
235, -- APPLICATION_ID
(select profile_option_id
from fnd_profile_options
where profile_option_name = 'ZX_TAXVDR_CASESENSITIVE'), -- PROFILE_OPTION_ID
LEVEL_ID,
LEVEL_VALUE,
sysdate, --LAST_UPDATE_DATE
fnd_global.user_id, --LAST_UPDATED_BY
sysdate, --CREATION_DATE
fnd_global.user_id, --CREATED_BY
fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
PROFILE_OPTION_VALUE,
LEVEL_VALUE_APPLICATION_ID
FROM fnd_profile_option_values valar
, fnd_profile_options fpoar
WHERE valar.profile_option_id = fpoar.profile_option_id
AND fpoar.profile_option_name = 'AR_TAXVDR_CASESENSITIVE'
AND NOT EXISTS (SELECT 1
FROM fnd_profile_option_values valzx
, fnd_profile_options fpozx
WHERE valzx.profile_option_id = fpozx.profile_option_id
AND fpozx.profile_option_name = 'ZX_TAXVDR_CASESENSITIVE');
UPDATE fnd_profile_options
SET END_DATE_ACTIVE = sysdate,
LAST_UPDATE_DATE = sysdate,
LAST_UPDATED_BY = fnd_global.user_id,
LAST_UPDATE_LOGIN = fnd_global.conc_login_id
WHERE profile_option_name = 'AR_ALLOW_TRX_LINE_EXEMPTIONS'
AND end_date_active IS NULL;
UPDATE fnd_profile_options
SET END_DATE_ACTIVE = sysdate,
LAST_UPDATE_DATE = sysdate,
LAST_UPDATED_BY = fnd_global.user_id,
LAST_UPDATE_LOGIN = fnd_global.conc_login_id
WHERE profile_option_name = 'AR_ALLOW_TAX_UPDATE'
AND end_date_active IS NULL;
UPDATE fnd_profile_options
SET END_DATE_ACTIVE = sysdate,
LAST_UPDATE_DATE = sysdate,
LAST_UPDATED_BY = fnd_global.user_id,
LAST_UPDATE_LOGIN = fnd_global.conc_login_id
WHERE profile_option_name = 'AR_ALLOW_MANUAL_TAX_LINES'
AND end_date_active IS NULL;
UPDATE fnd_profile_options
SET END_DATE_ACTIVE = sysdate,
LAST_UPDATE_DATE = sysdate,
LAST_UPDATED_BY = fnd_global.user_id,
LAST_UPDATE_LOGIN = fnd_global.conc_login_id
WHERE profile_option_name = 'OE_INVENTORY_ITEM_FOR_FREIGHT'
AND end_date_active IS NULL;
UPDATE fnd_profile_options
SET END_DATE_ACTIVE = sysdate,
LAST_UPDATE_DATE = sysdate,
LAST_UPDATED_BY = fnd_global.user_id,
LAST_UPDATE_LOGIN = fnd_global.conc_login_id
WHERE profile_option_name = 'OE_INVOICE_FREIGHT_AS_LINE'
AND end_date_active IS NULL;
UPDATE fnd_profile_options
SET END_DATE_ACTIVE = sysdate,
LAST_UPDATE_DATE = sysdate,
LAST_UPDATED_BY = fnd_global.user_id,
LAST_UPDATE_LOGIN = fnd_global.conc_login_id
WHERE profile_option_name = 'AP_ALLOW_TAX_RECVRY_RATE_OVERRIDE'
AND end_date_active IS NULL;
UPDATE fnd_profile_options
SET END_DATE_ACTIVE = sysdate,
LAST_UPDATE_DATE = sysdate,
LAST_UPDATED_BY = fnd_global.user_id,
LAST_UPDATE_LOGIN = fnd_global.conc_login_id
WHERE profile_option_name = 'AR_ALLOW_TAX_CODE_OVERRIDE'
AND end_date_active IS NULL;
UPDATE fnd_profile_options
SET END_DATE_ACTIVE = sysdate,
LAST_UPDATE_DATE = sysdate,
LAST_UPDATED_BY = fnd_global.user_id,
LAST_UPDATE_LOGIN = fnd_global.conc_login_id
WHERE profile_option_name = 'AR_TAXVDR_USENEXPRO'
AND end_date_active IS NULL;
UPDATE fnd_profile_options
SET END_DATE_ACTIVE = sysdate,
LAST_UPDATE_DATE = sysdate,
LAST_UPDATED_BY = fnd_global.user_id,
LAST_UPDATE_LOGIN = fnd_global.conc_login_id
WHERE profile_option_name = 'AR_TAXVDR_TAXSELPARAM'
AND end_date_active IS NULL;
UPDATE fnd_profile_options
SET END_DATE_ACTIVE = sysdate,
LAST_UPDATE_DATE = sysdate,
LAST_UPDATED_BY = fnd_global.user_id,
LAST_UPDATE_LOGIN = fnd_global.conc_login_id
WHERE profile_option_name = 'AR_TAXVDR_TAXTYPE'
AND end_date_active IS NULL;
UPDATE fnd_profile_options
SET END_DATE_ACTIVE = sysdate,
LAST_UPDATE_DATE = sysdate,
LAST_UPDATED_BY = fnd_global.user_id,
LAST_UPDATE_LOGIN = fnd_global.conc_login_id
WHERE profile_option_name = 'AR_TAXVDR_SERVICEIND'
AND end_date_active IS NULL;
UPDATE fnd_profile_options
SET END_DATE_ACTIVE = sysdate,
LAST_UPDATE_DATE = sysdate,
LAST_UPDATED_BY = fnd_global.user_id,
LAST_UPDATE_LOGIN = fnd_global.conc_login_id
WHERE profile_option_name = 'AR_TAXVDR_CASESENSITIVE'
AND end_date_active IS NULL;