VIEW: OKS.OKS_SUBLINES_TEMP#

Source

View Text - Preformatted

select ID ID, CLE_ID CLE_ID, DNZ_CHR_ID DNZ_CHR_ID, LINE_NUMBER LINE_NUMBER, LSE_ID LSE_ID, CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID, NAME NAME, DESCRIPTION DESCRIPTION, SERIAL_NUMBER SERIAL_NUMBER, STATUS STATUS, STE_CODE STE_CODE, NEW_STATUS NEW_STATUS, NEW_STE_CODE NEW_STE_CODE, REASON_CODE REASON_CODE, COMMENTS COMMENTS, START_DATE START_DATE, END_DATE END_DATE, PRICE_NEGOTIATED PRICE_NEGOTIATED, TOP_LVL_PARENT TOP_LVL_PARENT, SELECT_FLAG SELECT_FLAG, MODIFIED_FLAG MODIFIED_FLAG, COMMIT_FLAG COMMIT_FLAG, SAVED_FLAG SAVED_FLAG, PRICE_CHANGE_FLAG PRICE_CHANGE_FLAG, STATUS_CHANGE_FLAG STATUS_CHANGE_FLAG, START_DT_EFF_CHANGE_FLAG START_DT_EFF_CHANGE_FLAG, END_DT_EFF_CHANGE_FLAG END_DT_EFF_CHANGE_FLAG, START_DT_ERROR_FLAG START_DT_ERROR_FLAG, END_DT_ERROR_FLAG END_DT_ERROR_FLAG, STATUS_ERROR_FLAG STATUS_ERROR_FLAG, ERROR_MESSAGE ERROR_MESSAGE, OLD_START_DATE OLD_START_DATE, OLD_END_DATE OLD_END_DATE, OLD_PRICE_NEGOTIATED OLD_PRICE_NEGOTIATED, OLD_STATUS OLD_STATUS, OLD_STE_CODE OLD_STE_CODE, ST_DT_ERR_MESSAGE ST_DT_ERR_MESSAGE, END_DT_ERR_MESSAGE END_DT_ERR_MESSAGE, STATUS_ERR_MESSAGE STATUS_ERR_MESSAGE, ID_CHAR ID_CHAR, CLE_ID_CHAR CLE_ID_CHAR, DNZ_CHR_ID_CHAR DNZ_CHR_ID_CHAR, UNDO_STATUS UNDO_STATUS, UNDO_START_DATE UNDO_START_DATE, UNDO_END_DATE UNDO_END_DATE, UNDO_PRICE_NEGOTIATED UNDO_PRICE_NEGOTIATED, SYSTEM_NAME SYSTEM_NAME, CASCADE_FLAG CASCADE_FLAG from "OKS"."OKS_SUBLINES_TEMP"

View Text - HTML Formatted

SELECT ID ID
, CLE_ID CLE_ID
, DNZ_CHR_ID DNZ_CHR_ID
, LINE_NUMBER LINE_NUMBER
, LSE_ID LSE_ID
, CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID
, NAME NAME
, DESCRIPTION DESCRIPTION
, SERIAL_NUMBER SERIAL_NUMBER
, STATUS STATUS
, STE_CODE STE_CODE
, NEW_STATUS NEW_STATUS
, NEW_STE_CODE NEW_STE_CODE
, REASON_CODE REASON_CODE
, COMMENTS COMMENTS
, START_DATE START_DATE
, END_DATE END_DATE
, PRICE_NEGOTIATED PRICE_NEGOTIATED
, TOP_LVL_PARENT TOP_LVL_PARENT
, SELECT_FLAG SELECT_FLAG
, MODIFIED_FLAG MODIFIED_FLAG
, COMMIT_FLAG COMMIT_FLAG
, SAVED_FLAG SAVED_FLAG
, PRICE_CHANGE_FLAG PRICE_CHANGE_FLAG
, STATUS_CHANGE_FLAG STATUS_CHANGE_FLAG
, START_DT_EFF_CHANGE_FLAG START_DT_EFF_CHANGE_FLAG
, END_DT_EFF_CHANGE_FLAG END_DT_EFF_CHANGE_FLAG
, START_DT_ERROR_FLAG START_DT_ERROR_FLAG
, END_DT_ERROR_FLAG END_DT_ERROR_FLAG
, STATUS_ERROR_FLAG STATUS_ERROR_FLAG
, ERROR_MESSAGE ERROR_MESSAGE
, OLD_START_DATE OLD_START_DATE
, OLD_END_DATE OLD_END_DATE
, OLD_PRICE_NEGOTIATED OLD_PRICE_NEGOTIATED
, OLD_STATUS OLD_STATUS
, OLD_STE_CODE OLD_STE_CODE
, ST_DT_ERR_MESSAGE ST_DT_ERR_MESSAGE
, END_DT_ERR_MESSAGE END_DT_ERR_MESSAGE
, STATUS_ERR_MESSAGE STATUS_ERR_MESSAGE
, ID_CHAR ID_CHAR
, CLE_ID_CHAR CLE_ID_CHAR
, DNZ_CHR_ID_CHAR DNZ_CHR_ID_CHAR
, UNDO_STATUS UNDO_STATUS
, UNDO_START_DATE UNDO_START_DATE
, UNDO_END_DATE UNDO_END_DATE
, UNDO_PRICE_NEGOTIATED UNDO_PRICE_NEGOTIATED
, SYSTEM_NAME SYSTEM_NAME
, CASCADE_FLAG CASCADE_FLAG
FROM "OKS"."OKS_SUBLINES_TEMP"