VIEW: APPS.OE_MTL_SYSTEM_ITEMS_V

Source

View Text - Preformatted

SELECT "INVENTORY_ITEM_ID" , "ORGANIZATION_ID" , "LAST_UPDATE_DATE" , "LAST_UPDATED_BY" , "CREATION_DATE" , "CREATED_BY" , "LAST_UPDATE_LOGIN" , "SUMMARY_FLAG" , "ENABLED_FLAG" , "START_DATE_ACTIVE" , "END_DATE_ACTIVE" , "DESCRIPTION" , "BUYER_ID" , "ACCOUNTING_RULE_ID" , "INVOICING_RULE_ID" , "SEGMENT1" , "SEGMENT2" , "SEGMENT3" , "SEGMENT4" , "SEGMENT5" , "SEGMENT6" , "SEGMENT7" , "SEGMENT8" , "SEGMENT9" , "SEGMENT10" , "SEGMENT11" , "SEGMENT12" , "SEGMENT13" , "SEGMENT14" , "SEGMENT15" , "SEGMENT16" , "SEGMENT17" , "SEGMENT18" , "SEGMENT19" , "SEGMENT20" , "ATTRIBUTE_CATEGORY" , "ATTRIBUTE1" , "ATTRIBUTE2" , "ATTRIBUTE3" , "ATTRIBUTE4" , "ATTRIBUTE5" , "ATTRIBUTE6" , "ATTRIBUTE7" , "ATTRIBUTE8" , "ATTRIBUTE9" , "ATTRIBUTE10" , "ATTRIBUTE11" , "ATTRIBUTE12" , "ATTRIBUTE13" , "ATTRIBUTE14" , "ATTRIBUTE15" , "PURCHASING_ITEM_FLAG" , "SHIPPABLE_ITEM_FLAG" , "CUSTOMER_ORDER_FLAG" , "INTERNAL_ORDER_FLAG" , "SERVICE_ITEM_FLAG" , "INVENTORY_ITEM_FLAG" , "ENG_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" , "BOM_ENABLED_FLAG" , "BUILD_IN_WIP_FLAG" , "REVISION_QTY_CONTROL_CODE" , "ITEM_CATALOG_GROUP_ID" , "CATALOG_STATUS_FLAG" , "RETURNABLE_FLAG" , "DEFAULT_SHIPPING_ORG" , "COLLATERAL_FLAG" , "TAXABLE_FLAG" , "QTY_RCV_EXCEPTION_CODE" , "ALLOW_ITEM_DESC_UPDATE_FLAG" , "INSPECTION_REQUIRED_FLAG" , "RECEIPT_REQUIRED_FLAG" , "MARKET_PRICE" , "HAZARD_CLASS_ID" , "RFQ_REQUIRED_FLAG" , "QTY_RCV_TOLERANCE" , "LIST_PRICE_PER_UNIT" , "UN_NUMBER_ID" , "PRICE_TOLERANCE_PERCENT" , "ASSET_CATEGORY_ID" , "ROUNDING_FACTOR" , "UNIT_OF_ISSUE" , "ENFORCE_SHIP_TO_LOCATION_CODE" , "ALLOW_SUBSTITUTE_RECEIPTS_FLAG" , "ALLOW_UNORDERED_RECEIPTS_FLAG" , "ALLOW_EXPRESS_DELIVERY_FLAG" , "DAYS_EARLY_RECEIPT_ALLOWED" , "DAYS_LATE_RECEIPT_ALLOWED" , "RECEIPT_DAYS_EXCEPTION_CODE" , "RECEIVING_ROUTING_ID" , "INVOICE_CLOSE_TOLERANCE" , "RECEIVE_CLOSE_TOLERANCE" , "AUTO_LOT_ALPHA_PREFIX" , "START_AUTO_LOT_NUMBER" , "LOT_CONTROL_CODE" , "SHELF_LIFE_CODE" , "SHELF_LIFE_DAYS" , "SERIAL_NUMBER_CONTROL_CODE" , "START_AUTO_SERIAL_NUMBER" , "AUTO_SERIAL_ALPHA_PREFIX" , "SOURCE_TYPE" , "SOURCE_ORGANIZATION_ID" , "SOURCE_SUBINVENTORY" , "EXPENSE_ACCOUNT" , "ENCUMBRANCE_ACCOUNT" , "RESTRICT_SUBINVENTORIES_CODE" , "UNIT_WEIGHT" , "WEIGHT_UOM_CODE" , "VOLUME_UOM_CODE" , "UNIT_VOLUME" , "RESTRICT_LOCATORS_CODE" , "LOCATION_CONTROL_CODE" , "SHRINKAGE_RATE" , "ACCEPTABLE_EARLY_DAYS" , "PLANNING_TIME_FENCE_CODE" , "DEMAND_TIME_FENCE_CODE" , "LEAD_TIME_LOT_SIZE" , "STD_LOT_SIZE" , "CUM_MANUFACTURING_LEAD_TIME" , "OVERRUN_PERCENTAGE" , "MRP_CALCULATE_ATP_FLAG" , "ACCEPTABLE_RATE_INCREASE" , "ACCEPTABLE_RATE_DECREASE" , "CUMULATIVE_TOTAL_LEAD_TIME" , "PLANNING_TIME_FENCE_DAYS" , "DEMAND_TIME_FENCE_DAYS" , "END_ASSEMBLY_PEGGING_FLAG" , "REPETITIVE_PLANNING_FLAG" , "PLANNING_EXCEPTION_SET" , "BOM_ITEM_TYPE" , "PICK_COMPONENTS_FLAG" , "REPLENISH_TO_ORDER_FLAG" , "BASE_ITEM_ID" , "ATP_COMPONENTS_FLAG" , "ATP_FLAG" , "FIXED_LEAD_TIME" , "VARIABLE_LEAD_TIME" , "WIP_SUPPLY_LOCATOR_ID" , "WIP_SUPPLY_TYPE" , "WIP_SUPPLY_SUBINVENTORY" , "PRIMARY_UOM_CODE" , "PRIMARY_UNIT_OF_MEASURE" , "ALLOWED_UNITS_LOOKUP_CODE" , "COST_OF_SALES_ACCOUNT" , "SALES_ACCOUNT" , "DEFAULT_INCLUDE_IN_ROLLUP_FLAG" , "INVENTORY_ITEM_STATUS_CODE" , "INVENTORY_PLANNING_CODE" , "PLANNER_CODE" , "PLANNING_MAKE_BUY_CODE" , "FIXED_LOT_MULTIPLIER" , "ROUNDING_CONTROL_TYPE" , "CARRYING_COST" , "POSTPROCESSING_LEAD_TIME" , "PREPROCESSING_LEAD_TIME" , "FULL_LEAD_TIME" , "ORDER_COST" , "MRP_SAFETY_STOCK_PERCENT" , "MRP_SAFETY_STOCK_CODE" , "MIN_MINMAX_QUANTITY" , "MAX_MINMAX_QUANTITY" , "MINIMUM_ORDER_QUANTITY" , "FIXED_ORDER_QUANTITY" , "FIXED_DAYS_SUPPLY" , "MAXIMUM_ORDER_QUANTITY" , "ATP_RULE_ID" , "PICKING_RULE_ID" , "RESERVABLE_TYPE" , "POSITIVE_MEASUREMENT_ERROR" , "NEGATIVE_MEASUREMENT_ERROR" , "ENGINEERING_ECN_CODE" , "ENGINEERING_ITEM_ID" , "ENGINEERING_DATE" , "SERVICE_STARTING_DELAY" , "VENDOR_WARRANTY_FLAG" , "SERVICEABLE_COMPONENT_FLAG" , "SERVICEABLE_PRODUCT_FLAG" , "BASE_WARRANTY_SERVICE_ID" , "PAYMENT_TERMS_ID" , "PREVENTIVE_MAINTENANCE_FLAG" , "PRIMARY_SPECIALIST_ID" , "SECONDARY_SPECIALIST_ID" , "SERVICEABLE_ITEM_CLASS_ID" , "TIME_BILLABLE_FLAG" , "MATERIAL_BILLABLE_FLAG" , "EXPENSE_BILLABLE_FLAG" , "PRORATE_SERVICE_FLAG" , "COVERAGE_SCHEDULE_ID" , "SERVICE_DURATION_PERIOD_CODE" , "SERVICE_DURATION" , "WARRANTY_VENDOR_ID" , "MAX_WARRANTY_AMOUNT" , "RESPONSE_TIME_PERIOD_CODE" , "RESPONSE_TIME_VALUE" , "NEW_REVISION_CODE" , "INVOICEABLE_ITEM_FLAG" , "TAX_CODE" , "INVOICE_ENABLED_FLAG" , "MUST_USE_APPROVED_VENDOR_FLAG" , "REQUEST_ID" , "PROGRAM_APPLICATION_ID" , "PROGRAM_ID" , "PROGRAM_UPDATE_DATE" , "OUTSIDE_OPERATION_FLAG" , "OUTSIDE_OPERATION_UOM_TYPE" , "SAFETY_STOCK_BUCKET_DAYS" , "AUTO_REDUCE_MPS" , "COSTING_ENABLED_FLAG" , "AUTO_CREATED_CONFIG_FLAG" , "CYCLE_COUNT_ENABLED_FLAG" , "ITEM_TYPE" , "MODEL_CONFIG_CLAUSE_NAME" , "SHIP_MODEL_COMPLETE_FLAG" , "MRP_PLANNING_CODE" , "RETURN_INSPECTION_REQUIREMENT" , "ATO_FORECAST_CONTROL" , "RELEASE_TIME_FENCE_CODE" , "RELEASE_TIME_FENCE_DAYS" , "CONTAINER_ITEM_FLAG" , "VEHICLE_ITEM_FLAG" , "MAXIMUM_LOAD_WEIGHT" , "MINIMUM_FILL_PERCENT" , "CONTAINER_TYPE_CODE" , "INTERNAL_VOLUME" , "WH_UPDATE_DATE" , "PRODUCT_FAMILY_ITEM_ID" , "GLOBAL_ATTRIBUTE_CATEGORY" , "GLOBAL_ATTRIBUTE1" , "GLOBAL_ATTRIBUTE2" , "GLOBAL_ATTRIBUTE3" , "GLOBAL_ATTRIBUTE4" , "GLOBAL_ATTRIBUTE5" , "GLOBAL_ATTRIBUTE6" , "GLOBAL_ATTRIBUTE7" , "GLOBAL_ATTRIBUTE8" , "GLOBAL_ATTRIBUTE9" , "GLOBAL_ATTRIBUTE10" , "PURCHASING_TAX_CODE" FROM MTL_SYSTEM_ITEMS

