[Home] [Help]
| Product: | ICX - Oracle iProcurement |
|---|---|
| Description: | Obsolete |
| Implementation/DBA Data: | Not implemented in this database |
SELECT AQL.ROWID ROW_ID
, 'AS_QUOTE_LINES' ROW_QUALIFIER
, AQL.QUOTE_LINE_ID LINE_ID
, AQL.QUOTE_ID HEADER_ID
, AQL.GROUP_ID
, -1 PARENT_LINE_ID
, AQL.INVENTORY_ITEM_ID
, -1 SEQUENCE_NUMBER
, '' COMPONENT_CODE
, AQL.QUANTITY ORDERED_QUANTITY
, 0 CANCELLED_QUANTITY
, AQL.ORGANIZATION_ID WAREHOUSE_ID
, AQ.SHIP_TO_SITE_USE_ID
, -1 ITEM_SVRID
, AQL.ATTRIBUTE_CATEGORY CONTEXT
, AQL.ATTRIBUTE1
, AQL.ATTRIBUTE2
, AQL.ATTRIBUTE3
, AQL.ATTRIBUTE4
, AQL.ATTRIBUTE5
, AQL.ATTRIBUTE6
, AQL.ATTRIBUTE7
, AQL.ATTRIBUTE8
, AQL.ATTRIBUTE9
, AQL.ATTRIBUTE10
, AQL.ATTRIBUTE11
, AQL.ATTRIBUTE12
, AQL.ATTRIBUTE13
, AQL.ATTRIBUTE14
, AQL.ATTRIBUTE15
FROM AS_QUOTE_LINES AQL
, AS_QUOTES AQ
WHERE AQ.QUOTE_ID = AQL.QUOTE_ID 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
, ITEM_SVRID
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM BOM_CONFIG_EXPLOSIONS