View: EGO_MTL_SY_ITEMS_CHG_VL

Product:	EGO - Advanced Product Catalog
Description:	This view stores the pending changes information for item operational attributes
Implementation/DBA Data:	APPS.EGO_MTL_SY_ITEMS_CHG_VL

View Text

SELECT B.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, B.ORGANIZATION_ID ORGANIZATION_ID
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.CREATION_DATE CREATION_DATE
, B.CREATED_BY CREATED_BY
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, B.SUMMARY_FLAG SUMMARY_FLAG
, B.ENABLED_FLAG ENABLED_FLAG
, B.START_DATE_ACTIVE START_DATE_ACTIVE
, B.END_DATE_ACTIVE END_DATE_ACTIVE
, T.DESCRIPTION DESCRIPTION
, T.LONG_DESCRIPTION LONG_DESCRIPTION
, B.BUYER_ID BUYER_ID
, B.ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, B.INVOICING_RULE_ID INVOICING_RULE_ID
, B.SEGMENT1 CONCATENATED_SEGMENTS
, RPAD(NVL(B.SEGMENT1
, ' ')
, 30) PADDED_CONCATENATED_SEGMENTS
, B.SEGMENT1 SEGMENT1
, B.SEGMENT2 SEGMENT2
, B.SEGMENT3 SEGMENT3
, B.SEGMENT4 SEGMENT4
, B.SEGMENT5 SEGMENT5
, B.SEGMENT6 SEGMENT6
, B.SEGMENT7 SEGMENT7
, B.SEGMENT8 SEGMENT8
, B.SEGMENT9 SEGMENT9
, B.SEGMENT10 SEGMENT10
, B.SEGMENT11 SEGMENT11
, B.SEGMENT12 SEGMENT12
, B.SEGMENT13 SEGMENT13
, B.SEGMENT14 SEGMENT14
, B.SEGMENT15 SEGMENT15
, B.SEGMENT16 SEGMENT16
, B.SEGMENT17 SEGMENT17
, B.SEGMENT18 SEGMENT18
, B.SEGMENT19 SEGMENT19
, B.SEGMENT20 SEGMENT20
, B.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1 ATTRIBUTE1
, B.ATTRIBUTE2 ATTRIBUTE2
, B.ATTRIBUTE3 ATTRIBUTE3
, B.ATTRIBUTE4 ATTRIBUTE4
, B.ATTRIBUTE5 ATTRIBUTE5
, B.ATTRIBUTE6 ATTRIBUTE6
, B.ATTRIBUTE7 ATTRIBUTE7
, B.ATTRIBUTE8 ATTRIBUTE8
, B.ATTRIBUTE9 ATTRIBUTE9
, B.ATTRIBUTE10 ATTRIBUTE10
, B.ATTRIBUTE11 ATTRIBUTE11
, B.ATTRIBUTE12 ATTRIBUTE12
, B.ATTRIBUTE13 ATTRIBUTE13
, B.ATTRIBUTE14 ATTRIBUTE14
, B.ATTRIBUTE15 ATTRIBUTE15
, B.PURCHASING_ITEM_FLAG PURCHASING_ITEM_FLAG
, B.SHIPPABLE_ITEM_FLAG SHIPPABLE_ITEM_FLAG
, B.CUSTOMER_ORDER_FLAG CUSTOMER_ORDER_FLAG
, B.INTERNAL_ORDER_FLAG INTERNAL_ORDER_FLAG
, B.SERVICE_ITEM_FLAG SERVICE_ITEM_FLAG
, B.INVENTORY_ITEM_FLAG INVENTORY_ITEM_FLAG
, B.ENG_ITEM_FLAG ENG_ITEM_FLAG
, B.INVENTORY_ASSET_FLAG INVENTORY_ASSET_FLAG
, B.PURCHASING_ENABLED_FLAG PURCHASING_ENABLED_FLAG
, B.CUSTOMER_ORDER_ENABLED_FLAG CUSTOMER_ORDER_ENABLED_FLAG
, B.INTERNAL_ORDER_ENABLED_FLAG INTERNAL_ORDER_ENABLED_FLAG
, B.SO_TRANSACTIONS_FLAG SO_TRANSACTIONS_FLAG
, B.MTL_TRANSACTIONS_ENABLED_FLAG MTL_TRANSACTIONS_ENABLED_FLAG
, B.STOCK_ENABLED_FLAG STOCK_ENABLED_FLAG
, B.BOM_ENABLED_FLAG BOM_ENABLED_FLAG
, B.BUILD_IN_WIP_FLAG BUILD_IN_WIP_FLAG
, B.REVISION_QTY_CONTROL_CODE REVISION_QTY_CONTROL_CODE
, B.ITEM_CATALOG_GROUP_ID ITEM_CATALOG_GROUP_ID
, B.CATALOG_STATUS_FLAG CATALOG_STATUS_FLAG
, B.RETURNABLE_FLAG RETURNABLE_FLAG
, B.DEFAULT_SHIPPING_ORG DEFAULT_SHIPPING_ORG
, B.COLLATERAL_FLAG COLLATERAL_FLAG
, B.TAXABLE_FLAG TAXABLE_FLAG
, B.QTY_RCV_EXCEPTION_CODE QTY_RCV_EXCEPTION_CODE
, B.ALLOW_ITEM_DESC_UPDATE_FLAG ALLOW_ITEM_DESC_UPDATE_FLAG
, B.INSPECTION_REQUIRED_FLAG INSPECTION_REQUIRED_FLAG
, B.RECEIPT_REQUIRED_FLAG RECEIPT_REQUIRED_FLAG
, B.MARKET_PRICE MARKET_PRICE
, B.HAZARD_CLASS_ID HAZARD_CLASS_ID
, B.RFQ_REQUIRED_FLAG RFQ_REQUIRED_FLAG
, B.QTY_RCV_TOLERANCE QTY_RCV_TOLERANCE
, B.LIST_PRICE_PER_UNIT LIST_PRICE_PER_UNIT
, B.UN_NUMBER_ID UN_NUMBER_ID
, B.PRICE_TOLERANCE_PERCENT PRICE_TOLERANCE_PERCENT
, B.ASSET_CATEGORY_ID ASSET_CATEGORY_ID
, B.ROUNDING_FACTOR ROUNDING_FACTOR
, B.UNIT_OF_ISSUE UNIT_OF_ISSUE
, B.ENFORCE_SHIP_TO_LOCATION_CODE ENFORCE_SHIP_TO_LOCATION_CODE
, B.ALLOW_SUBSTITUTE_RECEIPTS_FLAG ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, B.ALLOW_UNORDERED_RECEIPTS_FLAG ALLOW_UNORDERED_RECEIPTS_FLAG
, B.ALLOW_EXPRESS_DELIVERY_FLAG ALLOW_EXPRESS_DELIVERY_FLAG
, B.DAYS_EARLY_RECEIPT_ALLOWED DAYS_EARLY_RECEIPT_ALLOWED
, B.DAYS_LATE_RECEIPT_ALLOWED DAYS_LATE_RECEIPT_ALLOWED
, B.RECEIPT_DAYS_EXCEPTION_CODE RECEIPT_DAYS_EXCEPTION_CODE
, B.RECEIVING_ROUTING_ID RECEIVING_ROUTING_ID
, B.INVOICE_CLOSE_TOLERANCE INVOICE_CLOSE_TOLERANCE
, B.RECEIVE_CLOSE_TOLERANCE RECEIVE_CLOSE_TOLERANCE
, B.AUTO_LOT_ALPHA_PREFIX AUTO_LOT_ALPHA_PREFIX
, B.START_AUTO_LOT_NUMBER START_AUTO_LOT_NUMBER
, B.LOT_CONTROL_CODE LOT_CONTROL_CODE
, B.SHELF_LIFE_CODE SHELF_LIFE_CODE
, B.SHELF_LIFE_DAYS SHELF_LIFE_DAYS
, B.SERIAL_NUMBER_CONTROL_CODE SERIAL_NUMBER_CONTROL_CODE
, B.START_AUTO_SERIAL_NUMBER START_AUTO_SERIAL_NUMBER
, B.AUTO_SERIAL_ALPHA_PREFIX AUTO_SERIAL_ALPHA_PREFIX
, B.SOURCE_TYPE SOURCE_TYPE
, B.SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, B.SOURCE_SUBINVENTORY SOURCE_SUBINVENTORY
, B.EXPENSE_ACCOUNT EXPENSE_ACCOUNT
, B.ENCUMBRANCE_ACCOUNT ENCUMBRANCE_ACCOUNT
, B.RESTRICT_SUBINVENTORIES_CODE RESTRICT_SUBINVENTORIES_CODE
, B.UNIT_WEIGHT UNIT_WEIGHT
, B.WEIGHT_UOM_CODE WEIGHT_UOM_CODE
, B.VOLUME_UOM_CODE VOLUME_UOM_CODE
, B.UNIT_VOLUME UNIT_VOLUME
, B.RESTRICT_LOCATORS_CODE RESTRICT_LOCATORS_CODE
, B.LOCATION_CONTROL_CODE LOCATION_CONTROL_CODE
, B.SHRINKAGE_RATE SHRINKAGE_RATE
, B.ACCEPTABLE_EARLY_DAYS ACCEPTABLE_EARLY_DAYS
, B.PLANNING_TIME_FENCE_CODE PLANNING_TIME_FENCE_CODE
, B.DEMAND_TIME_FENCE_CODE DEMAND_TIME_FENCE_CODE
, B.LEAD_TIME_LOT_SIZE LEAD_TIME_LOT_SIZE
, B.STD_LOT_SIZE STD_LOT_SIZE
, B.CUM_MANUFACTURING_LEAD_TIME CUM_MANUFACTURING_LEAD_TIME
, B.OVERRUN_PERCENTAGE OVERRUN_PERCENTAGE
, B.MRP_CALCULATE_ATP_FLAG MRP_CALCULATE_ATP_FLAG
, B.ACCEPTABLE_RATE_INCREASE ACCEPTABLE_RATE_INCREASE
, B.ACCEPTABLE_RATE_DECREASE ACCEPTABLE_RATE_DECREASE
, B.CUMULATIVE_TOTAL_LEAD_TIME CUMULATIVE_TOTAL_LEAD_TIME
, B.PLANNING_TIME_FENCE_DAYS PLANNING_TIME_FENCE_DAYS
, B.DEMAND_TIME_FENCE_DAYS DEMAND_TIME_FENCE_DAYS
, B.END_ASSEMBLY_PEGGING_FLAG END_ASSEMBLY_PEGGING_FLAG
, B.REPETITIVE_PLANNING_FLAG REPETITIVE_PLANNING_FLAG
, B.PLANNING_EXCEPTION_SET PLANNING_EXCEPTION_SET
, B.BOM_ITEM_TYPE BOM_ITEM_TYPE
, B.PICK_COMPONENTS_FLAG PICK_COMPONENTS_FLAG
, B.REPLENISH_TO_ORDER_FLAG REPLENISH_TO_ORDER_FLAG
, B.BASE_ITEM_ID BASE_ITEM_ID
, B.ATP_COMPONENTS_FLAG ATP_COMPONENTS_FLAG
, B.ATP_FLAG ATP_FLAG
, B.FIXED_LEAD_TIME FIXED_LEAD_TIME
, B.VARIABLE_LEAD_TIME VARIABLE_LEAD_TIME
, B.WIP_SUPPLY_LOCATOR_ID WIP_SUPPLY_LOCATOR_ID
, B.WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
, B.WIP_SUPPLY_SUBINVENTORY WIP_SUPPLY_SUBINVENTORY
, B.PRIMARY_UOM_CODE PRIMARY_UOM_CODE
, B.PRIMARY_UNIT_OF_MEASURE PRIMARY_UNIT_OF_MEASURE
, B.ALLOWED_UNITS_LOOKUP_CODE ALLOWED_UNITS_LOOKUP_CODE
, B.COST_OF_SALES_ACCOUNT COST_OF_SALES_ACCOUNT
, B.SALES_ACCOUNT SALES_ACCOUNT
, B.DEFAULT_INCLUDE_IN_ROLLUP_FLAG DEFAULT_INCLUDE_IN_ROLLUP_FLAG
, B.INVENTORY_ITEM_STATUS_CODE INVENTORY_ITEM_STATUS_CODE
, B.INVENTORY_PLANNING_CODE INVENTORY_PLANNING_CODE
, B.PLANNER_CODE PLANNER_CODE
, B.PLANNING_MAKE_BUY_CODE PLANNING_MAKE_BUY_CODE
, B.FIXED_LOT_MULTIPLIER FIXED_LOT_MULTIPLIER
, B.ROUNDING_CONTROL_TYPE ROUNDING_CONTROL_TYPE
, B.CARRYING_COST CARRYING_COST
, B.POSTPROCESSING_LEAD_TIME POSTPROCESSING_LEAD_TIME
, B.PREPROCESSING_LEAD_TIME PREPROCESSING_LEAD_TIME
, B.FULL_LEAD_TIME FULL_LEAD_TIME
, B.ORDER_COST ORDER_COST
, B.MRP_SAFETY_STOCK_PERCENT MRP_SAFETY_STOCK_PERCENT
, B.MRP_SAFETY_STOCK_CODE MRP_SAFETY_STOCK_CODE
, B.MIN_MINMAX_QUANTITY MIN_MINMAX_QUANTITY
, B.MAX_MINMAX_QUANTITY MAX_MINMAX_QUANTITY
, B.MINIMUM_ORDER_QUANTITY MINIMUM_ORDER_QUANTITY
, B.FIXED_ORDER_QUANTITY FIXED_ORDER_QUANTITY
, B.FIXED_DAYS_SUPPLY FIXED_DAYS_SUPPLY
, B.MAXIMUM_ORDER_QUANTITY MAXIMUM_ORDER_QUANTITY
, B.ATP_RULE_ID ATP_RULE_ID
, B.PICKING_RULE_ID PICKING_RULE_ID
, B.RESERVABLE_TYPE RESERVABLE_TYPE
, B.POSITIVE_MEASUREMENT_ERROR POSITIVE_MEASUREMENT_ERROR
, B.NEGATIVE_MEASUREMENT_ERROR NEGATIVE_MEASUREMENT_ERROR
, B.ENGINEERING_ECN_CODE ENGINEERING_ECN_CODE
, B.ENGINEERING_ITEM_ID ENGINEERING_ITEM_ID
, B.ENGINEERING_DATE ENGINEERING_DATE
, B.SERVICE_STARTING_DELAY SERVICE_STARTING_DELAY
, B.VENDOR_WARRANTY_FLAG VENDOR_WARRANTY_FLAG
, B.SERVICEABLE_COMPONENT_FLAG SERVICEABLE_COMPONENT_FLAG
, B.SERVICEABLE_PRODUCT_FLAG SERVICEABLE_PRODUCT_FLAG
, B.BASE_WARRANTY_SERVICE_ID BASE_WARRANTY_SERVICE_ID
, B.PAYMENT_TERMS_ID PAYMENT_TERMS_ID
, B.PREVENTIVE_MAINTENANCE_FLAG PREVENTIVE_MAINTENANCE_FLAG
, B.PRIMARY_SPECIALIST_ID PRIMARY_SPECIALIST_ID
, B.SECONDARY_SPECIALIST_ID SECONDARY_SPECIALIST_ID
, B.SERVICEABLE_ITEM_CLASS_ID SERVICEABLE_ITEM_CLASS_ID
, B.TIME_BILLABLE_FLAG TIME_BILLABLE_FLAG
, B.MATERIAL_BILLABLE_FLAG MATERIAL_BILLABLE_FLAG
, B.EXPENSE_BILLABLE_FLAG EXPENSE_BILLABLE_FLAG
, B.PRORATE_SERVICE_FLAG PRORATE_SERVICE_FLAG
, B.COVERAGE_SCHEDULE_ID COVERAGE_SCHEDULE_ID
, B.SERVICE_DURATION_PERIOD_CODE SERVICE_DURATION_PERIOD_CODE
, B.SERVICE_DURATION SERVICE_DURATION
, B.WARRANTY_VENDOR_ID WARRANTY_VENDOR_ID
, B.MAX_WARRANTY_AMOUNT MAX_WARRANTY_AMOUNT
, B.RESPONSE_TIME_PERIOD_CODE RESPONSE_TIME_PERIOD_CODE
, B.RESPONSE_TIME_VALUE RESPONSE_TIME_VALUE
, B.NEW_REVISION_CODE NEW_REVISION_CODE
, B.INVOICEABLE_ITEM_FLAG INVOICEABLE_ITEM_FLAG
, B.TAX_CODE TAX_CODE
, B.INVOICE_ENABLED_FLAG INVOICE_ENABLED_FLAG
, B.MUST_USE_APPROVED_VENDOR_FLAG MUST_USE_APPROVED_VENDOR_FLAG
, B.REQUEST_ID REQUEST_ID
, B.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, B.PROGRAM_ID PROGRAM_ID
, B.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, B.OUTSIDE_OPERATION_FLAG OUTSIDE_OPERATION_FLAG
, B.OUTSIDE_OPERATION_UOM_TYPE OUTSIDE_OPERATION_UOM_TYPE
, B.SAFETY_STOCK_BUCKET_DAYS SAFETY_STOCK_BUCKET_DAYS
, B.AUTO_REDUCE_MPS AUTO_REDUCE_MPS
, B.COSTING_ENABLED_FLAG COSTING_ENABLED_FLAG
, B.AUTO_CREATED_CONFIG_FLAG AUTO_CREATED_CONFIG_FLAG
, B.CYCLE_COUNT_ENABLED_FLAG CYCLE_COUNT_ENABLED_FLAG
, B.ITEM_TYPE ITEM_TYPE
, B.MODEL_CONFIG_CLAUSE_NAME MODEL_CONFIG_CLAUSE_NAME
, B.SHIP_MODEL_COMPLETE_FLAG SHIP_MODEL_COMPLETE_FLAG
, B.MRP_PLANNING_CODE MRP_PLANNING_CODE
, B.RETURN_INSPECTION_REQUIREMENT RETURN_INSPECTION_REQUIREMENT
, B.ATO_FORECAST_CONTROL ATO_FORECAST_CONTROL
, B.RELEASE_TIME_FENCE_CODE RELEASE_TIME_FENCE_CODE
, B.RELEASE_TIME_FENCE_DAYS RELEASE_TIME_FENCE_DAYS
, B.CONTAINER_ITEM_FLAG CONTAINER_ITEM_FLAG
, B.VEHICLE_ITEM_FLAG VEHICLE_ITEM_FLAG
, B.MAXIMUM_LOAD_WEIGHT MAXIMUM_LOAD_WEIGHT
, B.MINIMUM_FILL_PERCENT MINIMUM_FILL_PERCENT
, B.CONTAINER_TYPE_CODE CONTAINER_TYPE_CODE
, B.INTERNAL_VOLUME INTERNAL_VOLUME
, B.WH_UPDATE_DATE WH_UPDATE_DATE
, B.PRODUCT_FAMILY_ITEM_ID PRODUCT_FAMILY_ITEM_ID
, B.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, B.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, B.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, B.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, B.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, B.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, B.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, B.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, B.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, B.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, B.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, B.PURCHASING_TAX_CODE PURCHASING_TAX_CODE
, B.OVERCOMPLETION_TOLERANCE_TYPE OVERCOMPLETION_TOLERANCE_TYPE
, B.OVERCOMPLETION_TOLERANCE_VALUE OVERCOMPLETION_TOLERANCE_VALUE
, B.EFFECTIVITY_CONTROL EFFECTIVITY_CONTROL
, B.CHECK_SHORTAGES_FLAG CHECK_SHORTAGES_FLAG
, B.OVER_SHIPMENT_TOLERANCE OVER_SHIPMENT_TOLERANCE
, B.UNDER_SHIPMENT_TOLERANCE UNDER_SHIPMENT_TOLERANCE
, B.OVER_RETURN_TOLERANCE OVER_RETURN_TOLERANCE
, B.UNDER_RETURN_TOLERANCE UNDER_RETURN_TOLERANCE
, B.EQUIPMENT_TYPE EQUIPMENT_TYPE
, B.RECOVERED_PART_DISP_CODE RECOVERED_PART_DISP_CODE
, B.DEFECT_TRACKING_ON_FLAG DEFECT_TRACKING_ON_FLAG
, B.USAGE_ITEM_FLAG USAGE_ITEM_FLAG
, B.EVENT_FLAG EVENT_FLAG
, B.ELECTRONIC_FLAG ELECTRONIC_FLAG
, B.DOWNLOADABLE_FLAG DOWNLOADABLE_FLAG
, B.VOL_DISCOUNT_EXEMPT_FLAG VOL_DISCOUNT_EXEMPT_FLAG
, B.COUPON_EXEMPT_FLAG COUPON_EXEMPT_FLAG
, B.COMMS_NL_TRACKABLE_FLAG COMMS_NL_TRACKABLE_FLAG
, B.ASSET_CREATION_CODE ASSET_CREATION_CODE
, B.COMMS_ACTIVATION_REQD_FLAG COMMS_ACTIVATION_REQD_FLAG
, B.ORDERABLE_ON_WEB_FLAG ORDERABLE_ON_WEB_FLAG
, B.BACK_ORDERABLE_FLAG BACK_ORDERABLE_FLAG
, B.WEB_STATUS WEB_STATUS
, B.INDIVISIBLE_FLAG INDIVISIBLE_FLAG
, B.DIMENSION_UOM_CODE DIMENSION_UOM_CODE
, B.UNIT_LENGTH UNIT_LENGTH
, B.UNIT_WIDTH UNIT_WIDTH
, B.UNIT_HEIGHT UNIT_HEIGHT
, B.BULK_PICKED_FLAG BULK_PICKED_FLAG
, B.LOT_STATUS_ENABLED LOT_STATUS_ENABLED
, B.DEFAULT_LOT_STATUS_ID DEFAULT_LOT_STATUS_ID
, B.SERIAL_STATUS_ENABLED SERIAL_STATUS_ENABLED
, B.DEFAULT_SERIAL_STATUS_ID DEFAULT_SERIAL_STATUS_ID
, B.LOT_SPLIT_ENABLED LOT_SPLIT_ENABLED
, B.LOT_MERGE_ENABLED LOT_MERGE_ENABLED
, B.INVENTORY_CARRY_PENALTY INVENTORY_CARRY_PENALTY
, B.OPERATION_SLACK_PENALTY OPERATION_SLACK_PENALTY
, B.FINANCING_ALLOWED_FLAG FINANCING_ALLOWED_FLAG
, B.EAM_ITEM_TYPE EAM_ITEM_TYPE
, B.EAM_ACTIVITY_TYPE_CODE EAM_ACTIVITY_TYPE_CODE
, B.EAM_ACTIVITY_CAUSE_CODE EAM_ACTIVITY_CAUSE_CODE
, B.EAM_ACT_NOTIFICATION_FLAG EAM_ACT_NOTIFICATION_FLAG
, B.EAM_ACT_SHUTDOWN_STATUS EAM_ACT_SHUTDOWN_STATUS
, B.DUAL_UOM_CONTROL DUAL_UOM_CONTROL
, B.SECONDARY_UOM_CODE SECONDARY_UOM_CODE
, B.DUAL_UOM_DEVIATION_HIGH DUAL_UOM_DEVIATION_HIGH
, B.DUAL_UOM_DEVIATION_LOW DUAL_UOM_DEVIATION_LOW
, B.CONTRACT_ITEM_TYPE_CODE CONTRACT_ITEM_TYPE_CODE
, B.SUBSCRIPTION_DEPEND_FLAG SUBSCRIPTION_DEPEND_FLAG
, B.SERV_REQ_ENABLED_CODE SERV_REQ_ENABLED_CODE
, B.SERV_BILLING_ENABLED_FLAG SERV_BILLING_ENABLED_FLAG
, B.SERV_IMPORTANCE_LEVEL SERV_IMPORTANCE_LEVEL
, B.PLANNED_INV_POINT_FLAG PLANNED_INV_POINT_FLAG
, B.LOT_TRANSLATE_ENABLED LOT_TRANSLATE_ENABLED
, B.DEFAULT_SO_SOURCE_TYPE DEFAULT_SO_SOURCE_TYPE
, B.CREATE_SUPPLY_FLAG CREATE_SUPPLY_FLAG
, B.SUBSTITUTION_WINDOW_CODE SUBSTITUTION_WINDOW_CODE
, B.SUBSTITUTION_WINDOW_DAYS SUBSTITUTION_WINDOW_DAYS
, B.IB_ITEM_INSTANCE_CLASS IB_ITEM_INSTANCE_CLASS
, B.CONFIG_MODEL_TYPE CONFIG_MODEL_TYPE
, B.LOT_SUBSTITUTION_ENABLED LOT_SUBSTITUTION_ENABLED
, B.MINIMUM_LICENSE_QUANTITY MINIMUM_LICENSE_QUANTITY
, B.EAM_ACTIVITY_SOURCE_CODE EAM_ACTIVITY_SOURCE_CODE
, B.LIFECYCLE_ID LIFECYCLE_ID
, B.CURRENT_PHASE_ID CURRENT_PHASE_ID
, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, B.TRACKING_QUANTITY_IND TRACKING_QUANTITY_IND
, B.ONT_PRICING_QTY_SOURCE ONT_PRICING_QTY_SOURCE
, B.SECONDARY_DEFAULT_IND SECONDARY_DEFAULT_IND
, B.OPTION_SPECIFIC_SOURCED OPTION_SPECIFIC_SOURCED
, B.APPROVAL_STATUS APPROVAL_STATUS
, B.VMI_MINIMUM_UNITS VMI_MINIMUM_UNITS
, B.VMI_MINIMUM_DAYS VMI_MINIMUM_DAYS
, B.VMI_MAXIMUM_UNITS VMI_MAXIMUM_UNITS
, B.VMI_MAXIMUM_DAYS VMI_MAXIMUM_DAYS
, B.VMI_FIXED_ORDER_QUANTITY VMI_FIXED_ORDER_QUANTITY
, B.SO_AUTHORIZATION_FLAG SO_AUTHORIZATION_FLAG
, B.CONSIGNED_FLAG CONSIGNED_FLAG
, B.ASN_AUTOEXPIRE_FLAG ASN_AUTOEXPIRE_FLAG
, B.VMI_FORECAST_TYPE VMI_FORECAST_TYPE
, B.FORECAST_HORIZON FORECAST_HORIZON
, B.EXCLUDE_FROM_BUDGET_FLAG EXCLUDE_FROM_BUDGET_FLAG
, B.DAYS_TGT_INV_SUPPLY DAYS_TGT_INV_SUPPLY
, B.DAYS_TGT_INV_WINDOW DAYS_TGT_INV_WINDOW
, B.DAYS_MAX_INV_SUPPLY DAYS_MAX_INV_SUPPLY
, B.DAYS_MAX_INV_WINDOW DAYS_MAX_INV_WINDOW
, B.DRP_PLANNED_FLAG DRP_PLANNED_FLAG
, B.CRITICAL_COMPONENT_FLAG CRITICAL_COMPONENT_FLAG
, B.CONTINOUS_TRANSFER CONTINOUS_TRANSFER
, B.CONVERGENCE CONVERGENCE
, B.DIVERGENCE DIVERGENCE
, B.CONFIG_ORGS CONFIG_ORGS
, B.CONFIG_MATCH CONFIG_MATCH
, B.CHARGE_PERIODICITY_CODE CHARGE_PERIODICITY_CODE
, B.REPAIR_LEADTIME REPAIR_LEADTIME
, B.REPAIR_YIELD REPAIR_YIELD
, B.PREPOSITION_POINT PREPOSITION_POINT
, B.REPAIR_PROGRAM REPAIR_PROGRAM
, B.SUBCONTRACTING_COMPONENT SUBCONTRACTING_COMPONENT
, B.OUTSOURCED_ASSEMBLY OUTSOURCED_ASSEMBLY
, B.CAS_NUMBER CAS_NUMBER
, B.HAZARDOUS_MATERIAL_FLAG HAZARDOUS_MATERIAL_FLAG
, B.PROCESS_COSTING_ENABLED_FLAG PROCESS_COSTING_ENABLED_FLAG
, B.PROCESS_EXECUTION_ENABLED_FLAG PROCESS_EXECUTION_ENABLED_FLAG
, B.PROCESS_QUALITY_ENABLED_FLAG PROCESS_QUALITY_ENABLED_FLAG
, B.PROCESS_SUPPLY_LOCATOR_ID PROCESS_SUPPLY_LOCATOR_ID
, B.PROCESS_SUPPLY_SUBINVENTORY PROCESS_SUPPLY_SUBINVENTORY
, B.PROCESS_YIELD_LOCATOR_ID PROCESS_YIELD_LOCATOR_ID
, B.PROCESS_YIELD_SUBINVENTORY PROCESS_YIELD_SUBINVENTORY
, B.RECIPE_ENABLED_FLAG RECIPE_ENABLED_FLAG
, B.HOLD_DAYS HOLD_DAYS
, B.LOT_DIVISIBLE_FLAG LOT_DIVISIBLE_FLAG
, B.MATURITY_DAYS MATURITY_DAYS
, B.PARENT_CHILD_GENERATION_FLAG PARENT_CHILD_GENERATION_FLAG
, B.RETEST_INTERVAL RETEST_INTERVAL
, B.CHILD_LOT_FLAG CHILD_LOT_FLAG
, B.CHILD_LOT_PREFIX CHILD_LOT_PREFIX
, B.CHILD_LOT_STARTING_NUMBER CHILD_LOT_STARTING_NUMBER
, B.CHILD_LOT_VALIDATION_FLAG CHILD_LOT_VALIDATION_FLAG
, B.COPY_LOT_ATTRIBUTE_FLAG COPY_LOT_ATTRIBUTE_FLAG
, B.DEFAULT_GRADE DEFAULT_GRADE
, B.EXPIRATION_ACTION_CODE EXPIRATION_ACTION_CODE
, B.EXPIRATION_ACTION_INTERVAL EXPIRATION_ACTION_INTERVAL
, B.GRADE_CONTROL_FLAG GRADE_CONTROL_FLAG
, B.ATTRIBUTE16 ATTRIBUTE16
, B.ATTRIBUTE17 ATTRIBUTE17
, B.ATTRIBUTE18 ATTRIBUTE18
, B.ATTRIBUTE19 ATTRIBUTE19
, B.ATTRIBUTE20 ATTRIBUTE20
, B.ATTRIBUTE21 ATTRIBUTE21
, B.ATTRIBUTE22 ATTRIBUTE22
, B.ATTRIBUTE23 ATTRIBUTE23
, B.ATTRIBUTE24 ATTRIBUTE24
, B.ATTRIBUTE25 ATTRIBUTE25
, B.ATTRIBUTE26 ATTRIBUTE26
, B.ATTRIBUTE27 ATTRIBUTE27
, B.ATTRIBUTE28 ATTRIBUTE28
, B.ATTRIBUTE29 ATTRIBUTE29
, B.ATTRIBUTE30 ATTRIBUTE30
, B.CHANGE_ID CHANGE_ID
, B.CHANGE_LINE_ID CHANGE_LINE_ID
, B.ACD_TYPE ACD_TYPE
, B.IMPLEMENTATION_DATE IMPLEMENTATION_DATE
, B.TRADE_ITEM_DESCRIPTOR TRADE_ITEM_DESCRIPTOR
, B.ITEM_NUMBER ITEM_NUMBER
, B.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, B.GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, B.GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, B.GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, B.GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, B.GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, B.GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, B.GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, B.GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, B.GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
FROM EGO_MTL_SY_ITEMS_CHG_TL T
, EGO_MTL_SY_ITEMS_CHG_B B
WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
AND B.CHANGE_LINE_ID = T.CHANGE_LINE_ID
AND B.ACD_TYPE = T.ACD_TYPE
AND NVL(B.IMPLEMENTATION_DATE
, SYSDATE) = NVL(T.IMPLEMENTATION_DATE
, SYSDATE)
AND T.LANGUAGE = USERENV('LANG')

Columns