VIEW: OE.SO_PICKING_LINE_DETAILS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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