CST_XLA_SYSTEM_ITEMS

Details

Schema: FUSION
Object owner: CST
Object type: VIEW

Columns

Name
INVENTORY_ITEM_ID ITEM_DESCRIPTION INV_ORG_ID ITEM_NUMBER PURCHASING_ITEM_FLAG SHIPPABLE_ITEM_FLAG CUSTOMER_ORDER_FLAG INTERNAL_ORDER_FLAG INVENTORY_ITEM_FLAG INVENTORY_ASSET_FLAG PURCHASING_ENABLED_FLAG CUSTOMER_ORDER_ENABLED_FLAG INTERNAL_ORDER_ENABLED_FLAG SO_TRANSACTIONS_FLAG MTL_TRANSACTIONS_ENABLED_FLAG STOCK_ENABLED_FLAG BUILD_IN_WIP_FLAG RETURNABLE_FLAG COLLATERAL_FLAG TAXABLE_FLAG INSPECTION_REQUIRED_FLAG RECEIPT_REQUIRED_FLAG ALLOW_SUBSTITUTE_RECEIPTS_FLAG ALLOW_UNORDERED_RECEIPTS_FLAG ALLOW_EXPRESS_DELIVERY_FLAG SOURCE_TYPE SOURCE_ORGANIZATION_ID SOURCE_SUBINVENTORY MRP_CALCULATE_ATP_FLAG REPETITIVE_PLANNING_FLAG BOM_ITEM_TYPE PICK_COMPONENTS_FLAG ATP_COMPONENTS_FLAG ATP_FLAG WIP_SUPPLY_TYPE WIP_SUPPLY_SUBINVENTORY PRIMARY_UOM_CODE DEFAULT_INCLUDE_IN_ROLLUP_FLAG INVENTORY_PLANNING_CODE PLANNING_MAKE_BUY_CODE RESERVABLE_TYPE SERVICEABLE_PRODUCT_FLAG MATERIAL_BILLABLE_FLAG INVOICEABLE_ITEM_FLAG INVOICE_ENABLED_FLAG OUTSIDE_OPERATION_FLAG COSTING_ENABLED_FLAG AUTO_CREATED_CONFIG_FLAG CYCLE_COUNT_ENABLED_FLAG ITEM_TYPE SHIP_MODEL_COMPLETE_FLAG MRP_PLANNING_CODE RETURN_INSPECTION_REQUIREMENT ATO_FORECAST_CONTROL CONTAINER_ITEM_FLAG VEHICLE_ITEM_FLAG CONTAINER_TYPE_CODE ITEM_ATTRIBUTE_CATEGORY ITEM_ATTRIBUTE1 ITEM_ATTRIBUTE2 ITEM_ATTRIBUTE3 ITEM_ATTRIBUTE4 ITEM_ATTRIBUTE5 ITEM_ATTRIBUTE6 ITEM_ATTRIBUTE7 ITEM_ATTRIBUTE8 ITEM_ATTRIBUTE9 ITEM_ATTRIBUTE10 ITEM_ATTRIBUTE11 ITEM_ATTRIBUTE12 ITEM_ATTRIBUTE13 ITEM_ATTRIBUTE14 ITEM_ATTRIBUTE15 ITEM_ATTRIBUTE16 ITEM_ATTRIBUTE17 ITEM_ATTRIBUTE18 ITEM_ATTRIBUTE19 ITEM_ATTRIBUTE20 ITEM_ATTRIBUTE21 ITEM_ATTRIBUTE22 ITEM_ATTRIBUTE23 ITEM_ATTRIBUTE24 ITEM_ATTRIBUTE25 ITEM_ATTRIBUTE26 ITEM_ATTRIBUTE27 ITEM_ATTRIBUTE28 ITEM_ATTRIBUTE29 ITEM_ATTRIBUTE30 EQUIPMENT_TYPE DEFECT_TRACKING_ON_FLAG EVENT_FLAG ELECTRONIC_FLAG DOWNLOADABLE_FLAG COMMS_NL_TRACKABLE_FLAG ASSET_CREATION_CODE ORDERABLE_ON_WEB_FLAG BACK_ORDERABLE_FLAG INDIVISIBLE_FLAG LOT_STATUS_ENABLED SERIAL_STATUS_ENABLED LOT_SPLIT_ENABLED LOT_MERGE_ENABLED FINANCING_ALLOWED_FLAG EAM_ITEM_TYPE EAM_ACTIVITY_TYPE_CODE EAM_ACTIVITY_CAUSE_CODE EAM_ACT_NOTIFICATION_FLAG CONTRACT_ITEM_TYPE_CODE SERV_REQ_ENABLED_CODE SERV_BILLING_ENABLED_FLAG LOT_TRANSLATE_ENABLED IB_ITEM_INSTANCE_CLASS CONFIG_MODEL_TYPE LOT_SUBSTITUTION_ENABLED EAM_ACTIVITY_SOURCE_CODE CONSIGNED_FLAG VMI_FORECAST_TYPE EXCLUDE_FROM_BUDGET_FLAG CHILD_LOT_FLAG COPY_LOT_ATTRIBUTE_FLAG OUTSIDE_PROCESS_SERVICE_FLAG ITEM_SALES_ACCOUNT ITEM_CLASS_ID

