VIEW: APPS.OKC_K_LINES_V

Source

View Text - Preformatted

SELECT cleb.rowid ROW_ID, CLEB.ID ID, CLEB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CLET.SFWT_FLAG SFWT_FLAG, CLEB.CHR_ID CHR_ID, CLEB.CLE_ID CLE_ID, CLEB.CLE_ID_RENEWED CLE_ID_RENEWED, CLEB.CLE_ID_RENEWED_TO CLE_ID_RENEWED_TO, CLEB.LSE_ID LSE_ID, CLEB.LINE_NUMBER LINE_NUMBER, CLEB.STS_CODE STS_CODE, CLEB.DISPLAY_SEQUENCE DISPLAY_SEQUENCE, CLEB.TRN_CODE TRN_CODE, CLEB.DNZ_CHR_ID DNZ_CHR_ID, CLET.COMMENTS COMMENTS, CLET.ITEM_DESCRIPTION ITEM_DESCRIPTION, CLET.OKE_BOE_DESCRIPTION, CLEB.HIDDEN_IND HIDDEN_IND, CLEB.PRICE_UNIT PRICE_UNIT, CLEB.PRICE_UNIT_PERCENT PRICE_UNIT_PERCENT, CLEB.PRICE_NEGOTIATED PRICE_NEGOTIATED, CLEB.PRICE_NEGOTIATED_RENEWED PRICE_NEGOTIATED_RENEWED, CLEB.PRICE_LEVEL_IND PRICE_LEVEL_IND, CLEB.INVOICE_LINE_LEVEL_IND INVOICE_LINE_LEVEL_IND, CLEB.DPAS_RATING DPAS_RATING, CLET.BLOCK23TEXT BLOCK23TEXT, CLEB.EXCEPTION_YN EXCEPTION_YN, CLEB.TEMPLATE_USED TEMPLATE_USED, CLEB.DATE_TERMINATED DATE_TERMINATED, CLET.NAME NAME, CLEB.START_DATE START_DATE, CLEB.END_DATE END_DATE, CLEB.UPG_ORIG_SYSTEM_REF UPG_ORIG_SYSTEM_REF , CLEB.UPG_ORIG_SYSTEM_REF_ID UPG_ORIG_SYSTEM_REF_ID, CLEB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, CLEB.ATTRIBUTE1 ATTRIBUTE1, CLEB.ATTRIBUTE2 ATTRIBUTE2, CLEB.ATTRIBUTE3 ATTRIBUTE3, CLEB.ATTRIBUTE4 ATTRIBUTE4, CLEB.ATTRIBUTE5 ATTRIBUTE5, CLEB.ATTRIBUTE6 ATTRIBUTE6, CLEB.ATTRIBUTE7 ATTRIBUTE7, CLEB.ATTRIBUTE8 ATTRIBUTE8, CLEB.ATTRIBUTE9 ATTRIBUTE9, CLEB.ATTRIBUTE10 ATTRIBUTE10, CLEB.ATTRIBUTE11 ATTRIBUTE11, CLEB.ATTRIBUTE12 ATTRIBUTE12, CLEB.ATTRIBUTE13 ATTRIBUTE13, CLEB.ATTRIBUTE14 ATTRIBUTE14, CLEB.ATTRIBUTE15 ATTRIBUTE15, CLEB.CREATED_BY CREATED_BY, CLEB.CREATION_DATE CREATION_DATE, CLEB.LAST_UPDATED_BY LAST_UPDATED_BY, CLEB.LAST_UPDATE_DATE LAST_UPDATE_DATE, CLEB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , CLEB.PRICE_TYPE PRICE_TYPE, CLEB.CURRENCY_CODE CURRENCY_CODE, CLEB.CURRENCY_CODE_RENEWED CURRENCY_CODE_RENEWED , CLEB.DATE_RENEWED DATE_RENEWED, CLEB.ORIG_SYSTEM_SOURCE_CODE ORIG_SYSTEM_SOURCE_CODE, CLEB.ORIG_SYSTEM_ID1 ORIG_SYSTEM_ID1, CLEB.ORIG_SYSTEM_REFERENCE1 ORIG_SYSTEM_REFERENCE1 , CLET.COGNOMEN COGNOMEN, CLEB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, CLEB.PROGRAM_ID PROGRAM_ID, CLEB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CLEB.REQUEST_ID REQUEST_ID, CLEB.PRICE_LIST_LINE_ID PRICE_LIST_LINE_ID, CLEB.PRICE_LIST_ID PRICE_LIST_ID, CLEB.LINE_LIST_PRICE LINE_LIST_PRICE, CLEB.ITEM_TO_PRICE_YN ITEM_TO_PRICE_YN, CLEB.PRICING_DATE PRICING_DATE, CLEB.PRICE_BASIS_YN PRICE_BASIS_YN, CLEB.CONFIG_HEADER_ID CONFIG_HEADER_ID, CLEB.CONFIG_REVISION_NUMBER REVISION_NUMBER, CLEB.CONFIG_COMPLETE_YN COMPLETE_YN, CLEB.CONFIG_VALID_YN CONFIG_VALID_YN, CLEB.CONFIG_TOP_MODEL_LINE_ID CONFIG_TOP_MODEL_LINE_ID, CLEB.CONFIG_ITEM_TYPE CONFIG_ITEM_TYPE, CLEB.CONFIG_ITEM_ID CONFIG_ITEM_ID, CLEB.SERVICE_ITEM_YN SERVICE_ITEM_YN, CLEB.PH_PRICING_TYPE, CLEB.PH_ADJUSTMENT, CLEB.PH_PRICE_BREAK_BASIS, CLEB.PH_MIN_QTY, CLEB.PH_MIN_AMT, CLEB.PH_QP_REFERENCE_ID, CLEB.PH_VALUE, CLEB.PH_ENFORCE_PRICE_LIST_YN, CLEB.PH_INTEGRATED_WITH_QP, CLEB.CUST_ACCT_ID CUST_ACCT_ID, CLEB.BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID, CLEB.INV_RULE_ID INV_RULE_ID, CLEB.LINE_RENEWAL_TYPE_CODE LINE_RENEWAL_TYPE_CODE, CLEB.SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, CLEB.PAYMENT_TERM_ID PAYMENT_TERM_ID , CLEB.DATE_CANCELLED DATE_CANCELLED, CLEB.TERM_CANCEL_SOURCE TERM_CANCEL_SOURCE, CLEB.ANNUALIZED_FACTOR ANNUALIZED_FACTOR, CLEB.PAYMENT_INSTRUCTION_TYPE PAYMENT_INSTRUCTION_TYPE, CLEB.CANCELLED_AMOUNT CANCELLED_AMOUNT FROM OKC_K_LINES_B CLEB,OKC_K_LINES_TL CLET WHERE CLEB.ID = CLET.ID and CLET.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT CLEB.ROWID ROW_ID
, CLEB.ID ID
, CLEB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CLET.SFWT_FLAG SFWT_FLAG
, CLEB.CHR_ID CHR_ID
, CLEB.CLE_ID CLE_ID
, CLEB.CLE_ID_RENEWED CLE_ID_RENEWED
, CLEB.CLE_ID_RENEWED_TO CLE_ID_RENEWED_TO
, CLEB.LSE_ID LSE_ID
, CLEB.LINE_NUMBER LINE_NUMBER
, CLEB.STS_CODE STS_CODE
, CLEB.DISPLAY_SEQUENCE DISPLAY_SEQUENCE
, CLEB.TRN_CODE TRN_CODE
, CLEB.DNZ_CHR_ID DNZ_CHR_ID
, CLET.COMMENTS COMMENTS
, CLET.ITEM_DESCRIPTION ITEM_DESCRIPTION
, CLET.OKE_BOE_DESCRIPTION
, CLEB.HIDDEN_IND HIDDEN_IND
, CLEB.PRICE_UNIT PRICE_UNIT
, CLEB.PRICE_UNIT_PERCENT PRICE_UNIT_PERCENT
, CLEB.PRICE_NEGOTIATED PRICE_NEGOTIATED
, CLEB.PRICE_NEGOTIATED_RENEWED PRICE_NEGOTIATED_RENEWED
, CLEB.PRICE_LEVEL_IND PRICE_LEVEL_IND
, CLEB.INVOICE_LINE_LEVEL_IND INVOICE_LINE_LEVEL_IND
, CLEB.DPAS_RATING DPAS_RATING
, CLET.BLOCK23TEXT BLOCK23TEXT
, CLEB.EXCEPTION_YN EXCEPTION_YN
, CLEB.TEMPLATE_USED TEMPLATE_USED
, CLEB.DATE_TERMINATED DATE_TERMINATED
, CLET.NAME NAME
, CLEB.START_DATE START_DATE
, CLEB.END_DATE END_DATE
, CLEB.UPG_ORIG_SYSTEM_REF UPG_ORIG_SYSTEM_REF
, CLEB.UPG_ORIG_SYSTEM_REF_ID UPG_ORIG_SYSTEM_REF_ID
, CLEB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CLEB.ATTRIBUTE1 ATTRIBUTE1
, CLEB.ATTRIBUTE2 ATTRIBUTE2
, CLEB.ATTRIBUTE3 ATTRIBUTE3
, CLEB.ATTRIBUTE4 ATTRIBUTE4
, CLEB.ATTRIBUTE5 ATTRIBUTE5
, CLEB.ATTRIBUTE6 ATTRIBUTE6
, CLEB.ATTRIBUTE7 ATTRIBUTE7
, CLEB.ATTRIBUTE8 ATTRIBUTE8
, CLEB.ATTRIBUTE9 ATTRIBUTE9
, CLEB.ATTRIBUTE10 ATTRIBUTE10
, CLEB.ATTRIBUTE11 ATTRIBUTE11
, CLEB.ATTRIBUTE12 ATTRIBUTE12
, CLEB.ATTRIBUTE13 ATTRIBUTE13
, CLEB.ATTRIBUTE14 ATTRIBUTE14
, CLEB.ATTRIBUTE15 ATTRIBUTE15
, CLEB.CREATED_BY CREATED_BY
, CLEB.CREATION_DATE CREATION_DATE
, CLEB.LAST_UPDATED_BY LAST_UPDATED_BY
, CLEB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CLEB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CLEB.PRICE_TYPE PRICE_TYPE
, CLEB.CURRENCY_CODE CURRENCY_CODE
, CLEB.CURRENCY_CODE_RENEWED CURRENCY_CODE_RENEWED
, CLEB.DATE_RENEWED DATE_RENEWED
, CLEB.ORIG_SYSTEM_SOURCE_CODE ORIG_SYSTEM_SOURCE_CODE
, CLEB.ORIG_SYSTEM_ID1 ORIG_SYSTEM_ID1
, CLEB.ORIG_SYSTEM_REFERENCE1 ORIG_SYSTEM_REFERENCE1
, CLET.COGNOMEN COGNOMEN
, CLEB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, CLEB.PROGRAM_ID PROGRAM_ID
, CLEB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CLEB.REQUEST_ID REQUEST_ID
, CLEB.PRICE_LIST_LINE_ID PRICE_LIST_LINE_ID
, CLEB.PRICE_LIST_ID PRICE_LIST_ID
, CLEB.LINE_LIST_PRICE LINE_LIST_PRICE
, CLEB.ITEM_TO_PRICE_YN ITEM_TO_PRICE_YN
, CLEB.PRICING_DATE PRICING_DATE
, CLEB.PRICE_BASIS_YN PRICE_BASIS_YN
, CLEB.CONFIG_HEADER_ID CONFIG_HEADER_ID
, CLEB.CONFIG_REVISION_NUMBER REVISION_NUMBER
, CLEB.CONFIG_COMPLETE_YN COMPLETE_YN
, CLEB.CONFIG_VALID_YN CONFIG_VALID_YN
, CLEB.CONFIG_TOP_MODEL_LINE_ID CONFIG_TOP_MODEL_LINE_ID
, CLEB.CONFIG_ITEM_TYPE CONFIG_ITEM_TYPE
, CLEB.CONFIG_ITEM_ID CONFIG_ITEM_ID
, CLEB.SERVICE_ITEM_YN SERVICE_ITEM_YN
, CLEB.PH_PRICING_TYPE
, CLEB.PH_ADJUSTMENT
, CLEB.PH_PRICE_BREAK_BASIS
, CLEB.PH_MIN_QTY
, CLEB.PH_MIN_AMT
, CLEB.PH_QP_REFERENCE_ID
, CLEB.PH_VALUE
, CLEB.PH_ENFORCE_PRICE_LIST_YN
, CLEB.PH_INTEGRATED_WITH_QP
, CLEB.CUST_ACCT_ID CUST_ACCT_ID
, CLEB.BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, CLEB.INV_RULE_ID INV_RULE_ID
, CLEB.LINE_RENEWAL_TYPE_CODE LINE_RENEWAL_TYPE_CODE
, CLEB.SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, CLEB.PAYMENT_TERM_ID PAYMENT_TERM_ID
, CLEB.DATE_CANCELLED DATE_CANCELLED
, CLEB.TERM_CANCEL_SOURCE TERM_CANCEL_SOURCE
, CLEB.ANNUALIZED_FACTOR ANNUALIZED_FACTOR
, CLEB.PAYMENT_INSTRUCTION_TYPE PAYMENT_INSTRUCTION_TYPE
, CLEB.CANCELLED_AMOUNT CANCELLED_AMOUNT
FROM OKC_K_LINES_B CLEB
, OKC_K_LINES_TL CLET
WHERE CLEB.ID = CLET.ID
AND CLET.LANGUAGE = USERENV('LANG')