[Home] [Help] [Dependency Information]

VIEW: APPS.BOM_ODI_WS_COMPONENTS_V

Object Details

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

[View Source]

Columns

Query Text

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

SELECT SESSION_ID
,      ASSEMBLY_ITEM_ID
,      ORGANIZATION_ID
,      COMMON_BILL_SEQUENCE_ID
,      COMMON_COMPONENT_SEQUENCE_ID
,      COMPONENT_SEQUENCE_ID
,      OPERATION_SEQ_NUM
,      COMPONENT_ITEM_ID
,      NEW_COMPONENT_CODE
,      COMPONENT_CODE
,      COMPONENT_ITEM_NAME
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      DESCRIPTION
,      LANGUAGE
,      ITEM_SEQUENCE_NUMBER
,      PRIMARY_UOM_CODE
,      PRIMARY_UNIT_OF_MEASURE
,      BASIS_TYPE
,      COMPONENT_QUANTITY
,      AUTO_REQUEST_MATERIAL
,      CURRENT_FUTURE_PAST_FLAG
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      IMPLEMENTATION_DATE
,      CHANGE_NOTICE
,      PLANNING_FACTOR
,      COMPONENT_YIELD_FACTOR
,      ENFORCE_INT_REQUIREMENTS
,      INCLUDE_IN_COST_ROLLUP
,      BOM_ITEM_TYPE
,      WIP_SUPPLY_TYPE
,      SUPPLY_SUBINVENTORY
,      SUPPLY_LOCATOR_ID
,      CHECK_ATP
,      OPTIONAL
,      MUTUALLY_EXCLUSIVE_OPTIONS
,      LOW_QUANTITY
,      HIGH_QUANTITY
,      SO_BASIS
,      SHIPPING_ALLOWED
,      INCLUDE_ON_SHIP_DOCS
,      REQUIRED_TO_SHIP
,      REQUIRED_FOR_REVENUE
,      TOP_ITEM_ID
,      TOP_BILL_SEQUENCE_ID
,      PARENT_BOM_ITEM_TYPE
,      EXPLOSION_TYPE
,      PLAN_LEVEL
,      EXTENDED_QUANTITY
,      SORT_ORDER
,      COMP_BILL_SEQ_ID
,      COMP_COMMON_BILL_SEQ_ID
,      PARENT_SORT_ORDER
,      COMP_SOURCE_BILL_SEQ_ID
,      SOURCE_BILL_SEQUENCE_ID
,      ECO_FOR_PRODUCTION
,      OPTIONAL_ON_MODEL
,      INCLUDE_ON_BILL_DOCS
,      BASE_ITEM_ID
,      ATP_COMPONENTS_FLAG
,      ATP_FLAG
,      PICK_COMPONENTS_FLAG
,      REPLENISH_TO_ORDER_FLAG
,      SHIPPABLE_ITEM_FLAG
,      CUSTOMER_ORDER_FLAG
,      INTERNAL_ORDER_FLAG
,      CUSTOMER_ORDER_ENABLED_FLAG
,      INTERNAL_ORDER_ENABLED_FLAG
,      SO_TRANSACTIONS_FLAG
,      LOOP_FLAG
,      ITEM_NUM
,      REXPLODE_FLAG
,      SUGGESTED_VENDOR_NAME
,      VENDOR_ID
,      UNIT_PRICE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      QUANTITY_RELATED
,      FROM_END_ITEM_REV_ID
,      TO_END_ITEM_REV_ID
,      GROUP_ID
,      REVISION_ID
,      REVISION
FROM APPS.BOM_ODI_WS_COMPONENTS_V;

Dependencies

[top of page]

APPS

BOM_EXPLOSIONS_ALL

BOM_INVENTORY_COMPONENTS

BOM_ODI_WS_ENTITIES

BOM_ODI_WS_REVISIONS

MTL_ITEM_REVISIONS_B

MTL_SYSTEM_ITEMS_KFV

MTL_SYSTEM_ITEMS_TL

APPS.BOM_ODI_WS_COMPONENTS_V is not referenced by any database object