[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT inventory_item_id,
organization_id,
item_catalog_group_id,
template_id,
template_name,
transaction_id,
transaction_type,
rowid,
style_item_flag
FROM MTL_SYSTEM_ITEMS_INTERFACE
WHERE process_flag = 1
AND set_process_id = xset_id
AND ((organization_id = org_id) or (all_org = 1));
SELECT template_id,
context_organization_id
FROM mtl_item_templates
WHERE template_name = cp_template_name;
SELECT template_id,
context_organization_id
FROM mtl_item_templates
WHERE template_id = cp_template_id;
select item_catalog_group_id
from mtl_system_items_b
where inventory_item_id = cp_inventory_item_id
and organization_id = cp_organization_id;
SELECT TEMPLATE_ID,
CONTEXT_ORGANIZATION_ID
FROM MTL_ITEM_TEMPLATES MIT
WHERE TEMPLATE_NAME = CP_TEMPLATE_NAME
AND EXISTS (SELECT 1
FROM EGO_CAT_GRP_TEMPLATES
WHERE CATALOG_GROUP_ID IN (SELECT ITEM_CATALOG_GROUP_ID
FROM MTL_ITEM_CATALOG_GROUPS_B
START WITH ITEM_CATALOG_GROUP_ID = CP_CAT_GRP_ID
CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID)
AND TEMPLATE_ID = MIT.TEMPLATE_ID);
SELECT TEMPLATE_ID,
CONTEXT_ORGANIZATION_ID
FROM MTL_ITEM_TEMPLATES MIT
WHERE TEMPLATE_ID = CP_TEMPLATE_ID
AND EXISTS (SELECT 1
FROM EGO_CAT_GRP_TEMPLATES
WHERE CATALOG_GROUP_ID IN (SELECT ITEM_CATALOG_GROUP_ID
FROM MTL_ITEM_CATALOG_GROUPS_B
START WITH ITEM_CATALOG_GROUP_ID = CP_CAT_GRP_ID
CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID)
AND TEMPLATE_ID = MIT.TEMPLATE_ID);
SELECT attribute_name,
attribute_value
FROM mtl_item_templ_attributes
WHERE template_id = cp_template_id
AND enabled_flag = 'Y'
AND attribute_name IN
(SELECT a.attribute_name
FROM mtl_item_attributes a
WHERE NVL(a.status_control_code, 3) <> 1
AND a.control_level IN (1, 2)
AND a.attribute_group_id_gui IS NOT NULL);
SELECT
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
FROM MTL_ITEM_TEMPLATES MIT
WHERE MIT.template_id = cp_template_id;
SELECT COUNT(1)
FROM mtl_parameters mp
WHERE mp.master_organization_id = cp_orgid
AND rownum = 1;
SELECT COUNT(1)
INTO L_CAT_TEMPL_COUNT
FROM EGO_CAT_GRP_TEMPLATES
WHERE CATALOG_GROUP_ID IN (SELECT ITEM_CATALOG_GROUP_ID
FROM MTL_ITEM_CATALOG_GROUPS_B
START WITH ITEM_CATALOG_GROUP_ID = CUR.ITEM_CATALOG_GROUP_ID
CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID);
cur.transaction_type = 'UPDATE' THEN
FOR rec_get_icc_id IN get_icc_id(cur.inventory_item_id, cur.organization_id)
LOOP
l_icc_id := rec_get_icc_id.item_catalog_group_id;
SELECT COUNT(1)
INTO L_CAT_TEMPL_COUNT
FROM EGO_CAT_GRP_TEMPLATES
WHERE CATALOG_GROUP_ID IN (SELECT ITEM_CATALOG_GROUP_ID
FROM MTL_ITEM_CATALOG_GROUPS_B
START WITH ITEM_CATALOG_GROUP_ID = (SELECT NVL(ITEM_CATALOG_GROUP_ID,0)
FROM MTL_SYSTEM_ITEMS_B
WHERE INVENTORY_ITEM_ID = CUR.INVENTORY_ITEM_ID
AND ORGANIZATION_ID = CUR.ORGANIZATION_ID)
CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID);
UPDATE mtl_system_items_interface
SET process_flag = 3
WHERE rowid = cur.rowid ;
UPDATE mtl_system_items_interface
SET template_id = l_template_id
WHERE rowid = cur.rowid;
SELECT DISTINCT template_id, transaction_type BULK COLLECT INTO template_table, transaction_table
FROM mtl_system_items_interface
WHERE process_flag = 1
AND set_process_id = xset_id
AND ((organization_id = org_id) or (all_org = 1))
AND template_id > 0 ;
/* if(transaction_table(i) = 'UPDATE') then Commented for bug 6394546 as this feature should work both for 'CREATE' and 'UPDATE' modes of IOI */
if cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ACCEPTABLE_EARLY_DAYS' then AttRec.ACCEPTABLE_EARLY_DAYS := nvl(cr.ATTRIBUTE_VALUE, -999999);
elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ALLOW_ITEM_DESC_UPDATE_FLAG' then AttRec.ALLOW_ITEM_DESC_UPDATE_FLAG := nvl(cr.ATTRIBUTE_VALUE, '!');
elsif cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ALLOW_ITEM_DESC_UPDATE_FLAG' then AttRec.ALLOW_ITEM_DESC_UPDATE_FLAG := cr.ATTRIBUTE_VALUE;
UPDATE MTL_SYSTEM_ITEMS_INTERFACE
SET
DESCRIPTION = nvl(DESCRIPTION , AttRec.DESCRIPTION),
ACCEPTABLE_EARLY_DAYS = nvl(ACCEPTABLE_EARLY_DAYS , AttRec.ACCEPTABLE_EARLY_DAYS),
ACCEPTABLE_RATE_DECREASE = nvl(ACCEPTABLE_RATE_DECREASE , AttRec.ACCEPTABLE_RATE_DECREASE),
ACCEPTABLE_RATE_INCREASE = nvl(ACCEPTABLE_RATE_INCREASE , AttRec.ACCEPTABLE_RATE_INCREASE),
ACCOUNTING_RULE_ID = nvl(ACCOUNTING_RULE_ID , AttRec.ACCOUNTING_RULE_ID),
ALLOWED_UNITS_LOOKUP_CODE = nvl(ALLOWED_UNITS_LOOKUP_CODE , AttRec.ALLOWED_UNITS_LOOKUP_CODE),
ALLOW_EXPRESS_DELIVERY_FLAG = nvl(ALLOW_EXPRESS_DELIVERY_FLAG , AttRec.ALLOW_EXPRESS_DELIVERY_FLAG),
ALLOW_ITEM_DESC_UPDATE_FLAG = nvl(ALLOW_ITEM_DESC_UPDATE_FLAG , AttRec.ALLOW_ITEM_DESC_UPDATE_FLAG),
ALLOW_SUBSTITUTE_RECEIPTS_FLAG = nvl(ALLOW_SUBSTITUTE_RECEIPTS_FLAG , AttRec.ALLOW_SUBSTITUTE_RECEIPTS_FLAG),
ALLOW_UNORDERED_RECEIPTS_FLAG = nvl(ALLOW_UNORDERED_RECEIPTS_FLAG , AttRec.ALLOW_UNORDERED_RECEIPTS_FLAG),
ASSET_CATEGORY_ID = nvl(ASSET_CATEGORY_ID , AttRec.ASSET_CATEGORY_ID),
ATP_COMPONENTS_FLAG = nvl(ATP_COMPONENTS_FLAG , AttRec.ATP_COMPONENTS_FLAG),
ATP_FLAG = nvl(ATP_FLAG , AttRec.ATP_FLAG),
ATP_RULE_ID = nvl(ATP_RULE_ID , AttRec.ATP_RULE_ID),
AUTO_LOT_ALPHA_PREFIX = nvl(AUTO_LOT_ALPHA_PREFIX , AttRec.AUTO_LOT_ALPHA_PREFIX),
AUTO_REDUCE_MPS = nvl(AUTO_REDUCE_MPS , AttRec.AUTO_REDUCE_MPS),
AUTO_SERIAL_ALPHA_PREFIX = nvl(AUTO_SERIAL_ALPHA_PREFIX , AttRec.AUTO_SERIAL_ALPHA_PREFIX),
BOM_ENABLED_FLAG = nvl(BOM_ENABLED_FLAG , AttRec.BOM_ENABLED_FLAG),
BOM_ITEM_TYPE = nvl(BOM_ITEM_TYPE , AttRec.BOM_ITEM_TYPE),
BUILD_IN_WIP_FLAG = nvl(BUILD_IN_WIP_FLAG , AttRec.BUILD_IN_WIP_FLAG),
BUYER_ID = nvl(BUYER_ID , AttRec.BUYER_ID),
CARRYING_COST = nvl(CARRYING_COST , AttRec.CARRYING_COST),
COLLATERAL_FLAG = nvl(COLLATERAL_FLAG , AttRec.COLLATERAL_FLAG),
COSTING_ENABLED_FLAG = nvl(COSTING_ENABLED_FLAG , AttRec.COSTING_ENABLED_FLAG),
COVERAGE_SCHEDULE_ID = nvl(COVERAGE_SCHEDULE_ID , AttRec.COVERAGE_SCHEDULE_ID),
CUMULATIVE_TOTAL_LEAD_TIME = nvl(CUMULATIVE_TOTAL_LEAD_TIME , AttRec.CUMULATIVE_TOTAL_LEAD_TIME),
CUM_MANUFACTURING_LEAD_TIME = nvl(CUM_MANUFACTURING_LEAD_TIME , AttRec.CUM_MANUFACTURING_LEAD_TIME),
CUSTOMER_ORDER_ENABLED_FLAG = nvl(CUSTOMER_ORDER_ENABLED_FLAG , AttRec.CUSTOMER_ORDER_ENABLED_FLAG),
CUSTOMER_ORDER_FLAG = nvl(CUSTOMER_ORDER_FLAG , AttRec.CUSTOMER_ORDER_FLAG),
CYCLE_COUNT_ENABLED_FLAG = nvl(CYCLE_COUNT_ENABLED_FLAG , AttRec.CYCLE_COUNT_ENABLED_FLAG),
DAYS_EARLY_RECEIPT_ALLOWED = nvl(DAYS_EARLY_RECEIPT_ALLOWED , AttRec.DAYS_EARLY_RECEIPT_ALLOWED),
DAYS_LATE_RECEIPT_ALLOWED = nvl(DAYS_LATE_RECEIPT_ALLOWED , AttRec.DAYS_LATE_RECEIPT_ALLOWED),
DEFAULT_INCLUDE_IN_ROLLUP_FLAG = nvl(DEFAULT_INCLUDE_IN_ROLLUP_FLAG , AttRec.DEFAULT_INCLUDE_IN_ROLLUP_FLAG),
DEFAULT_SHIPPING_ORG = nvl(DEFAULT_SHIPPING_ORG , AttRec.DEFAULT_SHIPPING_ORG),
DEMAND_TIME_FENCE_CODE = nvl(DEMAND_TIME_FENCE_CODE , AttRec.DEMAND_TIME_FENCE_CODE),
DEMAND_TIME_FENCE_DAYS = nvl(DEMAND_TIME_FENCE_DAYS , AttRec.DEMAND_TIME_FENCE_DAYS),
END_ASSEMBLY_PEGGING_FLAG = nvl(END_ASSEMBLY_PEGGING_FLAG , AttRec.END_ASSEMBLY_PEGGING_FLAG),
ENFORCE_SHIP_TO_LOCATION_CODE = nvl(ENFORCE_SHIP_TO_LOCATION_CODE , AttRec.ENFORCE_SHIP_TO_LOCATION_CODE),
EXPENSE_BILLABLE_FLAG = nvl(EXPENSE_BILLABLE_FLAG , AttRec.EXPENSE_BILLABLE_FLAG),
FIXED_DAYS_SUPPLY = nvl(FIXED_DAYS_SUPPLY , AttRec.FIXED_DAYS_SUPPLY),
FIXED_LEAD_TIME = nvl(FIXED_LEAD_TIME , AttRec.FIXED_LEAD_TIME),
FIXED_LOT_MULTIPLIER = nvl(FIXED_LOT_MULTIPLIER , AttRec.FIXED_LOT_MULTIPLIER),
FIXED_ORDER_QUANTITY = nvl(FIXED_ORDER_QUANTITY , AttRec.FIXED_ORDER_QUANTITY),
FULL_LEAD_TIME = nvl(FULL_LEAD_TIME , AttRec.FULL_LEAD_TIME),
HAZARD_CLASS_ID = nvl(HAZARD_CLASS_ID , AttRec.HAZARD_CLASS_ID),
INSPECTION_REQUIRED_FLAG = nvl(INSPECTION_REQUIRED_FLAG , AttRec.INSPECTION_REQUIRED_FLAG),
INTERNAL_ORDER_ENABLED_FLAG = nvl(INTERNAL_ORDER_ENABLED_FLAG , AttRec.INTERNAL_ORDER_ENABLED_FLAG),
INTERNAL_ORDER_FLAG = nvl(INTERNAL_ORDER_FLAG , AttRec.INTERNAL_ORDER_FLAG),
INVENTORY_ASSET_FLAG = nvl(INVENTORY_ASSET_FLAG , AttRec.INVENTORY_ASSET_FLAG),
INVENTORY_ITEM_FLAG = nvl(INVENTORY_ITEM_FLAG , AttRec.INVENTORY_ITEM_FLAG),
INVENTORY_ITEM_STATUS_CODE = nvl(INVENTORY_ITEM_STATUS_CODE , AttRec.INVENTORY_ITEM_STATUS_CODE),
INVENTORY_PLANNING_CODE = nvl(INVENTORY_PLANNING_CODE , AttRec.INVENTORY_PLANNING_CODE),
INVOICEABLE_ITEM_FLAG = nvl(INVOICEABLE_ITEM_FLAG , AttRec.INVOICEABLE_ITEM_FLAG),
INVOICE_CLOSE_TOLERANCE = nvl(INVOICE_CLOSE_TOLERANCE , AttRec.INVOICE_CLOSE_TOLERANCE),
INVOICE_ENABLED_FLAG = nvl(INVOICE_ENABLED_FLAG , AttRec.INVOICE_ENABLED_FLAG),
INVOICING_RULE_ID = nvl(INVOICING_RULE_ID , AttRec.INVOICING_RULE_ID),
ITEM_TYPE = nvl(ITEM_TYPE , AttRec.ITEM_TYPE),
LEAD_TIME_LOT_SIZE = nvl(LEAD_TIME_LOT_SIZE , AttRec.LEAD_TIME_LOT_SIZE),
LIST_PRICE_PER_UNIT = nvl(LIST_PRICE_PER_UNIT , AttRec.LIST_PRICE_PER_UNIT),
LOCATION_CONTROL_CODE = nvl(LOCATION_CONTROL_CODE , AttRec.LOCATION_CONTROL_CODE),
LOT_CONTROL_CODE = nvl(LOT_CONTROL_CODE , AttRec.LOT_CONTROL_CODE),
MARKET_PRICE = nvl(MARKET_PRICE , AttRec.MARKET_PRICE),
MATERIAL_BILLABLE_FLAG = nvl(MATERIAL_BILLABLE_FLAG , AttRec.MATERIAL_BILLABLE_FLAG),
MAXIMUM_ORDER_QUANTITY = nvl(MAXIMUM_ORDER_QUANTITY , AttRec.MAXIMUM_ORDER_QUANTITY),
MAX_MINMAX_QUANTITY = nvl(MAX_MINMAX_QUANTITY , AttRec.MAX_MINMAX_QUANTITY),
MAX_WARRANTY_AMOUNT = nvl(MAX_WARRANTY_AMOUNT , AttRec.MAX_WARRANTY_AMOUNT),
MINIMUM_ORDER_QUANTITY = nvl(MINIMUM_ORDER_QUANTITY , AttRec.MINIMUM_ORDER_QUANTITY),
MIN_MINMAX_QUANTITY = nvl(MIN_MINMAX_QUANTITY , AttRec.MIN_MINMAX_QUANTITY),
MRP_CALCULATE_ATP_FLAG = nvl(MRP_CALCULATE_ATP_FLAG , AttRec.MRP_CALCULATE_ATP_FLAG),
MRP_PLANNING_CODE = nvl(MRP_PLANNING_CODE , AttRec.MRP_PLANNING_CODE),
MRP_SAFETY_STOCK_CODE = nvl(MRP_SAFETY_STOCK_CODE , AttRec.MRP_SAFETY_STOCK_CODE),
MRP_SAFETY_STOCK_PERCENT = nvl(MRP_SAFETY_STOCK_PERCENT , AttRec.MRP_SAFETY_STOCK_PERCENT),
MTL_TRANSACTIONS_ENABLED_FLAG = nvl(MTL_TRANSACTIONS_ENABLED_FLAG , AttRec.MTL_TRANSACTIONS_ENABLED_FLAG),
MUST_USE_APPROVED_VENDOR_FLAG = nvl(MUST_USE_APPROVED_VENDOR_FLAG , AttRec.MUST_USE_APPROVED_VENDOR_FLAG),
NEGATIVE_MEASUREMENT_ERROR = nvl(NEGATIVE_MEASUREMENT_ERROR , AttRec.NEGATIVE_MEASUREMENT_ERROR),
NEW_REVISION_CODE = nvl(NEW_REVISION_CODE , AttRec.NEW_REVISION_CODE),
ORDER_COST = nvl(ORDER_COST , AttRec.ORDER_COST),
OUTSIDE_OPERATION_FLAG = nvl(OUTSIDE_OPERATION_FLAG , AttRec.OUTSIDE_OPERATION_FLAG),
OUTSIDE_OPERATION_UOM_TYPE = nvl(OUTSIDE_OPERATION_UOM_TYPE , AttRec.OUTSIDE_OPERATION_UOM_TYPE),
OVERRUN_PERCENTAGE = nvl(OVERRUN_PERCENTAGE , AttRec.OVERRUN_PERCENTAGE),
PAYMENT_TERMS_ID = nvl(PAYMENT_TERMS_ID , AttRec.PAYMENT_TERMS_ID),
PICKING_RULE_ID = nvl(PICKING_RULE_ID , AttRec.PICKING_RULE_ID),
PICK_COMPONENTS_FLAG = nvl(PICK_COMPONENTS_FLAG , AttRec.PICK_COMPONENTS_FLAG),
PLANNING_MAKE_BUY_CODE = nvl(PLANNING_MAKE_BUY_CODE , AttRec.PLANNING_MAKE_BUY_CODE),
PLANNING_TIME_FENCE_CODE = nvl(PLANNING_TIME_FENCE_CODE , AttRec.PLANNING_TIME_FENCE_CODE),
PLANNING_TIME_FENCE_DAYS = nvl(PLANNING_TIME_FENCE_DAYS , AttRec.PLANNING_TIME_FENCE_DAYS),
POSITIVE_MEASUREMENT_ERROR = nvl(POSITIVE_MEASUREMENT_ERROR , AttRec.POSITIVE_MEASUREMENT_ERROR),
POSTPROCESSING_LEAD_TIME = nvl(POSTPROCESSING_LEAD_TIME , AttRec.POSTPROCESSING_LEAD_TIME),
PREPROCESSING_LEAD_TIME = nvl(PREPROCESSING_LEAD_TIME , AttRec.PREPROCESSING_LEAD_TIME),
PREVENTIVE_MAINTENANCE_FLAG = nvl(PREVENTIVE_MAINTENANCE_FLAG , AttRec.PREVENTIVE_MAINTENANCE_FLAG),
PRICE_TOLERANCE_PERCENT = nvl(PRICE_TOLERANCE_PERCENT , AttRec.PRICE_TOLERANCE_PERCENT),
PRIMARY_SPECIALIST_ID = nvl(PRIMARY_SPECIALIST_ID , AttRec.PRIMARY_SPECIALIST_ID),
PRORATE_SERVICE_FLAG = nvl(PRORATE_SERVICE_FLAG , AttRec.PRORATE_SERVICE_FLAG),
PURCHASING_ENABLED_FLAG = nvl(PURCHASING_ENABLED_FLAG , AttRec.PURCHASING_ENABLED_FLAG),
PURCHASING_ITEM_FLAG = nvl(PURCHASING_ITEM_FLAG , AttRec.PURCHASING_ITEM_FLAG),
QTY_RCV_EXCEPTION_CODE = nvl(QTY_RCV_EXCEPTION_CODE , AttRec.QTY_RCV_EXCEPTION_CODE),
QTY_RCV_TOLERANCE = nvl(QTY_RCV_TOLERANCE , AttRec.QTY_RCV_TOLERANCE),
RECEIPT_DAYS_EXCEPTION_CODE = nvl(RECEIPT_DAYS_EXCEPTION_CODE , AttRec.RECEIPT_DAYS_EXCEPTION_CODE),
RECEIPT_REQUIRED_FLAG = nvl(RECEIPT_REQUIRED_FLAG , AttRec.RECEIPT_REQUIRED_FLAG),
RECEIVE_CLOSE_TOLERANCE = nvl(RECEIVE_CLOSE_TOLERANCE , AttRec.RECEIVE_CLOSE_TOLERANCE),
RECEIVING_ROUTING_ID = nvl(RECEIVING_ROUTING_ID , AttRec.RECEIVING_ROUTING_ID),
REPETITIVE_PLANNING_FLAG = nvl(REPETITIVE_PLANNING_FLAG , AttRec.REPETITIVE_PLANNING_FLAG),
REPLENISH_TO_ORDER_FLAG = nvl(REPLENISH_TO_ORDER_FLAG , AttRec.REPLENISH_TO_ORDER_FLAG),
RESERVABLE_TYPE = nvl(RESERVABLE_TYPE , AttRec.RESERVABLE_TYPE),
RESPONSE_TIME_PERIOD_CODE = nvl(RESPONSE_TIME_PERIOD_CODE , AttRec.RESPONSE_TIME_PERIOD_CODE),
RESPONSE_TIME_VALUE = nvl(RESPONSE_TIME_VALUE , AttRec.RESPONSE_TIME_VALUE),
RESTRICT_LOCATORS_CODE = nvl(RESTRICT_LOCATORS_CODE , AttRec.RESTRICT_LOCATORS_CODE),
RESTRICT_SUBINVENTORIES_CODE = nvl(RESTRICT_SUBINVENTORIES_CODE , AttRec.RESTRICT_SUBINVENTORIES_CODE),
RETURNABLE_FLAG = nvl(RETURNABLE_FLAG , AttRec.RETURNABLE_FLAG),
RETURN_INSPECTION_REQUIREMENT = nvl(RETURN_INSPECTION_REQUIREMENT , AttRec.RETURN_INSPECTION_REQUIREMENT),
REVISION_QTY_CONTROL_CODE = nvl(REVISION_QTY_CONTROL_CODE , AttRec.REVISION_QTY_CONTROL_CODE),
RFQ_REQUIRED_FLAG = nvl(RFQ_REQUIRED_FLAG , AttRec.RFQ_REQUIRED_FLAG),
ROUNDING_CONTROL_TYPE = nvl(ROUNDING_CONTROL_TYPE , AttRec.ROUNDING_CONTROL_TYPE),
ROUNDING_FACTOR = nvl(ROUNDING_FACTOR , AttRec.ROUNDING_FACTOR),
SAFETY_STOCK_BUCKET_DAYS = nvl(SAFETY_STOCK_BUCKET_DAYS , AttRec.SAFETY_STOCK_BUCKET_DAYS),
SECONDARY_SPECIALIST_ID = nvl(SECONDARY_SPECIALIST_ID , AttRec.SECONDARY_SPECIALIST_ID),
SERIAL_NUMBER_CONTROL_CODE = nvl(SERIAL_NUMBER_CONTROL_CODE , AttRec.SERIAL_NUMBER_CONTROL_CODE),
SERVICEABLE_COMPONENT_FLAG = nvl(SERVICEABLE_COMPONENT_FLAG , AttRec.SERVICEABLE_COMPONENT_FLAG),
SERVICEABLE_ITEM_CLASS_ID = nvl(SERVICEABLE_ITEM_CLASS_ID , AttRec.SERVICEABLE_ITEM_CLASS_ID),
SERVICEABLE_PRODUCT_FLAG = nvl(SERVICEABLE_PRODUCT_FLAG , AttRec.SERVICEABLE_PRODUCT_FLAG),
SERVICE_DURATION = nvl(SERVICE_DURATION , AttRec.SERVICE_DURATION),
SERVICE_DURATION_PERIOD_CODE = nvl(SERVICE_DURATION_PERIOD_CODE , AttRec.SERVICE_DURATION_PERIOD_CODE),
SERVICE_STARTING_DELAY = nvl(SERVICE_STARTING_DELAY , AttRec.SERVICE_STARTING_DELAY),
SHELF_LIFE_CODE = nvl(SHELF_LIFE_CODE , AttRec.SHELF_LIFE_CODE),
SHELF_LIFE_DAYS = nvl(SHELF_LIFE_DAYS , AttRec.SHELF_LIFE_DAYS),
SHIPPABLE_ITEM_FLAG = nvl(SHIPPABLE_ITEM_FLAG , AttRec.SHIPPABLE_ITEM_FLAG),
SHIP_MODEL_COMPLETE_FLAG = nvl(SHIP_MODEL_COMPLETE_FLAG , AttRec.SHIP_MODEL_COMPLETE_FLAG),
SHRINKAGE_RATE = nvl(SHRINKAGE_RATE , AttRec.SHRINKAGE_RATE),
SOURCE_ORGANIZATION_ID = nvl(SOURCE_ORGANIZATION_ID , AttRec.SOURCE_ORGANIZATION_ID),
SOURCE_SUBINVENTORY = nvl(SOURCE_SUBINVENTORY , AttRec.SOURCE_SUBINVENTORY),
SOURCE_TYPE = nvl(SOURCE_TYPE , AttRec.SOURCE_TYPE),
SO_TRANSACTIONS_FLAG = nvl(SO_TRANSACTIONS_FLAG , AttRec.SO_TRANSACTIONS_FLAG),
START_AUTO_LOT_NUMBER = nvl(START_AUTO_LOT_NUMBER , AttRec.START_AUTO_LOT_NUMBER),
START_AUTO_SERIAL_NUMBER = nvl(START_AUTO_SERIAL_NUMBER , AttRec.START_AUTO_SERIAL_NUMBER),
STD_LOT_SIZE = nvl(STD_LOT_SIZE , AttRec.STD_LOT_SIZE),
STOCK_ENABLED_FLAG = nvl(STOCK_ENABLED_FLAG , AttRec.STOCK_ENABLED_FLAG),
TAXABLE_FLAG = nvl(TAXABLE_FLAG , AttRec.TAXABLE_FLAG),
PURCHASING_TAX_CODE = nvl(PURCHASING_TAX_CODE , AttRec.PURCHASING_TAX_CODE),
TAX_CODE = nvl(TAX_CODE , AttRec.TAX_CODE),
TIME_BILLABLE_FLAG = nvl(TIME_BILLABLE_FLAG , AttRec.TIME_BILLABLE_FLAG),
UNIT_OF_ISSUE = nvl(UNIT_OF_ISSUE , AttRec.UNIT_OF_ISSUE),
UNIT_VOLUME = nvl(UNIT_VOLUME , AttRec.UNIT_VOLUME),
UNIT_WEIGHT = nvl(UNIT_WEIGHT , AttRec.UNIT_WEIGHT),
UN_NUMBER_ID = nvl(UN_NUMBER_ID , AttRec.UN_NUMBER_ID),
VARIABLE_LEAD_TIME = nvl(VARIABLE_LEAD_TIME , AttRec.VARIABLE_LEAD_TIME),
VOLUME_UOM_CODE = nvl(VOLUME_UOM_CODE , AttRec.VOLUME_UOM_CODE),
WARRANTY_VENDOR_ID = nvl(WARRANTY_VENDOR_ID , AttRec.WARRANTY_VENDOR_ID),
WEIGHT_UOM_CODE = nvl(WEIGHT_UOM_CODE , AttRec.WEIGHT_UOM_CODE),
WIP_SUPPLY_TYPE = nvl(WIP_SUPPLY_TYPE , AttRec.WIP_SUPPLY_TYPE),
ATO_FORECAST_CONTROL = nvl(ATO_FORECAST_CONTROL , AttRec.ATO_FORECAST_CONTROL),
RELEASE_TIME_FENCE_CODE = nvl(RELEASE_TIME_FENCE_CODE , AttRec.RELEASE_TIME_FENCE_CODE),
RELEASE_TIME_FENCE_DAYS = nvl(RELEASE_TIME_FENCE_DAYS , AttRec.RELEASE_TIME_FENCE_DAYS),
CONTAINER_ITEM_FLAG = nvl(CONTAINER_ITEM_FLAG , AttRec.CONTAINER_ITEM_FLAG),
CONTAINER_TYPE_CODE = nvl(CONTAINER_TYPE_CODE , AttRec.CONTAINER_TYPE_CODE),
INTERNAL_VOLUME = nvl(INTERNAL_VOLUME , AttRec.INTERNAL_VOLUME),
MAXIMUM_LOAD_WEIGHT = nvl(MAXIMUM_LOAD_WEIGHT , AttRec.MAXIMUM_LOAD_WEIGHT),
MINIMUM_FILL_PERCENT = nvl(MINIMUM_FILL_PERCENT , AttRec.MINIMUM_FILL_PERCENT),
VEHICLE_ITEM_FLAG = nvl(VEHICLE_ITEM_FLAG , AttRec.VEHICLE_ITEM_FLAG),
CHECK_SHORTAGES_FLAG = nvl(CHECK_SHORTAGES_FLAG,AttRec.CHECK_SHORTAGES_FLAG),
EFFECTIVITY_CONTROL = nvl(EFFECTIVITY_CONTROL, AttRec.EFFECTIVITY_CONTROL),
OVERCOMPLETION_TOLERANCE_TYPE = nvl(OVERCOMPLETION_TOLERANCE_TYPE , AttRec.OVERCOMPLETION_TOLERANCE_TYPE ),
OVERCOMPLETION_TOLERANCE_VALUE = nvl(OVERCOMPLETION_TOLERANCE_VALUE , AttRec.OVERCOMPLETION_TOLERANCE_VALUE ),
OVER_SHIPMENT_TOLERANCE = nvl(OVER_SHIPMENT_TOLERANCE , AttRec.OVER_SHIPMENT_TOLERANCE ),
UNDER_SHIPMENT_TOLERANCE = nvl(UNDER_SHIPMENT_TOLERANCE , AttRec.UNDER_SHIPMENT_TOLERANCE ),
OVER_RETURN_TOLERANCE = nvl(OVER_RETURN_TOLERANCE , AttRec.OVER_RETURN_TOLERANCE ),
UNDER_RETURN_TOLERANCE = nvl(UNDER_RETURN_TOLERANCE , AttRec.UNDER_RETURN_TOLERANCE ),
EQUIPMENT_TYPE = nvl(EQUIPMENT_TYPE , AttRec.EQUIPMENT_TYPE ),
RECOVERED_PART_DISP_CODE = nvl(RECOVERED_PART_DISP_CODE , AttRec.RECOVERED_PART_DISP_CODE ),
DEFECT_TRACKING_ON_FLAG = nvl(DEFECT_TRACKING_ON_FLAG , AttRec.DEFECT_TRACKING_ON_FLAG ),
EVENT_FLAG = nvl(EVENT_FLAG , AttRec.EVENT_FLAG ),
ELECTRONIC_FLAG = nvl(ELECTRONIC_FLAG , AttRec.ELECTRONIC_FLAG ),
DOWNLOADABLE_FLAG = nvl(DOWNLOADABLE_FLAG , AttRec.DOWNLOADABLE_FLAG ),
VOL_DISCOUNT_EXEMPT_FLAG = nvl(VOL_DISCOUNT_EXEMPT_FLAG , AttRec.VOL_DISCOUNT_EXEMPT_FLAG ),
COUPON_EXEMPT_FLAG = nvl(COUPON_EXEMPT_FLAG , AttRec.COUPON_EXEMPT_FLAG ),
COMMS_NL_TRACKABLE_FLAG = nvl(COMMS_NL_TRACKABLE_FLAG , AttRec.COMMS_NL_TRACKABLE_FLAG ),
ASSET_CREATION_CODE = nvl(ASSET_CREATION_CODE , AttRec.ASSET_CREATION_CODE ),
COMMS_ACTIVATION_REQD_FLAG = nvl(COMMS_ACTIVATION_REQD_FLAG , AttRec.COMMS_ACTIVATION_REQD_FLAG ),
ORDERABLE_ON_WEB_FLAG = nvl(ORDERABLE_ON_WEB_FLAG , AttRec.ORDERABLE_ON_WEB_FLAG ),
BACK_ORDERABLE_FLAG = nvl(BACK_ORDERABLE_FLAG , AttRec.BACK_ORDERABLE_FLAG ),
WEB_STATUS = nvl(WEB_STATUS, AttRec.WEB_STATUS ),
INDIVISIBLE_FLAG = nvl(INDIVISIBLE_FLAG, AttRec.INDIVISIBLE_FLAG ),
DIMENSION_UOM_CODE = nvl(DIMENSION_UOM_CODE , AttRec.DIMENSION_UOM_CODE ),
UNIT_LENGTH = nvl(UNIT_LENGTH , AttRec.UNIT_LENGTH ),
UNIT_WIDTH = nvl(UNIT_WIDTH , AttRec.UNIT_WIDTH ),
UNIT_HEIGHT = nvl(UNIT_HEIGHT , AttRec.UNIT_HEIGHT ),
BULK_PICKED_FLAG = nvl(BULK_PICKED_FLAG , AttRec.BULK_PICKED_FLAG ),
LOT_STATUS_ENABLED = nvl(LOT_STATUS_ENABLED , AttRec.LOT_STATUS_ENABLED ),
-- bug 9004676
-- DEFAULT_LOT_STATUS_ID = nvl(DEFAULT_LOT_STATUS_ID , AttRec.DEFAULT_LOT_STATUS_ID ),
DEFAULT_LOT_STATUS_ID = nvl(DEFAULT_LOT_STATUS_ID, DECODE(NVL(LOT_STATUS_ENABLED,AttRec.LOT_STATUS_ENABLED),NULL,NULL,'N',NULL,AttRec.DEFAULT_LOT_STATUS_ID)),
SERIAL_STATUS_ENABLED = nvl(SERIAL_STATUS_ENABLED , AttRec.SERIAL_STATUS_ENABLED ),
DEFAULT_SERIAL_STATUS_ID = nvl(DEFAULT_SERIAL_STATUS_ID , AttRec.DEFAULT_SERIAL_STATUS_ID ),
LOT_SPLIT_ENABLED = nvl(LOT_SPLIT_ENABLED , AttRec.LOT_SPLIT_ENABLED ),
LOT_MERGE_ENABLED = nvl(LOT_MERGE_ENABLED , AttRec.LOT_MERGE_ENABLED ),
INVENTORY_CARRY_PENALTY = nvl(INVENTORY_CARRY_PENALTY , AttRec.INVENTORY_CARRY_PENALTY ),
OPERATION_SLACK_PENALTY = nvl(OPERATION_SLACK_PENALTY , AttRec.OPERATION_SLACK_PENALTY ),
FINANCING_ALLOWED_FLAG = nvl(FINANCING_ALLOWED_FLAG , AttRec.FINANCING_ALLOWED_FLAG ),
-- Primary Unit of Measure is now maintained via the PRIMARY_UOM_CODE column.
PRIMARY_UOM_CODE = decode(PRIMARY_UOM_CODE, NULL,decode(PRIMARY_UNIT_OF_MEASURE,NULL,AttRec.PRIMARY_UOM_CODE ),PRIMARY_UOM_CODE),
EAM_ITEM_TYPE = nvl(EAM_ITEM_TYPE, AttRec.EAM_ITEM_TYPE ),
EAM_ACTIVITY_TYPE_CODE = nvl(EAM_ACTIVITY_TYPE_CODE, AttRec.EAM_ACTIVITY_TYPE_CODE ),
EAM_ACTIVITY_CAUSE_CODE = nvl(EAM_ACTIVITY_CAUSE_CODE, AttRec.EAM_ACTIVITY_CAUSE_CODE ),
EAM_ACT_NOTIFICATION_FLAG = nvl(EAM_ACT_NOTIFICATION_FLAG, AttRec.EAM_ACT_NOTIFICATION_FLAG ),
EAM_ACT_SHUTDOWN_STATUS = nvl(EAM_ACT_SHUTDOWN_STATUS, AttRec.EAM_ACT_SHUTDOWN_STATUS ),
SECONDARY_UOM_CODE = nvl(SECONDARY_UOM_CODE, AttRec.SECONDARY_UOM_CODE ),
DUAL_UOM_DEVIATION_HIGH = nvl(DUAL_UOM_DEVIATION_HIGH, AttRec.DUAL_UOM_DEVIATION_HIGH ),
DUAL_UOM_DEVIATION_LOW = nvl(DUAL_UOM_DEVIATION_LOW, AttRec.DUAL_UOM_DEVIATION_LOW ),
CONTRACT_ITEM_TYPE_CODE = nvl(CONTRACT_ITEM_TYPE_CODE, AttRec.CONTRACT_ITEM_TYPE_CODE ),
SERV_REQ_ENABLED_CODE = nvl(SERV_REQ_ENABLED_CODE, AttRec.SERV_REQ_ENABLED_CODE ),
SERV_BILLING_ENABLED_FLAG = nvl(SERV_BILLING_ENABLED_FLAG, AttRec.SERV_BILLING_ENABLED_FLAG ),
PLANNED_INV_POINT_FLAG = nvl(PLANNED_INV_POINT_FLAG, AttRec.PLANNED_INV_POINT_FLAG ),
LOT_TRANSLATE_ENABLED = nvl(LOT_TRANSLATE_ENABLED, AttRec.LOT_TRANSLATE_ENABLED ),
DEFAULT_SO_SOURCE_TYPE = nvl(DEFAULT_SO_SOURCE_TYPE, AttRec.DEFAULT_SO_SOURCE_TYPE ),
CREATE_SUPPLY_FLAG = nvl(CREATE_SUPPLY_FLAG, AttRec.CREATE_SUPPLY_FLAG ),
SUBSTITUTION_WINDOW_CODE = nvl(SUBSTITUTION_WINDOW_CODE, AttRec.SUBSTITUTION_WINDOW_CODE ),
SUBSTITUTION_WINDOW_DAYS = nvl(SUBSTITUTION_WINDOW_DAYS, AttRec.SUBSTITUTION_WINDOW_DAYS ),
--Added as part of 11.5.9
LOT_SUBSTITUTION_ENABLED = nvl(LOT_SUBSTITUTION_ENABLED, AttRec.LOT_SUBSTITUTION_ENABLED ),
MINIMUM_LICENSE_QUANTITY = nvl(MINIMUM_LICENSE_QUANTITY, AttRec.MINIMUM_LICENSE_QUANTITY ),
EAM_ACTIVITY_SOURCE_CODE = nvl(EAM_ACTIVITY_SOURCE_CODE, AttRec.EAM_ACTIVITY_SOURCE_CODE ),
IB_ITEM_INSTANCE_CLASS = nvl(IB_ITEM_INSTANCE_CLASS, AttRec.IB_ITEM_INSTANCE_CLASS ),
CONFIG_MODEL_TYPE = nvl(CONFIG_MODEL_TYPE, AttRec.CONFIG_MODEL_TYPE ),
--Added as part of 11.5.10
TRACKING_QUANTITY_IND = nvl(TRACKING_QUANTITY_IND , AttRec.TRACKING_QUANTITY_IND ),
ONT_PRICING_QTY_SOURCE = nvl(ONT_PRICING_QTY_SOURCE, AttRec.ONT_PRICING_QTY_SOURCE ),
SECONDARY_DEFAULT_IND = nvl(SECONDARY_DEFAULT_IND , AttRec.SECONDARY_DEFAULT_IND ),
AUTO_CREATED_CONFIG_FLAG = nvl(AUTO_CREATED_CONFIG_FLAG, AttRec.AUTO_CREATED_CONFIG_FLAG),
CONFIG_ORGS = nvl(CONFIG_ORGS, AttRec.CONFIG_ORGS),
CONFIG_MATCH = nvl(CONFIG_MATCH, AttRec.CONFIG_MATCH),
VMI_MINIMUM_UNITS = nvl(VMI_MINIMUM_UNITS, AttRec.VMI_MINIMUM_UNITS),
VMI_MINIMUM_DAYS = nvl(VMI_MINIMUM_DAYS, AttRec.VMI_MINIMUM_DAYS),
VMI_MAXIMUM_UNITS = nvl(VMI_MAXIMUM_UNITS, AttRec.VMI_MAXIMUM_UNITS),
VMI_MAXIMUM_DAYS = nvl(VMI_MAXIMUM_DAYS, AttRec.VMI_MAXIMUM_DAYS),
VMI_FIXED_ORDER_QUANTITY = nvl(VMI_FIXED_ORDER_QUANTITY, AttRec.VMI_FIXED_ORDER_QUANTITY),
SO_AUTHORIZATION_FLAG = nvl(SO_AUTHORIZATION_FLAG, AttRec.SO_AUTHORIZATION_FLAG),
CONSIGNED_FLAG = nvl(CONSIGNED_FLAG, AttRec.CONSIGNED_FLAG),
ASN_AUTOEXPIRE_FLAG = nvl(ASN_AUTOEXPIRE_FLAG, AttRec.ASN_AUTOEXPIRE_FLAG),
VMI_FORECAST_TYPE = nvl(VMI_FORECAST_TYPE, AttRec.VMI_FORECAST_TYPE),
FORECAST_HORIZON = nvl(FORECAST_HORIZON, AttRec.FORECAST_HORIZON),
EXCLUDE_FROM_BUDGET_FLAG = nvl(EXCLUDE_FROM_BUDGET_FLAG, AttRec.EXCLUDE_FROM_BUDGET_FLAG),
DAYS_TGT_INV_SUPPLY = nvl(DAYS_TGT_INV_SUPPLY, AttRec.DAYS_TGT_INV_SUPPLY),
DAYS_TGT_INV_WINDOW = nvl(DAYS_TGT_INV_WINDOW, AttRec.DAYS_TGT_INV_WINDOW),
DAYS_MAX_INV_SUPPLY = nvl(DAYS_MAX_INV_SUPPLY, AttRec.DAYS_MAX_INV_SUPPLY),
DAYS_MAX_INV_WINDOW = nvl(DAYS_MAX_INV_WINDOW, AttRec.DAYS_MAX_INV_WINDOW),
DRP_PLANNED_FLAG = nvl(DRP_PLANNED_FLAG, AttRec.DRP_PLANNED_FLAG),
CRITICAL_COMPONENT_FLAG = nvl(CRITICAL_COMPONENT_FLAG, AttRec.CRITICAL_COMPONENT_FLAG),
CONTINOUS_TRANSFER = nvl(CONTINOUS_TRANSFER, AttRec.CONTINOUS_TRANSFER),
CONVERGENCE = nvl(CONVERGENCE, AttRec.CONVERGENCE),
DIVERGENCE = nvl(DIVERGENCE, AttRec.DIVERGENCE) ,
--Start Bug 3713912
LOT_DIVISIBLE_FLAG = nvl(LOT_DIVISIBLE_FLAG,AttRec.LOT_DIVISIBLE_FLAG),
GRADE_CONTROL_FLAG = nvl(GRADE_CONTROL_FLAG,AttRec.GRADE_CONTROL_FLAG),
DEFAULT_GRADE = nvl(DEFAULT_GRADE,AttRec.DEFAULT_GRADE),
CHILD_LOT_FLAG = nvl(CHILD_LOT_FLAG,AttRec.CHILD_LOT_FLAG),
PARENT_CHILD_GENERATION_FLAG = nvl(PARENT_CHILD_GENERATION_FLAG,AttRec.PARENT_CHILD_GENERATION_FLAG),
CHILD_LOT_PREFIX = nvl(CHILD_LOT_PREFIX,AttRec.CHILD_LOT_PREFIX),
CHILD_LOT_STARTING_NUMBER = nvl(CHILD_LOT_STARTING_NUMBER,AttRec.CHILD_LOT_STARTING_NUMBER),
CHILD_LOT_VALIDATION_FLAG = nvl(CHILD_LOT_VALIDATION_FLAG,AttRec.CHILD_LOT_VALIDATION_FLAG),
COPY_LOT_ATTRIBUTE_FLAG = nvl(COPY_LOT_ATTRIBUTE_FLAG,AttRec.COPY_LOT_ATTRIBUTE_FLAG),
RECIPE_ENABLED_FLAG = nvl(RECIPE_ENABLED_FLAG,AttRec.RECIPE_ENABLED_FLAG),
PROCESS_QUALITY_ENABLED_FLAG = nvl(PROCESS_QUALITY_ENABLED_FLAG,AttRec.PROCESS_QUALITY_ENABLED_FLAG),
PROCESS_EXECUTION_ENABLED_FLAG = nvl(PROCESS_EXECUTION_ENABLED_FLAG,AttRec.PROCESS_EXECUTION_ENABLED_FLAG),
PROCESS_COSTING_ENABLED_FLAG = nvl(PROCESS_COSTING_ENABLED_FLAG,AttRec.PROCESS_COSTING_ENABLED_FLAG),
HAZARDOUS_MATERIAL_FLAG = nvl(HAZARDOUS_MATERIAL_FLAG,AttRec.HAZARDOUS_MATERIAL_FLAG),
CAS_NUMBER = nvl(CAS_NUMBER,AttRec.CAS_NUMBER),
RETEST_INTERVAL = nvl(RETEST_INTERVAL,AttRec.RETEST_INTERVAL),
EXPIRATION_ACTION_INTERVAL = nvl(EXPIRATION_ACTION_INTERVAL,AttRec.EXPIRATION_ACTION_INTERVAL),
EXPIRATION_ACTION_CODE = nvl(EXPIRATION_ACTION_CODE,AttRec.EXPIRATION_ACTION_CODE),
MATURITY_DAYS = nvl(MATURITY_DAYS,AttRec.MATURITY_DAYS),
HOLD_DAYS = nvl(HOLD_DAYS,AttRec.HOLD_DAYS),
--End Bug 3713912
--R12 Enhancement
CHARGE_PERIODICITY_CODE = nvl(CHARGE_PERIODICITY_CODE,AttRec.CHARGE_PERIODICITY_CODE),
REPAIR_LEADTIME = nvl(REPAIR_LEADTIME,AttRec.REPAIR_LEADTIME),
REPAIR_YIELD = nvl(REPAIR_YIELD,AttRec.REPAIR_YIELD),
PREPOSITION_POINT = nvl(PREPOSITION_POINT,AttRec.PREPOSITION_POINT),
REPAIR_PROGRAM = nvl(REPAIR_PROGRAM,AttRec.REPAIR_PROGRAM),
SUBCONTRACTING_COMPONENT = nvl(SUBCONTRACTING_COMPONENT,AttRec.SUBCONTRACTING_COMPONENT),
OUTSOURCED_ASSEMBLY = nvl(OUTSOURCED_ASSEMBLY,AttRec.OUTSOURCED_ASSEMBLY)
WHERE process_flag = 1
AND set_process_id = xset_id
AND ((organization_id = org_id) or (all_org = 1))
AND template_id = template_table(i)
AND transaction_type = transaction_table(i);
UPDATE MTL_SYSTEM_ITEMS_INTERFACE
SET
BASE_ITEM_ID = nvl(BASE_ITEM_ID , AttRec.BASE_ITEM_ID),
BASE_WARRANTY_SERVICE_ID = nvl(BASE_WARRANTY_SERVICE_ID , AttRec.BASE_WARRANTY_SERVICE_ID),
COST_OF_SALES_ACCOUNT = nvl(COST_OF_SALES_ACCOUNT , AttRec.COST_OF_SALES_ACCOUNT),
EXPENSE_ACCOUNT = nvl(EXPENSE_ACCOUNT , AttRec.EXPENSE_ACCOUNT),
ENCUMBRANCE_ACCOUNT = nvl(ENCUMBRANCE_ACCOUNT , AttRec.ENCUMBRANCE_ACCOUNT),
PLANNING_EXCEPTION_SET = nvl(PLANNING_EXCEPTION_SET , AttRec.PLANNING_EXCEPTION_SET),
PLANNER_CODE = nvl(PLANNER_CODE , AttRec.PLANNER_CODE),
SALES_ACCOUNT = nvl(SALES_ACCOUNT , AttRec.SALES_ACCOUNT),
WIP_SUPPLY_LOCATOR_ID = nvl(WIP_SUPPLY_LOCATOR_ID , AttRec.WIP_SUPPLY_LOCATOR_ID),
WIP_SUPPLY_SUBINVENTORY = nvl(WIP_SUPPLY_SUBINVENTORY , AttRec.WIP_SUPPLY_SUBINVENTORY),
--Start Bug 3713912
PROCESS_SUPPLY_SUBINVENTORY = nvl(PROCESS_SUPPLY_SUBINVENTORY , AttRec.PROCESS_SUPPLY_SUBINVENTORY),
PROCESS_SUPPLY_LOCATOR_ID = nvl(PROCESS_SUPPLY_LOCATOR_ID , AttRec.PROCESS_SUPPLY_LOCATOR_ID),
PROCESS_YIELD_SUBINVENTORY = nvl(PROCESS_YIELD_SUBINVENTORY , AttRec.PROCESS_YIELD_SUBINVENTORY),
PROCESS_YIELD_LOCATOR_ID = nvl(PROCESS_YIELD_LOCATOR_ID , AttRec.PROCESS_YIELD_LOCATOR_ID)
--End Bug 3713912
WHERE process_flag = 1
AND set_process_id = xset_id
AND organization_id = context_orgid
AND template_id = template_table(i)
AND transaction_type = transaction_table(i);
UPDATE MTL_SYSTEM_ITEMS_INTERFACE
SET
Global_attribute_Category = nvl(Global_attribute_Category,l_global_attribute_Category),
Global_attribute1 = nvl(Global_attribute1,CR.Global_attribute1),
Global_attribute2 = nvl(Global_attribute2,CR.Global_attribute2),
Global_attribute3 = nvl(Global_attribute3,CR.Global_attribute3),
Global_attribute4 = nvl(Global_attribute4,CR.Global_attribute4),
Global_attribute5 = nvl(Global_attribute5,CR.Global_attribute5),
Global_attribute6 = nvl(Global_attribute6,CR.Global_attribute6),
Global_attribute7 = nvl(Global_attribute7,CR.Global_attribute7),
Global_attribute8 = nvl(Global_attribute8,CR.Global_attribute8),
Global_attribute9 = nvl(Global_attribute9,CR.Global_attribute9),
Global_attribute10 = nvl(Global_attribute10,CR.Global_attribute10),
Global_attribute11 = nvl(Global_attribute11,CR.Global_attribute11),
Global_attribute12 = nvl(Global_attribute12,CR.Global_attribute12),
Global_attribute13 = nvl(Global_attribute13,CR.Global_attribute13),
Global_attribute14 = nvl(Global_attribute14,CR.Global_attribute14),
Global_attribute15 = nvl(Global_attribute15,CR.Global_attribute15),
Global_attribute16 = nvl(Global_attribute16,CR.Global_attribute16),
Global_attribute17 = nvl(Global_attribute17,CR.Global_attribute17),
Global_attribute18 = nvl(Global_attribute18,CR.Global_attribute18),
Global_attribute19 = nvl(Global_attribute19,CR.Global_attribute19),
Global_attribute20 = nvl(Global_attribute20,CR.Global_attribute20)
WHERE process_flag = 1
AND set_process_id = xset_id
AND ((organization_id = org_id) or (all_org = 1))
AND template_id = template_table(i)
AND transaction_type = transaction_table(i);
SELECT transaction_id,inventory_item_id,organization_id
FROM mtl_system_items_interface
WHERE process_flag = 1
AND set_process_id = p_xset_id
AND((p_all_org = 1) or (organization_id = p_org_id));
UPDATE mtl_system_items_interface
SET template_id = l_template_id
WHERE process_flag = 1
AND set_process_id = p_xset_id
AND((p_all_org = 1) or (organization_id = p_org_id));
SELECT CONTEXT_ORGANIZATION_ID into l_temp_org_id
FROM mtl_item_templates
WHERE template_id=l_template_id;
UPDATE mtl_system_items_interface
SET template_id = null
WHERE process_flag = 1
AND set_process_id = p_xset_id
AND((p_all_org = 1) or (organization_id = p_org_id));