[Home] [Help] [Dependency Information]

VIEW: APPS.BOM_WS_EXPLOSIONS_ALL_V

Object Details

[View Source]

Columns

Query Text

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

SELECT ROW_ID
,      TOP_BILL_SEQUENCE_ID
,      BILL_SEQUENCE_ID
,      ORGANIZATION_ID
,      COMPONENT_SEQUENCE_ID
,      COMPONENT_ITEM_ID
,      PLAN_LEVEL
,      EXTENDED_QUANTITY
,      SORT_ORDER
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      GROUP_ID
,      SESSION_ID
,      SELECT_FLAG
,      SELECT_QUANTITY
,      EXTEND_COST_FLAG
,      TOP_ALTERNATE_DESIGNATOR
,      TOP_ITEM_ID
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      HEADER_ID
,      LINE_ID
,      LIST_PRICE
,      SELLING_PRICE
,      COMPONENT_YIELD_FACTOR
,      ITEM_COST
,      INCLUDE_IN_ROLLUP_FLAG
,      BASED_ON_ROLLUP_FLAG
,      ACTUAL_COST_TYPE_ID
,      COMPONENT_QUANTITY
,      SHRINKAGE_RATE
,      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
,      MTL_TRANSACTIONS_ENABLED_FLAG
,      STOCK_ENABLED_FLAG
,      DESCRIPTION
,      ASSEMBLY_ITEM_ID
,      ALTERNATE_BOM_DESIGNATOR
,      CONFIGURATOR_FLAG
,      PRICE_LIST_ID
,      ROUNDING_FACTOR
,      PRICING_CONTEXT
,      PRICING_ATTRIBUTE1
,      PRICING_ATTRIBUTE2
,      PRICING_ATTRIBUTE3
,      PRICING_ATTRIBUTE4
,      PRICING_ATTRIBUTE5
,      PRICING_ATTRIBUTE6
,      PRICING_ATTRIBUTE7
,      PRICING_ATTRIBUTE8
,      PRICING_ATTRIBUTE9
,      PRICING_ATTRIBUTE10
,      PRICING_ATTRIBUTE11
,      PRICING_ATTRIBUTE12
,      PRICING_ATTRIBUTE13
,      PRICING_ATTRIBUTE14
,      PRICING_ATTRIBUTE15
,      COMPONENT_CODE
,      LOOP_FLAG
,      INVENTORY_ASSET_FLAG
,      PLANNING_FACTOR
,      OPERATION_SEQ_NUM
,      PARENT_BOM_ITEM_TYPE
,      WIP_SUPPLY_TYPE
,      ITEM_NUM
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      TRIMMED_EFFECTIVITY_DATE
,      TRIMMED_DISABLE_DATE
,      IMPLEMENTATION_DATE
,      SUPPLY_SUBINVENTORY
,      SUPPLY_LOCATOR_ID
,      COMPONENT_REMARKS
,      CHANGE_NOTICE
,      OPERATION_LEAD_TIME_PERCENT
,      REXPLODE_FLAG
,      COMMON_BILL_SEQUENCE_ID
,      COMMON_ORGANIZATION_ID
,      PRIMARY_PATH_FLAG
,      AUTO_REQUEST_MATERIAL
,      EXPLOSION_TYPE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      COMP_BILL_SEQ_ID
,      COMP_COMMON_BILL_SEQ_ID
,      NUM_COL1
,      NUM_COL2
,      NUM_COL3
,      DATE_COL1
,      DATE_COL2
,      DATE_COL3
,      CHAR_COL1
,      CHAR_COL2
,      CHAR_COL3
,      INCLUDE_IN_COST_ROLLUP
,      PARENT_SORT_ORDER
,      STRUCTURE_TYPE_ID
,      OBJ_NAME
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      HGRID_FLAG
,      OPERATION_OFFSET
,      CURRENT_REVISION
,      LOCATOR
,      SUGGESTED_VENDOR_NAME
,      UNIT_PRICE
,      VENDOR_ID
,      FROM_END_ITEM_UNIT_NUMBER
,      TO_END_ITEM_UNIT_NUMBER
,      TRIMMED_FROM_UNIT_NUMBER
,      TRIMMED_TO_UNIT_NUMBER
,      FROM_END_ITEM_REV_ID
,      FROM_END_ITEM_MINOR_REV_ID
,      TO_END_ITEM_REV_ID
,      TO_END_ITEM_MINOR_REV_ID
,      NEW_COMPONENT_CODE
,      FROM_BILL_REVISION_ID
,      TO_BILL_REVISION_ID
,      REVISION_ID
,      REVISION_LABEL
,      EFFECTIVITY_CONTROL
,      ACCESS_FLAG
,      ENG_ITEM_FLAG
,      ASSEMBLY_TYPE
,      FROM_OBJECT_REVISION_ID
,      FROM_MINOR_REVISION_ID
,      TO_OBJECT_REVISION_ID
,      TO_MINOR_REVISION_ID
,      OBJECT_REVISION_ID
,      MINOR_REVISION_ID
,      MINOR_REVISION_CODE
,      COMPONENT_ITEM_REVISION_ID
,      COMPONENT_MINOR_REVISION_ID
,      BOM_IMPLEMENTATION_DATE
,      GTIN_NUMBER
,      GTIN_DESCRIPTION
,      TRADE_ITEM_DESCRIPTOR
,      TRADE_ITEM_DESCRIPTOR_DESC
,      GTIN_PUBLICATION_STATUS
,      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
,      CHANGE_ID
,      ACD_TYPE
,      QUANTITY_RELATED
,      CHANGE_POLICY_VALUE
,      EXPLODED_DATE
,      EXPLODED_UNIT_NUMBER
,      EXPLODED_END_ITEM_REV
,      EXPLODED_END_ITEM_ID
,      EXPLODED_END_ITEM_ORG_ID
,      EXPLODED_OPTION
,      PARENT_COMP_SEQ_ID
,      END_ITEM_ID
,      END_ITEM_ORG_ID
,      FROM_END_ITEM_REVISION
,      TO_END_ITEM_REVISION
,      IS_END_ITEM_SPECIFIC
,      IS_EXCLUDED_BY_RULE
,      REAPPLY_EXCLUSIONS
,      COMP_FIXED_REV_HIGH_DATE
,      COMP_FIXED_REVISION_ID
,      MAX_BILL_LEVEL
,      IS_PREFERRED
,      PARENT_IMPLEMENTATION_DATE
,      PARENT_CHANGE_NOTICE
,      COMP_EFFECTIVITY_CONTROL
,      BASIS_TYPE
,      SOURCE_BILL_SEQUENCE_ID
,      COMMON_COMPONENT_SEQUENCE_ID
,      COMP_SOURCE_BILL_SEQ_ID
FROM APPS.BOM_WS_EXPLOSIONS_ALL_V;

Dependencies

[top of page]

APPS

BOM_EXPLOSIONS_ALL

APPS.BOM_WS_EXPLOSIONS_ALL_V is not referenced by any database object