[Home] [Help] [Dependency Information]

VIEW: APPS.BOM_EXPLOSIONS_V

Object Details

Object Name:	BOM_EXPLOSIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BOM.BOM_EXPLOSIONS_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 TOP_BILL_SEQUENCE_ID
,      BILL_SEQUENCE_ID
,      ORGANIZATION_ID
,      EXPLOSION_TYPE
,      COMPONENT_SEQUENCE_ID
,      COMPONENT_ITEM_ID
,      PLAN_LEVEL
,      EXTENDED_QUANTITY
,      SORT_ORDER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      TOP_ITEM_ID
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      BASIS_TYPE
,      COMPONENT_QUANTITY
,      SO_BASIS
,      OPTIONAL
,      MUTUALLY_EXCLUSIVE_OPTIONS
,      CHECK_ATP
,      SHIPPING_ALLOWED
,      REQUIRED_TO_SHIP
,      REQUIRED_FOR_REVENUE
,      INCLUDE_ON_SHIP_DOCS
,      INCLUDE_ON_BILL_DOCS
,      LOW_QUANTITY
,      HIGH_QUANTITY
,      PICK_COMPONENTS
,      PRIMARY_UOM_CODE
,      PRIMARY_UNIT_OF_MEASURE
,      BASE_ITEM_ID
,      ATP_COMPONENTS_FLAG
,      ATP_FLAG
,      BOM_ITEM_TYPE
,      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
,      DESCRIPTION
,      ASSEMBLY_ITEM_ID
,      COMPONENT_CODE
,      LOOP_FLAG
,      PARENT_BOM_ITEM_TYPE
,      OPERATION_SEQ_NUM
,      ITEM_NUM
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      IMPLEMENTATION_DATE
,      REXPLODE_FLAG
,      COMMON_BILL_SEQUENCE_ID
,      COMP_BILL_SEQ_ID
,      COMP_COMMON_BILL_SEQ_ID
,      EXPLODE_GROUP_ID
,      NUM_COL1
,      NUM_COL2
,      NUM_COL3
,      DATE_COL1
,      DATE_COL2
,      DATE_COL3
,      CHAR_COL1
,      CHAR_COL2
,      CHAR_COL3
,      AUTO_REQUEST_MATERIAL
,      ITEM_NAME
,      ITEM_STATUS
,      IMAGE_SOURCE
,      ALTERNATE_BOM_DESIGNATOR
,      CURRENT_ITEM_REVISION
,      REVISION_LABEL
,      INCLUDE_IN_COST_ROLLUP
,      COMPONENT_YIELD_FACTOR
,      PLANNING_FACTOR
,      CHANGE_NOTICE
,      STRUCTURE_TYPE
,      USER_ITEM_TYPE
,      CHANGE_ID
,      CATALOG_CATEGORY
,      ENG_ITEM_FLAG
,      PARENT_SORT_ORDER
,      LONG_DESCRIPTION
,      REVISION_CODE
,      STRUCTURE_TYPE_ID
,      SUGGESTED_VENDOR_NAME
,      VENDOR_ID
,      UNIT_PRICE
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      OBJ_NAME
,      HGRID_FLAG
,      CATALOG_CATEGORY_ID
,      REVISION_ID
,      FROM_MINOR_REVISION_ID
,      TO_MINOR_REVISION_ID
,      FROM_MINOR_REVISION_LABEL
,      TO_MINOR_REVISION_LABEL
,      FROM_END_ITEM_REV_ID
,      TO_END_ITEM_REV_ID
,      FROM_END_ITEM_REVISION_LABEL
,      TO_END_ITEM_REVISION_LABEL
,      FROM_END_ITEM_MINOR_REV_ID
,      TO_END_ITEM_MINOR_REV_ID
,      FROM_END_ITEM_MINOR_REV_LABEL
,      TO_END_ITEM_MINOR_REV_LABEL
,      OBJECT_VERSION
,      MAPPED_ITEM_NAME
,      MAPPED_ITEM_REVISION
,      MAP_STATUS
,      FROM_END_ITEM
,      TO_END_ITEM
,      EFFECTIVITY_CONTROL
,      ACCESS_FLAG
,      TEMPLATE_NAME
,      BOM_IMPLEMENTATION_DATE
,      MINOR_REVISION
,      ASSEMBLY_TYPE
,      GTIN_NUMBER
,      GTIN_DESCRIPTION
,      TRADE_ITEM_DESCRIPTOR
,      TOP_GTIN_NUMBER
,      TOP_GTIN_DESCRIPTION
,      TOP_TRADE_ITEM_DESCRIPTOR
,      PARENT_GTIN_NUMBER
,      PARENT_GTIN_DESCRIPTION
,      PARENT_TRADE_ITEM_DESCRIPTOR
,      QUANTITY_OF_CHILDREN
,      TOTAL_QTY_AT_NEXT_LEVEL
,      IS_PREFERRED
,      TRADE_ITEM_DESCRIPTOR_DESC
,      GTIN_PUBLICATION_STATUS
,      ATTACHMENT_NAME
,      ACD_TYPE
,      QUANTITY_RELATED
,      SUPPLY_SUBINVENTORY
,      FROM_END_ITEM_UNIT_NUMBER
,      TO_END_ITEM_UNIT_NUMBER
,      STRUCTURE_DISPLAY_NAME
,      CHANGE_POLICY_VALUE
,      COMPONENT_REMARKS
,      IS_EXCLUDED_BY_RULE
,      WIP_SUPPLY_TYPE
,      LOCATOR
,      GROUP_ID
,      PARENT_IMPLEMENTATION_DATE
,      PARENT_CHANGE_NOTICE
,      COMP_FIXED_REV_CODE
,      SOURCE_BILL_SEQUENCE_ID
,      COMMON_COMPONENT_SEQUENCE_ID
,      COMP_SOURCE_BILL_SEQ_ID
,      INVERSE_QUANTITY
,      COMP_EFFECTIVITY_CONTROL
,      REVISED_ITEM_SEQUENCE_ID
,      FROM_END_ITEM_REVISION_CODE
,      TO_END_ITEM_REVISION_CODE
,      ENFORCE_INT_REQUIREMENTS
,      PARENT_REVISION_CODE
,      PARENT_REVISION_LABEL
,      PARENT_REVISION_ID
,      COMMON_ITEM_NAME
,      COMMON_ORGANIZATION_NAME
,      STRUCTURE_DESC
,      STYLE_ITEM_ID
,      STYLE_ITEM_FLAG
,      INHERIT_FLAG
FROM APPS.BOM_EXPLOSIONS_V;

