VIEW: ONT.OE_UPGRADE_WSH_IFACE#

Source

View Text - Preformatted

select LINE_DETAIL_ID LINE_DETAIL_ID, 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, LINE_ID LINE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, INCLUDED_ITEM_FLAG INCLUDED_ITEM_FLAG, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID, COMPONENT_CODE COMPONENT_CODE, SHIPPABLE_FLAG SHIPPABLE_FLAG, TRANSACTABLE_FLAG TRANSACTABLE_FLAG, RESERVABLE_FLAG RESERVABLE_FLAG, UNIT_CODE UNIT_CODE, RELEASED_FLAG RELEASED_FLAG, REQUIRED_FOR_REVENUE_FLAG REQUIRED_FOR_REVENUE_FLAG, QUANTITY QUANTITY, WAREHOUSE_ID WAREHOUSE_ID, SUBINVENTORY SUBINVENTORY, DEMAND_CLASS_CODE DEMAND_CLASS_CODE, SCHEDULE_DATE SCHEDULE_DATE, REVISION REVISION, SCHEDULE_STATUS_CODE SCHEDULE_STATUS_CODE, SCHEDULE_LEVEL_CODE SCHEDULE_LEVEL_CODE, INVENTORY_LOCATION_ID INVENTORY_LOCATION_ID, CONFIGURATION_ITEM_FLAG CONFIGURATION_ITEM_FLAG, LATEST_ACCEPTABLE_DATE LATEST_ACCEPTABLE_DATE, DEP_PLAN_REQUIRED_FLAG DEP_PLAN_REQUIRED_FLAG, DPW_ASSIGNED_FLAG DPW_ASSIGNED_FLAG, CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID, DEPARTURE_ID DEPARTURE_ID, 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, SHIPPED_QUANTITY SHIPPED_QUANTITY, SHIP_METHOD_CODE SHIP_METHOD_CODE, ACTUAL_DEPARTURE_DATE ACTUAL_DEPARTURE_DATE, DELIVERY DELIVERY, INVOICED_QUANTITY INVOICED_QUANTITY, RECEIPT_STATUS_CODE RECEIPT_STATUS_CODE from "ONT"."OE_UPGRADE_WSH_IFACE"

View Text - HTML Formatted

SELECT LINE_DETAIL_ID LINE_DETAIL_ID
, 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
, LINE_ID LINE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, INCLUDED_ITEM_FLAG INCLUDED_ITEM_FLAG
, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, COMPONENT_CODE COMPONENT_CODE
, SHIPPABLE_FLAG SHIPPABLE_FLAG
, TRANSACTABLE_FLAG TRANSACTABLE_FLAG
, RESERVABLE_FLAG RESERVABLE_FLAG
, UNIT_CODE UNIT_CODE
, RELEASED_FLAG RELEASED_FLAG
, REQUIRED_FOR_REVENUE_FLAG REQUIRED_FOR_REVENUE_FLAG
, QUANTITY QUANTITY
, WAREHOUSE_ID WAREHOUSE_ID
, SUBINVENTORY SUBINVENTORY
, DEMAND_CLASS_CODE DEMAND_CLASS_CODE
, SCHEDULE_DATE SCHEDULE_DATE
, REVISION REVISION
, SCHEDULE_STATUS_CODE SCHEDULE_STATUS_CODE
, SCHEDULE_LEVEL_CODE SCHEDULE_LEVEL_CODE
, INVENTORY_LOCATION_ID INVENTORY_LOCATION_ID
, CONFIGURATION_ITEM_FLAG CONFIGURATION_ITEM_FLAG
, LATEST_ACCEPTABLE_DATE LATEST_ACCEPTABLE_DATE
, DEP_PLAN_REQUIRED_FLAG DEP_PLAN_REQUIRED_FLAG
, DPW_ASSIGNED_FLAG DPW_ASSIGNED_FLAG
, CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID
, DEPARTURE_ID DEPARTURE_ID
, 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
, SHIPPED_QUANTITY SHIPPED_QUANTITY
, SHIP_METHOD_CODE SHIP_METHOD_CODE
, ACTUAL_DEPARTURE_DATE ACTUAL_DEPARTURE_DATE
, DELIVERY DELIVERY
, INVOICED_QUANTITY INVOICED_QUANTITY
, RECEIPT_STATUS_CODE RECEIPT_STATUS_CODE
FROM "ONT"."OE_UPGRADE_WSH_IFACE"