Product: | ONT - Order Management |
---|---|
Description: | No longer used |
Implementation/DBA Data: | APPS.OE_MTL_SYSTEM_ITEMS_V |
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