VIEW: APPS.OKS_AUTH_LINES_HV

Source

View Text - Preformatted

SELECT CLEB.ROWID ROW_ID ,CLEB.MAJOR_VERSION MAJOR_VERSION ,CLEB.ID ID ,CLEB.LINE_NUMBER LINE_NUMBER ,CLEB.CHR_ID CHR_ID ,CLEB.CLE_ID CLE_ID ,CLEB.CLE_ID_RENEWED CLE_ID_RENEWED ,CLEB.DNZ_CHR_ID DNZ_CHR_ID ,CLEB.DISPLAY_SEQUENCE DISPLAY_SEQUENCE ,CLEB.STS_CODE STS_CODE ,CLEB.TRN_CODE TRN_CODE ,CLEB.LSE_ID LSE_ID ,CLEB.EXCEPTION_YN EXCEPTION_YN ,CLEB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER ,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.HIDDEN_IND HIDDEN_IND ,CLEB.PRICE_NEGOTIATED PRICE_NEGOTIATED ,CLEB.PRICE_LEVEL_IND PRICE_LEVEL_IND ,CLEB.PRICE_UNIT PRICE_UNIT ,CLEB.PRICE_UNIT_PERCENT PRICE_UNIT_PERCENT ,CLEB.INVOICE_LINE_LEVEL_IND INVOICE_LINE_LEVEL_IND ,CLEB.DPAS_RATING DPAS_RATING ,CLEB.TEMPLATE_USED TEMPLATE_USED ,CLEB.PRICE_TYPE PRICE_TYPE ,CLEB.CURRENCY_CODE CURRENCY_CODE ,CLEB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN ,CLEB.DATE_TERMINATED DATE_TERMINATED ,CLEB.START_DATE START_DATE ,CLEB.END_DATE END_DATE ,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.SECURITY_GROUP_ID SECURITY_GROUP_ID ,CLEB.CLE_ID_RENEWED_TO CLE_ID_RENEWED_TO ,CLEB.PRICE_NEGOTIATED_RENEWED PRICE_NEGOTIATED_RENEWED ,CLEB.CURRENCY_CODE_RENEWED CURRENCY_CODE_RENEWED ,CLEB.UPG_ORIG_SYSTEM_REF UPG_ORIG_SYSTEM_REF ,CLEB.UPG_ORIG_SYSTEM_REF_ID UPG_ORIG_SYSTEM_REF_ID ,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 ,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_ID PRICE_LIST_ID ,CLEB.PRICE_LIST_LINE_ID PRICE_LIST_LINE_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 CONFIG_REVISION_NUMBER ,CLEB.CONFIG_COMPLETE_YN CONFIG_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 PH_PRICING_TYPE ,CLEB.PH_PRICE_BREAK_BASIS PH_PRICE_BREAK_BASIS ,CLEB.PH_MIN_QTY PH_MIN_QTY ,CLEB.PH_MIN_AMT PH_MIN_AMT ,CLEB.PH_QP_REFERENCE_ID PH_QP_REFERENCE_ID ,CLEB.PH_VALUE PH_VALUE ,CLEB.PH_ENFORCE_PRICE_LIST_YN PH_ENFORCE_PRICE_LIST_YN ,CLEB.PH_ADJUSTMENT PH_ADJUSTMENT ,CLEB.PH_INTEGRATED_WITH_QP 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 ,CLET.LANGUAGE LANGUAGE ,CLET.SOURCE_LANG SOURCE_LANG ,CLET.SFWT_FLAG SFWT_FLAG ,CLET.NAME NAME ,CLET.COMMENTS COMMENTS ,CLET.ITEM_DESCRIPTION ITEM_DESCRIPTION ,CLET.BLOCK23TEXT BLOCK23TEXT ,CLET.OKE_BOE_DESCRIPTION OKE_BOE_DESCRIPTION ,CLET.COGNOMEN COGNOMEN ,KLH.ID KLN_ID ,KLH.DISCOUNT_LIST DISCOUNT_LIST ,KLH.ACCT_RULE_ID ACCT_RULE_ID ,KLH.PAYMENT_TYPE PAYMENT_TYPE ,KLH.CC_NO CC_NO ,KLH.CC_EXPIRY_DATE CC_EXPIRY_DATE ,KLH.CC_BANK_ACCT_ID CC_BANK_ACCT_ID ,KLH.CC_AUTH_CODE CC_AUTH_CODE ,KLH.COMMITMENT_ID COMMITMENT_ID ,KLH.LOCKED_PRICE_LIST_ID LOCKED_PRICE_LIST_ID ,KLH.USAGE_EST_YN USAGE_EST_YN ,KLH.USAGE_EST_METHOD USAGE_EST_METHOD ,KLH.USAGE_EST_START_DATE USAGE_EST_START_DATE ,KLH.TERMN_METHOD TERMN_METHOD ,KLH.UBT_AMOUNT UBT_AMOUNT ,KLH.CREDIT_AMOUNT CREDIT_AMOUNT ,KLH.SUPPRESSED_CREDIT SUPPRESSED_CREDIT ,KLH.OVERRIDE_AMOUNT OVERRIDE_AMOUNT ,KLH.CUST_PO_NUMBER_REQ_YN CUST_PO_NUMBER_REQ_YN ,KLH.CUST_PO_NUMBER CUST_PO_NUMBER ,KLH.GRACE_DURATION GRACE_DURATION ,KLH.GRACE_PERIOD GRACE_PERIOD ,KLH.INV_PRINT_FLAG INV_PRINT_FLAG ,KLH.PRICE_UOM PRICE_UOM ,KLH.TAX_AMOUNT TAX_AMOUNT ,KLH.TAX_INCLUSIVE_YN TAX_INCLUSIVE_YN ,KLH.TAX_STATUS TAX_STATUS ,KLH.TAX_CODE TAX_CODE ,KLH.TAX_EXEMPTION_ID TAX_EXEMPTION_ID ,KLH.IB_TRANS_TYPE IB_TRANS_TYPE ,KLH.IB_TRANS_DATE IB_TRANS_DATE ,KLH.PROD_PRICE PROD_PRICE ,KLH.SERVICE_PRICE SERVICE_PRICE ,KLH.CLVL_LIST_PRICE CLVL_LIST_PRICE ,KLH.CLVL_QUANTITY CLVL_QUANTITY ,KLH.CLVL_EXTENDED_AMT CLVL_EXTENDED_AMT ,KLH.CLVL_UOM_CODE CLVL_UOM_CODE ,KLH.TOPLVL_OPERAND_CODE TOPLVL_OPERAND_CODE ,KLH.TOPLVL_OPERAND_VAL TOPLVL_OPERAND_VAL ,KLH.TOPLVL_QUANTITY TOPLVL_QUANTITY ,KLH.TOPLVL_UOM_CODE TOPLVL_UOM_CODE ,KLH.TOPLVL_ADJ_PRICE TOPLVL_ADJ_PRICE ,KLH.TOPLVL_PRICE_QTY TOPLVL_PRICE_QTY ,KLH.AVERAGING_INTERVAL AVERAGING_INTERVAL ,KLH.SETTLEMENT_INTERVAL SETTLEMENT_INTERVAL ,KLH.MINIMUM_QUANTITY MINIMUM_QUANTITY ,KLH.DEFAULT_QUANTITY DEFAULT_QUANTITY ,KLH.AMCV_FLAG AMCV_FLAG ,KLH.FIXED_QUANTITY FIXED_QUANTITY ,KLH.USAGE_DURATION USAGE_DURATION ,KLH.USAGE_PERIOD USAGE_PERIOD ,KLH.LEVEL_YN LEVEL_YN ,KLH.USAGE_TYPE USAGE_TYPE ,KLH.UOM_QUANTIFIED UOM_QUANTIFIED ,KLH.BASE_READING BASE_READING ,KLH.BILLING_SCHEDULE_TYPE BILLING_SCHEDULE_TYPE ,KLH.COVERAGE_TYPE COVERAGE_TYPE ,KLH.EXCEPTION_COV_ID EXCEPTION_COV_ID ,KLH.LIMIT_UOM_QUANTIFIED LIMIT_UOM_QUANTIFIED ,KLH.DISCOUNT_AMOUNT DISCOUNT_AMOUNT ,KLH.DISCOUNT_PERCENT DISCOUNT_PERCENT ,KLH.OFFSET_DURATION OFFSET_DURATION ,KLH.OFFSET_PERIOD OFFSET_PERIOD ,KLH.INCIDENT_SEVERITY_ID INCIDENT_SEVERITY_ID ,KLH.PDF_ID PDF_ID ,KLH.WORK_THRU_YN WORK_THRU_YN ,KLH.REACT_ACTIVE_YN REACT_ACTIVE_YN ,KLH.TRANSFER_OPTION TRANSFER_OPTION ,KLH.PROD_UPGRADE_YN PROD_UPGRADE_YN ,KLH.INHERITANCE_TYPE INHERITANCE_TYPE ,KLH.PM_PROGRAM_ID PM_PROGRAM_ID ,KLH.PM_CONF_REQ_YN PM_CONF_REQ_YN ,KLH.PM_SCH_EXISTS_YN PM_SCH_EXISTS_YN ,KLH.ALLOW_BT_DISCOUNT ALLOW_BT_DISCOUNT ,KLH.APPLY_DEFAULT_TIMEZONE APPLY_DEFAULT_TIMEZONE ,KLH.SYNC_DATE_INSTALL SYNC_DATE_INSTALL ,KLH.OBJECT_VERSION_NUMBER KLN_OBJECT_VERSION_NUMBER ,KLH.LOCKED_PRICE_LIST_LINE_ID LOCKED_PRICE_LIST_LINE_ID ,KLH.BREAK_UOM BREAK_UOM ,KLH.PRORATE PRORATE ,LTH.INVOICE_TEXT INVOICE_TEXT ,LTH.IB_TRX_DETAILS IB_TRX_DETAILS ,LTH.STATUS_TEXT STATUS_TEXT ,LTH.REACT_TIME_NAME REACT_TIME_NAME ,KLH.TRXN_EXTENSION_ID TRXN_EXTENSION_ID ,CLEB.PAYMENT_INSTRUCTION_TYPE PAYMENT_INSTRUCTION_TYPE ,KLH.TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE ,KLH.EXEMPT_CERTIFICATE_NUMBER EXEMPT_CERTIFICATE_NUMBER ,KLH.EXEMPT_REASON_CODE EXEMPT_REASON_CODE ,KLH.COVERAGE_ID COVERAGE_ID ,KLH.STANDARD_COV_YN STANDARD_COV_YN ,CLEB.DATE_CANCELLED DATE_CANCELLED ,CLEB.TERM_CANCEL_SOURCE TERM_CANCEL_SOURCE ,CLEB.ANNUALIZED_FACTOR ANNUALIZED_FACTOR ,CLEB.CANCELLED_AMOUNT CANCELLED_AMOUNT ,KLH.COUNTER_VALUE_ID COUNTER_VALUE_ID FROM okc_k_lines_bh CLEB, okc_k_lines_tlh CLET, oks_k_lines_bh KLH, oks_k_lines_tlh LTH WHERE CLEB.id = CLET.id AND CLEB.MAJOR_VERSION = CLET.MAJOR_VERSION AND CLEB.MAJOR_VERSION = KLH.MAJOR_VERSION AND CLET.LANGUAGE = USERENV('LANG') AND CLET.LANGUAGE = LTH.LANGUAGE AND KLH.MAJOR_VERSION = LTH.MAJOR_VERSION AND CLEB.id = KLH.CLE_ID AND KLH.ID = LTH.ID

