[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MTL_SYSTEM_ITEMS_VL |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  INV.MTL_SYSTEM_ITEMS_VL
|
| Subobject Name: | |
| Status: | VALID |
MultiLingual view (a language resolved view of the data.)
System Items multilingual view with concatenated segments column.
For column description, please refer to mtl_system_items_b columns descriptions.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| INVENTORY_ITEM_ID | NUMBER | Yes | ||
| ORGANIZATION_ID | NUMBER | Yes | ||
| PRIMARY_UOM_CODE | VARCHAR2 | (3) | ||
| PRIMARY_UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
| ITEM_TYPE | VARCHAR2 | (30) | ||
| INVENTORY_ITEM_STATUS_CODE | VARCHAR2 | (10) | Yes | |
| ALLOWED_UNITS_LOOKUP_CODE | NUMBER | |||
| ITEM_CATALOG_GROUP_ID | NUMBER | |||
| CATALOG_STATUS_FLAG | VARCHAR2 | (1) | ||
| INVENTORY_ITEM_FLAG | VARCHAR2 | (1) | Yes | |
| STOCK_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| MTL_TRANSACTIONS_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| CHECK_SHORTAGES_FLAG | VARCHAR2 | (1) | ||
| REVISION_QTY_CONTROL_CODE | NUMBER | |||
| RESERVABLE_TYPE | NUMBER | |||
| SHELF_LIFE_CODE | NUMBER | |||
| SHELF_LIFE_DAYS | NUMBER | |||
| CYCLE_COUNT_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| NEGATIVE_MEASUREMENT_ERROR | NUMBER | |||
| POSITIVE_MEASUREMENT_ERROR | NUMBER | |||
| LOT_CONTROL_CODE | NUMBER | |||
| AUTO_LOT_ALPHA_PREFIX | VARCHAR2 | (30) | ||
| START_AUTO_LOT_NUMBER | VARCHAR2 | (30) | ||
| SERIAL_NUMBER_CONTROL_CODE | NUMBER | |||
| AUTO_SERIAL_ALPHA_PREFIX | VARCHAR2 | (30) | ||
| START_AUTO_SERIAL_NUMBER | VARCHAR2 | (30) | ||
| LOCATION_CONTROL_CODE | NUMBER | |||
| RESTRICT_SUBINVENTORIES_CODE | NUMBER | |||
| RESTRICT_LOCATORS_CODE | NUMBER | |||
| BOM_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| BOM_ITEM_TYPE | NUMBER | Yes | ||
| BASE_ITEM_ID | NUMBER | |||
| EFFECTIVITY_CONTROL | NUMBER | |||
| ENG_ITEM_FLAG | VARCHAR2 | (1) | Yes | |
| ENGINEERING_ECN_CODE | VARCHAR2 | (50) | ||
| ENGINEERING_ITEM_ID | NUMBER | |||
| ENGINEERING_DATE | DATE | |||
| PRODUCT_FAMILY_ITEM_ID | NUMBER | |||
| AUTO_CREATED_CONFIG_FLAG | VARCHAR2 | (1) | Yes | |
| MODEL_CONFIG_CLAUSE_NAME | VARCHAR2 | (10) | ||
| NEW_REVISION_CODE | VARCHAR2 | (30) | ||
| COSTING_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| INVENTORY_ASSET_FLAG | VARCHAR2 | (1) | Yes | |
| DEFAULT_INCLUDE_IN_ROLLUP_FLAG | VARCHAR2 | (1) | ||
| COST_OF_SALES_ACCOUNT | NUMBER | |||
| STD_LOT_SIZE | NUMBER | |||
| PURCHASING_ITEM_FLAG | VARCHAR2 | (1) | Yes | |
| PURCHASING_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| MUST_USE_APPROVED_VENDOR_FLAG | VARCHAR2 | (1) | Yes | |
| ALLOW_ITEM_DESC_UPDATE_FLAG | VARCHAR2 | (1) | ||
| RFQ_REQUIRED_FLAG | VARCHAR2 | (1) | ||
| OUTSIDE_OPERATION_FLAG | VARCHAR2 | (1) | Yes | |
| OUTSIDE_OPERATION_UOM_TYPE | VARCHAR2 | (25) | ||
| TAXABLE_FLAG | VARCHAR2 | (1) | ||
| PURCHASING_TAX_CODE | VARCHAR2 | (50) | ||
| RECEIPT_REQUIRED_FLAG | VARCHAR2 | (1) | ||
| INSPECTION_REQUIRED_FLAG | VARCHAR2 | (1) | ||
| BUYER_ID | NUMBER | (9) | ||
| UNIT_OF_ISSUE | VARCHAR2 | (25) | ||
| RECEIVE_CLOSE_TOLERANCE | NUMBER | |||
| INVOICE_CLOSE_TOLERANCE | NUMBER | |||
| UN_NUMBER_ID | NUMBER | |||
| HAZARD_CLASS_ID | NUMBER | |||
| LIST_PRICE_PER_UNIT | NUMBER | |||
| MARKET_PRICE | NUMBER | |||
| PRICE_TOLERANCE_PERCENT | NUMBER | |||
| ROUNDING_FACTOR | NUMBER | |||
| ENCUMBRANCE_ACCOUNT | NUMBER | |||
| EXPENSE_ACCOUNT | NUMBER | |||
| ASSET_CATEGORY_ID | NUMBER | |||
| RECEIPT_DAYS_EXCEPTION_CODE | VARCHAR2 | (25) | ||
| DAYS_EARLY_RECEIPT_ALLOWED | NUMBER | |||
| DAYS_LATE_RECEIPT_ALLOWED | NUMBER | |||
| ALLOW_SUBSTITUTE_RECEIPTS_FLAG | VARCHAR2 | (1) | ||
| ALLOW_UNORDERED_RECEIPTS_FLAG | VARCHAR2 | (1) | ||
| ALLOW_EXPRESS_DELIVERY_FLAG | VARCHAR2 | (1) | ||
| QTY_RCV_EXCEPTION_CODE | VARCHAR2 | (25) | ||
| QTY_RCV_TOLERANCE | NUMBER | |||
| RECEIVING_ROUTING_ID | NUMBER | |||
| ENFORCE_SHIP_TO_LOCATION_CODE | VARCHAR2 | (25) | ||
| WEIGHT_UOM_CODE | VARCHAR2 | (3) | ||
| UNIT_WEIGHT | NUMBER | |||
| VOLUME_UOM_CODE | VARCHAR2 | (3) | ||
| UNIT_VOLUME | NUMBER | |||
| CONTAINER_ITEM_FLAG | VARCHAR2 | (1) | ||
| VEHICLE_ITEM_FLAG | VARCHAR2 | (1) | ||
| CONTAINER_TYPE_CODE | VARCHAR2 | (30) | ||
| INTERNAL_VOLUME | NUMBER | |||
| MAXIMUM_LOAD_WEIGHT | NUMBER | |||
| MINIMUM_FILL_PERCENT | NUMBER | |||
| INVENTORY_PLANNING_CODE | NUMBER | |||
| PLANNER_CODE | VARCHAR2 | (10) | ||
| PLANNING_MAKE_BUY_CODE | NUMBER | |||
| MIN_MINMAX_QUANTITY | NUMBER | |||
| MAX_MINMAX_QUANTITY | NUMBER | |||
| MINIMUM_ORDER_QUANTITY | NUMBER | |||
| MAXIMUM_ORDER_QUANTITY | NUMBER | |||
| ORDER_COST | NUMBER | |||
| CARRYING_COST | NUMBER | |||
| SOURCE_TYPE | NUMBER | |||
| SOURCE_ORGANIZATION_ID | NUMBER | |||
| SOURCE_SUBINVENTORY | VARCHAR2 | (10) | ||
| MRP_SAFETY_STOCK_CODE | NUMBER | |||
| SAFETY_STOCK_BUCKET_DAYS | NUMBER | |||
| MRP_SAFETY_STOCK_PERCENT | NUMBER | |||
| FIXED_ORDER_QUANTITY | NUMBER | |||
| FIXED_DAYS_SUPPLY | NUMBER | |||
| FIXED_LOT_MULTIPLIER | NUMBER | |||
| MRP_PLANNING_CODE | NUMBER | |||
| ATO_FORECAST_CONTROL | NUMBER | |||
| PLANNING_EXCEPTION_SET | VARCHAR2 | (10) | ||
| END_ASSEMBLY_PEGGING_FLAG | VARCHAR2 | (1) | ||
| SHRINKAGE_RATE | NUMBER | |||
| ROUNDING_CONTROL_TYPE | NUMBER | |||
| ACCEPTABLE_EARLY_DAYS | NUMBER | |||
| REPETITIVE_PLANNING_FLAG | VARCHAR2 | (1) | ||
| OVERRUN_PERCENTAGE | NUMBER | |||
| ACCEPTABLE_RATE_INCREASE | NUMBER | |||
| ACCEPTABLE_RATE_DECREASE | NUMBER | |||
| MRP_CALCULATE_ATP_FLAG | VARCHAR2 | (1) | ||
| AUTO_REDUCE_MPS | NUMBER | (22) | ||
| PLANNING_TIME_FENCE_CODE | NUMBER | |||
| PLANNING_TIME_FENCE_DAYS | NUMBER | |||
| DEMAND_TIME_FENCE_CODE | NUMBER | |||
| DEMAND_TIME_FENCE_DAYS | NUMBER | |||
| RELEASE_TIME_FENCE_CODE | NUMBER | |||
| RELEASE_TIME_FENCE_DAYS | NUMBER | |||
| PREPROCESSING_LEAD_TIME | NUMBER | |||
| FULL_LEAD_TIME | NUMBER | |||
| POSTPROCESSING_LEAD_TIME | NUMBER | |||
| FIXED_LEAD_TIME | NUMBER | |||
| VARIABLE_LEAD_TIME | NUMBER | |||
| CUM_MANUFACTURING_LEAD_TIME | NUMBER | |||
| CUMULATIVE_TOTAL_LEAD_TIME | NUMBER | |||
| LEAD_TIME_LOT_SIZE | NUMBER | |||
| BUILD_IN_WIP_FLAG | VARCHAR2 | (1) | Yes | |
| WIP_SUPPLY_TYPE | NUMBER | |||
| WIP_SUPPLY_SUBINVENTORY | VARCHAR2 | (10) | ||
| WIP_SUPPLY_LOCATOR_ID | NUMBER | |||
| OVERCOMPLETION_TOLERANCE_TYPE | NUMBER | |||
| OVERCOMPLETION_TOLERANCE_VALUE | NUMBER | |||
| CUSTOMER_ORDER_FLAG | VARCHAR2 | (1) | Yes | |
| CUSTOMER_ORDER_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| SHIPPABLE_ITEM_FLAG | VARCHAR2 | (1) | Yes | |
| INTERNAL_ORDER_FLAG | VARCHAR2 | (1) | Yes | |
| INTERNAL_ORDER_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| SO_TRANSACTIONS_FLAG | VARCHAR2 | (1) | Yes | |
| PICK_COMPONENTS_FLAG | VARCHAR2 | (1) | Yes | |
| ATP_FLAG | VARCHAR2 | (1) | Yes | |
| REPLENISH_TO_ORDER_FLAG | VARCHAR2 | (1) | Yes | |
| ATP_RULE_ID | NUMBER | |||
| ATP_COMPONENTS_FLAG | VARCHAR2 | (1) | Yes | |
| SHIP_MODEL_COMPLETE_FLAG | VARCHAR2 | (1) | ||
| PICKING_RULE_ID | NUMBER | |||
| COLLATERAL_FLAG | VARCHAR2 | (1) | ||
| DEFAULT_SHIPPING_ORG | NUMBER | |||
| RETURNABLE_FLAG | VARCHAR2 | (1) | ||
| RETURN_INSPECTION_REQUIREMENT | NUMBER | |||
| OVER_SHIPMENT_TOLERANCE | NUMBER | |||
| UNDER_SHIPMENT_TOLERANCE | NUMBER | |||
| OVER_RETURN_TOLERANCE | NUMBER | |||
| UNDER_RETURN_TOLERANCE | NUMBER | |||
| INVOICEABLE_ITEM_FLAG | VARCHAR2 | (1) | Yes | |
| INVOICE_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| ACCOUNTING_RULE_ID | NUMBER | |||
| INVOICING_RULE_ID | NUMBER | |||
| TAX_CODE | VARCHAR2 | (50) | ||
| SALES_ACCOUNT | NUMBER | |||
| PAYMENT_TERMS_ID | NUMBER | |||
| SERVICE_ITEM_FLAG | VARCHAR2 | (1) | Yes | |
| VENDOR_WARRANTY_FLAG | VARCHAR2 | (1) | Yes | |
| COVERAGE_SCHEDULE_ID | NUMBER | |||
| SERVICE_DURATION | NUMBER | |||
| SERVICE_DURATION_PERIOD_CODE | VARCHAR2 | (10) | ||
| SERVICEABLE_PRODUCT_FLAG | VARCHAR2 | (1) | Yes | |
| SERVICE_STARTING_DELAY | NUMBER | |||
| MATERIAL_BILLABLE_FLAG | VARCHAR2 | (30) | ||
| TIME_BILLABLE_FLAG | VARCHAR2 | (1) | ||
| EXPENSE_BILLABLE_FLAG | VARCHAR2 | (1) | ||
| SERVICEABLE_COMPONENT_FLAG | VARCHAR2 | (1) | ||
| PREVENTIVE_MAINTENANCE_FLAG | VARCHAR2 | (1) | ||
| PRORATE_SERVICE_FLAG | VARCHAR2 | (1) | ||
| SERVICEABLE_ITEM_CLASS_ID | NUMBER | |||
| BASE_WARRANTY_SERVICE_ID | NUMBER | |||
| WARRANTY_VENDOR_ID | NUMBER | |||
| MAX_WARRANTY_AMOUNT | NUMBER | |||
| RESPONSE_TIME_PERIOD_CODE | VARCHAR2 | (30) | ||
| RESPONSE_TIME_VALUE | NUMBER | |||
| PRIMARY_SPECIALIST_ID | NUMBER | |||
| SECONDARY_SPECIALIST_ID | NUMBER | |||
| WH_UPDATE_DATE | DATE | |||
| SEGMENT1 | VARCHAR2 | (40) | ||
| SEGMENT2 | VARCHAR2 | (40) | ||
| SEGMENT3 | VARCHAR2 | (40) | ||
| SEGMENT4 | VARCHAR2 | (40) | ||
| SEGMENT5 | VARCHAR2 | (40) | ||
| SEGMENT6 | VARCHAR2 | (40) | ||
| SEGMENT7 | VARCHAR2 | (40) | ||
| SEGMENT8 | VARCHAR2 | (40) | ||
| SEGMENT9 | VARCHAR2 | (40) | ||
| SEGMENT10 | VARCHAR2 | (40) | ||
| SEGMENT11 | VARCHAR2 | (40) | ||
| SEGMENT12 | VARCHAR2 | (40) | ||
| SEGMENT13 | VARCHAR2 | (40) | ||
| SEGMENT14 | VARCHAR2 | (40) | ||
| SEGMENT15 | VARCHAR2 | (40) | ||
| SEGMENT16 | VARCHAR2 | (40) | ||
| SEGMENT17 | VARCHAR2 | (40) | ||
| SEGMENT18 | VARCHAR2 | (40) | ||
| SEGMENT19 | VARCHAR2 | (40) | ||
| SEGMENT20 | VARCHAR2 | (40) | ||
| SUMMARY_FLAG | VARCHAR2 | (1) | Yes | |
| ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| START_DATE_ACTIVE | DATE | |||
| END_DATE_ACTIVE | DATE | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (240) | ||
| ATTRIBUTE3 | VARCHAR2 | (240) | ||
| ATTRIBUTE4 | VARCHAR2 | (240) | ||
| ATTRIBUTE5 | VARCHAR2 | (240) | ||
| ATTRIBUTE6 | VARCHAR2 | (240) | ||
| ATTRIBUTE7 | VARCHAR2 | (240) | ||
| ATTRIBUTE8 | VARCHAR2 | (240) | ||
| ATTRIBUTE9 | VARCHAR2 | (240) | ||
| ATTRIBUTE10 | VARCHAR2 | (240) | ||
| ATTRIBUTE11 | VARCHAR2 | (240) | ||
| ATTRIBUTE12 | VARCHAR2 | (240) | ||
| ATTRIBUTE13 | VARCHAR2 | (240) | ||
| ATTRIBUTE14 | VARCHAR2 | (240) | ||
| ATTRIBUTE15 | VARCHAR2 | (240) | ||
| ATTRIBUTE16 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE17 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE18 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE19 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE20 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE21 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE22 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE23 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE24 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE25 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE26 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE27 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE28 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE29 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE30 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| EQUIPMENT_TYPE | NUMBER | |||
| RECOVERED_PART_DISP_CODE | VARCHAR2 | (30) | ||
| DEFECT_TRACKING_ON_FLAG | VARCHAR2 | (1) | ||
| USAGE_ITEM_FLAG | VARCHAR2 | (1) | ||
| EVENT_FLAG | VARCHAR2 | (1) | ||
| ELECTRONIC_FLAG | VARCHAR2 | (1) | ||
| DOWNLOADABLE_FLAG | VARCHAR2 | (1) | ||
| VOL_DISCOUNT_EXEMPT_FLAG | VARCHAR2 | (1) | ||
| COUPON_EXEMPT_FLAG | VARCHAR2 | (1) | ||
| COMMS_NL_TRACKABLE_FLAG | VARCHAR2 | (1) | ||
| ASSET_CREATION_CODE | VARCHAR2 | (30) | ||
| COMMS_ACTIVATION_REQD_FLAG | VARCHAR2 | (1) | ||
| ORDERABLE_ON_WEB_FLAG | VARCHAR2 | (1) | ||
| BACK_ORDERABLE_FLAG | VARCHAR2 | (1) | ||
| WEB_STATUS | VARCHAR2 | (30) | ||
| INDIVISIBLE_FLAG | VARCHAR2 | (1) | ||
| DIMENSION_UOM_CODE | VARCHAR2 | (3) | ||
| UNIT_LENGTH | NUMBER | |||
| UNIT_WIDTH | NUMBER | |||
| UNIT_HEIGHT | NUMBER | |||
| BULK_PICKED_FLAG | VARCHAR2 | (1) | ||
| LOT_STATUS_ENABLED | VARCHAR2 | (1) | ||
| DEFAULT_LOT_STATUS_ID | NUMBER | |||
| SERIAL_STATUS_ENABLED | VARCHAR2 | (1) | ||
| DEFAULT_SERIAL_STATUS_ID | NUMBER | |||
| LOT_SPLIT_ENABLED | VARCHAR2 | (1) | ||
| LOT_MERGE_ENABLED | VARCHAR2 | (1) | ||
| INVENTORY_CARRY_PENALTY | NUMBER | |||
| OPERATION_SLACK_PENALTY | NUMBER | |||
| FINANCING_ALLOWED_FLAG | VARCHAR2 | (1) | ||
| EAM_ITEM_TYPE | NUMBER | |||
| EAM_ACTIVITY_TYPE_CODE | VARCHAR2 | (30) | ||
| EAM_ACTIVITY_CAUSE_CODE | VARCHAR2 | (30) | ||
| EAM_ACT_NOTIFICATION_FLAG | VARCHAR2 | (1) | ||
| EAM_ACT_SHUTDOWN_STATUS | VARCHAR2 | (30) | ||
| DUAL_UOM_CONTROL | NUMBER | |||
| SECONDARY_UOM_CODE | VARCHAR2 | (3) | ||
| DUAL_UOM_DEVIATION_HIGH | NUMBER | |||
| DUAL_UOM_DEVIATION_LOW | NUMBER | |||
| CONTRACT_ITEM_TYPE_CODE | VARCHAR2 | (30) | ||
| SUBSCRIPTION_DEPEND_FLAG | VARCHAR2 | (1) | ||
| SERV_REQ_ENABLED_CODE | VARCHAR2 | (30) | ||
| SERV_BILLING_ENABLED_FLAG | VARCHAR2 | (1) | ||
| SERV_IMPORTANCE_LEVEL | NUMBER | |||
| PLANNED_INV_POINT_FLAG | VARCHAR2 | (1) | ||
| LOT_TRANSLATE_ENABLED | VARCHAR2 | (1) | ||
| DEFAULT_SO_SOURCE_TYPE | VARCHAR2 | (30) | ||
| CREATE_SUPPLY_FLAG | VARCHAR2 | (1) | ||
| SUBSTITUTION_WINDOW_CODE | NUMBER | |||
| SUBSTITUTION_WINDOW_DAYS | NUMBER | |||
| IB_ITEM_INSTANCE_CLASS | VARCHAR2 | (30) | ||
| CONFIG_MODEL_TYPE | VARCHAR2 | (30) | ||
| LOT_SUBSTITUTION_ENABLED | VARCHAR2 | (1) | Lot Substitution Enabled for 11.5.9 | |
| MINIMUM_LICENSE_QUANTITY | NUMBER | Minimum License Quantity for 11.5.9 | ||
| EAM_ACTIVITY_SOURCE_CODE | VARCHAR2 | (30) | Activity Source for 11.5.9 | |
| LIFECYCLE_ID | NUMBER | |||
| CURRENT_PHASE_ID | NUMBER | |||
| OBJECT_VERSION_NUMBER | NUMBER | (9) | ||
| TRACKING_QUANTITY_IND | VARCHAR2 | (30) | Catch-weight Support for 11.5.10 | |
| ONT_PRICING_QTY_SOURCE | VARCHAR2 | (30) | Catch-Weight Support for 11.5.10 | |
| SECONDARY_DEFAULT_IND | VARCHAR2 | (30) | Catch-Weight Support for 11.5.10 | |
| OPTION_SPECIFIC_SOURCED | NUMBER | CTO changes for 11.5.10 | ||
| APPROVAL_STATUS | VARCHAR2 | (30) | 11.5.10 added for PLM it will be used in Part Number Request | |
| VMI_MINIMUM_UNITS | NUMBER | |||
| VMI_MINIMUM_DAYS | NUMBER | |||
| VMI_MAXIMUM_UNITS | NUMBER | |||
| VMI_MAXIMUM_DAYS | NUMBER | |||
| VMI_FIXED_ORDER_QUANTITY | NUMBER | |||
| SO_AUTHORIZATION_FLAG | NUMBER | |||
| CONSIGNED_FLAG | NUMBER | |||
| ASN_AUTOEXPIRE_FLAG | NUMBER | |||
| VMI_FORECAST_TYPE | NUMBER | |||
| FORECAST_HORIZON | NUMBER | |||
| EXCLUDE_FROM_BUDGET_FLAG | NUMBER | |||
| DAYS_TGT_INV_SUPPLY | NUMBER | |||
| DAYS_TGT_INV_WINDOW | NUMBER | |||
| DAYS_MAX_INV_SUPPLY | NUMBER | |||
| DAYS_MAX_INV_WINDOW | NUMBER | |||
| DRP_PLANNED_FLAG | NUMBER | |||
| CRITICAL_COMPONENT_FLAG | NUMBER | |||
| CONTINOUS_TRANSFER | NUMBER | |||
| CONVERGENCE | NUMBER | |||
| DIVERGENCE | NUMBER | |||
| CONFIG_ORGS | VARCHAR2 | (30) | CTO 11.5.10 Enahncement | |
| CONFIG_MATCH | VARCHAR2 | (30) | CTO 11.5.10 ENH | |
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | Yes | ||
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | |||
| REQUEST_ID | NUMBER | |||
| PROGRAM_APPLICATION_ID | NUMBER | |||
| PROGRAM_ID | NUMBER | |||
| PROGRAM_UPDATE_DATE | DATE | |||
| DESCRIPTION | VARCHAR2 | (240) | ||
| LONG_DESCRIPTION | VARCHAR2 | (4000) | ||
| CONCATENATED_SEGMENTS | VARCHAR2 | (40) | Concatenated segments based on the System Item key flexfield definition | |
| PADDED_CONCATENATED_SEGMENTS | VARCHAR2 | (40) | Padded concatenated segments based on the System Item key flexfield definition | |
| LOT_DIVISIBLE_FLAG | VARCHAR2 | (1) | Whether or not a lot may be transacted against for a quantity less than total onhand for lot | |
| GRADE_CONTROL_FLAG | VARCHAR2 | (1) | Whether the item is grade controlled | |
| DEFAULT_GRADE | VARCHAR2 | (150) | Default Grade assigned to a newly created lot | |
| CHILD_LOT_FLAG | VARCHAR2 | (1) | Whether a child lot can be created for items | |
| PARENT_CHILD_GENERATION_FLAG | VARCHAR2 | (1) | Generation method for child lot numbers | |
| CHILD_LOT_PREFIX | VARCHAR2 | (30) | Item-level prefix for child lot numbers | |
| CHILD_LOT_STARTING_NUMBER | NUMBER | Next auto assigned child lot number | ||
| CHILD_LOT_VALIDATION_FLAG | VARCHAR2 | (1) | Ensure that the child lot number conforms to the parameters defined for the item/organization | |
| COPY_LOT_ATTRIBUTE_FLAG | VARCHAR2 | (1) | If it is set to yes, a new child lot will inherit all attributes from the parent lot. If set to no, the lot attributes for a new child lot will not inherit the parent lot attributes and will default to values similar to a new lot. | |
| RECIPE_ENABLED_FLAG | VARCHAR2 | (1) | Flag indicating item may appear on a Recipe in OPM (Oracle Process Manufacturing) Process | |
| PROCESS_COSTING_ENABLED_FLAG | VARCHAR2 | (1) | Flag indicating cost information may be maintained in OPM (Oracle Process Manufacturing) | |
| RETEST_INTERVAL | NUMBER | Number of days specifying how often lot controlled items should be retested | ||
| EXPIRATION_ACTION_INTERVAL | NUMBER | Interval between the time lot expires and the time expiration action should be taken | ||
| EXPIRATION_ACTION_CODE | VARCHAR2 | (32) | Identifier code for action to take when a lot expires | |
| MATURITY_DAYS | NUMBER | Days to maturity | ||
| HOLD_DAYS | NUMBER | Number of hold days | ||
| PROCESS_QUALITY_ENABLED_FLAG | VARCHAR2 | (1) | Flag indicating item may be used in OPM (Oracle Process Manufacturing) Process Quality | |
| PROCESS_EXECUTION_ENABLED_FLAG | VARCHAR2 | (1) | Flag indicating item may be used in OPM (Oracle Process Manufacturing) Process Excecution | |
| PROCESS_SUPPLY_SUBINVENTORY | VARCHAR2 | (10) | Default supply subinventory for process execution transactions | |
| PROCESS_SUPPLY_LOCATOR_ID | NUMBER | Default supply locator for process execution transactions | ||
| PROCESS_YIELD_SUBINVENTORY | VARCHAR2 | (10) | Default yield subinventory for process execution transactions | |
| PROCESS_YIELD_LOCATOR_ID | NUMBER | Default yield locator for process execution transactions | ||
| HAZARDOUS_MATERIAL_FLAG | VARCHAR2 | (1) | Flag indicating item is hazardous | |
| CAS_NUMBER | VARCHAR2 | (30) | Chemical abstracts service registry number | |
| CHARGE_PERIODICITY_CODE | VARCHAR2 | (3) | ||
| REPAIR_LEADTIME | NUMBER | |||
| REPAIR_YIELD | NUMBER | |||
| PREPOSITION_POINT | VARCHAR2 | (1) | ||
| REPAIR_PROGRAM | NUMBER | |||
| SUBCONTRACTING_COMPONENT | NUMBER | |||
| OUTSOURCED_ASSEMBLY | NUMBER | |||
| GDSN_OUTBOUND_ENABLED_FLAG | VARCHAR2 | (1) | ||
| TRADE_ITEM_DESCRIPTOR | VARCHAR2 | (35) | ||
| STYLE_ITEM_ID | NUMBER | |||
| STYLE_ITEM_FLAG | VARCHAR2 | (1) | ||
| LAST_SUBMITTED_NIR_ID | NUMBER | |||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | ||
| SERIAL_TAGGING_FLAG | VARCHAR2 | (1) | Flag indicates if Serial Tagging Assignments exist for an Item | |
| EGO_MASTER_ITEMS_DFF_CTX | VARCHAR2 | (1) | ||
| DEFAULT_MATERIAL_STATUS_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, PRIMARY_UOM_CODE
, PRIMARY_UNIT_OF_MEASURE
, ITEM_TYPE
, INVENTORY_ITEM_STATUS_CODE
, ALLOWED_UNITS_LOOKUP_CODE
, ITEM_CATALOG_GROUP_ID
, CATALOG_STATUS_FLAG
, INVENTORY_ITEM_FLAG
, STOCK_ENABLED_FLAG
, MTL_TRANSACTIONS_ENABLED_FLAG
, CHECK_SHORTAGES_FLAG
, REVISION_QTY_CONTROL_CODE
, RESERVABLE_TYPE
, SHELF_LIFE_CODE
, SHELF_LIFE_DAYS
, CYCLE_COUNT_ENABLED_FLAG
, NEGATIVE_MEASUREMENT_ERROR
, POSITIVE_MEASUREMENT_ERROR
, LOT_CONTROL_CODE
, AUTO_LOT_ALPHA_PREFIX
, START_AUTO_LOT_NUMBER
, SERIAL_NUMBER_CONTROL_CODE
, AUTO_SERIAL_ALPHA_PREFIX
, START_AUTO_SERIAL_NUMBER
, LOCATION_CONTROL_CODE
, RESTRICT_SUBINVENTORIES_CODE
, RESTRICT_LOCATORS_CODE
, BOM_ENABLED_FLAG
, BOM_ITEM_TYPE
, BASE_ITEM_ID
, EFFECTIVITY_CONTROL
, ENG_ITEM_FLAG
, ENGINEERING_ECN_CODE
, ENGINEERING_ITEM_ID
, ENGINEERING_DATE
, PRODUCT_FAMILY_ITEM_ID
, AUTO_CREATED_CONFIG_FLAG
, MODEL_CONFIG_CLAUSE_NAME
, NEW_REVISION_CODE
, COSTING_ENABLED_FLAG
, INVENTORY_ASSET_FLAG
, DEFAULT_INCLUDE_IN_ROLLUP_FLAG
, COST_OF_SALES_ACCOUNT
, STD_LOT_SIZE
, PURCHASING_ITEM_FLAG
, PURCHASING_ENABLED_FLAG
, MUST_USE_APPROVED_VENDOR_FLAG
, ALLOW_ITEM_DESC_UPDATE_FLAG
, RFQ_REQUIRED_FLAG
, OUTSIDE_OPERATION_FLAG
, OUTSIDE_OPERATION_UOM_TYPE
, TAXABLE_FLAG
, PURCHASING_TAX_CODE
, RECEIPT_REQUIRED_FLAG
, INSPECTION_REQUIRED_FLAG
, BUYER_ID
, UNIT_OF_ISSUE
, RECEIVE_CLOSE_TOLERANCE
, INVOICE_CLOSE_TOLERANCE
, UN_NUMBER_ID
, HAZARD_CLASS_ID
, LIST_PRICE_PER_UNIT
, MARKET_PRICE
, PRICE_TOLERANCE_PERCENT
, ROUNDING_FACTOR
, ENCUMBRANCE_ACCOUNT
, EXPENSE_ACCOUNT
, ASSET_CATEGORY_ID
, RECEIPT_DAYS_EXCEPTION_CODE
, DAYS_EARLY_RECEIPT_ALLOWED
, DAYS_LATE_RECEIPT_ALLOWED
, ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, ALLOW_UNORDERED_RECEIPTS_FLAG
, ALLOW_EXPRESS_DELIVERY_FLAG
, QTY_RCV_EXCEPTION_CODE
, QTY_RCV_TOLERANCE
, RECEIVING_ROUTING_ID
, ENFORCE_SHIP_TO_LOCATION_CODE
, WEIGHT_UOM_CODE
, UNIT_WEIGHT
, VOLUME_UOM_CODE
, UNIT_VOLUME
, CONTAINER_ITEM_FLAG
, VEHICLE_ITEM_FLAG
, CONTAINER_TYPE_CODE
, INTERNAL_VOLUME
, MAXIMUM_LOAD_WEIGHT
, MINIMUM_FILL_PERCENT
, INVENTORY_PLANNING_CODE
, PLANNER_CODE
, PLANNING_MAKE_BUY_CODE
, MIN_MINMAX_QUANTITY
, MAX_MINMAX_QUANTITY
, MINIMUM_ORDER_QUANTITY
, MAXIMUM_ORDER_QUANTITY
, ORDER_COST
, CARRYING_COST
, SOURCE_TYPE
, SOURCE_ORGANIZATION_ID
, SOURCE_SUBINVENTORY
, MRP_SAFETY_STOCK_CODE
, SAFETY_STOCK_BUCKET_DAYS
, MRP_SAFETY_STOCK_PERCENT
, FIXED_ORDER_QUANTITY
, FIXED_DAYS_SUPPLY
, FIXED_LOT_MULTIPLIER
, MRP_PLANNING_CODE
, ATO_FORECAST_CONTROL
, PLANNING_EXCEPTION_SET
, END_ASSEMBLY_PEGGING_FLAG
, SHRINKAGE_RATE
, ROUNDING_CONTROL_TYPE
, ACCEPTABLE_EARLY_DAYS
, REPETITIVE_PLANNING_FLAG
, OVERRUN_PERCENTAGE
, ACCEPTABLE_RATE_INCREASE
, ACCEPTABLE_RATE_DECREASE
, MRP_CALCULATE_ATP_FLAG
, AUTO_REDUCE_MPS
, PLANNING_TIME_FENCE_CODE
, PLANNING_TIME_FENCE_DAYS
, DEMAND_TIME_FENCE_CODE
, DEMAND_TIME_FENCE_DAYS
, RELEASE_TIME_FENCE_CODE
, RELEASE_TIME_FENCE_DAYS
, PREPROCESSING_LEAD_TIME
, FULL_LEAD_TIME
, POSTPROCESSING_LEAD_TIME
, FIXED_LEAD_TIME
, VARIABLE_LEAD_TIME
, CUM_MANUFACTURING_LEAD_TIME
, CUMULATIVE_TOTAL_LEAD_TIME
, LEAD_TIME_LOT_SIZE
, BUILD_IN_WIP_FLAG
, WIP_SUPPLY_TYPE
, WIP_SUPPLY_SUBINVENTORY
, WIP_SUPPLY_LOCATOR_ID
, OVERCOMPLETION_TOLERANCE_TYPE
, OVERCOMPLETION_TOLERANCE_VALUE
, CUSTOMER_ORDER_FLAG
, CUSTOMER_ORDER_ENABLED_FLAG
, SHIPPABLE_ITEM_FLAG
, INTERNAL_ORDER_FLAG
, INTERNAL_ORDER_ENABLED_FLAG
, SO_TRANSACTIONS_FLAG
, PICK_COMPONENTS_FLAG
, ATP_FLAG
, REPLENISH_TO_ORDER_FLAG
, ATP_RULE_ID
, ATP_COMPONENTS_FLAG
, SHIP_MODEL_COMPLETE_FLAG
, PICKING_RULE_ID
, COLLATERAL_FLAG
, DEFAULT_SHIPPING_ORG
, RETURNABLE_FLAG
, RETURN_INSPECTION_REQUIREMENT
, OVER_SHIPMENT_TOLERANCE
, UNDER_SHIPMENT_TOLERANCE
, OVER_RETURN_TOLERANCE
, UNDER_RETURN_TOLERANCE
, INVOICEABLE_ITEM_FLAG
, INVOICE_ENABLED_FLAG
, ACCOUNTING_RULE_ID
, INVOICING_RULE_ID
, TAX_CODE
, SALES_ACCOUNT
, PAYMENT_TERMS_ID
, SERVICE_ITEM_FLAG
, VENDOR_WARRANTY_FLAG
, COVERAGE_SCHEDULE_ID
, SERVICE_DURATION
, SERVICE_DURATION_PERIOD_CODE
, SERVICEABLE_PRODUCT_FLAG
, SERVICE_STARTING_DELAY
, MATERIAL_BILLABLE_FLAG
, TIME_BILLABLE_FLAG
, EXPENSE_BILLABLE_FLAG
, SERVICEABLE_COMPONENT_FLAG
, PREVENTIVE_MAINTENANCE_FLAG
, PRORATE_SERVICE_FLAG
, SERVICEABLE_ITEM_CLASS_ID
, BASE_WARRANTY_SERVICE_ID
, WARRANTY_VENDOR_ID
, MAX_WARRANTY_AMOUNT
, RESPONSE_TIME_PERIOD_CODE
, RESPONSE_TIME_VALUE
, PRIMARY_SPECIALIST_ID
, SECONDARY_SPECIALIST_ID
, WH_UPDATE_DATE
, SEGMENT1
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, SEGMENT9
, SEGMENT10
, SEGMENT11
, SEGMENT12
, SEGMENT13
, SEGMENT14
, SEGMENT15
, SEGMENT16
, SEGMENT17
, SEGMENT18
, SEGMENT19
, SEGMENT20
, SUMMARY_FLAG
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, EQUIPMENT_TYPE
, RECOVERED_PART_DISP_CODE
, DEFECT_TRACKING_ON_FLAG
, USAGE_ITEM_FLAG
, EVENT_FLAG
, ELECTRONIC_FLAG
, DOWNLOADABLE_FLAG
, VOL_DISCOUNT_EXEMPT_FLAG
, COUPON_EXEMPT_FLAG
, COMMS_NL_TRACKABLE_FLAG
, ASSET_CREATION_CODE
, COMMS_ACTIVATION_REQD_FLAG
, ORDERABLE_ON_WEB_FLAG
, BACK_ORDERABLE_FLAG
, WEB_STATUS
, INDIVISIBLE_FLAG
, DIMENSION_UOM_CODE
, UNIT_LENGTH
, UNIT_WIDTH
, UNIT_HEIGHT
, BULK_PICKED_FLAG
, LOT_STATUS_ENABLED
, DEFAULT_LOT_STATUS_ID
, SERIAL_STATUS_ENABLED
, DEFAULT_SERIAL_STATUS_ID
, LOT_SPLIT_ENABLED
, LOT_MERGE_ENABLED
, INVENTORY_CARRY_PENALTY
, OPERATION_SLACK_PENALTY
, FINANCING_ALLOWED_FLAG
, EAM_ITEM_TYPE
, EAM_ACTIVITY_TYPE_CODE
, EAM_ACTIVITY_CAUSE_CODE
, EAM_ACT_NOTIFICATION_FLAG
, EAM_ACT_SHUTDOWN_STATUS
, DUAL_UOM_CONTROL
, SECONDARY_UOM_CODE
, DUAL_UOM_DEVIATION_HIGH
, DUAL_UOM_DEVIATION_LOW
, CONTRACT_ITEM_TYPE_CODE
, SUBSCRIPTION_DEPEND_FLAG
, SERV_REQ_ENABLED_CODE
, SERV_BILLING_ENABLED_FLAG
, SERV_IMPORTANCE_LEVEL
, PLANNED_INV_POINT_FLAG
, LOT_TRANSLATE_ENABLED
, DEFAULT_SO_SOURCE_TYPE
, CREATE_SUPPLY_FLAG
, SUBSTITUTION_WINDOW_CODE
, SUBSTITUTION_WINDOW_DAYS
, IB_ITEM_INSTANCE_CLASS
, CONFIG_MODEL_TYPE
, LOT_SUBSTITUTION_ENABLED
, MINIMUM_LICENSE_QUANTITY
, EAM_ACTIVITY_SOURCE_CODE
, LIFECYCLE_ID
, CURRENT_PHASE_ID
, OBJECT_VERSION_NUMBER
, TRACKING_QUANTITY_IND
, ONT_PRICING_QTY_SOURCE
, SECONDARY_DEFAULT_IND
, OPTION_SPECIFIC_SOURCED
, APPROVAL_STATUS
, VMI_MINIMUM_UNITS
, VMI_MINIMUM_DAYS
, VMI_MAXIMUM_UNITS
, VMI_MAXIMUM_DAYS
, VMI_FIXED_ORDER_QUANTITY
, SO_AUTHORIZATION_FLAG
, CONSIGNED_FLAG
, ASN_AUTOEXPIRE_FLAG
, VMI_FORECAST_TYPE
, FORECAST_HORIZON
, EXCLUDE_FROM_BUDGET_FLAG
, DAYS_TGT_INV_SUPPLY
, DAYS_TGT_INV_WINDOW
, DAYS_MAX_INV_SUPPLY
, DAYS_MAX_INV_WINDOW
, DRP_PLANNED_FLAG
, CRITICAL_COMPONENT_FLAG
, CONTINOUS_TRANSFER
, CONVERGENCE
, DIVERGENCE
, CONFIG_ORGS
, CONFIG_MATCH
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, DESCRIPTION
, LONG_DESCRIPTION
, CONCATENATED_SEGMENTS
, PADDED_CONCATENATED_SEGMENTS
, LOT_DIVISIBLE_FLAG
, GRADE_CONTROL_FLAG
, DEFAULT_GRADE
, CHILD_LOT_FLAG
, PARENT_CHILD_GENERATION_FLAG
, CHILD_LOT_PREFIX
, CHILD_LOT_STARTING_NUMBER
, CHILD_LOT_VALIDATION_FLAG
, COPY_LOT_ATTRIBUTE_FLAG
, RECIPE_ENABLED_FLAG
, PROCESS_COSTING_ENABLED_FLAG
, RETEST_INTERVAL
, EXPIRATION_ACTION_INTERVAL
, EXPIRATION_ACTION_CODE
, MATURITY_DAYS
, HOLD_DAYS
, PROCESS_QUALITY_ENABLED_FLAG
, PROCESS_EXECUTION_ENABLED_FLAG
, PROCESS_SUPPLY_SUBINVENTORY
, PROCESS_SUPPLY_LOCATOR_ID
, PROCESS_YIELD_SUBINVENTORY
, PROCESS_YIELD_LOCATOR_ID
, HAZARDOUS_MATERIAL_FLAG
, CAS_NUMBER
, CHARGE_PERIODICITY_CODE
, REPAIR_LEADTIME
, REPAIR_YIELD
, PREPOSITION_POINT
, REPAIR_PROGRAM
, SUBCONTRACTING_COMPONENT
, OUTSOURCED_ASSEMBLY
, GDSN_OUTBOUND_ENABLED_FLAG
, TRADE_ITEM_DESCRIPTOR
, STYLE_ITEM_ID
, STYLE_ITEM_FLAG
, LAST_SUBMITTED_NIR_ID
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, SERIAL_TAGGING_FLAG
, EGO_MASTER_ITEMS_DFF_CTX
, DEFAULT_MATERIAL_STATUS_ID
FROM APPS.MTL_SYSTEM_ITEMS_VL;
APPS
MTL_SYSTEM_ITEMS_B_KFV
MTL_SYSTEM_ITEMS_TL
APPS
AHL_COMPLEX_MX_RWSC_PVT
- show dependent code
AHL_JOB_OPER_MATERIALS_V
AHL_LTP_MATRL_AVAL_PVT
- show dependent code
AHL_LTP_REQST_MATRL_PVT
- show dependent code
AHL_LTP_SPACE_SCHEDULE_PVT
- show dependent code
AHL_OSP_SHIPMENT_PUB
- show dependent code
AHL_PP_MATERIALS_PVT
- show dependent code
AHL_PRD_BLK_PARTS_CHANGE_PVT
- show dependent code
AHL_PRD_SERN_CHANGE_PVT
- show dependent code
AHL_VWP_PRICE_PVT
- show dependent code
AMS_ACT_PRODUCTS_V
AMS_CAMPAIGN_PRODUCTS_V
AMS_CAMPAIGN_PRODUCT_VOLUMES_V
AMS_DS_SALES_LEADS_V
AMS_OFFER_PRODUCTS_V
AMS_RUNTIME_PROD_PVT
- show dependent code
AR_INVOICE_UTILS
- show dependent code
AR_RDR_ITEMS_V
ASO_AK_QUOTE_LINE_V
ASO_ATP_INT
- show dependent code
ASO_COPY_QUOTE_PVT
- show dependent code
ASO_COPY_TMPL_PUB
- show dependent code
ASO_DEFAULTING_UTIL
- show dependent code
ASO_I_ITEMS_V
ASO_I_ORDER_LINES_V
ASO_I_RELATED_ITEMS_V
ASO_OPP_QTE_PUB
- show dependent code
ASO_PVT_INSTALL_BASE_BALI_V
ASO_PVT_PENDING_ORDERS_BALI_V
ASO_PVT_PRODUCT_CATALOG_BALI_V
ASO_PVT_QTE_LINES_PRINT_NUM_V
ASO_PVT_QUOTE_LINES_BALIVIEW_V
ASO_PVT_QUOTE_LINES_NUM_V
ASO_PVT_QUOTE_LINES_V
ASO_PVT_RELATED_ITEMS_BALI_V
ASO_QUOTE_HEADERS_PVT
- show dependent code
ASO_QUOTE_TMPL_PVT
- show dependent code
ASO_SERVICE_CONTRACTS_INT
- show dependent code
ASO_SERVICE_CONTRACTS_INT_W
- show dependent code
ASO_UTILITY_PVT
- show dependent code
AST_ITEM_RELATIONSHIPS_V
AST_LM_COLLATERAL_V
AST_SALES_LEAD_LINES_PC_V
AST_SALES_LEAD_LINES_V
AS_INV_ITEM_LOV_V
AS_OPP_LINE_PVT
- show dependent code
BOMPCMBM
- show dependent code
BOMPKMUD
- show dependent code
BOM_BILL_OF_MATERIALS_ERV
BOM_BULKLOAD_PVT_PKG
- show dependent code
BOM_DELETE_ENTITY
- show dependent code
BOM_IMPLOSIONS_V
BOM_IMPORT_PUB
- show dependent code
BOM_OPERATIONAL_ROUTINGS_ERV
BOM_REVISIONS
- show dependent code
BOM_ROLLUP_PUB
- show dependent code
BOM_STRUCTURE_SYNC_V
BOM_SUBSTITUTE_COMPONENTS_ERV
CLN_INVENTORY_REPORT_V
CLN_ITEMMST_ITEMHEADER_V
CRP_BILL_OF_RESOURCE_ITEMS_V
CSD_CP_REFERENCE_V
CSD_CUSTOMER_SEARCH_V
CSD_ESTIMATE_DETAILS_EXT_V
CSD_INCIDENTS_NON_SEC_V
CSD_INCIDENTS_V
CSD_IR_REPAIR_JOBS_V
CSD_PROCESS_PVT
- show dependent code
CSD_PRODUCT_TXNS_V
CSD_REPAIRS_NON_SEC_V
CSD_REPAIRS_V
CSD_REPAIR_ACTUAL_LINES_V
CSD_REPAIR_ESTIMATE_LINES_V
CSD_REPAIR_JOBS_V
CSD_REPAIR_ORDER_GROUPS_V
CSD_RO_GROUP_DETAILS_V
CSD_RO_SUMMARY_V
CSD_SERIAL_NUMBERS_V
CSD_SPLIT_PKG
- show dependent code
CSFW_DEBRIEF_PUB
- show dependent code
CSF_ALERTS_PUB
- show dependent code
CSF_ALERTS_PUB
- show dependent code
CSF_PARAMS_PKG
- show dependent code
CSI_DEBUG_PKG
- show dependent code
CSI_INSTANCE_DETAILS_V
CSI_INSTANCE_SEARCH_V
CSP_CURR_SUP_DEM_SUMS_V
CSP_MOVEORDERS_V
CSP_NOTIFICATIONS_V
CSP_NOT_STAT_ITEMS_NAV
CSP_PICKLIST_LINES_V1
CSP_PLIST_BOXITEMS_NAV
CSP_RECV_PARTS_V
CST_AEL_GL_INV_V
CST_AEL_SL_INV_V
CST_INV_DISTRIBUTION_V
CST_ITEM_COST_TYPE_V
CST_LC_ADJ_INTERFACE_V
CST_MGD_LIFO_ITEM_COSTS_V
CST_MTL_RCV_TXN_V
CST_RCV_RAE_V
CST_WIP_ENTITY_V
CS_AUDIT_REPORT_VW
CS_BRM_3D_SERVICE_REQUEST_V
CS_ERES_INT_PKG
- show dependent code
CS_INCIDENTS_WORKFLOW_V
CS_KNOWLEDGE_AUDIT_PVT
- show dependent code
CS_SERVICEREQUEST_UTIL
- show dependent code
CS_SR_CP_NEW_ACCT_EAM_NM_RG_V
CS_SR_CP_NEW_ACCT_EAM_RG_V
CS_SR_FIND_EAM_PROD_MAINT_NM_V
CS_SR_FIND_EAM_PROD_MAINT_V
CS_SR_FIND_PROD_MAINT_EAM_V
CS_SR_FIND_PROD_MAINT_P_EAM_V
CS_SR_FUL_PKG
- show dependent code
CS_SR_INV_COMPONENTS_V
CS_SR_INV_SUBCOMPONENTS_V
CS_SR_NEW_ACC_CP_RG2_V
CS_SR_NEW_ACC_CP_RG_V
CS_SR_NEW_FIND_PROD_MAINT_P_V
CS_SR_NEW_FIND_PROD_MAINT_V
CTO_BOM_RTG_PK
- show dependent code
CTO_CHANGE_ORDER_PK
- show dependent code
CTO_CONFIG_BOM_PK
- show dependent code
CTO_UTILITY_PK
- show dependent code
CZ_BOM_SYNCH
- show dependent code
CZ_MODEL_MIGRATION_PVT
- show dependent code
CZ_PB_SYNC
- show dependent code
EAM_CONSTRUCTION_EST_PVT
- show dependent code
EAM_COPY_BOM_PKG
- show dependent code
EAM_PM_SCHEDULINGS_V
EAM_PM_UTILS
- show dependent code
EAM_WB_UTILS
- show dependent code
ECEPOI
- show dependent code
EGO_ICC_STRUCTURE_PVT
- show dependent code
EGO_ITEM_COMPARE_PKG
- show dependent code
EGO_ITEM_PUB
- show dependent code
EGO_ITEM_WS_PVT
- show dependent code
EGO_PUBLICATION_PKG
- show dependent code
EGO_TRANSACTION_ATTRS_PVT
- show dependent code
EGO_UI_ITEM_PUB
- show dependent code
ENGECOBO
- show dependent code
ENGPKIMP
- show dependent code
ENG_CHANGE_LINE_UTIL
- show dependent code
ENG_DEFAULT_REVISED_ITEM
- show dependent code
ENG_ECO_UTIL
- show dependent code
ENG_IMPACTED_BILLS_ERV
ENG_NIR_UTIL_PKG
- show dependent code
ENG_REVISED_COMPONENTS_ERV
ENG_REVISED_ITEMS_ERV
ENG_REVISED_ITEMS_INTERFACE_V
ENG_REVISED_ITEMS_PKG
- show dependent code
ENG_VALIDATE_REVISED_ITEM
- show dependent code
FLM_EKB_BUSINESS_EVENT_PKG
- show dependent code
FLM_RECEIPT_PUB
- show dependent code
FTE_CARRIER_VEHICLE_TYPES_V
FTE_COMP_CONSTRAINT_UTIL
- show dependent code
FTE_ESTIMATE_FREIGHT_RATE
- show dependent code
GMD_AUTO_SAMPLE_PKG
- show dependent code
GMD_ERES_MATERIALS_VW
GMD_ERES_UTILS
- show dependent code
GMD_FORMULA_DETAIL_PUB
- show dependent code
GMD_MBR_MATERIAL_V1
GMD_MBR_STEP_MATERIAL_V1
GMD_QMSMC
- show dependent code
GMD_SAMPLES_GRP
- show dependent code
GME_GANTT_LOV_PKG
- show dependent code
GME_INGRED_PICK_VW
GME_MATERIAL_DETAILS_V
GME_MOBILE_TXN
- show dependent code
GME_POST_MIGRATION
- show dependent code
GME_STEP_MATERIAL_DETAILS_V
GMO_DISPENSE_GRP
- show dependent code
GMO_DISPENSE_PVT
- show dependent code
GMO_DISPENSE_SETUP_PVT
- show dependent code
GMO_DISP_CON_PKG
- show dependent code
IBC_UTILITIES_PVT
- show dependent code
IBE_CART_NOTIFY_UTIL
- show dependent code
IBE_CATALOG_PVT
- show dependent code
IBE_CCTBOM_PVT
- show dependent code
IBE_DSP_HIERARCHY_QUERY_PVT
- show dependent code
IBE_DSP_TPL_ITEM_CTG_V
IBE_M_AUTOPLACEMENT_PVT
- show dependent code
IBE_ORDER_DETAIL_V
IBE_ORDER_ITEMS_ADV_V
IBE_ORDER_LINE_DTL_V
IBE_PRICE_PVT
- show dependent code
IBE_PROD_RELATION_RULE_PVT
- show dependent code
IBE_QUOTE_SAVE_PVT
- show dependent code
IBE_RETURNABLE_LINES_V
IBE_RETURNABLE_SERIAL_V
IBE_RETURN_DETAIL_V
IBE_SHIP_DETAIL_V
IBE_SHIP_DLVY_DTL_V
IBE_WORKFLOW_PVT
- show dependent code
INL_LANDEDCOST_PVT
- show dependent code
INL_SHIPMENT_PVT
- show dependent code
INL_SHIP_IR_OVERALL_V
INL_SHIP_OVERALL_V
INL_SHIP_PO_OVERALL_V
INL_SHIP_RMA_OVERALL_V
INVPVALM
- show dependent code
INVTROAP
- show dependent code
INVUPD1B
- show dependent code
INVUPD2B
- show dependent code
INV_CONVERT
- show dependent code
INV_EBI_CHANGE_ORDER_HELPER
- show dependent code
INV_EBI_ITEM_HELPER
- show dependent code
INV_ITEM_GRP
- show dependent code
INV_ITEM_INQ
- show dependent code
INV_KANBAN_PKG
- show dependent code
INV_LABEL_PVT1
- show dependent code
INV_LABEL_PVT11
- show dependent code
INV_LABEL_PVT13
- show dependent code
INV_LABEL_PVT15
- show dependent code
INV_LABEL_PVT16
- show dependent code
INV_LABEL_PVT2
- show dependent code
INV_LABEL_PVT9
- show dependent code
INV_MINMAX_PVT
- show dependent code
INV_MWB_QUERY_MANAGER
- show dependent code
INV_OBJECT_GENEALOGY
- show dependent code
INV_REPLENISH_COUNT_PVT
- show dependent code
INV_SHIPPING_TRANSACTION_PUB
- show dependent code
INV_UI_ITEM_ATT_LOVS
- show dependent code
INV_UI_ITEM_LOVS
- show dependent code
INV_UI_RCV_LOVS
- show dependent code
JMF_SHIKYU_ONT_PVT
- show dependent code
JMF_SHIKYU_RPT_CFR_PVT
- show dependent code
JMF_SHIKYU_RPT_CUR_PVT
- show dependent code
JMF_SHIKYU_RPT_SPR_PVT
- show dependent code
JTF_DSP_TPL_ITEM_CTG_V
JTF_RS_PLATFORMS_V
MRP_FORECAST_ITEMS_V
MRP_SCHEDULE_ITEMS_V
MTL_CLIENT_ITEMS_VL
MTL_EAM_ASSET_ACTIVITIES_V
MTL_EAM_ASSET_ACTIVITIES_WB_V
MTL_EAM_ITEMS_V
MTL_LOT_ONHAND_SUM_V
MTL_MATERIAL_TXNS_VAL_V
MTL_ONHAND_ITEMS_V
MTL_ONHAND_LPN_MWB_V
MTL_ONHAND_LPN_V
MTL_ONHAND_NEW_LPN_MWB_V
MTL_ONHAND_NEW_LPN_V
MTL_ONHAND_SERIAL_MWB_V
MTL_ONHAND_SERIAL_V
MTL_ONHAND_TOTAL_MWB_V
MTL_ONHAND_TOTAL_V
MTL_RCV_MWB_NEW_OH_V
MTL_RCV_MWB_ONHAND_V
MTL_RCV_SERIAL_MWB_OH_V
MTL_RCV_SERIAL_OH_V
MTL_TRANSACTIONS_TEMP_ALL_V
OEFV_ORDER_LINES
OE_ACKNOWLEDGMENT_PVT
- show dependent code
OE_BLANKET_UTIL
- show dependent code
OE_BULK_ACK_PVT
- show dependent code
OE_BULK_PROCESS_LINE
- show dependent code
OE_CNCL_VALIDATE_LINE
- show dependent code
OE_CNCL_VALUE_TO_ID
- show dependent code
OE_ID_TO_VALUE
- show dependent code
OE_INVOICE_PUB
- show dependent code
OE_LINE_ACK_UTIL
- show dependent code
OE_OE_FORM_LINE
- show dependent code
OE_ORDER_IMPORT_SPECIFIC_PVT
- show dependent code
OE_ORDER_MISC_UTIL
- show dependent code
OE_ORDER_SCH_UTIL
- show dependent code
OE_SCHEDULE_UTIL
- show dependent code
OE_SCH_ORDER_LINES_V
OE_SCH_RSV_SET_LINES_V
OE_VALIDATE_LINE
- show dependent code
OKC_XPRT_QA_PVT
- show dependent code
OKC_XPRT_QUOTE_INT_PVT
- show dependent code
OKC_XPRT_UTIL_PVT
- show dependent code
OKL_AM_ASSET_RETURN_PVT
- show dependent code
OKL_CS_ASSET_COUNTERS_UV
OKL_FE_WF
- show dependent code
OKL_PA_DATA_INTEGRITY
- show dependent code
ONT_ITM_PKG
- show dependent code
ONT_OEXCRDIS_XMLP_PKG
- show dependent code
ONT_OEXIODIS_XMLP_PKG
- show dependent code
ONT_OEXOEACK_XMLP_PKG
- show dependent code
ONT_OEXOECCL_XMLP_PKG
- show dependent code
ONT_OEXOECOD_XMLP_PKG
- show dependent code
ONT_OEXOEIOD_XMLP_PKG
- show dependent code
ONT_OEXOEITR_XMLP_PKG
- show dependent code
ONT_OEXOEOCR_XMLP_PKG
- show dependent code
ONT_OEXOEOCS_XMLP_PKG
- show dependent code
ONT_OEXOEORD_XMLP_PKG
- show dependent code
ONT_OEXOEORR_XMLP_PKG
- show dependent code
ONT_OEXOEORS_XMLP_PKG
- show dependent code
ONT_OEXOESOS_XMLP_PKG
- show dependent code
ONT_OEXOEUBK_XMLP_PKG
- show dependent code
ONT_OEXOHHSA_XMLP_PKG
- show dependent code
ONT_OEXOHOHS_XMLP_PKG
- show dependent code
ONT_OEXPRPRD_XMLP_PKG
- show dependent code
OZF_AP_INTERFACE_PVT
- show dependent code
OZF_AR_INTERFACE_PVT
- show dependent code
OZF_AR_SETTLEMENT_PVT
- show dependent code
OZF_OM_VALIDATION_PVT
- show dependent code
OZF_PRE_PROCESS_PVT
- show dependent code
OZF_RESALE_LINES_V
OZF_SUPP_TRADE_PROFILE_PUB
- show dependent code
OZF_TP_UTIL_QUERIES
- show dependent code
OZF_WEBADI_INTERFACE_PVT
- show dependent code
POS_PO_SUPPLIER_ITEMS_V
PO_EMAIL_GENERATE
- show dependent code
PO_PDOI_ITEM_PROCESS_PVT
- show dependent code
PO_SGD_LINES_V
PO_SGD_MOD_LINES_V
PO_VAL_LINES2
- show dependent code
QOT_DEFAULT_PVT
- show dependent code
QPR_SR_OM_QUOTE_LINES_V
QPR_SR_QUOTE_LINES_V
QP_BULK_VALIDATE
- show dependent code
QP_BULK_VALUE_TO_ID
- show dependent code
QP_CUSTOMER_ITEMS_V
QP_MASS_MAINTAIN_UTIL
- show dependent code
QP_PREQ_GRP
- show dependent code
QP_PRICE_BOOK_UTIL
- show dependent code
QP_PRICE_FORMULA_UPG_UTIL_PVT
- show dependent code
QP_PRICE_LIST_LINE_UTIL
- show dependent code
QP_QPXPRCST_XMLP_PKG
- show dependent code
RCV_DEFAULT_PKG
- show dependent code
RCV_ROI_TRANSACTION
- show dependent code
SO_CONFIG_COMPONENTS_V
SO_INCLUDED_ITEMS_OEXORRSO_V
SO_LINES_CANCEL_V
SO_LINES_RMA_V
SO_LINES_VIEW_RETURNS_V
SO_LINE_DETAILS_V
SO_LINE_DETAILS_VIEW_WIP_V
SO_PICKING_LINES_V
SO_PICKING_LINE_DETAILS_V
SO_PICKING_LINE_DETAIL_VO_V
SO_PRICE_LIST_LINES_ALL_V
SO_SCHEDULE_DETAILS
WIP_EXP_NOTIF_WF_PKG
- show dependent code
WIP_PICKING_PVT
- show dependent code
WIP_REQUIREMENT_OPERATIONS_V
WMS_PICKING_PKG
- show dependent code
WMS_PICK_DROP_PVT
- show dependent code
WMS_SHIPPING_TRANSACTION_PUB
- show dependent code
WMS_TASK_DISPATCH_LOV
- show dependent code
WSH_BOLS_UTIL_PKG
- show dependent code
WSH_IB_UI_RECON_GRP
- show dependent code
WSH_OPSM_ASN_ITEM_GENEALOGY
- show dependent code
WSH_OPSM_ASN_ITEM_GENEALOGY
- show dependent code
WSH_WSHRDBDR_XMLP_PKG
- show dependent code
WSH_WSHRDBOL_XMLP_PKG
- show dependent code
WSH_WSHRDBSR_XMLP_PKG
- show dependent code
WSH_WSHRDINV_XMLP_PKG
- show dependent code
WSH_WSHRDMBL_XMLP_PKG
- show dependent code
WSH_WSHRDPAK_XMLP_PKG
- show dependent code
WSH_WSHRDSDL_XMLP_PKG
- show dependent code
XDP_ORDER
- show dependent code
XDP_PERF_BM_PKG
- show dependent code
XNB_CMN_PVT
- show dependent code
XNB_ITEMMST_CATS_V
XNB_ITEM_BATCH_PVT
- show dependent code
XNB_ORDER_LINES_V
XNB_SALES_ORDER_PVT
- show dependent code
XNP_CVU_PKG
- show dependent code
|
|
|
|