The following lines contain the word 'select', 'insert', 'update' or 'delete':
A_ALLOW_ITEM_DESC_UPDATE_FLAG NUMBER := 2;
FUNCTION validate_item_update_master
(
org_id NUMBER,
all_org NUMBER := 2,
prog_appid NUMBER := -1,
prog_id NUMBER := -1,
request_id NUMBER := -1,
user_id NUMBER := -1,
login_id NUMBER := -1,
err_text IN OUT NOCOPY VARCHAR2,
xset_id IN NUMBER DEFAULT NULL
)
RETURN INTEGER
IS
/* Bug 4460686. Dont pick up master records when AUTO_CHILD already exists as
this will create duplicate AUTO_CHILD records */
CURSOR C_msii_master_records
IS
SELECT
ROWID,
INVENTORY_ITEM_ID,
ORGANIZATION_ID,
TRANSACTION_ID
FROM
MTL_SYSTEM_ITEMS_INTERFACE
WHERE
process_flag = 4
AND set_process_id = xset_id
AND ( (organization_id = org_id) or (all_org = 1) )
AND organization_id IN
( select organization_id
from MTL_PARAMETERS
where organization_id = master_organization_id
)
AND not exists
(select 1 from mtl_system_items_interface
where set_process_id = xset_id + 1000000000000
and transaction_type = 'AUTO_CHILD'
and process_flag = 4
);
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); /* Bug 3713912 Added 130*/
ret_code_update NUMBER;
INVPUTLI.info('INVUPD2B: Inside validate_item_update_master'|| '***orgid: ' || TO_CHAR(org_id));
ELSIF l_attribute_name = 'ALLOW_ITEM_DESC_UPDATE_FLAG' THEN A_ALLOW_ITEM_DESC_UPDATE_FLAG := rec.control_level;
-- call additional update validations on master record
ret_code_update := INVUPD2B.update_validations(
rec.ROWID,
rec.ORGANIZATION_ID,
t_trans_id,
user_id,
login_id,
prog_appid,
prog_id,
request_id);
SELECT process_flag into m_process_flag
FROM mtl_system_items_interface
WHERE rowid = rec.rowid;
if (ret_code_update = 0 AND m_process_flag=4) THEN
ret_code := INVUPD2B.check_child_records(
rec.ROWID,
rec.INVENTORY_ITEM_ID,
rec.ORGANIZATION_ID,
t_trans_id,
prog_appid,
prog_id,
request_id,
user_id,
login_id,
err_text,
tmp_xset_id); --5351611
update mtl_system_items_interface
set set_process_id = xset_id + 1000000000000
where set_process_id = tmp_xset_id + 1000000000000 ; --5405867
update mtl_system_items_interface
set process_flag = 4
where inventory_item_id = rec.inventory_item_id
and SET_PROCESS_ID = xset_id + 1000000000000
and TRANSACTION_TYPE = 'AUTO_CHILD';
'When OTHERS exception raised in validate_item_update_master ' ||
SQLCODE ||
' - ' ||
SQLERRM,1,240));
END validate_item_update_master;
SELECT SUBSTR(ATTRIBUTE_NAME,18) Attribute_Code
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));
SELECT * INTO m_Item_rec
FROM mtl_system_items_interface
WHERE rowid = mast_rowid;
SELECT * INTO l_Item_rec
FROM mtl_system_items_vl
WHERE inventory_item_id = item_id
AND organization_id = org_id;
ELSIF ( l_attribute_code = 'ALLOW_ITEM_DESC_UPDATE_FLAG' AND (NVL(l_item_rec.ALLOW_ITEM_DESC_UPDATE_FLAG,'!') <> NVL(m_item_rec.ALLOW_ITEM_DESC_UPDATE_FLAG,'!'))) THEN
l_create_child := TRUE;
select
MSI.INVENTORY_ITEM_ID,
MSI.ORGANIZATION_ID
from MTL_SYSTEM_ITEMS_B MSI, MTL_PARAMETERS MP
where MP.master_organization_id = org_id
and MP.organization_id = MSI.organization_id
and MSI.inventory_item_id = inv_item_id
and MSI.organization_id <> MP.master_organization_id;
CURSOR C_msii_forupdate_records is
select
ROWID, ORGANIZATION_ID
from MTL_SYSTEM_ITEMS_INTERFACE
where SET_PROCESS_ID = xset_id + 1000000000000
and PROCESS_FLAG = 4
and INVENTORY_ITEM_ID = inv_item_id;
ret_code_update NUMBER := 0;
ret_code := INVUPD2B.create_child_update_mast_attr(master_row_id, crec.INVENTORY_ITEM_ID, crec.ORGANIZATION_ID, xset_id);
for rec in C_msii_forupdate_records loop
ret_code_update := INVUPD2B.update_validations(
rec.ROWID,
rec.ORGANIZATION_ID,
trans_id,
user_id,
login_id,
prog_appid,
prog_id,
request_id);
exit when ret_code_update = 1;
if (ret_code_create = 1 OR ret_code_update = 1) then
return (1);
FUNCTION create_child_update_mast_attr
(
master_row_id ROWID,
inv_item_id NUMBER,
org_id NUMBER,
xset_id IN NUMBER
)
return INTEGER
IS
ret_code NUMBER;
INVPUTLI.info('INVUPD2B: Inside create_child_update_mast_attr'|| '***orgid: ' || TO_CHAR(org_id));
INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
(
TRANSACTION_ID,
INVENTORY_ITEM_ID,
ORGANIZATION_ID,
SET_PROCESS_ID,
TRANSACTION_TYPE,
SUMMARY_FLAG,
ENABLED_FLAG,
START_DATE_ACTIVE,
END_DATE_ACTIVE,
DESCRIPTION,
LONG_DESCRIPTION,
BUYER_ID,
ACCOUNTING_RULE_ID,
INVOICING_RULE_ID,
SEGMENT1,
SEGMENT2,
SEGMENT3,
SEGMENT4,
SEGMENT5,
SEGMENT6,
SEGMENT7,
SEGMENT8,
SEGMENT9,
SEGMENT10,
SEGMENT11,
SEGMENT12,
SEGMENT13,
SEGMENT14,
SEGMENT15,
SEGMENT16,
SEGMENT17,
SEGMENT18,
SEGMENT19,
SEGMENT20,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
/* Start Bug 3713912 */
ATTRIBUTE16 ,
ATTRIBUTE17 ,
ATTRIBUTE18 ,
ATTRIBUTE19 ,
ATTRIBUTE20 ,
ATTRIBUTE21 ,
ATTRIBUTE22 ,
ATTRIBUTE23 ,
ATTRIBUTE24 ,
ATTRIBUTE25 ,
ATTRIBUTE26 ,
ATTRIBUTE27 ,
ATTRIBUTE28 ,
ATTRIBUTE29 ,
ATTRIBUTE30 ,
/* End Bug 3713912 */
GLOBAL_ATTRIBUTE_CATEGORY,
GLOBAL_ATTRIBUTE1,
GLOBAL_ATTRIBUTE2,
GLOBAL_ATTRIBUTE3,
GLOBAL_ATTRIBUTE4,
GLOBAL_ATTRIBUTE5,
GLOBAL_ATTRIBUTE6,
GLOBAL_ATTRIBUTE7,
GLOBAL_ATTRIBUTE8,
GLOBAL_ATTRIBUTE9,
GLOBAL_ATTRIBUTE10,
GLOBAL_ATTRIBUTE11,
GLOBAL_ATTRIBUTE12,
GLOBAL_ATTRIBUTE13,
GLOBAL_ATTRIBUTE14,
GLOBAL_ATTRIBUTE15,
GLOBAL_ATTRIBUTE16,
GLOBAL_ATTRIBUTE17,
GLOBAL_ATTRIBUTE18,
GLOBAL_ATTRIBUTE19,
GLOBAL_ATTRIBUTE20,
PURCHASING_ITEM_FLAG,
SHIPPABLE_ITEM_FLAG,
CUSTOMER_ORDER_FLAG,
INTERNAL_ORDER_FLAG,
INVENTORY_ITEM_FLAG,
ENG_ITEM_FLAG,
INVENTORY_ASSET_FLAG,
PURCHASING_ENABLED_FLAG,
CUSTOMER_ORDER_ENABLED_FLAG,
INTERNAL_ORDER_ENABLED_FLAG,
SO_TRANSACTIONS_FLAG,
MTL_TRANSACTIONS_ENABLED_FLAG,
STOCK_ENABLED_FLAG,
BOM_ENABLED_FLAG,
BUILD_IN_WIP_FLAG,
REVISION_QTY_CONTROL_CODE,
ITEM_CATALOG_GROUP_ID,
CATALOG_STATUS_FLAG,
RETURNABLE_FLAG,
DEFAULT_SHIPPING_ORG,
COLLATERAL_FLAG,
TAXABLE_FLAG,
PURCHASING_TAX_CODE,
QTY_RCV_EXCEPTION_CODE,
ALLOW_ITEM_DESC_UPDATE_FLAG,
INSPECTION_REQUIRED_FLAG,
RECEIPT_REQUIRED_FLAG,
MARKET_PRICE,
HAZARD_CLASS_ID,
RFQ_REQUIRED_FLAG,
QTY_RCV_TOLERANCE,
LIST_PRICE_PER_UNIT,
UN_NUMBER_ID,
PRICE_TOLERANCE_PERCENT,
ASSET_CATEGORY_ID,
ROUNDING_FACTOR,
UNIT_OF_ISSUE,
ENFORCE_SHIP_TO_LOCATION_CODE,
ALLOW_SUBSTITUTE_RECEIPTS_FLAG,
ALLOW_UNORDERED_RECEIPTS_FLAG,
ALLOW_EXPRESS_DELIVERY_FLAG,
DAYS_EARLY_RECEIPT_ALLOWED,
DAYS_LATE_RECEIPT_ALLOWED,
RECEIPT_DAYS_EXCEPTION_CODE,
RECEIVING_ROUTING_ID,
INVOICE_CLOSE_TOLERANCE,
RECEIVE_CLOSE_TOLERANCE,
AUTO_LOT_ALPHA_PREFIX,
START_AUTO_LOT_NUMBER,
LOT_CONTROL_CODE,
SHELF_LIFE_CODE,
SHELF_LIFE_DAYS,
SERIAL_NUMBER_CONTROL_CODE,
START_AUTO_SERIAL_NUMBER,
AUTO_SERIAL_ALPHA_PREFIX,
SOURCE_TYPE,
SOURCE_ORGANIZATION_ID,
SOURCE_SUBINVENTORY,
EXPENSE_ACCOUNT,
ENCUMBRANCE_ACCOUNT,
RESTRICT_SUBINVENTORIES_CODE,
UNIT_WEIGHT,
WEIGHT_UOM_CODE,
VOLUME_UOM_CODE,
UNIT_VOLUME,
RESTRICT_LOCATORS_CODE,
LOCATION_CONTROL_CODE,
SHRINKAGE_RATE,
ACCEPTABLE_EARLY_DAYS,
PLANNING_TIME_FENCE_CODE,
DEMAND_TIME_FENCE_CODE,
RELEASE_TIME_FENCE_CODE,
LEAD_TIME_LOT_SIZE,
STD_LOT_SIZE,
CUM_MANUFACTURING_LEAD_TIME,
OVERRUN_PERCENTAGE,
MRP_CALCULATE_ATP_FLAG,
ACCEPTABLE_RATE_INCREASE,
ACCEPTABLE_RATE_DECREASE,
CUMULATIVE_TOTAL_LEAD_TIME,
PLANNING_TIME_FENCE_DAYS,
DEMAND_TIME_FENCE_DAYS,
RELEASE_TIME_FENCE_DAYS,
END_ASSEMBLY_PEGGING_FLAG,
REPETITIVE_PLANNING_FLAG,
PLANNING_EXCEPTION_SET,
BOM_ITEM_TYPE,
PICK_COMPONENTS_FLAG,
REPLENISH_TO_ORDER_FLAG,
BASE_ITEM_ID,
ATP_COMPONENTS_FLAG,
ATP_FLAG,
FIXED_LEAD_TIME,
VARIABLE_LEAD_TIME,
WIP_SUPPLY_LOCATOR_ID,
WIP_SUPPLY_TYPE,
WIP_SUPPLY_SUBINVENTORY,
PRIMARY_UOM_CODE,
PRIMARY_UNIT_OF_MEASURE,
ALLOWED_UNITS_LOOKUP_CODE,
COST_OF_SALES_ACCOUNT,
SALES_ACCOUNT,
DEFAULT_INCLUDE_IN_ROLLUP_FLAG,
INVENTORY_ITEM_STATUS_CODE,
INVENTORY_PLANNING_CODE,
PLANNER_CODE,
PLANNING_MAKE_BUY_CODE,
FIXED_LOT_MULTIPLIER,
ROUNDING_CONTROL_TYPE,
CARRYING_COST,
POSTPROCESSING_LEAD_TIME,
PREPROCESSING_LEAD_TIME,
FULL_LEAD_TIME,
ORDER_COST,
MRP_SAFETY_STOCK_PERCENT,
MRP_SAFETY_STOCK_CODE,
MIN_MINMAX_QUANTITY,
MAX_MINMAX_QUANTITY,
MINIMUM_ORDER_QUANTITY,
FIXED_ORDER_QUANTITY,
FIXED_DAYS_SUPPLY,
MAXIMUM_ORDER_QUANTITY,
ATP_RULE_ID,
PICKING_RULE_ID,
RESERVABLE_TYPE,
POSITIVE_MEASUREMENT_ERROR,
NEGATIVE_MEASUREMENT_ERROR,
ENGINEERING_ECN_CODE,
ENGINEERING_ITEM_ID,
ENGINEERING_DATE,
SERVICE_STARTING_DELAY,
SERVICEABLE_COMPONENT_FLAG,
SERVICEABLE_PRODUCT_FLAG,
BASE_WARRANTY_SERVICE_ID,
PAYMENT_TERMS_ID,
PREVENTIVE_MAINTENANCE_FLAG,
PRIMARY_SPECIALIST_ID,
SECONDARY_SPECIALIST_ID,
SERVICEABLE_ITEM_CLASS_ID,
TIME_BILLABLE_FLAG,
MATERIAL_BILLABLE_FLAG,
EXPENSE_BILLABLE_FLAG,
PRORATE_SERVICE_FLAG,
COVERAGE_SCHEDULE_ID,
SERVICE_DURATION_PERIOD_CODE,
SERVICE_DURATION,
WARRANTY_VENDOR_ID,
MAX_WARRANTY_AMOUNT,
RESPONSE_TIME_PERIOD_CODE,
RESPONSE_TIME_VALUE,
NEW_REVISION_CODE,
INVOICEABLE_ITEM_FLAG,
TAX_CODE,
INVOICE_ENABLED_FLAG,
MUST_USE_APPROVED_VENDOR_FLAG,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
OUTSIDE_OPERATION_FLAG,
OUTSIDE_OPERATION_UOM_TYPE,
SAFETY_STOCK_BUCKET_DAYS,
AUTO_REDUCE_MPS,
COSTING_ENABLED_FLAG,
AUTO_CREATED_CONFIG_FLAG,
CYCLE_COUNT_ENABLED_FLAG,
ITEM_TYPE,
MODEL_CONFIG_CLAUSE_NAME,
SHIP_MODEL_COMPLETE_FLAG,
MRP_PLANNING_CODE,
RETURN_INSPECTION_REQUIREMENT,
ATO_FORECAST_CONTROL,
CONTAINER_ITEM_FLAG,
VEHICLE_ITEM_FLAG,
MAXIMUM_LOAD_WEIGHT,
MINIMUM_FILL_PERCENT,
CONTAINER_TYPE_CODE,
INTERNAL_VOLUME,
CHECK_SHORTAGES_FLAG
, EFFECTIVITY_CONTROL
, OVERCOMPLETION_TOLERANCE_TYPE
, OVERCOMPLETION_TOLERANCE_VALUE
, OVER_SHIPMENT_TOLERANCE
, UNDER_SHIPMENT_TOLERANCE
, OVER_RETURN_TOLERANCE
, UNDER_RETURN_TOLERANCE
, EQUIPMENT_TYPE
, RECOVERED_PART_DISP_CODE
, DEFECT_TRACKING_ON_FLAG
, EVENT_FLAG
, ELECTRONIC_FLAG
, DOWNLOADABLE_FLAG
, VOL_DISCOUNT_EXEMPT_FLAG
, COUPON_EXEMPT_FLAG
, COMMS_NL_TRACKABLE_FLAG
, ASSET_CREATION_CODE
, COMMS_ACTIVATION_REQD_FLAG
, ORDERABLE_ON_WEB_FLAG
, BACK_ORDERABLE_FLAG
, WEB_STATUS
, INDIVISIBLE_FLAG
, DIMENSION_UOM_CODE
, UNIT_LENGTH
, UNIT_WIDTH
, UNIT_HEIGHT
, BULK_PICKED_FLAG
, LOT_STATUS_ENABLED
, DEFAULT_LOT_STATUS_ID
, SERIAL_STATUS_ENABLED
, DEFAULT_SERIAL_STATUS_ID
, LOT_SPLIT_ENABLED
, LOT_MERGE_ENABLED
, INVENTORY_CARRY_PENALTY
, OPERATION_SLACK_PENALTY
, FINANCING_ALLOWED_FLAG
, EAM_ITEM_TYPE
, EAM_ACTIVITY_TYPE_CODE
, EAM_ACTIVITY_CAUSE_CODE
, EAM_ACT_NOTIFICATION_FLAG
, EAM_ACT_SHUTDOWN_STATUS
, DUAL_UOM_CONTROL
, SECONDARY_UOM_CODE
, DUAL_UOM_DEVIATION_HIGH
, DUAL_UOM_DEVIATION_LOW
--, SERVICE_ITEM_FLAG
--, VENDOR_WARRANTY_FLAG
--, USAGE_ITEM_FLAG
, CONTRACT_ITEM_TYPE_CODE
-- , SUBSCRIPTION_DEPEND_FLAG
--
, SERV_REQ_ENABLED_CODE
, SERV_BILLING_ENABLED_FLAG
-- , SERV_IMPORTANCE_LEVEL
, PLANNED_INV_POINT_FLAG
, LOT_TRANSLATE_ENABLED
, DEFAULT_SO_SOURCE_TYPE
, CREATE_SUPPLY_FLAG
, SUBSTITUTION_WINDOW_CODE
, SUBSTITUTION_WINDOW_DAYS
--Added as part of 11.5.9
, LOT_SUBSTITUTION_ENABLED
, MINIMUM_LICENSE_QUANTITY
, EAM_ACTIVITY_SOURCE_CODE
, IB_ITEM_INSTANCE_CLASS
, CONFIG_MODEL_TYPE
--Added as part of 11.5.10
, TRACKING_QUANTITY_IND
, ONT_PRICING_QTY_SOURCE
, SECONDARY_DEFAULT_IND
, CONFIG_ORGS
, CONFIG_MATCH
,VMI_MINIMUM_UNITS
,VMI_MINIMUM_DAYS
,VMI_MAXIMUM_UNITS
,VMI_MAXIMUM_DAYS
,VMI_FIXED_ORDER_QUANTITY
,SO_AUTHORIZATION_FLAG
,CONSIGNED_FLAG
,ASN_AUTOEXPIRE_FLAG
,VMI_FORECAST_TYPE
,FORECAST_HORIZON
,EXCLUDE_FROM_BUDGET_FLAG
,DAYS_TGT_INV_SUPPLY
,DAYS_TGT_INV_WINDOW
,DAYS_MAX_INV_SUPPLY
,DAYS_MAX_INV_WINDOW
,DRP_PLANNED_FLAG
,CRITICAL_COMPONENT_FLAG
,CONTINOUS_TRANSFER
,CONVERGENCE
,DIVERGENCE ,
/* Start Bug 3713912 */
LOT_DIVISIBLE_FLAG ,
GRADE_CONTROL_FLAG ,
DEFAULT_GRADE ,
CHILD_LOT_FLAG ,
PARENT_CHILD_GENERATION_FLAG ,
CHILD_LOT_PREFIX ,
CHILD_LOT_STARTING_NUMBER ,
CHILD_LOT_VALIDATION_FLAG ,
COPY_LOT_ATTRIBUTE_FLAG ,
RECIPE_ENABLED_FLAG ,
PROCESS_QUALITY_ENABLED_FLAG ,
PROCESS_EXECUTION_ENABLED_FLAG ,
PROCESS_COSTING_ENABLED_FLAG ,
PROCESS_SUPPLY_SUBINVENTORY ,
PROCESS_SUPPLY_LOCATOR_ID ,
PROCESS_YIELD_SUBINVENTORY ,
PROCESS_YIELD_LOCATOR_ID ,
HAZARDOUS_MATERIAL_FLAG ,
CAS_NUMBER ,
RETEST_INTERVAL ,
EXPIRATION_ACTION_INTERVAL ,
EXPIRATION_ACTION_CODE ,
MATURITY_DAYS ,
HOLD_DAYS,
/* End Bug 3713912 */
--R12 Enhancement
CHARGE_PERIODICITY_CODE,
REPAIR_LEADTIME,
REPAIR_YIELD,
PREPOSITION_POINT,
REPAIR_PROGRAM,
SUBCONTRACTING_COMPONENT,
OUTSOURCED_ASSEMBLY,
/* Bug 6397416*/
GDSN_OUTBOUND_ENABLED_FLAG,
TRADE_ITEM_DESCRIPTOR,
STYLE_ITEM_FLAG,
STYLE_ITEM_ID)
SELECT
MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL,
inv_item_id,
org_id,
xset_id + 1000000000000,
'AUTO_CHILD',
MSI.SUMMARY_FLAG,
MSI.ENABLED_FLAG,
MSI.START_DATE_ACTIVE,
MSI.END_DATE_ACTIVE,
MSI.DESCRIPTION,
MSI.LONG_DESCRIPTION,
MSI.BUYER_ID,
MSI.ACCOUNTING_RULE_ID,
MSI.INVOICING_RULE_ID,
MSI.SEGMENT1,
MSI.SEGMENT2,
MSI.SEGMENT3,
MSI.SEGMENT4,
MSI.SEGMENT5,
MSI.SEGMENT6,
MSI.SEGMENT7,
MSI.SEGMENT8,
MSI.SEGMENT9,
MSI.SEGMENT10,
MSI.SEGMENT11,
MSI.SEGMENT12,
MSI.SEGMENT13,
MSI.SEGMENT14,
MSI.SEGMENT15,
MSI.SEGMENT16,
MSI.SEGMENT17,
MSI.SEGMENT18,
MSI.SEGMENT19,
MSI.SEGMENT20,
MSI.ATTRIBUTE_CATEGORY,
MSI.ATTRIBUTE1,
MSI.ATTRIBUTE2,
MSI.ATTRIBUTE3,
MSI.ATTRIBUTE4,
MSI.ATTRIBUTE5,
MSI.ATTRIBUTE6,
MSI.ATTRIBUTE7,
MSI.ATTRIBUTE8,
MSI.ATTRIBUTE9,
MSI.ATTRIBUTE10,
MSI.ATTRIBUTE11,
MSI.ATTRIBUTE12,
MSI.ATTRIBUTE13,
MSI.ATTRIBUTE14,
MSI.ATTRIBUTE15,
/* Start Bug 3713912 */
MSI.ATTRIBUTE16 ,
MSI.ATTRIBUTE17 ,
MSI.ATTRIBUTE18 ,
MSI.ATTRIBUTE19 ,
MSI.ATTRIBUTE20 ,
MSI.ATTRIBUTE21 ,
MSI.ATTRIBUTE22 ,
MSI.ATTRIBUTE23 ,
MSI.ATTRIBUTE24 ,
MSI.ATTRIBUTE25 ,
MSI.ATTRIBUTE26 ,
MSI.ATTRIBUTE27 ,
MSI.ATTRIBUTE28 ,
MSI.ATTRIBUTE29 ,
MSI.ATTRIBUTE30 ,
/* End Bug 3713912 */
MSI.GLOBAL_ATTRIBUTE_CATEGORY,
MSI.GLOBAL_ATTRIBUTE1,
MSI.GLOBAL_ATTRIBUTE2,
MSI.GLOBAL_ATTRIBUTE3,
MSI.GLOBAL_ATTRIBUTE4,
MSI.GLOBAL_ATTRIBUTE5,
MSI.GLOBAL_ATTRIBUTE6,
MSI.GLOBAL_ATTRIBUTE7,
MSI.GLOBAL_ATTRIBUTE8,
MSI.GLOBAL_ATTRIBUTE9,
MSI.GLOBAL_ATTRIBUTE10,
MSI.GLOBAL_ATTRIBUTE11,
MSI.GLOBAL_ATTRIBUTE12,
MSI.GLOBAL_ATTRIBUTE13,
MSI.GLOBAL_ATTRIBUTE14,
MSI.GLOBAL_ATTRIBUTE15,
MSI.GLOBAL_ATTRIBUTE16,
MSI.GLOBAL_ATTRIBUTE17,
MSI.GLOBAL_ATTRIBUTE18,
MSI.GLOBAL_ATTRIBUTE19,
MSI.GLOBAL_ATTRIBUTE20,
MSI.PURCHASING_ITEM_FLAG,
MSI.SHIPPABLE_ITEM_FLAG,
MSI.CUSTOMER_ORDER_FLAG,
MSI.INTERNAL_ORDER_FLAG,
MSI.INVENTORY_ITEM_FLAG,
MSI.ENG_ITEM_FLAG,
MSI.INVENTORY_ASSET_FLAG,
MSI.PURCHASING_ENABLED_FLAG,
MSI.CUSTOMER_ORDER_ENABLED_FLAG,
MSI.INTERNAL_ORDER_ENABLED_FLAG,
MSI.SO_TRANSACTIONS_FLAG,
MSI.MTL_TRANSACTIONS_ENABLED_FLAG,
MSI.STOCK_ENABLED_FLAG,
MSI.BOM_ENABLED_FLAG,
MSI.BUILD_IN_WIP_FLAG,
MSI.REVISION_QTY_CONTROL_CODE,
MSI.ITEM_CATALOG_GROUP_ID,
MSI.CATALOG_STATUS_FLAG,
MSI.RETURNABLE_FLAG,
MSI.DEFAULT_SHIPPING_ORG,
MSI.COLLATERAL_FLAG,
MSI.TAXABLE_FLAG,
MSI.PURCHASING_TAX_CODE,
MSI.QTY_RCV_EXCEPTION_CODE,
MSI.ALLOW_ITEM_DESC_UPDATE_FLAG,
MSI.INSPECTION_REQUIRED_FLAG,
MSI.RECEIPT_REQUIRED_FLAG,
MSI.MARKET_PRICE,
MSI.HAZARD_CLASS_ID,
MSI.RFQ_REQUIRED_FLAG,
MSI.QTY_RCV_TOLERANCE,
MSI.LIST_PRICE_PER_UNIT,
MSI.UN_NUMBER_ID,
MSI.PRICE_TOLERANCE_PERCENT,
MSI.ASSET_CATEGORY_ID,
MSI.ROUNDING_FACTOR,
MSI.UNIT_OF_ISSUE,
MSI.ENFORCE_SHIP_TO_LOCATION_CODE,
MSI.ALLOW_SUBSTITUTE_RECEIPTS_FLAG,
MSI.ALLOW_UNORDERED_RECEIPTS_FLAG,
MSI.ALLOW_EXPRESS_DELIVERY_FLAG,
MSI.DAYS_EARLY_RECEIPT_ALLOWED,
MSI.DAYS_LATE_RECEIPT_ALLOWED,
MSI.RECEIPT_DAYS_EXCEPTION_CODE,
MSI.RECEIVING_ROUTING_ID,
MSI.INVOICE_CLOSE_TOLERANCE,
MSI.RECEIVE_CLOSE_TOLERANCE,
MSI.AUTO_LOT_ALPHA_PREFIX,
MSI.START_AUTO_LOT_NUMBER,
MSI.LOT_CONTROL_CODE,
MSI.SHELF_LIFE_CODE,
MSI.SHELF_LIFE_DAYS,
MSI.SERIAL_NUMBER_CONTROL_CODE,
MSI.START_AUTO_SERIAL_NUMBER,
MSI.AUTO_SERIAL_ALPHA_PREFIX,
MSI.SOURCE_TYPE,
MSI.SOURCE_ORGANIZATION_ID,
MSI.SOURCE_SUBINVENTORY,
MSI.EXPENSE_ACCOUNT,
MSI.ENCUMBRANCE_ACCOUNT,
MSI.RESTRICT_SUBINVENTORIES_CODE,
MSI.UNIT_WEIGHT,
MSI.WEIGHT_UOM_CODE,
MSI.VOLUME_UOM_CODE,
MSI.UNIT_VOLUME,
MSI.RESTRICT_LOCATORS_CODE,
MSI.LOCATION_CONTROL_CODE,
MSI.SHRINKAGE_RATE,
MSI.ACCEPTABLE_EARLY_DAYS,
MSI.PLANNING_TIME_FENCE_CODE,
MSI.DEMAND_TIME_FENCE_CODE,
MSI.RELEASE_TIME_FENCE_CODE,
MSI.LEAD_TIME_LOT_SIZE,
MSI.STD_LOT_SIZE,
MSI.CUM_MANUFACTURING_LEAD_TIME,
MSI.OVERRUN_PERCENTAGE,
MSI.MRP_CALCULATE_ATP_FLAG,
MSI.ACCEPTABLE_RATE_INCREASE,
MSI.ACCEPTABLE_RATE_DECREASE,
MSI.CUMULATIVE_TOTAL_LEAD_TIME,
MSI.PLANNING_TIME_FENCE_DAYS,
MSI.DEMAND_TIME_FENCE_DAYS,
MSI.RELEASE_TIME_FENCE_DAYS,
MSI.END_ASSEMBLY_PEGGING_FLAG,
MSI.REPETITIVE_PLANNING_FLAG,
MSI.PLANNING_EXCEPTION_SET,
MSI.BOM_ITEM_TYPE,
MSI.PICK_COMPONENTS_FLAG,
MSI.REPLENISH_TO_ORDER_FLAG,
MSI.BASE_ITEM_ID,
MSI.ATP_COMPONENTS_FLAG,
MSI.ATP_FLAG,
MSI.FIXED_LEAD_TIME,
MSI.VARIABLE_LEAD_TIME,
MSI.WIP_SUPPLY_LOCATOR_ID,
MSI.WIP_SUPPLY_TYPE,
MSI.WIP_SUPPLY_SUBINVENTORY,
MSI.PRIMARY_UOM_CODE,
MSI.PRIMARY_UNIT_OF_MEASURE,
MSI.ALLOWED_UNITS_LOOKUP_CODE,
MSI.COST_OF_SALES_ACCOUNT,
MSI.SALES_ACCOUNT,
MSI.DEFAULT_INCLUDE_IN_ROLLUP_FLAG,
MSI.INVENTORY_ITEM_STATUS_CODE,
MSI.INVENTORY_PLANNING_CODE,
MSI.PLANNER_CODE,
MSI.PLANNING_MAKE_BUY_CODE,
MSI.FIXED_LOT_MULTIPLIER,
MSI.ROUNDING_CONTROL_TYPE,
MSI.CARRYING_COST,
MSI.POSTPROCESSING_LEAD_TIME,
MSI.PREPROCESSING_LEAD_TIME,
MSI.FULL_LEAD_TIME,
MSI.ORDER_COST,
MSI.MRP_SAFETY_STOCK_PERCENT,
MSI.MRP_SAFETY_STOCK_CODE,
MSI.MIN_MINMAX_QUANTITY,
MSI.MAX_MINMAX_QUANTITY,
MSI.MINIMUM_ORDER_QUANTITY,
MSI.FIXED_ORDER_QUANTITY,
MSI.FIXED_DAYS_SUPPLY,
MSI.MAXIMUM_ORDER_QUANTITY,
MSI.ATP_RULE_ID,
MSI.PICKING_RULE_ID,
MSI.RESERVABLE_TYPE,
MSI.POSITIVE_MEASUREMENT_ERROR,
MSI.NEGATIVE_MEASUREMENT_ERROR,
MSI.ENGINEERING_ECN_CODE,
MSI.ENGINEERING_ITEM_ID,
MSI.ENGINEERING_DATE,
MSI.SERVICE_STARTING_DELAY,
MSI.SERVICEABLE_COMPONENT_FLAG,
MSI.SERVICEABLE_PRODUCT_FLAG,
MSI.BASE_WARRANTY_SERVICE_ID,
MSI.PAYMENT_TERMS_ID,
MSI.PREVENTIVE_MAINTENANCE_FLAG,
MSI.PRIMARY_SPECIALIST_ID,
MSI.SECONDARY_SPECIALIST_ID,
MSI.SERVICEABLE_ITEM_CLASS_ID,
MSI.TIME_BILLABLE_FLAG,
MSI.MATERIAL_BILLABLE_FLAG,
MSI.EXPENSE_BILLABLE_FLAG,
MSI.PRORATE_SERVICE_FLAG,
MSI.COVERAGE_SCHEDULE_ID,
MSI.SERVICE_DURATION_PERIOD_CODE,
MSI.SERVICE_DURATION,
MSI.WARRANTY_VENDOR_ID,
MSI.MAX_WARRANTY_AMOUNT,
MSI.RESPONSE_TIME_PERIOD_CODE,
MSI.RESPONSE_TIME_VALUE,
MSI.NEW_REVISION_CODE,
MSI.INVOICEABLE_ITEM_FLAG,
MSI.TAX_CODE,
MSI.INVOICE_ENABLED_FLAG,
MSI.MUST_USE_APPROVED_VENDOR_FLAG,
MSI.REQUEST_ID,
MSI.PROGRAM_APPLICATION_ID,
MSI.PROGRAM_ID,
MSI.PROGRAM_UPDATE_DATE,
MSI.OUTSIDE_OPERATION_FLAG,
MSI.OUTSIDE_OPERATION_UOM_TYPE,
MSI.SAFETY_STOCK_BUCKET_DAYS,
MSI.AUTO_REDUCE_MPS,
MSI.COSTING_ENABLED_FLAG,
MSI.AUTO_CREATED_CONFIG_FLAG,
MSI.CYCLE_COUNT_ENABLED_FLAG,
MSI.ITEM_TYPE,
MSI.MODEL_CONFIG_CLAUSE_NAME,
MSI.SHIP_MODEL_COMPLETE_FLAG,
MSI.MRP_PLANNING_CODE,
MSI.RETURN_INSPECTION_REQUIREMENT,
MSI.ATO_FORECAST_CONTROL,
MSI.CONTAINER_ITEM_FLAG,
MSI.VEHICLE_ITEM_FLAG,
MSI.MAXIMUM_LOAD_WEIGHT,
MSI.MINIMUM_FILL_PERCENT,
MSI.CONTAINER_TYPE_CODE,
MSI.INTERNAL_VOLUME,
MSI.CHECK_SHORTAGES_FLAG
, MSI.EFFECTIVITY_CONTROL
, MSI.OVERCOMPLETION_TOLERANCE_TYPE
, MSI.OVERCOMPLETION_TOLERANCE_VALUE
, MSI.OVER_SHIPMENT_TOLERANCE
, MSI.UNDER_SHIPMENT_TOLERANCE
, MSI.OVER_RETURN_TOLERANCE
, MSI.UNDER_RETURN_TOLERANCE
, MSI.EQUIPMENT_TYPE
, MSI.RECOVERED_PART_DISP_CODE
, MSI.DEFECT_TRACKING_ON_FLAG
, MSI.EVENT_FLAG
, MSI.ELECTRONIC_FLAG
, MSI.DOWNLOADABLE_FLAG
, MSI.VOL_DISCOUNT_EXEMPT_FLAG
, MSI.COUPON_EXEMPT_FLAG
, MSI.COMMS_NL_TRACKABLE_FLAG
, MSI.ASSET_CREATION_CODE
, MSI.COMMS_ACTIVATION_REQD_FLAG
, MSI.ORDERABLE_ON_WEB_FLAG
, MSI.BACK_ORDERABLE_FLAG
, MSI.WEB_STATUS
, MSI.INDIVISIBLE_FLAG
, MSI.DIMENSION_UOM_CODE
, MSI.UNIT_LENGTH
, MSI.UNIT_WIDTH
, MSI.UNIT_HEIGHT
, MSI.BULK_PICKED_FLAG
, MSI.LOT_STATUS_ENABLED
, MSI.DEFAULT_LOT_STATUS_ID
, MSI.SERIAL_STATUS_ENABLED
, MSI.DEFAULT_SERIAL_STATUS_ID
, MSI.LOT_SPLIT_ENABLED
, MSI.LOT_MERGE_ENABLED
, MSI.INVENTORY_CARRY_PENALTY
, MSI.OPERATION_SLACK_PENALTY
, MSI.FINANCING_ALLOWED_FLAG
, MSI.EAM_ITEM_TYPE
, MSI.EAM_ACTIVITY_TYPE_CODE
, MSI.EAM_ACTIVITY_CAUSE_CODE
, MSI.EAM_ACT_NOTIFICATION_FLAG
, MSI.EAM_ACT_SHUTDOWN_STATUS
, MSI.DUAL_UOM_CONTROL
, MSI.SECONDARY_UOM_CODE
, MSI.DUAL_UOM_DEVIATION_HIGH
, MSI.DUAL_UOM_DEVIATION_LOW
--, MSI.SERVICE_ITEM_FLAG
--, MSI.VENDOR_WARRANTY_FLAG
--, MSI.USAGE_ITEM_FLAG
, MSI.CONTRACT_ITEM_TYPE_CODE
-- , MSI.SUBSCRIPTION_DEPEND_FLAG
--
, MSI.SERV_REQ_ENABLED_CODE
, MSI.SERV_BILLING_ENABLED_FLAG
-- , MSI.SERV_IMPORTANCE_LEVEL
, MSI.PLANNED_INV_POINT_FLAG
, MSI.LOT_TRANSLATE_ENABLED
, MSI.DEFAULT_SO_SOURCE_TYPE
, MSI.CREATE_SUPPLY_FLAG
, MSI.SUBSTITUTION_WINDOW_CODE
, MSI.SUBSTITUTION_WINDOW_DAYS
--Added as part of 11.5.9
, MSI.LOT_SUBSTITUTION_ENABLED
, MSI.MINIMUM_LICENSE_QUANTITY
, MSI.EAM_ACTIVITY_SOURCE_CODE
, MSI.IB_ITEM_INSTANCE_CLASS
, MSI.CONFIG_MODEL_TYPE
--Added as part of 11.5.10
, MSI.TRACKING_QUANTITY_IND
, MSI.ONT_PRICING_QTY_SOURCE
, MSI.SECONDARY_DEFAULT_IND
, MSI.CONFIG_ORGS
, MSI.CONFIG_MATCH
,MSI.VMI_MINIMUM_UNITS
,MSI.VMI_MINIMUM_DAYS
,MSI.VMI_MAXIMUM_UNITS
,MSI.VMI_MAXIMUM_DAYS
,MSI.VMI_FIXED_ORDER_QUANTITY
,MSI.SO_AUTHORIZATION_FLAG
,MSI.CONSIGNED_FLAG
,MSI.ASN_AUTOEXPIRE_FLAG
,MSI.VMI_FORECAST_TYPE
,MSI.FORECAST_HORIZON
,MSI.EXCLUDE_FROM_BUDGET_FLAG
,MSI.DAYS_TGT_INV_SUPPLY
,MSI.DAYS_TGT_INV_WINDOW
,MSI.DAYS_MAX_INV_SUPPLY
,MSI.DAYS_MAX_INV_WINDOW
,MSI.DRP_PLANNED_FLAG
,MSI.CRITICAL_COMPONENT_FLAG
,MSI.CONTINOUS_TRANSFER
,MSI.CONVERGENCE
,MSI.DIVERGENCE ,
/* Start Bug 3713912 */
MSI.LOT_DIVISIBLE_FLAG ,
MSI.GRADE_CONTROL_FLAG ,
MSI.DEFAULT_GRADE ,
MSI.CHILD_LOT_FLAG ,
MSI.PARENT_CHILD_GENERATION_FLAG ,
MSI.CHILD_LOT_PREFIX ,
MSI.CHILD_LOT_STARTING_NUMBER ,
MSI.CHILD_LOT_VALIDATION_FLAG ,
MSI.COPY_LOT_ATTRIBUTE_FLAG ,
MSI.RECIPE_ENABLED_FLAG ,
MSI.PROCESS_QUALITY_ENABLED_FLAG ,
MSI.PROCESS_EXECUTION_ENABLED_FLAG ,
MSI.PROCESS_COSTING_ENABLED_FLAG ,
MSI.PROCESS_SUPPLY_SUBINVENTORY ,
MSI.PROCESS_SUPPLY_LOCATOR_ID ,
MSI.PROCESS_YIELD_SUBINVENTORY ,
MSI.PROCESS_YIELD_LOCATOR_ID ,
MSI.HAZARDOUS_MATERIAL_FLAG ,
MSI.CAS_NUMBER ,
MSI.RETEST_INTERVAL ,
MSI.EXPIRATION_ACTION_INTERVAL ,
MSI.EXPIRATION_ACTION_CODE ,
MSI.MATURITY_DAYS ,
MSI.HOLD_DAYS ,
/* End Bug 3713912 */
--R12 Enhancement
MSI.CHARGE_PERIODICITY_CODE,
MSI.REPAIR_LEADTIME,
MSI.REPAIR_YIELD,
MSI.PREPOSITION_POINT,
MSI.REPAIR_PROGRAM,
MSI.SUBCONTRACTING_COMPONENT,
MSI.OUTSOURCED_ASSEMBLY,
MSI.GDSN_OUTBOUND_ENABLED_FLAG,
MSI.TRADE_ITEM_DESCRIPTOR,
MSI.STYLE_ITEM_FLAG,
MSI.STYLE_ITEM_ID
FROM
MTL_SYSTEM_ITEMS_VL MSI
WHERE
MSI.inventory_item_id = inv_item_id
AND MSI.organization_id = org_id;
'when OTHERS exception raised in create_child_update_mast_attr ' ||
SQLCODE ||
' - ' ||
SQLERRM, 1, 240));
END create_child_update_mast_attr; -- }
select *
into msii_master_temp
from
MTL_SYSTEM_ITEMS_INTERFACE MSII
where
MSII.ROWID = master_row_id;
UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII
SET MSII.ALLOWED_UNITS_LOOKUP_CODE = decode( A_ALLOWED_UNITS_LOOKUP_CODE,1,msii_master_temp.ALLOWED_UNITS_LOOKUP_CODE,MSII.ALLOWED_UNITS_LOOKUP_CODE ),
MSII.INVENTORY_ITEM_STATUS_CODE = decode( A_INVENTORY_ITEM_STATUS_CODE,1, msii_master_temp.INVENTORY_ITEM_STATUS_CODE,MSII.INVENTORY_ITEM_STATUS_CODE ),
MSII.ITEM_TYPE = decode( A_ITEM_TYPE,1,msii_master_temp.ITEM_TYPE,MSII.ITEM_TYPE ),
MSII.PRIMARY_UNIT_OF_MEASURE = decode( A_PRIMARY_UNIT_OF_MEASURE,1,msii_master_temp.PRIMARY_UNIT_OF_MEASURE,MSII.PRIMARY_UNIT_OF_MEASURE ),
MSII.BASE_ITEM_ID = decode( A_BASE_ITEM_ID,1,msii_master_temp.BASE_ITEM_ID,MSII.BASE_ITEM_ID ),
MSII.BOM_ENABLED_FLAG = decode( A_BOM_ENABLED_FLAG,1,msii_master_temp.BOM_ENABLED_FLAG,MSII.BOM_ENABLED_FLAG ),
MSII.BOM_ITEM_TYPE = decode( A_BOM_ITEM_TYPE,1,msii_master_temp.BOM_ITEM_TYPE,MSII.BOM_ITEM_TYPE ),
MSII.ENGINEERING_ECN_CODE = decode( A_ENGINEERING_ECN_CODE,1,msii_master_temp.ENGINEERING_ECN_CODE,MSII.ENGINEERING_ECN_CODE ),
MSII.ENGINEERING_ITEM_ID = decode( A_ENGINEERING_ITEM_ID,1,msii_master_temp.ENGINEERING_ITEM_ID,MSII.ENGINEERING_ITEM_ID ),
MSII.ENG_ITEM_FLAG = decode( A_ENG_ITEM_FLAG,1,msii_master_temp.ENG_ITEM_FLAG,MSII.ENG_ITEM_FLAG ),
MSII.COSTING_ENABLED_FLAG = decode( A_COSTING_ENABLED_FLAG,1,msii_master_temp.COSTING_ENABLED_FLAG,MSII.COSTING_ENABLED_FLAG ),
MSII.COST_OF_SALES_ACCOUNT = decode( A_COST_OF_SALES_ACCOUNT,1,msii_master_temp.COST_OF_SALES_ACCOUNT,MSII.COST_OF_SALES_ACCOUNT ),
MSII.DEFAULT_INCLUDE_IN_ROLLUP_FLAG= decode( A_DEF_INCL_IN_ROLLUP_FLAG,1,msii_master_temp.DEFAULT_INCLUDE_IN_ROLLUP_FLAG,MSII.DEFAULT_INCLUDE_IN_ROLLUP_FLAG ),
MSII.INVENTORY_ASSET_FLAG = decode( A_INVENTORY_ASSET_FLAG,1,msii_master_temp.INVENTORY_ASSET_FLAG,MSII.INVENTORY_ASSET_FLAG ),
MSII.STD_LOT_SIZE = decode( A_STD_LOT_SIZE,1,msii_master_temp.STD_LOT_SIZE,MSII.STD_LOT_SIZE ),
MSII.ALLOW_ITEM_DESC_UPDATE_FLAG = decode( A_ALLOW_ITEM_DESC_UPDATE_FLAG,1,msii_master_temp.ALLOW_ITEM_DESC_UPDATE_FLAG,MSII.ALLOW_ITEM_DESC_UPDATE_FLAG ),
MSII.ASSET_CATEGORY_ID = decode( A_ASSET_CATEGORY_ID,1, msii_master_temp.ASSET_CATEGORY_ID,MSII.ASSET_CATEGORY_ID ),
MSII.BUYER_ID = decode( A_BUYER_ID,1,msii_master_temp.BUYER_ID,MSII.BUYER_ID ),
MSII.ENCUMBRANCE_ACCOUNT = decode( A_ENCUMBRANCE_ACCOUNT,1,msii_master_temp.ENCUMBRANCE_ACCOUNT,MSII.ENCUMBRANCE_ACCOUNT ),
MSII.EXPENSE_ACCOUNT = decode( A_EXPENSE_ACCOUNT,1,msii_master_temp.EXPENSE_ACCOUNT,MSII.EXPENSE_ACCOUNT ),
MSII.HAZARD_CLASS_ID = decode( A_HAZARD_CLASS_ID,1,msii_master_temp.HAZARD_CLASS_ID,MSII.HAZARD_CLASS_ID ),
MSII.LIST_PRICE_PER_UNIT = decode( A_LIST_PRICE_PER_UNIT,1,msii_master_temp.LIST_PRICE_PER_UNIT,MSII.LIST_PRICE_PER_UNIT ),
MSII.MARKET_PRICE = decode( A_MARKET_PRICE,1,msii_master_temp.MARKET_PRICE,MSII.MARKET_PRICE ),
MSII.MUST_USE_APPROVED_VENDOR_FLAG = decode( A_MU_APPRVD_VENDOR_FLAG,1,msii_master_temp.MUST_USE_APPROVED_VENDOR_FLAG,MSII.MUST_USE_APPROVED_VENDOR_FLAG ),
MSII.OUTSIDE_OPERATION_FLAG = decode( A_OUTSIDE_OPERATION_FLAG,1,msii_master_temp.OUTSIDE_OPERATION_FLAG,MSII.OUTSIDE_OPERATION_FLAG ),
MSII.OUTSIDE_OPERATION_UOM_TYPE = decode( A_OUTSIDE_OPERATION_UOM_TYPE,1,msii_master_temp.OUTSIDE_OPERATION_UOM_TYPE,MSII.OUTSIDE_OPERATION_UOM_TYPE ),
MSII.PRICE_TOLERANCE_PERCENT = decode( A_PRICE_TOLERANCE_PERCENT,1,msii_master_temp.PRICE_TOLERANCE_PERCENT,MSII.PRICE_TOLERANCE_PERCENT ),
MSII.PURCHASING_ENABLED_FLAG = decode( A_PURCHASING_ENABLED_FLAG,1,msii_master_temp.PURCHASING_ENABLED_FLAG,MSII.PURCHASING_ENABLED_FLAG ),
MSII.PURCHASING_ITEM_FLAG = decode( A_PURCHASING_ITEM_FLAG,1,msii_master_temp.PURCHASING_ITEM_FLAG,MSII.PURCHASING_ITEM_FLAG ),
MSII.RFQ_REQUIRED_FLAG = decode( A_RFQ_REQUIRED_FLAG,1,msii_master_temp.RFQ_REQUIRED_FLAG,MSII.RFQ_REQUIRED_FLAG ),
MSII.ROUNDING_FACTOR = decode( A_ROUNDING_FACTOR,1,msii_master_temp.ROUNDING_FACTOR,MSII.ROUNDING_FACTOR ),
MSII.TAXABLE_FLAG = decode( A_TAXABLE_FLAG,1,msii_master_temp.TAXABLE_FLAG,MSII.TAXABLE_FLAG ),
MSII.PURCHASING_TAX_CODE = decode( A_PURCHASING_TAX_CODE,1,msii_master_temp.PURCHASING_TAX_CODE,MSII.PURCHASING_TAX_CODE ),
MSII.UNIT_OF_ISSUE = decode( A_UNIT_OF_ISSUE,1,msii_master_temp.UNIT_OF_ISSUE,MSII.UNIT_OF_ISSUE ),
MSII.UN_NUMBER_ID = decode( A_UN_NUMBER_ID,1,msii_master_temp.UN_NUMBER_ID,MSII.UN_NUMBER_ID ),
MSII.ALLOW_EXPRESS_DELIVERY_FLAG = decode( A_ALLOW_EXPRESS_DELIVERY_FLAG,1,msii_master_temp.ALLOW_EXPRESS_DELIVERY_FLAG,MSII.ALLOW_EXPRESS_DELIVERY_FLAG ),
MSII.ALLOW_SUBSTITUTE_RECEIPTS_FLAG= decode( A_ALLOW_SUBS_RECEIPTS_FLAG,1,msii_master_temp.ALLOW_SUBSTITUTE_RECEIPTS_FLAG,MSII.ALLOW_SUBSTITUTE_RECEIPTS_FLAG ),
MSII.ALLOW_UNORDERED_RECEIPTS_FLAG = decode( A_ALLOW_UNORD_RECEIPTS_FLAG,1,msii_master_temp.ALLOW_UNORDERED_RECEIPTS_FLAG,MSII.ALLOW_UNORDERED_RECEIPTS_FLAG ),
MSII.DAYS_EARLY_RECEIPT_ALLOWED = decode( A_DAYS_EARLY_RECEIPT_ALLOWED,1,msii_master_temp.DAYS_EARLY_RECEIPT_ALLOWED,MSII.DAYS_EARLY_RECEIPT_ALLOWED ),
MSII.DAYS_LATE_RECEIPT_ALLOWED = decode( A_DAYS_LATE_RECEIPT_ALLOWED,1,msii_master_temp.DAYS_LATE_RECEIPT_ALLOWED,MSII.DAYS_LATE_RECEIPT_ALLOWED ),
MSII.ENFORCE_SHIP_TO_LOCATION_CODE = decode( A_ENFORCE_SHIP_TO_LOC_CODE,1,msii_master_temp.ENFORCE_SHIP_TO_LOCATION_CODE,MSII.ENFORCE_SHIP_TO_LOCATION_CODE ),
MSII.INSPECTION_REQUIRED_FLAG = decode( A_INSPECTION_REQUIRED_FLAG,1,msii_master_temp.INSPECTION_REQUIRED_FLAG,MSII.INSPECTION_REQUIRED_FLAG ),
MSII.INVOICE_CLOSE_TOLERANCE = decode( A_INVOICE_CLOSE_TOLERANCE,1,msii_master_temp.INVOICE_CLOSE_TOLERANCE,MSII.INVOICE_CLOSE_TOLERANCE ),
MSII.QTY_RCV_EXCEPTION_CODE = decode( A_QTY_RCV_EXCEPTION_CODE,1,msii_master_temp.QTY_RCV_EXCEPTION_CODE,MSII.QTY_RCV_EXCEPTION_CODE ),
MSII.QTY_RCV_TOLERANCE = decode( A_QTY_RCV_TOLERANCE,1,msii_master_temp.QTY_RCV_TOLERANCE,MSII.QTY_RCV_TOLERANCE ),
MSII.RECEIPT_DAYS_EXCEPTION_CODE = decode( A_RECEIPT_DAYS_EXCEPTION_CODE,1,msii_master_temp.RECEIPT_DAYS_EXCEPTION_CODE,MSII.RECEIPT_DAYS_EXCEPTION_CODE ),
MSII.RECEIPT_REQUIRED_FLAG = decode( A_RECEIPT_REQUIRED_FLAG,1,msii_master_temp.RECEIPT_REQUIRED_FLAG,MSII.RECEIPT_REQUIRED_FLAG ),
MSII.RECEIVE_CLOSE_TOLERANCE = decode( A_RECEIVE_CLOSE_TOLERANCE,1,msii_master_temp.RECEIVE_CLOSE_TOLERANCE,MSII.RECEIVE_CLOSE_TOLERANCE ),
MSII.RECEIVING_ROUTING_ID = decode( A_RECEIVING_ROUTING_ID,1,msii_master_temp.RECEIVING_ROUTING_ID,MSII.RECEIVING_ROUTING_ID ),
MSII.AUTO_LOT_ALPHA_PREFIX = decode( A_AUTO_LOT_ALPHA_PREFIX,1,msii_master_temp.AUTO_LOT_ALPHA_PREFIX,MSII.AUTO_LOT_ALPHA_PREFIX ),
MSII.AUTO_SERIAL_ALPHA_PREFIX = decode( A_AUTO_SERIAL_ALPHA_PREFIX,1,msii_master_temp.AUTO_SERIAL_ALPHA_PREFIX,MSII.AUTO_SERIAL_ALPHA_PREFIX ),
MSII.CYCLE_COUNT_ENABLED_FLAG = decode( A_CYCLE_COUNT_ENABLED_FLAG,1,msii_master_temp.CYCLE_COUNT_ENABLED_FLAG,MSII.CYCLE_COUNT_ENABLED_FLAG ),
MSII.INVENTORY_ITEM_FLAG = decode( A_INVENTORY_ITEM_FLAG,1,msii_master_temp.INVENTORY_ITEM_FLAG,MSII.INVENTORY_ITEM_FLAG ),
MSII.LOCATION_CONTROL_CODE = decode( A_LOCATION_CONTROL_CODE,1,msii_master_temp.LOCATION_CONTROL_CODE,MSII.LOCATION_CONTROL_CODE ),
MSII.LOT_CONTROL_CODE = decode( A_LOT_CONTROL_CODE,1,msii_master_temp.LOT_CONTROL_CODE,MSII.LOT_CONTROL_CODE ),
MSII.MTL_TRANSACTIONS_ENABLED_FLAG = decode( A_MTL_TRANSAC_ENABLED_FLAG,1,msii_master_temp.MTL_TRANSACTIONS_ENABLED_FLAG,MSII.MTL_TRANSACTIONS_ENABLED_FLAG ),
MSII.NEGATIVE_MEASUREMENT_ERROR = decode( A_NEGATIVE_MEASUREMENT_ERROR,1,msii_master_temp.NEGATIVE_MEASUREMENT_ERROR,MSII.NEGATIVE_MEASUREMENT_ERROR ),
MSII.RESERVABLE_TYPE = decode( A_RESERVABLE_TYPE,1,msii_master_temp.RESERVABLE_TYPE,MSII.RESERVABLE_TYPE ),
MSII.RESTRICT_LOCATORS_CODE = decode( A_RESTRICT_LOCATORS_CODE,1,msii_master_temp.RESTRICT_LOCATORS_CODE,MSII.RESTRICT_LOCATORS_CODE ),
MSII.RESTRICT_SUBINVENTORIES_CODE = decode( A_RESTRICT_SUBINVENTORIES_CODE,1,msii_master_temp.RESTRICT_SUBINVENTORIES_CODE,MSII.RESTRICT_SUBINVENTORIES_CODE ),
MSII.REVISION_QTY_CONTROL_CODE = decode( A_REVISION_QTY_CONTROL_CODE,1,msii_master_temp.REVISION_QTY_CONTROL_CODE,MSII.REVISION_QTY_CONTROL_CODE ),
MSII.SERIAL_NUMBER_CONTROL_CODE = decode( A_SERIAL_NUMBER_CONTROL_CODE,1,msii_master_temp.SERIAL_NUMBER_CONTROL_CODE,MSII.SERIAL_NUMBER_CONTROL_CODE ),
MSII.SHELF_LIFE_CODE = decode( A_SHELF_LIFE_CODE,1,msii_master_temp.SHELF_LIFE_CODE,MSII.SHELF_LIFE_CODE ),
MSII.SHELF_LIFE_DAYS = decode( A_SHELF_LIFE_DAYS,1,msii_master_temp.SHELF_LIFE_DAYS,MSII.SHELF_LIFE_DAYS ),
MSII.START_AUTO_LOT_NUMBER = decode( A_START_AUTO_LOT_NUMBER,1,msii_master_temp.START_AUTO_LOT_NUMBER,MSII.START_AUTO_LOT_NUMBER ),
MSII.START_AUTO_SERIAL_NUMBER = decode( A_START_AUTO_SERIAL_NUMBER,1,msii_master_temp.START_AUTO_SERIAL_NUMBER,MSII.START_AUTO_SERIAL_NUMBER ),
MSII.STOCK_ENABLED_FLAG = decode( A_STOCK_ENABLED_FLAG,1,msii_master_temp.STOCK_ENABLED_FLAG,MSII.STOCK_ENABLED_FLAG ),
MSII.UNIT_VOLUME = decode( A_UNIT_VOLUME,1,msii_master_temp.UNIT_VOLUME,MSII.UNIT_VOLUME ),
MSII.UNIT_WEIGHT = decode( A_UNIT_WEIGHT,1,msii_master_temp.UNIT_WEIGHT,MSII.UNIT_WEIGHT ),
MSII.VOLUME_UOM_CODE = decode( A_VOLUME_UOM_CODE,1,msii_master_temp.VOLUME_UOM_CODE,MSII.VOLUME_UOM_CODE ),
MSII.WEIGHT_UOM_CODE = decode( A_WEIGHT_UOM_CODE,1,msii_master_temp.WEIGHT_UOM_CODE,MSII.WEIGHT_UOM_CODE ),
MSII.CARRYING_COST = decode( A_CARRYING_COST,1,msii_master_temp.CARRYING_COST,MSII.CARRYING_COST ),
MSII.FIXED_DAYS_SUPPLY = decode( A_FIXED_DAYS_SUPPLY,1,msii_master_temp.FIXED_DAYS_SUPPLY,MSII.FIXED_DAYS_SUPPLY ),
MSII.FIXED_LOT_MULTIPLIER = decode( A_FIXED_LOT_MULTIPLIER,1,msii_master_temp.FIXED_LOT_MULTIPLIER,MSII.FIXED_LOT_MULTIPLIER ),
MSII.FIXED_ORDER_QUANTITY = decode( A_FIXED_ORDER_QUANTITY,1, msii_master_temp.FIXED_ORDER_QUANTITY,MSII.FIXED_ORDER_QUANTITY ),
MSII.INVENTORY_PLANNING_CODE = decode( A_INVENTORY_PLANNING_CODE,1,msii_master_temp.INVENTORY_PLANNING_CODE,MSII.INVENTORY_PLANNING_CODE ),
MSII.MAXIMUM_ORDER_QUANTITY = decode( A_MAXIMUM_ORDER_QUANTITY,1,msii_master_temp.MAXIMUM_ORDER_QUANTITY,MSII.MAXIMUM_ORDER_QUANTITY ),
MSII.MAX_MINMAX_QUANTITY = decode( A_MAX_MINMAX_QUANTITY,1,msii_master_temp.MAX_MINMAX_QUANTITY,MSII.MAX_MINMAX_QUANTITY ),
MSII.MINIMUM_ORDER_QUANTITY = decode( A_MINIMUM_ORDER_QUANTITY,1,msii_master_temp.MINIMUM_ORDER_QUANTITY,MSII.MINIMUM_ORDER_QUANTITY ),
MSII.MIN_MINMAX_QUANTITY = decode( A_MIN_MINMAX_QUANTITY,1,msii_master_temp.MIN_MINMAX_QUANTITY,MSII.MIN_MINMAX_QUANTITY ),
MSII.MRP_SAFETY_STOCK_CODE = decode( A_MRP_SAFETY_STOCK_CODE,1,msii_master_temp.MRP_SAFETY_STOCK_CODE,MSII.MRP_SAFETY_STOCK_CODE ),
MSII.MRP_SAFETY_STOCK_PERCENT = decode( A_MRP_SAFETY_STOCK_PERCENT,1, msii_master_temp.MRP_SAFETY_STOCK_PERCENT,MSII.MRP_SAFETY_STOCK_PERCENT ),
MSII.ORDER_COST = decode( A_ORDER_COST,1,msii_master_temp.ORDER_COST,MSII.ORDER_COST ),
MSII.PLANNER_CODE = decode( A_PLANNER_CODE,1,msii_master_temp.PLANNER_CODE,MSII.PLANNER_CODE ),
MSII.SAFETY_STOCK_BUCKET_DAYS = decode( A_SAFETY_STOCK_BUCKET_DAYS,1,msii_master_temp.SAFETY_STOCK_BUCKET_DAYS,MSII.SAFETY_STOCK_BUCKET_DAYS ),
MSII.SOURCE_ORGANIZATION_ID = decode( A_SOURCE_ORGANIZATION_ID,1,msii_master_temp.SOURCE_ORGANIZATION_ID,MSII.SOURCE_ORGANIZATION_ID ),
MSII.SOURCE_SUBINVENTORY = decode( A_SOURCE_SUBINVENTORY,1,msii_master_temp.SOURCE_SUBINVENTORY,MSII.SOURCE_SUBINVENTORY ),
MSII.SOURCE_TYPE = decode( A_SOURCE_TYPE,1,msii_master_temp.SOURCE_TYPE,MSII.SOURCE_TYPE ),
MSII.ACCEPTABLE_EARLY_DAYS = decode( A_ACCEPTABLE_EARLY_DAYS,1,msii_master_temp.ACCEPTABLE_EARLY_DAYS,MSII.ACCEPTABLE_EARLY_DAYS ),
MSII.ACCEPTABLE_RATE_DECREASE = decode( A_ACCEPTABLE_RATE_DECREASE,1,msii_master_temp.ACCEPTABLE_RATE_DECREASE,MSII.ACCEPTABLE_RATE_DECREASE ),
MSII.ACCEPTABLE_RATE_INCREASE = decode( A_ACCEPTABLE_RATE_INCREASE,1,msii_master_temp.ACCEPTABLE_RATE_INCREASE,MSII.ACCEPTABLE_RATE_INCREASE ),
MSII.AUTO_REDUCE_MPS = decode( A_AUTO_REDUCE_MPS,1,msii_master_temp.AUTO_REDUCE_MPS,MSII.AUTO_REDUCE_MPS ),
MSII.DEMAND_TIME_FENCE_CODE = decode( A_DEMAND_TIME_FENCE_CODE,1,msii_master_temp.DEMAND_TIME_FENCE_CODE,MSII.DEMAND_TIME_FENCE_CODE ),
MSII.DEMAND_TIME_FENCE_DAYS = decode( A_DEMAND_TIME_FENCE_DAYS,1,msii_master_temp.DEMAND_TIME_FENCE_DAYS,MSII.DEMAND_TIME_FENCE_DAYS ),
MSII.END_ASSEMBLY_PEGGING_FLAG = decode( A_END_ASSEMBLY_PEGGING_FLAG,1,msii_master_temp.END_ASSEMBLY_PEGGING_FLAG,MSII.END_ASSEMBLY_PEGGING_FLAG ),
MSII.MRP_CALCULATE_ATP_FLAG = decode( A_MRP_CALCULATE_ATP_FLAG,1,msii_master_temp.MRP_CALCULATE_ATP_FLAG,MSII.MRP_CALCULATE_ATP_FLAG ),
MSII.MRP_PLANNING_CODE = decode( A_MRP_PLANNING_CODE,1,msii_master_temp.MRP_PLANNING_CODE,MSII.MRP_PLANNING_CODE ),
MSII.OVERRUN_PERCENTAGE = decode( A_OVERRUN_PERCENTAGE,1,msii_master_temp.OVERRUN_PERCENTAGE,MSII.OVERRUN_PERCENTAGE ),
MSII.PLANNING_EXCEPTION_SET = decode( A_PLANNING_EXCEPTION_SET,1,msii_master_temp.PLANNING_EXCEPTION_SET,MSII.PLANNING_EXCEPTION_SET ),
MSII.PLANNING_MAKE_BUY_CODE = decode( A_PLANNING_MAKE_BUY_CODE,1,msii_master_temp.PLANNING_MAKE_BUY_CODE,MSII.PLANNING_MAKE_BUY_CODE ),
MSII.PLANNING_TIME_FENCE_CODE = decode( A_PLANNING_TIME_FENCE_CODE,1,msii_master_temp.PLANNING_TIME_FENCE_CODE,MSII.PLANNING_TIME_FENCE_CODE ),
MSII.PLANNING_TIME_FENCE_DAYS = decode( A_PLANNING_TIME_FENCE_DAYS,1,msii_master_temp.PLANNING_TIME_FENCE_DAYS,MSII.PLANNING_TIME_FENCE_DAYS ),
-- Bug #1052111
MSII.RELEASE_TIME_FENCE_CODE = decode( A_RELEASE_TIME_FENCE_CODE,1,msii_master_temp.RELEASE_TIME_FENCE_CODE,MSII.RELEASE_TIME_FENCE_CODE ),
MSII.RELEASE_TIME_FENCE_DAYS = decode( A_RELEASE_TIME_FENCE_DAYS,1,msii_master_temp.RELEASE_TIME_FENCE_DAYS,MSII.RELEASE_TIME_FENCE_DAYS ),
MSII.REPETITIVE_PLANNING_FLAG = decode( A_REPETITIVE_PLANNING_FLAG,1,msii_master_temp.REPETITIVE_PLANNING_FLAG,MSII.REPETITIVE_PLANNING_FLAG ),
MSII.ROUNDING_CONTROL_TYPE = decode( A_ROUNDING_CONTROL_TYPE,1, msii_master_temp.ROUNDING_CONTROL_TYPE,MSII.ROUNDING_CONTROL_TYPE ),
MSII.SHRINKAGE_RATE = decode( A_SHRINKAGE_RATE,1,msii_master_temp.SHRINKAGE_RATE,MSII.SHRINKAGE_RATE ),
MSII.CUMULATIVE_TOTAL_LEAD_TIME = decode( A_CUMULATIVE_TOTAL_LEAD_TIME,1,msii_master_temp.CUMULATIVE_TOTAL_LEAD_TIME,MSII.CUMULATIVE_TOTAL_LEAD_TIME ),
MSII.CUM_MANUFACTURING_LEAD_TIME = decode( A_CUM_MANUFACTURING_LEAD_TIME,1,msii_master_temp.CUM_MANUFACTURING_LEAD_TIME,MSII.CUM_MANUFACTURING_LEAD_TIME ),
MSII.FIXED_LEAD_TIME = decode( A_FIXED_LEAD_TIME,1,msii_master_temp.FIXED_LEAD_TIME,MSII.FIXED_LEAD_TIME ),
MSII.FULL_LEAD_TIME = decode( A_FULL_LEAD_TIME,1,msii_master_temp.FULL_LEAD_TIME,MSII.FULL_LEAD_TIME ),
MSII.POSTPROCESSING_LEAD_TIME = decode( A_POSTPROCESSING_LEAD_TIME,1,msii_master_temp.POSTPROCESSING_LEAD_TIME,MSII.POSTPROCESSING_LEAD_TIME ),
MSII.PREPROCESSING_LEAD_TIME = decode( A_PREPROCESSING_LEAD_TIME,1,msii_master_temp.PREPROCESSING_LEAD_TIME,MSII.PREPROCESSING_LEAD_TIME ),
MSII.VARIABLE_LEAD_TIME = decode( A_VARIABLE_LEAD_TIME,1,msii_master_temp.VARIABLE_LEAD_TIME,MSII.VARIABLE_LEAD_TIME ),
MSII.BUILD_IN_WIP_FLAG = decode( A_BUILD_IN_WIP_FLAG,1,msii_master_temp.BUILD_IN_WIP_FLAG,MSII.BUILD_IN_WIP_FLAG ),
MSII.WIP_SUPPLY_LOCATOR_ID = decode( A_WIP_SUPPLY_LOCATOR_ID,1,msii_master_temp.WIP_SUPPLY_LOCATOR_ID,MSII.WIP_SUPPLY_LOCATOR_ID ),
MSII.WIP_SUPPLY_SUBINVENTORY = decode( A_WIP_SUPPLY_SUBINVENTORY,1,msii_master_temp.WIP_SUPPLY_SUBINVENTORY,MSII.WIP_SUPPLY_SUBINVENTORY ),
MSII.WIP_SUPPLY_TYPE = decode( A_WIP_SUPPLY_TYPE,1,msii_master_temp.WIP_SUPPLY_TYPE,MSII.WIP_SUPPLY_TYPE ),
MSII.ATP_COMPONENTS_FLAG = decode( A_ATP_COMPONENTS_FLAG,1,msii_master_temp.ATP_COMPONENTS_FLAG,MSII.ATP_COMPONENTS_FLAG ),
MSII.ATP_FLAG = decode( A_ATP_FLAG,1,msii_master_temp.ATP_FLAG,MSII.ATP_FLAG ),
MSII.ATP_RULE_ID = decode( A_ATP_RULE_ID,1,msii_master_temp.ATP_RULE_ID,MSII.ATP_RULE_ID ),
MSII.COLLATERAL_FLAG = decode( A_COLLATERAL_FLAG,1,msii_master_temp.COLLATERAL_FLAG,MSII.COLLATERAL_FLAG ),
MSII.CUSTOMER_ORDER_ENABLED_FLAG = decode( A_CUSTOMER_ORDER_ENABLED_FLAG,1,msii_master_temp.CUSTOMER_ORDER_ENABLED_FLAG,MSII.CUSTOMER_ORDER_ENABLED_FLAG ),
MSII.CUSTOMER_ORDER_FLAG = decode( A_CUSTOMER_ORDER_FLAG,1,msii_master_temp.CUSTOMER_ORDER_FLAG,MSII.CUSTOMER_ORDER_FLAG ),
MSII.DEFAULT_SHIPPING_ORG = decode( A_DEFAULT_SHIPPING_ORG,1,msii_master_temp.DEFAULT_SHIPPING_ORG,MSII.DEFAULT_SHIPPING_ORG ),
MSII.INTERNAL_ORDER_ENABLED_FLAG = decode( A_INTERNAL_ORDER_ENABLED_FLAG,1,msii_master_temp.INTERNAL_ORDER_ENABLED_FLAG,MSII.INTERNAL_ORDER_ENABLED_FLAG ),
MSII.INTERNAL_ORDER_FLAG =
decode( A_INTERNAL_ORDER_FLAG,
1,
msii_master_temp.INTERNAL_ORDER_FLAG,
MSII.INTERNAL_ORDER_FLAG ),
MSII.PICKING_RULE_ID =
decode( A_PICKING_RULE_ID,
1,
msii_master_temp.PICKING_RULE_ID,
MSII.PICKING_RULE_ID ),
MSII.PICK_COMPONENTS_FLAG =
decode( A_PICK_COMPONENTS_FLAG,
1,
msii_master_temp.PICK_COMPONENTS_FLAG,
MSII.PICK_COMPONENTS_FLAG ),
MSII.REPLENISH_TO_ORDER_FLAG =
decode( A_REPLENISH_TO_ORDER_FLAG,
1,
msii_master_temp.REPLENISH_TO_ORDER_FLAG,
MSII.REPLENISH_TO_ORDER_FLAG ),
MSII.RETURNABLE_FLAG =
decode( A_RETURNABLE_FLAG,
1,
msii_master_temp.RETURNABLE_FLAG,
MSII.RETURNABLE_FLAG ),
MSII.RETURN_INSPECTION_REQUIREMENT =
decode( A_RETURN_INSPECTION_REQMT,
1,
msii_master_temp.RETURN_INSPECTION_REQUIREMENT,
MSII.RETURN_INSPECTION_REQUIREMENT ),
MSII.SHIPPABLE_ITEM_FLAG =
decode( A_SHIPPABLE_ITEM_FLAG,
1,
msii_master_temp.SHIPPABLE_ITEM_FLAG,
MSII.SHIPPABLE_ITEM_FLAG ),
MSII.SHIP_MODEL_COMPLETE_FLAG =
decode( A_SHIP_MODEL_COMPLETE_FLAG,
1,
msii_master_temp.SHIP_MODEL_COMPLETE_FLAG,
MSII.SHIP_MODEL_COMPLETE_FLAG ),
MSII.SO_TRANSACTIONS_FLAG =
decode( A_SO_TRANSACTIONS_FLAG,
1,
msii_master_temp.SO_TRANSACTIONS_FLAG,
MSII.SO_TRANSACTIONS_FLAG ),
MSII.ACCOUNTING_RULE_ID =
decode( A_ACCOUNTING_RULE_ID,
1,
msii_master_temp.ACCOUNTING_RULE_ID,
MSII.ACCOUNTING_RULE_ID ),
MSII.INVOICEABLE_ITEM_FLAG =
decode( A_INVOICEABLE_ITEM_FLAG,
1,
msii_master_temp.INVOICEABLE_ITEM_FLAG,
MSII.INVOICEABLE_ITEM_FLAG ),
MSII.INVOICE_ENABLED_FLAG =
decode( A_INVOICE_ENABLED_FLAG,
1,
msii_master_temp.INVOICE_ENABLED_FLAG,
MSII.INVOICE_ENABLED_FLAG ),
MSII.ENGINEERING_DATE =
decode( A_ENGINEERING_DATE,
1,
msii_master_temp.ENGINEERING_DATE,
MSII.ENGINEERING_DATE ),
MSII.INVOICING_RULE_ID =
decode( A_INVOICING_RULE_ID,
1,
msii_master_temp.INVOICING_RULE_ID,
MSII.INVOICING_RULE_ID ),
MSII.PAYMENT_TERMS_ID =
decode( A_PAYMENT_TERMS_ID,
1,
msii_master_temp.PAYMENT_TERMS_ID,
MSII.PAYMENT_TERMS_ID ),
MSII.SALES_ACCOUNT =
decode( A_SALES_ACCOUNT,
1,
msii_master_temp.SALES_ACCOUNT,
MSII.SALES_ACCOUNT ),
MSII.TAX_CODE =
decode( A_TAX_CODE,
1,
msii_master_temp.TAX_CODE,
MSII.TAX_CODE ),
MSII.COVERAGE_SCHEDULE_ID =
decode( A_COVERAGE_SCHEDULE_ID,
1,
msii_master_temp.COVERAGE_SCHEDULE_ID,
MSII.COVERAGE_SCHEDULE_ID ),
MSII.MATERIAL_BILLABLE_FLAG =
decode( A_MATERIAL_BILLABLE_FLAG,
1,
msii_master_temp.MATERIAL_BILLABLE_FLAG,
MSII.MATERIAL_BILLABLE_FLAG ),
MSII.MAX_WARRANTY_AMOUNT =
decode( A_MAX_WARRANTY_AMOUNT,
1,
msii_master_temp.MAX_WARRANTY_AMOUNT,
MSII.MAX_WARRANTY_AMOUNT ),
MSII.PREVENTIVE_MAINTENANCE_FLAG =
decode( A_PREVENTIVE_MAINTENANCE_FLAG,
1,
msii_master_temp.PREVENTIVE_MAINTENANCE_FLAG,
MSII.PREVENTIVE_MAINTENANCE_FLAG ),
MSII.PRORATE_SERVICE_FLAG =
decode( A_PRORATE_SERVICE_FLAG,
1,
msii_master_temp.PRORATE_SERVICE_FLAG,
MSII.PRORATE_SERVICE_FLAG ),
MSII.RESPONSE_TIME_PERIOD_CODE =
decode( A_RESPONSE_TIME_PERIOD_CODE,
1,
msii_master_temp.RESPONSE_TIME_PERIOD_CODE,
MSII.RESPONSE_TIME_PERIOD_CODE ),
MSII.RESPONSE_TIME_VALUE =
decode( A_RESPONSE_TIME_VALUE,
1,
msii_master_temp.RESPONSE_TIME_VALUE,
MSII.RESPONSE_TIME_VALUE ),
MSII.SERVICE_DURATION =
decode( A_SERVICE_DURATION,
1,
msii_master_temp.SERVICE_DURATION,
MSII.SERVICE_DURATION ),
MSII.SERVICE_DURATION_PERIOD_CODE =
decode( A_SERVICE_DURATION_PERIOD_CODE,
1,
msii_master_temp.SERVICE_DURATION_PERIOD_CODE,
MSII.SERVICE_DURATION_PERIOD_CODE ),
MSII.WARRANTY_VENDOR_ID =
decode( A_WARRANTY_VENDOR_ID,
1,
msii_master_temp.WARRANTY_VENDOR_ID,
MSII.WARRANTY_VENDOR_ID ),
MSII.BASE_WARRANTY_SERVICE_ID =
decode( A_BASE_WARRANTY_SERVICE_ID,
1,
msii_master_temp.BASE_WARRANTY_SERVICE_ID,
MSII.BASE_WARRANTY_SERVICE_ID ),
MSII.NEW_REVISION_CODE =
decode( A_NEW_REVISION_CODE,
1,
msii_master_temp.NEW_REVISION_CODE,
MSII.NEW_REVISION_CODE ),
MSII.PRIMARY_SPECIALIST_ID =
decode( A_PRIMARY_SPECIALIST_ID,
1,
msii_master_temp.PRIMARY_SPECIALIST_ID,
MSII.PRIMARY_SPECIALIST_ID ),
MSII.SECONDARY_SPECIALIST_ID =
decode( A_SECONDARY_SPECIALIST_ID,
1,
msii_master_temp.SECONDARY_SPECIALIST_ID,
MSII.SECONDARY_SPECIALIST_ID ),
MSII.SERVICEABLE_COMPONENT_FLAG =
decode( A_SERVICEABLE_COMPONENT_FLAG,
1,
msii_master_temp.SERVICEABLE_COMPONENT_FLAG,
MSII.SERVICEABLE_COMPONENT_FLAG ),
MSII.SERVICEABLE_ITEM_CLASS_ID =
decode( A_SERVICEABLE_ITEM_CLASS_ID,
1,
msii_master_temp.SERVICEABLE_ITEM_CLASS_ID,
MSII.SERVICEABLE_ITEM_CLASS_ID ),
MSII.SERVICEABLE_PRODUCT_FLAG =
decode( A_SERVICEABLE_PRODUCT_FLAG,
1,
msii_master_temp.SERVICEABLE_PRODUCT_FLAG,
MSII.SERVICEABLE_PRODUCT_FLAG ),
MSII.SERVICE_STARTING_DELAY =
decode( A_SERVICE_STARTING_DELAY,
1,
msii_master_temp.SERVICE_STARTING_DELAY,
MSII.SERVICE_STARTING_DELAY ),
MSII.ATO_FORECAST_CONTROL =
decode( A_ATO_FORECAST_CONTROL,
1,
msii_master_temp.ATO_FORECAST_CONTROL,
MSII.ATO_FORECAST_CONTROL ),
MSII.DESCRIPTION =
decode( A_DESCRIPTION,
1,
msii_master_temp.DESCRIPTION,
MSII.DESCRIPTION ),
MSII.LONG_DESCRIPTION =
decode( A_LONG_DESCRIPTION,
1,
msii_master_temp.LONG_DESCRIPTION,
MSII.LONG_DESCRIPTION ),
MSII.LEAD_TIME_LOT_SIZE =
decode( A_LEAD_TIME_LOT_SIZE,
1,
msii_master_temp.LEAD_TIME_LOT_SIZE,
MSII.LEAD_TIME_LOT_SIZE ),
MSII.POSITIVE_MEASUREMENT_ERROR =
decode( A_POSITIVE_MEASUREMENT_ERROR,
1,
msii_master_temp.POSITIVE_MEASUREMENT_ERROR,
MSII.POSITIVE_MEASUREMENT_ERROR ),
MSII.CONTAINER_ITEM_FLAG =
decode( A_CONTAINER_ITEM_FLAG,
1,
msii_master_temp.CONTAINER_ITEM_FLAG,
MSII.CONTAINER_ITEM_FLAG ),
MSII.VEHICLE_ITEM_FLAG =
decode( A_VEHICLE_ITEM_FLAG,
1,
msii_master_temp.VEHICLE_ITEM_FLAG,
MSII.VEHICLE_ITEM_FLAG ),
MSII.MAXIMUM_LOAD_WEIGHT =
decode( A_MAXIMUM_LOAD_WEIGHT,
1,
msii_master_temp.MAXIMUM_LOAD_WEIGHT,
MSII.MAXIMUM_LOAD_WEIGHT ),
MSII.MINIMUM_FILL_PERCENT =
decode( A_MINIMUM_FILL_PERCENT,
1,
msii_master_temp.MINIMUM_FILL_PERCENT,
MSII.MINIMUM_FILL_PERCENT ),
MSII.INTERNAL_VOLUME =
decode( A_INTERNAL_VOLUME,
1,
msii_master_temp.INTERNAL_VOLUME,
MSII.INTERNAL_VOLUME ),
MSII.CONTAINER_TYPE_CODE =
decode( A_CONTAINER_TYPE_CODE,
1,
msii_master_temp.CONTAINER_TYPE_CODE,
MSII.CONTAINER_TYPE_CODE ),
MSII.CHECK_SHORTAGES_FLAG =
decode( A_CHECK_SHORTAGES_FLAG,
1, msii_master_temp.CHECK_SHORTAGES_FLAG,
MSII.CHECK_SHORTAGES_FLAG ),
MSII.EFFECTIVITY_CONTROL =
decode( A_EFFECTIVITY_CONTROL,
1, msii_master_temp.EFFECTIVITY_CONTROL,
MSII.EFFECTIVITY_CONTROL ),
MSII.OVERCOMPLETION_TOLERANCE_TYPE =
decode( A_OVERCOMPLETION_TOLERANCE_TYP,
1, msii_master_temp.OVERCOMPLETION_TOLERANCE_TYPE,
MSII.OVERCOMPLETION_TOLERANCE_TYPE ),
MSII.OVERCOMPLETION_TOLERANCE_VALUE =
decode( A_OVERCOMPLETION_TOLERANCE_VAL,
1, msii_master_temp.OVERCOMPLETION_TOLERANCE_VALUE,
MSII.OVERCOMPLETION_TOLERANCE_VALUE ),
MSII.OVER_SHIPMENT_TOLERANCE =
decode( A_OVER_SHIPMENT_TOLERANCE,
1, msii_master_temp.OVER_SHIPMENT_TOLERANCE,
MSII.OVER_SHIPMENT_TOLERANCE ),
MSII.UNDER_SHIPMENT_TOLERANCE =
decode( A_UNDER_SHIPMENT_TOLERANCE,
1, msii_master_temp.UNDER_SHIPMENT_TOLERANCE,
MSII.UNDER_SHIPMENT_TOLERANCE ),
MSII.OVER_RETURN_TOLERANCE =
decode( A_OVER_RETURN_TOLERANCE,
1, msii_master_temp.OVER_RETURN_TOLERANCE,
MSII.OVER_RETURN_TOLERANCE ),
MSII.UNDER_RETURN_TOLERANCE =
decode( A_UNDER_RETURN_TOLERANCE,
1, msii_master_temp.UNDER_RETURN_TOLERANCE,
MSII.UNDER_RETURN_TOLERANCE ),
MSII.EQUIPMENT_TYPE =
decode( A_EQUIPMENT_TYPE,
1, msii_master_temp.EQUIPMENT_TYPE,
MSII.EQUIPMENT_TYPE ),
MSII.RECOVERED_PART_DISP_CODE =
decode( A_RECOVERED_PART_DISP_CODE,
1, msii_master_temp.RECOVERED_PART_DISP_CODE,
MSII.RECOVERED_PART_DISP_CODE ),
MSII.DEFECT_TRACKING_ON_FLAG =
decode( A_DEFECT_TRACKING_ON_FLAG,
1, msii_master_temp.DEFECT_TRACKING_ON_FLAG,
MSII.DEFECT_TRACKING_ON_FLAG ),
MSII.EVENT_FLAG =
decode( A_EVENT_FLAG,
1, msii_master_temp.EVENT_FLAG,
MSII.EVENT_FLAG ),
MSII.ELECTRONIC_FLAG =
decode( A_ELECTRONIC_FLAG,
1, msii_master_temp.ELECTRONIC_FLAG,
MSII.ELECTRONIC_FLAG ),
MSII. DOWNLOADABLE_FLAG=
decode( A_DOWNLOADABLE_FLAG,
1, msii_master_temp.DOWNLOADABLE_FLAG,
MSII.DOWNLOADABLE_FLAG ),
MSII.VOL_DISCOUNT_EXEMPT_FLAG =
decode( A_VOL_DISCOUNT_EXEMPT_FLAG,
1, msii_master_temp.VOL_DISCOUNT_EXEMPT_FLAG,
MSII.VOL_DISCOUNT_EXEMPT_FLAG ),
MSII.COUPON_EXEMPT_FLAG =
decode( A_COUPON_EXEMPT_FLAG,
1, msii_master_temp.COUPON_EXEMPT_FLAG,
MSII.COUPON_EXEMPT_FLAG ),
MSII.COMMS_NL_TRACKABLE_FLAG =
decode( A_COMMS_NL_TRACKABLE_FLAG,
1, msii_master_temp.COMMS_NL_TRACKABLE_FLAG,
MSII.COMMS_NL_TRACKABLE_FLAG ),
MSII.ASSET_CREATION_CODE =
decode( A_ASSET_CREATION_CODE,
1, msii_master_temp.ASSET_CREATION_CODE,
MSII.ASSET_CREATION_CODE ),
MSII.COMMS_ACTIVATION_REQD_FLAG =
decode( A_COMMS_ACTIVATION_REQD_FLAG,
1, msii_master_temp.COMMS_ACTIVATION_REQD_FLAG,
MSII.COMMS_ACTIVATION_REQD_FLAG ),
MSII.ORDERABLE_ON_WEB_FLAG =
decode( A_ORDERABLE_ON_WEB_FLAG,
1, msii_master_temp.ORDERABLE_ON_WEB_FLAG,
MSII.ORDERABLE_ON_WEB_FLAG ),
MSII.BACK_ORDERABLE_FLAG =
decode( A_BACK_ORDERABLE_FLAG,
1, msii_master_temp.BACK_ORDERABLE_FLAG,
MSII.BACK_ORDERABLE_FLAG ),
MSII.WEB_STATUS =
decode( A_WEB_STATUS,
1, msii_master_temp.WEB_STATUS,
MSII.WEB_STATUS ),
MSII.INDIVISIBLE_FLAG =
decode( A_INDIVISIBLE_FLAG,
1, msii_master_temp.INDIVISIBLE_FLAG,
MSII.INDIVISIBLE_FLAG ),
MSII.DIMENSION_UOM_CODE =
decode( A_DIMENSION_UOM_CODE,
1, msii_master_temp.DIMENSION_UOM_CODE,
MSII.DIMENSION_UOM_CODE ),
MSII.UNIT_LENGTH =
decode( A_UNIT_LENGTH,
1, msii_master_temp.UNIT_LENGTH,
MSII.UNIT_LENGTH ),
MSII.UNIT_WIDTH =
decode( A_UNIT_WIDTH,
1, msii_master_temp.UNIT_WIDTH,
MSII.UNIT_WIDTH ),
MSII.UNIT_HEIGHT =
decode( A_UNIT_HEIGHT,
1, msii_master_temp.UNIT_HEIGHT,
MSII.UNIT_HEIGHT ),
MSII.BULK_PICKED_FLAG =
decode( A_BULK_PICKED_FLAG,
1, msii_master_temp.BULK_PICKED_FLAG,
MSII.BULK_PICKED_FLAG ),
MSII. LOT_STATUS_ENABLED=
decode( A_LOT_STATUS_ENABLED,
1, msii_master_temp.LOT_STATUS_ENABLED,
MSII.LOT_STATUS_ENABLED ),
MSII.DEFAULT_LOT_STATUS_ID =
decode( A_DEFAULT_LOT_STATUS_ID,
1, msii_master_temp.DEFAULT_LOT_STATUS_ID,
MSII.DEFAULT_LOT_STATUS_ID ),
MSII.SERIAL_STATUS_ENABLED =
decode( A_SERIAL_STATUS_ENABLED,
1, msii_master_temp.SERIAL_STATUS_ENABLED,
MSII.SERIAL_STATUS_ENABLED ),
MSII.DEFAULT_SERIAL_STATUS_ID =
decode( A_DEFAULT_SERIAL_STATUS_ID,
1, msii_master_temp.DEFAULT_SERIAL_STATUS_ID,
MSII.DEFAULT_SERIAL_STATUS_ID ),
MSII.LOT_SPLIT_ENABLED =
decode( A_LOT_SPLIT_ENABLED,
1, msii_master_temp.LOT_SPLIT_ENABLED,
MSII.LOT_SPLIT_ENABLED ),
MSII.LOT_MERGE_ENABLED =
decode( A_LOT_MERGE_ENABLED,
1, msii_master_temp.LOT_MERGE_ENABLED,
MSII.LOT_MERGE_ENABLED ),
MSII.INVENTORY_CARRY_PENALTY =
decode( A_INVENTORY_CARRY_PENALTY,
1, msii_master_temp.INVENTORY_CARRY_PENALTY,
MSII.INVENTORY_CARRY_PENALTY ),
MSII.OPERATION_SLACK_PENALTY =
decode( A_OPERATION_SLACK_PENALTY,
1, msii_master_temp.OPERATION_SLACK_PENALTY,
MSII.OPERATION_SLACK_PENALTY ),
MSII.FINANCING_ALLOWED_FLAG =
decode( A_FINANCING_ALLOWED_FLAG,
1, msii_master_temp.FINANCING_ALLOWED_FLAG,
MSII.FINANCING_ALLOWED_FLAG ),
MSII.EAM_ITEM_TYPE =
decode( A_EAM_ITEM_TYPE,
1, msii_master_temp.EAM_ITEM_TYPE,
MSII.EAM_ITEM_TYPE ),
MSII.EAM_ACTIVITY_TYPE_CODE =
decode( A_EAM_ACTIVITY_TYPE_CODE,
1, msii_master_temp.EAM_ACTIVITY_TYPE_CODE,
MSII.EAM_ACTIVITY_TYPE_CODE ),
MSII.EAM_ACTIVITY_CAUSE_CODE =
decode( A_EAM_ACTIVITY_CAUSE_CODE,
1, msii_master_temp.EAM_ACTIVITY_CAUSE_CODE,
MSII.EAM_ACTIVITY_CAUSE_CODE ),
MSII.EAM_ACT_NOTIFICATION_FLAG =
decode( A_EAM_ACT_NOTIFICATION_FLAG,
1, msii_master_temp.EAM_ACT_NOTIFICATION_FLAG,
MSII.EAM_ACT_NOTIFICATION_FLAG ),
MSII.EAM_ACT_SHUTDOWN_STATUS =
decode( A_EAM_ACT_SHUTDOWN_STATUS,
1, msii_master_temp.EAM_ACT_SHUTDOWN_STATUS,
MSII.EAM_ACT_SHUTDOWN_STATUS ),
MSII.DUAL_UOM_CONTROL =
decode( A_DUAL_UOM_CONTROL,
1, msii_master_temp.DUAL_UOM_CONTROL,
MSII.DUAL_UOM_CONTROL ),
MSII.SECONDARY_UOM_CODE =
decode( A_SECONDARY_UOM_CODE,
1, msii_master_temp.SECONDARY_UOM_CODE,
MSII.SECONDARY_UOM_CODE ),
MSII.DUAL_UOM_DEVIATION_HIGH =
decode( A_DUAL_UOM_DEVIATION_HIGH,
1, msii_master_temp.DUAL_UOM_DEVIATION_HIGH,
MSII.DUAL_UOM_DEVIATION_HIGH ),
MSII.DUAL_UOM_DEVIATION_LOW =
decode( A_DUAL_UOM_DEVIATION_LOW,
1, msii_master_temp.DUAL_UOM_DEVIATION_LOW,
MSII.DUAL_UOM_DEVIATION_LOW ),
MSII.CONTRACT_ITEM_TYPE_CODE =
decode( A_CONTRACT_ITEM_TYPE_CODE,
1, msii_master_temp.CONTRACT_ITEM_TYPE_CODE,
MSII.CONTRACT_ITEM_TYPE_CODE ),
/* Removed 11.5.10
MSII.SUBSCRIPTION_DEPEND_FLAG =
decode( A_SUBSCRIPTION_DEPEND_FLAG,
1, msii_master_temp.SUBSCRIPTION_DEPEND_FLAG,
MSII.SUBSCRIPTION_DEPEND_FLAG ),
*/
MSII.SERV_REQ_ENABLED_CODE =
DECODE( A_SERV_REQ_ENABLED_CODE,
1, msii_master_temp.SERV_REQ_ENABLED_CODE,
MSII.SERV_REQ_ENABLED_CODE ),
MSII.SERV_BILLING_ENABLED_FLAG =
DECODE( A_SERV_BILLING_ENABLED_FLAG,
1, msii_master_temp.SERV_BILLING_ENABLED_FLAG,
MSII.SERV_BILLING_ENABLED_FLAG ),
MSII.PLANNED_INV_POINT_FLAG =
DECODE( A_PLANNED_INV_POINT_FLAG,
1, msii_master_temp.PLANNED_INV_POINT_FLAG,
MSII.PLANNED_INV_POINT_FLAG ),
MSII.LOT_TRANSLATE_ENABLED =
DECODE( A_LOT_TRANSLATE_ENABLED,
1, msii_master_temp.LOT_TRANSLATE_ENABLED,
MSII.LOT_TRANSLATE_ENABLED ),
MSII.DEFAULT_SO_SOURCE_TYPE =
DECODE( A_DEFAULT_SO_SOURCE_TYPE,
1, msii_master_temp.DEFAULT_SO_SOURCE_TYPE,
MSII.DEFAULT_SO_SOURCE_TYPE ),
MSII.CREATE_SUPPLY_FLAG =
DECODE( A_CREATE_SUPPLY_FLAG,
1, msii_master_temp.CREATE_SUPPLY_FLAG,
MSII.CREATE_SUPPLY_FLAG ),
MSII.SUBSTITUTION_WINDOW_CODE =
DECODE( A_SUBSTITUTION_WINDOW_CODE,
1, msii_master_temp.SUBSTITUTION_WINDOW_CODE,
MSII.SUBSTITUTION_WINDOW_CODE ),
MSII.SUBSTITUTION_WINDOW_DAYS =
DECODE( A_SUBSTITUTION_WINDOW_DAYS,
1, msii_master_temp.SUBSTITUTION_WINDOW_DAYS,
MSII.SUBSTITUTION_WINDOW_DAYS ),
--Added as part of 11.5.9 ENH
MSII.LOT_SUBSTITUTION_ENABLED =
DECODE( A_LOT_SUBSTITUTION_ENABLED,
1, msii_master_temp.LOT_SUBSTITUTION_ENABLED,
MSII.LOT_SUBSTITUTION_ENABLED ),
MSII.MINIMUM_LICENSE_QUANTITY =
DECODE( A_MINIMUM_LICENSE_QUANTITY,
1, msii_master_temp.MINIMUM_LICENSE_QUANTITY,
MSII.MINIMUM_LICENSE_QUANTITY ),
MSII.EAM_ACTIVITY_SOURCE_CODE =
DECODE( A_EAM_ACTIVITY_SOURCE_CODE,
1, msii_master_temp.EAM_ACTIVITY_SOURCE_CODE,
MSII.EAM_ACTIVITY_SOURCE_CODE ),
MSII.IB_ITEM_INSTANCE_CLASS =
DECODE( A_IB_ITEM_INSTANCE_CLASS,
1, msii_master_temp.IB_ITEM_INSTANCE_CLASS,
MSII.IB_ITEM_INSTANCE_CLASS ),
MSII.CONFIG_MODEL_TYPE =
DECODE( A_CONFIG_MODEL_TYPE,
1, msii_master_temp.CONFIG_MODEL_TYPE,
MSII.CONFIG_MODEL_TYPE ),
--Added as part of 11.5.10 ENH
MSII.TRACKING_QUANTITY_IND =
DECODE( A_TRACKING_QUANTITY_IND,
1, msii_master_temp.TRACKING_QUANTITY_IND,
MSII.TRACKING_QUANTITY_IND ),
MSII.ONT_PRICING_QTY_SOURCE =
DECODE( A_ONT_PRICING_QTY_SOURCE,
1, msii_master_temp.ONT_PRICING_QTY_SOURCE,
MSII.ONT_PRICING_QTY_SOURCE ),
MSII.SECONDARY_DEFAULT_IND =
DECODE( A_SECONDARY_DEFAULT_IND,
1, msii_master_temp.SECONDARY_DEFAULT_IND,
MSII.SECONDARY_DEFAULT_IND ),
MSII.AUTO_CREATED_CONFIG_FLAG =
DECODE( A_AUTO_CREATED_CONFIG_FLAG,
1, msii_master_temp.AUTO_CREATED_CONFIG_FLAG,
MSII.AUTO_CREATED_CONFIG_FLAG ),
MSII.CONFIG_ORGS =
DECODE( A_CONFIG_ORGS,
1, msii_master_temp.CONFIG_ORGS,
MSII.CONFIG_ORGS ),
MSII.CONFIG_MATCH =
DECODE( A_CONFIG_MATCH,
1, msii_master_temp.CONFIG_MATCH,
MSII.CONFIG_MATCH ),
MSII.VMI_MINIMUM_UNITS =
DECODE( A_VMI_MINIMUM_UNITS,
1, msii_master_temp.VMI_MINIMUM_UNITS,
MSII.VMI_MINIMUM_UNITS ),
MSII.VMI_MINIMUM_DAYS =
DECODE( A_VMI_MINIMUM_DAYS,
1, msii_master_temp.VMI_MINIMUM_DAYS,
MSII.VMI_MINIMUM_DAYS ),
MSII.VMI_MAXIMUM_UNITS =
DECODE( A_VMI_MAXIMUM_UNITS,
1, msii_master_temp.VMI_MAXIMUM_UNITS,
MSII.VMI_MAXIMUM_UNITS ),
MSII.VMI_MAXIMUM_DAYS =
DECODE( A_VMI_MAXIMUM_DAYS,
1, msii_master_temp.VMI_MAXIMUM_DAYS,
MSII.VMI_MAXIMUM_DAYS ),
MSII.VMI_FIXED_ORDER_QUANTITY =
DECODE( A_VMI_FIXED_ORDER_QUANTITY,
1, msii_master_temp.VMI_FIXED_ORDER_QUANTITY,
MSII.VMI_FIXED_ORDER_QUANTITY ),
MSII.SO_AUTHORIZATION_FLAG =
DECODE( A_SO_AUTHORIZATION_FLAG,
1, msii_master_temp.SO_AUTHORIZATION_FLAG,
MSII.SO_AUTHORIZATION_FLAG ),
MSII.CONSIGNED_FLAG =
DECODE( A_CONSIGNED_FLAG,
1, msii_master_temp.CONSIGNED_FLAG,
MSII.CONSIGNED_FLAG ),
MSII.ASN_AUTOEXPIRE_FLAG =
DECODE( A_ASN_AUTOEXPIRE_FLAG,
1, msii_master_temp.ASN_AUTOEXPIRE_FLAG,
MSII.ASN_AUTOEXPIRE_FLAG ),
MSII.VMI_FORECAST_TYPE =
DECODE( A_VMI_FORECAST_TYPE,
1, msii_master_temp.VMI_FORECAST_TYPE,
MSII.VMI_FORECAST_TYPE ),
MSII.FORECAST_HORIZON =
DECODE( A_FORECAST_HORIZON,
1, msii_master_temp.FORECAST_HORIZON,
MSII.FORECAST_HORIZON ),
MSII.EXCLUDE_FROM_BUDGET_FLAG =
DECODE( A_EXCLUDE_FROM_BUDGET_FLAG,
1, msii_master_temp.EXCLUDE_FROM_BUDGET_FLAG,
MSII.EXCLUDE_FROM_BUDGET_FLAG ),
MSII.DAYS_TGT_INV_SUPPLY =
DECODE( A_DAYS_TGT_INV_SUPPLY,
1, msii_master_temp.DAYS_TGT_INV_SUPPLY,
MSII.DAYS_TGT_INV_SUPPLY ),
MSII.DAYS_TGT_INV_WINDOW =
DECODE( A_DAYS_TGT_INV_WINDOW,
1, msii_master_temp.DAYS_TGT_INV_WINDOW,
MSII.DAYS_TGT_INV_WINDOW ),
MSII.DAYS_MAX_INV_SUPPLY =
DECODE( A_DAYS_MAX_INV_SUPPLY,
1, msii_master_temp.DAYS_MAX_INV_SUPPLY,
MSII.DAYS_MAX_INV_SUPPLY ),
MSII.DAYS_MAX_INV_WINDOW =
DECODE( A_DAYS_MAX_INV_WINDOW,
1, msii_master_temp.DAYS_MAX_INV_WINDOW,
MSII.DAYS_MAX_INV_WINDOW ),
MSII.DRP_PLANNED_FLAG =
DECODE( A_DRP_PLANNED_FLAG,
1, msii_master_temp.DRP_PLANNED_FLAG,
MSII.DRP_PLANNED_FLAG ),
MSII.CRITICAL_COMPONENT_FLAG =
DECODE( A_CRITICAL_COMPONENT_FLAG,
1, msii_master_temp.CRITICAL_COMPONENT_FLAG,
MSII.CRITICAL_COMPONENT_FLAG ),
MSII.CONTINOUS_TRANSFER =
DECODE( A_CONTINOUS_TRANSFER,
1, msii_master_temp.CONTINOUS_TRANSFER,
MSII.CONTINOUS_TRANSFER ),
MSII.CONVERGENCE =
DECODE( A_CONVERGENCE,
1, msii_master_temp.CONVERGENCE,
MSII.CONVERGENCE ),
MSII.DIVERGENCE =
DECODE( A_DIVERGENCE,
1, msii_master_temp.DIVERGENCE,
MSII.DIVERGENCE ),
/* Start Bug 3713912 */
MSII.LOT_DIVISIBLE_FLAG =
DECODE( A_LOT_DIVISIBLE_FLAG,
1, msii_master_temp.LOT_DIVISIBLE_FLAG,
MSII.LOT_DIVISIBLE_FLAG ),
MSII.GRADE_CONTROL_FLAG =
DECODE( A_GRADE_CONTROL_FLAG,
1, msii_master_temp.GRADE_CONTROL_FLAG,
MSII.GRADE_CONTROL_FLAG ),
MSII.DEFAULT_GRADE =
DECODE( A_DEFAULT_GRADE,
1, msii_master_temp.DEFAULT_GRADE,
MSII.DEFAULT_GRADE ),
MSII.CHILD_LOT_FLAG =
DECODE( A_CHILD_LOT_FLAG,
1, msii_master_temp.CHILD_LOT_FLAG,
MSII.CHILD_LOT_FLAG ),
MSII.PARENT_CHILD_GENERATION_FLAG =
DECODE( A_PARENT_CHILD_GENERATION_FLAG,
1, msii_master_temp.PARENT_CHILD_GENERATION_FLAG,
MSII.PARENT_CHILD_GENERATION_FLAG ),
MSII.CHILD_LOT_PREFIX =
DECODE( A_CHILD_LOT_PREFIX,
1, msii_master_temp.CHILD_LOT_PREFIX,
MSII.CHILD_LOT_PREFIX ),
MSII.CHILD_LOT_STARTING_NUMBER =
DECODE( A_CHILD_LOT_STARTING_NUMBER,
1, msii_master_temp.CHILD_LOT_STARTING_NUMBER,
MSII.CHILD_LOT_STARTING_NUMBER ),
MSII.CHILD_LOT_VALIDATION_FLAG =
DECODE( A_CHILD_LOT_VALIDATION_FLAG,
1, msii_master_temp.CHILD_LOT_VALIDATION_FLAG,
MSII.CHILD_LOT_VALIDATION_FLAG ),
MSII.COPY_LOT_ATTRIBUTE_FLAG =
DECODE( A_COPY_LOT_ATTRIBUTE_FLAG,
1, msii_master_temp.COPY_LOT_ATTRIBUTE_FLAG,
MSII.COPY_LOT_ATTRIBUTE_FLAG ),
MSII.RECIPE_ENABLED_FLAG =
DECODE( A_RECIPE_ENABLED_FLAG,
1, msii_master_temp.RECIPE_ENABLED_FLAG,
MSII.RECIPE_ENABLED_FLAG ),
MSII.PROCESS_QUALITY_ENABLED_FLAG =
DECODE( A_PROCESS_QUALITY_ENABLED_FLAG,
1, msii_master_temp.PROCESS_QUALITY_ENABLED_FLAG,
MSII.PROCESS_QUALITY_ENABLED_FLAG ),
MSII.PROCESS_EXECUTION_ENABLED_FLAG =
DECODE( A_PROCESS_EXEC_ENABLED_FLAG,
1, msii_master_temp.PROCESS_EXECUTION_ENABLED_FLAG,
MSII.PROCESS_EXECUTION_ENABLED_FLAG ),
MSII.PROCESS_COSTING_ENABLED_FLAG =
DECODE( A_PROCESS_COSTING_ENABLED_FLAG,
1, msii_master_temp.PROCESS_COSTING_ENABLED_FLAG,
MSII.PROCESS_COSTING_ENABLED_FLAG ),
MSII.HAZARDOUS_MATERIAL_FLAG =
DECODE( A_HAZARDOUS_MATERIAL_FLAG,
1, msii_master_temp.HAZARDOUS_MATERIAL_FLAG,
MSII.HAZARDOUS_MATERIAL_FLAG ),
MSII.CAS_NUMBER =
DECODE( A_CAS_NUMBER,
1, msii_master_temp.CAS_NUMBER,
MSII.CAS_NUMBER ),
MSII.RETEST_INTERVAL =
DECODE( A_RETEST_INTERVAL,
1, msii_master_temp.RETEST_INTERVAL,
MSII.RETEST_INTERVAL ),
MSII.EXPIRATION_ACTION_INTERVAL =
DECODE( A_EXPIRATION_ACTION_INTERVAL,
1, msii_master_temp.EXPIRATION_ACTION_INTERVAL,
MSII.EXPIRATION_ACTION_INTERVAL ),
MSII.EXPIRATION_ACTION_CODE =
DECODE( A_EXPIRATION_ACTION_CODE,
1, msii_master_temp.EXPIRATION_ACTION_CODE,
MSII.EXPIRATION_ACTION_CODE ),
MSII.MATURITY_DAYS =
DECODE( A_MATURITY_DAYS,
1, msii_master_temp.MATURITY_DAYS,
MSII.MATURITY_DAYS ),
MSII.HOLD_DAYS =
DECODE( A_HOLD_DAYS,
1, msii_master_temp.HOLD_DAYS,
MSII.HOLD_DAYS ),
/* End Bug 3713912 */
--R12 Enhancement
MSII.CHARGE_PERIODICITY_CODE = DECODE( A_CHARGE_PERIODICITY_CODE,1, msii_master_temp.CHARGE_PERIODICITY_CODE,MSII.CHARGE_PERIODICITY_CODE ),
MSII.REPAIR_LEADTIME = DECODE( A_REPAIR_LEADTIME,1, msii_master_temp.REPAIR_LEADTIME,MSII.REPAIR_LEADTIME),
MSII.REPAIR_YIELD = DECODE( A_REPAIR_YIELD,1, msii_master_temp.REPAIR_YIELD,MSII.REPAIR_YIELD),
MSII.PREPOSITION_POINT = DECODE( A_PREPOSITION_POINT, 1, msii_master_temp.PREPOSITION_POINT, MSII.PREPOSITION_POINT),
MSII.REPAIR_PROGRAM = DECODE( A_REPAIR_PROGRAM,1, msii_master_temp.REPAIR_PROGRAM,MSII.REPAIR_PROGRAM),
MSII.SUBCONTRACTING_COMPONENT = DECODE( A_SUBCONTRACTING_COMPONENT,1, msii_master_temp.SUBCONTRACTING_COMPONENT,MSII.SUBCONTRACTING_COMPONENT ),
MSII.OUTSOURCED_ASSEMBLY = DECODE( A_OUTSOURCED_ASSEMBLY,1, msii_master_temp.OUTSOURCED_ASSEMBLY,MSII.OUTSOURCED_ASSEMBLY),
MSII.ITEM_CATALOG_GROUP_ID = msii_master_temp.ITEM_CATALOG_GROUP_ID,--Bug: 3074458
--3637854 Should carry masters' lifecycle.
MSII.LIFECYCLE_ID = msii_master_temp.LIFECYCLE_ID,
MSII.CURRENT_PHASE_ID = DECODE(MSII.LIFECYCLE_ID,msii_master_temp.LIFECYCLE_ID,MSII.CURRENT_PHASE_ID,msii_master_temp.CURRENT_PHASE_ID),
MSII.PROCESS_FLAG = l_process_flag_2,
MSII.GDSN_OUTBOUND_ENABLED_FLAG = msii_master_temp.GDSN_OUTBOUND_ENABLED_FLAG,
MSII.TRADE_ITEM_DESCRIPTOR = msii_master_temp.TRADE_ITEM_DESCRIPTOR
WHERE MSII.inventory_item_id = inv_item_id
AND MSII.organization_id = org_id
AND MSII.set_process_id = xset_id + 1000000000000;
FUNCTION validate_item_update_child
(
org_id NUMBER,
all_org NUMBER := 2,
prog_appid NUMBER := -1,
prog_id NUMBER := -1,
request_id NUMBER := -1,
user_id NUMBER := -1,
login_id NUMBER := -1,
err_text IN OUT NOCOPY VARCHAR2,
xset_id IN NUMBER DEFAULT NULL
)
RETURN INTEGER
IS
CURSOR C_msii_child_records is
select
ROWID,
INVENTORY_ITEM_ID,
ORGANIZATION_ID,
TRANSACTION_ID
from MTL_SYSTEM_ITEMS_INTERFACE
where process_flag = 4
and set_process_id = xset_id
and ((organization_id = org_id) or (all_org = 1))
and organization_id in
(select organization_id
from MTL_PARAMETERS MP
where MP.organization_id <> MP.master_organization_id);
ret_code_update NUMBER := 1;
INVPUTLI.info('INVUPD2B: Inside validate_item_update_child'|| '***orgid: ' || TO_CHAR(org_id));
ret_code_update := INVUPD2B.update_validations(
crec.ROWID,
crec.ORGANIZATION_ID,
crec.TRANSACTION_ID,
user_id,
login_id,
prog_appid,
prog_id,
request_id);
'when OTHERS exception raised in validate_item_update_child ' ||
SQLCODE ||
' - ' ||
SQLERRM,1,240));
END validate_item_update_child;
FUNCTION update_validations
(
row_id ROWID,
org_id NUMBER,
trans_id NUMBER,
user_id NUMBER := -1,
login_id NUMBER := -1,
prog_appid NUMBER := -1,
prog_id NUMBER := -1,
request_id NUMBER := -1
)
RETURN INTEGER
IS
msii_temp mtl_system_items_interface%ROWTYPE;
INVPUTLI.info('INVUPD2B: Inside update_validations'|| '***orgid: ' || TO_CHAR(org_id));
select *
into msii_temp
from MTL_SYSTEM_ITEMS_INTERFACE MSII
where MSII.rowid = row_id;
select *
into msi_temp
from MTL_SYSTEM_ITEMS_B MSI
where MSI.organization_id = msii_temp.organization_id
and msi.inventory_item_id = msii_temp.inventory_item_id ;
select master_organization_id
into morgid
from MTL_PARAMETERS
where organization_id = msii_temp.organization_id;
INVPUTLI.info('INVUPD2B: Inside update_validations: After Table Quries');
'INV_LOT_QOH_CANNOT_UPDATE',
err_text);
'INV_INTRANSIT_CANNOT_UPDATE',
err_text);
'INV_DELIVER_CANNOT_UPDATE',
err_text);
'INV_LOT_QOH_CANNOT_UPDATE',
err_text);
'INV_LOT_QOH_CANNOT_UPDATE',
err_text);
'INV_LOT_QOH_CANNOT_UPDATE',
err_text);
'INV_LOT_QOH_CANNOT_UPDATE',
err_text);
'INV_DELIVER_CANNOT_UPDATE',
err_text);
'INV_INTRANSIT_CANNOT_UPDATE',
err_text);
'INV_DELIVER_CANNOT_UPDATE',
err_text);
SELECT 1 INTO l_item_has_lot_comp
FROM bom_components_b bic, bom_structures_b bbom
WHERE bic.basis_type =2
and bic.bill_sequence_id=bbom.common_bill_sequence_id
and bbom.assembly_item_id=msii_temp.inventory_item_id
and bbom.organization_id =msii_temp.organization_id
and ROWNUM = 1;
UPDATE mtl_system_items_interface
SET lead_time_lot_size = msii_temp.std_lot_size
WHERE rowid = row_id;
'INV_VEHICLE_CANNOT_UPDATE',
err_text);
INVPUTLI.info('INVUPD2B: Inside update_validations: 11.5.10 validations started');
'INV_DELIVER_CANNOT_UPDATE',
err_text);
INVPUTLI.info('INVUPD2B: Inside update_validations: VMI validations failed');
INVPUTLI.info('INVUPD2B: Inside update_validations: 11.5.10 validations Ended');
INVPUTLI.info('INVUPD2B: Inside update_validations: TRACKING_QUANTITY_IND onhand validations failed');
'INV_QOH_CANNOT_UPDATE',
err_text);
INVPUTLI.info('INVUPD2B: Inside update_validations: TRACKING_QUANTITY_IND pending validations failed');
INVPUTLI.info('INVUPD2B: Inside update_validations: SECONDARY_UOM_CODE onhand validations failed');
'INV_QOH_CANNOT_UPDATE',
err_text);
INVPUTLI.info('INVUPD2B: Inside update_validations: SECONDARY_UOM_CODE pending validations failed');
INVPUTLI.info('INVUPD2B: Inside update_validations: SECONDARY_DEFAULT_IND onhand validations failed');
'INV_QOH_CANNOT_UPDATE',
err_text);
INVPUTLI.info('INVUPD2B: Inside update_validations: SECONDARY_DEFAULT_IND pending validations failed');
INVPUTLI.info('INVUPD2B: Inside update_validations: PRIMARY_UOM_CODE onhand validations failed');
'INV_QOH_CANNOT_UPDATE',
err_text);
INVPUTLI.info('INVUPD2B: Inside update_validations: PRIMARY_UOM_CODE pending validations failed');
INVPUTLI.info('INVUPD2B: Inside update_validations: DUAL_UOM_DEVIATION_HIGH onhand validations failed');
'INV_QOH_CANNOT_UPDATE',
err_text);
INVPUTLI.info('INVUPD2B: Inside update_validations: DUAL_UOM_DEVIATION_HIGH pending validations failed');
INVPUTLI.info('INVUPD2B: Inside update_validations: DUAL_UOM_DEVIATION_LOW onhand validations failed');
'INV_QOH_CANNOT_UPDATE',
err_text);
INVPUTLI.info('INVUPD2B: Inside update_validations: DUAL_UOM_DEVIATION_LOW pending validations failed');
'when OTHERS exception raised in update_validations ' ||
SQLCODE ||
' - ' ||
SQLERRM,1,240));
END update_validations;
FUNCTION inproit_process_item_update
(
prg_appid IN NUMBER,
prg_id IN NUMBER,
req_id IN NUMBER,
user_id IN NUMBER,
login_id IN NUMBER,
error_message OUT NOCOPY VARCHAR2,
message_name OUT NOCOPY VARCHAR2,
table_name OUT NOCOPY VARCHAR2,
xset_id IN NUMBER DEFAULT NULL
)
RETURN INTEGER
IS
--Fix bug 6974062(7442071,7001285)
CURSOR C_msii_processed_records
IS
SELECT distinct msii.inventory_item_id
FROM MTL_SYSTEM_ITEMS_INTERFACE msii
WHERE
( set_process_id = xset_id OR
set_process_id = xset_id + 1000000000000 )
AND transaction_type IN ('UPDATE', 'AUTO_CHILD')
AND process_flag = 4;
SELECT distinct msii.inventory_item_id, organization_id, item_number
FROM MTL_SYSTEM_ITEMS_INTERFACE msii
WHERE
( set_process_id = xset_id OR
set_process_id = xset_id + 1000000000000 )
AND transaction_type IN ('UPDATE', 'AUTO_CHILD')
AND process_flag = 4;
SELECT rev.*, rev.rowid
FROM mtl_item_revisions_interface rev
WHERE( rev.set_process_id = xset_id
OR rev.set_process_id = xset_id + 1000000000000 )
AND rev.transaction_type = 'UPDATE'
AND rev.process_flag = 4;
SELECT
msii.inventory_item_id INV_ITEM_ID
, msii.primary_uom_code PUOMCODE
, muom.unit_of_measure PUOM
, muom.base_uom_flag
, muom.uom_class UOMCL
FROM
mtl_units_of_measure_vl muom
, mtl_system_items_interface msii
WHERE
msii.process_flag = 4
AND msii.allowed_units_lookup_code = 1
AND(msii.set_process_id = xset_id OR
msii.set_process_id = xset_id + 1000000000000)
AND muom.uom_code = msii.primary_uom_code
AND NOT EXISTS
( select 'x'
from mtl_uom_conversions
where inventory_item_id = msii.inventory_item_id
and uom_code = msii.primary_uom_code
);
SELECT msii.transaction_id,
tl.language,
tl.column_value,
msii.inventory_item_id,
msii.organization_id
FROM mtl_system_items_interface msii,
ego_interface_tl tl,
mtl_system_items item
WHERE item.inventory_item_id = msii.inventory_item_id
AND item.organization_id = msii.organization_id
AND msii.transaction_type in ('UPDATE','AUTO_CHILD')
AND msii.process_flag = 4
AND (msii.set_process_id = xset_id or msii.set_process_id = xset_id + 1000000000000)
AND tl.unique_id = msii.transaction_id
AND tl.set_process_id = msii.set_process_id
AND UPPER(tl.table_name) = 'MTL_SYSTEM_ITEMS_INTERFACE'
AND UPPER(tl.column_name) = 'DESCRIPTION'
AND tl.language IN (SELECT l.language_code FROM fnd_languages l
WHERE l.installed_flag IN ('I', 'B'));
SELECT 1 FROM ego_import_option_sets
WHERE batch_id = cp_xset_id
AND enabled_for_data_pool = 'Y';
SELECT name
FROM hr_organization_units
WHERE organization_id = cp_org_id;
SELECT 1
FROM MTL_SYSTEM_ITEMS_INTERFACE
WHERE inventory_item_id = p_inventory_item_id
AND organization_id = p_organization_id
AND process_flag = 4
AND set_process_id = p_set_id
AND transaction_type IN ('UPDATE', 'AUTO_CHILD');
CURSOR c_item_number_updated
IS
SELECT msik.inventory_item_id,
msii.segment1,msii.segment2,msii.segment3,msii.segment4,msii.segment5,
msii.segment6,msii.segment7,msii.segment8,msii.segment9,msii.segment10,
msii.segment11,msii.segment12,msii.segment13,msii.segment14,msii.segment15,
msii.segment16,msii.segment17,msii.segment18,msii.segment19,msii.segment20
FROM mtl_system_items_b_kfv msik,
mtl_system_items_interface msii,
mtl_parameters mp
WHERE msii.set_process_id = xset_id
AND msii.transaction_type = 'UPDATE'
AND msii.process_flag = 4
AND msii.organization_id = mp.master_organization_id
AND mp.organization_id = mp.master_organization_id
AND msii.inventory_item_id = msik.inventory_item_id
AND msii.organization_id = msik.organization_id
AND msii.item_number <> msik.concatenated_segments
AND msik.concatenated_segments IS NOT NULL;
l_transaction_type varchar2(10) := 'UPDATE';
l_last_updated_by number;
INVPUTLI.info('INVUPD2B.inproit_process_item_update : begin');
select INSTALLED_FLAG
into l_INSTALLED_FLAG
from FND_LANGUAGES
where LANGUAGE_CODE = userenv('LANG');
UPDATE MTL_SYSTEM_ITEMS_INTERFACE
SET process_flag = 3
WHERE inventory_item_id = item_rec.inventory_item_id
AND organization_id = item_rec.organization_id
AND process_flag = 4
AND set_process_id = xset_id
AND transaction_type IN ('UPDATE', 'AUTO_CHILD')
RETURNING transaction_id BULK COLLECT INTO transaction_table;
/* All updates and inserts that happen for a given Item to production tables
must ALL occur or NONE must occur. Also ALL Master-Child updates must happen
or NONE. Therefore defining a cursor that tries to lock all required
records before proceeding.
*/
DECLARE
CURSOR C_lock_msi_records
IS
select msi.ROWID msi_rowid,
msi.inventory_item_status_code msi_status_code,
msi.lifecycle_id msi_lifecycle_id,
msi.current_phase_id msi_current_phase_id,
msi.item_catalog_group_id msi_catalog_group_id,
msi.INVENTORY_ITEM_FLAG inv_item_flag,
msi.PURCHASING_ITEM_FLAG purchasing_flag,
msi.INTERNAL_ORDER_FLAG int_order_flag,
msi.MRP_PLANNING_CODE planning_code,
msi.SERVICE_ITEM_FLAG serv_item_flag,
msi.CUSTOMER_ORDER_FLAG cust_ord_flag,
msi.COSTING_ENABLED_FLAG cost_flag,
msi.ENG_ITEM_FLAG eng_flag,
/* Adding GDSN Changes - R12 FPC */
msi.GDSN_OUTBOUND_ENABLED_FLAG gdsn_flag,
msi.EAM_ITEM_TYPE eam_type,
msi.CONTRACT_ITEM_TYPE_CODE contract_type,
msi.INVENTORY_ASSET_FLAG inv_asset_flag,--Bug:3899614
msi.OBJECT_VERSION_NUMBER obj_ver_num,
msii.ROWID msii_rowid, msii.*
from MTL_SYSTEM_ITEMS_B msi, MTL_SYSTEM_ITEMS_INTERFACE msii
where item_rec.inventory_item_id = msii.inventory_item_id
and item_rec.inventory_item_id = msi.inventory_item_id
and msii.transaction_type in ('UPDATE','AUTO_CHILD')
and msi.organization_id = msii.organization_id
and msii.process_flag = 4
and (msii.set_process_id = xset_id or msii.set_process_id = xset_id + 1000000000000)
for update of msi.inventory_item_id nowait;
INVPUTLI.info('INVUPD2B: inserting the item category assignments for default category sets ');
insert into mtl_item_categories
(
inventory_item_id,
category_set_id,
category_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
program_application_id,
program_id,
program_update_date,
request_id,
organization_id
)
select
rec.inventory_item_id,
s.category_set_id,
s.default_category_id,
sysdate,
-1,
sysdate,
-1,
-1,
-1,
-1,
sysdate,
-1,
rec.organization_id
from mtl_category_sets s
where s.category_set_id in
( select d.category_set_id
from mtl_default_category_sets d
where (d.functional_area_id =
decode(rec.INVENTORY_ITEM_FLAG,'Y',1,0)
or d.functional_area_id =
decode(rec.PURCHASING_ITEM_FLAG,'Y',2,0)
or d.functional_area_id =
decode(rec.INTERNAL_ORDER_FLAG,'Y',2,0)
or d.functional_area_id =
decode(rec.MRP_PLANNING_CODE,6,0,3)
or d.functional_area_id =
decode(rec.SERVICE_ITEM_FLAG,'Y',4,0)
or d.functional_area_id =
decode(rec.CUSTOMER_ORDER_FLAG,'Y',7,0)
or d.functional_area_id =
decode(rec.COSTING_ENABLED_FLAG,'Y',5,0)
or d.functional_area_id =
decode(rec.ENG_ITEM_FLAG,'Y',6,0)
/* Default vategory Assignment for GDSN Syndicated Items - R12 FPC */
or d.functional_area_id =
decode(rec.GDSN_OUTBOUND_ENABLED_FLAG, 'Y', 12,0)
or d.functional_area_id =
decode( NVL(rec.EAM_ITEM_TYPE, 0), 0, 0, 9 )
or d.functional_area_id =
decode( rec.CONTRACT_ITEM_TYPE_CODE,
'SERVICE' , 10,
'WARRANTY' , 10,
'SUBSCRIPTION' , 10,
'USAGE' , 10, 0 )
-- These Contract Item types also imply an item belonging to the Service functional area
or d.functional_area_id =
decode( rec.CONTRACT_ITEM_TYPE_CODE,
'SERVICE' , 4,
'WARRANTY' , 4, 0 )
)
)
and not exists
( select 'already_exists'
from mtl_item_categories mic
where mic.inventory_item_id = rec.inventory_item_id
and mic.organization_id = rec.organization_id
and mic.category_set_id = s.category_set_id
);
IF ( rec.transaction_type = 'UPDATE') THEN
insert into mtl_item_categories
(
inventory_item_id,
category_set_id,
category_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
program_application_id,
program_id,
program_update_date,
request_id,
organization_id
)
select
rec.inventory_item_id,
s.category_set_id,
s.default_category_id,
sysdate,
-1,
sysdate,
-1,
-1,
-1,
-1,
sysdate,
-1,
p.organization_id
from mtl_category_sets s
, mtl_parameters p
where
p.master_organization_id =
(select master_organization_id
from mtl_parameters
where organization_id = rec.organization_id
)
AND s.default_category_id IS NOT NULL --Bug: 2801594
and s.category_set_id in
( select d.category_set_id
from mtl_default_category_sets d
where d.functional_area_id =
decode( rec.INTERNAL_ORDER_FLAG, 'Y', 11, 0 )
or d.functional_area_id =
decode( rec.CUSTOMER_ORDER_FLAG, 'Y', 11, 0 )
)
and EXISTS
( SELECT 'x'
FROM mtl_system_items_b i
WHERE i.inventory_item_id = rec.inventory_item_id
AND i.organization_id = p.organization_id
)
-- Check if the item already has any category assignment
and not exists
( select 'already_exists'
from mtl_item_categories mic
where mic.inventory_item_id = rec.inventory_item_id
--Bug 4089984. Modified following 'and' condition to
-- pick up rows from mtl_parameters table
and mic.organization_id = p.organization_id
and mic.category_set_id = s.category_set_id
);
delete from mtl_descr_element_values
where
inventory_item_id = rec.inventory_item_id
and rec.item_catalog_group_id is not null
and exists
( select 'x'
from mtl_parameters MP
where MP.organization_id = rec.organization_id
and MP.master_organization_id = rec.organization_id
);
insert into MTL_DESCR_ELEMENT_VALUES
(
inventory_item_id,
element_name,
default_element_flag,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
request_id,
program_application_id,
program_id,
program_update_date,
element_sequence
)
select
rec.inventory_item_id,
MDE.ELEMENT_NAME,
MDE.default_element_flag,
l_sysdate,
user_id, /* last_updated_by */
l_sysdate,
user_id, /* created_by */
login_id, /* last_update_login */
req_id,
prg_appid,
prg_id,
l_sysdate,
MDE.ELEMENT_SEQUENCE
from
mtl_descriptive_elements MDE
, mtl_parameters MP
where
rec.organization_id = MP.master_organization_id
and rec.organization_id = MP.organization_id
and MDE.item_catalog_group_id = nvl(rec.item_catalog_group_id,-999);
insert into mtl_pending_item_status
( INVENTORY_ITEM_ID,
ORGANIZATION_ID,
STATUS_CODE,
LIFECYCLE_ID,
PHASE_ID,
EFFECTIVE_DATE,
IMPLEMENTED_DATE,
PENDING_FLAG,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY
)
values
( rec.inventory_item_id,
rec.organization_id,
rec.inventory_item_status_code,
rec.lifecycle_id,
rec.current_phase_id,
l_sysdate,
l_sysdate,
'N',
l_sysdate,
user_id,
l_sysdate,
user_id
);
UPDATE MTL_SYSTEM_ITEMS_B MTLSYSI
SET
--* Modified l_sysdate => Nvl(rec.LAST_UPDATE_DATE,l_sysdate) for Bug - 3313863
LAST_UPDATE_DATE = Nvl(rec.LAST_UPDATE_DATE,l_sysdate),
LAST_UPDATED_BY = user_id,
LAST_UPDATE_LOGIN = login_id,
SUMMARY_FLAG = rec.SUMMARY_FLAG,
ENABLED_FLAG = rec.ENABLED_FLAG,
-- START_DATE_ACTIVE = rec.START_DATE_ACTIVE, Commented for Bug: 4457440
-- END_DATE_ACTIVE = rec.END_DATE_ACTIVE, Commented for Bug: 4457440
DESCRIPTION = decode(l_INSTALLED_FLAG, 'B', rec.DESCRIPTION, DESCRIPTION),
BUYER_ID = rec.BUYER_ID,
ACCOUNTING_RULE_ID = rec.ACCOUNTING_RULE_ID,
INVOICING_RULE_ID = rec.INVOICING_RULE_ID,
ATTRIBUTE1 = rec.ATTRIBUTE1,
ATTRIBUTE2 = rec.ATTRIBUTE2,
ATTRIBUTE3 = rec.ATTRIBUTE3,
ATTRIBUTE4 = rec.ATTRIBUTE4,
ATTRIBUTE5 = rec.ATTRIBUTE5,
ATTRIBUTE6 = rec.ATTRIBUTE6,
ATTRIBUTE7 = rec.ATTRIBUTE7,
ATTRIBUTE8 = rec.ATTRIBUTE8,
ATTRIBUTE9 = rec.ATTRIBUTE9,
ATTRIBUTE10 = rec.ATTRIBUTE10,
ATTRIBUTE11 = rec.ATTRIBUTE11,
ATTRIBUTE12 = rec.ATTRIBUTE12,
ATTRIBUTE13 = rec.ATTRIBUTE13,
ATTRIBUTE14 = rec.ATTRIBUTE14,
ATTRIBUTE15 = rec.ATTRIBUTE15,
/* Start Bug 3713912 */
ATTRIBUTE16 = rec.ATTRIBUTE16,
ATTRIBUTE17 = rec.ATTRIBUTE17,
ATTRIBUTE18 = rec.ATTRIBUTE18,
ATTRIBUTE19 = rec.ATTRIBUTE19,
ATTRIBUTE20 = rec.ATTRIBUTE20,
ATTRIBUTE21 = rec.ATTRIBUTE21,
ATTRIBUTE22 = rec.ATTRIBUTE22,
ATTRIBUTE23 = rec.ATTRIBUTE23,
ATTRIBUTE24 = rec.ATTRIBUTE24,
ATTRIBUTE25 = rec.ATTRIBUTE25,
ATTRIBUTE26 = rec.ATTRIBUTE26,
ATTRIBUTE27 = rec.ATTRIBUTE27,
ATTRIBUTE28 = rec.ATTRIBUTE28,
ATTRIBUTE29 = rec.ATTRIBUTE29,
ATTRIBUTE30 = rec.ATTRIBUTE30,
/* End Bug 3713912 */
ATTRIBUTE_CATEGORY = rec.ATTRIBUTE_CATEGORY,
GLOBAL_ATTRIBUTE_CATEGORY = rec.GLOBAL_ATTRIBUTE_CATEGORY,
GLOBAL_ATTRIBUTE1 = rec.GLOBAL_ATTRIBUTE1,
GLOBAL_ATTRIBUTE2 = rec.GLOBAL_ATTRIBUTE2,
GLOBAL_ATTRIBUTE3 = rec.GLOBAL_ATTRIBUTE3,
GLOBAL_ATTRIBUTE4 = rec.GLOBAL_ATTRIBUTE4,
GLOBAL_ATTRIBUTE5 = rec.GLOBAL_ATTRIBUTE5,
GLOBAL_ATTRIBUTE6 = rec.GLOBAL_ATTRIBUTE6,
GLOBAL_ATTRIBUTE7 = rec.GLOBAL_ATTRIBUTE7,
GLOBAL_ATTRIBUTE8 = rec.GLOBAL_ATTRIBUTE8,
GLOBAL_ATTRIBUTE9 = rec.GLOBAL_ATTRIBUTE9,
GLOBAL_ATTRIBUTE10 = rec.GLOBAL_ATTRIBUTE10,
GLOBAL_ATTRIBUTE11 = rec.GLOBAL_ATTRIBUTE11,
GLOBAL_ATTRIBUTE12 = rec.GLOBAL_ATTRIBUTE12,
GLOBAL_ATTRIBUTE13 = rec.GLOBAL_ATTRIBUTE13,
GLOBAL_ATTRIBUTE14 = rec.GLOBAL_ATTRIBUTE14,
GLOBAL_ATTRIBUTE15 = rec.GLOBAL_ATTRIBUTE15,
GLOBAL_ATTRIBUTE16 = rec.GLOBAL_ATTRIBUTE16,
GLOBAL_ATTRIBUTE17 = rec.GLOBAL_ATTRIBUTE17,
GLOBAL_ATTRIBUTE18 = rec.GLOBAL_ATTRIBUTE18,
GLOBAL_ATTRIBUTE19 = rec.GLOBAL_ATTRIBUTE19,
GLOBAL_ATTRIBUTE20 = rec.GLOBAL_ATTRIBUTE20,
PURCHASING_ITEM_FLAG = rec.PURCHASING_ITEM_FLAG,
SHIPPABLE_ITEM_FLAG = rec.SHIPPABLE_ITEM_FLAG,
CUSTOMER_ORDER_FLAG = rec.CUSTOMER_ORDER_FLAG,
INTERNAL_ORDER_FLAG = rec.INTERNAL_ORDER_FLAG,
INVENTORY_ITEM_FLAG = rec.INVENTORY_ITEM_FLAG,
ENG_ITEM_FLAG = rec.ENG_ITEM_FLAG,
INVENTORY_ASSET_FLAG = rec.INVENTORY_ASSET_FLAG,
PURCHASING_ENABLED_FLAG = rec.PURCHASING_ENABLED_FLAG,
CUSTOMER_ORDER_ENABLED_FLAG = rec.CUSTOMER_ORDER_ENABLED_FLAG,
INTERNAL_ORDER_ENABLED_FLAG = rec.INTERNAL_ORDER_ENABLED_FLAG,
SO_TRANSACTIONS_FLAG = rec.SO_TRANSACTIONS_FLAG,
MTL_TRANSACTIONS_ENABLED_FLAG = rec.MTL_TRANSACTIONS_ENABLED_FLAG,
STOCK_ENABLED_FLAG = rec.STOCK_ENABLED_FLAG,
BOM_ENABLED_FLAG = rec.BOM_ENABLED_FLAG,
BUILD_IN_WIP_FLAG = rec.BUILD_IN_WIP_FLAG,
REVISION_QTY_CONTROL_CODE = rec.REVISION_QTY_CONTROL_CODE,
ITEM_CATALOG_GROUP_ID = rec.ITEM_CATALOG_GROUP_ID,
CATALOG_STATUS_FLAG = rec.CATALOG_STATUS_FLAG,
RETURNABLE_FLAG = rec.RETURNABLE_FLAG,
DEFAULT_SHIPPING_ORG = rec.DEFAULT_SHIPPING_ORG,
COLLATERAL_FLAG = rec.COLLATERAL_FLAG,
TAXABLE_FLAG = rec.TAXABLE_FLAG,
PURCHASING_TAX_CODE = rec.PURCHASING_TAX_CODE,
ALLOW_ITEM_DESC_UPDATE_FLAG = rec.ALLOW_ITEM_DESC_UPDATE_FLAG,
INSPECTION_REQUIRED_FLAG = rec.INSPECTION_REQUIRED_FLAG,
RECEIPT_REQUIRED_FLAG = rec.RECEIPT_REQUIRED_FLAG,
MARKET_PRICE = rec.MARKET_PRICE,
HAZARD_CLASS_ID = rec.HAZARD_CLASS_ID,
RFQ_REQUIRED_FLAG = rec.RFQ_REQUIRED_FLAG,
QTY_RCV_TOLERANCE = rec.QTY_RCV_TOLERANCE,
LIST_PRICE_PER_UNIT = rec.LIST_PRICE_PER_UNIT,
UN_NUMBER_ID = rec.UN_NUMBER_ID,
PRICE_TOLERANCE_PERCENT = rec.PRICE_TOLERANCE_PERCENT,
ASSET_CATEGORY_ID = rec.ASSET_CATEGORY_ID,
ROUNDING_FACTOR = rec.ROUNDING_FACTOR,
UNIT_OF_ISSUE = rec.UNIT_OF_ISSUE,
ENFORCE_SHIP_TO_LOCATION_CODE = rec.ENFORCE_SHIP_TO_LOCATION_CODE,
ALLOW_SUBSTITUTE_RECEIPTS_FLAG = rec.ALLOW_SUBSTITUTE_RECEIPTS_FLAG,
ALLOW_UNORDERED_RECEIPTS_FLAG = rec.ALLOW_UNORDERED_RECEIPTS_FLAG,
ALLOW_EXPRESS_DELIVERY_FLAG = rec.ALLOW_EXPRESS_DELIVERY_FLAG,
DAYS_EARLY_RECEIPT_ALLOWED = rec.DAYS_EARLY_RECEIPT_ALLOWED,
DAYS_LATE_RECEIPT_ALLOWED = rec.DAYS_LATE_RECEIPT_ALLOWED,
RECEIPT_DAYS_EXCEPTION_CODE = rec.RECEIPT_DAYS_EXCEPTION_CODE,
RECEIVING_ROUTING_ID = rec.RECEIVING_ROUTING_ID,
INVOICE_CLOSE_TOLERANCE = rec.INVOICE_CLOSE_TOLERANCE,
RECEIVE_CLOSE_TOLERANCE = rec.RECEIVE_CLOSE_TOLERANCE,
AUTO_LOT_ALPHA_PREFIX = rec.AUTO_LOT_ALPHA_PREFIX,
START_AUTO_LOT_NUMBER = rec.START_AUTO_LOT_NUMBER,
LOT_CONTROL_CODE = rec.LOT_CONTROL_CODE,
SHELF_LIFE_CODE = rec.SHELF_LIFE_CODE,
SHELF_LIFE_DAYS = rec.SHELF_LIFE_DAYS,
SERIAL_NUMBER_CONTROL_CODE = rec.SERIAL_NUMBER_CONTROL_CODE,
START_AUTO_SERIAL_NUMBER = rec.START_AUTO_SERIAL_NUMBER,
AUTO_SERIAL_ALPHA_PREFIX = rec.AUTO_SERIAL_ALPHA_PREFIX,
SOURCE_TYPE = rec.SOURCE_TYPE,
SOURCE_ORGANIZATION_ID = rec.SOURCE_ORGANIZATION_ID,
SOURCE_SUBINVENTORY = rec.SOURCE_SUBINVENTORY,
EXPENSE_ACCOUNT = rec.EXPENSE_ACCOUNT,
ENCUMBRANCE_ACCOUNT = rec.ENCUMBRANCE_ACCOUNT,
RESTRICT_SUBINVENTORIES_CODE = rec.RESTRICT_SUBINVENTORIES_CODE,
UNIT_WEIGHT = rec.UNIT_WEIGHT,
WEIGHT_UOM_CODE = rec.WEIGHT_UOM_CODE,
VOLUME_UOM_CODE = rec.VOLUME_UOM_CODE,
UNIT_VOLUME = rec.UNIT_VOLUME,
RESTRICT_LOCATORS_CODE = rec.RESTRICT_LOCATORS_CODE,
LOCATION_CONTROL_CODE = rec.LOCATION_CONTROL_CODE,
SHRINKAGE_RATE = rec.SHRINKAGE_RATE,
ACCEPTABLE_EARLY_DAYS = rec.ACCEPTABLE_EARLY_DAYS,
PLANNING_TIME_FENCE_CODE = rec.PLANNING_TIME_FENCE_CODE,
DEMAND_TIME_FENCE_CODE = rec.DEMAND_TIME_FENCE_CODE,
LEAD_TIME_LOT_SIZE = rec.LEAD_TIME_LOT_SIZE,
STD_LOT_SIZE = rec.STD_LOT_SIZE,
CUM_MANUFACTURING_LEAD_TIME = rec.CUM_MANUFACTURING_LEAD_TIME,
OVERRUN_PERCENTAGE = rec.OVERRUN_PERCENTAGE,
ACCEPTABLE_RATE_INCREASE = rec.ACCEPTABLE_RATE_INCREASE,
ACCEPTABLE_RATE_DECREASE = rec.ACCEPTABLE_RATE_DECREASE,
CUMULATIVE_TOTAL_LEAD_TIME = rec.CUMULATIVE_TOTAL_LEAD_TIME,
PLANNING_TIME_FENCE_DAYS = rec.PLANNING_TIME_FENCE_DAYS,
DEMAND_TIME_FENCE_DAYS = rec.DEMAND_TIME_FENCE_DAYS,
END_ASSEMBLY_PEGGING_FLAG = rec.END_ASSEMBLY_PEGGING_FLAG,
PLANNING_EXCEPTION_SET = rec.PLANNING_EXCEPTION_SET,
BOM_ITEM_TYPE = rec.BOM_ITEM_TYPE,
PICK_COMPONENTS_FLAG = rec.PICK_COMPONENTS_FLAG,
REPLENISH_TO_ORDER_FLAG = rec.REPLENISH_TO_ORDER_FLAG,
BASE_ITEM_ID = rec.BASE_ITEM_ID,
ATP_COMPONENTS_FLAG = rec.ATP_COMPONENTS_FLAG,
ATP_FLAG = rec.ATP_FLAG,
FIXED_LEAD_TIME = rec.FIXED_LEAD_TIME,
VARIABLE_LEAD_TIME = rec.VARIABLE_LEAD_TIME,
WIP_SUPPLY_LOCATOR_ID = rec.WIP_SUPPLY_LOCATOR_ID,
WIP_SUPPLY_TYPE = rec.WIP_SUPPLY_TYPE,
WIP_SUPPLY_SUBINVENTORY = rec.WIP_SUPPLY_SUBINVENTORY,
PRIMARY_UOM_CODE = rec.PRIMARY_UOM_CODE,
PRIMARY_UNIT_OF_MEASURE = rec.PRIMARY_UNIT_OF_MEASURE,
ALLOWED_UNITS_LOOKUP_CODE = rec.ALLOWED_UNITS_LOOKUP_CODE,
COST_OF_SALES_ACCOUNT = rec.COST_OF_SALES_ACCOUNT,
SALES_ACCOUNT = rec.SALES_ACCOUNT,
DEFAULT_INCLUDE_IN_ROLLUP_FLAG = rec.DEFAULT_INCLUDE_IN_ROLLUP_FLAG,
INVENTORY_ITEM_STATUS_CODE = rec.INVENTORY_ITEM_STATUS_CODE,
INVENTORY_PLANNING_CODE = rec.INVENTORY_PLANNING_CODE,
PLANNER_CODE = rec.PLANNER_CODE,
PLANNING_MAKE_BUY_CODE = rec.PLANNING_MAKE_BUY_CODE,
FIXED_LOT_MULTIPLIER = rec.FIXED_LOT_MULTIPLIER,
ROUNDING_CONTROL_TYPE = rec.ROUNDING_CONTROL_TYPE,
CARRYING_COST = rec.CARRYING_COST,
POSTPROCESSING_LEAD_TIME = rec.POSTPROCESSING_LEAD_TIME,
PREPROCESSING_LEAD_TIME = rec.PREPROCESSING_LEAD_TIME,
FULL_LEAD_TIME = rec.FULL_LEAD_TIME,
ORDER_COST = rec.ORDER_COST,
MRP_SAFETY_STOCK_PERCENT = rec.MRP_SAFETY_STOCK_PERCENT,
MRP_SAFETY_STOCK_CODE = rec.MRP_SAFETY_STOCK_CODE,
MIN_MINMAX_QUANTITY = rec.MIN_MINMAX_QUANTITY,
MAX_MINMAX_QUANTITY = rec.MAX_MINMAX_QUANTITY,
MINIMUM_ORDER_QUANTITY = rec.MINIMUM_ORDER_QUANTITY,
FIXED_ORDER_QUANTITY = rec.FIXED_ORDER_QUANTITY,
FIXED_DAYS_SUPPLY = rec.FIXED_DAYS_SUPPLY,
MAXIMUM_ORDER_QUANTITY = rec.MAXIMUM_ORDER_QUANTITY,
ATP_RULE_ID = rec.ATP_RULE_ID,
PICKING_RULE_ID = rec.PICKING_RULE_ID,
RESERVABLE_TYPE = rec.RESERVABLE_TYPE,
POSITIVE_MEASUREMENT_ERROR = rec.POSITIVE_MEASUREMENT_ERROR,
NEGATIVE_MEASUREMENT_ERROR = rec.NEGATIVE_MEASUREMENT_ERROR,
ENGINEERING_ECN_CODE = rec.ENGINEERING_ECN_CODE,
ENGINEERING_ITEM_ID = rec.ENGINEERING_ITEM_ID,
ENGINEERING_DATE = rec.ENGINEERING_DATE,
SERVICE_STARTING_DELAY = rec.SERVICE_STARTING_DELAY,
SERVICEABLE_COMPONENT_FLAG = rec.SERVICEABLE_COMPONENT_FLAG,
SERVICEABLE_PRODUCT_FLAG = rec.SERVICEABLE_PRODUCT_FLAG,
BASE_WARRANTY_SERVICE_ID = rec.BASE_WARRANTY_SERVICE_ID,
PAYMENT_TERMS_ID = rec.PAYMENT_TERMS_ID,
PREVENTIVE_MAINTENANCE_FLAG = rec.PREVENTIVE_MAINTENANCE_FLAG,
PRIMARY_SPECIALIST_ID = rec.PRIMARY_SPECIALIST_ID,
SECONDARY_SPECIALIST_ID = rec.SECONDARY_SPECIALIST_ID,
SERVICEABLE_ITEM_CLASS_ID = rec.SERVICEABLE_ITEM_CLASS_ID,
TIME_BILLABLE_FLAG = rec.TIME_BILLABLE_FLAG,
MATERIAL_BILLABLE_FLAG = rec.MATERIAL_BILLABLE_FLAG,
EXPENSE_BILLABLE_FLAG = rec.EXPENSE_BILLABLE_FLAG,
PRORATE_SERVICE_FLAG = rec.PRORATE_SERVICE_FLAG,
COVERAGE_SCHEDULE_ID = rec.COVERAGE_SCHEDULE_ID,
SERVICE_DURATION_PERIOD_CODE = rec.SERVICE_DURATION_PERIOD_CODE,
SERVICE_DURATION = rec.SERVICE_DURATION,
MAX_WARRANTY_AMOUNT = rec.MAX_WARRANTY_AMOUNT,
RESPONSE_TIME_PERIOD_CODE = rec.RESPONSE_TIME_PERIOD_CODE,
RESPONSE_TIME_VALUE = rec.RESPONSE_TIME_VALUE,
NEW_REVISION_CODE = rec.NEW_REVISION_CODE,
TAX_CODE = rec.TAX_CODE,
MUST_USE_APPROVED_VENDOR_FLAG = rec.MUST_USE_APPROVED_VENDOR_FLAG,
SAFETY_STOCK_BUCKET_DAYS = rec.SAFETY_STOCK_BUCKET_DAYS,
AUTO_REDUCE_MPS = rec.AUTO_REDUCE_MPS,
COSTING_ENABLED_FLAG = rec.COSTING_ENABLED_FLAG,
INVOICEABLE_ITEM_FLAG = rec.INVOICEABLE_ITEM_FLAG,
INVOICE_ENABLED_FLAG = rec.INVOICE_ENABLED_FLAG,
OUTSIDE_OPERATION_FLAG = rec.OUTSIDE_OPERATION_FLAG,
OUTSIDE_OPERATION_UOM_TYPE = rec.OUTSIDE_OPERATION_UOM_TYPE,
AUTO_CREATED_CONFIG_FLAG = rec.AUTO_CREATED_CONFIG_FLAG,
CYCLE_COUNT_ENABLED_FLAG = rec.CYCLE_COUNT_ENABLED_FLAG,
MODEL_CONFIG_CLAUSE_NAME = rec.MODEL_CONFIG_CLAUSE_NAME,
SHIP_MODEL_COMPLETE_FLAG = rec.SHIP_MODEL_COMPLETE_FLAG,
MRP_PLANNING_CODE = rec.MRP_PLANNING_CODE,
RETURN_INSPECTION_REQUIREMENT = rec.RETURN_INSPECTION_REQUIREMENT,
REQUEST_ID = req_id,
PROGRAM_APPLICATION_ID = prg_appid,
PROGRAM_ID = prg_id,
PROGRAM_UPDATE_DATE = l_sysdate,
REPETITIVE_PLANNING_FLAG = rec.REPETITIVE_PLANNING_FLAG,
QTY_RCV_EXCEPTION_CODE = rec.QTY_RCV_EXCEPTION_CODE,
MRP_CALCULATE_ATP_FLAG = rec.MRP_CALCULATE_ATP_FLAG,
ITEM_TYPE = rec.ITEM_TYPE,
WARRANTY_VENDOR_ID = rec.WARRANTY_VENDOR_ID,
ATO_FORECAST_CONTROL = rec.ATO_FORECAST_CONTROL,
RELEASE_TIME_FENCE_CODE = rec.RELEASE_TIME_FENCE_CODE,
RELEASE_TIME_FENCE_DAYS = rec.RELEASE_TIME_FENCE_DAYS,
CONTAINER_ITEM_FLAG = rec.CONTAINER_ITEM_FLAG,
CONTAINER_TYPE_CODE = rec.CONTAINER_TYPE_CODE,
INTERNAL_VOLUME = rec.INTERNAL_VOLUME,
MAXIMUM_LOAD_WEIGHT = rec.MAXIMUM_LOAD_WEIGHT,
MINIMUM_FILL_PERCENT = rec.MINIMUM_FILL_PERCENT,
VEHICLE_ITEM_FLAG = rec.VEHICLE_ITEM_FLAG,
CHECK_SHORTAGES_FLAG = rec.CHECK_SHORTAGES_FLAG
, EFFECTIVITY_CONTROL = rec.EFFECTIVITY_CONTROL
, OVERCOMPLETION_TOLERANCE_TYPE = rec.OVERCOMPLETION_TOLERANCE_TYPE
, OVERCOMPLETION_TOLERANCE_VALUE = rec.OVERCOMPLETION_TOLERANCE_VALUE
, OVER_SHIPMENT_TOLERANCE = rec.OVER_SHIPMENT_TOLERANCE
, UNDER_SHIPMENT_TOLERANCE = rec.UNDER_SHIPMENT_TOLERANCE
, OVER_RETURN_TOLERANCE = rec.OVER_RETURN_TOLERANCE
, UNDER_RETURN_TOLERANCE = rec.UNDER_RETURN_TOLERANCE
, EQUIPMENT_TYPE = rec.EQUIPMENT_TYPE
, RECOVERED_PART_DISP_CODE = rec.RECOVERED_PART_DISP_CODE
, DEFECT_TRACKING_ON_FLAG = rec.DEFECT_TRACKING_ON_FLAG
, EVENT_FLAG = rec.EVENT_FLAG
, ELECTRONIC_FLAG = rec.ELECTRONIC_FLAG
, DOWNLOADABLE_FLAG = rec.DOWNLOADABLE_FLAG
, VOL_DISCOUNT_EXEMPT_FLAG = rec.VOL_DISCOUNT_EXEMPT_FLAG
, COUPON_EXEMPT_FLAG = rec.COUPON_EXEMPT_FLAG
, COMMS_NL_TRACKABLE_FLAG = rec.COMMS_NL_TRACKABLE_FLAG
, ASSET_CREATION_CODE = rec.ASSET_CREATION_CODE
, COMMS_ACTIVATION_REQD_FLAG = rec.COMMS_ACTIVATION_REQD_FLAG
, ORDERABLE_ON_WEB_FLAG = rec.ORDERABLE_ON_WEB_FLAG
, BACK_ORDERABLE_FLAG = rec.BACK_ORDERABLE_FLAG
--
, WEB_STATUS = rec.WEB_STATUS
, INDIVISIBLE_FLAG = rec.INDIVISIBLE_FLAG
--
, DIMENSION_UOM_CODE = rec.DIMENSION_UOM_CODE
, UNIT_LENGTH = rec.UNIT_LENGTH
, UNIT_WIDTH = rec.UNIT_WIDTH
, UNIT_HEIGHT = rec.UNIT_HEIGHT
, BULK_PICKED_FLAG = rec.BULK_PICKED_FLAG
, LOT_STATUS_ENABLED = rec.LOT_STATUS_ENABLED
, DEFAULT_LOT_STATUS_ID = rec.DEFAULT_LOT_STATUS_ID
, SERIAL_STATUS_ENABLED = rec.SERIAL_STATUS_ENABLED
, DEFAULT_SERIAL_STATUS_ID = rec.DEFAULT_SERIAL_STATUS_ID
, LOT_SPLIT_ENABLED = rec.LOT_SPLIT_ENABLED
, LOT_MERGE_ENABLED = rec.LOT_MERGE_ENABLED
, INVENTORY_CARRY_PENALTY = rec.INVENTORY_CARRY_PENALTY
, OPERATION_SLACK_PENALTY = rec.OPERATION_SLACK_PENALTY
, FINANCING_ALLOWED_FLAG = rec.FINANCING_ALLOWED_FLAG
, EAM_ITEM_TYPE = rec.EAM_ITEM_TYPE
, EAM_ACTIVITY_TYPE_CODE = rec.EAM_ACTIVITY_TYPE_CODE
, EAM_ACTIVITY_CAUSE_CODE = rec.EAM_ACTIVITY_CAUSE_CODE
, EAM_ACT_NOTIFICATION_FLAG = rec.EAM_ACT_NOTIFICATION_FLAG
, EAM_ACT_SHUTDOWN_STATUS = rec.EAM_ACT_SHUTDOWN_STATUS
, DUAL_UOM_CONTROL = rec.DUAL_UOM_CONTROL
, SECONDARY_UOM_CODE = rec.SECONDARY_UOM_CODE
, DUAL_UOM_DEVIATION_HIGH = rec.DUAL_UOM_DEVIATION_HIGH
, DUAL_UOM_DEVIATION_LOW = rec.DUAL_UOM_DEVIATION_LOW
--
-- Service Item, Warranty, Usage flag attributes are dependent on
-- and derived from Contract Item Type; supported for view only.
update MTL_SYSTEM_ITEMS_TL
set
DESCRIPTION = rec.DESCRIPTION,
LONG_DESCRIPTION = rec.LONG_DESCRIPTION,
LAST_UPDATE_DATE = NVL(rec.LAST_UPDATE_DATE,l_sysdate),
LAST_UPDATED_BY = user_id,
LAST_UPDATE_LOGIN = login_id,
SOURCE_LANG = userenv('LANG')
where
INVENTORY_ITEM_ID = rec.INVENTORY_ITEM_ID
and ORGANIZATION_ID = rec.ORGANIZATION_ID
and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
INV_ITEM_PVT.Delete_Cost_Details(
P_Item_Id => rec.inventory_item_id
,P_Org_Id => rec.organization_id
,P_Asset_Flag => rec.inventory_asset_flag
,P_Cost_Txn => NULL
,P_Last_Updated_By => user_id
,P_Last_Updated_Login => login_id);
INVIDIT2.Insert_Cost_Details (
x_item_id => rec.inventory_item_id
,x_org_id => rec.organization_id
,x_inv_install => INV_Item_Util.g_Appl_Inst.INV
,x_last_updated_by => user_id
,x_cst_item_type => l_cst_item_type );
update mtl_system_items_interface
set process_flag = 3,
request_id = req_id,
PROGRAM_APPLICATION_ID = prg_appid,
PROGRAM_ID = prg_id,
PROGRAM_UPDATE_DATE = l_sysdate,
last_update_login = login_id
where inventory_item_id = item_rec.inventory_item_id
and (set_process_id = xset_id or set_process_id = xset_id + 1000000000000)
and process_flag = 4;
SELECT organization_id, transaction_id INTO
l_org_id,l_transaction_id
FROM mtl_system_items_interface
WHERE inventory_item_id = item_rec.inventory_item_id
and (set_process_id = xset_id or set_process_id = xset_id + 1000000000000)
and process_flag = 3 AND ROWNUM=1;
update mtl_system_items_interface
set process_flag = 3,
request_id = req_id,
PROGRAM_APPLICATION_ID = prg_appid,
PROGRAM_ID = prg_id,
PROGRAM_UPDATE_DATE = l_sysdate,
last_update_login = login_id
where inventory_item_id = item_rec.inventory_item_id
and (set_process_id = xset_id or set_process_id = xset_id + 1000000000000)
and process_flag = 4;
SELECT organization_id, transaction_id INTO l_org_id,l_transaction_id
FROM mtl_system_items_interface
WHERE inventory_item_id = item_rec.inventory_item_id
and (set_process_id = xset_id or set_process_id = xset_id +1000000000000)
and process_flag = 3 AND ROWNUM=1;
'when OTHERS exception raised in inproit_process_item_update' ||
' - Cursor C_lock_msi_records ' ||
SQLCODE ||
' - ' ||
SQLERRM,1,240));
FOR item_csr IN c_item_number_updated
LOOP
IF l_inv_debug_level IN(101, 102) THEN
INVPUTLI.info('INVUPD2B: Update: III' || item_csr.inventory_item_id ||
'segment1' || item_csr.segment1);
UPDATE mtl_system_items_b
SET segment1 = item_csr.segment1,
segment2 = item_csr.segment2,
segment3 = item_csr.segment3,
segment4 = item_csr.segment4,
segment5 = item_csr.segment5,
segment6 = item_csr.segment6,
segment7 = item_csr.segment7,
segment8 = item_csr.segment8,
segment9 = item_csr.segment9,
segment10 = item_csr.segment10,
segment11 = item_csr.segment11,
segment12 = item_csr.segment12,
segment13 = item_csr.segment13,
segment14 = item_csr.segment14,
segment15 = item_csr.segment15,
segment16 = item_csr.segment16,
segment17 = item_csr.segment17,
segment18 = item_csr.segment18,
segment19 = item_csr.segment19,
segment20 = item_csr.segment20
WHERE inventory_item_id = item_csr.inventory_item_id;
UPDATE MTL_SYSTEM_ITEMS_TL
SET DESCRIPTION = NVL(cr.column_value, DESCRIPTION),
LAST_UPDATE_DATE = l_sysdate,
LAST_UPDATED_BY = user_id,
LAST_UPDATE_LOGIN = login_id
WHERE inventory_item_id = cr.inventory_item_id
AND organization_id = cr.organization_id
AND language = cr.language;
select conversion_rate into conversion_rate_temp
from mtl_uom_conversions
where inventory_item_id = 0
and uom_code = UOM_process_rec.PUOMCODE;
INSERT INTO mtl_uom_conversions(
unit_of_measure,
uom_code,
uom_class,
inventory_item_id,
conversion_rate,
default_conversion_flag,
last_update_date,
last_updated_by,
creation_date,
created_by)
VALUES(
UOM_process_rec.PUOM,
UOM_process_rec.PUOMCODE,
UOM_process_rec.UOMCL,
UOM_process_rec.INV_ITEM_ID,
conversion_rate_temp,
l_default_conversion_flag,
l_sysdate,
user_id,
l_sysdate,
user_id);
SELECT ROWID
FROM mtl_item_revisions_b
WHERE revision_id = rev_rec.revision_id
FOR UPDATE of revision_id;
FOR update_rec IN c_lock_rev_record LOOP
UPDATE MTL_ITEM_REVISIONS_B
SET
DESCRIPTION = decode(l_INSTALLED_FLAG, 'B', rev_rec.DESCRIPTION, DESCRIPTION),
CHANGE_NOTICE = rev_rec.CHANGE_NOTICE,
ECN_INITIATION_DATE = rev_rec.ECN_INITIATION_DATE,
IMPLEMENTATION_DATE = rev_rec.IMPLEMENTATION_DATE,
EFFECTIVITY_DATE = rev_rec.EFFECTIVITY_DATE,
ATTRIBUTE_CATEGORY = rev_rec.ATTRIBUTE_CATEGORY,
ATTRIBUTE1 = rev_rec.ATTRIBUTE1,
ATTRIBUTE2 = rev_rec.ATTRIBUTE2,
ATTRIBUTE3 = rev_rec.ATTRIBUTE3,
ATTRIBUTE4 = rev_rec.ATTRIBUTE4,
ATTRIBUTE5 = rev_rec.ATTRIBUTE5,
ATTRIBUTE6 = rev_rec.ATTRIBUTE6,
ATTRIBUTE7 = rev_rec.ATTRIBUTE7,
ATTRIBUTE8 = rev_rec.ATTRIBUTE8,
ATTRIBUTE9 = rev_rec.ATTRIBUTE9,
ATTRIBUTE10 = rev_rec.ATTRIBUTE10,
ATTRIBUTE11 = rev_rec.ATTRIBUTE11,
ATTRIBUTE12 = rev_rec.ATTRIBUTE12,
ATTRIBUTE13 = rev_rec.ATTRIBUTE13,
ATTRIBUTE14 = rev_rec.ATTRIBUTE14,
ATTRIBUTE15 = rev_rec.ATTRIBUTE15,
LIFECYCLE_ID = rev_rec.LIFECYCLE_ID,
CURRENT_PHASE_ID = rev_rec.CURRENT_PHASE_ID,
REVISION_LABEL = rev_rec.REVISION_LABEL,
REVISION_REASON = rev_rec.REVISION_REASON,
REVISED_ITEM_SEQUENCE_ID = rev_rec.REVISED_ITEM_SEQUENCE_ID,
LAST_UPDATE_DATE = NVL(rev_rec.last_update_date,l_sysdate),
LAST_UPDATED_BY = user_id,
LAST_UPDATE_LOGIN = login_id,
/* Bug 4224512 : Incrementing the object version number for each update -Anmurali */
OBJECT_VERSION_NUMBER = NVL(OBJECT_VERSION_NUMBER,1)+1
WHERE rowid = update_rec.rowid;
UPDATE mtl_item_revisions_tl
SET description = rev_rec.description,
last_update_date = NVL(rev_rec.last_update_date,l_sysdate),
last_updated_by = user_id,
last_update_login = login_id,
source_lang = userenv('LANG')
WHERE revision_id = rev_rec.revision_id
AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
UPDATE mtl_item_revisions_interface
SET process_flag = 3,
request_id = req_id,
PROGRAM_APPLICATION_ID = prg_appid,
PROGRAM_ID = prg_id,
PROGRAM_UPDATE_DATE = l_sysdate,
last_update_login = login_id
WHERE rowid = rev_rec.rowid
RETURNING organization_id,transaction_id INTO l_org_id,l_transaction_id;
'when OTHERS exception raised in inproit_process_item_update ' ||
'- Cursor c_lock_rev_record ' ||
SQLCODE ||
' - ' ||
SQLERRM,1,240));
update MTL_SYSTEM_ITEMS_INTERFACE
set process_flag = 7,
request_id = req_id,
PROGRAM_APPLICATION_ID = prg_appid,
PROGRAM_ID = prg_id,
PROGRAM_UPDATE_DATE = l_sysdate,
last_update_login = login_id
where process_flag = 4
and transaction_type in ('UPDATE','AUTO_CHILD')
and (set_process_id = xset_id or set_process_id = xset_id + 1000000000000);
update MTL_ITEM_REVISIONS_INTERFACE
set process_flag = 7,
request_id = nvl(request_id,req_id),
program_application_id = nvl(program_application_id,prg_appid),
PROGRAM_ID = nvl(PROGRAM_ID,prg_id),
PROGRAM_UPDATE_DATE = nvl(PROGRAM_UPDATE_DATE,l_sysdate),
LAST_UPDATE_LOGIN = nvl(LAST_UPDATE_LOGIN,login_id)
where process_flag = 4
and transaction_type = 'UPDATE'
and (set_process_id = xset_id or set_process_id = xset_id + 1000000000000);
'when OTHERS exception raised in inproit_process_item_update ' ||
SQLCODE ||
' - ' ||
SQLERRM,1,240));
END inproit_process_item_update;
update MTL_SYSTEM_ITEMS_INTERFACE
set PROCESS_FLAG = l_process_flag_3,
request_id = reqst_id,
PROGRAM_APPLICATION_ID = prog_appid,
PROGRAM_ID = prog_id,
last_update_login = login_id
where ROWID = row_id;