Name

INVENTORY_ITEM_ID

ITEM_DESCRIPTION

INV_ORG_ID

ITEM_NUMBER

PURCHASING_ITEM_FLAG

SHIPPABLE_ITEM_FLAG

CUSTOMER_ORDER_FLAG

INTERNAL_ORDER_FLAG

INVENTORY_ITEM_FLAG

INVENTORY_ASSET_FLAG

PURCHASING_ENABLED_FLAG

CUSTOMER_ORDER_ENABLED_FLAG

INTERNAL_ORDER_ENABLED_FLAG

SO_TRANSACTIONS_FLAG

MTL_TRANSACTIONS_ENABLED_FLAG

STOCK_ENABLED_FLAG

BUILD_IN_WIP_FLAG

RETURNABLE_FLAG

COLLATERAL_FLAG

TAXABLE_FLAG

INSPECTION_REQUIRED_FLAG

RECEIPT_REQUIRED_FLAG

ALLOW_SUBSTITUTE_RECEIPTS_FLAG

ALLOW_UNORDERED_RECEIPTS_FLAG

ALLOW_EXPRESS_DELIVERY_FLAG

SOURCE_TYPE

SOURCE_ORGANIZATION_ID

SOURCE_SUBINVENTORY

MRP_CALCULATE_ATP_FLAG

REPETITIVE_PLANNING_FLAG

BOM_ITEM_TYPE

PICK_COMPONENTS_FLAG

ATP_COMPONENTS_FLAG

ATP_FLAG

WIP_SUPPLY_TYPE

WIP_SUPPLY_SUBINVENTORY

PRIMARY_UOM_CODE

DEFAULT_INCLUDE_IN_ROLLUP_FLAG

INVENTORY_PLANNING_CODE

PLANNING_MAKE_BUY_CODE

RESERVABLE_TYPE

SERVICEABLE_PRODUCT_FLAG

MATERIAL_BILLABLE_FLAG

INVOICEABLE_ITEM_FLAG

INVOICE_ENABLED_FLAG

OUTSIDE_OPERATION_FLAG

COSTING_ENABLED_FLAG

AUTO_CREATED_CONFIG_FLAG

CYCLE_COUNT_ENABLED_FLAG

ITEM_TYPE

SHIP_MODEL_COMPLETE_FLAG

MRP_PLANNING_CODE

RETURN_INSPECTION_REQUIREMENT

ATO_FORECAST_CONTROL

CONTAINER_ITEM_FLAG

VEHICLE_ITEM_FLAG

CONTAINER_TYPE_CODE

ITEM_ATTRIBUTE_CATEGORY

ITEM_ATTRIBUTE1

ITEM_ATTRIBUTE2

ITEM_ATTRIBUTE3

ITEM_ATTRIBUTE4

ITEM_ATTRIBUTE5

ITEM_ATTRIBUTE6

ITEM_ATTRIBUTE7

ITEM_ATTRIBUTE8

ITEM_ATTRIBUTE9

ITEM_ATTRIBUTE10

ITEM_ATTRIBUTE11

