The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT MAX(fs.segment_num), COUNT(*)
INTO max_segment, totalsegs
FROM fnd_id_flex_segments fs
WHERE fs.application_id = l_application_id
AND fs.id_flex_code = l_id_flex_code
AND fs.enabled_flag = l_enabled_flag
AND fs.id_flex_num = l_id_flex_num;
SELECT TO_NUMBER(SUBSTR(fs.application_column_name, 8)), required_flag
INTO segnum, l_required_flag
FROM fnd_id_flex_segments fs
WHERE fs.segment_num = n
AND fs.id_flex_code = l_id_flex_code
AND fs.id_flex_num = l_id_flex_num
AND fs.enabled_flag = l_enabled_flag
AND fs.application_id = l_application_id;
UPDATE MTL_SYSTEM_ITEMS_INTERFACE I
SET
( I.LAST_UPDATED_BY,
I.CREATED_BY,
I.SUMMARY_FLAG,
I.ENABLED_FLAG,
I.START_DATE_ACTIVE,
I.END_DATE_ACTIVE,
I.DESCRIPTION,
I.LONG_DESCRIPTION,
I.BUYER_ID,
I.ACCOUNTING_RULE_ID,
I.INVOICING_RULE_ID,
I.SEGMENT1,
I.SEGMENT2,
I.SEGMENT3,
I.SEGMENT4,
I.SEGMENT5,
I.SEGMENT6,
I.SEGMENT7,
I.SEGMENT8,
I.SEGMENT9,
I.SEGMENT10,
I.SEGMENT11,
I.SEGMENT12,
I.SEGMENT13,
I.SEGMENT14,
I.SEGMENT15,
I.SEGMENT16,
I.SEGMENT17,
I.SEGMENT18,
I.SEGMENT19,
I.SEGMENT20,
I.ATTRIBUTE_CATEGORY,
I.ATTRIBUTE1,
I.ATTRIBUTE2,
I.ATTRIBUTE3,
I.ATTRIBUTE4,
I.ATTRIBUTE5,
I.ATTRIBUTE6,
I.ATTRIBUTE7,
I.ATTRIBUTE8,
I.ATTRIBUTE9,
I.ATTRIBUTE10,
I.ATTRIBUTE11,
I.ATTRIBUTE12,
I.ATTRIBUTE13,
I.ATTRIBUTE14,
I.ATTRIBUTE15,
/* Start Bug 3713912 */
I.ATTRIBUTE16,
I.ATTRIBUTE17,
I.ATTRIBUTE18,
I.ATTRIBUTE19,
I.ATTRIBUTE20,
I.ATTRIBUTE21,
I.ATTRIBUTE22,
I.ATTRIBUTE23,
I.ATTRIBUTE24,
I.ATTRIBUTE25,
I.ATTRIBUTE26,
I.ATTRIBUTE27,
I.ATTRIBUTE28,
I.ATTRIBUTE29,
I.ATTRIBUTE30,
/* End Bug 3713912 */
I.GLOBAL_ATTRIBUTE_CATEGORY,
I.GLOBAL_ATTRIBUTE1,
I.GLOBAL_ATTRIBUTE2,
I.GLOBAL_ATTRIBUTE3,
I.GLOBAL_ATTRIBUTE4,
I.GLOBAL_ATTRIBUTE5,
I.GLOBAL_ATTRIBUTE6,
I.GLOBAL_ATTRIBUTE7,
I.GLOBAL_ATTRIBUTE8,
I.GLOBAL_ATTRIBUTE9,
I.GLOBAL_ATTRIBUTE10,
I.GLOBAL_ATTRIBUTE11,
I.GLOBAL_ATTRIBUTE12,
I.GLOBAL_ATTRIBUTE13,
I.GLOBAL_ATTRIBUTE14,
I.GLOBAL_ATTRIBUTE15,
I.GLOBAL_ATTRIBUTE16,
I.GLOBAL_ATTRIBUTE17,
I.GLOBAL_ATTRIBUTE18,
I.GLOBAL_ATTRIBUTE19,
I.GLOBAL_ATTRIBUTE20,
I.PURCHASING_ITEM_FLAG,
I.SHIPPABLE_ITEM_FLAG,
I.CUSTOMER_ORDER_FLAG,
I.INTERNAL_ORDER_FLAG,
I.INVENTORY_ITEM_FLAG,
I.ENG_ITEM_FLAG,
I.INVENTORY_ASSET_FLAG,
-- * For the bug 3888752 from its base bug --ANMURALI
-- I.PURCHASING_ENABLED_FLAG,
-- I.CUSTOMER_ORDER_ENABLED_FLAG,
-- I.INTERNAL_ORDER_ENABLED_FLAG,
I.SO_TRANSACTIONS_FLAG,
-- I.MTL_TRANSACTIONS_ENABLED_FLAG,
-- I.STOCK_ENABLED_FLAG,
-- I.BOM_ENABLED_FLAG,
-- I.BUILD_IN_WIP_FLAG,
I.REVISION_QTY_CONTROL_CODE,
I.ITEM_CATALOG_GROUP_ID,
I.CATALOG_STATUS_FLAG,
I.RETURNABLE_FLAG,
I.DEFAULT_SHIPPING_ORG,
I.COLLATERAL_FLAG,
I.TAXABLE_FLAG,
I.PURCHASING_TAX_CODE,
I.QTY_RCV_EXCEPTION_CODE,
I.ALLOW_ITEM_DESC_UPDATE_FLAG,
I.INSPECTION_REQUIRED_FLAG,
I.RECEIPT_REQUIRED_FLAG,
I.MARKET_PRICE,
I.HAZARD_CLASS_ID,
I.RFQ_REQUIRED_FLAG,
I.QTY_RCV_TOLERANCE,
I.LIST_PRICE_PER_UNIT,
I.UN_NUMBER_ID,
I.PRICE_TOLERANCE_PERCENT,
I.ASSET_CATEGORY_ID,
I.ROUNDING_FACTOR,
I.UNIT_OF_ISSUE,
I.ENFORCE_SHIP_TO_LOCATION_CODE,
I.ALLOW_SUBSTITUTE_RECEIPTS_FLAG,
I.ALLOW_UNORDERED_RECEIPTS_FLAG,
I.ALLOW_EXPRESS_DELIVERY_FLAG,
I.DAYS_EARLY_RECEIPT_ALLOWED,
I.DAYS_LATE_RECEIPT_ALLOWED,
I.RECEIPT_DAYS_EXCEPTION_CODE,
I.RECEIVING_ROUTING_ID,
I.INVOICE_CLOSE_TOLERANCE,
I.RECEIVE_CLOSE_TOLERANCE,
I.AUTO_LOT_ALPHA_PREFIX,
I.START_AUTO_LOT_NUMBER,
I.LOT_CONTROL_CODE,
I.SHELF_LIFE_CODE,
I.SHELF_LIFE_DAYS,
I.SERIAL_NUMBER_CONTROL_CODE,
I.START_AUTO_SERIAL_NUMBER,
I.AUTO_SERIAL_ALPHA_PREFIX,
I.SOURCE_TYPE,
--* Commented for Bug #3764605 : Below attributes are org controlled.
--I.SOURCE_ORGANIZATION_ID,
--I.SOURCE_SUBINVENTORY,
--* End of Bug #3764605
I.RESTRICT_SUBINVENTORIES_CODE,
I.UNIT_WEIGHT,
I.WEIGHT_UOM_CODE,
I.VOLUME_UOM_CODE,
I.UNIT_VOLUME,
I.RESTRICT_LOCATORS_CODE,
I.LOCATION_CONTROL_CODE,
I.SHRINKAGE_RATE,
I.ACCEPTABLE_EARLY_DAYS,
I.PLANNING_TIME_FENCE_CODE,
I.DEMAND_TIME_FENCE_CODE,
I.LEAD_TIME_LOT_SIZE,
I.STD_LOT_SIZE,
I.CUM_MANUFACTURING_LEAD_TIME,
I.OVERRUN_PERCENTAGE,
I.MRP_CALCULATE_ATP_FLAG,
I.ACCEPTABLE_RATE_INCREASE,
I.ACCEPTABLE_RATE_DECREASE,
I.CUMULATIVE_TOTAL_LEAD_TIME,
I.PLANNING_TIME_FENCE_DAYS,
I.DEMAND_TIME_FENCE_DAYS,
I.END_ASSEMBLY_PEGGING_FLAG,
I.REPETITIVE_PLANNING_FLAG,
I.BOM_ITEM_TYPE,
I.PICK_COMPONENTS_FLAG,
I.REPLENISH_TO_ORDER_FLAG,
I.BASE_ITEM_ID,
I.ATP_COMPONENTS_FLAG,
I.ATP_FLAG,
I.FIXED_LEAD_TIME,
I.VARIABLE_LEAD_TIME,
I.WIP_SUPPLY_LOCATOR_ID,
I.WIP_SUPPLY_TYPE,
I.WIP_SUPPLY_SUBINVENTORY,
I.PRIMARY_UOM_CODE,
I.PRIMARY_UNIT_OF_MEASURE,
I.ALLOWED_UNITS_LOOKUP_CODE,
I.DEFAULT_INCLUDE_IN_ROLLUP_FLAG,
I.INVENTORY_ITEM_STATUS_CODE,
I.INVENTORY_PLANNING_CODE,
I.PLANNER_CODE,
I.PLANNING_MAKE_BUY_CODE,
I.FIXED_LOT_MULTIPLIER,
I.ROUNDING_CONTROL_TYPE,
I.CARRYING_COST,
I.POSTPROCESSING_LEAD_TIME,
I.PREPROCESSING_LEAD_TIME,
I.FULL_LEAD_TIME,
I.ORDER_COST,
I.MRP_SAFETY_STOCK_PERCENT,
I.MRP_SAFETY_STOCK_CODE,
I.MIN_MINMAX_QUANTITY,
I.MAX_MINMAX_QUANTITY,
I.MINIMUM_ORDER_QUANTITY,
I.FIXED_ORDER_QUANTITY,
I.FIXED_DAYS_SUPPLY,
I.MAXIMUM_ORDER_QUANTITY,
I.ATP_RULE_ID,
I.PICKING_RULE_ID,
I.RESERVABLE_TYPE,
I.POSITIVE_MEASUREMENT_ERROR,
I.NEGATIVE_MEASUREMENT_ERROR,
I.ENGINEERING_ECN_CODE,
I.ENGINEERING_ITEM_ID,
I.ENGINEERING_DATE,
I.SERVICE_STARTING_DELAY,
I.SERVICEABLE_COMPONENT_FLAG,
I.SERVICEABLE_PRODUCT_FLAG,
I.BASE_WARRANTY_SERVICE_ID,
I.PAYMENT_TERMS_ID,
I.PREVENTIVE_MAINTENANCE_FLAG,
I.PRIMARY_SPECIALIST_ID,
I.SECONDARY_SPECIALIST_ID,
I.SERVICEABLE_ITEM_CLASS_ID,
I.TIME_BILLABLE_FLAG,
I.MATERIAL_BILLABLE_FLAG,
I.EXPENSE_BILLABLE_FLAG,
I.PRORATE_SERVICE_FLAG,
I.COVERAGE_SCHEDULE_ID,
I.SERVICE_DURATION_PERIOD_CODE,
I.SERVICE_DURATION,
I.WARRANTY_VENDOR_ID,
I.MAX_WARRANTY_AMOUNT,
I.RESPONSE_TIME_PERIOD_CODE,
I.RESPONSE_TIME_VALUE,
I.NEW_REVISION_CODE,
I.INVOICEABLE_ITEM_FLAG,
I.TAX_CODE,
-- I.INVOICE_ENABLED_FLAG,
I.MUST_USE_APPROVED_VENDOR_FLAG,
I.REQUEST_ID,
I.PROGRAM_APPLICATION_ID,
I.PROGRAM_ID,
I.PROGRAM_UPDATE_DATE,
I.OUTSIDE_OPERATION_FLAG,
I.OUTSIDE_OPERATION_UOM_TYPE,
I.SAFETY_STOCK_BUCKET_DAYS,
I.AUTO_REDUCE_MPS,
I.COSTING_ENABLED_FLAG,
I.CYCLE_COUNT_ENABLED_FLAG,
I.AUTO_CREATED_CONFIG_FLAG,
I.ITEM_TYPE,
I.MODEL_CONFIG_CLAUSE_NAME,
I.SHIP_MODEL_COMPLETE_FLAG,
I.MRP_PLANNING_CODE,
I.ATO_FORECAST_CONTROL,
I.RETURN_INSPECTION_REQUIREMENT,
I.RELEASE_TIME_FENCE_CODE,
I.RELEASE_TIME_FENCE_DAYS,
I.CONTAINER_ITEM_FLAG,
I.CONTAINER_TYPE_CODE,
I.INTERNAL_VOLUME,
I.MAXIMUM_LOAD_WEIGHT,
I.MINIMUM_FILL_PERCENT,
I.VEHICLE_ITEM_FLAG,
I.CHECK_SHORTAGES_FLAG, /*CK 18NOV98 Added new attribute*/
I.EFFECTIVITY_CONTROL,
I.OVERCOMPLETION_TOLERANCE_TYPE,
I.OVERCOMPLETION_TOLERANCE_VALUE,
I.OVER_SHIPMENT_TOLERANCE,
I.UNDER_SHIPMENT_TOLERANCE,
I.OVER_RETURN_TOLERANCE,
I.UNDER_RETURN_TOLERANCE,
I.EQUIPMENT_TYPE,
I.RECOVERED_PART_DISP_CODE,
I.DEFECT_TRACKING_ON_FLAG,
I.EVENT_FLAG,
I.ELECTRONIC_FLAG,
I.DOWNLOADABLE_FLAG
, I.VOL_DISCOUNT_EXEMPT_FLAG
, I.COUPON_EXEMPT_FLAG
, I.COMMS_NL_TRACKABLE_FLAG
, I.ASSET_CREATION_CODE
, I.COMMS_ACTIVATION_REQD_FLAG
, I.ORDERABLE_ON_WEB_FLAG
, I.BACK_ORDERABLE_FLAG
, I.WEB_STATUS
, I.INDIVISIBLE_FLAG
, I.DIMENSION_UOM_CODE
, I.UNIT_LENGTH
, I.UNIT_WIDTH
, I.UNIT_HEIGHT
, I.BULK_PICKED_FLAG
, I.LOT_STATUS_ENABLED
, I.DEFAULT_LOT_STATUS_ID
, I.SERIAL_STATUS_ENABLED
, I.DEFAULT_SERIAL_STATUS_ID
, I.INVENTORY_CARRY_PENALTY
, I.OPERATION_SLACK_PENALTY
, I.FINANCING_ALLOWED_FLAG
, I.EAM_ITEM_TYPE
, I.EAM_ACTIVITY_TYPE_CODE
, I.EAM_ACTIVITY_CAUSE_CODE
, I.EAM_ACT_NOTIFICATION_FLAG
, I.EAM_ACT_SHUTDOWN_STATUS
, I.DUAL_UOM_CONTROL
, I.SECONDARY_UOM_CODE
, I.DUAL_UOM_DEVIATION_HIGH
, I.DUAL_UOM_DEVIATION_LOW
--, I.SERVICE_ITEM_FLAG
--, I.VENDOR_WARRANTY_FLAG
--, I.USAGE_ITEM_FLAG
, I.CONTRACT_ITEM_TYPE_CODE
, I.SUBSCRIPTION_DEPEND_FLAG
--
, I.SERV_REQ_ENABLED_CODE
, I.SERV_BILLING_ENABLED_FLAG
, I.SERV_IMPORTANCE_LEVEL
, I.PLANNED_INV_POINT_FLAG
, I.DEFAULT_SO_SOURCE_TYPE
, I.CREATE_SUPPLY_FLAG
, I.SUBSTITUTION_WINDOW_CODE
, I.SUBSTITUTION_WINDOW_DAYS
--Moved the dependant Lot attributes together
--(For ease of fix for bug# 2760857)
, I.LOT_SPLIT_ENABLED
, I.LOT_MERGE_ENABLED
, I.LOT_TRANSLATE_ENABLED
--Added as part of 11.5.9
, I.LOT_SUBSTITUTION_ENABLED
, I.MINIMUM_LICENSE_QUANTITY
, I.EAM_ACTIVITY_SOURCE_CODE
, I.IB_ITEM_INSTANCE_CLASS
, I.CONFIG_MODEL_TYPE
--2740503: Defaulting lifecycle-phase from master org.
, I.LIFECYCLE_ID
, I.CURRENT_PHASE_ID
--Added as part of 11.5.10
, I.TRACKING_QUANTITY_IND
, I.ONT_PRICING_QTY_SOURCE
, I.SECONDARY_DEFAULT_IND
, I.CONFIG_ORGS
, I.CONFIG_MATCH
, I.VMI_MINIMUM_UNITS
, I.VMI_MINIMUM_DAYS
, I.VMI_MAXIMUM_UNITS
, I.VMI_MAXIMUM_DAYS
, I.VMI_FIXED_ORDER_QUANTITY
, I.SO_AUTHORIZATION_FLAG
, I.CONSIGNED_FLAG
, I.ASN_AUTOEXPIRE_FLAG
, I.VMI_FORECAST_TYPE
, I.FORECAST_HORIZON
, I.EXCLUDE_FROM_BUDGET_FLAG
, I.DAYS_TGT_INV_SUPPLY
, I.DAYS_TGT_INV_WINDOW
, I.DAYS_MAX_INV_SUPPLY
, I.DAYS_MAX_INV_WINDOW
, I.DRP_PLANNED_FLAG
, I.CRITICAL_COMPONENT_FLAG
, I.CONTINOUS_TRANSFER
, I.CONVERGENCE
, I.DIVERGENCE
/* Start Bug 3713912 */
, I.LOT_DIVISIBLE_FLAG
, I.GRADE_CONTROL_FLAG
, I.DEFAULT_GRADE
, I.CHILD_LOT_FLAG
, I.PARENT_CHILD_GENERATION_FLAG
, I.CHILD_LOT_PREFIX
, I.CHILD_LOT_STARTING_NUMBER
, I.CHILD_LOT_VALIDATION_FLAG
, I.COPY_LOT_ATTRIBUTE_FLAG
--5349389 , I.RECIPE_ENABLED_FLAG
, I.PROCESS_QUALITY_ENABLED_FLAG
--5349389 , I.PROCESS_EXECUTION_ENABLED_FLAG
, I.PROCESS_COSTING_ENABLED_FLAG
, I.PROCESS_SUPPLY_SUBINVENTORY
, I.PROCESS_SUPPLY_LOCATOR_ID
, I.PROCESS_YIELD_SUBINVENTORY
, I.PROCESS_YIELD_LOCATOR_ID
, I.HAZARDOUS_MATERIAL_FLAG
, I.CAS_NUMBER
, I.RETEST_INTERVAL
, I.EXPIRATION_ACTION_INTERVAL
, I.EXPIRATION_ACTION_CODE
, I.MATURITY_DAYS
, I.HOLD_DAYS
/* End Bug 3713912 */
--R12 Enhancement
, I.REPAIR_LEADTIME
, I.REPAIR_YIELD
, I.PREPOSITION_POINT
, I.REPAIR_PROGRAM
, I.CHARGE_PERIODICITY_CODE
, I.SUBCONTRACTING_COMPONENT
, I.OUTSOURCED_ASSEMBLY
/* FPC Attributes */
, I.GDSN_OUTBOUND_ENABLED_FLAG
, I.TRADE_ITEM_DESCRIPTOR
, I.STYLE_ITEM_FLAG
, I.STYLE_ITEM_ID
) = (
SELECT
master_org_id, /* LAST_UPDATED_BY */
decode(i.created_by,-99,i.created_by,l_created_by), /*NP Comment here is where created_by is set
to 1 to reflect item exists in msi */
NVL(I.SUMMARY_FLAG,M.SUMMARY_FLAG),
NVL(I.ENABLED_FLAG,M.ENABLED_FLAG),
NVL(I.START_DATE_ACTIVE,M.START_DATE_ACTIVE),
NVL(I.END_DATE_ACTIVE,M.END_DATE_ACTIVE),
NVL(I.DESCRIPTION, M.DESCRIPTION),
NVL(I.LONG_DESCRIPTION, M.LONG_DESCRIPTION),
NVL(I.BUYER_ID,M.BUYER_ID),
NVL(I.ACCOUNTING_RULE_ID,M.ACCOUNTING_RULE_ID),
NVL(I.INVOICING_RULE_ID,M.INVOICING_RULE_ID),
NVL(I.SEGMENT1,M.SEGMENT1),
NVL(I.SEGMENT2,M.SEGMENT2),
NVL(I.SEGMENT3,M.SEGMENT3),
NVL(I.SEGMENT4,M.SEGMENT4),
NVL(I.SEGMENT5,M.SEGMENT5),
NVL(I.SEGMENT6,M.SEGMENT6),
NVL(I.SEGMENT7,M.SEGMENT7),
NVL(I.SEGMENT8,M.SEGMENT8),
NVL(I.SEGMENT9,M.SEGMENT9),
NVL(I.SEGMENT10,M.SEGMENT10),
NVL(I.SEGMENT11,M.SEGMENT11),
NVL(I.SEGMENT12,M.SEGMENT12),
NVL(I.SEGMENT13,M.SEGMENT13),
NVL(I.SEGMENT14,M.SEGMENT14),
NVL(I.SEGMENT15,M.SEGMENT15),
NVL(I.SEGMENT16,M.SEGMENT16),
NVL(I.SEGMENT17,M.SEGMENT17),
NVL(I.SEGMENT18,M.SEGMENT18),
NVL(I.SEGMENT19,M.SEGMENT19),
NVL(I.SEGMENT20,M.SEGMENT20),
NVL(I.ATTRIBUTE_CATEGORY,M.ATTRIBUTE_CATEGORY),
NVL(I.ATTRIBUTE1,M.ATTRIBUTE1),
NVL(I.ATTRIBUTE2,M.ATTRIBUTE2),
NVL(I.ATTRIBUTE3,M.ATTRIBUTE3),
NVL(I.ATTRIBUTE4,M.ATTRIBUTE4),
NVL(I.ATTRIBUTE5,M.ATTRIBUTE5),
NVL(I.ATTRIBUTE6,M.ATTRIBUTE6),
NVL(I.ATTRIBUTE7,M.ATTRIBUTE7),
NVL(I.ATTRIBUTE8,M.ATTRIBUTE8),
NVL(I.ATTRIBUTE9,M.ATTRIBUTE9),
NVL(I.ATTRIBUTE10,M.ATTRIBUTE10),
NVL(I.ATTRIBUTE11,M.ATTRIBUTE11),
NVL(I.ATTRIBUTE12,M.ATTRIBUTE12),
NVL(I.ATTRIBUTE13,M.ATTRIBUTE13),
NVL(I.ATTRIBUTE14,M.ATTRIBUTE14),
NVL(I.ATTRIBUTE15,M.ATTRIBUTE15),
/* End Bug 3713912 */
NVL(I.ATTRIBUTE16, M.ATTRIBUTE16) ,
NVL(I.ATTRIBUTE17, M.ATTRIBUTE17) ,
NVL(I.ATTRIBUTE18, M.ATTRIBUTE18) ,
NVL(I.ATTRIBUTE19, M.ATTRIBUTE19) ,
NVL(I.ATTRIBUTE20, M.ATTRIBUTE20) ,
NVL(I.ATTRIBUTE21, M.ATTRIBUTE21) ,
NVL(I.ATTRIBUTE22, M.ATTRIBUTE22) ,
NVL(I.ATTRIBUTE23, M.ATTRIBUTE23) ,
NVL(I.ATTRIBUTE24, M.ATTRIBUTE24) ,
NVL(I.ATTRIBUTE25, M.ATTRIBUTE25) ,
NVL(I.ATTRIBUTE26, M.ATTRIBUTE26) ,
NVL(I.ATTRIBUTE27, M.ATTRIBUTE27) ,
NVL(I.ATTRIBUTE28, M.ATTRIBUTE28) ,
NVL(I.ATTRIBUTE29, M.ATTRIBUTE29) ,
NVL(I.ATTRIBUTE30, M.ATTRIBUTE30) ,
/* End Bug 3713912 */
NVL(I.GLOBAL_ATTRIBUTE_CATEGORY,M.GLOBAL_ATTRIBUTE_CATEGORY),
NVL(I.GLOBAL_ATTRIBUTE1,M.GLOBAL_ATTRIBUTE1),
NVL(I.GLOBAL_ATTRIBUTE2,M.GLOBAL_ATTRIBUTE2),
NVL(I.GLOBAL_ATTRIBUTE3,M.GLOBAL_ATTRIBUTE3),
NVL(I.GLOBAL_ATTRIBUTE4,M.GLOBAL_ATTRIBUTE4),
NVL(I.GLOBAL_ATTRIBUTE5,M.GLOBAL_ATTRIBUTE5),
NVL(I.GLOBAL_ATTRIBUTE6,M.GLOBAL_ATTRIBUTE6),
NVL(I.GLOBAL_ATTRIBUTE7,M.GLOBAL_ATTRIBUTE7),
NVL(I.GLOBAL_ATTRIBUTE8,M.GLOBAL_ATTRIBUTE8),
NVL(I.GLOBAL_ATTRIBUTE9,M.GLOBAL_ATTRIBUTE9),
NVL(I.GLOBAL_ATTRIBUTE10,M.GLOBAL_ATTRIBUTE10),
NVL(I.GLOBAL_ATTRIBUTE11,M.GLOBAL_ATTRIBUTE11),
NVL(I.GLOBAL_ATTRIBUTE12,M.GLOBAL_ATTRIBUTE12),
NVL(I.GLOBAL_ATTRIBUTE13,M.GLOBAL_ATTRIBUTE13),
NVL(I.GLOBAL_ATTRIBUTE14,M.GLOBAL_ATTRIBUTE14),
NVL(I.GLOBAL_ATTRIBUTE15,M.GLOBAL_ATTRIBUTE15),
NVL(I.GLOBAL_ATTRIBUTE16,M.GLOBAL_ATTRIBUTE16),
NVL(I.GLOBAL_ATTRIBUTE17,M.GLOBAL_ATTRIBUTE17),
NVL(I.GLOBAL_ATTRIBUTE18,M.GLOBAL_ATTRIBUTE18),
NVL(I.GLOBAL_ATTRIBUTE19,M.GLOBAL_ATTRIBUTE19),
NVL(I.GLOBAL_ATTRIBUTE20,M.GLOBAL_ATTRIBUTE20),
NVL(I.PURCHASING_ITEM_FLAG,M.PURCHASING_ITEM_FLAG),
DECODE(I.INTERNAL_ORDER_FLAG, 'Y','Y', DECODE(M.INTERNAL_ORDER_FLAG, 'Y','Y',
nvl(I.SHIPPABLE_ITEM_FLAG,M.SHIPPABLE_ITEM_FLAG))),
NVL(I.CUSTOMER_ORDER_FLAG,M.CUSTOMER_ORDER_FLAG),
NVL(I.INTERNAL_ORDER_FLAG,M.INTERNAL_ORDER_FLAG),
NVL(I.INVENTORY_ITEM_FLAG,M.INVENTORY_ITEM_FLAG),
NVL(I.ENG_ITEM_FLAG,M.ENG_ITEM_FLAG),
NVL(I.INVENTORY_ASSET_FLAG,M.INVENTORY_ASSET_FLAG),
-- * For the bug 3888752 from its base bug --ANMURALI
-- NVL(I.PURCHASING_ENABLED_FLAG,M.PURCHASING_ENABLED_FLAG),
-- NVL(I.CUSTOMER_ORDER_ENABLED_FLAG,M.CUSTOMER_ORDER_ENABLED_FLAG),
-- NVL(I.INTERNAL_ORDER_ENABLED_FLAG,M.INTERNAL_ORDER_ENABLED_FLAG),
NVL(I.SO_TRANSACTIONS_FLAG,M.SO_TRANSACTIONS_FLAG),
-- NVL(I.MTL_TRANSACTIONS_ENABLED_FLAG,M.MTL_TRANSACTIONS_ENABLED_FLAG),
-- NVL(I.STOCK_ENABLED_FLAG,M.STOCK_ENABLED_FLAG),
-- NVL(I.BOM_ENABLED_FLAG,M.BOM_ENABLED_FLAG),
-- NVL(I.BUILD_IN_WIP_FLAG,M.BUILD_IN_WIP_FLAG),
NVL(I.REVISION_QTY_CONTROL_CODE,M.REVISION_QTY_CONTROL_CODE),
NVL(I.ITEM_CATALOG_GROUP_ID,M.ITEM_CATALOG_GROUP_ID),
NVL(I.CATALOG_STATUS_FLAG,M.CATALOG_STATUS_FLAG),
NVL(I.RETURNABLE_FLAG,M.RETURNABLE_FLAG),
NVL(I.DEFAULT_SHIPPING_ORG,M.DEFAULT_SHIPPING_ORG),
NVL(I.COLLATERAL_FLAG,M.COLLATERAL_FLAG),
NVL(I.TAXABLE_FLAG,M.TAXABLE_FLAG),
-- NVL(I.PURCHASING_TAX_CODE,M.PURCHASING_TAX_CODE),
NVL(I.PURCHASING_TAX_CODE,DECODE(NVL(I.TAXABLE_FLAG,M.TAXABLE_FLAG),NULL,NULL,'N',NULL,M.PURCHASING_TAX_CODE)),
NVL(I.QTY_RCV_EXCEPTION_CODE,M.QTY_RCV_EXCEPTION_CODE),
NVL(I.ALLOW_ITEM_DESC_UPDATE_FLAG,M.ALLOW_ITEM_DESC_UPDATE_FLAG),
NVL(I.INSPECTION_REQUIRED_FLAG,M.INSPECTION_REQUIRED_FLAG),
NVL(I.RECEIPT_REQUIRED_FLAG,M.RECEIPT_REQUIRED_FLAG),
NVL(I.MARKET_PRICE,M.MARKET_PRICE),
NVL(I.HAZARD_CLASS_ID,M.HAZARD_CLASS_ID),
NVL(I.RFQ_REQUIRED_FLAG,M.RFQ_REQUIRED_FLAG),
NVL(I.QTY_RCV_TOLERANCE,M.QTY_RCV_TOLERANCE),
NVL(I.LIST_PRICE_PER_UNIT,M.LIST_PRICE_PER_UNIT),
NVL(I.UN_NUMBER_ID,M.UN_NUMBER_ID),
NVL(I.PRICE_TOLERANCE_PERCENT,M.PRICE_TOLERANCE_PERCENT),
NVL(I.ASSET_CATEGORY_ID,M.ASSET_CATEGORY_ID),
NVL(I.ROUNDING_FACTOR,M.ROUNDING_FACTOR),
NVL(I.UNIT_OF_ISSUE,M.UNIT_OF_ISSUE),
NVL(I.ENFORCE_SHIP_TO_LOCATION_CODE,M.ENFORCE_SHIP_TO_LOCATION_CODE),
NVL(I.ALLOW_SUBSTITUTE_RECEIPTS_FLAG,M.ALLOW_SUBSTITUTE_RECEIPTS_FLAG),
NVL(I.ALLOW_UNORDERED_RECEIPTS_FLAG,M.ALLOW_UNORDERED_RECEIPTS_FLAG),
NVL(I.ALLOW_EXPRESS_DELIVERY_FLAG,M.ALLOW_EXPRESS_DELIVERY_FLAG),
NVL(I.DAYS_EARLY_RECEIPT_ALLOWED,M.DAYS_EARLY_RECEIPT_ALLOWED),
NVL(I.DAYS_LATE_RECEIPT_ALLOWED,M.DAYS_LATE_RECEIPT_ALLOWED),
NVL(I.RECEIPT_DAYS_EXCEPTION_CODE,M.RECEIPT_DAYS_EXCEPTION_CODE),
NVL(I.RECEIVING_ROUTING_ID,M.RECEIVING_ROUTING_ID),
NVL(I.INVOICE_CLOSE_TOLERANCE,M.INVOICE_CLOSE_TOLERANCE),
NVL(I.RECEIVE_CLOSE_TOLERANCE,M.RECEIVE_CLOSE_TOLERANCE),
NVL(I.AUTO_LOT_ALPHA_PREFIX,M.AUTO_LOT_ALPHA_PREFIX),
NVL(I.START_AUTO_LOT_NUMBER,M.START_AUTO_LOT_NUMBER),
NVL(I.LOT_CONTROL_CODE,M.LOT_CONTROL_CODE),
NVL(I.SHELF_LIFE_CODE,M.SHELF_LIFE_CODE),
NVL(I.SHELF_LIFE_DAYS,M.SHELF_LIFE_DAYS),
NVL(I.SERIAL_NUMBER_CONTROL_CODE,M.SERIAL_NUMBER_CONTROL_CODE),
NVL(I.START_AUTO_SERIAL_NUMBER,M.START_AUTO_SERIAL_NUMBER),
NVL(I.AUTO_SERIAL_ALPHA_PREFIX,M.AUTO_SERIAL_ALPHA_PREFIX),
NVL(I.SOURCE_TYPE,M.SOURCE_TYPE),
--* Commented for Bug #3764605 : Below attributes are org controlled.
--NVL(I.SOURCE_ORGANIZATION_ID,M.SOURCE_ORGANIZATION_ID),
--NVL(I.SOURCE_SUBINVENTORY,M.SOURCE_SUBINVENTORY),
--* End of Bug #3764605
NVL(I.RESTRICT_SUBINVENTORIES_CODE,M.RESTRICT_SUBINVENTORIES_CODE),
NVL(I.UNIT_WEIGHT,M.UNIT_WEIGHT),
NVL(I.WEIGHT_UOM_CODE,M.WEIGHT_UOM_CODE),
NVL(I.VOLUME_UOM_CODE,M.VOLUME_UOM_CODE),
NVL(I.UNIT_VOLUME,M.UNIT_VOLUME),
NVL(I.RESTRICT_LOCATORS_CODE,M.RESTRICT_LOCATORS_CODE),
NVL(I.LOCATION_CONTROL_CODE,M.LOCATION_CONTROL_CODE),
NVL(I.SHRINKAGE_RATE,M.SHRINKAGE_RATE),
NVL(I.ACCEPTABLE_EARLY_DAYS,M.ACCEPTABLE_EARLY_DAYS),
NVL(I.PLANNING_TIME_FENCE_CODE, M.PLANNING_TIME_FENCE_CODE),
NVL(I.DEMAND_TIME_FENCE_CODE, M.DEMAND_TIME_FENCE_CODE),
NVL(I.LEAD_TIME_LOT_SIZE,M.LEAD_TIME_LOT_SIZE),
NVL(I.STD_LOT_SIZE,M.STD_LOT_SIZE),
NVL(I.CUM_MANUFACTURING_LEAD_TIME,M.CUM_MANUFACTURING_LEAD_TIME),
NVL(I.OVERRUN_PERCENTAGE,M.OVERRUN_PERCENTAGE),
NVL(I.MRP_CALCULATE_ATP_FLAG,NVL(M.MRP_CALCULATE_ATP_FLAG,'N')),
NVL(I.ACCEPTABLE_RATE_INCREASE,M.ACCEPTABLE_RATE_INCREASE),
NVL(I.ACCEPTABLE_RATE_DECREASE,M.ACCEPTABLE_RATE_DECREASE),
NVL(I.CUMULATIVE_TOTAL_LEAD_TIME,M.CUMULATIVE_TOTAL_LEAD_TIME),
/*AN991207 #1081419: If child org time_fence_code is non-user defined,
do not copy master org time_fence_days to the child org */
NVL(I.PLANNING_TIME_FENCE_DAYS, decode(NVL(I.PLANNING_TIME_FENCE_CODE, M.PLANNING_TIME_FENCE_CODE),
4, M.PLANNING_TIME_FENCE_DAYS, NULL)),
NVL(I.DEMAND_TIME_FENCE_DAYS, decode(NVL(I.DEMAND_TIME_FENCE_CODE, M.DEMAND_TIME_FENCE_CODE),
4, M.DEMAND_TIME_FENCE_DAYS, NULL)),
NVL(I.END_ASSEMBLY_PEGGING_FLAG,M.END_ASSEMBLY_PEGGING_FLAG),
NVL(I.REPETITIVE_PLANNING_FLAG,M.REPETITIVE_PLANNING_FLAG),
NVL(I.BOM_ITEM_TYPE,M.BOM_ITEM_TYPE),
NVL(I.PICK_COMPONENTS_FLAG,M.PICK_COMPONENTS_FLAG),
NVL(I.REPLENISH_TO_ORDER_FLAG,M.REPLENISH_TO_ORDER_FLAG),
NVL(I.BASE_ITEM_ID,M.BASE_ITEM_ID),
NVL(I.ATP_COMPONENTS_FLAG,M.ATP_COMPONENTS_FLAG),
NVL(I.ATP_FLAG,M.ATP_FLAG),
NVL(I.FIXED_LEAD_TIME,M.FIXED_LEAD_TIME),
NVL(I.VARIABLE_LEAD_TIME,M.VARIABLE_LEAD_TIME),
I.WIP_SUPPLY_LOCATOR_ID, /*NP 26AUG94 this should not default from master*/
NVL(I.WIP_SUPPLY_TYPE,M.WIP_SUPPLY_TYPE),
I.WIP_SUPPLY_SUBINVENTORY, /*NP 26AUG94 this should not default from master*/
-- Primary Unit of Measure is now maintained via the PRIMARY_UOM_CODE column.
-- Bug: 4071090 NVL(I.PRIMARY_UOM_CODE,M.PRIMARY_UOM_CODE),
NVL(I.PRIMARY_UOM_CODE, M.PRIMARY_UOM_CODE),
--No defaulting from Master, as PRIMARY_UOM_CODE takes care of it.
NVL(I.PRIMARY_UNIT_OF_MEASURE,M.PRIMARY_UNIT_OF_MEASURE), /* MSIB only stores untranslated values for PUOM 5438341*/
NVL(I.ALLOWED_UNITS_LOOKUP_CODE,M.ALLOWED_UNITS_LOOKUP_CODE),
NVL(I.DEFAULT_INCLUDE_IN_ROLLUP_FLAG,M.DEFAULT_INCLUDE_IN_ROLLUP_FLAG),
NVL(I.INVENTORY_ITEM_STATUS_CODE,M.INVENTORY_ITEM_STATUS_CODE),
NVL(I.INVENTORY_PLANNING_CODE,M.INVENTORY_PLANNING_CODE),
I.PLANNER_CODE, /*NP 26AUG94 no defaulting from master*/
NVL(I.PLANNING_MAKE_BUY_CODE,M.PLANNING_MAKE_BUY_CODE),
NVL(I.FIXED_LOT_MULTIPLIER,M.FIXED_LOT_MULTIPLIER),
NVL(I.ROUNDING_CONTROL_TYPE,M.ROUNDING_CONTROL_TYPE),
NVL(I.CARRYING_COST,M.CARRYING_COST),
NVL(I.POSTPROCESSING_LEAD_TIME,M.POSTPROCESSING_LEAD_TIME),
NVL(I.PREPROCESSING_LEAD_TIME,M.PREPROCESSING_LEAD_TIME),
NVL(I.FULL_LEAD_TIME,M.FULL_LEAD_TIME),
NVL(I.ORDER_COST,M.ORDER_COST),
NVL(I.MRP_SAFETY_STOCK_PERCENT,M.MRP_SAFETY_STOCK_PERCENT),
NVL(I.MRP_SAFETY_STOCK_CODE,M.MRP_SAFETY_STOCK_CODE),
NVL(I.MIN_MINMAX_QUANTITY,M.MIN_MINMAX_QUANTITY),
NVL(I.MAX_MINMAX_QUANTITY,M.MAX_MINMAX_QUANTITY),
NVL(I.MINIMUM_ORDER_QUANTITY,M.MINIMUM_ORDER_QUANTITY),
NVL(I.FIXED_ORDER_QUANTITY,M.FIXED_ORDER_QUANTITY),
NVL(I.FIXED_DAYS_SUPPLY,M.FIXED_DAYS_SUPPLY),
NVL(I.MAXIMUM_ORDER_QUANTITY,M.MAXIMUM_ORDER_QUANTITY),
NVL(I.ATP_RULE_ID,M.ATP_RULE_ID),
NVL(I.PICKING_RULE_ID,M.PICKING_RULE_ID),
NVL(I.RESERVABLE_TYPE,M.RESERVABLE_TYPE),
NVL(I.POSITIVE_MEASUREMENT_ERROR,M.POSITIVE_MEASUREMENT_ERROR),
NVL(I.NEGATIVE_MEASUREMENT_ERROR,M.NEGATIVE_MEASUREMENT_ERROR),
NVL(I.ENGINEERING_ECN_CODE,M.ENGINEERING_ECN_CODE),
NVL(I.ENGINEERING_ITEM_ID,M.ENGINEERING_ITEM_ID),
NVL(I.ENGINEERING_DATE,M.ENGINEERING_DATE),
NVL(I.SERVICE_STARTING_DELAY,M.SERVICE_STARTING_DELAY),
NVL(I.SERVICEABLE_COMPONENT_FLAG,M.SERVICEABLE_COMPONENT_FLAG),
NVL(I.SERVICEABLE_PRODUCT_FLAG,M.SERVICEABLE_PRODUCT_FLAG),
NVL(I.BASE_WARRANTY_SERVICE_ID,M.BASE_WARRANTY_SERVICE_ID),
NVL(I.PAYMENT_TERMS_ID,M.PAYMENT_TERMS_ID),
NVL(I.PREVENTIVE_MAINTENANCE_FLAG,M.PREVENTIVE_MAINTENANCE_FLAG),
NVL(I.PRIMARY_SPECIALIST_ID,M.PRIMARY_SPECIALIST_ID),
NVL(I.SECONDARY_SPECIALIST_ID,M.SECONDARY_SPECIALIST_ID),
NVL(I.SERVICEABLE_ITEM_CLASS_ID,M.SERVICEABLE_ITEM_CLASS_ID),
NVL(I.TIME_BILLABLE_FLAG,M.TIME_BILLABLE_FLAG),
-- NVL(I.MATERIAL_BILLABLE_FLAG,M.MATERIAL_BILLABLE_FLAG),
NVL(I.MATERIAL_BILLABLE_FLAG, DECODE(
NVL(I.SERV_BILLING_ENABLED_FLAG,M.SERV_BILLING_ENABLED_FLAG)
,NULL,NULL,
'N',NULL,
M.MATERIAL_BILLABLE_FLAG)), -- Bug 5361618
NVL(I.EXPENSE_BILLABLE_FLAG,M.EXPENSE_BILLABLE_FLAG),
NVL(I.PRORATE_SERVICE_FLAG,M.PRORATE_SERVICE_FLAG),
NVL(I.COVERAGE_SCHEDULE_ID,M.COVERAGE_SCHEDULE_ID),
NVL(I.SERVICE_DURATION_PERIOD_CODE,M.SERVICE_DURATION_PERIOD_CODE),
NVL(I.SERVICE_DURATION,M.SERVICE_DURATION),
NVL(I.WARRANTY_VENDOR_ID,M.WARRANTY_VENDOR_ID),
NVL(I.MAX_WARRANTY_AMOUNT,M.MAX_WARRANTY_AMOUNT),
NVL(I.RESPONSE_TIME_PERIOD_CODE,M.RESPONSE_TIME_PERIOD_CODE),
NVL(I.RESPONSE_TIME_VALUE,M.RESPONSE_TIME_VALUE),
NVL(I.NEW_REVISION_CODE,M.NEW_REVISION_CODE),
NVL(I.INVOICEABLE_ITEM_FLAG,M.INVOICEABLE_ITEM_FLAG),
NVL(I.TAX_CODE,M.TAX_CODE),
--NVL(I.INVOICE_ENABLED_FLAG,M.INVOICE_ENABLED_FLAG),
NVL(I.MUST_USE_APPROVED_VENDOR_FLAG,M.MUST_USE_APPROVED_VENDOR_FLAG),
NVL(I.REQUEST_ID,M.REQUEST_ID),
NVL(I.PROGRAM_APPLICATION_ID,M.PROGRAM_APPLICATION_ID),
NVL(I.PROGRAM_ID,M.PROGRAM_ID),
NVL(I.PROGRAM_UPDATE_DATE,M.PROGRAM_UPDATE_DATE),
NVL(I.OUTSIDE_OPERATION_FLAG,M.OUTSIDE_OPERATION_FLAG),
NVL(I.OUTSIDE_OPERATION_UOM_TYPE,M.OUTSIDE_OPERATION_UOM_TYPE),
NVL(I.SAFETY_STOCK_BUCKET_DAYS,M.SAFETY_STOCK_BUCKET_DAYS),
NVL(I.AUTO_REDUCE_MPS,M.AUTO_REDUCE_MPS),
NVL(I.COSTING_ENABLED_FLAG,M.COSTING_ENABLED_FLAG),
NVL(I.CYCLE_COUNT_ENABLED_FLAG,M.CYCLE_COUNT_ENABLED_FLAG),
NVL(I.AUTO_CREATED_CONFIG_FLAG,M.AUTO_CREATED_CONFIG_FLAG),
NVL(I.ITEM_TYPE,M.ITEM_TYPE),
NVL(I.MODEL_CONFIG_CLAUSE_NAME,M.MODEL_CONFIG_CLAUSE_NAME),
NVL(I.SHIP_MODEL_COMPLETE_FLAG,M.SHIP_MODEL_COMPLETE_FLAG),
NVL(I.MRP_PLANNING_CODE,M.MRP_PLANNING_CODE),
NVL(I.ATO_FORECAST_CONTROL,M.ATO_FORECAST_CONTROL),
NVL(I.RETURN_INSPECTION_REQUIREMENT,M.RETURN_INSPECTION_REQUIREMENT),
NVL(I.RELEASE_TIME_FENCE_CODE, M.RELEASE_TIME_FENCE_CODE),
/*AN991207 #1081419: If child org time_fence_code is non-user defined,
do not copy master org time_fence_days to the child org */
NVL(I.RELEASE_TIME_FENCE_DAYS, decode(NVL(I.RELEASE_TIME_FENCE_CODE, M.RELEASE_TIME_FENCE_CODE),
4, M.RELEASE_TIME_FENCE_DAYS, NULL)),
NVL(I.CONTAINER_ITEM_FLAG, M.CONTAINER_ITEM_FLAG),
NVL(I.CONTAINER_TYPE_CODE, M.CONTAINER_TYPE_CODE),
NVL(I.INTERNAL_VOLUME, M.INTERNAL_VOLUME),
NVL(I.MAXIMUM_LOAD_WEIGHT, M.MAXIMUM_LOAD_WEIGHT),
NVL(I.MINIMUM_FILL_PERCENT, M.MINIMUM_FILL_PERCENT),
NVL(I.VEHICLE_ITEM_FLAG, M.VEHICLE_ITEM_FLAG),
NVL(I.CHECK_SHORTAGES_FLAG, M.CHECK_SHORTAGES_FLAG)
, NVL( I.EFFECTIVITY_CONTROL, M.EFFECTIVITY_CONTROL )
, NVL( I.OVERCOMPLETION_TOLERANCE_TYPE, M.OVERCOMPLETION_TOLERANCE_TYPE )
, NVL( I.OVERCOMPLETION_TOLERANCE_VALUE, M.OVERCOMPLETION_TOLERANCE_VALUE )
, NVL( I.OVER_SHIPMENT_TOLERANCE, M.OVER_SHIPMENT_TOLERANCE )
, NVL( I.UNDER_SHIPMENT_TOLERANCE, M.UNDER_SHIPMENT_TOLERANCE )
, NVL( I.OVER_RETURN_TOLERANCE, M.OVER_RETURN_TOLERANCE )
, NVL( I.UNDER_RETURN_TOLERANCE, M.UNDER_RETURN_TOLERANCE )
, NVL( I.EQUIPMENT_TYPE, M.EQUIPMENT_TYPE )
, NVL( I.RECOVERED_PART_DISP_CODE, M.RECOVERED_PART_DISP_CODE )
, NVL( I.DEFECT_TRACKING_ON_FLAG, M.DEFECT_TRACKING_ON_FLAG )
, NVL( I.EVENT_FLAG, M.EVENT_FLAG )
, NVL( I.ELECTRONIC_FLAG, M.ELECTRONIC_FLAG )
, NVL( I.DOWNLOADABLE_FLAG, M.DOWNLOADABLE_FLAG )
, NVL( I.VOL_DISCOUNT_EXEMPT_FLAG, M.VOL_DISCOUNT_EXEMPT_FLAG )
, NVL( I.COUPON_EXEMPT_FLAG, M.COUPON_EXEMPT_FLAG )
, NVL( I.COMMS_NL_TRACKABLE_FLAG, M.COMMS_NL_TRACKABLE_FLAG )
, NVL( I.ASSET_CREATION_CODE, M.ASSET_CREATION_CODE )
, NVL( I.COMMS_ACTIVATION_REQD_FLAG, M.COMMS_ACTIVATION_REQD_FLAG )
, NVL( I.ORDERABLE_ON_WEB_FLAG, M.ORDERABLE_ON_WEB_FLAG )
, NVL( I.BACK_ORDERABLE_FLAG, M.BACK_ORDERABLE_FLAG )
, NVL( I.WEB_STATUS, M.WEB_STATUS )
, NVL( I.INDIVISIBLE_FLAG, M.INDIVISIBLE_FLAG )
, NVL( I.DIMENSION_UOM_CODE, M.DIMENSION_UOM_CODE )
, NVL( I.UNIT_LENGTH, M.UNIT_LENGTH )
, NVL( I.UNIT_WIDTH, M.UNIT_WIDTH )
, NVL( I.UNIT_HEIGHT, M.UNIT_HEIGHT )
, NVL( I.BULK_PICKED_FLAG, M.BULK_PICKED_FLAG )
, NVL( I.LOT_STATUS_ENABLED, M.LOT_STATUS_ENABLED )
, NVL( I.DEFAULT_LOT_STATUS_ID, M.DEFAULT_LOT_STATUS_ID )
, NVL( I.SERIAL_STATUS_ENABLED, M.SERIAL_STATUS_ENABLED )
/*Bug: 5739429 Default_serial_status_id should be defaulted based on serial_status_enabled flag.
If serial_status_enabled flag is 'N' then default_serial_status_id should be null.
, NVL( I.DEFAULT_SERIAL_STATUS_ID, M.DEFAULT_SERIAL_STATUS_ID )
*/
, NVL( I.DEFAULT_SERIAL_STATUS_ID,DECODE(NVL(I.SERIAL_STATUS_ENABLED,M.SERIAL_STATUS_ENABLED),NULL,NULL,'N',NULL,M.DEFAULT_SERIAL_STATUS_ID))
, NVL( I.INVENTORY_CARRY_PENALTY, M.INVENTORY_CARRY_PENALTY )
, NVL( I.OPERATION_SLACK_PENALTY, M.OPERATION_SLACK_PENALTY )
, NVL( I.FINANCING_ALLOWED_FLAG, M.FINANCING_ALLOWED_FLAG )
, NVL( I.EAM_ITEM_TYPE , M.EAM_ITEM_TYPE )
, NVL( I.EAM_ACTIVITY_TYPE_CODE , M.EAM_ACTIVITY_TYPE_CODE )
, NVL( I.EAM_ACTIVITY_CAUSE_CODE , M.EAM_ACTIVITY_CAUSE_CODE )
, NVL( I.EAM_ACT_NOTIFICATION_FLAG , M.EAM_ACT_NOTIFICATION_FLAG )
, NVL( I.EAM_ACT_SHUTDOWN_STATUS , M.EAM_ACT_SHUTDOWN_STATUS )
-- , NVL( I.DUAL_UOM_CONTROL , M.DUAL_UOM_CONTROL )
-- bug 14685981
,NVL(I.DUAL_UOM_CONTROL,DECODE(NVL(I.TRACKING_QUANTITY_IND,'P'),'P',1,DECODE(NVL(I.SECONDARY_DEFAULT_IND,'X'),'F',2,'D',3, 4)))
, NVL( I.SECONDARY_UOM_CODE , M.SECONDARY_UOM_CODE )
, NVL( I.DUAL_UOM_DEVIATION_HIGH , M.DUAL_UOM_DEVIATION_HIGH )
, NVL( I.DUAL_UOM_DEVIATION_LOW , M.DUAL_UOM_DEVIATION_LOW )
--, NVL( I.SERVICE_ITEM_FLAG , M.SERVICE_ITEM_FLAG )
--, NVL( I.VENDOR_WARRANTY_FLAG , M.VENDOR_WARRANTY_FLAG )
--, NVL( I.USAGE_ITEM_FLAG , M.USAGE_ITEM_FLAG )
, NVL( I.CONTRACT_ITEM_TYPE_CODE , M.CONTRACT_ITEM_TYPE_CODE )
, NVL( I.SUBSCRIPTION_DEPEND_FLAG , M.SUBSCRIPTION_DEPEND_FLAG )
--
, NVL( I.SERV_REQ_ENABLED_CODE , M.SERV_REQ_ENABLED_CODE )
, NVL( I.SERV_BILLING_ENABLED_FLAG , M.SERV_BILLING_ENABLED_FLAG )
, NVL( I.SERV_IMPORTANCE_LEVEL , M.SERV_IMPORTANCE_LEVEL )
, NVL( I.PLANNED_INV_POINT_FLAG , M.PLANNED_INV_POINT_FLAG )
, NVL( I.DEFAULT_SO_SOURCE_TYPE , M.DEFAULT_SO_SOURCE_TYPE )
, NVL( I.CREATE_SUPPLY_FLAG , M.CREATE_SUPPLY_FLAG )
, NVL( I.SUBSTITUTION_WINDOW_CODE , M.SUBSTITUTION_WINDOW_CODE )
-- If child org window_code is non-user defined,
-- do not copy master org window_days to the child org.
, NVL( I.SUBSTITUTION_WINDOW_DAYS,
DECODE( NVL(I.SUBSTITUTION_WINDOW_CODE, M.SUBSTITUTION_WINDOW_CODE),
4, M.SUBSTITUTION_WINDOW_DAYS,
NULL ) )
--Moved the dependant Lot attributes together
--(For ease of fix for bug# 2760857)
, NVL( I.LOT_SPLIT_ENABLED , M.LOT_SPLIT_ENABLED )
, NVL( I.LOT_MERGE_ENABLED , M.LOT_MERGE_ENABLED )
, NVL( I.LOT_TRANSLATE_ENABLED , M.LOT_TRANSLATE_ENABLED )
--Added as part of 11.5.9 ENH
, NVL( I.LOT_SUBSTITUTION_ENABLED , M.LOT_SUBSTITUTION_ENABLED )
, NVL( I.MINIMUM_LICENSE_QUANTITY , M.MINIMUM_LICENSE_QUANTITY )
, NVL( I.EAM_ACTIVITY_SOURCE_CODE , M.EAM_ACTIVITY_SOURCE_CODE )
, NVL( I.IB_ITEM_INSTANCE_CLASS , M.IB_ITEM_INSTANCE_CLASS )
, NVL( I.CONFIG_MODEL_TYPE , M.CONFIG_MODEL_TYPE )
--2740503: Defaulting lifecycle-phase from master org.
, NVL( I.LIFECYCLE_ID , M.LIFECYCLE_ID )
, NVL( I.CURRENT_PHASE_ID , M.CURRENT_PHASE_ID )
--Added as part of 11.5.10 ENH
, NVL( I.TRACKING_QUANTITY_IND , M.TRACKING_QUANTITY_IND )
, NVL( I.ONT_PRICING_QTY_SOURCE , M.ONT_PRICING_QTY_SOURCE )
, NVL( I.SECONDARY_DEFAULT_IND , M.SECONDARY_DEFAULT_IND )
, NVL( I.CONFIG_ORGS , M.CONFIG_ORGS )
, NVL( I.CONFIG_MATCH , M.CONFIG_MATCH )
, NVL(I.VMI_MINIMUM_UNITS , M.VMI_MINIMUM_UNITS )
, NVL(I.VMI_MINIMUM_DAYS , M.VMI_MINIMUM_DAYS )
, NVL(I.VMI_MAXIMUM_UNITS , M.VMI_MAXIMUM_UNITS )
, NVL(I.VMI_MAXIMUM_DAYS , M.VMI_MAXIMUM_DAYS )
, NVL(I.VMI_FIXED_ORDER_QUANTITY , M.VMI_FIXED_ORDER_QUANTITY )
, NVL(I.SO_AUTHORIZATION_FLAG , M.SO_AUTHORIZATION_FLAG )
, NVL(I.CONSIGNED_FLAG , M.CONSIGNED_FLAG )
, NVL(I.ASN_AUTOEXPIRE_FLAG , M.ASN_AUTOEXPIRE_FLAG )
, NVL(I.VMI_FORECAST_TYPE , M.VMI_FORECAST_TYPE )
, NVL(I.FORECAST_HORIZON , M.FORECAST_HORIZON )
, NVL(I.EXCLUDE_FROM_BUDGET_FLAG , M.EXCLUDE_FROM_BUDGET_FLAG )
, NVL(I.DAYS_TGT_INV_SUPPLY , M.DAYS_TGT_INV_SUPPLY )
, NVL(I.DAYS_TGT_INV_WINDOW , M.DAYS_TGT_INV_WINDOW )
, NVL(I.DAYS_MAX_INV_SUPPLY , M.DAYS_MAX_INV_SUPPLY )
, NVL(I.DAYS_MAX_INV_WINDOW , M.DAYS_MAX_INV_WINDOW )
, NVL(I.DRP_PLANNED_FLAG , M.DRP_PLANNED_FLAG )
, NVL(I.CRITICAL_COMPONENT_FLAG , M.CRITICAL_COMPONENT_FLAG )
, NVL(I.CONTINOUS_TRANSFER , M.CONTINOUS_TRANSFER )
, NVL(I.CONVERGENCE , M.CONVERGENCE )
, NVL(I.DIVERGENCE , M.DIVERGENCE )
/* Start Bug 3713912 */
, NVL(I.LOT_DIVISIBLE_FLAG , M.LOT_DIVISIBLE_FLAG )
, NVL(I.GRADE_CONTROL_FLAG , M.GRADE_CONTROL_FLAG )
, NVL(I.DEFAULT_GRADE , M.DEFAULT_GRADE )
, NVL(I.CHILD_LOT_FLAG , M.CHILD_LOT_FLAG )
, NVL(I.PARENT_CHILD_GENERATION_FLAG , M.PARENT_CHILD_GENERATION_FLAG )
, NVL(I.CHILD_LOT_PREFIX , M.CHILD_LOT_PREFIX )
, NVL(I.CHILD_LOT_STARTING_NUMBER , M.CHILD_LOT_STARTING_NUMBER )
, NVL(I.CHILD_LOT_VALIDATION_FLAG , M.CHILD_LOT_VALIDATION_FLAG )
, NVL(I.COPY_LOT_ATTRIBUTE_FLAG , M.COPY_LOT_ATTRIBUTE_FLAG )
--5349389, NVL(I.RECIPE_ENABLED_FLAG , M.RECIPE_ENABLED_FLAG )
, NVL(I.PROCESS_QUALITY_ENABLED_FLAG , M.PROCESS_QUALITY_ENABLED_FLAG )
--5349389, NVL(I.PROCESS_EXECUTION_ENABLED_FLAG , M.PROCESS_EXECUTION_ENABLED_FLAG )
, NVL(I.PROCESS_COSTING_ENABLED_FLAG , M.PROCESS_COSTING_ENABLED_FLAG )
, I.PROCESS_SUPPLY_SUBINVENTORY /* this should not default from master */
, I.PROCESS_SUPPLY_LOCATOR_ID /* this should not default from master */
, I.PROCESS_YIELD_SUBINVENTORY /* this should not default from master */
, I.PROCESS_YIELD_LOCATOR_ID /* this should not default from master */
, NVL(I.HAZARDOUS_MATERIAL_FLAG , M.HAZARDOUS_MATERIAL_FLAG )
, NVL(I.CAS_NUMBER , M.CAS_NUMBER )
, NVL(I.RETEST_INTERVAL , M.RETEST_INTERVAL )
, NVL(I.EXPIRATION_ACTION_INTERVAL , M.EXPIRATION_ACTION_INTERVAL )
, NVL(I.EXPIRATION_ACTION_CODE , M.EXPIRATION_ACTION_CODE )
, NVL(I.MATURITY_DAYS , M.MATURITY_DAYS )
, NVL(I.HOLD_DAYS , M.HOLD_DAYS )
/* End Bug 3713912 */
--R12 Enhancement
, NVL(I.REPAIR_LEADTIME ,M.REPAIR_LEADTIME )
, NVL(I.REPAIR_YIELD ,M.REPAIR_YIELD )
, NVL(I.PREPOSITION_POINT ,M.PREPOSITION_POINT )
, NVL(I.REPAIR_PROGRAM ,M.REPAIR_PROGRAM )
, NVL(I.CHARGE_PERIODICITY_CODE ,M.CHARGE_PERIODICITY_CODE )
, NVL(I.SUBCONTRACTING_COMPONENT ,M.SUBCONTRACTING_COMPONENT )
, NVL(I.OUTSOURCED_ASSEMBLY ,M.OUTSOURCED_ASSEMBLY )
/* R12 FPC Attributes */
, NVL(I.GDSN_OUTBOUND_ENABLED_FLAG ,M.GDSN_OUTBOUND_ENABLED_FLAG )
, NVL(I.TRADE_ITEM_DESCRIPTOR ,M.TRADE_ITEM_DESCRIPTOR )
, NVL(I.STYLE_ITEM_FLAG ,M.STYLE_ITEM_FLAG )
, NVL(I.STYLE_ITEM_ID ,M.STYLE_ITEM_ID )
FROM
mtl_system_items_interface M
WHERE
M.inventory_item_id = item_id AND
M.organization_id = master_org_id AND
M.set_process_id = xset_id AND
M.process_flag in (1,60000+1)) /*masters are moved to 60000+ to before calling child create*/
WHERE I.rowid = p_rowid;
SELECT primary_unit_of_measure, primary_uom_code
INTO l_Primary_Unit_of_Measure, l_Primary_UOM_Code
FROM MTL_SYSTEM_ITEMS_INTERFACE
WHERE rowid = p_rowid;
SELECT uom_code INTO l_Primary_UOM_Code
FROM mtl_all_primary_uoms_vv
WHERE inventory_item_id = 0
AND unit_of_measure_tl = l_Primary_Unit_of_Measure;*/
SELECT uom_code
INTO l_Primary_UOM_Code
FROM mtl_units_of_measure_tl
WHERE language = USERENV('LANG')
AND unit_of_measure = l_Primary_Unit_of_Measure;
SELECT uom_code, unit_of_measure
INTO l_Primary_UOM_Code, l_base_primary_UOM
FROM mtl_units_of_measure_tl
WHERE language = USERENV('LANG')
AND unit_of_measure_tl = l_Primary_Unit_of_Measure;
UPDATE MTL_SYSTEM_ITEMS_INTERFACE I
SET
( I.LAST_UPDATED_BY,
I.CREATED_BY,
I.SUMMARY_FLAG,
I.ENABLED_FLAG,
I.START_DATE_ACTIVE,
I.END_DATE_ACTIVE,
I.DESCRIPTION,
I.LONG_DESCRIPTION,
I.BUYER_ID,
I.ACCOUNTING_RULE_ID,
I.INVOICING_RULE_ID,
I.SEGMENT1,
I.SEGMENT2,
I.SEGMENT3,
I.SEGMENT4,
I.SEGMENT5,
I.SEGMENT6,
I.SEGMENT7,
I.SEGMENT8,
I.SEGMENT9,
I.SEGMENT10,
I.SEGMENT11,
I.SEGMENT12,
I.SEGMENT13,
I.SEGMENT14,
I.SEGMENT15,
I.SEGMENT16,
I.SEGMENT17,
I.SEGMENT18,
I.SEGMENT19,
I.SEGMENT20,
I.ATTRIBUTE_CATEGORY,
I.ATTRIBUTE1,
I.ATTRIBUTE2,
I.ATTRIBUTE3,
I.ATTRIBUTE4,
I.ATTRIBUTE5,
I.ATTRIBUTE6,
I.ATTRIBUTE7,
I.ATTRIBUTE8,
I.ATTRIBUTE9,
I.ATTRIBUTE10,
I.ATTRIBUTE11,
I.ATTRIBUTE12,
I.ATTRIBUTE13,
I.ATTRIBUTE14,
I.ATTRIBUTE15,
/* Start Bug 3713912 */
I.ATTRIBUTE16,
I.ATTRIBUTE17,
I.ATTRIBUTE18,
I.ATTRIBUTE19,
I.ATTRIBUTE20,
I.ATTRIBUTE21,
I.ATTRIBUTE22,
I.ATTRIBUTE23,
I.ATTRIBUTE24,
I.ATTRIBUTE25,
I.ATTRIBUTE26,
I.ATTRIBUTE27,
I.ATTRIBUTE28,
I.ATTRIBUTE29,
I.ATTRIBUTE30,
/* End Bug 3713912 */
I.GLOBAL_ATTRIBUTE_CATEGORY,
I.GLOBAL_ATTRIBUTE1,
I.GLOBAL_ATTRIBUTE2,
I.GLOBAL_ATTRIBUTE3,
I.GLOBAL_ATTRIBUTE4,
I.GLOBAL_ATTRIBUTE5,
I.GLOBAL_ATTRIBUTE6,
I.GLOBAL_ATTRIBUTE7,
I.GLOBAL_ATTRIBUTE8,
I.GLOBAL_ATTRIBUTE9,
I.GLOBAL_ATTRIBUTE10,
I.GLOBAL_ATTRIBUTE11,
I.GLOBAL_ATTRIBUTE12,
I.GLOBAL_ATTRIBUTE13,
I.GLOBAL_ATTRIBUTE14,
I.GLOBAL_ATTRIBUTE15,
I.GLOBAL_ATTRIBUTE16,
I.GLOBAL_ATTRIBUTE17,
I.GLOBAL_ATTRIBUTE18,
I.GLOBAL_ATTRIBUTE19,
I.GLOBAL_ATTRIBUTE20,
I.PURCHASING_ITEM_FLAG,
I.SHIPPABLE_ITEM_FLAG,
I.CUSTOMER_ORDER_FLAG,
I.INTERNAL_ORDER_FLAG,
I.INVENTORY_ITEM_FLAG,
I.ENG_ITEM_FLAG,
I.INVENTORY_ASSET_FLAG,
-- * For the bug 3888752 from its base bug --ANMURALI
-- I.PURCHASING_ENABLED_FLAG,
-- I.CUSTOMER_ORDER_ENABLED_FLAG,
-- I.INTERNAL_ORDER_ENABLED_FLAG,
I.SO_TRANSACTIONS_FLAG,
-- I.MTL_TRANSACTIONS_ENABLED_FLAG,
-- I.STOCK_ENABLED_FLAG,
-- I.BOM_ENABLED_FLAG,
-- I.BUILD_IN_WIP_FLAG,
I.REVISION_QTY_CONTROL_CODE,
I.ITEM_CATALOG_GROUP_ID,
I.CATALOG_STATUS_FLAG,
I.RETURNABLE_FLAG,
I.DEFAULT_SHIPPING_ORG,
I.COLLATERAL_FLAG,
I.TAXABLE_FLAG,
I.PURCHASING_TAX_CODE,
I.QTY_RCV_EXCEPTION_CODE,
I.ALLOW_ITEM_DESC_UPDATE_FLAG,
I.INSPECTION_REQUIRED_FLAG,
I.RECEIPT_REQUIRED_FLAG,
I.MARKET_PRICE,
I.HAZARD_CLASS_ID,
I.RFQ_REQUIRED_FLAG,
I.QTY_RCV_TOLERANCE,
I.LIST_PRICE_PER_UNIT,
I.UN_NUMBER_ID,
I.PRICE_TOLERANCE_PERCENT,
I.ASSET_CATEGORY_ID,
I.ROUNDING_FACTOR,
I.UNIT_OF_ISSUE,
I.ENFORCE_SHIP_TO_LOCATION_CODE,
I.ALLOW_SUBSTITUTE_RECEIPTS_FLAG,
I.ALLOW_UNORDERED_RECEIPTS_FLAG,
I.ALLOW_EXPRESS_DELIVERY_FLAG,
I.DAYS_EARLY_RECEIPT_ALLOWED,
I.DAYS_LATE_RECEIPT_ALLOWED,
I.RECEIPT_DAYS_EXCEPTION_CODE,
I.RECEIVING_ROUTING_ID,
I.INVOICE_CLOSE_TOLERANCE,
I.RECEIVE_CLOSE_TOLERANCE,
I.AUTO_LOT_ALPHA_PREFIX,
I.START_AUTO_LOT_NUMBER,
I.LOT_CONTROL_CODE,
I.SHELF_LIFE_CODE,
I.SHELF_LIFE_DAYS,
I.SERIAL_NUMBER_CONTROL_CODE,
I.START_AUTO_SERIAL_NUMBER,
I.AUTO_SERIAL_ALPHA_PREFIX,
I.SOURCE_TYPE,
--* Commented for Bug #3764605 : Below attributes are org controlled.
--I.SOURCE_ORGANIZATION_ID,
--I.SOURCE_SUBINVENTORY,
--* End of Bug #3764605
I.RESTRICT_SUBINVENTORIES_CODE,
I.UNIT_WEIGHT,
I.WEIGHT_UOM_CODE,
I.VOLUME_UOM_CODE,
I.UNIT_VOLUME,
I.RESTRICT_LOCATORS_CODE,
I.LOCATION_CONTROL_CODE,
I.SHRINKAGE_RATE,
I.ACCEPTABLE_EARLY_DAYS,
I.PLANNING_TIME_FENCE_CODE,
I.DEMAND_TIME_FENCE_CODE,
I.LEAD_TIME_LOT_SIZE,
I.STD_LOT_SIZE,
I.CUM_MANUFACTURING_LEAD_TIME,
I.OVERRUN_PERCENTAGE,
I.MRP_CALCULATE_ATP_FLAG,
I.ACCEPTABLE_RATE_INCREASE,
I.ACCEPTABLE_RATE_DECREASE,
I.CUMULATIVE_TOTAL_LEAD_TIME,
I.PLANNING_TIME_FENCE_DAYS,
I.DEMAND_TIME_FENCE_DAYS,
I.END_ASSEMBLY_PEGGING_FLAG,
I.REPETITIVE_PLANNING_FLAG,
I.BOM_ITEM_TYPE,
I.PICK_COMPONENTS_FLAG,
I.REPLENISH_TO_ORDER_FLAG,
I.BASE_ITEM_ID,
I.ATP_COMPONENTS_FLAG,
I.ATP_FLAG,
I.FIXED_LEAD_TIME,
I.VARIABLE_LEAD_TIME,
I.WIP_SUPPLY_LOCATOR_ID,
I.WIP_SUPPLY_TYPE,
I.WIP_SUPPLY_SUBINVENTORY,
I.PRIMARY_UOM_CODE,
I.PRIMARY_UNIT_OF_MEASURE,
I.ALLOWED_UNITS_LOOKUP_CODE,
I.DEFAULT_INCLUDE_IN_ROLLUP_FLAG,
I.INVENTORY_ITEM_STATUS_CODE,
I.INVENTORY_PLANNING_CODE,
I.PLANNER_CODE,
I.PLANNING_MAKE_BUY_CODE,
I.FIXED_LOT_MULTIPLIER,
I.ROUNDING_CONTROL_TYPE,
I.CARRYING_COST,
I.POSTPROCESSING_LEAD_TIME,
I.PREPROCESSING_LEAD_TIME,
I.FULL_LEAD_TIME,
I.ORDER_COST,
I.MRP_SAFETY_STOCK_PERCENT,
I.MRP_SAFETY_STOCK_CODE,
I.MIN_MINMAX_QUANTITY,
I.MAX_MINMAX_QUANTITY,
I.MINIMUM_ORDER_QUANTITY,
I.FIXED_ORDER_QUANTITY,
I.FIXED_DAYS_SUPPLY,
I.MAXIMUM_ORDER_QUANTITY,
I.ATP_RULE_ID,
I.PICKING_RULE_ID,
I.RESERVABLE_TYPE,
I.POSITIVE_MEASUREMENT_ERROR,
I.NEGATIVE_MEASUREMENT_ERROR,
I.ENGINEERING_ECN_CODE,
I.ENGINEERING_ITEM_ID,
I.ENGINEERING_DATE,
I.SERVICE_STARTING_DELAY,
I.SERVICEABLE_COMPONENT_FLAG,
I.SERVICEABLE_PRODUCT_FLAG,
I.BASE_WARRANTY_SERVICE_ID,
I.PAYMENT_TERMS_ID,
I.PREVENTIVE_MAINTENANCE_FLAG,
I.PRIMARY_SPECIALIST_ID,
I.SECONDARY_SPECIALIST_ID,
I.SERVICEABLE_ITEM_CLASS_ID,
I.TIME_BILLABLE_FLAG,
I.MATERIAL_BILLABLE_FLAG,
I.EXPENSE_BILLABLE_FLAG,
I.PRORATE_SERVICE_FLAG,
I.COVERAGE_SCHEDULE_ID,
I.SERVICE_DURATION_PERIOD_CODE,
I.SERVICE_DURATION,
I.WARRANTY_VENDOR_ID,
I.MAX_WARRANTY_AMOUNT,
I.RESPONSE_TIME_PERIOD_CODE,
I.RESPONSE_TIME_VALUE,
I.NEW_REVISION_CODE,
I.INVOICEABLE_ITEM_FLAG,
I.TAX_CODE,
-- I.INVOICE_ENABLED_FLAG,
I.MUST_USE_APPROVED_VENDOR_FLAG,
I.REQUEST_ID,
I.PROGRAM_APPLICATION_ID,
I.PROGRAM_ID,
I.PROGRAM_UPDATE_DATE,
I.OUTSIDE_OPERATION_FLAG,
I.OUTSIDE_OPERATION_UOM_TYPE,
I.SAFETY_STOCK_BUCKET_DAYS,
I.AUTO_REDUCE_MPS,
I.COSTING_ENABLED_FLAG,
I.CYCLE_COUNT_ENABLED_FLAG,
I.AUTO_CREATED_CONFIG_FLAG,
I.ITEM_TYPE,
I.MODEL_CONFIG_CLAUSE_NAME,
I.SHIP_MODEL_COMPLETE_FLAG,
I.MRP_PLANNING_CODE,
I.ATO_FORECAST_CONTROL,
I.RETURN_INSPECTION_REQUIREMENT,
I.RELEASE_TIME_FENCE_CODE,
I.RELEASE_TIME_FENCE_DAYS,
I.CONTAINER_ITEM_FLAG,
I.CONTAINER_TYPE_CODE,
I.INTERNAL_VOLUME,
I.MAXIMUM_LOAD_WEIGHT,
I.MINIMUM_FILL_PERCENT,
I.VEHICLE_ITEM_FLAG,
I.CHECK_SHORTAGES_FLAG /*CK 18NOV98 Added new attribute*/
, I.EFFECTIVITY_CONTROL
, I.OVERCOMPLETION_TOLERANCE_TYPE
, I.OVERCOMPLETION_TOLERANCE_VALUE
, I.OVER_SHIPMENT_TOLERANCE
, I.UNDER_SHIPMENT_TOLERANCE
, I.OVER_RETURN_TOLERANCE
, I.UNDER_RETURN_TOLERANCE
, I.EQUIPMENT_TYPE
, I.RECOVERED_PART_DISP_CODE
, I.DEFECT_TRACKING_ON_FLAG
, I.EVENT_FLAG
, I.ELECTRONIC_FLAG
, I.DOWNLOADABLE_FLAG
, I.VOL_DISCOUNT_EXEMPT_FLAG
, I.COUPON_EXEMPT_FLAG
, I.COMMS_NL_TRACKABLE_FLAG
, I.ASSET_CREATION_CODE
, I.COMMS_ACTIVATION_REQD_FLAG
, I.ORDERABLE_ON_WEB_FLAG
, I.BACK_ORDERABLE_FLAG
, I.WEB_STATUS
, I.INDIVISIBLE_FLAG
, I.DIMENSION_UOM_CODE
, I.UNIT_LENGTH
, I.UNIT_WIDTH
, I.UNIT_HEIGHT
, I.BULK_PICKED_FLAG
, I.LOT_STATUS_ENABLED
, I.DEFAULT_LOT_STATUS_ID
, I.SERIAL_STATUS_ENABLED
, I.DEFAULT_SERIAL_STATUS_ID
, I.INVENTORY_CARRY_PENALTY
, I.OPERATION_SLACK_PENALTY
, I.FINANCING_ALLOWED_FLAG
, I.EAM_ITEM_TYPE
, I.EAM_ACTIVITY_TYPE_CODE
, I.EAM_ACTIVITY_CAUSE_CODE
, I.EAM_ACT_NOTIFICATION_FLAG
, I.EAM_ACT_SHUTDOWN_STATUS
, I.DUAL_UOM_CONTROL
, I.SECONDARY_UOM_CODE
, I.DUAL_UOM_DEVIATION_HIGH
, I.DUAL_UOM_DEVIATION_LOW
--, I.SERVICE_ITEM_FLAG
--, I.VENDOR_WARRANTY_FLAG
--, I.USAGE_ITEM_FLAG
, I.CONTRACT_ITEM_TYPE_CODE
, I.SUBSCRIPTION_DEPEND_FLAG
--
, I.SERV_REQ_ENABLED_CODE
, I.SERV_BILLING_ENABLED_FLAG
, I.SERV_IMPORTANCE_LEVEL
, I.PLANNED_INV_POINT_FLAG
, I.DEFAULT_SO_SOURCE_TYPE
, I.CREATE_SUPPLY_FLAG
, I.SUBSTITUTION_WINDOW_CODE
, I.SUBSTITUTION_WINDOW_DAYS
--Moved the dependant Lot attributes together
--(For ease of fix for bug# 2760857)
, I.LOT_SPLIT_ENABLED
, I.LOT_MERGE_ENABLED
, I.LOT_TRANSLATE_ENABLED
--Added as part of 11.5.9
, I.LOT_SUBSTITUTION_ENABLED
, I.MINIMUM_LICENSE_QUANTITY
, I.EAM_ACTIVITY_SOURCE_CODE
, I.IB_ITEM_INSTANCE_CLASS
, I.CONFIG_MODEL_TYPE
--2740503: Defaulting lifecycle-phase from master org.
, I.LIFECYCLE_ID
, I.CURRENT_PHASE_ID
--Added as part of 11.5.10
, I.TRACKING_QUANTITY_IND
, I.ONT_PRICING_QTY_SOURCE
, I.SECONDARY_DEFAULT_IND
, I.CONFIG_ORGS
, I.CONFIG_MATCH
, I.VMI_MINIMUM_UNITS
, I.VMI_MINIMUM_DAYS
, I.VMI_MAXIMUM_UNITS
, I.VMI_MAXIMUM_DAYS
, I.VMI_FIXED_ORDER_QUANTITY
, I.SO_AUTHORIZATION_FLAG
, I.CONSIGNED_FLAG
, I.ASN_AUTOEXPIRE_FLAG
, I.VMI_FORECAST_TYPE
, I.FORECAST_HORIZON
, I.EXCLUDE_FROM_BUDGET_FLAG
, I.DAYS_TGT_INV_SUPPLY
, I.DAYS_TGT_INV_WINDOW
, I.DAYS_MAX_INV_SUPPLY
, I.DAYS_MAX_INV_WINDOW
, I.DRP_PLANNED_FLAG
, I.CRITICAL_COMPONENT_FLAG
, I.CONTINOUS_TRANSFER
, I.CONVERGENCE
, I.DIVERGENCE
/* Start Bug 3713912 */
, I.LOT_DIVISIBLE_FLAG
, I.GRADE_CONTROL_FLAG
, I.DEFAULT_GRADE
, I.CHILD_LOT_FLAG
, I.PARENT_CHILD_GENERATION_FLAG
, I.CHILD_LOT_PREFIX
, I.CHILD_LOT_STARTING_NUMBER
, I.CHILD_LOT_VALIDATION_FLAG
, I.COPY_LOT_ATTRIBUTE_FLAG
--5349389 , I.RECIPE_ENABLED_FLAG
, I.PROCESS_QUALITY_ENABLED_FLAG
--5349389 , I.PROCESS_EXECUTION_ENABLED_FLAG
, I.PROCESS_COSTING_ENABLED_FLAG
, I.PROCESS_SUPPLY_SUBINVENTORY
, I.PROCESS_SUPPLY_LOCATOR_ID
, I.PROCESS_YIELD_SUBINVENTORY
, I.PROCESS_YIELD_LOCATOR_ID
, I.HAZARDOUS_MATERIAL_FLAG
, I.CAS_NUMBER
, I.RETEST_INTERVAL
, I.EXPIRATION_ACTION_INTERVAL
, I.EXPIRATION_ACTION_CODE
, I.MATURITY_DAYS
, I.HOLD_DAYS
/* End Bug 3713912 */
--R12 Enhancement
, I.REPAIR_LEADTIME
, I.REPAIR_YIELD
, I.PREPOSITION_POINT
, I.REPAIR_PROGRAM
, I.CHARGE_PERIODICITY_CODE
, I.SUBCONTRACTING_COMPONENT
, I.OUTSOURCED_ASSEMBLY
/* FPC Attributes */
, I.GDSN_OUTBOUND_ENABLED_FLAG
, I.TRADE_ITEM_DESCRIPTOR
, I.STYLE_ITEM_FLAG
, I.STYLE_ITEM_ID
) = (
SELECT
master_org_id, /* LAST_UPDATED_BY */
decode(i.created_by,-99,i.created_by,l_created_by), /*NP Comment here is where created_by is set
to 1 to reflect item exists in msi */
NVL(I.SUMMARY_FLAG,M.SUMMARY_FLAG),
NVL(I.ENABLED_FLAG,M.ENABLED_FLAG),
NVL(I.START_DATE_ACTIVE,M.START_DATE_ACTIVE),
NVL(I.END_DATE_ACTIVE,M.END_DATE_ACTIVE),
NVL(I.DESCRIPTION, MT.DESCRIPTION),
NVL(I.LONG_DESCRIPTION, MT.LONG_DESCRIPTION),
NVL(I.BUYER_ID,M.BUYER_ID),
NVL(I.ACCOUNTING_RULE_ID,M.ACCOUNTING_RULE_ID),
NVL(I.INVOICING_RULE_ID,M.INVOICING_RULE_ID),
NVL(I.SEGMENT1,M.SEGMENT1),
NVL(I.SEGMENT2,M.SEGMENT2),
NVL(I.SEGMENT3,M.SEGMENT3),
NVL(I.SEGMENT4,M.SEGMENT4),
NVL(I.SEGMENT5,M.SEGMENT5),
NVL(I.SEGMENT6,M.SEGMENT6),
NVL(I.SEGMENT7,M.SEGMENT7),
NVL(I.SEGMENT8,M.SEGMENT8),
NVL(I.SEGMENT9,M.SEGMENT9),
NVL(I.SEGMENT10,M.SEGMENT10),
NVL(I.SEGMENT11,M.SEGMENT11),
NVL(I.SEGMENT12,M.SEGMENT12),
NVL(I.SEGMENT13,M.SEGMENT13),
NVL(I.SEGMENT14,M.SEGMENT14),
NVL(I.SEGMENT15,M.SEGMENT15),
NVL(I.SEGMENT16,M.SEGMENT16),
NVL(I.SEGMENT17,M.SEGMENT17),
NVL(I.SEGMENT18,M.SEGMENT18),
NVL(I.SEGMENT19,M.SEGMENT19),
NVL(I.SEGMENT20,M.SEGMENT20),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE_CATEGORY,M.ATTRIBUTE_CATEGORY),
'Y' , org_id
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE1,M.ATTRIBUTE1),
'Y' , NULL
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE2,M.ATTRIBUTE2),
'Y' , NULL
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE3,M.ATTRIBUTE3),
'Y' , NULL
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE4,M.ATTRIBUTE4),
'Y' , NULL
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE5,M.ATTRIBUTE5),
'Y' , NULL
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE6,M.ATTRIBUTE6),
'Y' , NULL
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE7,M.ATTRIBUTE7),
'Y' , NULL
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE8,M.ATTRIBUTE8),
'Y' , NULL
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE9,M.ATTRIBUTE9),
'Y' , NULL
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE10,M.ATTRIBUTE10),
'Y' , NULL
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE11,M.ATTRIBUTE11),
'Y' , NULL
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE12,M.ATTRIBUTE12),
'Y' , NULL
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE13,M.ATTRIBUTE13),
'Y' , NULL
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE14,M.ATTRIBUTE14),
'Y' , NULL
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE15,M.ATTRIBUTE15),
'Y' , NULL
),
/* End Bug 3713912 */
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE16, M.ATTRIBUTE16) ,
'Y' , NULL
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE17, M.ATTRIBUTE17) ,
'Y' , NULL
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE18, M.ATTRIBUTE18) ,
'Y' , NULL
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE19, M.ATTRIBUTE19) ,
'Y' , NULL
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE20, M.ATTRIBUTE20) ,
'Y' , NULL
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE21, M.ATTRIBUTE21) ,
'Y' , NULL
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE22, M.ATTRIBUTE22) ,
'Y' , NULL
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE23, M.ATTRIBUTE23) ,
'Y' , NULL
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE24, M.ATTRIBUTE24) ,
'Y' , NULL
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE25, M.ATTRIBUTE25) ,
'Y' , NULL
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE26, M.ATTRIBUTE26) ,
'Y' , NULL
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE27, M.ATTRIBUTE27) ,
'Y' , NULL
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE28, M.ATTRIBUTE28) ,
'Y' , NULL
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE29, M.ATTRIBUTE29) ,
'Y' , NULL
),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE30, M.ATTRIBUTE30) ,
'Y' , NULL
),
/* End Bug 3713912 */
NVL(I.GLOBAL_ATTRIBUTE_CATEGORY,M.GLOBAL_ATTRIBUTE_CATEGORY),
NVL(I.GLOBAL_ATTRIBUTE1,M.GLOBAL_ATTRIBUTE1),
NVL(I.GLOBAL_ATTRIBUTE2,M.GLOBAL_ATTRIBUTE2),
NVL(I.GLOBAL_ATTRIBUTE3,M.GLOBAL_ATTRIBUTE3),
NVL(I.GLOBAL_ATTRIBUTE4,M.GLOBAL_ATTRIBUTE4),
NVL(I.GLOBAL_ATTRIBUTE5,M.GLOBAL_ATTRIBUTE5),
NVL(I.GLOBAL_ATTRIBUTE6,M.GLOBAL_ATTRIBUTE6),
NVL(I.GLOBAL_ATTRIBUTE7,M.GLOBAL_ATTRIBUTE7),
NVL(I.GLOBAL_ATTRIBUTE8,M.GLOBAL_ATTRIBUTE8),
NVL(I.GLOBAL_ATTRIBUTE9,M.GLOBAL_ATTRIBUTE9),
NVL(I.GLOBAL_ATTRIBUTE10,M.GLOBAL_ATTRIBUTE10),
NVL(I.GLOBAL_ATTRIBUTE11,M.GLOBAL_ATTRIBUTE11),
NVL(I.GLOBAL_ATTRIBUTE12,M.GLOBAL_ATTRIBUTE12),
NVL(I.GLOBAL_ATTRIBUTE13,M.GLOBAL_ATTRIBUTE13),
NVL(I.GLOBAL_ATTRIBUTE14,M.GLOBAL_ATTRIBUTE14),
NVL(I.GLOBAL_ATTRIBUTE15,M.GLOBAL_ATTRIBUTE15),
NVL(I.GLOBAL_ATTRIBUTE16,M.GLOBAL_ATTRIBUTE16),
NVL(I.GLOBAL_ATTRIBUTE17,M.GLOBAL_ATTRIBUTE17),
NVL(I.GLOBAL_ATTRIBUTE18,M.GLOBAL_ATTRIBUTE18),
NVL(I.GLOBAL_ATTRIBUTE19,M.GLOBAL_ATTRIBUTE19),
NVL(I.GLOBAL_ATTRIBUTE20,M.GLOBAL_ATTRIBUTE20),
NVL(I.PURCHASING_ITEM_FLAG,M.PURCHASING_ITEM_FLAG),
DECODE(I.INTERNAL_ORDER_FLAG, 'Y','Y', DECODE(M.INTERNAL_ORDER_FLAG, 'Y','Y',
nvl(I.SHIPPABLE_ITEM_FLAG,M.SHIPPABLE_ITEM_FLAG))),
NVL(I.CUSTOMER_ORDER_FLAG,M.CUSTOMER_ORDER_FLAG),
NVL(I.INTERNAL_ORDER_FLAG,M.INTERNAL_ORDER_FLAG),
NVL(I.INVENTORY_ITEM_FLAG,M.INVENTORY_ITEM_FLAG),
NVL(I.ENG_ITEM_FLAG,M.ENG_ITEM_FLAG),
NVL(I.INVENTORY_ASSET_FLAG,M.INVENTORY_ASSET_FLAG),
-- * For the bug 3888752 from its base bug --ANMURALI
-- NVL(I.PURCHASING_ENABLED_FLAG,M.PURCHASING_ENABLED_FLAG),
-- NVL(I.CUSTOMER_ORDER_ENABLED_FLAG,M.CUSTOMER_ORDER_ENABLED_FLAG),
-- NVL(I.INTERNAL_ORDER_ENABLED_FLAG,M.INTERNAL_ORDER_ENABLED_FLAG),
NVL(I.SO_TRANSACTIONS_FLAG,M.SO_TRANSACTIONS_FLAG),
-- NVL(I.MTL_TRANSACTIONS_ENABLED_FLAG,M.MTL_TRANSACTIONS_ENABLED_FLAG),
-- NVL(I.STOCK_ENABLED_FLAG,M.STOCK_ENABLED_FLAG),
-- NVL(I.BOM_ENABLED_FLAG,M.BOM_ENABLED_FLAG),
-- NVL(I.BUILD_IN_WIP_FLAG,M.BUILD_IN_WIP_FLAG),
NVL(I.REVISION_QTY_CONTROL_CODE,M.REVISION_QTY_CONTROL_CODE),
NVL(I.ITEM_CATALOG_GROUP_ID,M.ITEM_CATALOG_GROUP_ID),
NVL(I.CATALOG_STATUS_FLAG,M.CATALOG_STATUS_FLAG),
NVL(I.RETURNABLE_FLAG,M.RETURNABLE_FLAG),
NVL(I.DEFAULT_SHIPPING_ORG,M.DEFAULT_SHIPPING_ORG),
NVL(I.COLLATERAL_FLAG,M.COLLATERAL_FLAG),
NVL(I.TAXABLE_FLAG,M.TAXABLE_FLAG),
-- NVL(I.PURCHASING_TAX_CODE,M.PURCHASING_TAX_CODE),
NVL(I.PURCHASING_TAX_CODE,DECODE(NVL(I.TAXABLE_FLAG,M.TAXABLE_FLAG),NULL,NULL,'N',NULL,M.PURCHASING_TAX_CODE)),
NVL(I.QTY_RCV_EXCEPTION_CODE,M.QTY_RCV_EXCEPTION_CODE),
NVL(I.ALLOW_ITEM_DESC_UPDATE_FLAG,M.ALLOW_ITEM_DESC_UPDATE_FLAG),
NVL(I.INSPECTION_REQUIRED_FLAG,M.INSPECTION_REQUIRED_FLAG),
NVL(I.RECEIPT_REQUIRED_FLAG,M.RECEIPT_REQUIRED_FLAG),
NVL(I.MARKET_PRICE,M.MARKET_PRICE),
NVL(I.HAZARD_CLASS_ID,M.HAZARD_CLASS_ID),
NVL(I.RFQ_REQUIRED_FLAG,M.RFQ_REQUIRED_FLAG),
NVL(I.QTY_RCV_TOLERANCE,M.QTY_RCV_TOLERANCE),
NVL(I.LIST_PRICE_PER_UNIT,M.LIST_PRICE_PER_UNIT),
NVL(I.UN_NUMBER_ID,M.UN_NUMBER_ID),
NVL(I.PRICE_TOLERANCE_PERCENT,M.PRICE_TOLERANCE_PERCENT),
NVL(I.ASSET_CATEGORY_ID,M.ASSET_CATEGORY_ID),
NVL(I.ROUNDING_FACTOR,M.ROUNDING_FACTOR),
NVL(I.UNIT_OF_ISSUE,M.UNIT_OF_ISSUE),
NVL(I.ENFORCE_SHIP_TO_LOCATION_CODE,M.ENFORCE_SHIP_TO_LOCATION_CODE),
NVL(I.ALLOW_SUBSTITUTE_RECEIPTS_FLAG,M.ALLOW_SUBSTITUTE_RECEIPTS_FLAG),
NVL(I.ALLOW_UNORDERED_RECEIPTS_FLAG,M.ALLOW_UNORDERED_RECEIPTS_FLAG),
NVL(I.ALLOW_EXPRESS_DELIVERY_FLAG,M.ALLOW_EXPRESS_DELIVERY_FLAG),
NVL(I.DAYS_EARLY_RECEIPT_ALLOWED,M.DAYS_EARLY_RECEIPT_ALLOWED),
NVL(I.DAYS_LATE_RECEIPT_ALLOWED,M.DAYS_LATE_RECEIPT_ALLOWED),
NVL(I.RECEIPT_DAYS_EXCEPTION_CODE,M.RECEIPT_DAYS_EXCEPTION_CODE),
NVL(I.RECEIVING_ROUTING_ID,M.RECEIVING_ROUTING_ID),
NVL(I.INVOICE_CLOSE_TOLERANCE,M.INVOICE_CLOSE_TOLERANCE),
NVL(I.RECEIVE_CLOSE_TOLERANCE,M.RECEIVE_CLOSE_TOLERANCE),
NVL(I.AUTO_LOT_ALPHA_PREFIX,M.AUTO_LOT_ALPHA_PREFIX),
NVL(I.START_AUTO_LOT_NUMBER,M.START_AUTO_LOT_NUMBER),
NVL(I.LOT_CONTROL_CODE,M.LOT_CONTROL_CODE),
NVL(I.SHELF_LIFE_CODE,M.SHELF_LIFE_CODE),
NVL(I.SHELF_LIFE_DAYS,M.SHELF_LIFE_DAYS),
NVL(I.SERIAL_NUMBER_CONTROL_CODE,M.SERIAL_NUMBER_CONTROL_CODE),
NVL(I.START_AUTO_SERIAL_NUMBER,M.START_AUTO_SERIAL_NUMBER),
NVL(I.AUTO_SERIAL_ALPHA_PREFIX,M.AUTO_SERIAL_ALPHA_PREFIX),
NVL(I.SOURCE_TYPE,M.SOURCE_TYPE),
--* Commented for Bug #3764605 : Below attributes are org controlled.
--NVL(I.SOURCE_ORGANIZATION_ID,M.SOURCE_ORGANIZATION_ID),
--NVL(I.SOURCE_SUBINVENTORY,M.SOURCE_SUBINVENTORY),
--* End of Bug #3764605
NVL(I.RESTRICT_SUBINVENTORIES_CODE,M.RESTRICT_SUBINVENTORIES_CODE),
NVL(I.UNIT_WEIGHT,M.UNIT_WEIGHT),
NVL(I.WEIGHT_UOM_CODE,M.WEIGHT_UOM_CODE),
NVL(I.VOLUME_UOM_CODE,M.VOLUME_UOM_CODE),
NVL(I.UNIT_VOLUME,M.UNIT_VOLUME),
NVL(I.RESTRICT_LOCATORS_CODE,M.RESTRICT_LOCATORS_CODE),
NVL(I.LOCATION_CONTROL_CODE,M.LOCATION_CONTROL_CODE),
NVL(I.SHRINKAGE_RATE,M.SHRINKAGE_RATE),
NVL(I.ACCEPTABLE_EARLY_DAYS,M.ACCEPTABLE_EARLY_DAYS),
NVL(I.PLANNING_TIME_FENCE_CODE, M.PLANNING_TIME_FENCE_CODE),
NVL(I.DEMAND_TIME_FENCE_CODE, M.DEMAND_TIME_FENCE_CODE),
NVL(I.LEAD_TIME_LOT_SIZE,M.LEAD_TIME_LOT_SIZE),
NVL(I.STD_LOT_SIZE,M.STD_LOT_SIZE),
NVL(I.CUM_MANUFACTURING_LEAD_TIME,M.CUM_MANUFACTURING_LEAD_TIME),
NVL(I.OVERRUN_PERCENTAGE,M.OVERRUN_PERCENTAGE),
NVL(I.MRP_CALCULATE_ATP_FLAG,NVL(M.MRP_CALCULATE_ATP_FLAG,'N')),
NVL(I.ACCEPTABLE_RATE_INCREASE,M.ACCEPTABLE_RATE_INCREASE),
NVL(I.ACCEPTABLE_RATE_DECREASE,M.ACCEPTABLE_RATE_DECREASE),
NVL(I.CUMULATIVE_TOTAL_LEAD_TIME,M.CUMULATIVE_TOTAL_LEAD_TIME),
/*AN991207 #1081419: If child org time_fence_code is non-user defined,
do not copy master org time_fence_days to the child org */
NVL(I.PLANNING_TIME_FENCE_DAYS, decode(NVL(I.PLANNING_TIME_FENCE_CODE, M.PLANNING_TIME_FENCE_CODE),
4, M.PLANNING_TIME_FENCE_DAYS, NULL)),
NVL(I.DEMAND_TIME_FENCE_DAYS, decode(NVL(I.DEMAND_TIME_FENCE_CODE, M.DEMAND_TIME_FENCE_CODE),
4, M.DEMAND_TIME_FENCE_DAYS, NULL)),
NVL(I.END_ASSEMBLY_PEGGING_FLAG,M.END_ASSEMBLY_PEGGING_FLAG),
NVL(I.REPETITIVE_PLANNING_FLAG,M.REPETITIVE_PLANNING_FLAG),
NVL(I.BOM_ITEM_TYPE,M.BOM_ITEM_TYPE),
NVL(I.PICK_COMPONENTS_FLAG,M.PICK_COMPONENTS_FLAG),
NVL(I.REPLENISH_TO_ORDER_FLAG,M.REPLENISH_TO_ORDER_FLAG),
NVL(I.BASE_ITEM_ID,M.BASE_ITEM_ID),
NVL(I.ATP_COMPONENTS_FLAG,M.ATP_COMPONENTS_FLAG),
NVL(I.ATP_FLAG,M.ATP_FLAG),
NVL(I.FIXED_LEAD_TIME,M.FIXED_LEAD_TIME),
NVL(I.VARIABLE_LEAD_TIME,M.VARIABLE_LEAD_TIME),
I.WIP_SUPPLY_LOCATOR_ID, /*NP 26AUG94 this should not default from master*/
NVL(I.WIP_SUPPLY_TYPE,M.WIP_SUPPLY_TYPE),
I.WIP_SUPPLY_SUBINVENTORY, /*NP 26AUG94 this should not default from master*/
-- Primary Unit of Measure is now maintained via the PRIMARY_UOM_CODE column.
-- Bug: 4071090 NVL(I.PRIMARY_UOM_CODE,M.PRIMARY_UOM_CODE),
DECODE(I.PRIMARY_UOM_CODE, NULL,decode(I.PRIMARY_UNIT_OF_MEASURE,NULL,M.PRIMARY_UOM_CODE,l_Primary_UOM_Code),I.PRIMARY_UOM_CODE),
NVL(l_base_primary_UOM,NVL(I.PRIMARY_UNIT_OF_MEASURE,M.primary_unit_of_measure)), -- bug 13603262
NVL(I.ALLOWED_UNITS_LOOKUP_CODE,M.ALLOWED_UNITS_LOOKUP_CODE),
NVL(I.DEFAULT_INCLUDE_IN_ROLLUP_FLAG,M.DEFAULT_INCLUDE_IN_ROLLUP_FLAG),
NVL(I.INVENTORY_ITEM_STATUS_CODE,M.INVENTORY_ITEM_STATUS_CODE),
NVL(I.INVENTORY_PLANNING_CODE,M.INVENTORY_PLANNING_CODE),
I.PLANNER_CODE, /*NP 26AUG94 no defaulting from master*/
NVL(I.PLANNING_MAKE_BUY_CODE,M.PLANNING_MAKE_BUY_CODE),
NVL(I.FIXED_LOT_MULTIPLIER,M.FIXED_LOT_MULTIPLIER),
NVL(I.ROUNDING_CONTROL_TYPE,M.ROUNDING_CONTROL_TYPE),
NVL(I.CARRYING_COST,M.CARRYING_COST),
NVL(I.POSTPROCESSING_LEAD_TIME,M.POSTPROCESSING_LEAD_TIME),
NVL(I.PREPROCESSING_LEAD_TIME,M.PREPROCESSING_LEAD_TIME),
NVL(I.FULL_LEAD_TIME,M.FULL_LEAD_TIME),
NVL(I.ORDER_COST,M.ORDER_COST),
NVL(I.MRP_SAFETY_STOCK_PERCENT,M.MRP_SAFETY_STOCK_PERCENT),
NVL(I.MRP_SAFETY_STOCK_CODE,M.MRP_SAFETY_STOCK_CODE),
NVL(I.MIN_MINMAX_QUANTITY,M.MIN_MINMAX_QUANTITY),
NVL(I.MAX_MINMAX_QUANTITY,M.MAX_MINMAX_QUANTITY),
NVL(I.MINIMUM_ORDER_QUANTITY,M.MINIMUM_ORDER_QUANTITY),
NVL(I.FIXED_ORDER_QUANTITY,M.FIXED_ORDER_QUANTITY),
NVL(I.FIXED_DAYS_SUPPLY,M.FIXED_DAYS_SUPPLY),
NVL(I.MAXIMUM_ORDER_QUANTITY,M.MAXIMUM_ORDER_QUANTITY),
NVL(I.ATP_RULE_ID,M.ATP_RULE_ID),
NVL(I.PICKING_RULE_ID,M.PICKING_RULE_ID),
NVL(I.RESERVABLE_TYPE,M.RESERVABLE_TYPE),
NVL(I.POSITIVE_MEASUREMENT_ERROR,M.POSITIVE_MEASUREMENT_ERROR),
NVL(I.NEGATIVE_MEASUREMENT_ERROR,M.NEGATIVE_MEASUREMENT_ERROR),
NVL(I.ENGINEERING_ECN_CODE,M.ENGINEERING_ECN_CODE),
NVL(I.ENGINEERING_ITEM_ID,M.ENGINEERING_ITEM_ID),
NVL(I.ENGINEERING_DATE,M.ENGINEERING_DATE),
NVL(I.SERVICE_STARTING_DELAY,M.SERVICE_STARTING_DELAY),
NVL(I.SERVICEABLE_COMPONENT_FLAG,M.SERVICEABLE_COMPONENT_FLAG),
NVL(I.SERVICEABLE_PRODUCT_FLAG,M.SERVICEABLE_PRODUCT_FLAG),
NVL(I.BASE_WARRANTY_SERVICE_ID,M.BASE_WARRANTY_SERVICE_ID),
NVL(I.PAYMENT_TERMS_ID,M.PAYMENT_TERMS_ID),
NVL(I.PREVENTIVE_MAINTENANCE_FLAG,M.PREVENTIVE_MAINTENANCE_FLAG),
NVL(I.PRIMARY_SPECIALIST_ID,M.PRIMARY_SPECIALIST_ID),
NVL(I.SECONDARY_SPECIALIST_ID,M.SECONDARY_SPECIALIST_ID),
NVL(I.SERVICEABLE_ITEM_CLASS_ID,M.SERVICEABLE_ITEM_CLASS_ID),
NVL(I.TIME_BILLABLE_FLAG,M.TIME_BILLABLE_FLAG),
-- NVL(I.MATERIAL_BILLABLE_FLAG,M.MATERIAL_BILLABLE_FLAG),
NVL(I.MATERIAL_BILLABLE_FLAG, DECODE(
NVL(I.SERV_BILLING_ENABLED_FLAG,M.SERV_BILLING_ENABLED_FLAG)
,NULL,NULL,
'N',NULL,
M.MATERIAL_BILLABLE_FLAG)), -- Bug 5361618
NVL(I.EXPENSE_BILLABLE_FLAG,M.EXPENSE_BILLABLE_FLAG),
NVL(I.PRORATE_SERVICE_FLAG,M.PRORATE_SERVICE_FLAG),
NVL(I.COVERAGE_SCHEDULE_ID,M.COVERAGE_SCHEDULE_ID),
NVL(I.SERVICE_DURATION_PERIOD_CODE,M.SERVICE_DURATION_PERIOD_CODE),
NVL(I.SERVICE_DURATION,M.SERVICE_DURATION),
NVL(I.WARRANTY_VENDOR_ID,M.WARRANTY_VENDOR_ID),
NVL(I.MAX_WARRANTY_AMOUNT,M.MAX_WARRANTY_AMOUNT),
NVL(I.RESPONSE_TIME_PERIOD_CODE,M.RESPONSE_TIME_PERIOD_CODE),
NVL(I.RESPONSE_TIME_VALUE,M.RESPONSE_TIME_VALUE),
NVL(I.NEW_REVISION_CODE,M.NEW_REVISION_CODE),
NVL(I.INVOICEABLE_ITEM_FLAG,M.INVOICEABLE_ITEM_FLAG),
NVL(I.TAX_CODE,M.TAX_CODE),
--NVL(I.INVOICE_ENABLED_FLAG,M.INVOICE_ENABLED_FLAG),
NVL(I.MUST_USE_APPROVED_VENDOR_FLAG,M.MUST_USE_APPROVED_VENDOR_FLAG),
NVL(I.REQUEST_ID,M.REQUEST_ID),
NVL(I.PROGRAM_APPLICATION_ID,M.PROGRAM_APPLICATION_ID),
NVL(I.PROGRAM_ID,M.PROGRAM_ID),
NVL(I.PROGRAM_UPDATE_DATE,M.PROGRAM_UPDATE_DATE),
NVL(I.OUTSIDE_OPERATION_FLAG,M.OUTSIDE_OPERATION_FLAG),
NVL(I.OUTSIDE_OPERATION_UOM_TYPE,M.OUTSIDE_OPERATION_UOM_TYPE),
NVL(I.SAFETY_STOCK_BUCKET_DAYS,M.SAFETY_STOCK_BUCKET_DAYS),
NVL(I.AUTO_REDUCE_MPS,M.AUTO_REDUCE_MPS),
NVL(I.COSTING_ENABLED_FLAG,M.COSTING_ENABLED_FLAG),
NVL(I.CYCLE_COUNT_ENABLED_FLAG,M.CYCLE_COUNT_ENABLED_FLAG),
NVL(I.AUTO_CREATED_CONFIG_FLAG,M.AUTO_CREATED_CONFIG_FLAG),
NVL(I.ITEM_TYPE,M.ITEM_TYPE),
NVL(I.MODEL_CONFIG_CLAUSE_NAME,M.MODEL_CONFIG_CLAUSE_NAME),
NVL(I.SHIP_MODEL_COMPLETE_FLAG,M.SHIP_MODEL_COMPLETE_FLAG),
NVL(I.MRP_PLANNING_CODE,M.MRP_PLANNING_CODE),
NVL(I.ATO_FORECAST_CONTROL,M.ATO_FORECAST_CONTROL),
NVL(I.RETURN_INSPECTION_REQUIREMENT,M.RETURN_INSPECTION_REQUIREMENT),
NVL(I.RELEASE_TIME_FENCE_CODE, M.RELEASE_TIME_FENCE_CODE),
/*AN991207 #1081419: If child org time_fence_code is non-user defined,
do not copy master org time_fence_days to the child org */
NVL(I.RELEASE_TIME_FENCE_DAYS, decode(NVL(I.RELEASE_TIME_FENCE_CODE, M.RELEASE_TIME_FENCE_CODE),
4, M.RELEASE_TIME_FENCE_DAYS, NULL)),
NVL(I.CONTAINER_ITEM_FLAG, M.CONTAINER_ITEM_FLAG),
NVL(I.CONTAINER_TYPE_CODE, M.CONTAINER_TYPE_CODE),
NVL(I.INTERNAL_VOLUME, M.INTERNAL_VOLUME),
NVL(I.MAXIMUM_LOAD_WEIGHT, M.MAXIMUM_LOAD_WEIGHT),
NVL(I.MINIMUM_FILL_PERCENT, M.MINIMUM_FILL_PERCENT),
NVL(I.VEHICLE_ITEM_FLAG, M.VEHICLE_ITEM_FLAG),
NVL(I.CHECK_SHORTAGES_FLAG, M.CHECK_SHORTAGES_FLAG)
, NVL( I.EFFECTIVITY_CONTROL, M.EFFECTIVITY_CONTROL )
, NVL( I.OVERCOMPLETION_TOLERANCE_TYPE, M.OVERCOMPLETION_TOLERANCE_TYPE )
, NVL( I.OVERCOMPLETION_TOLERANCE_VALUE, M.OVERCOMPLETION_TOLERANCE_VALUE )
, NVL( I.OVER_SHIPMENT_TOLERANCE, M.OVER_SHIPMENT_TOLERANCE )
, NVL( I.UNDER_SHIPMENT_TOLERANCE, M.UNDER_SHIPMENT_TOLERANCE )
, NVL( I.OVER_RETURN_TOLERANCE, M.OVER_RETURN_TOLERANCE )
, NVL( I.UNDER_RETURN_TOLERANCE, M.UNDER_RETURN_TOLERANCE )
, NVL( I.EQUIPMENT_TYPE, M.EQUIPMENT_TYPE )
, NVL( I.RECOVERED_PART_DISP_CODE, M.RECOVERED_PART_DISP_CODE )
, NVL( I.DEFECT_TRACKING_ON_FLAG, M.DEFECT_TRACKING_ON_FLAG )
, NVL( I.EVENT_FLAG, M.EVENT_FLAG )
, NVL( I.ELECTRONIC_FLAG, M.ELECTRONIC_FLAG )
, NVL( I.DOWNLOADABLE_FLAG, M.DOWNLOADABLE_FLAG )
, NVL( I.VOL_DISCOUNT_EXEMPT_FLAG, M.VOL_DISCOUNT_EXEMPT_FLAG )
, NVL( I.COUPON_EXEMPT_FLAG, M.COUPON_EXEMPT_FLAG )
, NVL( I.COMMS_NL_TRACKABLE_FLAG, M.COMMS_NL_TRACKABLE_FLAG )
, NVL( I.ASSET_CREATION_CODE, M.ASSET_CREATION_CODE )
, NVL( I.COMMS_ACTIVATION_REQD_FLAG, M.COMMS_ACTIVATION_REQD_FLAG )
, NVL( I.ORDERABLE_ON_WEB_FLAG, M.ORDERABLE_ON_WEB_FLAG )
, NVL( I.BACK_ORDERABLE_FLAG, M.BACK_ORDERABLE_FLAG )
, NVL( I.WEB_STATUS, M.WEB_STATUS )
, NVL( I.INDIVISIBLE_FLAG, M.INDIVISIBLE_FLAG )
, NVL( I.DIMENSION_UOM_CODE, M.DIMENSION_UOM_CODE )
, NVL( I.UNIT_LENGTH, M.UNIT_LENGTH )
, NVL( I.UNIT_WIDTH, M.UNIT_WIDTH )
, NVL( I.UNIT_HEIGHT, M.UNIT_HEIGHT )
, NVL( I.BULK_PICKED_FLAG, M.BULK_PICKED_FLAG )
, NVL( I.LOT_STATUS_ENABLED, M.LOT_STATUS_ENABLED )
/*, NVL( I.DEFAULT_LOT_STATUS_ID, M.DEFAULT_LOT_STATUS_ID )
Bug 8538876, DEFAULT_LOT_STATUS_ID should be defauled based on LOT_STATUS_ENABLED flag.
If LOT_STATUS_ENABLED flag is 'N',then DEFAULT_LOT_STATUS_ID should be null
*/
, NVL( I.DEFAULT_LOT_STATUS_ID,DECODE(NVL(I.LOT_STATUS_ENABLED,M.LOT_STATUS_ENABLED),NULL,NULL,'N',NULL,M.DEFAULT_LOT_STATUS_ID))
, NVL( I.SERIAL_STATUS_ENABLED, M.SERIAL_STATUS_ENABLED )
/*Bug: 5739429 Default_serial_status_id should be defaulted based on serial_status_enabled flag.
If serial_status_enabled flag is 'N' then default_serial_status_id should be null.
, NVL( I.DEFAULT_SERIAL_STATUS_ID, M.DEFAULT_SERIAL_STATUS_ID )
*/
, NVL( I.DEFAULT_SERIAL_STATUS_ID,DECODE(NVL(I.SERIAL_STATUS_ENABLED,M.SERIAL_STATUS_ENABLED),NULL,NULL,'N',NULL,M.DEFAULT_SERIAL_STATUS_ID))
, NVL( I.INVENTORY_CARRY_PENALTY, M.INVENTORY_CARRY_PENALTY )
, NVL( I.OPERATION_SLACK_PENALTY, M.OPERATION_SLACK_PENALTY )
, NVL( I.FINANCING_ALLOWED_FLAG, M.FINANCING_ALLOWED_FLAG )
, NVL( I.EAM_ITEM_TYPE , M.EAM_ITEM_TYPE )
, NVL( I.EAM_ACTIVITY_TYPE_CODE , M.EAM_ACTIVITY_TYPE_CODE )
, NVL( I.EAM_ACTIVITY_CAUSE_CODE , M.EAM_ACTIVITY_CAUSE_CODE )
, NVL( I.EAM_ACT_NOTIFICATION_FLAG , M.EAM_ACT_NOTIFICATION_FLAG )
, NVL( I.EAM_ACT_SHUTDOWN_STATUS , M.EAM_ACT_SHUTDOWN_STATUS )
-- , NVL( I.DUAL_UOM_CONTROL , M.DUAL_UOM_CONTROL )
-- bug 14685981
, NVL(I.DUAL_UOM_CONTROL,DECODE(NVL(I.TRACKING_QUANTITY_IND,'P'),'P',1,DECODE(NVL(I.SECONDARY_DEFAULT_IND,'X'),'F',2,'D',3, 4)))
, NVL( I.SECONDARY_UOM_CODE , M.SECONDARY_UOM_CODE )
, NVL( I.DUAL_UOM_DEVIATION_HIGH , M.DUAL_UOM_DEVIATION_HIGH )
, NVL( I.DUAL_UOM_DEVIATION_LOW , M.DUAL_UOM_DEVIATION_LOW )
--, NVL( I.SERVICE_ITEM_FLAG , M.SERVICE_ITEM_FLAG )
--, NVL( I.VENDOR_WARRANTY_FLAG , M.VENDOR_WARRANTY_FLAG )
--, NVL( I.USAGE_ITEM_FLAG , M.USAGE_ITEM_FLAG )
, NVL( I.CONTRACT_ITEM_TYPE_CODE , M.CONTRACT_ITEM_TYPE_CODE )
, NVL( I.SUBSCRIPTION_DEPEND_FLAG , M.SUBSCRIPTION_DEPEND_FLAG )
--
, NVL( I.SERV_REQ_ENABLED_CODE , M.SERV_REQ_ENABLED_CODE )
, NVL( I.SERV_BILLING_ENABLED_FLAG , M.SERV_BILLING_ENABLED_FLAG )
, NVL( I.SERV_IMPORTANCE_LEVEL , M.SERV_IMPORTANCE_LEVEL )
, NVL( I.PLANNED_INV_POINT_FLAG , M.PLANNED_INV_POINT_FLAG )
, NVL( I.DEFAULT_SO_SOURCE_TYPE , M.DEFAULT_SO_SOURCE_TYPE )
, NVL( I.CREATE_SUPPLY_FLAG , M.CREATE_SUPPLY_FLAG )
, NVL( I.SUBSTITUTION_WINDOW_CODE , M.SUBSTITUTION_WINDOW_CODE )
-- If child org window_code is non-user defined,
-- do not copy master org window_days to the child org.
, NVL( I.SUBSTITUTION_WINDOW_DAYS,
DECODE( NVL(I.SUBSTITUTION_WINDOW_CODE, M.SUBSTITUTION_WINDOW_CODE),
4, M.SUBSTITUTION_WINDOW_DAYS,
NULL ) )
--Moved the dependant Lot attributes together
--(For ease of fix for bug# 2760857)
, NVL( I.LOT_SPLIT_ENABLED , M.LOT_SPLIT_ENABLED )
, NVL( I.LOT_MERGE_ENABLED , M.LOT_MERGE_ENABLED )
, NVL( I.LOT_TRANSLATE_ENABLED , M.LOT_TRANSLATE_ENABLED )
--Added as part of 11.5.9 ENH
, NVL( I.LOT_SUBSTITUTION_ENABLED , M.LOT_SUBSTITUTION_ENABLED )
, NVL( I.MINIMUM_LICENSE_QUANTITY , M.MINIMUM_LICENSE_QUANTITY )
, NVL( I.EAM_ACTIVITY_SOURCE_CODE , M.EAM_ACTIVITY_SOURCE_CODE )
, NVL( I.IB_ITEM_INSTANCE_CLASS , M.IB_ITEM_INSTANCE_CLASS )
, NVL( I.CONFIG_MODEL_TYPE , M.CONFIG_MODEL_TYPE )
--2740503: Defaulting lifecycle-phase from master org.
, NVL( I.LIFECYCLE_ID , M.LIFECYCLE_ID )
, NVL( I.CURRENT_PHASE_ID , M.CURRENT_PHASE_ID )
--Added as part of 11.5.10 ENH
, NVL( I.TRACKING_QUANTITY_IND , M.TRACKING_QUANTITY_IND )
, NVL( I.ONT_PRICING_QTY_SOURCE , M.ONT_PRICING_QTY_SOURCE )
, NVL( I.SECONDARY_DEFAULT_IND , M.SECONDARY_DEFAULT_IND )
, NVL( I.CONFIG_ORGS , M.CONFIG_ORGS )
, NVL( I.CONFIG_MATCH , M.CONFIG_MATCH )
, NVL(I.VMI_MINIMUM_UNITS , M.VMI_MINIMUM_UNITS )
, NVL(I.VMI_MINIMUM_DAYS , M.VMI_MINIMUM_DAYS )
, NVL(I.VMI_MAXIMUM_UNITS , M.VMI_MAXIMUM_UNITS )
, NVL(I.VMI_MAXIMUM_DAYS , M.VMI_MAXIMUM_DAYS )
, NVL(I.VMI_FIXED_ORDER_QUANTITY , M.VMI_FIXED_ORDER_QUANTITY )
, NVL(I.SO_AUTHORIZATION_FLAG , M.SO_AUTHORIZATION_FLAG )
, NVL(I.CONSIGNED_FLAG , M.CONSIGNED_FLAG )
, NVL(I.ASN_AUTOEXPIRE_FLAG , M.ASN_AUTOEXPIRE_FLAG )
, NVL(I.VMI_FORECAST_TYPE , M.VMI_FORECAST_TYPE )
, NVL(I.FORECAST_HORIZON , M.FORECAST_HORIZON )
, NVL(I.EXCLUDE_FROM_BUDGET_FLAG , M.EXCLUDE_FROM_BUDGET_FLAG )
, NVL(I.DAYS_TGT_INV_SUPPLY , M.DAYS_TGT_INV_SUPPLY )
, NVL(I.DAYS_TGT_INV_WINDOW , M.DAYS_TGT_INV_WINDOW )
, NVL(I.DAYS_MAX_INV_SUPPLY , M.DAYS_MAX_INV_SUPPLY )
, NVL(I.DAYS_MAX_INV_WINDOW , M.DAYS_MAX_INV_WINDOW )
, NVL(I.DRP_PLANNED_FLAG , M.DRP_PLANNED_FLAG )
, NVL(I.CRITICAL_COMPONENT_FLAG , M.CRITICAL_COMPONENT_FLAG )
, NVL(I.CONTINOUS_TRANSFER , M.CONTINOUS_TRANSFER )
, NVL(I.CONVERGENCE , M.CONVERGENCE )
, NVL(I.DIVERGENCE , M.DIVERGENCE )
/* Start Bug 3713912 */
, NVL(I.LOT_DIVISIBLE_FLAG , M.LOT_DIVISIBLE_FLAG )
, NVL(I.GRADE_CONTROL_FLAG , M.GRADE_CONTROL_FLAG )
, NVL(I.DEFAULT_GRADE , M.DEFAULT_GRADE )
, NVL(I.CHILD_LOT_FLAG , M.CHILD_LOT_FLAG )
, NVL(I.PARENT_CHILD_GENERATION_FLAG , M.PARENT_CHILD_GENERATION_FLAG )
, NVL(I.CHILD_LOT_PREFIX , M.CHILD_LOT_PREFIX )
, NVL(I.CHILD_LOT_STARTING_NUMBER , M.CHILD_LOT_STARTING_NUMBER )
, NVL(I.CHILD_LOT_VALIDATION_FLAG , M.CHILD_LOT_VALIDATION_FLAG )
, NVL(I.COPY_LOT_ATTRIBUTE_FLAG , M.COPY_LOT_ATTRIBUTE_FLAG )
--5349389, NVL(I.RECIPE_ENABLED_FLAG , M.RECIPE_ENABLED_FLAG )
, NVL(I.PROCESS_QUALITY_ENABLED_FLAG , M.PROCESS_QUALITY_ENABLED_FLAG )
--5349389, NVL(I.PROCESS_EXECUTION_ENABLED_FLAG , M.PROCESS_EXECUTION_ENABLED_FLAG )
, NVL(I.PROCESS_COSTING_ENABLED_FLAG , M.PROCESS_COSTING_ENABLED_FLAG )
, I.PROCESS_SUPPLY_SUBINVENTORY /* this should not default from master */
, I.PROCESS_SUPPLY_LOCATOR_ID /* this should not default from master */
, I.PROCESS_YIELD_SUBINVENTORY /* this should not default from master */
, I.PROCESS_YIELD_LOCATOR_ID /* this should not default from master */
, NVL(I.HAZARDOUS_MATERIAL_FLAG , M.HAZARDOUS_MATERIAL_FLAG )
, NVL(I.CAS_NUMBER , M.CAS_NUMBER )
, NVL(I.RETEST_INTERVAL , M.RETEST_INTERVAL )
, NVL(I.EXPIRATION_ACTION_INTERVAL , M.EXPIRATION_ACTION_INTERVAL )
, NVL(I.EXPIRATION_ACTION_CODE , M.EXPIRATION_ACTION_CODE )
, NVL(I.MATURITY_DAYS , M.MATURITY_DAYS )
, NVL(I.HOLD_DAYS , M.HOLD_DAYS )
/* End Bug 3713912 */
--R12 Enhancement
, NVL(I.REPAIR_LEADTIME ,M.REPAIR_LEADTIME )
, NVL(I.REPAIR_YIELD ,M.REPAIR_YIELD )
, NVL(I.PREPOSITION_POINT ,M.PREPOSITION_POINT )
, NVL(I.REPAIR_PROGRAM ,M.REPAIR_PROGRAM )
, NVL(I.CHARGE_PERIODICITY_CODE ,M.CHARGE_PERIODICITY_CODE )
, NVL(I.SUBCONTRACTING_COMPONENT ,M.SUBCONTRACTING_COMPONENT )
, NVL(I.OUTSOURCED_ASSEMBLY ,M.OUTSOURCED_ASSEMBLY )
/* R12 FPC Attributes */
, NVL(I.GDSN_OUTBOUND_ENABLED_FLAG ,M.GDSN_OUTBOUND_ENABLED_FLAG )
, NVL(I.TRADE_ITEM_DESCRIPTOR ,M.TRADE_ITEM_DESCRIPTOR )
, NVL(I.STYLE_ITEM_FLAG ,M.STYLE_ITEM_FLAG )
, NVL(I.STYLE_ITEM_ID ,M.STYLE_ITEM_ID )
FROM
mtl_system_items_tl MT
, mtl_system_items_b M
WHERE
M.inventory_item_id = item_id
AND M.organization_id = master_org_id
AND MT.INVENTORY_ITEM_ID = M.INVENTORY_ITEM_ID
AND MT.ORGANIZATION_ID = M.ORGANIZATION_ID
AND MT.LANGUAGE = userenv('LANG')
)
WHERE I.rowid = p_rowid;
SELECT tl.column_value
FROM ego_interface_tl tl, mtl_system_items_interface msii
WHERE 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 = USERENV('LANG')
AND msii.rowid = p_rowid;
SELECT ITEM_DESC_GEN_METHOD
FROM
(
SELECT ICC.ITEM_DESC_GEN_METHOD
FROM MTL_ITEM_CATALOG_GROUPS_B ICC
WHERE ICC.ITEM_DESC_GEN_METHOD IS NOT NULL
AND ICC.ITEM_DESC_GEN_METHOD <> 'I'
CONNECT BY PRIOR ICC.PARENT_CATALOG_GROUP_ID = ICC.ITEM_CATALOG_GROUP_ID
START WITH ICC.ITEM_CATALOG_GROUP_ID = cp_catalog_group_id
ORDER BY LEVEL ASC
)
WHERE ROWNUM = 1;
SELECT default_value FROM FND_DESCR_FLEX_COLUMN_USAGES
WHERE application_id = 431
AND DESCRIPTIVE_FLEXFIELD_NAME = 'EGO_MASTER_ITEMS'
AND DESCRIPTIVE_FLEX_CONTEXT_CODE = 'Main'
AND END_USER_COLUMN_NAME = 'Trade_Item_Descriptor';
SELECT description,
organization_id,
style_item_flag,
style_item_id,
primary_unit_of_measure,
primary_uom_code,
item_catalog_group_id
INTO temp_desc,
l_org_id,
l_style_item_flag,
l_style_item_id,
l_Primary_Unit_of_Measure,
l_Primary_UOM_Code,
l_item_catalog_group_id
FROM mtl_system_items_interface I
WHERE I.rowid = p_rowid;
SELECT starting_revision
INTO l_revision
FROM mtl_parameters
WHERE organization_id = l_org_id;
SELECT primary_unit_of_measure
INTO l_Primary_Unit_Of_Measure
FROM mtl_system_items_b
WHERE inventory_item_id = l_style_item_id
AND organization_id = l_org_id;
SELECT uom_code
INTO l_Primary_UOM_Code
FROM mtl_all_primary_uoms_vv
WHERE inventory_item_id = 0
AND unit_of_measure = l_Primary_Unit_of_Measure;--Bug:3775854*/
SELECT uom_code
INTO l_Primary_UOM_Code
FROM mtl_units_of_measure_tl
WHERE language = USERENV('LANG')
AND unit_of_measure = l_Primary_Unit_of_Measure;
SELECT unit_of_measure --Bug:3775854 --Bug 5192495 Use of unit_of_measure
INTO l_Primary_Unit_of_Measure
FROM mtl_units_of_measure
WHERE uom_code = l_Primary_UOM_Code;
UPDATE MTL_SYSTEM_ITEMS_INTERFACE I
SET (
I.DESCRIPTION,
I.LAST_UPDATED_BY,
I.CREATED_BY,
I.SUMMARY_FLAG,
I.ENABLED_FLAG,
I.ITEM_CATALOG_GROUP_ID,
I.INVENTORY_ITEM_FLAG,
I.WIP_SUPPLY_TYPE,
I.AUTO_CREATED_CONFIG_FLAG,
I.CYCLE_COUNT_ENABLED_FLAG,
I.INTERNAL_ORDER_FLAG,
I.INVENTORY_ITEM_STATUS_CODE,
I.INVENTORY_PLANNING_CODE,
I.MRP_PLANNING_CODE,
I.INVENTORY_ASSET_FLAG,
I.INVOICEABLE_ITEM_FLAG,
I.ENG_ITEM_FLAG,
I.BOM_ITEM_TYPE,
I.COSTING_ENABLED_FLAG,
I.CUSTOMER_ORDER_FLAG,
I.ALLOWED_UNITS_LOOKUP_CODE,
I.ALLOW_ITEM_DESC_UPDATE_FLAG,
I.ATP_COMPONENTS_FLAG,
I.ATP_FLAG,
I.SERVICEABLE_PRODUCT_FLAG,
I.SHELF_LIFE_CODE,
I.SHIPPABLE_ITEM_FLAG,
I.SO_TRANSACTIONS_FLAG,
I.SERVICEABLE_COMPONENT_FLAG,
I.REPLENISH_TO_ORDER_FLAG,
I.RESERVABLE_TYPE,
I.RESTRICT_LOCATORS_CODE,
I.RESTRICT_SUBINVENTORIES_CODE,
I.REVISION_QTY_CONTROL_CODE,
I.RFQ_REQUIRED_FLAG,
I.SERIAL_NUMBER_CONTROL_CODE,
I.PREVENTIVE_MAINTENANCE_FLAG,
I.SERV_BILLING_ENABLED_FLAG,
I.PRIMARY_UOM_CODE,
I.PRIMARY_UNIT_OF_MEASURE,
I.PRORATE_SERVICE_FLAG,
I.PURCHASING_ITEM_FLAG,
I.RECEIPT_REQUIRED_FLAG,
I.OUTSIDE_OPERATION_FLAG,
I.PICK_COMPONENTS_FLAG,
I.PLANNING_MAKE_BUY_CODE,
I.PLANNING_TIME_FENCE_CODE,
I.PLANNING_TIME_FENCE_DAYS,
I.MUST_USE_APPROVED_VENDOR_FLAG,
I.LOCATION_CONTROL_CODE,
I.LOT_CONTROL_CODE,
I.MRP_SAFETY_STOCK_CODE,
I.revision,
I.LAST_UPDATE_DATE,
I.CREATION_DATE,
I.SHIP_MODEL_COMPLETE_FLAG,
I.TAXABLE_FLAG,
I.MARKET_PRICE,
I.LIST_PRICE_PER_UNIT,
I.PRICE_TOLERANCE_PERCENT,
I.SHELF_LIFE_DAYS,
I.REPETITIVE_PLANNING_FLAG,
I.ACCEPTABLE_RATE_DECREASE,
I.ACCEPTABLE_RATE_INCREASE,
I.POSTPROCESSING_LEAD_TIME,
I.RETURN_INSPECTION_REQUIREMENT,
I.CONTAINER_ITEM_FLAG,
I.VEHICLE_ITEM_FLAG,
I.RETURNABLE_FLAG,
I.LEAD_TIME_LOT_SIZE,
I.CHECK_SHORTAGES_FLAG,
I.EFFECTIVITY_CONTROL,
I.EQUIPMENT_TYPE,
I.COMMS_NL_TRACKABLE_FLAG,
I.WEB_STATUS,
I.BULK_PICKED_FLAG,
I.LOT_STATUS_ENABLED,
I.DEFAULT_LOT_STATUS_ID,
I.SERIAL_STATUS_ENABLED,
I.DEFAULT_SERIAL_STATUS_ID,
I.DUAL_UOM_CONTROL,
I.LOT_SPLIT_ENABLED,
I.LOT_MERGE_ENABLED,
I.LOT_TRANSLATE_ENABLED,
I.DEFAULT_SO_SOURCE_TYPE,
I.CREATE_SUPPLY_FLAG,
I.TRACKING_QUANTITY_IND,
I.ONT_PRICING_QTY_SOURCE,
I.DUAL_UOM_DEVIATION_HIGH,
I.DUAL_UOM_DEVIATION_LOW,
I.VMI_MINIMUM_UNITS,
I.VMI_MINIMUM_DAYS,
I.VMI_MAXIMUM_UNITS,
I.VMI_MAXIMUM_DAYS,
I.VMI_FIXED_ORDER_QUANTITY,
I.SO_AUTHORIZATION_FLAG,
I.CONSIGNED_FLAG,
I.ASN_AUTOEXPIRE_FLAG,
I.VMI_FORECAST_TYPE,
I.FORECAST_HORIZON,
I.EXCLUDE_FROM_BUDGET_FLAG,
I.DAYS_TGT_INV_SUPPLY,
I.DAYS_TGT_INV_WINDOW,
I.DAYS_MAX_INV_SUPPLY,
I.DAYS_MAX_INV_WINDOW,
I.DRP_PLANNED_FLAG,
I.CRITICAL_COMPONENT_FLAG,
I.CONTINOUS_TRANSFER,
I.CONVERGENCE,
I.DIVERGENCE,
I.LOT_DIVISIBLE_FLAG,
I.GRADE_CONTROL_FLAG,
I.DEFAULT_GRADE,
I.CHILD_LOT_FLAG,
I.PARENT_CHILD_GENERATION_FLAG,
I.CHILD_LOT_PREFIX,
I.CHILD_LOT_STARTING_NUMBER,
I.CHILD_LOT_VALIDATION_FLAG,
I.COPY_LOT_ATTRIBUTE_FLAG,
I.PROCESS_QUALITY_ENABLED_FLAG,
I.PROCESS_COSTING_ENABLED_FLAG,
I.PROCESS_SUPPLY_SUBINVENTORY,
I.PROCESS_SUPPLY_LOCATOR_ID,
I.PROCESS_YIELD_SUBINVENTORY,
I.PROCESS_YIELD_LOCATOR_ID,
I.HAZARDOUS_MATERIAL_FLAG,
I.CAS_NUMBER,
I.RETEST_INTERVAL,
I.EXPIRATION_ACTION_INTERVAL,
I.EXPIRATION_ACTION_CODE,
I.MATURITY_DAYS,
I.HOLD_DAYS,
/* End Bug 3713912 */
--R12 Enhancement
I.PREPOSITION_POINT,
I.REPAIR_PROGRAM,
I.OUTSOURCED_ASSEMBLY,
/* Bug 5452757 */
I.COLLATERAL_FLAG,
I.EVENT_FLAG,
I.ELECTRONIC_FLAG,
I.DOWNLOADABLE_FLAG,
I.INDIVISIBLE_FLAG,
/* End of Bug 5452757 */
I.GDSN_OUTBOUND_ENABLED_FLAG,
I.TRADE_ITEM_DESCRIPTOR,
I.ATTRIBUTE_CATEGORY
)
= ( SELECT
NVL(I.DESCRIPTION, temp_desc),
l_created_by,
l_created_by,
NVL(I.SUMMARY_FLAG, 'N'), --Bug: 4918974
NVL(I.ENABLED_FLAG, 'Y'),
NVL(I.ITEM_CATALOG_GROUP_ID, M.ITEM_CATALOG_GROUP_ID),
NVL (I.INVENTORY_ITEM_FLAG, M.INVENTORY_ITEM_FLAG),
NVL (I.WIP_SUPPLY_TYPE, M.WIP_SUPPLY_TYPE),
NVL(I.AUTO_CREATED_CONFIG_FLAG, M.AUTO_CREATED_CONFIG_FLAG),
NVL(I.CYCLE_COUNT_ENABLED_FLAG,M.CYCLE_COUNT_ENABLED_FLAG),
NVL(I.INTERNAL_ORDER_FLAG,M.INTERNAL_ORDER_FLAG),
NVL(I.INVENTORY_ITEM_STATUS_CODE, M.INVENTORY_ITEM_STATUS_CODE),
NVL(I.INVENTORY_PLANNING_CODE, M.INVENTORY_PLANNING_CODE),
NVL(I.MRP_PLANNING_CODE, M.MRP_PLANNING_CODE),
NVL(I.INVENTORY_ASSET_FLAG, M.INVENTORY_ASSET_FLAG),
NVL(I.INVOICEABLE_ITEM_FLAG, M.INVOICEABLE_ITEM_FLAG),
NVL(I.ENG_ITEM_FLAG, M.ENG_ITEM_FLAG),
NVL(I.BOM_ITEM_TYPE, M.BOM_ITEM_TYPE),
NVL(I.COSTING_ENABLED_FLAG, M.COSTING_ENABLED_FLAG),
NVL(I.CUSTOMER_ORDER_FLAG, M.CUSTOMER_ORDER_FLAG),
NVL(I.ALLOWED_UNITS_LOOKUP_CODE, M.ALLOWED_UNITS_LOOKUP_CODE),
NVL(I.ALLOW_ITEM_DESC_UPDATE_FLAG, M.ALLOW_ITEM_DESC_UPDATE_FLAG),
NVL(I.ATP_COMPONENTS_FLAG, M.ATP_COMPONENTS_FLAG),
NVL(I.ATP_FLAG, M.ATP_FLAG),
NVL(I.SERVICEABLE_PRODUCT_FLAG, M.SERVICEABLE_PRODUCT_FLAG),
NVL(I.SHELF_LIFE_CODE,M.SHELF_LIFE_CODE),
NVL(I.SHIPPABLE_ITEM_FLAG, M.SHIPPABLE_ITEM_FLAG),
NVL(I.SO_TRANSACTIONS_FLAG, M.SO_TRANSACTIONS_FLAG),
NVL(I.SERVICEABLE_COMPONENT_FLAG, M.SERVICEABLE_COMPONENT_FLAG),
NVL(I.REPLENISH_TO_ORDER_FLAG, M.REPLENISH_TO_ORDER_FLAG),
NVL(I.RESERVABLE_TYPE, M.RESERVABLE_TYPE),
NVL(I.RESTRICT_LOCATORS_CODE, M.RESTRICT_LOCATORS_CODE),
NVL(I.RESTRICT_SUBINVENTORIES_CODE, M.RESTRICT_SUBINVENTORIES_CODE),
NVL(I.REVISION_QTY_CONTROL_CODE, M.REVISION_QTY_CONTROL_CODE),
NVL(I.RFQ_REQUIRED_FLAG, M.RFQ_REQUIRED_FLAG),
NVL(I.SERIAL_NUMBER_CONTROL_CODE, M.SERIAL_NUMBER_CONTROL_CODE),
NVL(I.PREVENTIVE_MAINTENANCE_FLAG, M.PREVENTIVE_MAINTENANCE_FLAG),
NVL(I.SERV_BILLING_ENABLED_FLAG, M.SERV_BILLING_ENABLED_FLAG),
l_primary_uom_code,
l_primary_unit_of_measure,
NVL(I.PRORATE_SERVICE_FLAG, M.PRORATE_SERVICE_FLAG),
NVL(I.PURCHASING_ITEM_FLAG, M.PURCHASING_ITEM_FLAG),
NVL(I.RECEIPT_REQUIRED_FLAG, M.RECEIPT_REQUIRED_FLAG),
NVL(I.OUTSIDE_OPERATION_FLAG, M.OUTSIDE_OPERATION_FLAG),
NVL(I.PICK_COMPONENTS_FLAG, M.PICK_COMPONENTS_FLAG),
NVL(I.PLANNING_MAKE_BUY_CODE, M.PLANNING_MAKE_BUY_CODE),
NVL(I.PLANNING_TIME_FENCE_CODE, M.PLANNING_TIME_FENCE_CODE),
NVL(I.PLANNING_TIME_FENCE_DAYS, M.PLANNING_TIME_FENCE_DAYS),
NVL(I.MUST_USE_APPROVED_VENDOR_FLAG, M.MUST_USE_APPROVED_VENDOR_FLAG),
NVL(I.LOCATION_CONTROL_CODE, M.LOCATION_CONTROL_CODE),
NVL(I.LOT_CONTROL_CODE, M.LOT_CONTROL_CODE),
NVL(I.MRP_SAFETY_STOCK_CODE, M.MRP_SAFETY_STOCK_CODE),
NVL(I.REVISION,l_revision),
NVL(I.LAST_UPDATE_DATE, l_sysdate),
NVL(I.CREATION_DATE, l_sysdate),
NVL(I.SHIP_MODEL_COMPLETE_FLAG, M.SHIP_MODEL_COMPLETE_FLAG),
NVL(I.TAXABLE_FLAG, M.TAXABLE_FLAG),
NVL(I.MARKET_PRICE, M.MARKET_PRICE),
NVL(I.LIST_PRICE_PER_UNIT, M.LIST_PRICE_PER_UNIT),
NVL(I.PRICE_TOLERANCE_PERCENT, M.PRICE_TOLERANCE_PERCENT),
NVL(I.SHELF_LIFE_DAYS, M.SHELF_LIFE_DAYS),
NVL(I.REPETITIVE_PLANNING_FLAG, M.REPETITIVE_PLANNING_FLAG),
NVL(I.ACCEPTABLE_RATE_DECREASE, M.ACCEPTABLE_RATE_DECREASE),
NVL(I.ACCEPTABLE_RATE_INCREASE, M.ACCEPTABLE_RATE_INCREASE),
NVL(I.POSTPROCESSING_LEAD_TIME, M.POSTPROCESSING_LEAD_TIME),
NVL(I.RETURN_INSPECTION_REQUIREMENT, M.RETURN_INSPECTION_REQUIREMENT),
NVL(I.CONTAINER_ITEM_FLAG, M.CONTAINER_ITEM_FLAG),
NVL(I.VEHICLE_ITEM_FLAG, M.VEHICLE_ITEM_FLAG),
NVL(I.RETURNABLE_FLAG, M.RETURNABLE_FLAG),
NVL(I.LEAD_TIME_LOT_SIZE, M.LEAD_TIME_LOT_SIZE),
NVL(I.CHECK_SHORTAGES_FLAG, M.CHECK_SHORTAGES_FLAG),
NVL(I.EFFECTIVITY_CONTROL, M.EFFECTIVITY_CONTROL),
NVL(I.EQUIPMENT_TYPE, M.EQUIPMENT_TYPE),
NVL(I.COMMS_NL_TRACKABLE_FLAG, M.COMMS_NL_TRACKABLE_FLAG),
NVL(I.WEB_STATUS, M.WEB_STATUS),
NVL(I.BULK_PICKED_FLAG, M.BULK_PICKED_FLAG),
NVL(I.LOT_STATUS_ENABLED, M.LOT_STATUS_ENABLED),
NVL(I.DEFAULT_LOT_STATUS_ID, M.DEFAULT_LOT_STATUS_ID),
NVL(I.SERIAL_STATUS_ENABLED, M.SERIAL_STATUS_ENABLED),
NVL(I.DEFAULT_SERIAL_STATUS_ID, M.DEFAULT_SERIAL_STATUS_ID),
-- NVL(I.DUAL_UOM_CONTROL, M.DUAL_UOM_CONTROL),
-- bug 14685981
NVL(I.DUAL_UOM_CONTROL,DECODE(NVL(I.TRACKING_QUANTITY_IND,'P'),'P',1,DECODE(NVL(I.SECONDARY_DEFAULT_IND,'X'),'F',2,'D',3, 4))),
NVL(I.LOT_SPLIT_ENABLED, M.LOT_SPLIT_ENABLED),
NVL(I.LOT_MERGE_ENABLED, M.LOT_MERGE_ENABLED),
NVL(I.LOT_TRANSLATE_ENABLED, M.LOT_TRANSLATE_ENABLED),
NVL(I.DEFAULT_SO_SOURCE_TYPE, M.DEFAULT_SO_SOURCE_TYPE),
NVL(I.CREATE_SUPPLY_FLAG, M.CREATE_SUPPLY_FLAG),
NVL(I.TRACKING_QUANTITY_IND, M.TRACKING_QUANTITY_IND),
NVL(I.ONT_PRICING_QTY_SOURCE, M.ONT_PRICING_QTY_SOURCE),
NVL(I.DUAL_UOM_DEVIATION_HIGH, M.DUAL_UOM_DEVIATION_HIGH),
NVL(I.DUAL_UOM_DEVIATION_LOW, M.DUAL_UOM_DEVIATION_LOW),
NVL(I.VMI_MINIMUM_UNITS, M.VMI_MINIMUM_UNITS),
NVL(I.VMI_MINIMUM_DAYS, M.VMI_MINIMUM_DAYS),
NVL(I.VMI_MAXIMUM_UNITS, M.VMI_MAXIMUM_UNITS),
NVL(I.VMI_MAXIMUM_DAYS, M.VMI_MAXIMUM_DAYS),
NVL(I.VMI_FIXED_ORDER_QUANTITY, M.VMI_FIXED_ORDER_QUANTITY),
NVL(I.SO_AUTHORIZATION_FLAG, M.SO_AUTHORIZATION_FLAG),
NVL(I.CONSIGNED_FLAG, M.CONSIGNED_FLAG),
NVL(I.ASN_AUTOEXPIRE_FLAG, M.ASN_AUTOEXPIRE_FLAG),
NVL(I.VMI_FORECAST_TYPE, M.VMI_FORECAST_TYPE),
NVL(I.FORECAST_HORIZON, M.FORECAST_HORIZON),
NVL(I.EXCLUDE_FROM_BUDGET_FLAG, M.EXCLUDE_FROM_BUDGET_FLAG),
NVL(I.DAYS_TGT_INV_SUPPLY, M.DAYS_TGT_INV_SUPPLY),
NVL(I.DAYS_TGT_INV_WINDOW, M.DAYS_TGT_INV_WINDOW),
NVL(I.DAYS_MAX_INV_SUPPLY, M.DAYS_MAX_INV_SUPPLY),
NVL(I.DAYS_MAX_INV_WINDOW, M.DAYS_MAX_INV_WINDOW),
NVL(I.DRP_PLANNED_FLAG, M.DRP_PLANNED_FLAG),
NVL(I.CRITICAL_COMPONENT_FLAG, M.CRITICAL_COMPONENT_FLAG),
NVL(I.CONTINOUS_TRANSFER, M.CONTINOUS_TRANSFER),
NVL(I.CONVERGENCE, M.CONVERGENCE),
NVL(I.DIVERGENCE, M.DIVERGENCE),
NVL(I.LOT_DIVISIBLE_FLAG, M.LOT_DIVISIBLE_FLAG),
NVL(I.GRADE_CONTROL_FLAG, M.GRADE_CONTROL_FLAG),
NVL(I.DEFAULT_GRADE, M.DEFAULT_GRADE),
NVL(I.CHILD_LOT_FLAG, M.CHILD_LOT_FLAG),
NVL(I.PARENT_CHILD_GENERATION_FLAG, M.PARENT_CHILD_GENERATION_FLAG),
NVL(I.CHILD_LOT_PREFIX, M.CHILD_LOT_PREFIX),
NVL(I.CHILD_LOT_STARTING_NUMBER, M.CHILD_LOT_STARTING_NUMBER),
NVL(I.CHILD_LOT_VALIDATION_FLAG, M.CHILD_LOT_VALIDATION_FLAG),
NVL(I.COPY_LOT_ATTRIBUTE_FLAG, M.COPY_LOT_ATTRIBUTE_FLAG),
NVL(I.PROCESS_QUALITY_ENABLED_FLAG, M.PROCESS_QUALITY_ENABLED_FLAG),
NVL(I.PROCESS_COSTING_ENABLED_FLAG, M.PROCESS_COSTING_ENABLED_FLAG),
NVL(I.PROCESS_SUPPLY_SUBINVENTORY, M.PROCESS_SUPPLY_SUBINVENTORY),
NVL(I.PROCESS_SUPPLY_LOCATOR_ID, M.PROCESS_SUPPLY_LOCATOR_ID),
NVL(I.PROCESS_YIELD_SUBINVENTORY, M.PROCESS_YIELD_SUBINVENTORY),
NVL(I.PROCESS_YIELD_LOCATOR_ID, M.PROCESS_YIELD_LOCATOR_ID),
NVL(I.HAZARDOUS_MATERIAL_FLAG, M.HAZARDOUS_MATERIAL_FLAG),
NVL(I.CAS_NUMBER, M.CAS_NUMBER),
NVL(I.RETEST_INTERVAL, M.RETEST_INTERVAL),
NVL(I.EXPIRATION_ACTION_INTERVAL, M.EXPIRATION_ACTION_INTERVAL),
NVL(I.EXPIRATION_ACTION_CODE, M.EXPIRATION_ACTION_CODE),
NVL(I.MATURITY_DAYS, M.MATURITY_DAYS),
NVL(I.HOLD_DAYS, M.HOLD_DAYS),
NVL(I.PREPOSITION_POINT, M.PREPOSITION_POINT),
NVL(I.REPAIR_PROGRAM, M.REPAIR_PROGRAM),
NVL(I.OUTSOURCED_ASSEMBLY, M.OUTSOURCED_ASSEMBLY),
NVL(I.COLLATERAL_FLAG, M.COLLATERAL_FLAG),
NVL(I.EVENT_FLAG, M.EVENT_FLAG),
NVL(I.ELECTRONIC_FLAG, M.ELECTRONIC_FLAG),
NVL(I.DOWNLOADABLE_FLAG, M.DOWNLOADABLE_FLAG),
NVL(I.INDIVISIBLE_FLAG, M.INDIVISIBLE_FLAG),
NVL(I.GDSN_OUTBOUND_ENABLED_FLAG,M.GDSN_OUTBOUND_ENABLED_FLAG),
NVL(I.TRADE_ITEM_DESCRIPTOR, M.TRADE_ITEM_DESCRIPTOR),
DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE_CATEGORY,M.ATTRIBUTE_CATEGORY),
'Y' , l_org_id
)
FROM mtl_system_items M
WHERE M.inventory_item_id = l_style_item_id
AND M.organization_id = l_org_id
)
WHERE I.ROWID = p_rowid;
UPDATE MTL_SYSTEM_ITEMS_INTERFACE I
SET
I.LAST_UPDATED_BY = org_id,
I.CREATED_BY = l_created_by,
I.SUMMARY_FLAG = NVL(I.SUMMARY_FLAG, 'N'), --Bug: 4918974
I.ENABLED_FLAG = NVL(I.ENABLED_FLAG, 'Y'),
--
-- Do not assign here defaults for
-- STOCK_ENABLED_FLAG and MTL_TRANSACTIONS_ENABLED_FLAG.
-- This will be done in INVPULI4.assign_status_attributes.
-- I.STOCK_ENABLED_FLAG = DECODE(I.STOCK_ENABLED_FLAG,NULL, 'N', I.STOCK_ENABLED_FLAG)
-- I.MTL_TRANSACTIONS_ENABLED_FLAG = DECODE(I.MTL_TRANSACTIONS_ENABLED_FLAG,NULL, 'N', I.MTL_TRANSACTIONS_ENABLED_FLAG)
-- 3410315: Status controlled attributes defaulting in INVPUL4B.
-- I.INTERNAL_ORDER_ENABLED_FLAG = DECODE(I.INTERNAL_ORDER_ENABLED_FLAG, NULL, 'N',I.INTERNAL_ORDER_ENABLED_FLAG),
-- I.INVOICE_ENABLED_FLAG = DECODE(I.INVOICE_ENABLED_FLAG, NULL, 'N', I.INVOICE_ENABLED_FLAG),
-- I.BOM_ENABLED_FLAG = DECODE(I.BOM_ENABLED_FLAG, NULL, 'N', I.BOM_ENABLED_FLAG),
-- I.BUILD_IN_WIP_FLAG = DECODE(I.BUILD_IN_WIP_FLAG,NULL,'N',I.BUILD_IN_WIP_FLAG),
-- I.CUSTOMER_ORDER_ENABLED_FLAG = DECODE(I.CUSTOMER_ORDER_ENABLED_FLAG, NULL, 'N',I.CUSTOMER_ORDER_ENABLED_FLAG),
-- I.PURCHASING_ENABLED_FLAG = DECODE(I.PURCHASING_ENABLED_FLAG,NULL,'N',I.PURCHASING_ENABLED_FLAG),
I.INVENTORY_ITEM_FLAG = NVL(I.INVENTORY_ITEM_FLAG, 'N'),
I.WIP_SUPPLY_TYPE = NVL(I.WIP_SUPPLY_TYPE, 1),
I.AUTO_CREATED_CONFIG_FLAG = NVL(I.AUTO_CREATED_CONFIG_FLAG, 'N'),
I.CYCLE_COUNT_ENABLED_FLAG = DECODE(I.CYCLE_COUNT_ENABLED_FLAG,NULL,'N',I.CYCLE_COUNT_ENABLED_FLAG),
I.INTERNAL_ORDER_FLAG = DECODE(I.INTERNAL_ORDER_FLAG, NULL,'N', I.INTERNAL_ORDER_FLAG),
I.INVENTORY_ITEM_STATUS_CODE = DECODE(I.INVENTORY_ITEM_STATUS_CODE, NULL, status_default, I.INVENTORY_ITEM_STATUS_CODE),
I.INVENTORY_PLANNING_CODE = DECODE(I.INVENTORY_PLANNING_CODE, NULL, 6, I.INVENTORY_PLANNING_CODE),
I.MRP_PLANNING_CODE = DECODE(I.MRP_PLANNING_CODE, NULL, 6, I.MRP_PLANNING_CODE),
I.INVENTORY_ASSET_FLAG = DECODE(I.INVENTORY_ASSET_FLAG, NULL, 'N', I.INVENTORY_ASSET_FLAG),
I.INVOICEABLE_ITEM_FLAG = DECODE(I.INVOICEABLE_ITEM_FLAG, NULL, 'N', I.INVOICEABLE_ITEM_FLAG),
--5665680 : When imported from XL, item should be eng item only.
I.ENG_ITEM_FLAG = DECODE(I.ENG_ITEM_FLAG, NULL, DECODE(l_process_ctrl,'EGO_ITEM_BULKLOAD','Y','N'),I.ENG_ITEM_FLAG),
-- Remove the defaulting of the expense_billable_flag to 'N' for bug 2886456- anmurali
-- I.EXPENSE_BILLABLE_FLAG = DECODE(I.EXPENSE_BILLABLE_FLAG,NULL,'N',I.EXPENSE_BILLABLE_FLAG),
I.BOM_ITEM_TYPE = DECODE(I.BOM_ITEM_TYPE, NULL, 4, I.BOM_ITEM_TYPE),
I.COSTING_ENABLED_FLAG = DECODE(I.COSTING_ENABLED_FLAG,NULL,'N',I.COSTING_ENABLED_FLAG),
I.CUSTOMER_ORDER_FLAG = DECODE(I.CUSTOMER_ORDER_FLAG,NULL,'N',I.CUSTOMER_ORDER_FLAG),
I.ALLOWED_UNITS_LOOKUP_CODE = DECODE(I.ALLOWED_UNITS_LOOKUP_CODE,NULL,3,I.ALLOWED_UNITS_LOOKUP_CODE),
I.ALLOW_ITEM_DESC_UPDATE_FLAG = DECODE(I.ALLOW_ITEM_DESC_UPDATE_FLAG,NULL,allow_item_desc_flag, ALLOW_ITEM_DESC_UPDATE_FLAG),
I.ATP_COMPONENTS_FLAG = DECODE(I.ATP_COMPONENTS_FLAG,NULL,'N',I.ATP_COMPONENTS_FLAG),
I.ATP_FLAG = DECODE(I.ATP_FLAG,NULL,'N',I.ATP_FLAG),
-- Remove the defaulting of the time_billable_flag to 'N' for bug 2886456- anmurali
-- I.TIME_BILLABLE_FLAG = DECODE(I.TIME_BILLABLE_FLAG,NULL,'N',I.TIME_BILLABLE_FLAG),
I.SERVICEABLE_PRODUCT_FLAG = DECODE(I.SERVICEABLE_PRODUCT_FLAG,NULL,'N',I.SERVICEABLE_PRODUCT_FLAG),
I.SHELF_LIFE_CODE = DECODE(I.SHELF_LIFE_CODE,NULL,1,I.SHELF_LIFE_CODE),
I.SHIPPABLE_ITEM_FLAG = DECODE(I.INTERNAL_ORDER_FLAG,'Y','Y', NVL(I.SHIPPABLE_ITEM_FLAG,'N')),
I.SO_TRANSACTIONS_FLAG = DECODE(I.SO_TRANSACTIONS_FLAG,NULL,'N',I.SO_TRANSACTIONS_FLAG),
I.SERVICEABLE_COMPONENT_FLAG = DECODE(I.SERVICEABLE_COMPONENT_FLAG,NULL,'N',I.SERVICEABLE_COMPONENT_FLAG),
I.REPLENISH_TO_ORDER_FLAG = DECODE(I.REPLENISH_TO_ORDER_FLAG,NULL,'N',I.REPLENISH_TO_ORDER_FLAG),
I.RESERVABLE_TYPE = DECODE(I.RESERVABLE_TYPE, NULL, 1, I.RESERVABLE_TYPE),
I.RESTRICT_LOCATORS_CODE = DECODE(I.RESTRICT_LOCATORS_CODE,NULL,2,I.RESTRICT_LOCATORS_CODE),
I.RESTRICT_SUBINVENTORIES_CODE = DECODE(I.RESTRICT_SUBINVENTORIES_CODE, NULL, 2,I.RESTRICT_SUBINVENTORIES_CODE),
I.REVISION_QTY_CONTROL_CODE = DECODE(I.REVISION_QTY_CONTROL_CODE,NULL,1,I.REVISION_QTY_CONTROL_CODE),
I.RFQ_REQUIRED_FLAG = DECODE(I.RFQ_REQUIRED_FLAG,NULL,req_required_flag,I.RFQ_REQUIRED_FLAG),
I.SERIAL_NUMBER_CONTROL_CODE = DECODE(I.SERIAL_NUMBER_CONTROL_CODE,NULL,1,I.SERIAL_NUMBER_CONTROL_CODE),
I.PREVENTIVE_MAINTENANCE_FLAG = DECODE(I.PREVENTIVE_MAINTENANCE_FLAG,NULL,'N', I.PREVENTIVE_MAINTENANCE_FLAG),
-- Anmurali - As in forms even while creating an item through IOI the SERV_BILLING_ENABLED_FLAG must default to 'N'
I.SERV_BILLING_ENABLED_FLAG = DECODE(I.SERV_BILLING_ENABLED_FLAG,NULL,'N',I.SERV_BILLING_ENABLED_FLAG),
-- Primary Unit of Measure is now maintained via the PRIMARY_UOM_CODE column.
I.PRIMARY_UOM_CODE = l_Primary_UOM_Code,
I.PRIMARY_UNIT_OF_MEASURE = l_Primary_Unit_of_Measure,
I.PRORATE_SERVICE_FLAG = DECODE(I.PRORATE_SERVICE_FLAG,NULL,'N',I.PRORATE_SERVICE_FLAG),
I.PURCHASING_ITEM_FLAG = DECODE(I.PURCHASING_ITEM_FLAG,NULL,'N',I.PURCHASING_ITEM_FLAG),
I.RECEIPT_REQUIRED_FLAG = DECODE(I.RECEIPT_REQUIRED_FLAG,NULL,v_receiving_flag,I.RECEIPT_REQUIRED_FLAG),
I.OUTSIDE_OPERATION_FLAG = DECODE(I.OUTSIDE_OPERATION_FLAG,NULL,'N',I.OUTSIDE_OPERATION_FLAG),
I.PICK_COMPONENTS_FLAG = DECODE(I.PICK_COMPONENTS_FLAG,NULL,'N',I.PICK_COMPONENTS_FLAG),
I.PLANNING_MAKE_BUY_CODE = DECODE(I.PLANNING_MAKE_BUY_CODE,NULL,2,I.PLANNING_MAKE_BUY_CODE),
I.PLANNING_TIME_FENCE_CODE = DECODE(I.PLANNING_TIME_FENCE_CODE,NULL,4,I.PLANNING_TIME_FENCE_CODE),
-- I.PLANNING_TIME_FENCE_DAYS = DECODE(I.PLANNING_TIME_FENCE_DAYS,NULL,1,I.PLANNING_TIME_FENCE_DAYS),
I.PLANNING_TIME_FENCE_DAYS = DECODE(I.PLANNING_TIME_FENCE_CODE,
NULL,DECODE(I.PLANNING_TIME_FENCE_DAYS, NULL,1,I.PLANNING_TIME_FENCE_DAYS),--Bug:3839935
4,DECODE(I.PLANNING_TIME_FENCE_DAYS, NULL, 1, I.PLANNING_TIME_FENCE_DAYS),
I.PLANNING_TIME_FENCE_DAYS ),
I.MUST_USE_APPROVED_VENDOR_FLAG = DECODE(I.MUST_USE_APPROVED_VENDOR_FLAG,NULL,'N',
I.MUST_USE_APPROVED_VENDOR_FLAG),
I.LOCATION_CONTROL_CODE = DECODE(I.LOCATION_CONTROL_CODE, NULL, 1, I.LOCATION_CONTROL_CODE),
I.LOT_CONTROL_CODE = DECODE(I.LOT_CONTROL_CODE, NULL, 1, I.LOT_CONTROL_CODE),
I.MRP_SAFETY_STOCK_CODE = DECODE(I.MRP_SAFETY_STOCK_CODE,NULL,1,I.MRP_SAFETY_STOCK_CODE),
I.revision = ( SELECT DECODE(I.revision, NULL,M.STARTING_REVISION, I.revision)
FROM MTL_PARAMETERS M
WHERE M.organization_id = org_id ),
I.LAST_UPDATE_DATE = NVL(I.LAST_UPDATE_DATE,l_sysdate),
I.CREATION_DATE = NVL(I.CREATION_DATE,l_sysdate),
I.SHIP_MODEL_COMPLETE_FLAG = DECODE(I.SHIP_MODEL_COMPLETE_FLAG, NULL, 'N', I.SHIP_MODEL_COMPLETE_FLAG ),
I.TAXABLE_FLAG = DECODE(I.TAXABLE_FLAG, NULL, tax_flag, I.TAXABLE_FLAG),
I.MARKET_PRICE = DECODE(I.MARKET_PRICE, NULL, NULL, I.MARKET_PRICE),
I.LIST_PRICE_PER_UNIT = DECODE(I.LIST_PRICE_PER_UNIT, NULL, NULL, I.LIST_PRICE_PER_UNIT),
-- I.PRICE_TOLERANCE_PERCENT = DECODE(I.PRICE_TOLERANCE_PERCENT, NULL, 0, I.PRICE_TOLERANCE_PERCENT),
I.PRICE_TOLERANCE_PERCENT = I.PRICE_TOLERANCE_PERCENT,
I.SHELF_LIFE_DAYS = DECODE(I.SHELF_LIFE_DAYS, NULL, 0 , I.SHELF_LIFE_DAYS),
I.REPETITIVE_PLANNING_FLAG = DECODE(I.REPETITIVE_PLANNING_FLAG, NULL, 'N', I.REPETITIVE_PLANNING_FLAG),
I.ACCEPTABLE_RATE_DECREASE = DECODE(I.ACCEPTABLE_RATE_DECREASE, NULL, 0, I.ACCEPTABLE_RATE_DECREASE),
I.ACCEPTABLE_RATE_INCREASE = DECODE(I.ACCEPTABLE_RATE_INCREASE, NULL, 0, I.ACCEPTABLE_RATE_INCREASE),
I.POSTPROCESSING_LEAD_TIME = DECODE(I.POSTPROCESSING_LEAD_TIME, NULL, 0, I.POSTPROCESSING_LEAD_TIME),
I.RETURN_INSPECTION_REQUIREMENT = DECODE(I.RETURN_INSPECTION_REQUIREMENT, NULL, 2,
I.RETURN_INSPECTION_REQUIREMENT),
I.CONTAINER_ITEM_FLAG = DECODE(I.CONTAINER_ITEM_FLAG, NULL, 'N', I.CONTAINER_ITEM_FLAG),
I.VEHICLE_ITEM_FLAG = DECODE(I.VEHICLE_ITEM_FLAG, NULL, 'N', I.VEHICLE_ITEM_FLAG),
-- I.SERVICE_DURATION = DECODE(I.SERVICE_DURATION, NULL, 0, I.SERVICE_DURATION), commented for bug 3048968
--Bug: 2696647 For Contract Items like SERVICE,WARRANTY and USAGE returnable_flag = 'N'
I.RETURNABLE_FLAG = DECODE(I.RETURNABLE_FLAG,NULL,DECODE(I.INVENTORY_ITEM_FLAG,'Y','Y','N'),I.RETURNABLE_FLAG), --Added for bug#929335
-- I.LEAD_TIME_LOT_SIZE = nvl(I.LEAD_TIME_LOT_SIZE,I.STD_LOT_SIZE), -- Added for bug# 900262
I.LEAD_TIME_LOT_SIZE = DECODE(I.LEAD_TIME_LOT_SIZE,null,DECODE(I.STD_LOT_SIZE,NULL,1,I.STD_LOT_SIZE),I.LEAD_TIME_LOT_SIZE), -- Added for bug# 900262
I.CHECK_SHORTAGES_FLAG = DECODE(I.CHECK_SHORTAGES_FLAG, NULL, 'N', I.CHECK_SHORTAGES_FLAG),
I.EFFECTIVITY_CONTROL = DECODE(I.EFFECTIVITY_CONTROL, NULL, 1, I.EFFECTIVITY_CONTROL),
I.EQUIPMENT_TYPE = NVL( I.EQUIPMENT_TYPE, c_Equipment_Type_default ),
I.COMMS_NL_TRACKABLE_FLAG = DECODE(I.COMMS_NL_TRACKABLE_FLAG,NULL,DECODE(I.CONTRACT_ITEM_TYPE_CODE,NULL,DECODE(I.SERVICEABLE_PRODUCT_FLAG,'Y','Y')),I.COMMS_NL_TRACKABLE_FLAG),
I.WEB_STATUS = NVL( I.WEB_STATUS, c_Web_Status_default ),
I.BULK_PICKED_FLAG = NVL( I.BULK_PICKED_FLAG, 'N' ),
I.LOT_STATUS_ENABLED = NVL( I.LOT_STATUS_ENABLED, 'N' ),
I.DEFAULT_LOT_STATUS_ID = NVL( I.DEFAULT_LOT_STATUS_ID, DECODE( NVL( I.LOT_CONTROL_CODE, 1 ),1, NULL,
DECODE( I.LOT_STATUS_ENABLED, 'Y', c_default_Lot_Status_id, NULL ))),
I.SERIAL_STATUS_ENABLED = NVL( I.SERIAL_STATUS_ENABLED, 'N' ),
I.DEFAULT_SERIAL_STATUS_ID = NVL( I.DEFAULT_SERIAL_STATUS_ID,
DECODE( NVL( I.SERIAL_NUMBER_CONTROL_CODE, 1 ), 1, NULL,
DECODE( I.SERIAL_STATUS_ENABLED, 'Y', c_default_Serial_Status_id, NULL ))),
I.DUAL_UOM_CONTROL = DECODE(NVL(TRACKING_QUANTITY_IND,'P'),'P',1,
DECODE(NVL(SECONDARY_DEFAULT_IND,'X'),'F',2,'D',3, 4)),--11.5.10
--2/17/2003
--As a Fix for bug# 2760857, the following LOT attributes were made to behave
--similar to LOT_SUBSTITUTION_ENABLED attribute.
--The Defaulting to 'N' below was commented out. But as per latest decision,
--Old Checkbox related attributes will default to N, and new ones to NULL.
--Since LOT_SUBSTITUTION_ENABLED is new attr, it will default to NULL.
--
I.LOT_SPLIT_ENABLED = NVL( I.LOT_SPLIT_ENABLED, 'N' ),
I.LOT_MERGE_ENABLED = NVL( I.LOT_MERGE_ENABLED, 'N' ),
I.LOT_TRANSLATE_ENABLED = NVL( I.LOT_TRANSLATE_ENABLED, 'N' ),
I.DEFAULT_SO_SOURCE_TYPE = NVL( I.DEFAULT_SO_SOURCE_TYPE, 'INTERNAL' ),
I.CREATE_SUPPLY_FLAG = NVL( I.CREATE_SUPPLY_FLAG, 'Y' ),
-- Added for 11.5.10 ENH
I.TRACKING_QUANTITY_IND = NVL(I.TRACKING_QUANTITY_IND, 'P'),
I.ONT_PRICING_QTY_SOURCE = NVL(I.ONT_PRICING_QTY_SOURCE,'P'),
I.DUAL_UOM_DEVIATION_HIGH = NVL(I.DUAL_UOM_DEVIATION_HIGH, 0),
I.DUAL_UOM_DEVIATION_LOW = NVL(I.DUAL_UOM_DEVIATION_LOW, 0),
I.VMI_MINIMUM_UNITS = I.VMI_MINIMUM_UNITS,
I.VMI_MINIMUM_DAYS = I.VMI_MINIMUM_DAYS,
I.VMI_MAXIMUM_UNITS = VMI_MAXIMUM_UNITS,
I.VMI_MAXIMUM_DAYS = VMI_MAXIMUM_DAYS,
I.VMI_FIXED_ORDER_QUANTITY = I.VMI_FIXED_ORDER_QUANTITY,
I.SO_AUTHORIZATION_FLAG = I.SO_AUTHORIZATION_FLAG,
I.CONSIGNED_FLAG = NVL(I.CONSIGNED_FLAG, 2),
I.ASN_AUTOEXPIRE_FLAG = NVL(I.ASN_AUTOEXPIRE_FLAG, 2),
I.VMI_FORECAST_TYPE = NVL(I.VMI_FORECAST_TYPE, 1),
I.FORECAST_HORIZON = I.FORECAST_HORIZON,
I.EXCLUDE_FROM_BUDGET_FLAG = NVL(I.EXCLUDE_FROM_BUDGET_FLAG, 2),
I.DAYS_TGT_INV_SUPPLY = I.DAYS_TGT_INV_SUPPLY,
I.DAYS_TGT_INV_WINDOW = I.DAYS_TGT_INV_WINDOW,
I.DAYS_MAX_INV_SUPPLY = I.DAYS_MAX_INV_SUPPLY,
I.DAYS_MAX_INV_WINDOW = I.DAYS_MAX_INV_WINDOW,
I.DRP_PLANNED_FLAG = NVL(I.DRP_PLANNED_FLAG, 2),
I.CRITICAL_COMPONENT_FLAG = NVL(I.CRITICAL_COMPONENT_FLAG, 2),
I.CONTINOUS_TRANSFER = NVL(I.CONTINOUS_TRANSFER, 3),
I.CONVERGENCE = NVL(I.CONVERGENCE, 3),
I.DIVERGENCE = NVL(I.DIVERGENCE, 3) ,
/* Start Bug 3713912 */
I.LOT_DIVISIBLE_FLAG = NVL(I.LOT_DIVISIBLE_FLAG , 'N' ) ,
I.GRADE_CONTROL_FLAG = NVL(I.GRADE_CONTROL_FLAG , 'N' ) ,
I.DEFAULT_GRADE = DEFAULT_GRADE ,
I.CHILD_LOT_FLAG = NVL(I.CHILD_LOT_FLAG , 'N' ) ,
I.PARENT_CHILD_GENERATION_FLAG = I.PARENT_CHILD_GENERATION_FLAG ,
I.CHILD_LOT_PREFIX = I.CHILD_LOT_PREFIX ,
I.CHILD_LOT_STARTING_NUMBER = I.CHILD_LOT_STARTING_NUMBER ,
I.CHILD_LOT_VALIDATION_FLAG = NVL(I.CHILD_LOT_VALIDATION_FLAG , 'N' ) ,
I.COPY_LOT_ATTRIBUTE_FLAG = NVL(I.COPY_LOT_ATTRIBUTE_FLAG , 'N' ) ,
--5349389 I.RECIPE_ENABLED_FLAG = NVL(I.RECIPE_ENABLED_FLAG , 'N' ) ,
I.PROCESS_QUALITY_ENABLED_FLAG = NVL(I.PROCESS_QUALITY_ENABLED_FLAG , 'N' ) ,
--5349389 I.PROCESS_EXECUTION_ENABLED_FLAG = NVL(I.PROCESS_EXECUTION_ENABLED_FLAG, 'N' ) ,
I.PROCESS_COSTING_ENABLED_FLAG = NVL(I.PROCESS_COSTING_ENABLED_FLAG , 'N' ) ,
I.PROCESS_SUPPLY_SUBINVENTORY = I.PROCESS_SUPPLY_SUBINVENTORY ,
I.PROCESS_SUPPLY_LOCATOR_ID = I.PROCESS_SUPPLY_LOCATOR_ID ,
I.PROCESS_YIELD_SUBINVENTORY = I.PROCESS_YIELD_SUBINVENTORY ,
I.PROCESS_YIELD_LOCATOR_ID = I.PROCESS_YIELD_LOCATOR_ID ,
I.HAZARDOUS_MATERIAL_FLAG = NVL(I.HAZARDOUS_MATERIAL_FLAG , 'N' ) ,
I.CAS_NUMBER = I.CAS_NUMBER ,
I.RETEST_INTERVAL = I.RETEST_INTERVAL ,
I.EXPIRATION_ACTION_INTERVAL = I.EXPIRATION_ACTION_INTERVAL ,
I.EXPIRATION_ACTION_CODE = I.EXPIRATION_ACTION_CODE ,
I.MATURITY_DAYS = I.MATURITY_DAYS ,
I.HOLD_DAYS = I.HOLD_DAYS ,
/* End Bug 3713912 */
--R12 Enhancement
I.PREPOSITION_POINT = NVL(I.PREPOSITION_POINT , 'N' ),
I.REPAIR_PROGRAM = NVL(I.REPAIR_PROGRAM , 3 ),
I.OUTSOURCED_ASSEMBLY = NVL(I.OUTSOURCED_ASSEMBLY , 2 ),
/* Bug 5452757 */
I.COLLATERAL_FLAG = NVL(I.COLLATERAL_FLAG,'N'),
I.EVENT_FLAG = NVL(I.EVENT_FLAG,'N'),
I.ELECTRONIC_FLAG = NVL(I.ELECTRONIC_FLAG,'N'),
I.DOWNLOADABLE_FLAG = NVL(I.DOWNLOADABLE_FLAG, 'N'),
I.INDIVISIBLE_FLAG = NVL(I.INDIVISIBLE_FLAG,'N'),
/* End of Bug 5452757 */
/* R12 FPC */
I.GDSN_OUTBOUND_ENABLED_FLAG = NVL(I.GDSN_OUTBOUND_ENABLED_FLAG, 'N'),
--Default Trade Item Descriptor for GDSN Syndicated Items Bug 6126870
I.TRADE_ITEM_DESCRIPTOR = NVL(I.TRADE_ITEM_DESCRIPTOR, DECODE(I.GDSN_OUTBOUND_ENABLED_FLAG, 'Y', l_trade_item_default, NULL)),
I.ATTRIBUTE_CATEGORY = DECODE(g_is_dff_reference_org_id, 'N' , I.ATTRIBUTE_CATEGORY,
'Y' , l_org_id
)
WHERE I.rowid = p_rowid;
SELECT DEFAULT_CONTEXT_FIELD_NAME
INTO l_context_name
FROM FND_DESCRIPTIVE_FLEXS
WHERE DESCRIPTIVE_FLEXFIELD_NAME = 'MTL_SYSTEM_ITEMS'
AND APPLICATION_ID = 401;