Dependencies

[top of page]

APPS

BOM_ALTERNATE_DESIGNATORS_TL

BOM_COMPONENTS_B

BOM_EXPLODER_PUB - show dependent code

BOM_EXPLOSIONS_ALL

BOM_GLOBALS - show dependent code

BOM_ITEM_ATTACH_CATEGORY_ASSOC

BOM_STRUCTURES_B

BOM_STRUCTURE_TYPES_B

EGO_MINOR_REVISIONS

ENG_ENGINEERING_CHANGES

FND_ATTACHED_DOCUMENTS

FND_DOCUMENTS

FND_DOCUMENTS_TL

FND_DOCUMENT_CATEGORIES_VL

FND_FLEX_SERVER - show dependent code

FND_GLOBAL - show dependent code

FND_LOOKUPS

HR_ALL_ORGANIZATION_UNITS_TL

MTL_ITEM_CATALOG_GROUPS

MTL_ITEM_REVISIONS

MTL_ITEM_REVISIONS_B

MTL_SYSTEM_ITEMS_B

MTL_SYSTEM_ITEMS_KFV

MTL_SYSTEM_ITEMS_TL

MTL_UNITS_OF_MEASURE

PUBLIC

DUAL

APPS

BOM_UTIL - show dependent code

EGO_ITEM_ASSOCIATIONS_PUB - show dependent code

INV_EBI_CHANGE_ORDER_HELPER - show dependent code