[Home] [Help]
| Product: | BOM - Bills of Material |
|---|---|
| Description: | Selection of components |
| Implementation/DBA Data: | Not implemented in this database |
SELECT ROWID ROW_ID
, 'SO_LINES' ROW_QUALIFIER
, LINE_ID
, HEADER_ID
, -1 GROUP_ID
, PARENT_LINE_ID
, INVENTORY_ITEM_ID
, -1 SEQUENCE_NUMBER
, COMPONENT_CODE
, ORDERED_QUANTITY
, CANCELLED_QUANTITY
, WAREHOUSE_ID
, SHIP_TO_SITE_USE_ID
, ITEM_SVRID
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM SO_LINES_ALL UNION SELECT ROWID ROW_ID
, 'BCE' ROW_QUALIFIER
, -1 LINE_ID
, -1 HEADER_ID
, GROUP_ID
, -1 PARENT_LINE_ID
, COMPONENT_ITEM_ID
, NUM_COL1 SEQUENCE_NUMBER
, COMPONENT_CODE
, SELECT_QUANTITY
, 0 CANCELLED_QUANTITY
, ORGANIZATION_ID
, -1 SHIP_TO_SITE_USE_ID
, -1 ITEM_SVRID
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM BOM_CONFIG_EXPLOSIONS