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.CST_XLA_INV_SYSTEM_ITEMS_REF_V

Source

View Text - Preformatted


SELECT msi.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, msi.ORGANIZATION_ID ORGANIZATION_ID, msik.CONCATENATED_SEGMENTS ITEM_CONCATENATED_SEGMENTS, msi.description item_description, msi.PURCHASING_ITEM_FLAG PURCHASING_ITEM_FLAG, msi.SHIPPABLE_ITEM_FLAG SHIPPABLE_ITEM_FLAG, msi.CUSTOMER_ORDER_FLAG CUSTOMER_ORDER_FLAG, msi.INTERNAL_ORDER_FLAG INTERNAL_ORDER_FLAG, msi.SERVICE_ITEM_FLAG SERVICE_ITEM_FLAG, msi.INVENTORY_ITEM_FLAG INVENTORY_ITEM_FLAG, msi.ENG_ITEM_FLAG ENG_ITEM_FLAG, cic.INVENTORY_ASSET_FLAG INVENTORY_ASSET_FLAG, msi.PURCHASING_ENABLED_FLAG PURCHASING_ENABLED_FLAG, msi.CUSTOMER_ORDER_ENABLED_FLAG CUSTOMER_ORDER_ENABLED_FLAG, msi.INTERNAL_ORDER_ENABLED_FLAG INTERNAL_ORDER_ENABLED_FLAG, msi.SO_TRANSACTIONS_FLAG SO_TRANSACTIONS_FLAG, msi.MTL_TRANSACTIONS_ENABLED_FLAG MTL_TRANSACTIONS_ENABLED_FLAG, msi.STOCK_ENABLED_FLAG STOCK_ENABLED_FLAG, msi.BOM_ENABLED_FLAG BOM_ENABLED_FLAG, msi.BUILD_IN_WIP_FLAG BUILD_IN_WIP_FLAG, NVL(msi.CATALOG_STATUS_FLAG,'N') CATALOG_STATUS_FLAG, NVL(msi.RETURNABLE_FLAG,'N') RETURNABLE_FLAG, NVL(msi.COLLATERAL_FLAG,'N') COLLATERAL_FLAG, NVL(msi.TAXABLE_FLAG,'N') TAXABLE_FLAG, NVL(msi.INSPECTION_REQUIRED_FLAG,'N') INSPECTION_REQUIRED_FLAG, NVL(msi.RECEIPT_REQUIRED_FLAG,'N') RECEIPT_REQUIRED_FLAG, NVL(msi.RFQ_REQUIRED_FLAG,'N') RFQ_REQUIRED_FLAG, NVL(msi.ALLOW_SUBSTITUTE_RECEIPTS_FLAG,'N') ALLOW_SUBSTITUTE_RECEIPTS_FLAG, NVL(msi.ALLOW_UNORDERED_RECEIPTS_FLAG,'N') ALLOW_UNORDERED_RECEIPTS_FLAG, NVL(msi.ALLOW_EXPRESS_DELIVERY_FLAG,'N') ALLOW_EXPRESS_DELIVERY_FLAG, NVL(msi.SOURCE_TYPE,1) SOURCE_TYPE, msi.SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, msi.SOURCE_SUBINVENTORY SOURCE_SUBINVENTORY, NVL(msi.MRP_CALCULATE_ATP_FLAG,'N') MRP_CALCULATE_ATP_FLAG, NVL(msi.REPETITIVE_PLANNING_FLAG,'N') REPETITIVE_PLANNING_FLAG, msi.BOM_ITEM_TYPE BOM_ITEM_TYPE, msi.PICK_COMPONENTS_FLAG PICK_COMPONENTS_FLAG, msi.ATP_COMPONENTS_FLAG ATP_COMPONENTS_FLAG, msi.ATP_FLAG ATP_FLAG, msi.WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE, msi.WIP_SUPPLY_SUBINVENTORY WIP_SUPPLY_SUBINVENTORY, msi.PRIMARY_UOM_CODE PRIMARY_UOM_CODE, NVL(msi.DEFAULT_INCLUDE_IN_ROLLUP_FLAG,'N') DEFAULT_INCLUDE_IN_ROLLUP_FLAG, msi.INVENTORY_PLANNING_CODE INVENTORY_PLANNING_CODE, msi.PLANNING_MAKE_BUY_CODE PLANNING_MAKE_BUY_CODE, Decode(msi.RESERVABLE_TYPE, 1,'Y', 'N') RESERVABLE_TYPE, msi.VENDOR_WARRANTY_FLAG VENDOR_WARRANTY_FLAG, NVL(msi.SERVICEABLE_COMPONENT_FLAG,'N') SERVICEABLE_COMPONENT_FLAG, msi.SERVICEABLE_PRODUCT_FLAG SERVICEABLE_PRODUCT_FLAG, NVL(msi.PREVENTIVE_MAINTENANCE_FLAG,'N') PREVENTIVE_MAINTENANCE_FLAG, NVL(msi.TIME_BILLABLE_FLAG,'N') TIME_BILLABLE_FLAG, NVL(msi.MATERIAL_BILLABLE_FLAG,'M') MATERIAL_BILLABLE_FLAG, NVL(msi.EXPENSE_BILLABLE_FLAG,'N') EXPENSE_BILLABLE_FLAG, NVL(msi.PRORATE_SERVICE_FLAG,'N') PRORATE_SERVICE_FLAG, msi.INVOICEABLE_ITEM_FLAG INVOICEABLE_ITEM_FLAG, msi.INVOICE_ENABLED_FLAG INVOICE_ENABLED_FLAG, msi.OUTSIDE_OPERATION_FLAG OUTSIDE_OPERATION_FLAG, msi.COSTING_ENABLED_FLAG COSTING_ENABLED_FLAG, msi.AUTO_CREATED_CONFIG_FLAG AUTO_CREATED_CONFIG_FLAG, msi.CYCLE_COUNT_ENABLED_FLAG CYCLE_COUNT_ENABLED_FLAG, msi.ITEM_TYPE ITEM_TYPE, NVL(msi.SHIP_MODEL_COMPLETE_FLAG,'N') SHIP_MODEL_COMPLETE_FLAG, msi.MRP_PLANNING_CODE MRP_PLANNING_CODE, Decode(msi.RETURN_INSPECTION_REQUIREMENT, 1,'Y', 'N') RETURN_INSPECTION_REQUIREMENT, msi.ATO_FORECAST_CONTROL ATO_FORECAST_CONTROL, NVL(msi.CONTAINER_ITEM_FLAG,'N') CONTAINER_ITEM_FLAG, NVL(msi.VEHICLE_ITEM_FLAG,'N') VEHICLE_ITEM_FLAG, msi.CONTAINER_TYPE_CODE CONTAINER_TYPE_CODE, msi.ATTRIBUTE_CATEGORY ITEM_ATTRIBUTE_CATEGORY, msi.ATTRIBUTE1 ITEM_ATTRIBUTE1, msi.ATTRIBUTE2 ITEM_ATTRIBUTE2, msi.ATTRIBUTE3 ITEM_ATTRIBUTE3, msi.ATTRIBUTE4 ITEM_ATTRIBUTE4, msi.ATTRIBUTE5 ITEM_ATTRIBUTE5, msi.ATTRIBUTE6 ITEM_ATTRIBUTE6, msi.ATTRIBUTE7 ITEM_ATTRIBUTE7, msi.ATTRIBUTE8 ITEM_ATTRIBUTE8, msi.ATTRIBUTE9 ITEM_ATTRIBUTE9, msi.ATTRIBUTE10 ITEM_ATTRIBUTE10, msi.ATTRIBUTE11 ITEM_ATTRIBUTE11, msi.ATTRIBUTE12 ITEM_ATTRIBUTE12, msi.ATTRIBUTE13 ITEM_ATTRIBUTE13, msi.ATTRIBUTE14 ITEM_ATTRIBUTE14, msi.ATTRIBUTE15 ITEM_ATTRIBUTE15, msi.ATTRIBUTE16 ITEM_ATTRIBUTE16, msi.ATTRIBUTE17 ITEM_ATTRIBUTE17, msi.ATTRIBUTE18 ITEM_ATTRIBUTE18, msi.ATTRIBUTE19 ITEM_ATTRIBUTE19, msi.ATTRIBUTE20 ITEM_ATTRIBUTE20, msi.ATTRIBUTE21 ITEM_ATTRIBUTE21, msi.ATTRIBUTE22 ITEM_ATTRIBUTE22, msi.ATTRIBUTE23 ITEM_ATTRIBUTE23, msi.ATTRIBUTE24 ITEM_ATTRIBUTE24, msi.ATTRIBUTE25 ITEM_ATTRIBUTE25, msi.ATTRIBUTE26 ITEM_ATTRIBUTE26, msi.ATTRIBUTE27 ITEM_ATTRIBUTE27, msi.ATTRIBUTE28 ITEM_ATTRIBUTE28, msi.ATTRIBUTE29 ITEM_ATTRIBUTE29, msi.ATTRIBUTE30 ITEM_ATTRIBUTE30, msi.SEGMENT1 ITEM_SEGMENT1, msi.SEGMENT2 ITEM_SEGMENT2, msi.SEGMENT3 ITEM_SEGMENT3, msi.SEGMENT4 ITEM_SEGMENT4, msi.SEGMENT5 ITEM_SEGMENT5, msi.SEGMENT6 ITEM_SEGMENT6, msi.SEGMENT7 ITEM_SEGMENT7, msi.SEGMENT8 ITEM_SEGMENT8, msi.SEGMENT9 ITEM_SEGMENT9, msi.SEGMENT10 ITEM_SEGMENT10, msi.SEGMENT11 ITEM_SEGMENT11, msi.SEGMENT12 ITEM_SEGMENT12, msi.SEGMENT13 ITEM_SEGMENT13, msi.SEGMENT14 ITEM_SEGMENT14, msi.SEGMENT15 ITEM_SEGMENT15, msi.SEGMENT16 ITEM_SEGMENT16, msi.SEGMENT17 ITEM_SEGMENT17, msi.SEGMENT18 ITEM_SEGMENT18, msi.SEGMENT19 ITEM_SEGMENT19, msi.SEGMENT20 ITEM_SEGMENT20, Decode(msi.EQUIPMENT_TYPE, 1,'Y', 'N') EQUIPMENT_TYPE, NVL(msi.DEFECT_TRACKING_ON_FLAG,'N') DEFECT_TRACKING_ON_FLAG, NVL(msi.USAGE_ITEM_FLAG,'N') USAGE_ITEM_FLAG, NVL(msi.EVENT_FLAG,'N') EVENT_FLAG, NVL(msi.ELECTRONIC_FLAG,'N') ELECTRONIC_FLAG, NVL(msi.DOWNLOADABLE_FLAG,'N') DOWNLOADABLE_FLAG, NVL(msi.VOL_DISCOUNT_EXEMPT_FLAG,'N') VOL_DISCOUNT_EXEMPT_FLAG, NVL(msi.COUPON_EXEMPT_FLAG,'N') COUPON_EXEMPT_FLAG, NVL(msi.COMMS_NL_TRACKABLE_FLAG,'N') COMMS_NL_TRACKABLE_FLAG, msi.ASSET_CREATION_CODE ASSET_CREATION_CODE, NVL(msi.ORDERABLE_ON_WEB_FLAG,'N') ORDERABLE_ON_WEB_FLAG, NVL(msi.BACK_ORDERABLE_FLAG,'N') BACK_ORDERABLE_FLAG, NVL(msi.INDIVISIBLE_FLAG,'N') INDIVISIBLE_FLAG, NVL(msi.LOT_STATUS_ENABLED,'N') LOT_STATUS_ENABLED, NVL(msi.SERIAL_STATUS_ENABLED,'N') SERIAL_STATUS_ENABLED, NVL(msi.LOT_SPLIT_ENABLED,'N') LOT_SPLIT_ENABLED, NVL(msi.LOT_MERGE_ENABLED,'N') LOT_MERGE_ENABLED, NVL(msi.FINANCING_ALLOWED_FLAG,'N') FINANCING_ALLOWED_FLAG, msi.EAM_ITEM_TYPE EAM_ITEM_TYPE, msi.EAM_ACTIVITY_TYPE_CODE EAM_ACTIVITY_TYPE_CODE, msi.EAM_ACTIVITY_CAUSE_CODE EAM_ACTIVITY_CAUSE_CODE, NVL(msi.EAM_ACT_NOTIFICATION_FLAG,'N') EAM_ACT_NOTIFICATION_FLAG, msi.CONTRACT_ITEM_TYPE_CODE CONTRACT_ITEM_TYPE_CODE, NVL(msi.SUBSCRIPTION_DEPEND_FLAG,'N') SUBSCRIPTION_DEPEND_FLAG, msi.SERV_REQ_ENABLED_CODE SERV_REQ_ENABLED_CODE, NVL(msi.SERV_BILLING_ENABLED_FLAG,'N') SERV_BILLING_ENABLED_FLAG, NVL(msi.LOT_TRANSLATE_ENABLED,'N') LOT_TRANSLATE_ENABLED, msi.IB_ITEM_INSTANCE_CLASS IB_ITEM_INSTANCE_CLASS, msi.CONFIG_MODEL_TYPE CONFIG_MODEL_TYPE, NVL(msi.LOT_SUBSTITUTION_ENABLED,'N') LOT_SUBSTITUTION_ENABLED, msi.EAM_ACTIVITY_SOURCE_CODE EAM_ACTIVITY_SOURCE_CODE, Decode(msi.CONSIGNED_FLAG, 1,'Y', 'N') CONSIGNED_ITEM_FLAG, msi.VMI_FORECAST_TYPE VMI_FORECAST_TYPE, Decode(msi.EXCLUDE_FROM_BUDGET_FLAG, 1,'Y', 'N') EXCLUDE_FROM_BUDGET_FLAG, NVL(msi.CHILD_LOT_FLAG,'N') CHILD_LOT_FLAG, NVL(msi.COPY_LOT_ATTRIBUTE_FLAG,'N') COPY_LOT_ATTRIBUTE_FLAG, NVL(msi.PROCESS_COSTING_ENABLED_FLAG,'N') PROCESS_COSTING_ENABLED_FLAG, NVL(msi.PROCESS_EXECUTION_ENABLED_FLAG,'N') PROCESS_EXECUTION_ENABLED_FLAG, NVL(msi.PROCESS_QUALITY_ENABLED_FLAG,'N') PROCESS_QUALITY_ENABLED_FLAG, NVL(msi.RECIPE_ENABLED_FLAG,'N') RECIPE_ENABLED_FLAG, CIC.BASED_ON_ROLLUP_FLAG BASED_ON_ROLLUP_FLAG, CIC.SHRINKAGE_RATE SHRINKAGE_RATE, msi.EXPENSE_ACCOUNT INV_ITEM_EXPENSE_ACCT FROM mtl_system_items msi , mtl_system_items_kfv msik ,(SELECT c.BASED_ON_ROLLUP_FLAG , C.SHRINKAGE_RATE , c.INVENTORY_ASSET_FLAG , c.inventory_item_id , mp.organization_id FROM cst_item_costs c , mtl_parameters mp where c.organization_id = mp.cost_organization_id AND c.cost_type_id = mp.primary_cost_method) cic WHERE msi.organization_id = msik.organization_id AND msi.inventory_item_id = msik.inventory_item_id AND cic.inventory_item_id(+) = msi.inventory_item_id AND cic.organization_id(+) = msi.organization_id

