VIEW: WSH.WSH_UPGRADE_PLD_TMP#

Source

View Text - Preformatted

select PICKING_LINE_DETAIL_ID PICKING_LINE_DETAIL_ID, HEADER_ID HEADER_ID, LINE_ID LINE_ID, LINE_DETAIL_ID LINE_DETAIL_ID, PICKING_LINE_ID PICKING_LINE_ID, ORDER_NUMBER ORDER_NUMBER, ORDER_TYPE_ID ORDER_TYPE_ID, NAME NAME, PURCHASE_ORDER_NUM PURCHASE_ORDER_NUM, CUSTOMER_ID CUSTOMER_ID, ORDERED_BY_CONTACT_ID ORDERED_BY_CONTACT_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, SHIP_SET_NUMBER SHIP_SET_NUMBER, PARENT_LINE_ID PARENT_LINE_ID, ATO_LINE_ID ATO_LINE_ID, SHIP_MODEL_COMPLETE_FLAG SHIP_MODEL_COMPLETE_FLAG, WAREHOUSE_ID WAREHOUSE_ID, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID, INTERMEDIATE_SHIP_TO_ID INTERMEDIATE_SHIP_TO_ID, SHIPPED_QUANTITY SHIPPED_QUANTITY, UNIT_CODE UNIT_CODE, SUBINVENTORY SUBINVENTORY, REVISION REVISION, LOT_NUMBER LOT_NUMBER, CUSTOMER_REQUESTED_LOT_FLAG CUSTOMER_REQUESTED_LOT_FLAG, SERIAL_NUMBER SERIAL_NUMBER, INVENTORY_LOCATION_ID INVENTORY_LOCATION_ID, DATE_REQUESTED_CURRENT DATE_REQUESTED_CURRENT, SCHEDULE_DATE SCHEDULE_DATE, MASTER_CONTAINER_ITEM_ID MASTER_CONTAINER_ITEM_ID, DETAIL_CONTAINER_ITEM_ID DETAIL_CONTAINER_ITEM_ID, LOAD_SEQ_NUMBER LOAD_SEQ_NUMBER, SHIP_METHOD_CODE SHIP_METHOD_CODE, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE, FOB_CODE FOB_CODE, CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID, DEP_PLAN_REQUIRED_FLAG DEP_PLAN_REQUIRED_FLAG, PLANNING_PROD_SEQ_NUMBER PLANNING_PROD_SEQ_NUMBER, CUSTOMER_DOCK_CODE CUSTOMER_DOCK_CODE, MVT_STAT_STATUS MVT_STAT_STATUS, DELIVERY DELIVERY, 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, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, DELIVERY_ID DELIVERY_ID, 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, CURRENCY_CODE CURRENCY_CODE, LIST_PRICE LIST_PRICE, ORG_ID ORG_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID from "WSH"."WSH_UPGRADE_PLD_TMP"

View Text - HTML Formatted

SELECT PICKING_LINE_DETAIL_ID PICKING_LINE_DETAIL_ID
, HEADER_ID HEADER_ID
, LINE_ID LINE_ID
, LINE_DETAIL_ID LINE_DETAIL_ID
, PICKING_LINE_ID PICKING_LINE_ID
, ORDER_NUMBER ORDER_NUMBER
, ORDER_TYPE_ID ORDER_TYPE_ID
, NAME NAME
, PURCHASE_ORDER_NUM PURCHASE_ORDER_NUM
, CUSTOMER_ID CUSTOMER_ID
, ORDERED_BY_CONTACT_ID ORDERED_BY_CONTACT_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SHIP_SET_NUMBER SHIP_SET_NUMBER
, PARENT_LINE_ID PARENT_LINE_ID
, ATO_LINE_ID ATO_LINE_ID
, SHIP_MODEL_COMPLETE_FLAG SHIP_MODEL_COMPLETE_FLAG
, WAREHOUSE_ID WAREHOUSE_ID
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID
, INTERMEDIATE_SHIP_TO_ID INTERMEDIATE_SHIP_TO_ID
, SHIPPED_QUANTITY SHIPPED_QUANTITY
, UNIT_CODE UNIT_CODE
, SUBINVENTORY SUBINVENTORY
, REVISION REVISION
, LOT_NUMBER LOT_NUMBER
, CUSTOMER_REQUESTED_LOT_FLAG CUSTOMER_REQUESTED_LOT_FLAG
, SERIAL_NUMBER SERIAL_NUMBER
, INVENTORY_LOCATION_ID INVENTORY_LOCATION_ID
, DATE_REQUESTED_CURRENT DATE_REQUESTED_CURRENT
, SCHEDULE_DATE SCHEDULE_DATE
, MASTER_CONTAINER_ITEM_ID MASTER_CONTAINER_ITEM_ID
, DETAIL_CONTAINER_ITEM_ID DETAIL_CONTAINER_ITEM_ID
, LOAD_SEQ_NUMBER LOAD_SEQ_NUMBER
, SHIP_METHOD_CODE SHIP_METHOD_CODE
, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE
, FOB_CODE FOB_CODE
, CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID
, DEP_PLAN_REQUIRED_FLAG DEP_PLAN_REQUIRED_FLAG
, PLANNING_PROD_SEQ_NUMBER PLANNING_PROD_SEQ_NUMBER
, CUSTOMER_DOCK_CODE CUSTOMER_DOCK_CODE
, MVT_STAT_STATUS MVT_STAT_STATUS
, DELIVERY DELIVERY
, 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
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, DELIVERY_ID DELIVERY_ID
, 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
, CURRENCY_CODE CURRENCY_CODE
, LIST_PRICE LIST_PRICE
, ORG_ID ORG_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
FROM "WSH"."WSH_UPGRADE_PLD_TMP"