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.DESCRIPTION,
msii.LONG_DESCRIPTION,
msii.BUYER_ID,
msii.ACCOUNTING_RULE_ID,
msii.INVOICING_RULE_ID,
msii.PURCHASING_ITEM_FLAG,
msii.SHIPPABLE_ITEM_FLAG,
msii.CUSTOMER_ORDER_FLAG,
msii.INTERNAL_ORDER_FLAG,
msii.INVENTORY_ITEM_FLAG,
msii.PURCHASING_ENABLED_FLAG,
msii.CUSTOMER_ORDER_ENABLED_FLAG,
msii.INTERNAL_ORDER_ENABLED_FLAG,
msii.SO_TRANSACTIONS_FLAG,
msii.MTL_TRANSACTIONS_ENABLED_FLAG,
msii.STOCK_ENABLED_FLAG,
msii.BOM_ENABLED_FLAG,
msii.BUILD_IN_WIP_FLAG,
msii.REVISION_QTY_CONTROL_CODE,
msii.ITEM_CATALOG_GROUP_ID,
msii.CATALOG_STATUS_FLAG,
msii.RETURNABLE_FLAG,
msii.DEFAULT_SHIPPING_ORG,
msii.COLLATERAL_FLAG,
msii.TAXABLE_FLAG,
msii.PURCHASING_TAX_CODE,
msii.QTY_RCV_EXCEPTION_CODE,
msii.ALLOW_ITEM_DESC_UPDATE_FLAG,
msii.INSPECTION_REQUIRED_FLAG,
msii.RECEIPT_REQUIRED_FLAG,
msii.MARKET_PRICE,
msii.HAZARD_CLASS_ID,
msii.RFQ_REQUIRED_FLAG,
msii.QTY_RCV_TOLERANCE,
msii.LIST_PRICE_PER_UNIT,
msii.UN_NUMBER_ID,
msii.PRICE_TOLERANCE_PERCENT,
msii.ASSET_CATEGORY_ID,
msii.ROUNDING_FACTOR,
msii.UNIT_OF_ISSUE,
msii.ENFORCE_SHIP_TO_LOCATION_CODE,
msii.ALLOW_SUBSTITUTE_RECEIPTS_FLAG,
msii.ALLOW_UNORDERED_RECEIPTS_FLAG,
msii.ALLOW_EXPRESS_DELIVERY_FLAG,
msii.DAYS_EARLY_RECEIPT_ALLOWED,
msii.DAYS_LATE_RECEIPT_ALLOWED,
msii.RECEIPT_DAYS_EXCEPTION_CODE,
msii.RECEIVING_ROUTING_ID,
msii.INVOICE_CLOSE_TOLERANCE,
msii.RECEIVE_CLOSE_TOLERANCE,
msii.AUTO_LOT_ALPHA_PREFIX,
msii.CHECK_SHORTAGES_FLAG, /*CK 21MAY98 Added new attribute*/
msii.EFFECTIVITY_CONTROL
, msii.OVERCOMPLETION_TOLERANCE_TYPE
, msii.OVERCOMPLETION_TOLERANCE_VALUE
, msii.OVER_SHIPMENT_TOLERANCE
, msii.UNDER_SHIPMENT_TOLERANCE
, msii.OVER_RETURN_TOLERANCE
, msii.UNDER_RETURN_TOLERANCE
, msii.EQUIPMENT_TYPE
, msii.RECOVERED_PART_DISP_CODE
, msii.DEFECT_TRACKING_ON_FLAG
, msii.EVENT_FLAG
, msii.ELECTRONIC_FLAG
, msii.DOWNLOADABLE_FLAG
, msii.VOL_DISCOUNT_EXEMPT_FLAG
, msii.COUPON_EXEMPT_FLAG
, msii.COMMS_NL_TRACKABLE_FLAG
, msii.ASSET_CREATION_CODE
, msii.COMMS_ACTIVATION_REQD_FLAG
, msii.ORDERABLE_ON_WEB_FLAG
, msii.BACK_ORDERABLE_FLAG
, msii.WEB_STATUS
, msii.INDIVISIBLE_FLAG
, msii.DIMENSION_UOM_CODE
, msii.UNIT_LENGTH
, msii.UNIT_WIDTH
, msii.UNIT_HEIGHT
, msii.BULK_PICKED_FLAG
, msii.LOT_STATUS_ENABLED
, msii.DEFAULT_LOT_STATUS_ID
, msii.SERIAL_STATUS_ENABLED
, msii.DEFAULT_SERIAL_STATUS_ID
, msii.LOT_SPLIT_ENABLED
, msii.LOT_MERGE_ENABLED
, msii.INVENTORY_CARRY_PENALTY
, msii.OPERATION_SLACK_PENALTY
, msii.FINANCING_ALLOWED_FLAG
, msii.EAM_ITEM_TYPE
, msii.EAM_ACTIVITY_TYPE_CODE
, msii.EAM_ACTIVITY_CAUSE_CODE
, msii.EAM_ACT_NOTIFICATION_FLAG
, msii.EAM_ACT_SHUTDOWN_STATUS
, msii.DUAL_UOM_CONTROL
, msii.SECONDARY_UOM_CODE
, msii.DUAL_UOM_DEVIATION_HIGH
, msii.DUAL_UOM_DEVIATION_LOW
--, msii.SERVICE_ITEM_FLAG
--, msii.USAGE_ITEM_FLAG
, msii.CONTRACT_ITEM_TYPE_CODE
-- , msii.SUBSCRIPTION_DEPEND_FLAG
--
, msii.SERV_REQ_ENABLED_CODE
, msii.SERV_BILLING_ENABLED_FLAG
-- , msii.SERV_IMPORTANCE_LEVEL
, msii.PLANNED_INV_POINT_FLAG
, msii.LOT_TRANSLATE_ENABLED
, msii.DEFAULT_SO_SOURCE_TYPE
, msii.CREATE_SUPPLY_FLAG
, msii.SUBSTITUTION_WINDOW_CODE
, msii.SUBSTITUTION_WINDOW_DAYS
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
AND attribute_group_id_gui IN
(20, 25, 30, 31, 35, 40, 41, 51,
60, 62, 65, 70, 80, 90, 100, 120, 130);
A_ALLOW_ITEM_DESC_UPDATE_FLAG number := 2;
if substr(att.attribute_name,18) = 'ALLOW_ITEM_DESC_UPDATE_FLAG' then
A_ALLOW_ITEM_DESC_UPDATE_FLAG := att.control_level;
select inventory_item_id into msicount
from mtl_system_items_B msi
where msi.inventory_item_id = cr.III
and msi.organization_id = cr.MORGID
and decode(A_BUYER_ID,X_TRUE,nvl(cr.BUYER_ID,-1),nvl(msi.BUYER_ID,-1))=nvl(msi.BUYER_ID,-1)
and decode(A_ACCOUNTING_RULE_ID,X_TRUE,nvl(cr.ACCOUNTING_RULE_ID,-1),nvl(msi.ACCOUNTING_RULE_ID,-1))=nvl(msi.ACCOUNTING_RULE_ID,-1)
and decode(A_INVOICING_RULE_ID,X_TRUE,nvl(cr.INVOICING_RULE_ID,-1),nvl(msi.INVOICING_RULE_ID,-1))=nvl(msi.INVOICING_RULE_ID,-1)
and decode(A_PURCHASING_ITEM_FLAG,X_TRUE,nvl(cr.PURCHASING_ITEM_FLAG,-1),nvl(msi.PURCHASING_ITEM_FLAG,-1))=nvl(msi.PURCHASING_ITEM_FLAG,-1)
and decode(A_SHIPPABLE_ITEM_FLAG,X_TRUE,nvl(cr.SHIPPABLE_ITEM_FLAG,-1),nvl(msi.SHIPPABLE_ITEM_FLAG,-1))=nvl(msi.SHIPPABLE_ITEM_FLAG,-1)
and decode(A_CUSTOMER_ORDER_FLAG,X_TRUE,nvl(cr.CUSTOMER_ORDER_FLAG,-1),nvl(msi.CUSTOMER_ORDER_FLAG,-1))=nvl(msi.CUSTOMER_ORDER_FLAG,-1)
and decode(A_INTERNAL_ORDER_FLAG,X_TRUE,nvl(cr.INTERNAL_ORDER_FLAG,-1),nvl(msi.INTERNAL_ORDER_FLAG,-1))=nvl(msi.INTERNAL_ORDER_FLAG,-1)
and decode(A_INVENTORY_ITEM_FLAG,X_TRUE,nvl(cr.INVENTORY_ITEM_FLAG,-1),nvl(msi.INVENTORY_ITEM_FLAG,-1))=nvl(msi.INVENTORY_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_B msi
where msi.inventory_item_id = cr.III
and msi.organization_id = cr.MORGID
and decode(A_PURCHASING_ENABLED_FLAG,X_TRUE,nvl(cr.PURCHASING_ENABLED_FLAG,-1),nvl(msi.PURCHASING_ENABLED_FLAG,-1))=nvl(msi.PURCHASING_ENABLED_FLAG,-1)
and decode(A_CUSTOMER_ORDER_ENABLED_FLAG,X_TRUE,nvl(cr.CUSTOMER_ORDER_ENABLED_FLAG,-1),nvl(msi.CUSTOMER_ORDER_ENABLED_FLAG,-1))=nvl(msi.CUSTOMER_ORDER_ENABLED_FLAG,-1)
and decode(A_INTERNAL_ORDER_ENABLED_FLAG,X_TRUE,nvl(cr.INTERNAL_ORDER_ENABLED_FLAG,-1),nvl(msi.INTERNAL_ORDER_ENABLED_FLAG,-1))=nvl(msi.INTERNAL_ORDER_ENABLED_FLAG,-1)
and decode(A_SO_TRANSACTIONS_FLAG,X_TRUE,nvl(cr.SO_TRANSACTIONS_FLAG,-1),nvl(msi.SO_TRANSACTIONS_FLAG,-1))=nvl(msi.SO_TRANSACTIONS_FLAG,-1)
and decode(A_MTL_TRANSACTIONS_ENABLED_F,X_TRUE,nvl(cr.MTL_TRANSACTIONS_ENABLED_FLAG,-1),nvl(msi.MTL_TRANSACTIONS_ENABLED_FLAG,-1))=nvl(msi.MTL_TRANSACTIONS_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_B msi
where msi.inventory_item_id = cr.III
and msi.organization_id = cr.MORGID
and decode(A_STOCK_ENABLED_FLAG,X_TRUE,nvl(cr.STOCK_ENABLED_FLAG,-1),nvl(msi.STOCK_ENABLED_FLAG,-1))=nvl(msi.STOCK_ENABLED_FLAG,-1)
and decode(A_BOM_ENABLED_FLAG,X_TRUE,nvl(cr.BOM_ENABLED_FLAG,-1),nvl(msi.BOM_ENABLED_FLAG,-1))=nvl(msi.BOM_ENABLED_FLAG,-1)
and decode(A_BUILD_IN_WIP_FLAG,X_TRUE,nvl(cr.BUILD_IN_WIP_FLAG,-1),nvl(msi.BUILD_IN_WIP_FLAG,-1))=nvl(msi.BUILD_IN_WIP_FLAG,-1)
and decode(A_REVISION_QTY_CONTROL_CODE,X_TRUE,nvl(cr.REVISION_QTY_CONTROL_CODE,-1),nvl(msi.REVISION_QTY_CONTROL_CODE,-1))=nvl(msi.REVISION_QTY_CONTROL_CODE,-1)
and decode(A_ITEM_CATALOG_GROUP_ID,X_TRUE,nvl(cr.ITEM_CATALOG_GROUP_ID,-1),nvl(msi.ITEM_CATALOG_GROUP_ID,-1))=nvl(msi.ITEM_CATALOG_GROUP_ID,-1)
and decode(A_CHECK_SHORTAGES_FLAG,X_TRUE,nvl(cr.CHECK_SHORTAGES_FLAG,-1),nvl(msi.CHECK_SHORTAGES_FLAG,-1))=nvl(msi.CHECK_SHORTAGES_FLAG,-1)
and decode(A_WEB_STATUS,
X_TRUE, nvl(cr.WEB_STATUS, -1),
nvl(msi.WEB_STATUS, -1)
) = nvl(msi.WEB_STATUS, -1)
and decode(A_INDIVISIBLE_FLAG,
X_TRUE, nvl(cr.INDIVISIBLE_FLAG, -1),
nvl(msi.INDIVISIBLE_FLAG, -1)
) = nvl(msi.INDIVISIBLE_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_B msi
where msi.inventory_item_id = cr.III
and msi.organization_id = cr.MORGID
and decode(A_CATALOG_STATUS_FLAG,X_TRUE,nvl(cr.CATALOG_STATUS_FLAG,-1),nvl(msi.CATALOG_STATUS_FLAG,-1))=nvl(msi.CATALOG_STATUS_FLAG,-1)
and decode(A_RETURNABLE_FLAG,X_TRUE,nvl(cr.RETURNABLE_FLAG,-1),nvl(msi.RETURNABLE_FLAG,-1))=nvl(msi.RETURNABLE_FLAG,-1)
and decode(A_DEFAULT_SHIPPING_ORG,X_TRUE,nvl(cr.DEFAULT_SHIPPING_ORG,-1),nvl(msi.DEFAULT_SHIPPING_ORG,-1))=nvl(msi.DEFAULT_SHIPPING_ORG,-1)
and decode(A_COLLATERAL_FLAG,X_TRUE,nvl(cr.COLLATERAL_FLAG,-1),nvl(msi.COLLATERAL_FLAG,-1))=nvl(msi.COLLATERAL_FLAG,-1)
and decode(A_TAXABLE_FLAG,X_TRUE,nvl(cr.TAXABLE_FLAG,-1),nvl(msi.TAXABLE_FLAG,-1))=nvl(msi.TAXABLE_FLAG,-1)
and decode(A_PURCHASING_TAX_CODE,X_TRUE,nvl(cr.PURCHASING_TAX_CODE,-1),nvl(msi.PURCHASING_TAX_CODE,-1))=nvl(msi.PURCHASING_TAX_CODE,-1)
and decode(A_QTY_RCV_EXCEPTION_CODE,X_TRUE,nvl(cr.QTY_RCV_EXCEPTION_CODE,-1),nvl(msi.QTY_RCV_EXCEPTION_CODE,-1))=nvl(msi.QTY_RCV_EXCEPTION_CODE,-1)
and decode(A_ALLOW_ITEM_DESC_UPDATE_FLAG,X_TRUE,nvl(cr.ALLOW_ITEM_DESC_UPDATE_FLAG,-1),nvl(msi.ALLOW_ITEM_DESC_UPDATE_FLAG,-1))=nvl(msi.ALLOW_ITEM_DESC_UPDATE_FLAG,-1)
and decode(A_INSPECTION_REQUIRED_FLAG,X_TRUE,nvl(cr.INSPECTION_REQUIRED_FLAG,-1),nvl(msi.INSPECTION_REQUIRED_FLAG,-1))=nvl(msi.INSPECTION_REQUIRED_FLAG,-1)
and decode(A_RECEIPT_REQUIRED_FLAG,X_TRUE,nvl(cr.RECEIPT_REQUIRED_FLAG,-1),nvl(msi.RECEIPT_REQUIRED_FLAG,-1))=nvl(msi.RECEIPT_REQUIRED_FLAG,-1)
and decode(A_MARKET_PRICE,X_TRUE,nvl(cr.MARKET_PRICE,-1),nvl(msi.MARKET_PRICE,-1))=nvl(msi.MARKET_PRICE,-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_B msi
where msi.inventory_item_id = cr.III
and msi.organization_id = cr.MORGID
and decode(A_HAZARD_CLASS_ID,X_TRUE,nvl(cr.HAZARD_CLASS_ID,-1),nvl(msi.HAZARD_CLASS_ID,-1))=nvl(msi.HAZARD_CLASS_ID,-1)
and decode(A_RFQ_REQUIRED_FLAG,X_TRUE,nvl(cr.RFQ_REQUIRED_FLAG,-1),nvl(msi.RFQ_REQUIRED_FLAG,-1))=nvl(msi.RFQ_REQUIRED_FLAG,-1)
and decode(A_QTY_RCV_TOLERANCE,X_TRUE,nvl(cr.QTY_RCV_TOLERANCE,-1),nvl(msi.QTY_RCV_TOLERANCE,-1))=nvl(msi.QTY_RCV_TOLERANCE,-1)
and decode(A_LIST_PRICE_PER_UNIT,X_TRUE,nvl(cr.LIST_PRICE_PER_UNIT,-1),nvl(msi.LIST_PRICE_PER_UNIT,-1))=nvl(msi.LIST_PRICE_PER_UNIT,-1)
and decode(A_UN_NUMBER_ID,X_TRUE,nvl(cr.UN_NUMBER_ID,-1),nvl(msi.UN_NUMBER_ID,-1))=nvl(msi.UN_NUMBER_ID,-1)
and decode(A_PRICE_TOLERANCE_PERCENT,X_TRUE,nvl(cr.PRICE_TOLERANCE_PERCENT,-1),nvl(msi.PRICE_TOLERANCE_PERCENT,-1))=nvl(msi.PRICE_TOLERANCE_PERCENT,-1)
and decode(A_ASSET_CATEGORY_ID,X_TRUE,nvl(cr.ASSET_CATEGORY_ID,-1),nvl(msi.ASSET_CATEGORY_ID,-1))=nvl(msi.ASSET_CATEGORY_ID,-1)
and decode(A_ROUNDING_FACTOR,X_TRUE,nvl(cr.ROUNDING_FACTOR,-1),nvl(msi.ROUNDING_FACTOR,-1))=nvl(msi.ROUNDING_FACTOR,-1)
and decode(A_UNIT_OF_ISSUE,X_TRUE,nvl(cr.UNIT_OF_ISSUE,-1),nvl(msi.UNIT_OF_ISSUE,-1))=nvl(msi.UNIT_OF_ISSUE,-1)
and decode(A_ENFORCE_SHIP_TO_LOCATION_C,X_TRUE,nvl(cr.ENFORCE_SHIP_TO_LOCATION_CODE,-1),nvl(msi.ENFORCE_SHIP_TO_LOCATION_CODE,-1))=nvl(msi.ENFORCE_SHIP_TO_LOCATION_CODE,-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_B msi
where msi.inventory_item_id = cr.III
and msi.organization_id = cr.MORGID
and decode(A_ALLOW_SUBSTITUTE_RECEIPTS_F,X_TRUE,nvl(cr.ALLOW_SUBSTITUTE_RECEIPTS_FLAG,-1),nvl(msi.ALLOW_SUBSTITUTE_RECEIPTS_FLAG,-1))=nvl(msi.ALLOW_SUBSTITUTE_RECEIPTS_FLAG,-1)
and decode(A_ALLOW_UNORDERED_RECEIPTS_F,X_TRUE,nvl(cr.ALLOW_UNORDERED_RECEIPTS_FLAG,-1),nvl(msi.ALLOW_UNORDERED_RECEIPTS_FLAG,-1))=nvl(msi.ALLOW_UNORDERED_RECEIPTS_FLAG,-1)
and decode(A_ALLOW_EXPRESS_DELIVERY_FLAG,X_TRUE,nvl(cr.ALLOW_EXPRESS_DELIVERY_FLAG,-1),nvl(msi.ALLOW_EXPRESS_DELIVERY_FLAG,-1))=nvl(msi.ALLOW_EXPRESS_DELIVERY_FLAG,-1)
and decode(A_DAYS_EARLY_RECEIPT_ALLOWED,X_TRUE,nvl(cr.DAYS_EARLY_RECEIPT_ALLOWED,-1),nvl(msi.DAYS_EARLY_RECEIPT_ALLOWED,-1))=nvl(msi.DAYS_EARLY_RECEIPT_ALLOWED,-1)
and decode(A_DAYS_LATE_RECEIPT_ALLOWED,X_TRUE,nvl(cr.DAYS_LATE_RECEIPT_ALLOWED,-1),nvl(msi.DAYS_LATE_RECEIPT_ALLOWED,-1))=nvl(msi.DAYS_LATE_RECEIPT_ALLOWED,-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_VL msi
where msi.inventory_item_id = cr.III
and msi.organization_id = cr.MORGID
and decode(A_RECEIPT_DAYS_EXCEPTION_CODE,X_TRUE,nvl(cr.RECEIPT_DAYS_EXCEPTION_CODE,-1),nvl(msi.RECEIPT_DAYS_EXCEPTION_CODE,-1))=nvl(msi.RECEIPT_DAYS_EXCEPTION_CODE,-1)
and decode(A_RECEIVING_ROUTING_ID,X_TRUE,nvl(cr.RECEIVING_ROUTING_ID,-1),nvl(msi.RECEIVING_ROUTING_ID,-1))=nvl(msi.RECEIVING_ROUTING_ID,-1)
and decode(A_INVOICE_CLOSE_TOLERANCE,X_TRUE,nvl(cr.INVOICE_CLOSE_TOLERANCE,-1),nvl(msi.INVOICE_CLOSE_TOLERANCE,-1))=nvl(msi.INVOICE_CLOSE_TOLERANCE,-1)
and decode(A_RECEIVE_CLOSE_TOLERANCE,X_TRUE,nvl(cr.RECEIVE_CLOSE_TOLERANCE,-1),nvl(msi.RECEIVE_CLOSE_TOLERANCE,-1))=nvl(msi.RECEIVE_CLOSE_TOLERANCE,-1)
and decode(A_DESCRIPTION,X_TRUE,nvl(cr.DESCRIPTION,-1),nvl(msi.DESCRIPTION,-1))=nvl(msi.DESCRIPTION,-1)
and decode(A_LONG_DESCRIPTION,X_TRUE,nvl(cr.LONG_DESCRIPTION,-1),nvl(msi.LONG_DESCRIPTION,-1))=nvl(msi.LONG_DESCRIPTION,-1)
and decode(A_AUTO_LOT_ALPHA_PREFIX,X_TRUE,nvl(cr.AUTO_LOT_ALPHA_PREFIX,-1),nvl(msi.AUTO_LOT_ALPHA_PREFIX,-1))=nvl(msi.AUTO_LOT_ALPHA_PREFIX,-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_b msi
WHERE msi.inventory_item_id = cr.III
AND msi.organization_id = cr.MORGID
AND DECODE( A_OVERCOMPLETION_TOLERANCE_TYP,
x_true, NVL(cr.OVERCOMPLETION_TOLERANCE_TYPE, -1),
NVL(msi.OVERCOMPLETION_TOLERANCE_TYPE, -1)
) = NVL(msi.OVERCOMPLETION_TOLERANCE_TYPE, -1)
AND DECODE( A_OVERCOMPLETION_TOLERANCE_VAL,
x_true, NVL(cr.OVERCOMPLETION_TOLERANCE_VALUE, -1),
NVL(msi.OVERCOMPLETION_TOLERANCE_VALUE, -1)
) = NVL(msi.OVERCOMPLETION_TOLERANCE_VALUE, -1)
AND DECODE( A_OVER_SHIPMENT_TOLERANCE,
x_true, NVL(cr.OVER_SHIPMENT_TOLERANCE, -1),
NVL(msi.OVER_SHIPMENT_TOLERANCE, -1)
) = NVL(msi.OVER_SHIPMENT_TOLERANCE, -1)
AND DECODE( A_UNDER_SHIPMENT_TOLERANCE,
x_true, NVL(cr.UNDER_SHIPMENT_TOLERANCE, -1),
NVL(msi.UNDER_SHIPMENT_TOLERANCE, -1)
) = NVL(msi.UNDER_SHIPMENT_TOLERANCE, -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_b msi
WHERE msi.inventory_item_id = cr.III
AND msi.organization_id = cr.MORGID
AND DECODE( A_OVER_RETURN_TOLERANCE,
x_true, NVL(cr.OVER_RETURN_TOLERANCE, -1),
NVL(msi.OVER_RETURN_TOLERANCE, -1)
) = NVL(msi.OVER_RETURN_TOLERANCE, -1)
AND DECODE( A_UNDER_RETURN_TOLERANCE,
x_true, NVL(cr.UNDER_RETURN_TOLERANCE, -1),
NVL(msi.UNDER_RETURN_TOLERANCE, -1)
) = NVL(msi.UNDER_RETURN_TOLERANCE, -1)
AND DECODE( A_EQUIPMENT_TYPE,
x_true, NVL(cr.EQUIPMENT_TYPE, -1),
NVL(msi.EQUIPMENT_TYPE, -1)
) = NVL(msi.EQUIPMENT_TYPE, -1)
AND DECODE( A_RECOVERED_PART_DISP_CODE,
x_true, NVL(cr.RECOVERED_PART_DISP_CODE, -1),
NVL(msi.RECOVERED_PART_DISP_CODE, -1)
) = NVL(msi.RECOVERED_PART_DISP_CODE, -1)
AND DECODE( A_DEFECT_TRACKING_ON_FLAG,
x_true, NVL(cr.DEFECT_TRACKING_ON_FLAG, -1),
NVL(msi.DEFECT_TRACKING_ON_FLAG, -1)
) = NVL(msi.DEFECT_TRACKING_ON_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_b msi
WHERE msi.inventory_item_id = cr.III
AND msi.organization_id = cr.MORGID
AND DECODE( A_EVENT_FLAG,
x_true, NVL(cr.EVENT_FLAG, -1),
NVL(msi.EVENT_FLAG, -1)
) = NVL(msi.EVENT_FLAG, -1)
AND DECODE( A_ELECTRONIC_FLAG,
x_true, NVL(cr.ELECTRONIC_FLAG, -1),
NVL(msi.ELECTRONIC_FLAG, -1)
) = NVL(msi.ELECTRONIC_FLAG, -1)
AND DECODE( A_DOWNLOADABLE_FLAG,
x_true, NVL(cr.DOWNLOADABLE_FLAG, -1),
NVL(msi.DOWNLOADABLE_FLAG, -1)
) = NVL(msi.DOWNLOADABLE_FLAG, -1)
AND DECODE( A_VOL_DISCOUNT_EXEMPT_FLAG,
x_true, NVL(cr.VOL_DISCOUNT_EXEMPT_FLAG, -1),
NVL(msi.VOL_DISCOUNT_EXEMPT_FLAG, -1)
) = NVL(msi.VOL_DISCOUNT_EXEMPT_FLAG, -1)
AND DECODE( A_COUPON_EXEMPT_FLAG,
x_true, NVL(cr.COUPON_EXEMPT_FLAG, -1),
NVL(msi.COUPON_EXEMPT_FLAG, -1)
) = NVL(msi.COUPON_EXEMPT_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_b msi
WHERE msi.inventory_item_id = cr.III
AND msi.organization_id = cr.MORGID
AND DECODE( A_COMMS_NL_TRACKABLE_FLAG,
x_true, NVL(cr.COMMS_NL_TRACKABLE_FLAG, -1),
NVL(msi.COMMS_NL_TRACKABLE_FLAG, -1)
) = NVL(msi.COMMS_NL_TRACKABLE_FLAG, -1)
AND DECODE( A_ASSET_CREATION_CODE,
x_true, NVL(cr.ASSET_CREATION_CODE, -1),
NVL(msi.ASSET_CREATION_CODE, -1)
) = NVL(msi.ASSET_CREATION_CODE, -1)
AND DECODE( A_COMMS_ACTIVATION_REQD_FLAG,
x_true, NVL(cr.COMMS_ACTIVATION_REQD_FLAG, -1),
NVL(msi.COMMS_ACTIVATION_REQD_FLAG, -1)
) = NVL(msi.COMMS_ACTIVATION_REQD_FLAG, -1)
AND DECODE( A_ORDERABLE_ON_WEB_FLAG,
x_true, NVL(cr.ORDERABLE_ON_WEB_FLAG, -1),
NVL(msi.ORDERABLE_ON_WEB_FLAG, -1)
) = NVL(msi.ORDERABLE_ON_WEB_FLAG, -1)
AND DECODE( A_BACK_ORDERABLE_FLAG,
x_true, NVL(cr.BACK_ORDERABLE_FLAG, -1),
NVL(msi.BACK_ORDERABLE_FLAG, -1)
) = NVL(msi.BACK_ORDERABLE_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_b msi
WHERE msi.inventory_item_id = cr.III
AND msi.organization_id = cr.MORGID
AND DECODE( A_DIMENSION_UOM_CODE,
x_true, NVL(cr.DIMENSION_UOM_CODE, -1),
NVL(msi.DIMENSION_UOM_CODE, -1)
) = NVL(msi.DIMENSION_UOM_CODE, -1)
AND DECODE( A_UNIT_LENGTH,
x_true, NVL(cr.UNIT_LENGTH, -1),
NVL(msi.UNIT_LENGTH, -1)
) = NVL(msi.UNIT_LENGTH, -1)
AND DECODE( A_UNIT_WIDTH,
x_true, NVL(cr.UNIT_WIDTH, -1),
NVL(msi.UNIT_WIDTH, -1)
) = NVL(msi.UNIT_WIDTH, -1)
AND DECODE( A_UNIT_HEIGHT,
x_true, NVL(cr.UNIT_HEIGHT, -1),
NVL(msi.UNIT_HEIGHT, -1)
) = NVL(msi.UNIT_HEIGHT, -1)
AND DECODE( A_BULK_PICKED_FLAG,
x_true, NVL(cr.BULK_PICKED_FLAG, -1),
NVL(msi.BULK_PICKED_FLAG, -1)
) = NVL(msi.BULK_PICKED_FLAG, -1)
AND DECODE( A_LOT_STATUS_ENABLED,
x_true, NVL(cr.LOT_STATUS_ENABLED, -1),
NVL(msi.LOT_STATUS_ENABLED, -1)
) = NVL(msi.LOT_STATUS_ENABLED, -1)
AND DECODE( A_DEFAULT_LOT_STATUS_ID,
x_true, NVL(cr.DEFAULT_LOT_STATUS_ID, -1),
NVL(msi.DEFAULT_LOT_STATUS_ID, -1)
) = NVL(msi.DEFAULT_LOT_STATUS_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_b msi
WHERE msi.inventory_item_id = cr.III
AND msi.organization_id = cr.MORGID
AND DECODE( A_SERIAL_STATUS_ENABLED,
x_true, NVL(cr.SERIAL_STATUS_ENABLED, -1),
NVL(msi.SERIAL_STATUS_ENABLED, -1)
) = NVL(msi.SERIAL_STATUS_ENABLED, -1)
AND DECODE( A_DEFAULT_SERIAL_STATUS_ID,
x_true, NVL(cr.DEFAULT_SERIAL_STATUS_ID, -1),
NVL(msi.DEFAULT_SERIAL_STATUS_ID, -1)
) = NVL(msi.DEFAULT_SERIAL_STATUS_ID, -1)
AND DECODE( A_LOT_SPLIT_ENABLED,
x_true, NVL(cr.LOT_SPLIT_ENABLED, -1),
NVL(msi.LOT_SPLIT_ENABLED, -1)
) = NVL(msi.LOT_SPLIT_ENABLED, -1)
AND DECODE( A_LOT_MERGE_ENABLED,
x_true, NVL(cr.LOT_MERGE_ENABLED, -1),
NVL(msi.LOT_MERGE_ENABLED, -1)
) = NVL(msi.LOT_MERGE_ENABLED, -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_b msi
WHERE msi.inventory_item_id = cr.III
AND msi.organization_id = cr.MORGID
AND DECODE( A_INVENTORY_CARRY_PENALTY,
x_true, NVL(cr.INVENTORY_CARRY_PENALTY, -1),
NVL(msi.INVENTORY_CARRY_PENALTY, -1)
) = NVL(msi.INVENTORY_CARRY_PENALTY, -1)
AND DECODE( A_OPERATION_SLACK_PENALTY,
x_true, NVL(cr.OPERATION_SLACK_PENALTY, -1),
NVL(msi.OPERATION_SLACK_PENALTY, -1)
) = NVL(msi.OPERATION_SLACK_PENALTY, -1)
AND DECODE( A_FINANCING_ALLOWED_FLAG,
x_true, NVL(cr.FINANCING_ALLOWED_FLAG, -1),
NVL(msi.FINANCING_ALLOWED_FLAG, -1)
) = NVL(msi.FINANCING_ALLOWED_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_b msi
WHERE msi.inventory_item_id = cr.III
AND msi.organization_id = cr.MORGID
AND DECODE( A_EAM_ITEM_TYPE,
x_true, NVL(cr.EAM_ITEM_TYPE, -1),
NVL(msi.EAM_ITEM_TYPE, -1)
) = NVL(msi.EAM_ITEM_TYPE, -1)
AND DECODE( A_EAM_ACTIVITY_TYPE_CODE,
x_true, NVL(cr.EAM_ACTIVITY_TYPE_CODE, -1),
NVL(msi.EAM_ACTIVITY_TYPE_CODE, -1)
) = NVL(msi.EAM_ACTIVITY_TYPE_CODE, -1)
AND DECODE( A_EAM_ACTIVITY_CAUSE_CODE,
x_true, NVL(cr.EAM_ACTIVITY_CAUSE_CODE, -1),
NVL(msi.EAM_ACTIVITY_CAUSE_CODE, -1)
) = NVL(msi.EAM_ACTIVITY_CAUSE_CODE, -1)
AND DECODE( A_EAM_ACT_NOTIFICATION_FLAG,
x_true, NVL(cr.EAM_ACT_NOTIFICATION_FLAG, -1),
NVL(msi.EAM_ACT_NOTIFICATION_FLAG, -1)
) = NVL(msi.EAM_ACT_NOTIFICATION_FLAG, -1)
AND DECODE( A_EAM_ACT_SHUTDOWN_STATUS,
x_true, NVL(cr.EAM_ACT_SHUTDOWN_STATUS, -1),
NVL(msi.EAM_ACT_SHUTDOWN_STATUS, -1)
) = NVL(msi.EAM_ACT_SHUTDOWN_STATUS, -1)
AND DECODE( A_DUAL_UOM_CONTROL,
x_true, NVL(cr.DUAL_UOM_CONTROL, -1),
NVL(msi.DUAL_UOM_CONTROL, -1)
) = NVL(msi.DUAL_UOM_CONTROL, -1)
AND DECODE( A_SECONDARY_UOM_CODE,
x_true, NVL(cr.SECONDARY_UOM_CODE, -1),
NVL(msi.SECONDARY_UOM_CODE, -1)
) = NVL(msi.SECONDARY_UOM_CODE, -1)
AND DECODE( A_DUAL_UOM_DEVIATION_HIGH,
x_true, NVL(cr.DUAL_UOM_DEVIATION_HIGH, -1),
NVL(msi.DUAL_UOM_DEVIATION_HIGH, -1)
) = NVL(msi.DUAL_UOM_DEVIATION_HIGH, -1)
AND DECODE( A_DUAL_UOM_DEVIATION_LOW,
x_true, NVL(cr.DUAL_UOM_DEVIATION_LOW, -1),
NVL(msi.DUAL_UOM_DEVIATION_LOW, -1)
) = NVL(msi.DUAL_UOM_DEVIATION_LOW, -1)
/*
and decode(A_SERVICE_ITEM_FLAG, X_TRUE, nvl(cr.SERVICE_ITEM_FLAG,-1), nvl(msi.SERVICE_ITEM_FLAG,-1)) = nvl(msi.SERVICE_ITEM_FLAG,-1)
AND DECODE( A_USAGE_ITEM_FLAG,
x_true, NVL(cr.USAGE_ITEM_FLAG, -1),
NVL(msi.USAGE_ITEM_FLAG, -1)
) = NVL(msi.USAGE_ITEM_FLAG, -1)
*/
AND DECODE( A_CONTRACT_ITEM_TYPE_CODE,
x_true, NVL(cr.CONTRACT_ITEM_TYPE_CODE, -1),
NVL(msi.CONTRACT_ITEM_TYPE_CODE, -1)
) = NVL(msi.CONTRACT_ITEM_TYPE_CODE, -1)
/* AND DECODE( A_SUBSCRIPTION_DEPEND_FLAG,
x_true, NVL(cr.SUBSCRIPTION_DEPEND_FLAG, -1),
NVL(msi.SUBSCRIPTION_DEPEND_FLAG, -1)
) = NVL(msi.SUBSCRIPTION_DEPEND_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_b msi
WHERE msi.inventory_item_id = cr.III
AND msi.organization_id = cr.MORGID
AND DECODE( A_SERV_REQ_ENABLED_CODE,
x_true, NVL(cr.SERV_REQ_ENABLED_CODE, -1),
NVL(msi.SERV_REQ_ENABLED_CODE, -1)
) = NVL(msi.SERV_REQ_ENABLED_CODE, -1)
AND DECODE( A_SERV_BILLING_ENABLED_FLAG,
x_true, NVL(cr.SERV_BILLING_ENABLED_FLAG, -1),
NVL(msi.SERV_BILLING_ENABLED_FLAG, -1)
) = NVL(msi.SERV_BILLING_ENABLED_FLAG, -1)
/* AND DECODE( A_SERV_IMPORTANCE_LEVEL,
x_true, NVL(cr.SERV_IMPORTANCE_LEVEL, -1),
NVL(msi.SERV_IMPORTANCE_LEVEL, -1)
) = NVL(msi.SERV_IMPORTANCE_LEVEL, -1)
*/
AND DECODE( A_PLANNED_INV_POINT_FLAG,
x_true, NVL(cr.PLANNED_INV_POINT_FLAG, -1),
NVL(msi.PLANNED_INV_POINT_FLAG, -1)
) = NVL(msi.PLANNED_INV_POINT_FLAG, -1)
AND DECODE( A_LOT_TRANSLATE_ENABLED,
x_true, NVL(cr.LOT_TRANSLATE_ENABLED, -1),
NVL(msi.LOT_TRANSLATE_ENABLED, -1)
) = NVL(msi.LOT_TRANSLATE_ENABLED, -1)
AND DECODE( A_DEFAULT_SO_SOURCE_TYPE,
x_true, NVL(cr.DEFAULT_SO_SOURCE_TYPE, -1),
NVL(msi.DEFAULT_SO_SOURCE_TYPE, -1)
) = NVL(msi.DEFAULT_SO_SOURCE_TYPE, -1)
AND DECODE( A_CREATE_SUPPLY_FLAG,
x_true, NVL(cr.CREATE_SUPPLY_FLAG, -1),
NVL(msi.CREATE_SUPPLY_FLAG, -1)
) = NVL(msi.CREATE_SUPPLY_FLAG, -1)
AND DECODE( A_SUBSTITUTION_WINDOW_CODE,
x_true, NVL(cr.SUBSTITUTION_WINDOW_CODE, -1),
NVL(msi.SUBSTITUTION_WINDOW_CODE, -1)
) = NVL(msi.SUBSTITUTION_WINDOW_CODE, -1)
AND DECODE( A_SUBSTITUTION_WINDOW_DAYS,
x_true, NVL(cr.SUBSTITUTION_WINDOW_DAYS, -1),
NVL(msi.SUBSTITUTION_WINDOW_DAYS, -1)
) = NVL(msi.SUBSTITUTION_WINDOW_DAYS, -1)
;
update mtl_system_items_interface msii
set process_flag = 3
where msii.transaction_id = cr.transaction_id;