ITEM_ATTRIBUTE12

ITEM_ATTRIBUTE13

ITEM_ATTRIBUTE14

ITEM_ATTRIBUTE15

ITEM_ATTRIBUTE16

ITEM_ATTRIBUTE17

ITEM_ATTRIBUTE18

ITEM_ATTRIBUTE19

ITEM_ATTRIBUTE20

ITEM_ATTRIBUTE21

ITEM_ATTRIBUTE22

ITEM_ATTRIBUTE23

ITEM_ATTRIBUTE24

ITEM_ATTRIBUTE25

ITEM_ATTRIBUTE26

ITEM_ATTRIBUTE27

ITEM_ATTRIBUTE28

ITEM_ATTRIBUTE29

ITEM_ATTRIBUTE30

EQUIPMENT_TYPE

DEFECT_TRACKING_ON_FLAG

EVENT_FLAG

ELECTRONIC_FLAG

DOWNLOADABLE_FLAG

COMMS_NL_TRACKABLE_FLAG

ASSET_CREATION_CODE

ORDERABLE_ON_WEB_FLAG

BACK_ORDERABLE_FLAG

INDIVISIBLE_FLAG

LOT_STATUS_ENABLED

SERIAL_STATUS_ENABLED

LOT_SPLIT_ENABLED

LOT_MERGE_ENABLED

FINANCING_ALLOWED_FLAG

EAM_ITEM_TYPE

EAM_ACTIVITY_TYPE_CODE

EAM_ACTIVITY_CAUSE_CODE

EAM_ACT_NOTIFICATION_FLAG

CONTRACT_ITEM_TYPE_CODE

SERV_REQ_ENABLED_CODE

SERV_BILLING_ENABLED_FLAG

LOT_TRANSLATE_ENABLED

IB_ITEM_INSTANCE_CLASS

CONFIG_MODEL_TYPE

LOT_SUBSTITUTION_ENABLED

EAM_ACTIVITY_SOURCE_CODE

CONSIGNED_FLAG

VMI_FORECAST_TYPE

EXCLUDE_FROM_BUDGET_FLAG

CHILD_LOT_FLAG

COPY_LOT_ATTRIBUTE_FLAG

OUTSIDE_PROCESS_SERVICE_FLAG

ITEM_SALES_ACCOUNT

ITEM_CLASS_ID

Query

