FND Design Data [Home] [Help]

View: BOM_LINE_DETAILS_VIEW

Product: BOM - Bills of Material
Description: Order line details -- used by delete constraints
Implementation/DBA Data: ViewAPPS.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