[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GMF_XLA_ITEMS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  GMF.GMF_XLA_ITEMS_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View for SLA ADR sources from Item Definition
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item identifier | |
| ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
| ITEM_CONCATENATED_SEGMENTS | VARCHAR2 | (0) | Item Number concatenated segment value | |
| PURCHASING_ITEM_FLAG | VARCHAR2 | (1) | Yes | Flag indicating purchasing item |
| SHIPPABLE_ITEM_FLAG | VARCHAR2 | (1) | Yes | Flag indicating shippable item |
| CUSTOMER_ORDER_FLAG | VARCHAR2 | (1) | Yes | Flag indicating customer orderable item |
| INTERNAL_ORDER_FLAG | VARCHAR2 | (1) | Yes | Flag indicating internally orderable item |
| SERVICE_ITEM_FLAG | VARCHAR2 | (1) | Yes | Flag indicating service item |
| INVENTORY_ITEM_FLAG | VARCHAR2 | (1) | Yes | Flag indicating inventory item |
| ENG_ITEM_FLAG | VARCHAR2 | (1) | Yes | Flag indicating engineering item |
| INVENTORY_ASSET_FLAG | VARCHAR2 | (1) | Yes | Flag indicating item is an inventory asset |
| PURCHASING_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Flag indicating item is purchasable |
| CUSTOMER_ORDER_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Flag indicating item is customer orderable |
| INTERNAL_ORDER_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Flag indicating item is internally orderable |
| SO_TRANSACTIONS_FLAG | VARCHAR2 | (1) | Yes | Sales order transactions flag |
| MTL_TRANSACTIONS_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Flag indicating item is transactable |
| STOCK_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Flag indicating item is stockable |
| BOM_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Flag indicating item may appear on a BOM |
| BUILD_IN_WIP_FLAG | VARCHAR2 | (1) | Yes | Flag indicating item may be built in WIP |
| CATALOG_STATUS_FLAG | VARCHAR2 | (1) | Flag indicating item catalog complete | |
| RETURNABLE_FLAG | VARCHAR2 | (1) | Flag indicating whether item is returnable | |
| COLLATERAL_FLAG | VARCHAR2 | (1) | Flag indicating item is collateral item | |
| TAXABLE_FLAG | VARCHAR2 | (1) | Flag indicating whether item is taxable | |
| INSPECTION_REQUIRED_FLAG | VARCHAR2 | (1) | Flag indicating whether inspection is required upon receipt | |
| RECEIPT_REQUIRED_FLAG | VARCHAR2 | (1) | Flag indicating supplier receipt is required before payment | |
| RFQ_REQUIRED_FLAG | VARCHAR2 | (1) | Flag indicating whether an RFQ (request for quotation) is required | |
| ALLOW_SUBSTITUTE_RECEIPTS_FLAG | VARCHAR2 | (1) | Flag indicating substitute receipts allowed | |
| ALLOW_UNORDERED_RECEIPTS_FLAG | VARCHAR2 | (1) | Flag indicating unordered receipts allowed | |
| ALLOW_EXPRESS_DELIVERY_FLAG | VARCHAR2 | (1) | Flag indicating express delivery allowed | |
| SOURCE_TYPE | NUMBER | Inventory or supplier source type | ||
| SOURCE_ORGANIZATION_ID | NUMBER | Organization to source items from | ||
| SOURCE_SUBINVENTORY | VARCHAR2 | (10) | Subinventory to source items from | |
| MRP_CALCULATE_ATP_FLAG | VARCHAR2 | (1) | Calculate ATP flag (y/n) for MRP planning routine | |
| REPETITIVE_PLANNING_FLAG | VARCHAR2 | (1) | Flag indicating item to be planned as repetitive schedule | |
| BOM_ITEM_TYPE | NUMBER | Yes | Type of item | |
| PICK_COMPONENTS_FLAG | VARCHAR2 | (1) | Yes | Flag indicating whether all shippable components should be picked |
| ATP_COMPONENTS_FLAG | VARCHAR2 | (1) | Yes | Flag indicating whether item may have components requiring ATP check |
| ATP_FLAG | VARCHAR2 | (1) | Yes | Flag indicating ATP must be checked when item is ordered |
| WIP_SUPPLY_TYPE | NUMBER | Source of WIP material supply | ||
| WIP_SUPPLY_SUBINVENTORY | VARCHAR2 | (10) | Supply subinventory for WIP transactions | |
| PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary unit of measure code | |
| DEFAULT_INCLUDE_IN_ROLLUP_FLAG | VARCHAR2 | (1) | Default value for include in cost rollup | |
| INVENTORY_PLANNING_CODE | NUMBER | Inventory planning code | ||
| PLANNING_MAKE_BUY_CODE | NUMBER | Indicates whether item is planned as manufactured or purchased | ||
| RESERVABLE_TYPE | VARCHAR2 | (1) | Hard reservations allowed flag | |
| VENDOR_WARRANTY_FLAG | VARCHAR2 | (1) | Yes | Flag indicating service for the item is provided by a supplier |
| SERVICEABLE_COMPONENT_FLAG | VARCHAR2 | (1) | Indicates whether the item is serviceable by other service-type items and whether it can be referenced as the component of another item | |
| SERVICEABLE_PRODUCT_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the item is serviceable by other service-type items and can have service requests reported against it |
| PREVENTIVE_MAINTENANCE_FLAG | VARCHAR2 | (1) | Flag indicating whether item can be a preventive maintenance service item | |
| TIME_BILLABLE_FLAG | VARCHAR2 | (1) | Flag indicating service labor hours are billable | |
| MATERIAL_BILLABLE_FLAG | VARCHAR2 | (30) | Flag indicating service material is billable | |
| EXPENSE_BILLABLE_FLAG | VARCHAR2 | (1) | Flag indicating service expenses are billable | |
| PRORATE_SERVICE_FLAG | VARCHAR2 | (1) | Flag indicating cost of service may be prorated | |
| INVOICEABLE_ITEM_FLAG | VARCHAR2 | (1) | Yes | Flag indicating item may appear on invoices |
| INVOICE_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the item can be invoiced |
| OUTSIDE_OPERATION_FLAG | VARCHAR2 | (1) | Yes | Flag indicating item may appear on outside operation purchase order |
| COSTING_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Flag indicating cost information is maintained |
| AUTO_CREATED_CONFIG_FLAG | VARCHAR2 | (1) | Yes | Flag indicating configuration item automatically created |
| CYCLE_COUNT_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Flag indicating item may be cycle counted |
| ITEM_TYPE | VARCHAR2 | (30) | User-defined item type | |
| SHIP_MODEL_COMPLETE_FLAG | VARCHAR2 | (1) | Flag indicating model must be complete to ship | |
| MRP_PLANNING_CODE | NUMBER | MRP Planning option | ||
| RETURN_INSPECTION_REQUIREMENT | VARCHAR2 | (1) | RMA inspection requirement | |
| ATO_FORECAST_CONTROL | NUMBER | Type of forecast control for ATO | ||
| CONTAINER_ITEM_FLAG | VARCHAR2 | (1) | Flag indicating if the item is a container. Used for shipping sales orders | |
| VEHICLE_ITEM_FLAG | VARCHAR2 | (1) | Indicates if the item is a vehicle or not. Used for shipping sales orders | |
| CONTAINER_TYPE_CODE | VARCHAR2 | (30) | Container type code for container items. Container types are user defineable | |
| ITEM_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| ITEM_ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE16 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE17 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE18 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE19 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE20 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE21 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE22 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE23 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE24 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE25 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE26 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE27 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE28 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE29 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_ATTRIBUTE30 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ITEM_SEGMENT1 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT2 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT3 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT4 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT5 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT6 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT7 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT8 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT9 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT10 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT11 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT12 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT13 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT14 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT15 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT16 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT17 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT18 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT19 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT20 | VARCHAR2 | (40) | Key flexfield segment | |
| EQUIPMENT_TYPE | VARCHAR2 | (1) | Flag indicating item is equipment | |
| DEFECT_TRACKING_ON_FLAG | VARCHAR2 | (1) | Specifies whether a defect or bug can be filed against the product | |
| USAGE_ITEM_FLAG | VARCHAR2 | (1) | Flag indicating an item represents usage. Usage items can be sold as a use of something | |
| EVENT_FLAG | VARCHAR2 | (1) | Identifies item as an event | |
| ELECTRONIC_FLAG | VARCHAR2 | (1) | Flag indicating an item exists only in electronic format and not physical | |
| DOWNLOADABLE_FLAG | VARCHAR2 | (1) | Flag indicating an item is downloadable | |
| VOL_DISCOUNT_EXEMPT_FLAG | VARCHAR2 | (1) | Indicates an item does not contribute to volume discount for any order | |
| COUPON_EXEMPT_FLAG | VARCHAR2 | (1) | Indicates an item is excluded from coupons even if it is part of the group that any coupon applies | |
| COMMS_NL_TRACKABLE_FLAG | VARCHAR2 | (1) | Identifies an item as network logistics trackable | |
| ASSET_CREATION_CODE | VARCHAR2 | (30) | Used to specify when an asset should be created | |
| ORDERABLE_ON_WEB_FLAG | VARCHAR2 | (1) | Indicates whether an item is orderable on the web or not. iStore will only sell items with this flag to be true | |
| BACK_ORDERABLE_FLAG | VARCHAR2 | (1) | If ATP failed, can item be back ordered | |
| INDIVISIBLE_FLAG | VARCHAR2 | (1) | Item unit is indivisible | |
| LOT_STATUS_ENABLED | VARCHAR2 | (1) | Lot status enabled | |
| SERIAL_STATUS_ENABLED | VARCHAR2 | (1) | Serial status enabled | |
| LOT_SPLIT_ENABLED | VARCHAR2 | (1) | Lot split enabled | |
| LOT_MERGE_ENABLED | VARCHAR2 | (1) | Lot merge enabled | |
| FINANCING_ALLOWED_FLAG | VARCHAR2 | (1) | Item is eligible for financing | |
| EAM_ITEM_TYPE | NUMBER | Asset item type | ||
| EAM_ACTIVITY_TYPE_CODE | VARCHAR2 | (30) | Asset activity type | |
| EAM_ACTIVITY_CAUSE_CODE | VARCHAR2 | (30) | Asset activity cause | |
| EAM_ACT_NOTIFICATION_FLAG | VARCHAR2 | (1) | Asset activity notification required | |
| CONTRACT_ITEM_TYPE_CODE | VARCHAR2 | (30) | Contract Item type | |
| SUBSCRIPTION_DEPEND_FLAG | VARCHAR2 | (1) | Subscription dependency enabled | |
| SERV_REQ_ENABLED_CODE | VARCHAR2 | (30) | Service Request Enabled | |
| SERV_BILLING_ENABLED_FLAG | VARCHAR2 | (1) | Service Billing Enabled | |
| LOT_TRANSLATE_ENABLED | VARCHAR2 | (1) | Lot Translate Enabled | |
| IB_ITEM_INSTANCE_CLASS | VARCHAR2 | (30) | Installed Base Item Instance Classification | |
| CONFIG_MODEL_TYPE | VARCHAR2 | (30) | Configurator Model Type | |
| LOT_SUBSTITUTION_ENABLED | VARCHAR2 | (1) | Lot Substitution Enabled for 11.5.9 | |
| EAM_ACTIVITY_SOURCE_CODE | VARCHAR2 | (30) | Activity Source for 11.5.9 | |
| CONSIGNED_FLAG | VARCHAR2 | (1) | Consigned flag: 1 - consigned, 2 - unconsigned (default) | |
| VMI_FORECAST_TYPE | NUMBER | Forecast type for average daily demand calculation: 1 - order forecast (default), 2 - sales forecast, 3 - historical sales | ||
| EXCLUDE_FROM_BUDGET_FLAG | VARCHAR2 | (1) | 1- Yes2- No (Default) | |
| CHILD_LOT_FLAG | VARCHAR2 | (1) | Whether a child lot can be created for items | |
| 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. | |
| PROCESS_COSTING_ENABLED_FLAG | VARCHAR2 | (1) | Flag indicating cost information may be maintained in OPM (Oracle Process Manufacturing) | |
| PROCESS_EXECUTION_ENABLED_FLAG | VARCHAR2 | (1) | Flag indicating item may be used in OPM (Oracle Process Manufacturing) Process Excecution | |
| PROCESS_QUALITY_ENABLED_FLAG | VARCHAR2 | (1) | Flag indicating item may be used in OPM (Oracle Process Manufacturing) Process Quality | |
| RECIPE_ENABLED_FLAG | VARCHAR2 | (1) | Flag indicating item may appear on a Recipe in OPM (Oracle Process Manufacturing) Process |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, ORGANIZATION_ID
, ITEM_CONCATENATED_SEGMENTS
, 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
, CATALOG_STATUS_FLAG
, RETURNABLE_FLAG
, COLLATERAL_FLAG
, TAXABLE_FLAG
, INSPECTION_REQUIRED_FLAG
, RECEIPT_REQUIRED_FLAG
, RFQ_REQUIRED_FLAG
, ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, ALLOW_UNORDERED_RECEIPTS_FLAG
, ALLOW_EXPRESS_DELIVERY_FLAG
, SOURCE_TYPE
, SOURCE_ORGANIZATION_ID
, SOURCE_SUBINVENTORY
, MRP_CALCULATE_ATP_FLAG
, REPETITIVE_PLANNING_FLAG
, BOM_ITEM_TYPE
, PICK_COMPONENTS_FLAG
, ATP_COMPONENTS_FLAG
, ATP_FLAG
, WIP_SUPPLY_TYPE
, WIP_SUPPLY_SUBINVENTORY
, PRIMARY_UOM_CODE
, DEFAULT_INCLUDE_IN_ROLLUP_FLAG
, INVENTORY_PLANNING_CODE
, PLANNING_MAKE_BUY_CODE
, RESERVABLE_TYPE
, VENDOR_WARRANTY_FLAG
, SERVICEABLE_COMPONENT_FLAG
, SERVICEABLE_PRODUCT_FLAG
, PREVENTIVE_MAINTENANCE_FLAG
, TIME_BILLABLE_FLAG
, MATERIAL_BILLABLE_FLAG
, EXPENSE_BILLABLE_FLAG
, PRORATE_SERVICE_FLAG
, INVOICEABLE_ITEM_FLAG
, INVOICE_ENABLED_FLAG
, OUTSIDE_OPERATION_FLAG
, COSTING_ENABLED_FLAG
, AUTO_CREATED_CONFIG_FLAG
, CYCLE_COUNT_ENABLED_FLAG
, ITEM_TYPE
, SHIP_MODEL_COMPLETE_FLAG
, MRP_PLANNING_CODE
, RETURN_INSPECTION_REQUIREMENT
, ATO_FORECAST_CONTROL
, CONTAINER_ITEM_FLAG
, VEHICLE_ITEM_FLAG
, CONTAINER_TYPE_CODE
, ITEM_ATTRIBUTE_CATEGORY
, ITEM_ATTRIBUTE1
, ITEM_ATTRIBUTE2
, ITEM_ATTRIBUTE3
, ITEM_ATTRIBUTE4
, ITEM_ATTRIBUTE5
, ITEM_ATTRIBUTE6
, ITEM_ATTRIBUTE7
, ITEM_ATTRIBUTE8
, ITEM_ATTRIBUTE9
, ITEM_ATTRIBUTE10
, ITEM_ATTRIBUTE11
, ITEM_ATTRIBUTE12
, ITEM_ATTRIBUTE13
, ITEM_ATTRIBUTE14
, ITEM_ATTRIBUTE15
, ITEM_ATTRIBUTE16
, ITEM_ATTRIBUTE17
, ITEM_ATTRIBUTE18
, ITEM_ATTRIBUTE19
, ITEM_ATTRIBUTE20
, ITEM_ATTRIBUTE21
, ITEM_ATTRIBUTE22
, ITEM_ATTRIBUTE23
, ITEM_ATTRIBUTE24
, ITEM_ATTRIBUTE25
, ITEM_ATTRIBUTE26
, ITEM_ATTRIBUTE27
, ITEM_ATTRIBUTE28
, ITEM_ATTRIBUTE29
, ITEM_ATTRIBUTE30
, ITEM_SEGMENT1
, ITEM_SEGMENT2
, ITEM_SEGMENT3
, ITEM_SEGMENT4
, ITEM_SEGMENT5
, ITEM_SEGMENT6
, ITEM_SEGMENT7
, ITEM_SEGMENT8
, ITEM_SEGMENT9
, ITEM_SEGMENT10
, ITEM_SEGMENT11
, ITEM_SEGMENT12
, ITEM_SEGMENT13
, ITEM_SEGMENT14
, ITEM_SEGMENT15
, ITEM_SEGMENT16
, ITEM_SEGMENT17
, ITEM_SEGMENT18
, ITEM_SEGMENT19
, ITEM_SEGMENT20
, EQUIPMENT_TYPE
, 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
, ORDERABLE_ON_WEB_FLAG
, BACK_ORDERABLE_FLAG
, INDIVISIBLE_FLAG
, LOT_STATUS_ENABLED
, SERIAL_STATUS_ENABLED
, LOT_SPLIT_ENABLED
, LOT_MERGE_ENABLED
, FINANCING_ALLOWED_FLAG
, EAM_ITEM_TYPE
, EAM_ACTIVITY_TYPE_CODE
, EAM_ACTIVITY_CAUSE_CODE
, EAM_ACT_NOTIFICATION_FLAG
, CONTRACT_ITEM_TYPE_CODE
, SUBSCRIPTION_DEPEND_FLAG
, SERV_REQ_ENABLED_CODE
, SERV_BILLING_ENABLED_FLAG
, LOT_TRANSLATE_ENABLED
, IB_ITEM_INSTANCE_CLASS
, CONFIG_MODEL_TYPE
, LOT_SUBSTITUTION_ENABLED
, EAM_ACTIVITY_SOURCE_CODE
, CONSIGNED_FLAG
, VMI_FORECAST_TYPE
, EXCLUDE_FROM_BUDGET_FLAG
, CHILD_LOT_FLAG
, COPY_LOT_ATTRIBUTE_FLAG
, PROCESS_COSTING_ENABLED_FLAG
, PROCESS_EXECUTION_ENABLED_FLAG
, PROCESS_QUALITY_ENABLED_FLAG
, RECIPE_ENABLED_FLAG
FROM APPS.GMF_XLA_ITEMS_V;
APPS
MTL_PARAMETERS
MTL_SYSTEM_ITEMS_B
APPS.GMF_XLA_ITEMS_V is not referenced by any database object
|
|
|
|