eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: OE.SO_LINE_DETAILS

Object Details

Object Name:	SO_LINE_DETAILS
Object Type:	TABLE
Owner:	OE
FND Design Data:	OE.SO_LINE_DETAILS
Subobject Name:
Status:	VALID

SO_LINE_DETAILS stores information about how an order line is
scheduled in Oracle Manufacturing.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SO_LINE_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LINE_DETAIL_ID
SO_LINE_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LINE_ID
SO_LINE_DETAILS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID
SO_LINE_DETAILS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DPW_ASSIGNED_FLAG
SO_LINE_DETAILS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELIVERY_ID
SO_LINE_DETAILS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DEPARTURE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LINE_DETAIL_ID	NUMBER		Yes	System-generated identifier
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
LINE_ID	NUMBER		Yes	Order line
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item
INCLUDED_ITEM_FLAG	VARCHAR2	(1)	Yes	Indicates whether item is an included item
COMPONENT_SEQUENCE_ID	NUMBER			Bill of materials component (option) or bill (top model)
COMPONENT_CODE	VARCHAR2	(1000)	Yes	Identifier of component within an exploded bill
COMPONENT_RATIO	NUMBER		Yes	Number of detail items per line item
SHIPPABLE_FLAG	VARCHAR2	(1)		Indicates whether item in warehouse is shippable
TRANSACTABLE_FLAG	VARCHAR2	(1)		Indicates whether item in warehouse is transactable to Inventory
RESERVABLE_FLAG	VARCHAR2	(1)		Indicates whether item in warehouse is reservable
UNIT_CODE	VARCHAR2	(3)		Unit of measure
RELEASED_FLAG	VARCHAR2	(1)	Yes	Indicates whether detail has been pick released
REQUIRED_FOR_REVENUE_FLAG	VARCHAR2	(1)		Indicator whether item is required to ship in order to invoice order line
QUANTITY	NUMBER		Yes	Quantity
WAREHOUSE_ID	NUMBER			Warehouse (Organization)
DEMAND_CLASS_CODE	VARCHAR2	(30)		Demand class
SCHEDULE_DATE	DATE			Date planned to ship item
REVISION	VARCHAR2	(3)		Revision of item
LOT_NUMBER	VARCHAR2	(30)		Lot of item
SUBINVENTORY	VARCHAR2	(10)		Subinventory of item
CUSTOMER_REQUESTED_LOT_FLAG	VARCHAR2	(1)		Indicator whether customer requested revision, lot and/or subinventory
SCHEDULE_STATUS_CODE	VARCHAR2	(30)		Current schedule status
RECEIPT_STATUS_CODE	VARCHAR2	(30)		Indicates receiving status of the schedule detail
SCHEDULE_LEVEL_CODE	NUMBER			Not used
QUANTITY_SVRID	NUMBER			Standard value rule from which attribute is derived
WAREHOUSE_SVRID	NUMBER			Standard value rule from which attribute is derived
DEMAND_CLASS_SVRID	NUMBER			Standard value rule from which attribute is derived
DATE_SVRID	NUMBER			Standard value rule from which attribute is derived
REVISION_SVRID	NUMBER			Standard value rule from which attribute is derived
LOT_SVRID	NUMBER			Standard value rule from which attribute is derived
SUBINVENTORY_SVRID	NUMBER			Standard value rule from which attribute is derived
CUSTOMER_REQUESTED_SVRID	NUMBER			Standard value rule from which attribute is derived
DF_SVRID	NUMBER			Standard value rule from which attribute is derived
CONTEXT	VARCHAR2	(30)		Descriptive flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
DELIVERY	NUMBER			Demand delivery
WIP_RESERVED_QUANTITY	NUMBER			Quantity of item reserved by Work in Process
WIP_COMPLETED_QUANTITY	NUMBER			Quantity of item built by Work in Process
SUPPLY_SOURCE_TYPE	NUMBER			Supply source type
SUPPLY_SOURCE_HEADER_ID	NUMBER			Supply source header
UPDATE_FLAG	VARCHAR2	(1)		Indicator whether detail must be synchronized with changes in Manufacturing
INVENTORY_LOCATION_ID	NUMBER			Inventory location of item
CONFIGURATION_ITEM_FLAG	VARCHAR2	(1)		Indicates whether item is a configuration item
LATEST_ACCEPTABLE_DATE	DATE			Not used
LATEST_ACCEPTABLE_DATE_SVRID	NUMBER			Standard value rule from which attribute is derived
DEP_PLAN_REQUIRED_FLAG	VARCHAR2	(1)		Departure planning mandatory flag
DPW_ASSIGNED_FLAG	VARCHAR2	(1)		Departure Assigned flag
DELIVERY_ID	NUMBER			Foreign key to WSH_DELIVERIES
DEPARTURE_ID	NUMBER			Foreign key to WSH_DELIVERIES
CUSTOMER_ITEM_ID	NUMBER			Customer item ID
LOAD_SEQ_NUMBER	NUMBER			Loading sequence number
MASTER_CONTAINER_ITEM_ID	NUMBER			Foreign key to MTL_SYSTEM_ITEMS (Master Organization)
DETAIL_CONTAINER_ITEM_ID	NUMBER			Foreign key to MTL_SYSTEM_ITEMS (Master Organization)
SO_LINE_DETAILS_DEPARTURE_ID	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


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
,      UNIT_CODE
,      RELEASED_FLAG
,      REQUIRED_FOR_REVENUE_FLAG
,      QUANTITY
,      WAREHOUSE_ID
,      DEMAND_CLASS_CODE
,      SCHEDULE_DATE
,      REVISION
,      LOT_NUMBER
,      SUBINVENTORY
,      CUSTOMER_REQUESTED_LOT_FLAG
,      SCHEDULE_STATUS_CODE
,      RECEIPT_STATUS_CODE
,      SCHEDULE_LEVEL_CODE
,      QUANTITY_SVRID
,      WAREHOUSE_SVRID
,      DEMAND_CLASS_SVRID
,      DATE_SVRID
,      REVISION_SVRID
,      LOT_SVRID
,      SUBINVENTORY_SVRID
,      CUSTOMER_REQUESTED_SVRID
,      DF_SVRID
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DELIVERY
,      WIP_RESERVED_QUANTITY
,      WIP_COMPLETED_QUANTITY
,      SUPPLY_SOURCE_TYPE
,      SUPPLY_SOURCE_HEADER_ID
,      UPDATE_FLAG
,      INVENTORY_LOCATION_ID
,      CONFIGURATION_ITEM_FLAG
,      LATEST_ACCEPTABLE_DATE
,      LATEST_ACCEPTABLE_DATE_SVRID
,      DEP_PLAN_REQUIRED_FLAG
,      DPW_ASSIGNED_FLAG
,      DELIVERY_ID
,      DEPARTURE_ID
,      CUSTOMER_ITEM_ID
,      LOAD_SEQ_NUMBER
,      MASTER_CONTAINER_ITEM_ID
,      DETAIL_CONTAINER_ITEM_ID
,      SO_LINE_DETAILS_DEPARTURE_ID
FROM OE.SO_LINE_DETAILS;

Dependencies

[top of page]

OE.SO_LINE_DETAILS does not reference any database object

OE.SO_LINE_DETAILS is referenced by following:

APPS: SO_LINE_DETAILS