VIEW: APPS.GMF_XLA_ITEMS_V

Source

View Text - Preformatted

SELECT msi.inventory_item_id inventory_item_id, msi.organization_id organization_id, null item_concatenated_segments, 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, msi.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_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 FROM mtl_system_items_b msi, mtl_parameters mp WHERE msi.organization_id = mp.organization_id AND mp.process_enabled_flag = 'Y'

View Text - HTML Formatted

SELECT MSI.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MSI.ORGANIZATION_ID ORGANIZATION_ID
, NULL ITEM_CONCATENATED_SEGMENTS
, 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
, MSI.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_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
FROM MTL_SYSTEM_ITEMS_B MSI
, MTL_PARAMETERS MP
WHERE MSI.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MP.PROCESS_ENABLED_FLAG = 'Y'