[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CN_MTL_SYSTEM_ITEM_CATS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INVENTORY_ITEM_ID | NUMBER | Yes | ||
| ORGANIZATION_ID | NUMBER | Yes | ||
| CATEGORY_SET_ID | NUMBER | Yes | ||
| CATEGORY_ID | NUMBER | Yes | ||
| VENDOR_WARRANTY_FLAG | VARCHAR2 | (1) | Yes | |
| SERVICEABLE_COMPONENT_FLAG | VARCHAR2 | (1) | ||
| SERVICEABLE_PRODUCT_FLAG | VARCHAR2 | (1) | Yes | |
| BASE_WARRANTY_SERVICE_ID | NUMBER | |||
| PAYMENT_TERMS_ID | NUMBER | |||
| PREVENTIVE_MAINTENANCE_FLAG | VARCHAR2 | (1) | ||
| PRIMARY_SPECIALIST_ID | NUMBER | |||
| SECONDARY_SPECIALIST_ID | NUMBER | |||
| SERVICEABLE_ITEM_CLASS_ID | NUMBER | |||
| TIME_BILLABLE_FLAG | VARCHAR2 | (1) | ||
| MATERIAL_BILLABLE_FLAG | VARCHAR2 | (30) | ||
| EXPENSE_BILLABLE_FLAG | VARCHAR2 | (1) | ||
| PRORATE_SERVICE_FLAG | VARCHAR2 | (1) | ||
| COVERAGE_SCHEDULE_ID | NUMBER | |||
| SERVICE_DURATION_PERIOD_CODE | VARCHAR2 | (10) | ||
| SERVICE_DURATION | NUMBER | |||
| WARRANTY_VENDOR_ID | NUMBER | |||
| MAX_WARRANTY_AMOUNT | NUMBER | |||
| RESPONSE_TIME_PERIOD_CODE | VARCHAR2 | (30) | ||
| RESPONSE_TIME_VALUE | NUMBER | |||
| NEW_REVISION_CODE | VARCHAR2 | (30) | ||
| INVOICEABLE_ITEM_FLAG | VARCHAR2 | (1) | Yes | |
| TAX_CODE | VARCHAR2 | (50) | ||
| INVOICE_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| MUST_USE_APPROVED_VENDOR_FLAG | VARCHAR2 | (1) | Yes | |
| TAXABLE_FLAG | VARCHAR2 | (1) | ||
| QTY_RCV_EXCEPTION_CODE | VARCHAR2 | (25) | ||
| ALLOW_ITEM_DESC_UPDATE_FLAG | VARCHAR2 | (1) | ||
| INSPECTION_REQUIRED_FLAG | VARCHAR2 | (1) | ||
| RECEIPT_REQUIRED_FLAG | VARCHAR2 | (1) | ||
| MARKET_PRICE | NUMBER | |||
| HAZARD_CLASS_ID | NUMBER | |||
| RFQ_REQUIRED_FLAG | VARCHAR2 | (1) | ||
| QTY_RCV_TOLERANCE | NUMBER | |||
| LIST_PRICE_PER_UNIT | NUMBER | |||
| UN_NUMBER_ID | NUMBER | |||
| PRICE_TOLERANCE_PERCENT | NUMBER | |||
| ASSET_CATEGORY_ID | NUMBER | |||
| ROUNDING_FACTOR | NUMBER | |||
| UNIT_OF_ISSUE | VARCHAR2 | (25) | ||
| ENFORCE_SHIP_TO_LOCATION_CODE | VARCHAR2 | (25) | ||
| ALLOW_SUBSTITUTE_RECEIPTS_FLAG | VARCHAR2 | (1) | ||
| ALLOW_UNORDERED_RECEIPTS_FLAG | VARCHAR2 | (1) | ||
| ALLOW_EXPRESS_DELIVERY_FLAG | VARCHAR2 | (1) | ||
| DAYS_EARLY_RECEIPT_ALLOWED | NUMBER | |||
| DAYS_LATE_RECEIPT_ALLOWED | NUMBER | |||
| RECEIPT_DAYS_EXCEPTION_CODE | VARCHAR2 | (25) | ||
| RECEIVING_ROUTING_ID | NUMBER | |||
| ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| PURCHASING_ITEM_FLAG | VARCHAR2 | (1) | Yes | |
| SHIPPABLE_ITEM_FLAG | VARCHAR2 | (1) | Yes | |
| CUSTOMER_ORDER_FLAG | VARCHAR2 | (1) | Yes | |
| INTERNAL_ORDER_FLAG | VARCHAR2 | (1) | Yes | |
| SERVICE_ITEM_FLAG | VARCHAR2 | (1) | Yes | |
| INVENTORY_ITEM_FLAG | VARCHAR2 | (1) | Yes | |
| ENG_ITEM_FLAG | VARCHAR2 | (1) | Yes | |
| INVENTORY_ASSET_FLAG | VARCHAR2 | (1) | Yes | |
| PURCHASING_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| CUSTOMER_ORDER_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| INTERNAL_ORDER_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| SO_TRANSACTIONS_FLAG | VARCHAR2 | (1) | Yes | |
| MTL_TRANSACTIONS_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| STOCK_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| BOM_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| BUILD_IN_WIP_FLAG | VARCHAR2 | (1) | Yes | |
| REVISION_QTY_CONTROL_CODE | NUMBER | |||
| ITEM_CATALOG_GROUP_ID | NUMBER | |||
| CATALOG_STATUS_FLAG | VARCHAR2 | (1) | ||
| RETURNABLE_FLAG | VARCHAR2 | (1) | ||
| DEFAULT_SHIPPING_ORG | NUMBER | |||
| COLLATERAL_FLAG | VARCHAR2 | (1) | ||
| SALES_ACCOUNT | NUMBER | |||
| DEFAULT_INCLUDE_IN_ROLLUP_FLAG | VARCHAR2 | (1) | ||
| INVENTORY_ITEM_STATUS_CODE | VARCHAR2 | (10) | Yes | |
| INVENTORY_PLANNING_CODE | NUMBER | |||
| PLANNER_CODE | VARCHAR2 | (10) | ||
| PLANNING_MAKE_BUY_CODE | NUMBER | |||
| FIXED_LOT_MULTIPLIER | NUMBER | |||
| ROUNDING_CONTROL_TYPE | NUMBER | |||
| CARRYING_COST | NUMBER | |||
| POSTPROCESSING_LEAD_TIME | NUMBER | |||
| PREPROCESSING_LEAD_TIME | NUMBER | |||
| FULL_LEAD_TIME | NUMBER | |||
| ORDER_COST | NUMBER | |||
| MRP_SAFETY_STOCK_PERCENT | NUMBER | |||
| MRP_SAFETY_STOCK_CODE | NUMBER | |||
| MIN_MINMAX_QUANTITY | NUMBER | |||
| MAX_MINMAX_QUANTITY | NUMBER | |||
| MINIMUM_ORDER_QUANTITY | NUMBER | |||
| FIXED_ORDER_QUANTITY | NUMBER | |||
| FIXED_DAYS_SUPPLY | NUMBER | |||
| MAXIMUM_ORDER_QUANTITY | NUMBER | |||
| ATP_RULE_ID | NUMBER | |||
| PICKING_RULE_ID | NUMBER | |||
| RESERVABLE_TYPE | NUMBER | |||
| POSITIVE_MEASUREMENT_ERROR | NUMBER | |||
| NEGATIVE_MEASUREMENT_ERROR | NUMBER | |||
| ENGINEERING_ECN_CODE | VARCHAR2 | (50) | ||
| ENGINEERING_ITEM_ID | NUMBER | |||
| ENGINEERING_DATE | DATE | |||
| SERVICE_STARTING_DELAY | NUMBER | |||
| OUTSIDE_OPERATION_FLAG | VARCHAR2 | (1) | Yes | |
| OUTSIDE_OPERATION_UOM_TYPE | VARCHAR2 | (25) | ||
| SAFETY_STOCK_BUCKET_DAYS | NUMBER | |||
| AUTO_REDUCE_MPS | NUMBER | (22) | ||
| COSTING_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| AUTO_CREATED_CONFIG_FLAG | VARCHAR2 | (1) | Yes | |
| CYCLE_COUNT_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| ITEM_TYPE | VARCHAR2 | (30) | ||
| MODEL_CONFIG_CLAUSE_NAME | VARCHAR2 | (10) | ||
| SHIP_MODEL_COMPLETE_FLAG | VARCHAR2 | (1) | ||
| MRP_PLANNING_CODE | NUMBER | |||
| RETURN_INSPECTION_REQUIREMENT | NUMBER | |||
| ATO_FORECAST_CONTROL | NUMBER | |||
| RELEASE_TIME_FENCE_CODE | NUMBER | |||
| RELEASE_TIME_FENCE_DAYS | NUMBER | |||
| SUMMARY_FLAG | VARCHAR2 | (1) | Yes | |
| ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| START_DATE_ACTIVE | DATE | |||
| END_DATE_ACTIVE | DATE | |||
| DESCRIPTION | VARCHAR2 | (240) | ||
| BUYER_ID | NUMBER | (9) | ||
| ACCOUNTING_RULE_ID | NUMBER | |||
| INVOICING_RULE_ID | NUMBER | |||
| SEGMENT1 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT2 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT3 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT4 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT5 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT6 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT7 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT8 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT9 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT10 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT11 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT12 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT13 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT14 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT15 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT16 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT17 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT18 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT19 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT20 | VARCHAR2 | (40) | Key flexfield segment | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
| RESTRICT_LOCATORS_CODE | NUMBER | |||
| LOCATION_CONTROL_CODE | NUMBER | |||
| SHRINKAGE_RATE | NUMBER | |||
| ACCEPTABLE_EARLY_DAYS | NUMBER | |||
| PLANNING_TIME_FENCE_CODE | NUMBER | |||
| DEMAND_TIME_FENCE_CODE | NUMBER | |||
| LEAD_TIME_LOT_SIZE | NUMBER | |||
| STD_LOT_SIZE | NUMBER | |||
| CUM_MANUFACTURING_LEAD_TIME | NUMBER | |||
| OVERRUN_PERCENTAGE | NUMBER | |||
| MRP_CALCULATE_ATP_FLAG | VARCHAR2 | (1) | ||
| ACCEPTABLE_RATE_INCREASE | NUMBER | |||
| ACCEPTABLE_RATE_DECREASE | NUMBER | |||
| CUMULATIVE_TOTAL_LEAD_TIME | NUMBER | |||
| PLANNING_TIME_FENCE_DAYS | NUMBER | |||
| DEMAND_TIME_FENCE_DAYS | NUMBER | |||
| END_ASSEMBLY_PEGGING_FLAG | VARCHAR2 | (1) | ||
| REPETITIVE_PLANNING_FLAG | VARCHAR2 | (1) | ||
| PLANNING_EXCEPTION_SET | VARCHAR2 | (10) | ||
| BOM_ITEM_TYPE | NUMBER | Yes | ||
| PICK_COMPONENTS_FLAG | VARCHAR2 | (1) | Yes | |
| REPLENISH_TO_ORDER_FLAG | VARCHAR2 | (1) | Yes | |
| BASE_ITEM_ID | NUMBER | |||
| ATP_COMPONENTS_FLAG | VARCHAR2 | (1) | Yes | |
| ATP_FLAG | VARCHAR2 | (1) | Yes | |
| FIXED_LEAD_TIME | NUMBER | |||
| VARIABLE_LEAD_TIME | NUMBER | |||
| WIP_SUPPLY_LOCATOR_ID | NUMBER | |||
| WIP_SUPPLY_TYPE | NUMBER | |||
| WIP_SUPPLY_SUBINVENTORY | VARCHAR2 | (10) | ||
| PRIMARY_UOM_CODE | VARCHAR2 | (3) | ||
| PRIMARY_UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
| ALLOWED_UNITS_LOOKUP_CODE | NUMBER | |||
| COST_OF_SALES_ACCOUNT | NUMBER | |||
| INVOICE_CLOSE_TOLERANCE | NUMBER | |||
| RECEIVE_CLOSE_TOLERANCE | NUMBER | |||
| AUTO_LOT_ALPHA_PREFIX | VARCHAR2 | (30) | ||
| START_AUTO_LOT_NUMBER | VARCHAR2 | (30) | ||
| LOT_CONTROL_CODE | NUMBER | |||
| SHELF_LIFE_CODE | NUMBER | |||
| SHELF_LIFE_DAYS | NUMBER | |||
| SERIAL_NUMBER_CONTROL_CODE | NUMBER | |||
| START_AUTO_SERIAL_NUMBER | VARCHAR2 | (30) | ||
| AUTO_SERIAL_ALPHA_PREFIX | VARCHAR2 | (30) | ||
| SOURCE_TYPE | NUMBER | |||
| SOURCE_ORGANIZATION_ID | NUMBER | |||
| SOURCE_SUBINVENTORY | VARCHAR2 | (10) | ||
| EXPENSE_ACCOUNT | NUMBER | |||
| ENCUMBRANCE_ACCOUNT | NUMBER | |||
| RESTRICT_SUBINVENTORIES_CODE | NUMBER | |||
| UNIT_WEIGHT | NUMBER | |||
| WEIGHT_UOM_CODE | VARCHAR2 | (3) | ||
| VOLUME_UOM_CODE | VARCHAR2 | (3) | ||
| UNIT_VOLUME | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, ORGANIZATION_ID
, CATEGORY_SET_ID
, CATEGORY_ID
, 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
, 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
, 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
, 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
, 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
, 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
, 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
, 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
FROM APPS.CN_MTL_SYSTEM_ITEM_CATS_V;
APPS
MTL_DEFAULT_CATEGORY_SETS
MTL_ITEM_CATEGORIES
MTL_SYSTEM_ITEMS
OE_PROFILE
- show dependent code
APPS.CN_MTL_SYSTEM_ITEM_CATS_V is not referenced by any database object
|
|
|
|