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

TABLE: OE.SO_PICKING_LINE_DETAILS

Object Details
Object Name: SO_PICKING_LINE_DETAILS
Object Type: TABLE
Owner: OE
FND Design Data: TableOE.SO_PICKING_LINE_DETAILS
Subobject Name:
Status: VALID


SO_PICKING_LINE_DETAILS stores only the lot, inventory name, and
inventory location for picking lines that have been reserved. The
REQUESTED_QUANTITY must equal the picking line's REQUESTED_QUANTITY.
CUSTOMER_REQUESTED_LOT_FLAG distinguishes between lots that have been
assigned by Order Entry/Shipping and lots that have been requested
by customers.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SO_PICKING_LINE_DETAILS_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnPICKING_LINE_DETAIL_ID
SO_PICKING_LINE_DETAILS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnPICKING_LINE_ID
SO_PICKING_LINE_DETAILS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnDPW_ASSIGNED_FLAG
SO_PICKING_LINE_DETAILS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnDELIVERY_ID
SO_PICKING_LINE_DETAILS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnDEPARTURE_ID
SO_PICKING_LINE_DETAILS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnPICK_SLIP_NUMBER
SO_PICKING_LINE_DETAILS_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnCONTAINER_ID
Columns
Name Datatype Length Mandatory Comments
PICKING_LINE_DETAIL_ID NUMBER
Yes System-generated ID
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
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_LINE_ID NUMBER
Yes Picking line associated with this detail
WAREHOUSE_ID NUMBER
Yes Warehouse (Organization)
REQUESTED_QUANTITY NUMBER
Yes Total requested quantity for this release
SHIPPED_QUANTITY NUMBER

Total shipped quantity for this release
SERIAL_NUMBER VARCHAR2 (30)
Serial number of item (on picking line)
LOT_NUMBER VARCHAR2 (30)
Lot number for this detail; completed if the item is under inventory lot control
CUSTOMER_REQUESTED_LOT_FLAG VARCHAR2 (1)
Indicates the customer specified the lot, rather than pick release rules
REVISION VARCHAR2 (3)
Revision of item (on picking line)
SUBINVENTORY VARCHAR2 (10)
Inventory subinventory assigned to this detail
INVENTORY_LOCATION_ID NUMBER

Location of item in warehouse
SEGMENT1 VARCHAR2 (40)
Key flexfield segment
SEGMENT2 VARCHAR2 (40)
Key flexfield segment
SEGMENT3 VARCHAR2 (40)
Key flexfield segment
SEGMENT4 VARCHAR2 (40)
Key flexfield segment
SEGMENT5 VARCHAR2 (40)
Key flexfield segment
SEGMENT6 VARCHAR2 (40)
Key flexfield segment
SEGMENT7 VARCHAR2 (40)
Key flexfield segment
SEGMENT8 VARCHAR2 (40)
Key flexfield segment
SEGMENT9 VARCHAR2 (40)
Key flexfield segment
SEGMENT10 VARCHAR2 (40)
Key flexfield segment
SEGMENT11 VARCHAR2 (40)
Key flexfield segment
SEGMENT12 VARCHAR2 (40)
Key flexfield segment
SEGMENT13 VARCHAR2 (40)
Key flexfield segment
SEGMENT14 VARCHAR2 (40)
Key flexfield segment
SEGMENT15 VARCHAR2 (40)
Key flexfield segment
SEGMENT16 VARCHAR2 (40)
Key flexfield segment
SEGMENT17 VARCHAR2 (40)
Key flexfield segment
SEGMENT18 VARCHAR2 (40)
Key flexfield segment
SEGMENT19 VARCHAR2 (40)
Key flexfield segment
SEGMENT20 VARCHAR2 (40)
Key flexfield segment
INVENTORY_LOCATION_SEGMENTS VARCHAR2 (240)
Concatenated flexfield description for inventory locator flexfield
DETAIL_TYPE_CODE VARCHAR2 (30)
Indicates if record was created in programs or forms
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
RELEASED_FLAG VARCHAR2 (1)
Released indicator
SCHEDULE_DATE DATE

Schedule date
SCHEDULE_LEVEL NUMBER

Schedule level
SCHEDULE_STATUS_CODE VARCHAR2 (30)
Schedule status
DEMAND_ID NUMBER

Demand identifier
AUTOSCHEDULED_FLAG VARCHAR2 (1)
Autoscheduled indicator
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
DEMAND_CLASS_CODE VARCHAR2 (30)
Demand class
RESERVABLE_FLAG VARCHAR2 (1)
Indicator whether item is reservable in warehouse (organization)
TRANSACTABLE_FLAG VARCHAR2 (1)
Indicator whether item is transactable in warehouse (organization)
LATEST_ACCEPTABLE_DATE DATE

Not used
DPW_ASSIGNED_FLAG VARCHAR2 (1)
Departure Assigned flag
DELIVERY_ID NUMBER

Foreign key to WSH_DELIVERIES
DEPARTURE_ID NUMBER

Foreign key to WSH_DELIVERIES
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)
TRANSACTION_TEMP_ID NUMBER

Foreign key to Inventory Transaction Temp tables
PICK_SLIP_NUMBER NUMBER

Pick slip number
CONTAINER_ID NUMBER

Container identifier
MOVEMENT_ID NUMBER

Movement statistics identifier
MVT_STAT_STATUS VARCHAR2 (30)
PROCESSED_FLAG VARCHAR2 (1)
Query Text

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


SELECT PICKING_LINE_DETAIL_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      PICKING_LINE_ID
,      WAREHOUSE_ID
,      REQUESTED_QUANTITY
,      SHIPPED_QUANTITY
,      SERIAL_NUMBER
,      LOT_NUMBER
,      CUSTOMER_REQUESTED_LOT_FLAG
,      REVISION
,      SUBINVENTORY
,      INVENTORY_LOCATION_ID
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      INVENTORY_LOCATION_SEGMENTS
,      DETAIL_TYPE_CODE
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      RELEASED_FLAG
,      SCHEDULE_DATE
,      SCHEDULE_LEVEL
,      SCHEDULE_STATUS_CODE
,      DEMAND_ID
,      AUTOSCHEDULED_FLAG
,      DELIVERY
,      WIP_RESERVED_QUANTITY
,      WIP_COMPLETED_QUANTITY
,      SUPPLY_SOURCE_TYPE
,      SUPPLY_SOURCE_HEADER_ID
,      UPDATE_FLAG
,      DEMAND_CLASS_CODE
,      RESERVABLE_FLAG
,      TRANSACTABLE_FLAG
,      LATEST_ACCEPTABLE_DATE
,      DPW_ASSIGNED_FLAG
,      DELIVERY_ID
,      DEPARTURE_ID
,      LOAD_SEQ_NUMBER
,      MASTER_CONTAINER_ITEM_ID
,      DETAIL_CONTAINER_ITEM_ID
,      TRANSACTION_TEMP_ID
,      PICK_SLIP_NUMBER
,      CONTAINER_ID
,      MOVEMENT_ID
,      MVT_STAT_STATUS
,      PROCESSED_FLAG
FROM OE.SO_PICKING_LINE_DETAILS;

Dependencies

[top of page]

OE.SO_PICKING_LINE_DETAILS does not reference any database object

OE.SO_PICKING_LINE_DETAILS is referenced by following:

SchemaOE
ViewSO_PICKING_LINE_DETAILS#