VIEW: OE.SO_PICKING_LINES_ALL#

Source

View Text - Preformatted

select PICKING_LINE_ID PICKING_LINE_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, 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_HEADER_ID PICKING_HEADER_ID, SEQUENCE_NUMBER SEQUENCE_NUMBER, ORDER_LINE_ID ORDER_LINE_ID, COMPONENT_CODE COMPONENT_CODE, LINE_DETAIL_ID LINE_DETAIL_ID, COMPONENT_RATIO COMPONENT_RATIO, REQUESTED_QUANTITY REQUESTED_QUANTITY, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, INCLUDED_ITEM_FLAG INCLUDED_ITEM_FLAG, DATE_REQUESTED DATE_REQUESTED, ORIGINAL_REQUESTED_QUANTITY ORIGINAL_REQUESTED_QUANTITY, WAREHOUSE_ID WAREHOUSE_ID, SHIPPED_QUANTITY SHIPPED_QUANTITY, CANCELLED_QUANTITY CANCELLED_QUANTITY, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE, SHIP_METHOD_CODE SHIP_METHOD_CODE, DATE_CONFIRMED DATE_CONFIRMED, RA_INTERFACE_STATUS RA_INTERFACE_STATUS, SERVICE_INTERFACE_STATUS SERVICE_INTERFACE_STATUS, INVOICED_QUANTITY INVOICED_QUANTITY, INVENTORY_STATUS INVENTORY_STATUS, UNIT_CODE UNIT_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, SCHEDULE_DATE SCHEDULE_DATE, DEMAND_CLASS_CODE DEMAND_CLASS_CODE, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID, CONFIGURATION_ITEM_FLAG CONFIGURATION_ITEM_FLAG, LATEST_ACCEPTABLE_DATE LATEST_ACCEPTABLE_DATE, MOVEMENT_ID MOVEMENT_ID, ORG_ID ORG_ID, TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID, BO_PICKING_LINE_ID BO_PICKING_LINE_ID, DEP_PLAN_REQUIRED_FLAG DEP_PLAN_REQUIRED_FLAG, CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID from "OE"."SO_PICKING_LINES_ALL"

View Text - HTML Formatted

SELECT PICKING_LINE_ID PICKING_LINE_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, 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_HEADER_ID PICKING_HEADER_ID
, SEQUENCE_NUMBER SEQUENCE_NUMBER
, ORDER_LINE_ID ORDER_LINE_ID
, COMPONENT_CODE COMPONENT_CODE
, LINE_DETAIL_ID LINE_DETAIL_ID
, COMPONENT_RATIO COMPONENT_RATIO
, REQUESTED_QUANTITY REQUESTED_QUANTITY
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, INCLUDED_ITEM_FLAG INCLUDED_ITEM_FLAG
, DATE_REQUESTED DATE_REQUESTED
, ORIGINAL_REQUESTED_QUANTITY ORIGINAL_REQUESTED_QUANTITY
, WAREHOUSE_ID WAREHOUSE_ID
, SHIPPED_QUANTITY SHIPPED_QUANTITY
, CANCELLED_QUANTITY CANCELLED_QUANTITY
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID
, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE
, SHIP_METHOD_CODE SHIP_METHOD_CODE
, DATE_CONFIRMED DATE_CONFIRMED
, RA_INTERFACE_STATUS RA_INTERFACE_STATUS
, SERVICE_INTERFACE_STATUS SERVICE_INTERFACE_STATUS
, INVOICED_QUANTITY INVOICED_QUANTITY
, INVENTORY_STATUS INVENTORY_STATUS
, UNIT_CODE UNIT_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
, SCHEDULE_DATE SCHEDULE_DATE
, DEMAND_CLASS_CODE DEMAND_CLASS_CODE
, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, CONFIGURATION_ITEM_FLAG CONFIGURATION_ITEM_FLAG
, LATEST_ACCEPTABLE_DATE LATEST_ACCEPTABLE_DATE
, MOVEMENT_ID MOVEMENT_ID
, ORG_ID ORG_ID
, TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID
, BO_PICKING_LINE_ID BO_PICKING_LINE_ID
, DEP_PLAN_REQUIRED_FLAG DEP_PLAN_REQUIRED_FLAG
, CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID
FROM "OE"."SO_PICKING_LINES_ALL"