VIEW: XDP.XDP_OE_ORDER_LINES#

Source

View Text - Preformatted

select ORDER_NUMBER ORDER_NUMBER, ORDER_VERSION ORDER_VERSION, LINE_NUMBER LINE_NUMBER, LINE_ITEM_NAME LINE_ITEM_NAME, LINE_ITEM_VERSION LINE_ITEM_VERSION, LINE_ITEM_ACTION LINE_ITEM_ACTION, PROVISIONING_REQUIRED_FLAG PROVISIONING_REQUIRED_FLAG, IS_WORKITEM_FLAG IS_WORKITEM_FLAG, LINE_ITEM_TYPE LINE_ITEM_TYPE, STATUS STATUS, PROVISIONING_SEQUENCE PROVISIONING_SEQUENCE, PRIORITY PRIORITY, PROVISIONING_DATE PROVISIONING_DATE, DUE_DATE DUE_DATE, CUSTOMER_REQUIRED_DATE CUSTOMER_REQUIRED_DATE, COMPLETION_DATE COMPLETION_DATE, BUNDLE_ID BUNDLE_ID, BUNDLE_SEQUENCE BUNDLE_SEQUENCE, JEOPARDY_ENABLED_FLAG JEOPARDY_ENABLED_FLAG, STARTING_NUMBER STARTING_NUMBER, ENDING_NUMBER ENDING_NUMBER, 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_LINES"

View Text - HTML Formatted

SELECT ORDER_NUMBER ORDER_NUMBER
, ORDER_VERSION ORDER_VERSION
, LINE_NUMBER LINE_NUMBER
, LINE_ITEM_NAME LINE_ITEM_NAME
, LINE_ITEM_VERSION LINE_ITEM_VERSION
, LINE_ITEM_ACTION LINE_ITEM_ACTION
, PROVISIONING_REQUIRED_FLAG PROVISIONING_REQUIRED_FLAG
, IS_WORKITEM_FLAG IS_WORKITEM_FLAG
, LINE_ITEM_TYPE LINE_ITEM_TYPE
, STATUS STATUS
, PROVISIONING_SEQUENCE PROVISIONING_SEQUENCE
, PRIORITY PRIORITY
, PROVISIONING_DATE PROVISIONING_DATE
, DUE_DATE DUE_DATE
, CUSTOMER_REQUIRED_DATE CUSTOMER_REQUIRED_DATE
, COMPLETION_DATE COMPLETION_DATE
, BUNDLE_ID BUNDLE_ID
, BUNDLE_SEQUENCE BUNDLE_SEQUENCE
, JEOPARDY_ENABLED_FLAG JEOPARDY_ENABLED_FLAG
, STARTING_NUMBER STARTING_NUMBER
, ENDING_NUMBER ENDING_NUMBER
, 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_LINES"