View: CST_XLA_INV_SYSTEM_ITEMS_REF_V

Product:	BOM - Bills of Material
Description:
Implementation/DBA Data:	APPS.CST_XLA_INV_SYSTEM_ITEMS_REF_V

View Text

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
, CST_ITEM_COSTS CIC
, MTL_PARAMETERS MP
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
AND MP.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND CIC.COST_TYPE_ID = MP.PRIMARY_COST_METHOD

Columns