[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
msii.TRANSACTION_ID,
msii.INVENTORY_ITEM_ID III,
msii.ORGANIZATION_ID ORGID,
mp.MASTER_ORGANIZATION_ID MORGID,
msii.NEGATIVE_MEASUREMENT_ERROR,
msii.ENGINEERING_ECN_CODE,
msii.ENGINEERING_ITEM_ID,
msii.ENGINEERING_DATE,
msii.SERVICE_STARTING_DELAY,
msii.SERVICEABLE_COMPONENT_FLAG,
msii.SERVICEABLE_PRODUCT_FLAG,
msii.BASE_WARRANTY_SERVICE_ID,
msii.PAYMENT_TERMS_ID,
msii.PREVENTIVE_MAINTENANCE_FLAG,
msii.PRIMARY_SPECIALIST_ID,
msii.SECONDARY_SPECIALIST_ID,
msii.SERVICEABLE_ITEM_CLASS_ID,
msii.TIME_BILLABLE_FLAG,
msii.MATERIAL_BILLABLE_FLAG,
msii.EXPENSE_BILLABLE_FLAG,
msii.PRORATE_SERVICE_FLAG,
msii.COVERAGE_SCHEDULE_ID,
msii.SERVICE_DURATION_PERIOD_CODE,
msii.SERVICE_DURATION,
msii.WARRANTY_VENDOR_ID,
msii.MAX_WARRANTY_AMOUNT,
msii.RESPONSE_TIME_PERIOD_CODE,
msii.RESPONSE_TIME_VALUE,
msii.NEW_REVISION_CODE,
msii.INVOICEABLE_ITEM_FLAG,
msii.TAX_CODE,
msii.INVOICE_ENABLED_FLAG,
msii.MUST_USE_APPROVED_VENDOR_FLAG,
msii.RELEASE_TIME_FENCE_CODE,
msii.RELEASE_TIME_FENCE_DAYS,
msii.CONTAINER_ITEM_FLAG,
msii.CONTAINER_TYPE_CODE,
msii.INTERNAL_VOLUME,
msii.MAXIMUM_LOAD_WEIGHT,
msii.MINIMUM_FILL_PERCENT,
msii.VEHICLE_ITEM_FLAG,
-- Added for 11.5.10
msii.TRACKING_QUANTITY_IND ,
msii.ONT_PRICING_QTY_SOURCE,
msii.SECONDARY_DEFAULT_IND ,
msii.CONFIG_ORGS,
msii.CONFIG_MATCH,
msii.VMI_MINIMUM_UNITS ,
msii.VMI_MINIMUM_DAYS ,
msii.VMI_MAXIMUM_UNITS ,
msii.VMI_MAXIMUM_DAYS ,
msii.VMI_FIXED_ORDER_QUANTITY ,
msii.SO_AUTHORIZATION_FLAG ,
msii.CONSIGNED_FLAG ,
msii.ASN_AUTOEXPIRE_FLAG ,
msii.VMI_FORECAST_TYPE ,
msii.FORECAST_HORIZON ,
msii.EXCLUDE_FROM_BUDGET_FLAG ,
msii.DAYS_TGT_INV_SUPPLY ,
msii.DAYS_TGT_INV_WINDOW ,
msii.DAYS_MAX_INV_SUPPLY ,
msii.DAYS_MAX_INV_WINDOW ,
msii.DRP_PLANNED_FLAG ,
msii.CRITICAL_COMPONENT_FLAG ,
msii.CONTINOUS_TRANSFER ,
msii.CONVERGENCE ,
msii.DIVERGENCE ,
/* Start Bug 3713912 */
msii.LOT_DIVISIBLE_FLAG ,
msii.GRADE_CONTROL_FLAG ,
msii.DEFAULT_GRADE ,
msii.CHILD_LOT_FLAG ,
msii.PARENT_CHILD_GENERATION_FLAG ,
msii.CHILD_LOT_PREFIX ,
msii.CHILD_LOT_STARTING_NUMBER ,
msii.CHILD_LOT_VALIDATION_FLAG ,
msii.COPY_LOT_ATTRIBUTE_FLAG ,
msii.RECIPE_ENABLED_FLAG ,
msii.PROCESS_QUALITY_ENABLED_FLAG ,
msii.PROCESS_EXECUTION_ENABLED_FLAG ,
msii.PROCESS_COSTING_ENABLED_FLAG ,
msii.PROCESS_SUPPLY_SUBINVENTORY ,
msii.PROCESS_SUPPLY_LOCATOR_ID ,
msii.PROCESS_YIELD_SUBINVENTORY ,
msii.PROCESS_YIELD_LOCATOR_ID ,
msii.HAZARDOUS_MATERIAL_FLAG ,
msii.CAS_NUMBER ,
msii.RETEST_INTERVAL ,
msii.EXPIRATION_ACTION_INTERVAL ,
msii.EXPIRATION_ACTION_CODE ,
msii.MATURITY_DAYS ,
msii.HOLD_DAYS
/* End Bug 3713912 */
from MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp
where ((msii.organization_id = org_id) or
(all_Org = 1))
and msii.process_flag = 2
and msii.organization_id = mp.organization_id
and msii.set_process_id = xset_id
and msii.organization_id <> mp.master_organization_id;
select attribute_name,
control_level
from MTL_ITEM_ATTRIBUTES
where control_level = 1;
select inventory_item_id into msicount
from mtl_system_items msi
where msi.inventory_item_id = cr.III
and msi.organization_id = cr.MORGID
and decode(A_ENGINEERING_DATE,X_TRUE,nvl(cr.ENGINEERING_DATE,TO_DATE('1000/01/01','YYYY/MM/DD')),nvl(msi.ENGINEERING_DATE,TO_DATE('1000/01/01','YYYY/MM/DD')))=nvl(msi.ENGINEERING_DATE,TO_DATE('1000/01/01','YYYY/MM/DD'))
and decode(A_NEGATIVE_MEASUREMENT_ERROR,X_TRUE,nvl(cr.NEGATIVE_MEASUREMENT_ERROR,-1),nvl(msi.NEGATIVE_MEASUREMENT_ERROR,-1))=nvl(msi.NEGATIVE_MEASUREMENT_ERROR,-1)
and decode(A_ENGINEERING_ECN_CODE,X_TRUE,nvl(cr.ENGINEERING_ECN_CODE,-1),nvl(msi.ENGINEERING_ECN_CODE,-1))=nvl(msi.ENGINEERING_ECN_CODE,-1)
and decode(A_ENGINEERING_ITEM_ID,X_TRUE,nvl(cr.ENGINEERING_ITEM_ID,-1),nvl(msi.ENGINEERING_ITEM_ID,-1))=nvl(msi.ENGINEERING_ITEM_ID,-1)
and decode(A_SERVICE_STARTING_DELAY,X_TRUE,nvl(cr.SERVICE_STARTING_DELAY,-1),nvl(msi.SERVICE_STARTING_DELAY,-1))=nvl(msi.SERVICE_STARTING_DELAY,-1)
and decode(A_SERVICEABLE_COMPONENT_FLAG,X_TRUE,nvl(cr.SERVICEABLE_COMPONENT_FLAG,-1),nvl(msi.SERVICEABLE_COMPONENT_FLAG,-1))=nvl(msi.SERVICEABLE_COMPONENT_FLAG,-1);
update mtl_system_items_interface msii
set process_flag = 3
where msii.transaction_id = cr.transaction_id;
select inventory_item_id into msicount
from mtl_system_items msi
where msi.inventory_item_id = cr.III
and msi.organization_id = cr.MORGID
and decode(A_SERVICEABLE_PRODUCT_FLAG,X_TRUE,nvl(cr.SERVICEABLE_PRODUCT_FLAG,-1),nvl(msi.SERVICEABLE_PRODUCT_FLAG,-1))=nvl(msi.SERVICEABLE_PRODUCT_FLAG,-1)
and decode(A_BASE_WARRANTY_SERVICE_ID,X_TRUE,nvl(cr.BASE_WARRANTY_SERVICE_ID,-1),nvl(msi.BASE_WARRANTY_SERVICE_ID,-1))=nvl(msi.BASE_WARRANTY_SERVICE_ID,-1)
and decode(A_PAYMENT_TERMS_ID,X_TRUE,nvl(cr.PAYMENT_TERMS_ID,-1),nvl(msi.PAYMENT_TERMS_ID,-1))=nvl(msi.PAYMENT_TERMS_ID,-1)
and decode(A_PREVENTIVE_MAINTENANCE_FLAG,X_TRUE,nvl(cr.PREVENTIVE_MAINTENANCE_FLAG,-1),nvl(msi.PREVENTIVE_MAINTENANCE_FLAG,-1))=nvl(msi.PREVENTIVE_MAINTENANCE_FLAG,-1)
and decode(A_PRIMARY_SPECIALIST_ID,X_TRUE,nvl(cr.PRIMARY_SPECIALIST_ID,-1),nvl(msi.PRIMARY_SPECIALIST_ID,-1))=nvl(msi.PRIMARY_SPECIALIST_ID,-1)
and decode(A_SECONDARY_SPECIALIST_ID,X_TRUE,nvl(cr.SECONDARY_SPECIALIST_ID,-1),nvl(msi.SECONDARY_SPECIALIST_ID,-1))=nvl(msi.SECONDARY_SPECIALIST_ID,-1)
and decode(A_SERVICEABLE_ITEM_CLASS_ID,X_TRUE,nvl(cr.SERVICEABLE_ITEM_CLASS_ID,-1),nvl(msi.SERVICEABLE_ITEM_CLASS_ID,-1))=nvl(msi.SERVICEABLE_ITEM_CLASS_ID,-1);
update mtl_system_items_interface msii
set process_flag = 3
where msii.transaction_id = cr.transaction_id;
select inventory_item_id into msicount
from mtl_system_items msi
where msi.inventory_item_id = cr.III
and msi.organization_id = cr.MORGID
--Bug 4496767 and decode(A_TIME_BILLABLE_FLAG,X_TRUE,nvl(cr.TIME_BILLABLE_FLAG,-1),nvl(msi.TIME_BILLABLE_FLAG,-1))=nvl(msi.TIME_BILLABLE_FLAG,-1)
and decode(A_MATERIAL_BILLABLE_FLAG,X_TRUE,nvl(cr.MATERIAL_BILLABLE_FLAG,-1),nvl(msi.MATERIAL_BILLABLE_FLAG,-1))=nvl(msi.MATERIAL_BILLABLE_FLAG,-1)
--Bug 4496767 and decode(A_EXPENSE_BILLABLE_FLAG,X_TRUE,nvl(cr.EXPENSE_BILLABLE_FLAG,-1),nvl(msi.EXPENSE_BILLABLE_FLAG,-1))=nvl(msi.EXPENSE_BILLABLE_FLAG,-1)
and decode(A_PRORATE_SERVICE_FLAG,X_TRUE,nvl(cr.PRORATE_SERVICE_FLAG,-1),nvl(msi.PRORATE_SERVICE_FLAG,-1))=nvl(msi.PRORATE_SERVICE_FLAG,-1)
and decode(A_COVERAGE_SCHEDULE_ID,X_TRUE,nvl(cr.COVERAGE_SCHEDULE_ID,-1),nvl(msi.COVERAGE_SCHEDULE_ID,-1))=nvl(msi.COVERAGE_SCHEDULE_ID,-1)
and decode(A_SERVICE_DURATION_PERIOD_CODE,X_TRUE,nvl(cr.SERVICE_DURATION_PERIOD_CODE,-1),nvl(msi.SERVICE_DURATION_PERIOD_CODE,-1))=nvl(msi.SERVICE_DURATION_PERIOD_CODE,-1)
and decode(A_SERVICE_DURATION,X_TRUE,nvl(cr.SERVICE_DURATION,-1),nvl(msi.SERVICE_DURATION,-1))=nvl(msi.SERVICE_DURATION,-1)
and decode(A_WARRANTY_VENDOR_ID,X_TRUE,nvl(cr.WARRANTY_VENDOR_ID,-1),nvl(msi.WARRANTY_VENDOR_ID,-1))=nvl(msi.WARRANTY_VENDOR_ID,-1);
update mtl_system_items_interface msii
set process_flag = 3
where msii.transaction_id = cr.transaction_id;
select inventory_item_id into msicount
from mtl_system_items msi
where msi.inventory_item_id = cr.III
and msi.organization_id = cr.MORGID
and decode(A_MAX_WARRANTY_AMOUNT,X_TRUE,nvl(cr.MAX_WARRANTY_AMOUNT,-1),nvl(msi.MAX_WARRANTY_AMOUNT,-1))=nvl(msi.MAX_WARRANTY_AMOUNT,-1)
and decode(A_RESPONSE_TIME_PERIOD_CODE,X_TRUE,nvl(cr.RESPONSE_TIME_PERIOD_CODE,-1),nvl(msi.RESPONSE_TIME_PERIOD_CODE,-1))=nvl(msi.RESPONSE_TIME_PERIOD_CODE,-1)
and decode(A_RESPONSE_TIME_VALUE,X_TRUE,nvl(cr.RESPONSE_TIME_VALUE,-1),nvl(msi.RESPONSE_TIME_VALUE,-1))=nvl(msi.RESPONSE_TIME_VALUE,-1)
and decode(A_NEW_REVISION_CODE,X_TRUE,nvl(cr.NEW_REVISION_CODE,-1),nvl(msi.NEW_REVISION_CODE,-1))=nvl(msi.NEW_REVISION_CODE,-1)
and decode(A_INVOICEABLE_ITEM_FLAG,X_TRUE,nvl(cr.INVOICEABLE_ITEM_FLAG,-1),nvl(msi.INVOICEABLE_ITEM_FLAG,-1))=nvl(msi.INVOICEABLE_ITEM_FLAG,-1)
and decode(A_TAX_CODE,X_TRUE,nvl(cr.TAX_CODE,-1),nvl(msi.TAX_CODE,-1))=nvl(msi.TAX_CODE,-1)
and decode(A_INVOICE_ENABLED_FLAG,X_TRUE,nvl(cr.INVOICE_ENABLED_FLAG,-1),nvl(msi.INVOICE_ENABLED_FLAG,-1))=nvl(msi.INVOICE_ENABLED_FLAG,-1)
and decode(A_MUST_USE_APPROVED_VENDOR_F,X_TRUE,nvl(cr.MUST_USE_APPROVED_VENDOR_FLAG,-1),nvl(msi.MUST_USE_APPROVED_VENDOR_FLAG,-1))=nvl(msi.MUST_USE_APPROVED_VENDOR_FLAG,-1);
update mtl_system_items_interface msii
set process_flag = 3
where msii.transaction_id = cr.transaction_id;
select inventory_item_id into msicount
from mtl_system_items msi
where msi.inventory_item_id = cr.III
and msi.organization_id = cr.MORGID
and decode(A_RELEASE_TIME_FENCE_CODE,X_TRUE,nvl(cr.RELEASE_TIME_FENCE_CODE,-1),nvl(msi.RELEASE_TIME_FENCE_CODE,-1))=nvl(msi.RELEASE_TIME_FENCE_CODE,-1)
and decode(A_RELEASE_TIME_FENCE_DAYS,X_TRUE,nvl(cr.RELEASE_TIME_FENCE_DAYS,-1),nvl(msi.RELEASE_TIME_FENCE_DAYS,-1))=nvl(msi.RELEASE_TIME_FENCE_DAYS,-1)
and decode(A_CONTAINER_ITEM_FLAG,X_TRUE,nvl(cr.CONTAINER_ITEM_FLAG,-1),nvl(msi.CONTAINER_ITEM_FLAG,-1))=nvl(msi.CONTAINER_ITEM_FLAG,-1)
and decode(A_CONTAINER_TYPE_CODE,X_TRUE,nvl(cr.CONTAINER_TYPE_CODE,-1),nvl(msi.CONTAINER_TYPE_CODE,-1))=nvl(msi.CONTAINER_TYPE_CODE,-1)
and decode(A_INTERNAL_VOLUME,X_TRUE,nvl(cr.INTERNAL_VOLUME,-1),nvl(msi.INTERNAL_VOLUME,-1))=nvl(msi.INTERNAL_VOLUME,-1)
and decode(A_MAXIMUM_LOAD_WEIGHT,X_TRUE,nvl(cr.MAXIMUM_LOAD_WEIGHT,-1),nvl(msi.MAXIMUM_LOAD_WEIGHT,-1))=nvl(msi.MAXIMUM_LOAD_WEIGHT,-1)
and decode(A_MINIMUM_FILL_PERCENT,X_TRUE,nvl(cr.MINIMUM_FILL_PERCENT,-1),nvl(msi.MINIMUM_FILL_PERCENT,-1))=nvl(msi.MINIMUM_FILL_PERCENT,-1)
and decode(A_VEHICLE_ITEM_FLAG,X_TRUE,nvl(cr.VEHICLE_ITEM_FLAG,-1),nvl(msi.VEHICLE_ITEM_FLAG,-1))=nvl(msi.VEHICLE_ITEM_FLAG,-1);
update mtl_system_items_interface msii
set process_flag = 3
where msii.transaction_id = cr.transaction_id;
select inventory_item_id into msicount
from mtl_system_items msi
where msi.inventory_item_id = cr.III
and msi.organization_id = cr.MORGID
and decode(A_TRACKING_QUANTITY_IND,X_TRUE,nvl(cr.TRACKING_QUANTITY_IND,-1),nvl(msi.TRACKING_QUANTITY_IND,-1))=nvl(msi.TRACKING_QUANTITY_IND,-1)
and decode(A_ONT_PRICING_QTY_SOURCE,X_TRUE,nvl(cr.ONT_PRICING_QTY_SOURCE,-1),nvl(msi.ONT_PRICING_QTY_SOURCE,-1))=nvl(msi.ONT_PRICING_QTY_SOURCE,-1)
and decode(A_SECONDARY_DEFAULT_IND,X_TRUE,nvl(cr.SECONDARY_DEFAULT_IND,-1),nvl(msi.SECONDARY_DEFAULT_IND,-1))=nvl(msi.SECONDARY_DEFAULT_IND,-1);
update mtl_system_items_interface msii
set process_flag = 3
where msii.transaction_id = cr.transaction_id;
select inventory_item_id into msicount
from mtl_system_items msi
where msi.inventory_item_id = cr.III
and msi.organization_id = cr.MORGID
and decode(A_CONFIG_ORGS,X_TRUE,nvl(cr.CONFIG_ORGS,-1),nvl(msi.CONFIG_ORGS,-1))=nvl(msi.CONFIG_ORGS,-1)
and decode(A_CONFIG_MATCH,X_TRUE,nvl(cr.CONFIG_MATCH,-1),nvl(msi.CONFIG_MATCH,-1))=nvl(msi.CONFIG_MATCH,-1);
update mtl_system_items_interface msii
set process_flag = 3
where msii.transaction_id = cr.transaction_id;
select inventory_item_id into msicount
from mtl_system_items msi
where msi.inventory_item_id = cr.III
and msi.organization_id = cr.MORGID
and decode(A_SO_AUTHORIZATION_FLAG,X_TRUE,nvl(cr.SO_AUTHORIZATION_FLAG,-1),nvl(msi.SO_AUTHORIZATION_FLAG,-1))=nvl(msi.SO_AUTHORIZATION_FLAG,-1)
and decode(A_VMI_MINIMUM_UNITS,X_TRUE,nvl(cr.VMI_MINIMUM_UNITS,-1),nvl(msi.VMI_MINIMUM_UNITS,-1))=nvl(msi.VMI_MINIMUM_UNITS,-1)
and decode(A_VMI_MINIMUM_DAYS,X_TRUE,nvl(cr.VMI_MINIMUM_DAYS,-1),nvl(msi.VMI_MINIMUM_DAYS,-1))= nvl(msi.VMI_MINIMUM_DAYS,-1)
and decode(A_VMI_MAXIMUM_DAYS,X_TRUE,nvl(cr.VMI_MAXIMUM_DAYS,-1),nvl(msi.VMI_MAXIMUM_DAYS,-1))= nvl(msi.VMI_MAXIMUM_DAYS,-1)
and decode(A_VMI_MAXIMUM_UNITS,X_TRUE,nvl(cr.VMI_MAXIMUM_UNITS,-1),nvl(msi.VMI_MAXIMUM_UNITS,-1))= nvl(msi.VMI_MAXIMUM_UNITS,-1)
and decode(A_VMI_FIXED_ORDER_QUANTITY,X_TRUE,nvl(cr.VMI_FIXED_ORDER_QUANTITY,-1),nvl(msi.VMI_FIXED_ORDER_QUANTITY,-1))= nvl(msi.VMI_FIXED_ORDER_QUANTITY,-1)
and decode(A_CONSIGNED_FLAG,X_TRUE,nvl(cr.CONSIGNED_FLAG,-1),nvl(msi.CONSIGNED_FLAG,-1))= nvl(msi.CONSIGNED_FLAG,-1)
and decode(A_ASN_AUTOEXPIRE_FLAG,X_TRUE,nvl(cr.ASN_AUTOEXPIRE_FLAG,-1),nvl(msi.ASN_AUTOEXPIRE_FLAG,-1))= nvl(msi.ASN_AUTOEXPIRE_FLAG,-1)
and decode(A_FORECAST_HORIZON,X_TRUE,nvl(cr.FORECAST_HORIZON,-1),nvl(msi.FORECAST_HORIZON,-1))= nvl(msi.FORECAST_HORIZON,-1)
and decode(A_EXCLUDE_FROM_BUDGET_FLAG,X_TRUE,nvl(cr.EXCLUDE_FROM_BUDGET_FLAG,-1),nvl(msi.EXCLUDE_FROM_BUDGET_FLAG,-1))= nvl(msi.EXCLUDE_FROM_BUDGET_FLAG,-1)
and decode(A_DAYS_TGT_INV_SUPPLY,X_TRUE,nvl(cr.DAYS_TGT_INV_SUPPLY,-1),nvl(msi.DAYS_TGT_INV_SUPPLY,-1))= nvl(msi.DAYS_TGT_INV_SUPPLY,-1)
and decode(A_DAYS_TGT_INV_WINDOW,X_TRUE,nvl(cr.DAYS_TGT_INV_WINDOW,-1),nvl(msi.DAYS_TGT_INV_WINDOW,-1))= nvl(msi.DAYS_TGT_INV_WINDOW,-1)
and decode(A_DAYS_MAX_INV_WINDOW,X_TRUE,nvl(cr.DAYS_MAX_INV_WINDOW,-1),nvl(msi.DAYS_MAX_INV_WINDOW,-1))= nvl(msi.DAYS_MAX_INV_WINDOW,-1)
and decode(A_DAYS_MAX_INV_SUPPLY,X_TRUE,nvl(cr.DAYS_MAX_INV_SUPPLY,-1),nvl(msi.DAYS_MAX_INV_SUPPLY,-1))= nvl(msi.DAYS_MAX_INV_SUPPLY,-1)
and decode(A_DRP_PLANNED_FLAG,X_TRUE,nvl(cr.DRP_PLANNED_FLAG,-1),nvl(msi.DRP_PLANNED_FLAG,-1))= nvl(msi.DRP_PLANNED_FLAG,-1)
and decode(A_CRITICAL_COMPONENT_FLAG,X_TRUE,nvl(cr.CRITICAL_COMPONENT_FLAG,-1),nvl(msi.CRITICAL_COMPONENT_FLAG,-1))= nvl(msi.CRITICAL_COMPONENT_FLAG,-1)
and decode(A_CONTINOUS_TRANSFER,X_TRUE,nvl(cr.CONTINOUS_TRANSFER,-1),nvl(msi.CONTINOUS_TRANSFER,-1))=nvl(msi.CONTINOUS_TRANSFER,-1)
and decode(A_VMI_FORECAST_TYPE,X_TRUE,nvl(cr.VMI_FORECAST_TYPE,-1),nvl(msi.VMI_FORECAST_TYPE,-1))=nvl(msi.VMI_FORECAST_TYPE,-1)
and decode(A_CONVERGENCE,X_TRUE,nvl(cr.CONVERGENCE,-1),nvl(msi.CONVERGENCE,-1))=nvl(msi.CONVERGENCE,-1)
and decode(A_DIVERGENCE,X_TRUE,nvl(cr.DIVERGENCE,-1),nvl(msi.DIVERGENCE,-1))=nvl(msi.DIVERGENCE,-1) ;
update mtl_system_items_interface msii
set process_flag = 3
where msii.transaction_id = cr.transaction_id;
select inventory_item_id into msicount
from mtl_system_items msi
where msi.inventory_item_id = cr.III
and msi.organization_id = cr.MORGID
and decode(A_LOT_DIVISIBLE_FLAG ,X_TRUE,nvl(cr.LOT_DIVISIBLE_FLAG ,-1),nvl(msi.LOT_DIVISIBLE_FLAG ,-1))= nvl(msi.LOT_DIVISIBLE_FLAG,-1)
and decode(A_GRADE_CONTROL_FLAG ,X_TRUE,nvl(cr.GRADE_CONTROL_FLAG ,-1),nvl(msi.GRADE_CONTROL_FLAG ,-1))= nvl(msi.GRADE_CONTROL_FLAG,-1)
and decode(A_DEFAULT_GRADE ,X_TRUE,nvl(cr.DEFAULT_GRADE ,-1),nvl(msi.DEFAULT_GRADE ,-1))= nvl(msi.DEFAULT_GRADE,-1)
and decode(A_CHILD_LOT_FLAG ,X_TRUE,nvl(cr.CHILD_LOT_FLAG ,-1),nvl(msi.CHILD_LOT_FLAG ,-1))= nvl(msi.CHILD_LOT_FLAG,-1)
and decode(A_PARENT_CHILD_GENERATION_FLAG ,X_TRUE,nvl(cr.PARENT_CHILD_GENERATION_FLAG ,-1),nvl(msi.PARENT_CHILD_GENERATION_FLAG ,-1))= nvl(msi.PARENT_CHILD_GENERATION_FLAG,-1)
and decode(A_CHILD_LOT_PREFIX ,X_TRUE,nvl(cr.CHILD_LOT_PREFIX ,-1),nvl(msi.CHILD_LOT_PREFIX ,-1))= nvl(msi.CHILD_LOT_PREFIX,-1)
and decode(A_CHILD_LOT_STARTING_NUMBER ,X_TRUE,nvl(cr.CHILD_LOT_STARTING_NUMBER ,-1),nvl(msi.CHILD_LOT_STARTING_NUMBER ,-1))= nvl(msi.CHILD_LOT_STARTING_NUMBER,-1)
and decode(A_CHILD_LOT_VALIDATION_FLAG ,X_TRUE,nvl(cr.CHILD_LOT_VALIDATION_FLAG ,-1),nvl(msi.CHILD_LOT_VALIDATION_FLAG ,-1))= nvl(msi.CHILD_LOT_VALIDATION_FLAG,-1)
and decode(A_COPY_LOT_ATTRIBUTE_FLAG ,X_TRUE,nvl(cr.COPY_LOT_ATTRIBUTE_FLAG ,-1),nvl(msi.COPY_LOT_ATTRIBUTE_FLAG ,-1))= nvl(msi.COPY_LOT_ATTRIBUTE_FLAG,-1)
and decode(A_RECIPE_ENABLED_FLAG ,X_TRUE,nvl(cr.RECIPE_ENABLED_FLAG ,-1),nvl(msi.RECIPE_ENABLED_FLAG ,-1))= nvl(msi.RECIPE_ENABLED_FLAG,-1)
and decode(A_PROCESS_QUALITY_ENABLED_FLAG ,X_TRUE,nvl(cr.PROCESS_QUALITY_ENABLED_FLAG ,-1),nvl(msi.PROCESS_QUALITY_ENABLED_FLAG ,-1))= nvl(msi.PROCESS_QUALITY_ENABLED_FLAG,-1)
and decode(A_PROCESS_EXEC_ENABLED_FLAG ,X_TRUE,nvl(cr.PROCESS_EXECUTION_ENABLED_FLAG,-1),nvl(msi.PROCESS_EXECUTION_ENABLED_FLAG,-1))= nvl(msi.PROCESS_EXECUTION_ENABLED_FLAG,-1);
update mtl_system_items_interface msii
set process_flag = 3
where msii.transaction_id = cr.transaction_id;
select inventory_item_id into msicount
from mtl_system_items msi
where msi.inventory_item_id = cr.III
and msi.organization_id = cr.MORGID
and decode(A_PROCESS_COSTING_ENABLED_FLAG ,X_TRUE,nvl(cr.PROCESS_COSTING_ENABLED_FLAG,-1),nvl(msi.PROCESS_COSTING_ENABLED_FLAG,-1))= nvl(msi.PROCESS_COSTING_ENABLED_FLAG,-1)
and decode(A_HAZARDOUS_MATERIAL_FLAG ,X_TRUE,nvl(cr.HAZARDOUS_MATERIAL_FLAG,-1),nvl(msi.HAZARDOUS_MATERIAL_FLAG,-1))= nvl(msi.HAZARDOUS_MATERIAL_FLAG,-1)
and decode(A_CAS_NUMBER ,X_TRUE,nvl(cr.CAS_NUMBER,-1),nvl(msi.CAS_NUMBER,-1))= nvl(msi.CAS_NUMBER,-1)
and decode(A_RETEST_INTERVAL ,X_TRUE,nvl(cr.RETEST_INTERVAL,-1),nvl(msi.RETEST_INTERVAL,-1))= nvl(msi.RETEST_INTERVAL,-1)
and decode(A_EXPIRATION_ACTION_INTERVAL ,X_TRUE,nvl(cr.EXPIRATION_ACTION_INTERVAL,-1),nvl(msi.EXPIRATION_ACTION_INTERVAL,-1))= nvl(msi.EXPIRATION_ACTION_INTERVAL,-1)
and decode(A_EXPIRATION_ACTION_CODE ,X_TRUE,nvl(cr.EXPIRATION_ACTION_CODE,-1),nvl(msi.EXPIRATION_ACTION_CODE,-1))= nvl(msi.EXPIRATION_ACTION_CODE,-1)
and decode(A_MATURITY_DAYS ,X_TRUE,nvl(cr.MATURITY_DAYS,-1),nvl(msi.MATURITY_DAYS,-1))= nvl(msi.MATURITY_DAYS,-1)
and decode(A_HOLD_DAYS ,X_TRUE,nvl(cr.HOLD_DAYS,-1),nvl(msi.HOLD_DAYS,-1))= nvl(msi.HOLD_DAYS,-1) ;
update mtl_system_items_interface msii
set process_flag = 3
where msii.transaction_id = cr.transaction_id;