VIEW: APPS.WMS_WP_LINES_GTMP_V

Source

View Text - Preformatted

SELECT "DELIVER_TO","DELIVERY","EXCEPTION_ID","ITEM","LINE_STATUS","LINE_PROGRESS","ORDER_NUMBER","SOURCE_LINE_NUMBER","REQUESTED_QTY","PLANNED_FILL_RATE","RELEASE_FILL_RATE","PICK_FILL_RATE","SHIP_TO","SHIPPED_QTY","DATE_SCHEDULED","BATCH","CARRIER","CONTACT","CUSTOMER_MODEL_SERIAL_NUMBER","DATE_REQUESTED","DELIVER_TO_CONTACT","DELIVER_TO_CUSTOMER","DELIVERED_QTY","EARLIEST_DELIVERY_DATE","EARLIEST_SHIP_DATE","FOB","FREIGHT_TERMS","GRADE","GROSS_WEIGHT","HAZARD_CLASS","IGNORE_FOR_PLANNING","INSPECTION_STATUS","INTERMEDIATE_SHIP_TO","INTERMEDIATE_SHIP_TO_CONTACT","ITEM_DESCRIPTION","LATEST_DELIVERY_DATE","LOADING_SEQUENCE","LOCATOR","LOT","MAX_LOAD_WEIGHT","MAX_VOLUME","MIN_FILL_PERCENT","MODE_OF_TRANSPORT","NET_WEIGHT","ORDER_TYPE","ORG_NAME","PACKING_INSTRUCTIONS","REQUESTED_QTY_UOM","REVISION","SEAL_CODE","SECONDARY_DELIVERED_QTY","SECONDARY_REQUESTED_QTY","SECONDARY_REQUESTED_QTY_UOM","SECONDARY_SHIPPED_QTY","SECONDARY_SRC_REQ_QTY","SECONDARY_SRC_REQ_QTY_UOM","SERVICE_LEVEL","SHIP_METHOD","SHIP_MODEL_COMPLETE","SHIP_SET","SHIP_TO_CONTACT","SHIP_TO_CUSTOMER","SHIPMENT_PRIORITY","SHIPPING_INSTRUCTIONS","SOURCE_REQUESTED_QTY","SOURCE_REQUESTED_QTY_UOM","TARE_WEIGHT","TASK_NUMBER","TRACKING_NUMBER","UNIT_NUMBER","VOLUME","VOLUME_UOM","WEIGHT_UOM","CUSTOMER","PROJECT","CUSTOMER_CLASS","TRIP","REMOVE_FROM_WAVE_FLAG","WAVE_FIRMED_FLAG","MESSAGE" FROM wms_wp_lines_gtmp
   
   

View Text - HTML Formatted

SELECT "DELIVER_TO"
, "DELIVERY"
, "EXCEPTION_ID"
, "ITEM"
, "LINE_STATUS"
, "LINE_PROGRESS"
, "ORDER_NUMBER"
, "SOURCE_LINE_NUMBER"
, "REQUESTED_QTY"
, "PLANNED_FILL_RATE"
, "RELEASE_FILL_RATE"
, "PICK_FILL_RATE"
, "SHIP_TO"
, "SHIPPED_QTY"
, "DATE_SCHEDULED"
, "BATCH"
, "CARRIER"
, "CONTACT"
, "CUSTOMER_MODEL_SERIAL_NUMBER"
, "DATE_REQUESTED"
, "DELIVER_TO_CONTACT"
, "DELIVER_TO_CUSTOMER"
, "DELIVERED_QTY"
, "EARLIEST_DELIVERY_DATE"
, "EARLIEST_SHIP_DATE"
, "FOB"
, "FREIGHT_TERMS"
, "GRADE"
, "GROSS_WEIGHT"
, "HAZARD_CLASS"
, "IGNORE_FOR_PLANNING"
, "INSPECTION_STATUS"
, "INTERMEDIATE_SHIP_TO"
, "INTERMEDIATE_SHIP_TO_CONTACT"
, "ITEM_DESCRIPTION"
, "LATEST_DELIVERY_DATE"
, "LOADING_SEQUENCE"
, "LOCATOR"
, "LOT"
, "MAX_LOAD_WEIGHT"
, "MAX_VOLUME"
, "MIN_FILL_PERCENT"
, "MODE_OF_TRANSPORT"
, "NET_WEIGHT"
, "ORDER_TYPE"
, "ORG_NAME"
, "PACKING_INSTRUCTIONS"
, "REQUESTED_QTY_UOM"
, "REVISION"
, "SEAL_CODE"
, "SECONDARY_DELIVERED_QTY"
, "SECONDARY_REQUESTED_QTY"
, "SECONDARY_REQUESTED_QTY_UOM"
, "SECONDARY_SHIPPED_QTY"
, "SECONDARY_SRC_REQ_QTY"
, "SECONDARY_SRC_REQ_QTY_UOM"
, "SERVICE_LEVEL"
, "SHIP_METHOD"
, "SHIP_MODEL_COMPLETE"
, "SHIP_SET"
, "SHIP_TO_CONTACT"
, "SHIP_TO_CUSTOMER"
, "SHIPMENT_PRIORITY"
, "SHIPPING_INSTRUCTIONS"
, "SOURCE_REQUESTED_QTY"
, "SOURCE_REQUESTED_QTY_UOM"
, "TARE_WEIGHT"
, "TASK_NUMBER"
, "TRACKING_NUMBER"
, "UNIT_NUMBER"
, "VOLUME"
, "VOLUME_UOM"
, "WEIGHT_UOM"
, "CUSTOMER"
, "PROJECT"
, "CUSTOMER_CLASS"
, "TRIP"
, "REMOVE_FROM_WAVE_FLAG"
, "WAVE_FIRMED_FLAG"
, "MESSAGE"
FROM WMS_WP_LINES_GTMP