View Text - HTML Formatted

SELECT "INVENTORY_ITEM_ID"
, "ORGANIZATION_ID"
, "LAST_UPDATE_DATE"
, "LAST_UPDATED_BY"
, "CREATION_DATE"
, "CREATED_BY"
, "LAST_UPDATE_LOGIN"
, "SUMMARY_FLAG"
, "ENABLED_FLAG"
, "START_DATE_ACTIVE"
, "END_DATE_ACTIVE"
, "DESCRIPTION"
, "BUYER_ID"
, "ACCOUNTING_RULE_ID"
, "INVOICING_RULE_ID"
, "SEGMENT1"
, "SEGMENT2"
, "SEGMENT3"
, "SEGMENT4"
, "SEGMENT5"
, "SEGMENT6"
, "SEGMENT7"
, "SEGMENT8"
, "SEGMENT9"
, "SEGMENT10"
, "SEGMENT11"
, "SEGMENT12"
, "SEGMENT13"
, "SEGMENT14"
, "SEGMENT15"
, "SEGMENT16"
, "SEGMENT17"
, "SEGMENT18"
, "SEGMENT19"
, "SEGMENT20"
, "ATTRIBUTE_CATEGORY"
, "ATTRIBUTE1"
, "ATTRIBUTE2"
, "ATTRIBUTE3"
, "ATTRIBUTE4"
, "ATTRIBUTE5"
, "ATTRIBUTE6"
, "ATTRIBUTE7"
, "ATTRIBUTE8"
, "ATTRIBUTE9"
, "ATTRIBUTE10"
, "ATTRIBUTE11"
, "ATTRIBUTE12"
, "ATTRIBUTE13"
, "ATTRIBUTE14"
, "ATTRIBUTE15"
, "PURCHASING_ITEM_FLAG"
, "SHIPPABLE_ITEM_FLAG"
, "CUSTOMER_ORDER_FLAG"
, "INTERNAL_ORDER_FLAG"
, "SERVICE_ITEM_FLAG"
, "INVENTORY_ITEM_FLAG"
, "ENG_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"
, "BOM_ENABLED_FLAG"
, "BUILD_IN_WIP_FLAG"
, "REVISION_QTY_CONTROL_CODE"
, "ITEM_CATALOG_GROUP_ID"
, "CATALOG_STATUS_FLAG"
, "RETURNABLE_FLAG"
, "DEFAULT_SHIPPING_ORG"
, "COLLATERAL_FLAG"
, "TAXABLE_FLAG"
, "QTY_RCV_EXCEPTION_CODE"
, "ALLOW_ITEM_DESC_UPDATE_FLAG"
, "INSPECTION_REQUIRED_FLAG"
, "RECEIPT_REQUIRED_FLAG"
, "MARKET_PRICE"
, "HAZARD_CLASS_ID"
, "RFQ_REQUIRED_FLAG"
, "QTY_RCV_TOLERANCE"
, "LIST_PRICE_PER_UNIT"
, "UN_NUMBER_ID"
, "PRICE_TOLERANCE_PERCENT"
, "ASSET_CATEGORY_ID"
, "ROUNDING_FACTOR"
, "UNIT_OF_ISSUE"
, "ENFORCE_SHIP_TO_LOCATION_CODE"
, "ALLOW_SUBSTITUTE_RECEIPTS_FLAG"
, "ALLOW_UNORDERED_RECEIPTS_FLAG"
, "ALLOW_EXPRESS_DELIVERY_FLAG"
, "DAYS_EARLY_RECEIPT_ALLOWED"
, "DAYS_LATE_RECEIPT_ALLOWED"
, "RECEIPT_DAYS_EXCEPTION_CODE"
, "RECEIVING_ROUTING_ID"
, "INVOICE_CLOSE_TOLERANCE"
, "RECEIVE_CLOSE_TOLERANCE"
, "AUTO_LOT_ALPHA_PREFIX"
, "START_AUTO_LOT_NUMBER"
, "LOT_CONTROL_CODE"
, "SHELF_LIFE_CODE"
, "SHELF_LIFE_DAYS"
, "SERIAL_NUMBER_CONTROL_CODE"
, "START_AUTO_SERIAL_NUMBER"
, "AUTO_SERIAL_ALPHA_PREFIX"
, "SOURCE_TYPE"
, "SOURCE_ORGANIZATION_ID"
, "SOURCE_SUBINVENTORY"
, "EXPENSE_ACCOUNT"
, "ENCUMBRANCE_ACCOUNT"
, "RESTRICT_SUBINVENTORIES_CODE"
, "UNIT_WEIGHT"
, "WEIGHT_UOM_CODE"
, "VOLUME_UOM_CODE"
, "UNIT_VOLUME"
, "RESTRICT_LOCATORS_CODE"
, "LOCATION_CONTROL_CODE"
, "SHRINKAGE_RATE"
, "ACCEPTABLE_EARLY_DAYS"
, "PLANNING_TIME_FENCE_CODE"
, "DEMAND_TIME_FENCE_CODE"
, "LEAD_TIME_LOT_SIZE"
, "STD_LOT_SIZE"
, "CUM_MANUFACTURING_LEAD_TIME"
, "OVERRUN_PERCENTAGE"
, "MRP_CALCULATE_ATP_FLAG"
, "ACCEPTABLE_RATE_INCREASE"
, "ACCEPTABLE_RATE_DECREASE"
, "CUMULATIVE_TOTAL_LEAD_TIME"
, "PLANNING_TIME_FENCE_DAYS"
, "DEMAND_TIME_FENCE_DAYS"
, "END_ASSEMBLY_PEGGING_FLAG"
, "REPETITIVE_PLANNING_FLAG"
, "PLANNING_EXCEPTION_SET"
, "BOM_ITEM_TYPE"
, "PICK_COMPONENTS_FLAG"
, "REPLENISH_TO_ORDER_FLAG"
, "BASE_ITEM_ID"
, "ATP_COMPONENTS_FLAG"
, "ATP_FLAG"
, "FIXED_LEAD_TIME"
, "VARIABLE_LEAD_TIME"
, "WIP_SUPPLY_LOCATOR_ID"
, "WIP_SUPPLY_TYPE"
, "WIP_SUPPLY_SUBINVENTORY"
, "PRIMARY_UOM_CODE"
, "PRIMARY_UNIT_OF_MEASURE"
, "ALLOWED_UNITS_LOOKUP_CODE"
, "COST_OF_SALES_ACCOUNT"
, "SALES_ACCOUNT"
, "DEFAULT_INCLUDE_IN_ROLLUP_FLAG"
, "INVENTORY_ITEM_STATUS_CODE"
, "INVENTORY_PLANNING_CODE"
, "PLANNER_CODE"
, "PLANNING_MAKE_BUY_CODE"
, "FIXED_LOT_MULTIPLIER"
, "ROUNDING_CONTROL_TYPE"
, "CARRYING_COST"
, "POSTPROCESSING_LEAD_TIME"
, "PREPROCESSING_LEAD_TIME"
, "FULL_LEAD_TIME"
, "ORDER_COST"
, "MRP_SAFETY_STOCK_PERCENT"
, "MRP_SAFETY_STOCK_CODE"
, "MIN_MINMAX_QUANTITY"
, "MAX_MINMAX_QUANTITY"
, "MINIMUM_ORDER_QUANTITY"
, "FIXED_ORDER_QUANTITY"
, "FIXED_DAYS_SUPPLY"
, "MAXIMUM_ORDER_QUANTITY"
, "ATP_RULE_ID"
, "PICKING_RULE_ID"
, "RESERVABLE_TYPE"
, "POSITIVE_MEASUREMENT_ERROR"
, "NEGATIVE_MEASUREMENT_ERROR"
, "ENGINEERING_ECN_CODE"
, "ENGINEERING_ITEM_ID"
, "ENGINEERING_DATE"
, "SERVICE_STARTING_DELAY"
, "VENDOR_WARRANTY_FLAG"
, "SERVICEABLE_COMPONENT_FLAG"
, "SERVICEABLE_PRODUCT_FLAG"
, "BASE_WARRANTY_SERVICE_ID"
, "PAYMENT_TERMS_ID"
, "PREVENTIVE_MAINTENANCE_FLAG"
, "PRIMARY_SPECIALIST_ID"
, "SECONDARY_SPECIALIST_ID"
, "SERVICEABLE_ITEM_CLASS_ID"
, "TIME_BILLABLE_FLAG"
, "MATERIAL_BILLABLE_FLAG"
, "EXPENSE_BILLABLE_FLAG"
, "PRORATE_SERVICE_FLAG"
, "COVERAGE_SCHEDULE_ID"
, "SERVICE_DURATION_PERIOD_CODE"
, "SERVICE_DURATION"
, "WARRANTY_VENDOR_ID"
, "MAX_WARRANTY_AMOUNT"
, "RESPONSE_TIME_PERIOD_CODE"
, "RESPONSE_TIME_VALUE"
, "NEW_REVISION_CODE"
, "INVOICEABLE_ITEM_FLAG"
, "TAX_CODE"
, "INVOICE_ENABLED_FLAG"
, "MUST_USE_APPROVED_VENDOR_FLAG"
, "REQUEST_ID"
, "PROGRAM_APPLICATION_ID"
, "PROGRAM_ID"
, "PROGRAM_UPDATE_DATE"
, "OUTSIDE_OPERATION_FLAG"
, "OUTSIDE_OPERATION_UOM_TYPE"
, "SAFETY_STOCK_BUCKET_DAYS"
, "AUTO_REDUCE_MPS"
, "COSTING_ENABLED_FLAG"
, "AUTO_CREATED_CONFIG_FLAG"
, "CYCLE_COUNT_ENABLED_FLAG"
, "ITEM_TYPE"
, "MODEL_CONFIG_CLAUSE_NAME"
, "SHIP_MODEL_COMPLETE_FLAG"
, "MRP_PLANNING_CODE"
, "RETURN_INSPECTION_REQUIREMENT"
, "ATO_FORECAST_CONTROL"
, "RELEASE_TIME_FENCE_CODE"
, "RELEASE_TIME_FENCE_DAYS"
, "CONTAINER_ITEM_FLAG"
, "VEHICLE_ITEM_FLAG"
, "MAXIMUM_LOAD_WEIGHT"
, "MINIMUM_FILL_PERCENT"
, "CONTAINER_TYPE_CODE"
, "INTERNAL_VOLUME"
, "WH_UPDATE_DATE"
, "PRODUCT_FAMILY_ITEM_ID"
, "GLOBAL_ATTRIBUTE_CATEGORY"
, "GLOBAL_ATTRIBUTE1"
, "GLOBAL_ATTRIBUTE2"
, "GLOBAL_ATTRIBUTE3"
, "GLOBAL_ATTRIBUTE4"
, "GLOBAL_ATTRIBUTE5"
, "GLOBAL_ATTRIBUTE6"
, "GLOBAL_ATTRIBUTE7"
, "GLOBAL_ATTRIBUTE8"
, "GLOBAL_ATTRIBUTE9"
, "GLOBAL_ATTRIBUTE10"
, "PURCHASING_TAX_CODE"
FROM MTL_SYSTEM_ITEMS