VIEW: GMP.RH_DORD_IMP#

Source

View Text - Preformatted

select IMPORT_ID IMPORT_ID, LINE_ID LINE_ID, LINE_NO LINE_NO, PROCESS_ID PROCESS_ID, ORGN_CODE ORGN_CODE, DOC_TYPE DOC_TYPE, ORDER_NO ORDER_NO, OLD_ORDER_QTY OLD_ORDER_QTY, ORDER_QTY ORDER_QTY, OLD_SCHED_DATE OLD_SCHED_DATE, SCHED_DATE SCHED_DATE, OLD_PRIORITY OLD_PRIORITY, PRIORITY PRIORITY, NEW_DOC_TYPE NEW_DOC_TYPE, NEW_DOC_ID NEW_DOC_ID, ACTION_TYPE ACTION_TYPE, OLD_ORDER_UOM OLD_ORDER_UOM, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE from "GMP"."RH_DORD_IMP"

View Text - HTML Formatted

SELECT IMPORT_ID IMPORT_ID
, LINE_ID LINE_ID
, LINE_NO LINE_NO
, PROCESS_ID PROCESS_ID
, ORGN_CODE ORGN_CODE
, DOC_TYPE DOC_TYPE
, ORDER_NO ORDER_NO
, OLD_ORDER_QTY OLD_ORDER_QTY
, ORDER_QTY ORDER_QTY
, OLD_SCHED_DATE OLD_SCHED_DATE
, SCHED_DATE SCHED_DATE
, OLD_PRIORITY OLD_PRIORITY
, PRIORITY PRIORITY
, NEW_DOC_TYPE NEW_DOC_TYPE
, NEW_DOC_ID NEW_DOC_ID
, ACTION_TYPE ACTION_TYPE
, OLD_ORDER_UOM OLD_ORDER_UOM
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
FROM "GMP"."RH_DORD_IMP"