[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | BOM_EXPLOSIONS_ALL_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  BOM.BOM_EXPLOSIONS_ALL_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TOP_BILL_SEQUENCE_ID | NUMBER | Yes | Top Bill Sequence Id of Explosion | |
| BILL_SEQUENCE_ID | NUMBER | Yes | Bill Sequence Id of the Item | |
| ORGANIZATION_ID | NUMBER | Yes | Organization Id of the Item | |
| EXPLOSION_TYPE | VARCHAR2 | (20) | Explosion Type | |
| COMPONENT_SEQUENCE_ID | NUMBER | Coponent Sequence ID | ||
| COMPONENT_ITEM_ID | NUMBER | Component Item Id | ||
| PLAN_LEVEL | NUMBER | Yes | Hierarchy Level for Explosion | |
| EXTENDED_QUANTITY | NUMBER | Components Extended Quantity | ||
| SORT_ORDER | VARCHAR2 | (2000) | Yes | Sort Order for the Hierarchy |
| CREATION_DATE | DATE | Standard Who Column | ||
| CREATED_BY | NUMBER | Standard Who Column | ||
| LAST_UPDATE_DATE | DATE | Standard Who Column | ||
| LAST_UPDATED_BY | NUMBER | Standard Who Column | ||
| TOP_ITEM_ID | NUMBER | Exploded Top Item Id | ||
| CONTEXT | VARCHAR2 | (30) | CONTEXT | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| COMPONENT_QUANTITY | NUMBER | Quantity of Component in Assembly | ||
| BASIS_TYPE | NUMBER | |||
| SO_BASIS | NUMBER | SO BASIS | ||
| OPTIONAL | NUMBER | Optional Item Flag | ||
| MUTUALLY_EXCLUSIVE_OPTIONS | NUMBER | MUTUALLY_EXCLUSIVE_OPTIONS | ||
| CHECK_ATP | NUMBER | CHECK ATP FLAG | ||
| SHIPPING_ALLOWED | NUMBER | Shipping Allowed Flag | ||
| REQUIRED_TO_SHIP | NUMBER | REQUIRED TO SHIP Flag | ||
| REQUIRED_FOR_REVENUE | NUMBER | REQUIRED_FOR_REVENUE | ||
| INCLUDE_ON_SHIP_DOCS | NUMBER | INCLUDE_ON_SHIP_DOCS | ||
| INCLUDE_ON_BILL_DOCS | NUMBER | INCLUDE_ON_BILL_DOCS | ||
| LOW_QUANTITY | NUMBER | LOW QUANTITY | ||
| HIGH_QUANTITY | NUMBER | HIGH_QUANTITY | ||
| PICK_COMPONENTS | NUMBER | PICK_COMPONENTS | ||
| PRIMARY_UOM_CODE | VARCHAR2 | (3) | Unit of Measure Code | |
| PRIMARY_UNIT_OF_MEASURE | VARCHAR2 | (25) | Primary Unit of Measure | |
| BASE_ITEM_ID | NUMBER | BASE_ITEM_ID | ||
| ATP_COMPONENTS_FLAG | VARCHAR2 | (1) | ATP_COMPONENTS_FLAG | |
| ATP_FLAG | VARCHAR2 | (1) | ATP_FLAG | |
| BOM_ITEM_TYPE | NUMBER | BOM_ITEM_TYPE | ||
| PICK_COMPONENTS_FLAG | VARCHAR2 | (1) | PICK_COMPONENTS_FLAG | |
| REPLENISH_TO_ORDER_FLAG | VARCHAR2 | (1) | REPLENISH_TO_ORDER_FLAG | |
| SHIPPABLE_ITEM_FLAG | VARCHAR2 | (1) | SHIPPABLE_ITEM_FLAG | |
| CUSTOMER_ORDER_FLAG | VARCHAR2 | (1) | CUSTOMER_ORDER_FLAG | |
| INTERNAL_ORDER_FLAG | VARCHAR2 | (1) | INTERNAL_ORDER_FLAG | |
| CUSTOMER_ORDER_ENABLED_FLAG | VARCHAR2 | (1) | CUSTOMER_ORDER_ENABLED_FLAG | |
| INTERNAL_ORDER_ENABLED_FLAG | VARCHAR2 | (1) | INTERNAL_ORDER_ENABLED_FLAG | |
| SO_TRANSACTIONS_FLAG | VARCHAR2 | (1) | SO_TRANSACTIONS_FLAG | |
| DESCRIPTION | VARCHAR2 | (255) | DESCRIPTION | |
| ASSEMBLY_ITEM_ID | NUMBER | ASSEMBLY_ITEM_ID | ||
| COMPONENT_CODE | VARCHAR2 | (4000) | COMPONENT_CODE | |
| LOOP_FLAG | NUMBER | LOOP_FLAG | ||
| PARENT_BOM_ITEM_TYPE | NUMBER | PARENT_BOM_ITEM_TYPE | ||
| OPERATION_SEQ_NUM | NUMBER | OPERATION_SEQ_NUM | ||
| ITEM_NUM | NUMBER | ITEM_NUM | ||
| EFFECTIVITY_DATE | DATE | EFFECTIVITY_DATE | ||
| DISABLE_DATE | DATE | DISABLE_DATE | ||
| IMPLEMENTATION_DATE | DATE | IMPLEMENTATION_DATE | ||
| REXPLODE_FLAG | NUMBER | REXPLODE_FLAG | ||
| COMMON_BILL_SEQUENCE_ID | NUMBER | COMMON_BILL_SEQUENCE_ID | ||
| COMP_BILL_SEQ_ID | NUMBER | COMP_BILL_SEQ_ID | ||
| COMP_COMMON_BILL_SEQ_ID | NUMBER | COMP_COMMON_BILL_SEQ_ID | ||
| EXPLODE_GROUP_ID | NUMBER | EXPLODE_GROUP_ID | ||
| NUM_COL1 | NUMBER | NUM_COL1 | ||
| NUM_COL2 | NUMBER | NUM_COL2 | ||
| NUM_COL3 | NUMBER | NUM_COL3 | ||
| DATE_COL1 | DATE | DATE_COL1 | ||
| DATE_COL2 | DATE | DATE_COL1 | ||
| DATE_COL3 | DATE | DATE_COL3 | ||
| CHAR_COL1 | VARCHAR2 | (80) | CHAR_COL1 | |
| CHAR_COL2 | VARCHAR2 | (80) | CHAR_COL1 | |
| CHAR_COL3 | VARCHAR2 | (80) | CHAR_COL3 | |
| AUTO_REQUEST_MATERIAL | VARCHAR2 | (1) | AUTO_REQUEST_MATERIAL | |
| ITEM_NAME | VARCHAR2 | (2048) | Concatenated Sengments | |
| ITEM_STATUS | VARCHAR2 | (80) | ITEM_STATUS | |
| IMAGE_SOURCE | CHAR | (20) | Image Source to Show Documents and Components | |
| ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | (4000) | Structure Name | |
| CURRENT_ITEM_REVISION | VARCHAR2 | (4000) | CURRENT_ITEM_REVISION | |
| REVISION_LABEL | VARCHAR2 | (4000) | Revision Label | |
| INCLUDE_IN_COST_ROLLUP | NUMBER | INCLUDE_IN_COST_ROLLUP | ||
| COMPONENT_YIELD_FACTOR | NUMBER | COMPONENT_YIELD_FACTOR | ||
| PLANNING_FACTOR | NUMBER | PLANNING_FACTOR | ||
| CHANGE_NOTICE | VARCHAR2 | (10) | CHANGE_NOTICE | |
| STRUCTURE_TYPE | VARCHAR2 | (4000) | Structure Type Display | |
| USER_ITEM_TYPE | CHAR | (8) | USER_ITEM_TYPE | |
| CHANGE_ID | NUMBER | Change Id for the Engineering Change Order | ||
| CATALOG_CATEGORY | VARCHAR2 | (255) | Catalog Category Group | |
| ENG_ITEM_FLAG | VARCHAR2 | (1) | Engineering Item Flag | |
| PARENT_SORT_ORDER | VARCHAR2 | (2000) | Parent Sort Order for Sorting the Components in a Tree Structure | |
| LONG_DESCRIPTION | VARCHAR2 | (4000) | Components Long Description | |
| REVISION_CODE | VARCHAR2 | (4000) | ||
| STRUCTURE_TYPE_ID | NUMBER | Structure Type Identifier | ||
| SUGGESTED_VENDOR_NAME | VARCHAR2 | (240) | Used by direct items in EAM BOMs | |
| VENDOR_ID | NUMBER | Used by direct items in EAM BOMs | ||
| UNIT_PRICE | NUMBER | Unit Price for direct items used by EAM BOMs | ||
| PK1_VALUE | VARCHAR2 | (240) | PK Columns | |
| PK2_VALUE | VARCHAR2 | (240) | PK Columns | |
| PK3_VALUE | VARCHAR2 | (240) | PK Columns | |
| PK4_VALUE | VARCHAR2 | (240) | PK Columns | |
| PK5_VALUE | VARCHAR2 | (240) | PK Columns | |
| OBJ_NAME | VARCHAR2 | (30) | Object Name | |
| HGRID_FLAG | VARCHAR2 | (240) | Filter Flag | |
| CATALOG_CATEGORY_ID | NUMBER | Item Catalog Category ID | ||
| REVISION_ID | NUMBER | |||
| FROM_MINOR_REVISION_ID | NUMBER | |||
| TO_MINOR_REVISION_ID | NUMBER | |||
| FROM_MINOR_REVISION_LABEL | VARCHAR2 | (0) | ||
| TO_MINOR_REVISION_LABEL | VARCHAR2 | (0) | ||
| FROM_END_ITEM_REV_ID | NUMBER | |||
| TO_END_ITEM_REV_ID | NUMBER | |||
| FROM_END_ITEM_REVISION_LABEL | VARCHAR2 | (80) | ||
| TO_END_ITEM_REVISION_LABEL | VARCHAR2 | (80) | ||
| FROM_END_ITEM_MINOR_REV_ID | NUMBER | |||
| TO_END_ITEM_MINOR_REV_ID | NUMBER | |||
| FROM_END_ITEM_MINOR_REV_LABEL | VARCHAR2 | (0) | ||
| TO_END_ITEM_MINOR_REV_LABEL | VARCHAR2 | (0) | ||
| OBJECT_VERSION | NUMBER | |||
| MAPPED_ITEM_NAME | VARCHAR2 | (40) | ||
| MAPPED_ITEM_REVISION | VARCHAR2 | (84) | ||
| MAP_STATUS | NUMBER | |||
| FROM_END_ITEM | VARCHAR2 | (40) | ||
| TO_END_ITEM | VARCHAR2 | (40) | ||
| EFFECTIVITY_CONTROL | NUMBER | |||
| ACCESS_FLAG | VARCHAR2 | (4000) | ||
| TEMPLATE_NAME | VARCHAR2 | (0) | Item Template | |
| BOM_IMPLEMENTATION_DATE | DATE | |||
| MINOR_REVISION | VARCHAR2 | (0) | ||
| ASSEMBLY_TYPE | NUMBER | Assembly Type of the BOM | ||
| GTIN_NUMBER | VARCHAR2 | (25) | ||
| GTIN_DESCRIPTION | VARCHAR2 | (240) | ||
| TRADE_ITEM_DESCRIPTOR | VARCHAR2 | (35) | ||
| TOP_GTIN_NUMBER | VARCHAR2 | (25) | ||
| TOP_GTIN_DESCRIPTION | VARCHAR2 | (240) | ||
| TOP_TRADE_ITEM_DESCRIPTOR | VARCHAR2 | (35) | ||
| PARENT_GTIN_NUMBER | VARCHAR2 | (25) | ||
| PARENT_GTIN_DESCRIPTION | VARCHAR2 | (240) | ||
| PARENT_TRADE_ITEM_DESCRIPTOR | VARCHAR2 | (35) | ||
| QUANTITY_OF_CHILDREN | NUMBER | |||
| TOTAL_QTY_AT_NEXT_LEVEL | NUMBER | |||
| IS_PREFERRED | VARCHAR2 | (1) | ||
| TRADE_ITEM_DESCRIPTOR_DESC | VARCHAR2 | (80) | Trade Item Descriptor Description | |
| GTIN_PUBLICATION_STATUS | VARCHAR2 | (1) | GTIN Publication Status | |
| ATTACHMENT_NAME | VARCHAR2 | (0) | ||
| ACD_TYPE | NUMBER | |||
| QUANTITY_RELATED | NUMBER | |||
| SUPPLY_SUBINVENTORY | VARCHAR2 | (10) | ||
| FROM_END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | ||
| TO_END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | ||
| STRUCTURE_DISPLAY_NAME | VARCHAR2 | (4000) | ||
| CHANGE_POLICY_VALUE | VARCHAR2 | (240) | ||
| COMPONENT_REMARKS | VARCHAR2 | (240) | Component Comments | |
| IS_EXCLUDED_BY_RULE | VARCHAR2 | (4000) | Whether the component is excluded by rule or not. | |
| WIP_SUPPLY_TYPE | NUMBER | |||
| LOCATOR | VARCHAR2 | (40) | ||
| GROUP_ID | NUMBER | |||
| PARENT_IMPLEMENTATION_DATE | DATE | |||
| PARENT_CHANGE_NOTICE | VARCHAR2 | (10) | ||
| COMP_FIXED_REV_CODE | VARCHAR2 | (4000) | Holds the value of fixed revision code for Fixed Rev Components. |
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
, COMPONENT_QUANTITY
, BASIS_TYPE
, 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
FROM APPS.BOM_EXPLOSIONS_ALL_V;
APPS
BOM_ALTERNATE_DESIGNATORS_TL
BOM_COMPONENTS_B
BOM_EXPLODER_PUB
- show dependent code
BOM_EXPLOSIONS_ALL
BOM_GLOBALS
- show dependent code
BOM_SECURITY_PUB
- show dependent code
DDD_ITEM_MAPPING_INFO
DDD_MODEL_OBJECTS
ENG_ENGINEERING_CHANGES
FND_ATTACHED_DOCUMENTS
FND_DOCUMENTS_TL
FND_DOCUMENT_CATEGORIES_VL
FND_GLOBAL
- show dependent code
FND_LOOKUPS
MTL_ITEM_CATALOG_GROUPS_KFV
MTL_ITEM_REVISIONS
MTL_ITEM_REVISIONS_B
MTL_ITEM_REVISIONS_VL
MTL_SYSTEM_ITEMS_B
MTL_SYSTEM_ITEMS_KFV
MTL_SYSTEM_ITEMS_TL
MTL_SYSTEM_ITEMS_VL
PUBLIC
DUAL
APPS
EGO_GTIN_PVT
- show dependent code
|
|
|
|