[Home] [Help]
View: BOM_LINE_DETAILS_VIEW
Product: | BOM - Bills of Material |
Description: | Order line details -- used by delete constraints |
Implementation/DBA Data: |
APPS.BOM_LINE_DETAILS_VIEW
|
View Text
SELECT LINE_DETAIL_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LINE_ID
, INVENTORY_ITEM_ID
, INCLUDED_ITEM_FLAG
, COMPONENT_SEQUENCE_ID
, COMPONENT_CODE
, COMPONENT_RATIO
, SHIPPABLE_FLAG
, TRANSACTABLE_FLAG
, RESERVABLE_FLAG
, RELEASED_FLAG
, QUANTITY
, WAREHOUSE_ID
, DEMAND_CLASS_CODE
, SCHEDULE_DATE
, REVISION
, LOT_NUMBER
, SUBINVENTORY
, CUSTOMER_REQUESTED_LOT_FLAG
, SCHEDULE_STATUS_CODE
, SCHEDULE_LEVEL_CODE
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM SO_LINE_DETAILS
Columns
Name |
LINE_DETAIL_ID |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
LINE_ID |
INVENTORY_ITEM_ID |
INCLUDED_ITEM_FLAG |
COMPONENT_SEQUENCE_ID |
COMPONENT_CODE |
COMPONENT_RATIO |
SHIPPABLE_FLAG |
TRANSACTABLE_FLAG |
RESERVABLE_FLAG |
RELEASED_FLAG |
QUANTITY |
WAREHOUSE_ID |
DEMAND_CLASS_CODE |
SCHEDULE_DATE |
REVISION |
LOT_NUMBER |
SUBINVENTORY |
CUSTOMER_REQUESTED_LOT_FLAG |
SCHEDULE_STATUS_CODE |
SCHEDULE_LEVEL_CODE |
CONTEXT |
ATTRIBUTE1 |
ATTRIBUTE2 |
ATTRIBUTE3 |
ATTRIBUTE4 |
ATTRIBUTE5 |
ATTRIBUTE6 |
ATTRIBUTE7 |
ATTRIBUTE8 |
ATTRIBUTE9 |
ATTRIBUTE10 |
ATTRIBUTE11 |
ATTRIBUTE12 |
ATTRIBUTE13 |
ATTRIBUTE14 |
ATTRIBUTE15 |