VIEW: XDP.XDP_OE_ORDER_HEADERS#

Source

View Text - Preformatted

select ORDER_NUMBER ORDER_NUMBER, ORDER_VERSION ORDER_VERSION, PROVISIONING_DATE PROVISIONING_DATE, COMPLETION_DATE COMPLETION_DATE, ORDER_TYPE ORDER_TYPE, ORDER_ACTION ORDER_ACTION, ORDER_SOURCE ORDER_SOURCE, PRIORITY PRIORITY, STATUS STATUS, SDP_ORDER_ID SDP_ORDER_ID, DUE_DATE DUE_DATE, CUSTOMER_REQUIRED_DATE CUSTOMER_REQUIRED_DATE, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_ID CUSTOMER_ID, ORG_ID ORG_ID, SERVICE_PROVIDER_ID SERVICE_PROVIDER_ID, TELEPHONE_NUMBER TELEPHONE_NUMBER, RELATED_ORDER_ID RELATED_ORDER_ID, ORDER_COMMENT ORDER_COMMENT, JEOPARDY_ENABLED_FLAG JEOPARDY_ENABLED_FLAG, ORDER_REF_NAME ORDER_REF_NAME, ORDER_REF_VALUE ORDER_REF_VALUE, SP_ORDER_NUMBER SP_ORDER_NUMBER, SP_USERID SP_USERID, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SECURITY_GROUP_ID SECURITY_GROUP_ID from "XDP"."XDP_OE_ORDER_HEADERS"

View Text - HTML Formatted

SELECT ORDER_NUMBER ORDER_NUMBER
, ORDER_VERSION ORDER_VERSION
, PROVISIONING_DATE PROVISIONING_DATE
, COMPLETION_DATE COMPLETION_DATE
, ORDER_TYPE ORDER_TYPE
, ORDER_ACTION ORDER_ACTION
, ORDER_SOURCE ORDER_SOURCE
, PRIORITY PRIORITY
, STATUS STATUS
, SDP_ORDER_ID SDP_ORDER_ID
, DUE_DATE DUE_DATE
, CUSTOMER_REQUIRED_DATE CUSTOMER_REQUIRED_DATE
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_ID CUSTOMER_ID
, ORG_ID ORG_ID
, SERVICE_PROVIDER_ID SERVICE_PROVIDER_ID
, TELEPHONE_NUMBER TELEPHONE_NUMBER
, RELATED_ORDER_ID RELATED_ORDER_ID
, ORDER_COMMENT ORDER_COMMENT
, JEOPARDY_ENABLED_FLAG JEOPARDY_ENABLED_FLAG
, ORDER_REF_NAME ORDER_REF_NAME
, ORDER_REF_VALUE ORDER_REF_VALUE
, SP_ORDER_NUMBER SP_ORDER_NUMBER
, SP_USERID SP_USERID
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "XDP"."XDP_OE_ORDER_HEADERS"