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_PICKING_LINES_ALL

Object Details

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

SO_PICKING_LINES_ALL stores the picking lines for a picking header.
The column ORDER_LINE_ID indicates the order line corresponding to
each picking line. The column SHIPPED_QUANTITY indicates how many
items from each picking line have been shipped, while
REQUESTED_QUANTITY reflects the amount that has been reserved,
and ORIGINAL_REQUESTED_QUANTITY indicates the total ordered
amount.
.
.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SO_PICKING_LINES_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	PICKING_LINE_ID
SO_PICKING_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	INVENTORY_ITEM_ID
SO_PICKING_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	ORDER_LINE_ID
SO_PICKING_LINES_N3	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	RA_INTERFACE_STATUS
SO_PICKING_LINES_N4	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	INVENTORY_STATUS
SO_PICKING_LINES_N5	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	PICKING_HEADER_ID WAREHOUSE_ID
SO_PICKING_LINES_N6	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	BO_PICKING_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PICKING_LINE_ID	NUMBER		Yes	System-generated ID
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
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who column
PROGRAM_ID	NUMBER	(15)		Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
REQUEST_ID	NUMBER	(15)		Standard Who column
PICKING_HEADER_ID	NUMBER		Yes	Pick release batch with which this picking line is associated
SEQUENCE_NUMBER	NUMBER		Yes	The number of this picking line within the picking batch
ORDER_LINE_ID	NUMBER		Yes	The order line associated with this picking line
COMPONENT_CODE	VARCHAR2	(1000)	Yes	Identifier of component within an exploded bill
LINE_DETAIL_ID	NUMBER		Yes	The order line detail associated with this picking line
COMPONENT_RATIO	NUMBER		Yes	The ratio of this component to its parent in the bill of material structure
REQUESTED_QUANTITY	NUMBER		Yes	Quantity released by pick release
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item
INCLUDED_ITEM_FLAG	VARCHAR2	(1)		Included item indicator
DATE_REQUESTED	DATE		Yes	Date customer requested shipment
ORIGINAL_REQUESTED_QUANTITY	NUMBER		Yes	Unshipped quantity
WAREHOUSE_ID	NUMBER			Warehouse (Organization)
SHIPPED_QUANTITY	NUMBER			Total shipped quantity
CANCELLED_QUANTITY	NUMBER			Total quantity cancelled on this picking line
SHIP_TO_SITE_USE_ID	NUMBER			Customer ship-to ID
SHIP_TO_CONTACT_ID	NUMBER			Customer ship-to contact
SHIPMENT_PRIORITY_CODE	VARCHAR2	(30)		Shipment priority
SHIP_METHOD_CODE	VARCHAR2	(30)		Freight carrier
DATE_CONFIRMED	DATE			Date shipment was confirmed
RA_INTERFACE_STATUS	VARCHAR2	(30)		Identifies whether the picking line has been processed by the Receivables Interface
SERVICE_INTERFACE_STATUS	VARCHAR2	(1)		Service Interface processing status
INVOICED_QUANTITY	NUMBER			Total quantity invoiced
INVENTORY_STATUS	VARCHAR2	(30)		Indicates whether Inventory Interface has processed line
UNIT_CODE	VARCHAR2	(3)		Unit of measure
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
SCHEDULE_DATE	DATE			Schedule date
DEMAND_CLASS_CODE	VARCHAR2	(30)		Demand class
COMPONENT_SEQUENCE_ID	NUMBER			Bill of materials component (option) or bill (top model)
CONFIGURATION_ITEM_FLAG	VARCHAR2	(1)		Configuration item indicator
LATEST_ACCEPTABLE_DATE	DATE			Not used
MOVEMENT_ID	NUMBER			Movement statistics identifier
ORG_ID	NUMBER			Operating unit which performed this transaction
TRANSACTION_HEADER_ID	NUMBER			Foreign key to Inventory Transaction Temp tables
BO_PICKING_LINE_ID	NUMBER			Identifier of associated backordered picking line
DEP_PLAN_REQUIRED_FLAG	VARCHAR2	(1)		Must be departure planned
CUSTOMER_ITEM_ID	NUMBER			Customer's item identifier

Query Text

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


SELECT PICKING_LINE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      PICKING_HEADER_ID
,      SEQUENCE_NUMBER
,      ORDER_LINE_ID
,      COMPONENT_CODE
,      LINE_DETAIL_ID
,      COMPONENT_RATIO
,      REQUESTED_QUANTITY
,      INVENTORY_ITEM_ID
,      INCLUDED_ITEM_FLAG
,      DATE_REQUESTED
,      ORIGINAL_REQUESTED_QUANTITY
,      WAREHOUSE_ID
,      SHIPPED_QUANTITY
,      CANCELLED_QUANTITY
,      SHIP_TO_SITE_USE_ID
,      SHIP_TO_CONTACT_ID
,      SHIPMENT_PRIORITY_CODE
,      SHIP_METHOD_CODE
,      DATE_CONFIRMED
,      RA_INTERFACE_STATUS
,      SERVICE_INTERFACE_STATUS
,      INVOICED_QUANTITY
,      INVENTORY_STATUS
,      UNIT_CODE
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SCHEDULE_DATE
,      DEMAND_CLASS_CODE
,      COMPONENT_SEQUENCE_ID
,      CONFIGURATION_ITEM_FLAG
,      LATEST_ACCEPTABLE_DATE
,      MOVEMENT_ID
,      ORG_ID
,      TRANSACTION_HEADER_ID
,      BO_PICKING_LINE_ID
,      DEP_PLAN_REQUIRED_FLAG
,      CUSTOMER_ITEM_ID
FROM OE.SO_PICKING_LINES_ALL;

Dependencies

[top of page]

OE.SO_PICKING_LINES_ALL does not reference any database object

OE.SO_PICKING_LINES_ALL is referenced by following:

OE: SO_PICKING_LINES_ALL#