[Home] [Help] [Dependency Information]

VIEW: APPS.CST_XLA_INV_SYSTEM_ITEMS_REF_V

Object Details

Object Name:	CST_XLA_INV_SYSTEM_ITEMS_REF_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BOM.CST_XLA_INV_SYSTEM_ITEMS_REF_V
Subobject Name:
Status:	VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      ITEM_CONCATENATED_SEGMENTS
,      ITEM_DESCRIPTION
,      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_ITEM_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
,      BASED_ON_ROLLUP_FLAG
,      SHRINKAGE_RATE
,      INV_ITEM_EXPENSE_ACCT
FROM APPS.CST_XLA_INV_SYSTEM_ITEMS_REF_V;

Dependencies

[top of page]

APPS

CST_ITEM_COSTS

MTL_PARAMETERS

MTL_SYSTEM_ITEMS

MTL_SYSTEM_ITEMS_KFV

APPS

XLA_00707_AAD_S_000019_PKG - show dependent code

XLA_00707_AAD_S_000020_BC_PKG - show dependent code

XLA_00707_AAD_S_000020_PKG - show dependent code