View: BOM_PLM_EXPLOSION_TEMP

Product:	BOM - Bills of Material
Description:
Implementation/DBA Data:	APPS.BOM_PLM_EXPLOSION_TEMP

View Text

SELECT TOP_BILL_SEQUENCE_ID
, BILL_SEQUENCE_ID
, COMMON_BILL_SEQUENCE_ID
, COMMON_ORGANIZATION_ID
, ORGANIZATION_ID
, COMPONENT_SEQUENCE_ID
, COMPONENT_ITEM_ID
, COMPONENT_QUANTITY
, PLAN_LEVEL
, EXTENDED_QUANTITY
, SORT_ORDER
, GROUP_ID
, TOP_ALTERNATE_DESIGNATOR
, COMPONENT_YIELD_FACTOR
, TOP_ITEM_ID
, COMPONENT_CODE
, INCLUDE_IN_ROLLUP_FLAG
, LOOP_FLAG
, PLANNING_FACTOR
, OPERATION_SEQ_NUM
, BOM_ITEM_TYPE
, PARENT_BOM_ITEM_TYPE
, ASSEMBLY_ITEM_ID
, ALTERNATE_BOM_DESIGNATOR
, WIP_SUPPLY_TYPE
, ITEM_NUM
, EFFECTIVITY_DATE
, DISABLE_DATE
, FROM_END_ITEM_UNIT_NUMBER
, TO_END_ITEM_UNIT_NUMBER
, IMPLEMENTATION_DATE
, OPTIONAL
, SUPPLY_SUBINVENTORY
, SUPPLY_LOCATOR_ID
, COMPONENT_REMARKS
, CHANGE_NOTICE
, OPERATION_LEAD_TIME_PERCENT
, MUTUALLY_EXCLUSIVE_OPTIONS
, CHECK_ATP
, REQUIRED_TO_SHIP
, REQUIRED_FOR_REVENUE
, INCLUDE_ON_SHIP_DOCS
, LOW_QUANTITY
, HIGH_QUANTITY
, SO_BASIS
, OPERATION_OFFSET
, CURRENT_REVISION
, LOCATOR
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, OBJ_NAME
, PK1_VALUE
, PK2_VALUE
, PK3_VALUE
, PK4_VALUE
, PK5_VALUE
, 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
, PARENT_SORT_ORDER
, COMP_COMMON_BILL_SEQ_ID
, COMP_BILL_SEQ_ID
, ACCESS_FLAG
, ASSEMBLY_TYPE
, REVISION_LABEL
, REVISION_ID
, EFFECTIVITY_CONTROL
, OBJECT_REVISION_ID
, MINOR_REVISION_ID
, MINOR_REVISION_CODE
, FROM_OBJECT_REVISION_ID
, FROM_MINOR_REVISION_ID
, TO_OBJECT_REVISION_ID
, TO_MINOR_REVISION_ID
, COMPONENT_ITEM_REVISION_ID
, COMPONENT_MINOR_REVISION_ID
, BOM_IMPLEMENTATION_DATE
FROM BOM_EXPLOSION_TEMP

Columns