SQL_Statement
SELECT esi.inventory_item_id inventory_item_id , esi.description item_description , esi.organization_id inv_org_id , esi.item_number item_number , esi.purchasing_item_flag purchasing_item_flag , esi.shippable_item_flag shippable_item_flag , esi.customer_order_flag customer_order_flag , esi.internal_order_flag internal_order_flag , esi.inventory_item_flag inventory_item_flag , esi.inventory_asset_flag inventory_asset_flag , esi.purchasing_enabled_flag purchasing_enabled_flag , esi.customer_order_enabled_flag customer_order_enabled_flag , esi.internal_order_enabled_flag internal_order_enabled_flag , esi.so_transactions_flag so_transactions_flag , esi.mtl_transactions_enabled_flag mtl_transactions_enabled_flag , esi.stock_enabled_flag stock_enabled_flag , esi.build_in_wip_flag build_in_wip_flag , nvl(esi.returnable_flag,'N') returnable_flag , nvl(esi.collateral_flag,'N') collateral_flag , nvl(esi.taxable_flag,'N') taxable_flag , nvl(esi.inspection_required_flag,'N') inspection_required_flag , nvl(esi.receipt_required_flag,'N') receipt_required_flag , nvl(esi.allow_substitute_receipts_flag,'N') allow_substitute_receipts_flag , nvl(esi.allow_unordered_receipts_flag,'N') allow_unordered_receipts_flag , nvl(esi.allow_express_delivery_flag,'N') allow_express_delivery_flag , nvl(esi.source_type,1) source_type , esi.source_organization_id source_organization_id , esi.source_subinventory source_subinventory , nvl(esi.mrp_calculate_atp_flag,'N') mrp_calculate_atp_flag , nvl(esi.repetitive_planning_flag,'N') repetitive_planning_flag , esi.bom_item_type bom_item_type , esi.pick_components_flag pick_components_flag , esi.atp_components_flag atp_components_flag , esi.atp_flag atp_flag , esi.wip_supply_type wip_supply_type , esi.wip_supply_subinventory wip_supply_subinventory , esi.primary_uom_code primary_uom_code , nvl(esi.default_include_in_rollup_flag,'N') default_include_in_rollup_flag , esi.inventory_planning_code inventory_planning_code , esi.planning_make_buy_code planning_make_buy_code , decode(esi.reservable_type,1,'Y' , 'N') reservable_type , esi.serviceable_product_flag serviceable_product_flag , nvl(esi.material_billable_flag,'M') material_billable_flag , esi.invoiceable_item_flag invoiceable_item_flag , esi.invoice_enabled_flag invoice_enabled_flag , esi.outside_operation_flag outside_operation_flag , esi.costing_enabled_flag costing_enabled_flag , esi.auto_created_config_flag auto_created_config_flag , esi.cycle_count_enabled_flag cycle_count_enabled_flag , esi.item_type item_type , nvl(esi.ship_model_complete_flag,'N') ship_model_complete_flag , esi.mrp_planning_code mrp_planning_code , decode(esi.return_inspection_requirement,1,'Y' , 'N') return_inspection_requirement , esi.ato_forecast_control ato_forecast_control , nvl(esi.container_item_flag,'N') container_item_flag , nvl(esi.vehicle_item_flag,'N') vehicle_item_flag , esi.container_type_code container_type_code , esi.attribute_category item_attribute_category , esi.attribute1 item_attribute1 , esi.attribute2 item_attribute2 , esi.attribute3 item_attribute3 , esi.attribute4 item_attribute4 , esi.attribute5 item_attribute5 , esi.attribute6 item_attribute6 , esi.attribute7 item_attribute7 , esi.attribute8 item_attribute8 , esi.attribute9 item_attribute9 , esi.attribute10 item_attribute10 , esi.attribute11 item_attribute11 , esi.attribute12 item_attribute12 , esi.attribute13 item_attribute13 , esi.attribute14 item_attribute14 , esi.attribute15 item_attribute15 , esi.attribute16 item_attribute16 , esi.attribute17 item_attribute17 , esi.attribute18 item_attribute18 , esi.attribute19 item_attribute19 , esi.attribute20 item_attribute20 , esi.attribute21 item_attribute21 , esi.attribute22 item_attribute22 , esi.attribute23 item_attribute23 , esi.attribute24 item_attribute24 , esi.attribute25 item_attribute25 , esi.attribute26 item_attribute26 , esi.attribute27 item_attribute27 , esi.attribute28 item_attribute28 , esi.attribute29 item_attribute29 , esi.attribute30 item_attribute30 , decode(esi.equipment_type,1,'Y' , 'N') equipment_type , nvl(esi.defect_tracking_on_flag,'N') defect_tracking_on_flag , nvl(esi.event_flag,'N') event_flag , nvl(esi.electronic_flag,'N') electronic_flag , nvl(esi.downloadable_flag,'N') downloadable_flag , nvl(esi.comms_nl_trackable_flag,'N') comms_nl_trackable_flag , esi.asset_creation_code asset_creation_code , nvl(esi.orderable_on_web_flag,'N') orderable_on_web_flag , nvl(esi.back_orderable_flag,'N') back_orderable_flag , nvl(esi.indivisible_flag,'N') indivisible_flag , nvl(esi.lot_status_enabled,'N') lot_status_enabled , nvl(esi.serial_status_enabled,'N') serial_status_enabled , nvl(esi.lot_split_enabled,'N') lot_split_enabled , nvl(esi.lot_merge_enabled,'N') lot_merge_enabled , nvl(esi.financing_allowed_flag,'N') financing_allowed_flag , esi.eam_item_type eam_item_type , esi.eam_activity_type_code eam_activity_type_code , esi.eam_activity_cause_code eam_activity_cause_code , nvl(esi.eam_act_notification_flag,'N') eam_act_notification_flag , esi.contract_item_type_code contract_item_type_code , esi.serv_req_enabled_code serv_req_enabled_code , nvl(esi.serv_billing_enabled_flag,'N') serv_billing_enabled_flag , nvl(esi.lot_translate_enabled,'N') lot_translate_enabled , esi.ib_item_instance_class ib_item_instance_class , esi.config_model_type config_model_type , nvl(esi.lot_substitution_enabled,'N') lot_substitution_enabled , esi.eam_activity_source_code eam_activity_source_code , decode(esi.consigned_flag,1,'Y' , 'N') consigned_flag , esi.vmi_forecast_type vmi_forecast_type , decode(esi.exclude_from_budget_flag,1,'Y' , 'N') exclude_from_budget_flag , nvl(esi.child_lot_flag,'N') child_lot_flag , nvl(esi.copy_lot_attribute_flag,'N') copy_lot_attribute_flag , NVL(esi.OUTSIDE_PROCESS_SERVICE_FLAG, 'N') OUTSIDE_PROCESS_SERVICE_FLAG , esi.sales_account item_sales_account , esi.item_catalog_group_id item_class_id FROM egp_system_items_vl esi

