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_HEADERS_ALL

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SO_PICKING_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	PICKING_HEADER_ID
SO_PICKING_HEADERS_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	DATE_SHIPPED
SO_PICKING_HEADERS_N2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	BATCH_ID
SO_PICKING_HEADERS_N3	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	ORDER_HEADER_ID
SO_PICKING_HEADERS_N4	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	PICK_SLIP_NUMBER
SO_PICKING_HEADERS_N5	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	WAYBILL_NUM
SO_PICKING_HEADERS_N6	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	STATUS_CODE
SO_PICKING_HEADERS_N7	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	SHIP_NOTICE_SENT_FLAG
SO_PICKING_HEADERS_N8	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	DELIVERY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PICKING_HEADER_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
BATCH_ID	NUMBER		Yes	User name or sequenced number for this release batch
ORDER_HEADER_ID	NUMBER		Yes	Order number, if order number was used as release criteria for this batch
WAREHOUSE_ID	NUMBER		Yes	Warehouse (Organization)
SHIP_TO_SITE_USE_ID	NUMBER		Yes	Specific customer ship-to site, if used as release criteria for this batch
STATUS_CODE	VARCHAR2	(30)	Yes	Indicates header has been processed completely
PICK_SLIP_NUMBER	NUMBER			Number of pick slip
WAYBILL_NUM	VARCHAR2	(50)		Waybill number for shipment
PICKED_BY_ID	NUMBER			User ID of user who picked pick slip
PACKED_BY_ID	NUMBER			User ID of user who packed pick slip
WEIGHT	NUMBER			Weight of items shipped on pick slip
WEIGHT_UNIT_CODE	VARCHAR2	(3)		Unit used for weight
NUMBER_OF_BOXES	NUMBER			Number of boxes in shipment
SHIP_METHOD_CODE	VARCHAR2	(30)		Freight carrier
EXPECTED_ARRIVAL_DATE	DATE			User-entered date on which the shipment for this batch is expected to reach its destination
DATE_RELEASED	DATE			Date items were pick released
DATE_SHIPPED	DATE			Date items were shipped
DATE_CONFIRMED	DATE			Date items were confirmed
ORG_ID	NUMBER			Operating unit which performed this transaction
SHIP_NOTICE_SENT_DATE	DATE			Date ship notice was sent
SHIP_NOTICE_SENT_FLAG	VARCHAR2	(1)		Whether ship notice was sent
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_ID	NUMBER			Identifier of associated delivery line
ARRIVED_FLAG	NUMBER			For future use

Query Text

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


SELECT PICKING_HEADER_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      BATCH_ID
,      ORDER_HEADER_ID
,      WAREHOUSE_ID
,      SHIP_TO_SITE_USE_ID
,      STATUS_CODE
,      PICK_SLIP_NUMBER
,      WAYBILL_NUM
,      PICKED_BY_ID
,      PACKED_BY_ID
,      WEIGHT
,      WEIGHT_UNIT_CODE
,      NUMBER_OF_BOXES
,      SHIP_METHOD_CODE
,      EXPECTED_ARRIVAL_DATE
,      DATE_RELEASED
,      DATE_SHIPPED
,      DATE_CONFIRMED
,      ORG_ID
,      SHIP_NOTICE_SENT_DATE
,      SHIP_NOTICE_SENT_FLAG
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DELIVERY_ID
,      ARRIVED_FLAG
FROM OE.SO_PICKING_HEADERS_ALL;

Dependencies

[top of page]

OE.SO_PICKING_HEADERS_ALL does not reference any database object

OE.SO_PICKING_HEADERS_ALL is referenced by following:

APPS: SO_PICKING_HEADERS_ALL