VIEW: OKC.OKC_K_LINES_B#

Source

View Text - Preformatted

select ID ID, LINE_NUMBER LINE_NUMBER, CHR_ID CHR_ID, CLE_ID CLE_ID, CLE_ID_RENEWED CLE_ID_RENEWED, DNZ_CHR_ID DNZ_CHR_ID, DISPLAY_SEQUENCE DISPLAY_SEQUENCE, STS_CODE STS_CODE, TRN_CODE TRN_CODE, LSE_ID LSE_ID, EXCEPTION_YN EXCEPTION_YN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, HIDDEN_IND HIDDEN_IND, PRICE_NEGOTIATED PRICE_NEGOTIATED, PRICE_LEVEL_IND PRICE_LEVEL_IND, PRICE_UNIT PRICE_UNIT, PRICE_UNIT_PERCENT PRICE_UNIT_PERCENT, INVOICE_LINE_LEVEL_IND INVOICE_LINE_LEVEL_IND, DPAS_RATING DPAS_RATING, TEMPLATE_USED TEMPLATE_USED, PRICE_TYPE PRICE_TYPE, CURRENCY_CODE CURRENCY_CODE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DATE_TERMINATED DATE_TERMINATED, START_DATE START_DATE, END_DATE END_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, SECURITY_GROUP_ID SECURITY_GROUP_ID, CLE_ID_RENEWED_TO CLE_ID_RENEWED_TO, PRICE_NEGOTIATED_RENEWED PRICE_NEGOTIATED_RENEWED, CURRENCY_CODE_RENEWED CURRENCY_CODE_RENEWED, UPG_ORIG_SYSTEM_REF UPG_ORIG_SYSTEM_REF, UPG_ORIG_SYSTEM_REF_ID UPG_ORIG_SYSTEM_REF_ID, DATE_RENEWED DATE_RENEWED, ORIG_SYSTEM_SOURCE_CODE ORIG_SYSTEM_SOURCE_CODE, ORIG_SYSTEM_ID1 ORIG_SYSTEM_ID1, ORIG_SYSTEM_REFERENCE1 ORIG_SYSTEM_REFERENCE1, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, PRICE_LIST_ID PRICE_LIST_ID, PRICE_LIST_LINE_ID PRICE_LIST_LINE_ID, LINE_LIST_PRICE LINE_LIST_PRICE, ITEM_TO_PRICE_YN ITEM_TO_PRICE_YN, PRICING_DATE PRICING_DATE, PRICE_BASIS_YN PRICE_BASIS_YN, CONFIG_HEADER_ID CONFIG_HEADER_ID, CONFIG_REVISION_NUMBER CONFIG_REVISION_NUMBER, CONFIG_COMPLETE_YN CONFIG_COMPLETE_YN, CONFIG_VALID_YN CONFIG_VALID_YN, CONFIG_TOP_MODEL_LINE_ID CONFIG_TOP_MODEL_LINE_ID, CONFIG_ITEM_TYPE CONFIG_ITEM_TYPE, CONFIG_ITEM_ID CONFIG_ITEM_ID, SERVICE_ITEM_YN SERVICE_ITEM_YN, PH_PRICING_TYPE PH_PRICING_TYPE, PH_PRICE_BREAK_BASIS PH_PRICE_BREAK_BASIS, PH_MIN_QTY PH_MIN_QTY, PH_MIN_AMT PH_MIN_AMT, PH_QP_REFERENCE_ID PH_QP_REFERENCE_ID, PH_VALUE PH_VALUE, PH_ENFORCE_PRICE_LIST_YN PH_ENFORCE_PRICE_LIST_YN, PH_ADJUSTMENT PH_ADJUSTMENT, PH_INTEGRATED_WITH_QP PH_INTEGRATED_WITH_QP, CUST_ACCT_ID CUST_ACCT_ID, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID, INV_RULE_ID INV_RULE_ID, LINE_RENEWAL_TYPE_CODE LINE_RENEWAL_TYPE_CODE, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, PAYMENT_TERM_ID PAYMENT_TERM_ID, DATE_CANCELLED DATE_CANCELLED, TERM_CANCEL_SOURCE TERM_CANCEL_SOURCE, PAYMENT_INSTRUCTION_TYPE PAYMENT_INSTRUCTION_TYPE, ANNUALIZED_FACTOR ANNUALIZED_FACTOR, CANCELLED_AMOUNT CANCELLED_AMOUNT from "OKC"."OKC_K_LINES_B"