SQL_Statement

SELECT esi.inventory_item_id inventory_item_id

, esi.description item_description

, esi.organization_id inv_org_id

, esi.item_number item_number

, esi.purchasing_item_flag purchasing_item_flag

, esi.shippable_item_flag shippable_item_flag

, esi.customer_order_flag customer_order_flag

, esi.internal_order_flag internal_order_flag

, esi.inventory_item_flag inventory_item_flag

, esi.inventory_asset_flag inventory_asset_flag

, esi.purchasing_enabled_flag purchasing_enabled_flag

, esi.customer_order_enabled_flag customer_order_enabled_flag

, esi.internal_order_enabled_flag internal_order_enabled_flag

, esi.so_transactions_flag so_transactions_flag

, esi.mtl_transactions_enabled_flag mtl_transactions_enabled_flag

, esi.stock_enabled_flag stock_enabled_flag

, esi.build_in_wip_flag build_in_wip_flag

, nvl(esi.returnable_flag,'N') returnable_flag

, nvl(esi.collateral_flag,'N') collateral_flag

, nvl(esi.taxable_flag,'N') taxable_flag

, nvl(esi.inspection_required_flag,'N') inspection_required_flag

, nvl(esi.receipt_required_flag,'N') receipt_required_flag

, nvl(esi.allow_substitute_receipts_flag,'N') allow_substitute_receipts_flag

, nvl(esi.allow_unordered_receipts_flag,'N') allow_unordered_receipts_flag

, nvl(esi.allow_express_delivery_flag,'N') allow_express_delivery_flag

, nvl(esi.source_type,1) source_type

, esi.source_organization_id source_organization_id

, esi.source_subinventory source_subinventory

, nvl(esi.mrp_calculate_atp_flag,'N') mrp_calculate_atp_flag

, nvl(esi.repetitive_planning_flag,'N') repetitive_planning_flag

, esi.bom_item_type bom_item_type

, esi.pick_components_flag pick_components_flag

, esi.atp_components_flag atp_components_flag

, esi.atp_flag atp_flag

, esi.wip_supply_type wip_supply_type

, esi.wip_supply_subinventory wip_supply_subinventory

, esi.primary_uom_code primary_uom_code

, nvl(esi.default_include_in_rollup_flag,'N') default_include_in_rollup_flag

, esi.inventory_planning_code inventory_planning_code

, esi.planning_make_buy_code planning_make_buy_code

, decode(esi.reservable_type,1,'Y'

, 'N') reservable_type

, esi.serviceable_product_flag serviceable_product_flag

, nvl(esi.material_billable_flag,'M') material_billable_flag

, esi.invoiceable_item_flag invoiceable_item_flag

, esi.invoice_enabled_flag invoice_enabled_flag

, esi.outside_operation_flag outside_operation_flag

, esi.costing_enabled_flag costing_enabled_flag

, esi.auto_created_config_flag auto_created_config_flag

, esi.cycle_count_enabled_flag cycle_count_enabled_flag

, esi.item_type item_type

, nvl(esi.ship_model_complete_flag,'N') ship_model_complete_flag

