VIEW: BOM.BOM_COMP_OPTIONS_TEMP#

Source

View Text - Preformatted

select TRANSACTION_GROUP_ID TRANSACTION_GROUP_ID, TRANSACTION_ID TRANSACTION_ID, ASSEMBLY_ITEM_NAME ASSEMBLY_ITEM_NAME, ORGANIZATION_CODE ORGANIZATION_CODE, ALTERNATE_BOM_CODE ALTERNATE_BOM_CODE, START_EFFECTIVE_DATE START_EFFECTIVE_DATE, COMPONENT_ITEM_NAME COMPONENT_ITEM_NAME, OPERATION_SEQUENCE_NUMBER OPERATION_SEQUENCE_NUMBER, ITEM_SEQUENCE_NUMBER ITEM_SEQUENCE_NUMBER, DISABLE_DATE DISABLE_DATE, SUPPLY_SUBINVENTORY SUPPLY_SUBINVENTORY, LOCATION_NAME LOCATION_NAME, PLANNING_PERCENT PLANNING_PERCENT, REQUIRED_FOR_REVENUE REQUIRED_FOR_REVENUE, REQUIRED_TO_SHIP REQUIRED_TO_SHIP, MINIMUM_ALLOWED_QUANTITY MINIMUM_ALLOWED_QUANTITY, MAXIMUM_ALLOWED_QUANTITY MAXIMUM_ALLOWED_QUANTITY, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE, QUANTITY_PER_ASSEMBLY QUANTITY_PER_ASSEMBLY, PROJECTED_YIELD PROJECTED_YIELD, COMMENTS COMMENTS, QUANTITY_RELATED QUANTITY_RELATED, SO_BASIS SO_BASIS, OPTIONAL OPTIONAL, MUTUALLY_EXCLUSIVE MUTUALLY_EXCLUSIVE, INCLUDE_IN_COST_ROLLUP INCLUDE_IN_COST_ROLLUP, CHECK_ATP CHECK_ATP, SHIPPING_ALLOWED SHIPPING_ALLOWED, INCLUDE_ON_SHIP_DOCS INCLUDE_ON_SHIP_DOCS, NEW_EFFECTIVITY_DATE NEW_EFFECTIVITY_DATE, NEW_OPERATION_SEQUENCE_NUMBER NEW_OPERATION_SEQUENCE_NUMBER, FROM_END_ITEM_UNIT_NUMBER FROM_END_ITEM_UNIT_NUMBER, TO_END_ITEM_UNIT_NUMBER TO_END_ITEM_UNIT_NUMBER, TRANSACTION_TYPE TRANSACTION_TYPE, RETURN_STATUS RETURN_STATUS, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, DELETE_GROUP_NAME DELETE_GROUP_NAME, DG_DESCRIPTION DG_DESCRIPTION, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE from "BOM"."BOM_COMP_OPTIONS_TEMP"

View Text - HTML Formatted

SELECT TRANSACTION_GROUP_ID TRANSACTION_GROUP_ID
, TRANSACTION_ID TRANSACTION_ID
, ASSEMBLY_ITEM_NAME ASSEMBLY_ITEM_NAME
, ORGANIZATION_CODE ORGANIZATION_CODE
, ALTERNATE_BOM_CODE ALTERNATE_BOM_CODE
, START_EFFECTIVE_DATE START_EFFECTIVE_DATE
, COMPONENT_ITEM_NAME COMPONENT_ITEM_NAME
, OPERATION_SEQUENCE_NUMBER OPERATION_SEQUENCE_NUMBER
, ITEM_SEQUENCE_NUMBER ITEM_SEQUENCE_NUMBER
, DISABLE_DATE DISABLE_DATE
, SUPPLY_SUBINVENTORY SUPPLY_SUBINVENTORY
, LOCATION_NAME LOCATION_NAME
, PLANNING_PERCENT PLANNING_PERCENT
, REQUIRED_FOR_REVENUE REQUIRED_FOR_REVENUE
, REQUIRED_TO_SHIP REQUIRED_TO_SHIP
, MINIMUM_ALLOWED_QUANTITY MINIMUM_ALLOWED_QUANTITY
, MAXIMUM_ALLOWED_QUANTITY MAXIMUM_ALLOWED_QUANTITY
, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
, QUANTITY_PER_ASSEMBLY QUANTITY_PER_ASSEMBLY
, PROJECTED_YIELD PROJECTED_YIELD
, COMMENTS COMMENTS
, QUANTITY_RELATED QUANTITY_RELATED
, SO_BASIS SO_BASIS
, OPTIONAL OPTIONAL
, MUTUALLY_EXCLUSIVE MUTUALLY_EXCLUSIVE
, INCLUDE_IN_COST_ROLLUP INCLUDE_IN_COST_ROLLUP
, CHECK_ATP CHECK_ATP
, SHIPPING_ALLOWED SHIPPING_ALLOWED
, INCLUDE_ON_SHIP_DOCS INCLUDE_ON_SHIP_DOCS
, NEW_EFFECTIVITY_DATE NEW_EFFECTIVITY_DATE
, NEW_OPERATION_SEQUENCE_NUMBER NEW_OPERATION_SEQUENCE_NUMBER
, FROM_END_ITEM_UNIT_NUMBER FROM_END_ITEM_UNIT_NUMBER
, TO_END_ITEM_UNIT_NUMBER TO_END_ITEM_UNIT_NUMBER
, TRANSACTION_TYPE TRANSACTION_TYPE
, RETURN_STATUS RETURN_STATUS
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, DELETE_GROUP_NAME DELETE_GROUP_NAME
, DG_DESCRIPTION DG_DESCRIPTION
, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE
FROM "BOM"."BOM_COMP_OPTIONS_TEMP"