View Text - HTML Formatted

SELECT MSI.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MSI.ORGANIZATION_ID ORGANIZATION_ID
, MSIK.CONCATENATED_SEGMENTS ITEM_CONCATENATED_SEGMENTS
, MSI.DESCRIPTION ITEM_DESCRIPTION
, MSI.PURCHASING_ITEM_FLAG PURCHASING_ITEM_FLAG
, MSI.SHIPPABLE_ITEM_FLAG SHIPPABLE_ITEM_FLAG
, MSI.CUSTOMER_ORDER_FLAG CUSTOMER_ORDER_FLAG
, MSI.INTERNAL_ORDER_FLAG INTERNAL_ORDER_FLAG
, MSI.SERVICE_ITEM_FLAG SERVICE_ITEM_FLAG
, MSI.INVENTORY_ITEM_FLAG INVENTORY_ITEM_FLAG
, MSI.ENG_ITEM_FLAG ENG_ITEM_FLAG
, CIC.INVENTORY_ASSET_FLAG INVENTORY_ASSET_FLAG
, MSI.PURCHASING_ENABLED_FLAG PURCHASING_ENABLED_FLAG
, MSI.CUSTOMER_ORDER_ENABLED_FLAG CUSTOMER_ORDER_ENABLED_FLAG
, MSI.INTERNAL_ORDER_ENABLED_FLAG INTERNAL_ORDER_ENABLED_FLAG
, MSI.SO_TRANSACTIONS_FLAG SO_TRANSACTIONS_FLAG
, MSI.MTL_TRANSACTIONS_ENABLED_FLAG MTL_TRANSACTIONS_ENABLED_FLAG
, MSI.STOCK_ENABLED_FLAG STOCK_ENABLED_FLAG
, MSI.BOM_ENABLED_FLAG BOM_ENABLED_FLAG
, MSI.BUILD_IN_WIP_FLAG BUILD_IN_WIP_FLAG
, NVL(MSI.CATALOG_STATUS_FLAG
, 'N') CATALOG_STATUS_FLAG
, NVL(MSI.RETURNABLE_FLAG
, 'N') RETURNABLE_FLAG
, NVL(MSI.COLLATERAL_FLAG
, 'N') COLLATERAL_FLAG
, NVL(MSI.TAXABLE_FLAG
, 'N') TAXABLE_FLAG
, NVL(MSI.INSPECTION_REQUIRED_FLAG
, 'N') INSPECTION_REQUIRED_FLAG
, NVL(MSI.RECEIPT_REQUIRED_FLAG
, 'N') RECEIPT_REQUIRED_FLAG
, NVL(MSI.RFQ_REQUIRED_FLAG
, 'N') RFQ_REQUIRED_FLAG
, NVL(MSI.ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, 'N') ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, NVL(MSI.ALLOW_UNORDERED_RECEIPTS_FLAG
, 'N') ALLOW_UNORDERED_RECEIPTS_FLAG
, NVL(MSI.ALLOW_EXPRESS_DELIVERY_FLAG
, 'N') ALLOW_EXPRESS_DELIVERY_FLAG
, NVL(MSI.SOURCE_TYPE
, 1) SOURCE_TYPE
, MSI.SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, MSI.SOURCE_SUBINVENTORY SOURCE_SUBINVENTORY
, NVL(MSI.MRP_CALCULATE_ATP_FLAG
, 'N') MRP_CALCULATE_ATP_FLAG
, NVL(MSI.REPETITIVE_PLANNING_FLAG
, 'N') REPETITIVE_PLANNING_FLAG
, MSI.BOM_ITEM_TYPE BOM_ITEM_TYPE
, MSI.PICK_COMPONENTS_FLAG PICK_COMPONENTS_FLAG
, MSI.ATP_COMPONENTS_FLAG ATP_COMPONENTS_FLAG
, MSI.ATP_FLAG ATP_FLAG
, MSI.WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
, MSI.WIP_SUPPLY_SUBINVENTORY WIP_SUPPLY_SUBINVENTORY
, MSI.PRIMARY_UOM_CODE PRIMARY_UOM_CODE
, NVL(MSI.DEFAULT_INCLUDE_IN_ROLLUP_FLAG
, 'N') DEFAULT_INCLUDE_IN_ROLLUP_FLAG
, MSI.INVENTORY_PLANNING_CODE INVENTORY_PLANNING_CODE
, MSI.PLANNING_MAKE_BUY_CODE PLANNING_MAKE_BUY_CODE
, DECODE(MSI.RESERVABLE_TYPE
, 1
, 'Y'
, 'N') RESERVABLE_TYPE
, MSI.VENDOR_WARRANTY_FLAG VENDOR_WARRANTY_FLAG
, NVL(MSI.SERVICEABLE_COMPONENT_FLAG
, 'N') SERVICEABLE_COMPONENT_FLAG
, MSI.SERVICEABLE_PRODUCT_FLAG SERVICEABLE_PRODUCT_FLAG
, NVL(MSI.PREVENTIVE_MAINTENANCE_FLAG
, 'N') PREVENTIVE_MAINTENANCE_FLAG
, NVL(MSI.TIME_BILLABLE_FLAG
, 'N') TIME_BILLABLE_FLAG
, NVL(MSI.MATERIAL_BILLABLE_FLAG
, 'M') MATERIAL_BILLABLE_FLAG
, NVL(MSI.EXPENSE_BILLABLE_FLAG
, 'N') EXPENSE_BILLABLE_FLAG
, NVL(MSI.PRORATE_SERVICE_FLAG
, 'N') PRORATE_SERVICE_FLAG
, MSI.INVOICEABLE_ITEM_FLAG INVOICEABLE_ITEM_FLAG
, MSI.INVOICE_ENABLED_FLAG INVOICE_ENABLED_FLAG
, MSI.OUTSIDE_OPERATION_FLAG OUTSIDE_OPERATION_FLAG
, MSI.COSTING_ENABLED_FLAG COSTING_ENABLED_FLAG
, MSI.AUTO_CREATED_CONFIG_FLAG AUTO_CREATED_CONFIG_FLAG
, MSI.CYCLE_COUNT_ENABLED_FLAG CYCLE_COUNT_ENABLED_FLAG
, MSI.ITEM_TYPE ITEM_TYPE
, NVL(MSI.SHIP_MODEL_COMPLETE_FLAG
, 'N') SHIP_MODEL_COMPLETE_FLAG
, MSI.MRP_PLANNING_CODE MRP_PLANNING_CODE
, DECODE(MSI.RETURN_INSPECTION_REQUIREMENT
, 1
, 'Y'
, 'N') RETURN_INSPECTION_REQUIREMENT
, MSI.ATO_FORECAST_CONTROL ATO_FORECAST_CONTROL
, NVL(MSI.CONTAINER_ITEM_FLAG
, 'N') CONTAINER_ITEM_FLAG
, NVL(MSI.VEHICLE_ITEM_FLAG
, 'N') VEHICLE_ITEM_FLAG
, MSI.CONTAINER_TYPE_CODE CONTAINER_TYPE_CODE
, MSI.ATTRIBUTE_CATEGORY ITEM_ATTRIBUTE_CATEGORY
, MSI.ATTRIBUTE1 ITEM_ATTRIBUTE1
, MSI.ATTRIBUTE2 ITEM_ATTRIBUTE2
, MSI.ATTRIBUTE3 ITEM_ATTRIBUTE3
, MSI.ATTRIBUTE4 ITEM_ATTRIBUTE4
, MSI.ATTRIBUTE5 ITEM_ATTRIBUTE5
, MSI.ATTRIBUTE6 ITEM_ATTRIBUTE6
, MSI.ATTRIBUTE7 ITEM_ATTRIBUTE7
, MSI.ATTRIBUTE8 ITEM_ATTRIBUTE8
, MSI.ATTRIBUTE9 ITEM_ATTRIBUTE9
, MSI.ATTRIBUTE10 ITEM_ATTRIBUTE10
, MSI.ATTRIBUTE11 ITEM_ATTRIBUTE11
, MSI.ATTRIBUTE12 ITEM_ATTRIBUTE12
, MSI.ATTRIBUTE13 ITEM_ATTRIBUTE13
, MSI.ATTRIBUTE14 ITEM_ATTRIBUTE14
, MSI.ATTRIBUTE15 ITEM_ATTRIBUTE15
, MSI.ATTRIBUTE16 ITEM_ATTRIBUTE16
, MSI.ATTRIBUTE17 ITEM_ATTRIBUTE17
, MSI.ATTRIBUTE18 ITEM_ATTRIBUTE18
, MSI.ATTRIBUTE19 ITEM_ATTRIBUTE19
, MSI.ATTRIBUTE20 ITEM_ATTRIBUTE20
, MSI.ATTRIBUTE21 ITEM_ATTRIBUTE21
, MSI.ATTRIBUTE22 ITEM_ATTRIBUTE22
, MSI.ATTRIBUTE23 ITEM_ATTRIBUTE23
, MSI.ATTRIBUTE24 ITEM_ATTRIBUTE24
, MSI.ATTRIBUTE25 ITEM_ATTRIBUTE25
, MSI.ATTRIBUTE26 ITEM_ATTRIBUTE26
, MSI.ATTRIBUTE27 ITEM_ATTRIBUTE27
, MSI.ATTRIBUTE28 ITEM_ATTRIBUTE28
, MSI.ATTRIBUTE29 ITEM_ATTRIBUTE29
, MSI.ATTRIBUTE30 ITEM_ATTRIBUTE30
, MSI.SEGMENT1 ITEM_SEGMENT1
, MSI.SEGMENT2 ITEM_SEGMENT2
, MSI.SEGMENT3 ITEM_SEGMENT3
, MSI.SEGMENT4 ITEM_SEGMENT4
, MSI.SEGMENT5 ITEM_SEGMENT5
, MSI.SEGMENT6 ITEM_SEGMENT6
, MSI.SEGMENT7 ITEM_SEGMENT7
, MSI.SEGMENT8 ITEM_SEGMENT8
, MSI.SEGMENT9 ITEM_SEGMENT9
, MSI.SEGMENT10 ITEM_SEGMENT10
, MSI.SEGMENT11 ITEM_SEGMENT11
, MSI.SEGMENT12 ITEM_SEGMENT12
, MSI.SEGMENT13 ITEM_SEGMENT13
, MSI.SEGMENT14 ITEM_SEGMENT14
, MSI.SEGMENT15 ITEM_SEGMENT15
, MSI.SEGMENT16 ITEM_SEGMENT16
, MSI.SEGMENT17 ITEM_SEGMENT17
, MSI.SEGMENT18 ITEM_SEGMENT18
, MSI.SEGMENT19 ITEM_SEGMENT19
, MSI.SEGMENT20 ITEM_SEGMENT20
, DECODE(MSI.EQUIPMENT_TYPE
, 1
, 'Y'
, 'N') EQUIPMENT_TYPE
, NVL(MSI.DEFECT_TRACKING_ON_FLAG
, 'N') DEFECT_TRACKING_ON_FLAG
, NVL(MSI.USAGE_ITEM_FLAG
, 'N') USAGE_ITEM_FLAG
, NVL(MSI.EVENT_FLAG
, 'N') EVENT_FLAG
, NVL(MSI.ELECTRONIC_FLAG
, 'N') ELECTRONIC_FLAG
, NVL(MSI.DOWNLOADABLE_FLAG
, 'N') DOWNLOADABLE_FLAG
, NVL(MSI.VOL_DISCOUNT_EXEMPT_FLAG
, 'N') VOL_DISCOUNT_EXEMPT_FLAG
, NVL(MSI.COUPON_EXEMPT_FLAG
, 'N') COUPON_EXEMPT_FLAG
, NVL(MSI.COMMS_NL_TRACKABLE_FLAG
, 'N') COMMS_NL_TRACKABLE_FLAG
, MSI.ASSET_CREATION_CODE ASSET_CREATION_CODE
, NVL(MSI.ORDERABLE_ON_WEB_FLAG
, 'N') ORDERABLE_ON_WEB_FLAG
, NVL(MSI.BACK_ORDERABLE_FLAG
, 'N') BACK_ORDERABLE_FLAG
, NVL(MSI.INDIVISIBLE_FLAG
, 'N') INDIVISIBLE_FLAG
, NVL(MSI.LOT_STATUS_ENABLED
, 'N') LOT_STATUS_ENABLED
, NVL(MSI.SERIAL_STATUS_ENABLED
, 'N') SERIAL_STATUS_ENABLED
, NVL(MSI.LOT_SPLIT_ENABLED
, 'N') LOT_SPLIT_ENABLED
, NVL(MSI.LOT_MERGE_ENABLED
, 'N') LOT_MERGE_ENABLED
, NVL(MSI.FINANCING_ALLOWED_FLAG
, 'N') FINANCING_ALLOWED_FLAG
, MSI.EAM_ITEM_TYPE EAM_ITEM_TYPE
, MSI.EAM_ACTIVITY_TYPE_CODE EAM_ACTIVITY_TYPE_CODE
, MSI.EAM_ACTIVITY_CAUSE_CODE EAM_ACTIVITY_CAUSE_CODE
, NVL(MSI.EAM_ACT_NOTIFICATION_FLAG
, 'N') EAM_ACT_NOTIFICATION_FLAG
, MSI.CONTRACT_ITEM_TYPE_CODE CONTRACT_ITEM_TYPE_CODE
, NVL(MSI.SUBSCRIPTION_DEPEND_FLAG
, 'N') SUBSCRIPTION_DEPEND_FLAG
, MSI.SERV_REQ_ENABLED_CODE SERV_REQ_ENABLED_CODE
, NVL(MSI.SERV_BILLING_ENABLED_FLAG
, 'N') SERV_BILLING_ENABLED_FLAG
, NVL(MSI.LOT_TRANSLATE_ENABLED
, 'N') LOT_TRANSLATE_ENABLED
, MSI.IB_ITEM_INSTANCE_CLASS IB_ITEM_INSTANCE_CLASS
, MSI.CONFIG_MODEL_TYPE CONFIG_MODEL_TYPE
, NVL(MSI.LOT_SUBSTITUTION_ENABLED
, 'N') LOT_SUBSTITUTION_ENABLED
, MSI.EAM_ACTIVITY_SOURCE_CODE EAM_ACTIVITY_SOURCE_CODE
, DECODE(MSI.CONSIGNED_FLAG
, 1
, 'Y'
, 'N') CONSIGNED_ITEM_FLAG
, MSI.VMI_FORECAST_TYPE VMI_FORECAST_TYPE
, DECODE(MSI.EXCLUDE_FROM_BUDGET_FLAG
, 1
, 'Y'
, 'N') EXCLUDE_FROM_BUDGET_FLAG
, NVL(MSI.CHILD_LOT_FLAG
, 'N') CHILD_LOT_FLAG
, NVL(MSI.COPY_LOT_ATTRIBUTE_FLAG
, 'N') COPY_LOT_ATTRIBUTE_FLAG
, NVL(MSI.PROCESS_COSTING_ENABLED_FLAG
, 'N') PROCESS_COSTING_ENABLED_FLAG
, NVL(MSI.PROCESS_EXECUTION_ENABLED_FLAG
, 'N') PROCESS_EXECUTION_ENABLED_FLAG
, NVL(MSI.PROCESS_QUALITY_ENABLED_FLAG
, 'N') PROCESS_QUALITY_ENABLED_FLAG
, NVL(MSI.RECIPE_ENABLED_FLAG
, 'N') RECIPE_ENABLED_FLAG
, CIC.BASED_ON_ROLLUP_FLAG BASED_ON_ROLLUP_FLAG
, CIC.SHRINKAGE_RATE SHRINKAGE_RATE
, MSI.EXPENSE_ACCOUNT INV_ITEM_EXPENSE_ACCT
FROM MTL_SYSTEM_ITEMS MSI
, MTL_SYSTEM_ITEMS_KFV MSIK
, (SELECT C.BASED_ON_ROLLUP_FLAG
, C.SHRINKAGE_RATE
, C.INVENTORY_ASSET_FLAG
, C.INVENTORY_ITEM_ID
, MP.ORGANIZATION_ID
FROM CST_ITEM_COSTS C
, MTL_PARAMETERS MP
WHERE C.ORGANIZATION_ID = MP.COST_ORGANIZATION_ID
AND C.COST_TYPE_ID = MP.PRIMARY_COST_METHOD) CIC
WHERE MSI.ORGANIZATION_ID = MSIK.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
AND CIC.INVENTORY_ITEM_ID(+) = MSI.INVENTORY_ITEM_ID
AND CIC.ORGANIZATION_ID(+) = MSI.ORGANIZATION_ID