, esi.mrp_planning_code mrp_planning_code

, decode(esi.return_inspection_requirement,1,'Y'

, 'N') return_inspection_requirement

, esi.ato_forecast_control ato_forecast_control

, nvl(esi.container_item_flag,'N') container_item_flag

, nvl(esi.vehicle_item_flag,'N') vehicle_item_flag

, esi.container_type_code container_type_code

, esi.attribute_category item_attribute_category

, esi.attribute1 item_attribute1

, esi.attribute2 item_attribute2

, esi.attribute3 item_attribute3

, esi.attribute4 item_attribute4

, esi.attribute5 item_attribute5

, esi.attribute6 item_attribute6

, esi.attribute7 item_attribute7

, esi.attribute8 item_attribute8

, esi.attribute9 item_attribute9

, esi.attribute10 item_attribute10

, esi.attribute11 item_attribute11

, esi.attribute12 item_attribute12

, esi.attribute13 item_attribute13

, esi.attribute14 item_attribute14

, esi.attribute15 item_attribute15

, esi.attribute16 item_attribute16

, esi.attribute17 item_attribute17

, esi.attribute18 item_attribute18

, esi.attribute19 item_attribute19

, esi.attribute20 item_attribute20

, esi.attribute21 item_attribute21

, esi.attribute22 item_attribute22

, esi.attribute23 item_attribute23

, esi.attribute24 item_attribute24

, esi.attribute25 item_attribute25

, esi.attribute26 item_attribute26

, esi.attribute27 item_attribute27

, esi.attribute28 item_attribute28

, esi.attribute29 item_attribute29

, esi.attribute30 item_attribute30

, decode(esi.equipment_type,1,'Y'

, 'N') equipment_type

, nvl(esi.defect_tracking_on_flag,'N') defect_tracking_on_flag

, nvl(esi.event_flag,'N') event_flag

, nvl(esi.electronic_flag,'N') electronic_flag

, nvl(esi.downloadable_flag,'N') downloadable_flag

, nvl(esi.comms_nl_trackable_flag,'N') comms_nl_trackable_flag

, esi.asset_creation_code asset_creation_code

, nvl(esi.orderable_on_web_flag,'N') orderable_on_web_flag

, nvl(esi.back_orderable_flag,'N') back_orderable_flag

, nvl(esi.indivisible_flag,'N') indivisible_flag

, nvl(esi.lot_status_enabled,'N') lot_status_enabled

, nvl(esi.serial_status_enabled,'N') serial_status_enabled

, nvl(esi.lot_split_enabled,'N') lot_split_enabled

, nvl(esi.lot_merge_enabled,'N') lot_merge_enabled

, nvl(esi.financing_allowed_flag,'N') financing_allowed_flag

, esi.eam_item_type eam_item_type

, esi.eam_activity_type_code eam_activity_type_code

, esi.eam_activity_cause_code eam_activity_cause_code

, nvl(esi.eam_act_notification_flag,'N') eam_act_notification_flag

, esi.contract_item_type_code contract_item_type_code

, esi.serv_req_enabled_code serv_req_enabled_code

, nvl(esi.serv_billing_enabled_flag,'N') serv_billing_enabled_flag

, nvl(esi.lot_translate_enabled,'N') lot_translate_enabled

, esi.ib_item_instance_class ib_item_instance_class

, esi.config_model_type config_model_type

, nvl(esi.lot_substitution_enabled,'N') lot_substitution_enabled

, esi.eam_activity_source_code eam_activity_source_code

, decode(esi.consigned_flag,1,'Y'

, 'N') consigned_flag

, esi.vmi_forecast_type vmi_forecast_type

, decode(esi.exclude_from_budget_flag,1,'Y'

, 'N') exclude_from_budget_flag

, nvl(esi.child_lot_flag,'N') child_lot_flag

, nvl(esi.copy_lot_attribute_flag,'N') copy_lot_attribute_flag

, NVL(esi.OUTSIDE_PROCESS_SERVICE_FLAG, 'N') OUTSIDE_PROCESS_SERVICE_FLAG

, esi.sales_account item_sales_account

, esi.item_catalog_group_id item_class_id

FROM egp_system_items_vl esi