VIEW: APPS.BOM_PLM_EXPLOSION_TEMP

Source

View Text - Preformatted

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

View Text - HTML Formatted

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