View Text - HTML Formatted

SELECT CLEB.ROWID ROW_ID
, CLEB.MAJOR_VERSION MAJOR_VERSION
, CLEB.ID ID
, CLEB.LINE_NUMBER LINE_NUMBER
, CLEB.CHR_ID CHR_ID
, CLEB.CLE_ID CLE_ID
, CLEB.CLE_ID_RENEWED CLE_ID_RENEWED
, CLEB.DNZ_CHR_ID DNZ_CHR_ID
, CLEB.DISPLAY_SEQUENCE DISPLAY_SEQUENCE
, CLEB.STS_CODE STS_CODE
, CLEB.TRN_CODE TRN_CODE
, CLEB.LSE_ID LSE_ID
, CLEB.EXCEPTION_YN EXCEPTION_YN
, CLEB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, 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.HIDDEN_IND HIDDEN_IND
, CLEB.PRICE_NEGOTIATED PRICE_NEGOTIATED
, CLEB.PRICE_LEVEL_IND PRICE_LEVEL_IND
, CLEB.PRICE_UNIT PRICE_UNIT
, CLEB.PRICE_UNIT_PERCENT PRICE_UNIT_PERCENT
, CLEB.INVOICE_LINE_LEVEL_IND INVOICE_LINE_LEVEL_IND
, CLEB.DPAS_RATING DPAS_RATING
, CLEB.TEMPLATE_USED TEMPLATE_USED
, CLEB.PRICE_TYPE PRICE_TYPE
, CLEB.CURRENCY_CODE CURRENCY_CODE
, CLEB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CLEB.DATE_TERMINATED DATE_TERMINATED
, CLEB.START_DATE START_DATE
, CLEB.END_DATE END_DATE
, 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.SECURITY_GROUP_ID SECURITY_GROUP_ID
, CLEB.CLE_ID_RENEWED_TO CLE_ID_RENEWED_TO
, CLEB.PRICE_NEGOTIATED_RENEWED PRICE_NEGOTIATED_RENEWED
, CLEB.CURRENCY_CODE_RENEWED CURRENCY_CODE_RENEWED
, CLEB.UPG_ORIG_SYSTEM_REF UPG_ORIG_SYSTEM_REF
, CLEB.UPG_ORIG_SYSTEM_REF_ID UPG_ORIG_SYSTEM_REF_ID
, 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
, 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_ID PRICE_LIST_ID
, CLEB.PRICE_LIST_LINE_ID PRICE_LIST_LINE_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 CONFIG_REVISION_NUMBER
, CLEB.CONFIG_COMPLETE_YN CONFIG_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 PH_PRICING_TYPE
, CLEB.PH_PRICE_BREAK_BASIS PH_PRICE_BREAK_BASIS
, CLEB.PH_MIN_QTY PH_MIN_QTY
, CLEB.PH_MIN_AMT PH_MIN_AMT
, CLEB.PH_QP_REFERENCE_ID PH_QP_REFERENCE_ID
, CLEB.PH_VALUE PH_VALUE
, CLEB.PH_ENFORCE_PRICE_LIST_YN PH_ENFORCE_PRICE_LIST_YN
, CLEB.PH_ADJUSTMENT PH_ADJUSTMENT
, CLEB.PH_INTEGRATED_WITH_QP 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
, CLET.LANGUAGE LANGUAGE
, CLET.SOURCE_LANG SOURCE_LANG
, CLET.SFWT_FLAG SFWT_FLAG
, CLET.NAME NAME
, CLET.COMMENTS COMMENTS
, CLET.ITEM_DESCRIPTION ITEM_DESCRIPTION
, CLET.BLOCK23TEXT BLOCK23TEXT
, CLET.OKE_BOE_DESCRIPTION OKE_BOE_DESCRIPTION
, CLET.COGNOMEN COGNOMEN
, KLH.ID KLN_ID
, KLH.DISCOUNT_LIST DISCOUNT_LIST
, KLH.ACCT_RULE_ID ACCT_RULE_ID
, KLH.PAYMENT_TYPE PAYMENT_TYPE
, KLH.CC_NO CC_NO
, KLH.CC_EXPIRY_DATE CC_EXPIRY_DATE
, KLH.CC_BANK_ACCT_ID CC_BANK_ACCT_ID
, KLH.CC_AUTH_CODE CC_AUTH_CODE
, KLH.COMMITMENT_ID COMMITMENT_ID
, KLH.LOCKED_PRICE_LIST_ID LOCKED_PRICE_LIST_ID
, KLH.USAGE_EST_YN USAGE_EST_YN
, KLH.USAGE_EST_METHOD USAGE_EST_METHOD
, KLH.USAGE_EST_START_DATE USAGE_EST_START_DATE
, KLH.TERMN_METHOD TERMN_METHOD
, KLH.UBT_AMOUNT UBT_AMOUNT
, KLH.CREDIT_AMOUNT CREDIT_AMOUNT
, KLH.SUPPRESSED_CREDIT SUPPRESSED_CREDIT
, KLH.OVERRIDE_AMOUNT OVERRIDE_AMOUNT
, KLH.CUST_PO_NUMBER_REQ_YN CUST_PO_NUMBER_REQ_YN
, KLH.CUST_PO_NUMBER CUST_PO_NUMBER
, KLH.GRACE_DURATION GRACE_DURATION
, KLH.GRACE_PERIOD GRACE_PERIOD
, KLH.INV_PRINT_FLAG INV_PRINT_FLAG
, KLH.PRICE_UOM PRICE_UOM
, KLH.TAX_AMOUNT TAX_AMOUNT
, KLH.TAX_INCLUSIVE_YN TAX_INCLUSIVE_YN
, KLH.TAX_STATUS TAX_STATUS
, KLH.TAX_CODE TAX_CODE
, KLH.TAX_EXEMPTION_ID TAX_EXEMPTION_ID
, KLH.IB_TRANS_TYPE IB_TRANS_TYPE
, KLH.IB_TRANS_DATE IB_TRANS_DATE
, KLH.PROD_PRICE PROD_PRICE
, KLH.SERVICE_PRICE SERVICE_PRICE
, KLH.CLVL_LIST_PRICE CLVL_LIST_PRICE
, KLH.CLVL_QUANTITY CLVL_QUANTITY
, KLH.CLVL_EXTENDED_AMT CLVL_EXTENDED_AMT
, KLH.CLVL_UOM_CODE CLVL_UOM_CODE
, KLH.TOPLVL_OPERAND_CODE TOPLVL_OPERAND_CODE
, KLH.TOPLVL_OPERAND_VAL TOPLVL_OPERAND_VAL
, KLH.TOPLVL_QUANTITY TOPLVL_QUANTITY
, KLH.TOPLVL_UOM_CODE TOPLVL_UOM_CODE
, KLH.TOPLVL_ADJ_PRICE TOPLVL_ADJ_PRICE
, KLH.TOPLVL_PRICE_QTY TOPLVL_PRICE_QTY
, KLH.AVERAGING_INTERVAL AVERAGING_INTERVAL
, KLH.SETTLEMENT_INTERVAL SETTLEMENT_INTERVAL
, KLH.MINIMUM_QUANTITY MINIMUM_QUANTITY
, KLH.DEFAULT_QUANTITY DEFAULT_QUANTITY
, KLH.AMCV_FLAG AMCV_FLAG
, KLH.FIXED_QUANTITY FIXED_QUANTITY
, KLH.USAGE_DURATION USAGE_DURATION
, KLH.USAGE_PERIOD USAGE_PERIOD
, KLH.LEVEL_YN LEVEL_YN
, KLH.USAGE_TYPE USAGE_TYPE
, KLH.UOM_QUANTIFIED UOM_QUANTIFIED
, KLH.BASE_READING BASE_READING
, KLH.BILLING_SCHEDULE_TYPE BILLING_SCHEDULE_TYPE
, KLH.COVERAGE_TYPE COVERAGE_TYPE
, KLH.EXCEPTION_COV_ID EXCEPTION_COV_ID
, KLH.LIMIT_UOM_QUANTIFIED LIMIT_UOM_QUANTIFIED
, KLH.DISCOUNT_AMOUNT DISCOUNT_AMOUNT
, KLH.DISCOUNT_PERCENT DISCOUNT_PERCENT
, KLH.OFFSET_DURATION OFFSET_DURATION
, KLH.OFFSET_PERIOD OFFSET_PERIOD
, KLH.INCIDENT_SEVERITY_ID INCIDENT_SEVERITY_ID
, KLH.PDF_ID PDF_ID
, KLH.WORK_THRU_YN WORK_THRU_YN
, KLH.REACT_ACTIVE_YN REACT_ACTIVE_YN
, KLH.TRANSFER_OPTION TRANSFER_OPTION
, KLH.PROD_UPGRADE_YN PROD_UPGRADE_YN
, KLH.INHERITANCE_TYPE INHERITANCE_TYPE
, KLH.PM_PROGRAM_ID PM_PROGRAM_ID
, KLH.PM_CONF_REQ_YN PM_CONF_REQ_YN
, KLH.PM_SCH_EXISTS_YN PM_SCH_EXISTS_YN
, KLH.ALLOW_BT_DISCOUNT ALLOW_BT_DISCOUNT
, KLH.APPLY_DEFAULT_TIMEZONE APPLY_DEFAULT_TIMEZONE
, KLH.SYNC_DATE_INSTALL SYNC_DATE_INSTALL
, KLH.OBJECT_VERSION_NUMBER KLN_OBJECT_VERSION_NUMBER
, KLH.LOCKED_PRICE_LIST_LINE_ID LOCKED_PRICE_LIST_LINE_ID
, KLH.BREAK_UOM BREAK_UOM
, KLH.PRORATE PRORATE
, LTH.INVOICE_TEXT INVOICE_TEXT
, LTH.IB_TRX_DETAILS IB_TRX_DETAILS
, LTH.STATUS_TEXT STATUS_TEXT
, LTH.REACT_TIME_NAME REACT_TIME_NAME
, KLH.TRXN_EXTENSION_ID TRXN_EXTENSION_ID
, CLEB.PAYMENT_INSTRUCTION_TYPE PAYMENT_INSTRUCTION_TYPE
, KLH.TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
, KLH.EXEMPT_CERTIFICATE_NUMBER EXEMPT_CERTIFICATE_NUMBER
, KLH.EXEMPT_REASON_CODE EXEMPT_REASON_CODE
, KLH.COVERAGE_ID COVERAGE_ID
, KLH.STANDARD_COV_YN STANDARD_COV_YN
, CLEB.DATE_CANCELLED DATE_CANCELLED
, CLEB.TERM_CANCEL_SOURCE TERM_CANCEL_SOURCE
, CLEB.ANNUALIZED_FACTOR ANNUALIZED_FACTOR
, CLEB.CANCELLED_AMOUNT CANCELLED_AMOUNT
, KLH.COUNTER_VALUE_ID COUNTER_VALUE_ID
FROM OKC_K_LINES_BH CLEB
, OKC_K_LINES_TLH CLET
, OKS_K_LINES_BH KLH
, OKS_K_LINES_TLH LTH
WHERE CLEB.ID = CLET.ID
AND CLEB.MAJOR_VERSION = CLET.MAJOR_VERSION
AND CLEB.MAJOR_VERSION = KLH.MAJOR_VERSION
AND CLET.LANGUAGE = USERENV('LANG')
AND CLET.LANGUAGE = LTH.LANGUAGE
AND KLH.MAJOR_VERSION = LTH.MAJOR_VERSION
AND CLEB.ID = KLH.CLE_ID
AND KLH.ID = LTH.ID