eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.EGO_ITEM_SYNC_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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