VIEW: APPS.OKS_K_LINES_HV

Source

View Text - Preformatted

SELECT KLH.ROWID ROW_ID , KLH.ID ID , KLH.MAJOR_VERSION MAJOR_VERSION , KLH.CLE_ID CLE_ID , KLH.DNZ_CHR_ID DNZ_CHR_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.FULL_CREDIT FULL_CREDIT , KLH.LOCKED_PRICE_LIST_LINE_ID LOCKED_PRICE_LIST_LINE_ID , KLH.BREAK_UOM BREAK_UOM , KLH.PRORATE PRORATE , 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 , LTH.SFWT_FLAG SFWT_FLAG , 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.COVERAGE_ID COVERAGE_ID , KLH.STANDARD_COV_YN STANDARD_COV_YN , KLH.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER , KLH.SECURITY_GROUP_ID SECURITY_GROUP_ID , KLH.REQUEST_ID REQUEST_ID , KLH.CREATED_BY CREATED_BY , KLH.CREATION_DATE CREATION_DATE , KLH.LAST_UPDATED_BY LAST_UPDATED_BY , KLH.LAST_UPDATE_DATE LAST_UPDATE_DATE , KLH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , KLH.TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE , KLH.EXEMPT_CERTIFICATE_NUMBER EXEMPT_CERTIFICATE_NUMBER , KLH.EXEMPT_REASON_CODE EXEMPT_REASON_CODE , KLH.TRXN_EXTENSION_ID TRXN_EXTENSION_ID ,KLH.COUNTER_VALUE_ID COUNTER_VALUE_ID FROM OKS_K_LINES_BH KLH,OKS_K_LINES_TLH LTH WHERE KLH.ID = LTH.ID AND LTH.LANGUAGE = USERENV('LANG') AND KLH.MAJOR_VERSION = LTH.MAJOR_VERSION

View Text - HTML Formatted

SELECT KLH.ROWID ROW_ID
, KLH.ID ID
, KLH.MAJOR_VERSION MAJOR_VERSION
, KLH.CLE_ID CLE_ID
, KLH.DNZ_CHR_ID DNZ_CHR_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.FULL_CREDIT FULL_CREDIT
, KLH.LOCKED_PRICE_LIST_LINE_ID LOCKED_PRICE_LIST_LINE_ID
, KLH.BREAK_UOM BREAK_UOM
, KLH.PRORATE PRORATE
, 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
, LTH.SFWT_FLAG SFWT_FLAG
, 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.COVERAGE_ID COVERAGE_ID
, KLH.STANDARD_COV_YN STANDARD_COV_YN
, KLH.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, KLH.SECURITY_GROUP_ID SECURITY_GROUP_ID
, KLH.REQUEST_ID REQUEST_ID
, KLH.CREATED_BY CREATED_BY
, KLH.CREATION_DATE CREATION_DATE
, KLH.LAST_UPDATED_BY LAST_UPDATED_BY
, KLH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, KLH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, KLH.TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
, KLH.EXEMPT_CERTIFICATE_NUMBER EXEMPT_CERTIFICATE_NUMBER
, KLH.EXEMPT_REASON_CODE EXEMPT_REASON_CODE
, KLH.TRXN_EXTENSION_ID TRXN_EXTENSION_ID
, KLH.COUNTER_VALUE_ID COUNTER_VALUE_ID
FROM OKS_K_LINES_BH KLH
, OKS_K_LINES_TLH LTH
WHERE KLH.ID = LTH.ID
AND LTH.LANGUAGE = USERENV('LANG')
AND KLH.MAJOR_VERSION = LTH.MAJOR_VERSION