View Text - HTML Formatted

SELECT ID ID
, LINE_NUMBER LINE_NUMBER
, CHR_ID CHR_ID
, CLE_ID CLE_ID
, CLE_ID_RENEWED CLE_ID_RENEWED
, DNZ_CHR_ID DNZ_CHR_ID
, DISPLAY_SEQUENCE DISPLAY_SEQUENCE
, STS_CODE STS_CODE
, TRN_CODE TRN_CODE
, LSE_ID LSE_ID
, EXCEPTION_YN EXCEPTION_YN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, HIDDEN_IND HIDDEN_IND
, PRICE_NEGOTIATED PRICE_NEGOTIATED
, PRICE_LEVEL_IND PRICE_LEVEL_IND
, PRICE_UNIT PRICE_UNIT
, PRICE_UNIT_PERCENT PRICE_UNIT_PERCENT
, INVOICE_LINE_LEVEL_IND INVOICE_LINE_LEVEL_IND
, DPAS_RATING DPAS_RATING
, TEMPLATE_USED TEMPLATE_USED
, PRICE_TYPE PRICE_TYPE
, CURRENCY_CODE CURRENCY_CODE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DATE_TERMINATED DATE_TERMINATED
, START_DATE START_DATE
, END_DATE END_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, CLE_ID_RENEWED_TO CLE_ID_RENEWED_TO
, PRICE_NEGOTIATED_RENEWED PRICE_NEGOTIATED_RENEWED
, CURRENCY_CODE_RENEWED CURRENCY_CODE_RENEWED
, UPG_ORIG_SYSTEM_REF UPG_ORIG_SYSTEM_REF
, UPG_ORIG_SYSTEM_REF_ID UPG_ORIG_SYSTEM_REF_ID
, DATE_RENEWED DATE_RENEWED
, ORIG_SYSTEM_SOURCE_CODE ORIG_SYSTEM_SOURCE_CODE
, ORIG_SYSTEM_ID1 ORIG_SYSTEM_ID1
, ORIG_SYSTEM_REFERENCE1 ORIG_SYSTEM_REFERENCE1
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, PRICE_LIST_ID PRICE_LIST_ID
, PRICE_LIST_LINE_ID PRICE_LIST_LINE_ID
, LINE_LIST_PRICE LINE_LIST_PRICE
, ITEM_TO_PRICE_YN ITEM_TO_PRICE_YN
, PRICING_DATE PRICING_DATE
, PRICE_BASIS_YN PRICE_BASIS_YN
, CONFIG_HEADER_ID CONFIG_HEADER_ID
, CONFIG_REVISION_NUMBER CONFIG_REVISION_NUMBER
, CONFIG_COMPLETE_YN CONFIG_COMPLETE_YN
, CONFIG_VALID_YN CONFIG_VALID_YN
, CONFIG_TOP_MODEL_LINE_ID CONFIG_TOP_MODEL_LINE_ID
, CONFIG_ITEM_TYPE CONFIG_ITEM_TYPE
, CONFIG_ITEM_ID CONFIG_ITEM_ID
, SERVICE_ITEM_YN SERVICE_ITEM_YN
, PH_PRICING_TYPE PH_PRICING_TYPE
, PH_PRICE_BREAK_BASIS PH_PRICE_BREAK_BASIS
, PH_MIN_QTY PH_MIN_QTY
, PH_MIN_AMT PH_MIN_AMT
, PH_QP_REFERENCE_ID PH_QP_REFERENCE_ID
, PH_VALUE PH_VALUE
, PH_ENFORCE_PRICE_LIST_YN PH_ENFORCE_PRICE_LIST_YN
, PH_ADJUSTMENT PH_ADJUSTMENT
, PH_INTEGRATED_WITH_QP PH_INTEGRATED_WITH_QP
, CUST_ACCT_ID CUST_ACCT_ID
, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, INV_RULE_ID INV_RULE_ID
, LINE_RENEWAL_TYPE_CODE LINE_RENEWAL_TYPE_CODE
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, PAYMENT_TERM_ID PAYMENT_TERM_ID
, DATE_CANCELLED DATE_CANCELLED
, TERM_CANCEL_SOURCE TERM_CANCEL_SOURCE
, PAYMENT_INSTRUCTION_TYPE PAYMENT_INSTRUCTION_TYPE
, ANNUALIZED_FACTOR ANNUALIZED_FACTOR
, CANCELLED_AMOUNT CANCELLED_AMOUNT
FROM "OKC"."OKC_K_LINES_B"