VIEW: APPS.OKS_K_LINES_V

Source

View Text - Preformatted

SELECT KLN.ROWID ROW_ID , KLN.ID ID , KLN.CLE_ID CLE_ID , KLN.DNZ_CHR_ID DNZ_CHR_ID , KLN.DISCOUNT_LIST DISCOUNT_LIST , KLN.ACCT_RULE_ID ACCT_RULE_ID , KLN.PAYMENT_TYPE PAYMENT_TYPE , KLN.CC_NO CC_NO , KLN.CC_EXPIRY_DATE CC_EXPIRY_DATE , KLN.CC_BANK_ACCT_ID CC_BANK_ACCT_ID , KLN.CC_AUTH_CODE CC_AUTH_CODE ,KLN.COMMITMENT_ID COMMITMENT_ID , KLN.LOCKED_PRICE_LIST_ID LOCKED_PRICE_LIST_ID , KLN.USAGE_EST_YN USAGE_EST_YN , KLN.USAGE_EST_METHOD USAGE_EST_METHOD , KLN.USAGE_EST_START_DATE USAGE_EST_START_DATE , KLN.TERMN_METHOD TERMN_METHOD , KLN.UBT_AMOUNT UBT_AMOUNT , KLN.CREDIT_AMOUNT CREDIT_AMOUNT , KLN.SUPPRESSED_CREDIT SUPPRESSED_CREDIT , KLN.OVERRIDE_AMOUNT OVERRIDE_AMOUNT , KLN.CUST_PO_NUMBER_REQ_YN CUST_PO_NUMBER_REQ_YN , KLN.CUST_PO_NUMBER CUST_PO_NUMBER , KLN.GRACE_DURATION GRACE_DURATION , KLN.GRACE_PERIOD GRACE_PERIOD , KLN.INV_PRINT_FLAG INV_PRINT_FLAG , KLN.PRICE_UOM PRICE_UOM , KLN.TAX_AMOUNT TAX_AMOUNT , KLN.TAX_INCLUSIVE_YN TAX_INCLUSIVE_YN , KLN.TAX_STATUS TAX_STATUS , KLN.TAX_CODE TAX_CODE , KLN.TAX_EXEMPTION_ID TAX_EXEMPTION_ID , KLN.IB_TRANS_TYPE IB_TRANS_TYPE , KLN.IB_TRANS_DATE IB_TRANS_DATE , KLN.PROD_PRICE PROD_PRICE , KLN.SERVICE_PRICE SERVICE_PRICE , KLN.CLVL_LIST_PRICE CLVL_LIST_PRICE , KLN.CLVL_QUANTITY CLVL_QUANTITY , KLN.CLVL_EXTENDED_AMT CLVL_EXTENDED_AMT , KLN.CLVL_UOM_CODE CLVL_UOM_CODE , KLN.TOPLVL_OPERAND_CODE TOPLVL_OPERAND_CODE , KLN.TOPLVL_OPERAND_VAL TOPLVL_OPERAND_VAL , KLN.TOPLVL_QUANTITY TOPLVL_QUANTITY , KLN.TOPLVL_UOM_CODE TOPLVL_UOM_CODE , KLN.TOPLVL_ADJ_PRICE TOPLVL_ADJ_PRICE , KLN.TOPLVL_PRICE_QTY TOPLVL_PRICE_QTY , KLN.AVERAGING_INTERVAL AVERAGING_INTERVAL , KLN.SETTLEMENT_INTERVAL SETTLEMENT_INTERVAL , KLN.MINIMUM_QUANTITY MINIMUM_QUANTITY , KLN.DEFAULT_QUANTITY DEFAULT_QUANTITY , KLN.AMCV_FLAG AMCV_FLAG , KLN.FIXED_QUANTITY FIXED_QUANTITY , KLN.USAGE_DURATION USAGE_DURATION , KLN.USAGE_PERIOD USAGE_PERIOD , KLN.LEVEL_YN LEVEL_YN , KLN.USAGE_TYPE USAGE_TYPE , KLN.UOM_QUANTIFIED UOM_QUANTIFIED , KLN.BASE_READING BASE_READING , KLN.BILLING_SCHEDULE_TYPE BILLING_SCHEDULE_TYPE , KLN.FULL_CREDIT FULL_CREDIT , KLN.LOCKED_PRICE_LIST_LINE_ID LOCKED_PRICE_LIST_LINE_ID , KLN.BREAK_UOM BREAK_UOM , KLN.PRORATE PRORATE , KLN.COVERAGE_TYPE COVERAGE_TYPE , KLN.EXCEPTION_COV_ID EXCEPTION_COV_ID , KLN.LIMIT_UOM_QUANTIFIED LIMIT_UOM_QUANTIFIED , KLN.DISCOUNT_AMOUNT DISCOUNT_AMOUNT , KLN.DISCOUNT_PERCENT DISCOUNT_PERCENT , KLN.OFFSET_DURATION OFFSET_DURATION , KLN.OFFSET_PERIOD OFFSET_PERIOD , KLN.INCIDENT_SEVERITY_ID INCIDENT_SEVERITY_ID , KLN.PDF_ID PDF_ID , KLN.WORK_THRU_YN WORK_THRU_YN , KLN.REACT_ACTIVE_YN REACT_ACTIVE_YN , KLN.TRANSFER_OPTION TRANSFER_OPTION , KLN.PROD_UPGRADE_YN PROD_UPGRADE_YN , KLN.INHERITANCE_TYPE INHERITANCE_TYPE , KLN.PM_PROGRAM_ID PM_PROGRAM_ID , KLN.PM_CONF_REQ_YN PM_CONF_REQ_YN , KLN.PM_SCH_EXISTS_YN PM_SCH_EXISTS_YN , KLN.ALLOW_BT_DISCOUNT ALLOW_BT_DISCOUNT , KLN.APPLY_DEFAULT_TIMEZONE APPLY_DEFAULT_TIMEZONE , KLN.SYNC_DATE_INSTALL SYNC_DATE_INSTALL , KLT.SFWT_FLAG SFWT_FLAG , KLT.INVOICE_TEXT INVOICE_TEXT , KLT.IB_TRX_DETAILS IB_TRX_DETAILS , KLT.STATUS_TEXT STATUS_TEXT , KLT.REACT_TIME_NAME REACT_TIME_NAME , KLN.COVERAGE_ID COVERAGE_ID , KLN.STANDARD_COV_YN STANDARD_COV_YN , KLN.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER , KLN.SECURITY_GROUP_ID SECURITY_GROUP_ID , KLN.REQUEST_ID REQUEST_ID , KLN.CREATED_BY CREATED_BY , KLN.CREATION_DATE CREATION_DATE , KLN.LAST_UPDATED_BY LAST_UPDATED_BY , KLN.LAST_UPDATE_DATE LAST_UPDATE_DATE , KLN.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN ,KLN.ORIG_SYSTEM_ID1 ORIG_SYSTEM_ID1 ,KLN.ORIG_SYSTEM_REFERENCE1 ORIG_SYSTEM_REFERENCE1 ,KLN.ORIG_SYSTEM_SOURCE_CODE ORIG_SYSTEM_SOURCE_CODE ,KLN.TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE ,KLN.EXEMPT_CERTIFICATE_NUMBER EXEMPT_CERTIFICATE_NUMBER ,KLN.EXEMPT_REASON_CODE EXEMPT_REASON_CODE ,KLN.TRXN_EXTENSION_ID TRXN_EXTENSION_ID ,KLN.revenue_impact_date REVENUE_IMPACT_DATE ,KLN.COUNTER_VALUE_ID COUNTER_VALUE_ID FROM OKS_K_LINES_B KLN,OKS_K_LINES_TL KLT WHERE KLN.ID = KLT.ID AND KLT.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT KLN.ROWID ROW_ID
, KLN.ID ID
, KLN.CLE_ID CLE_ID
, KLN.DNZ_CHR_ID DNZ_CHR_ID
, KLN.DISCOUNT_LIST DISCOUNT_LIST
, KLN.ACCT_RULE_ID ACCT_RULE_ID
, KLN.PAYMENT_TYPE PAYMENT_TYPE
, KLN.CC_NO CC_NO
, KLN.CC_EXPIRY_DATE CC_EXPIRY_DATE
, KLN.CC_BANK_ACCT_ID CC_BANK_ACCT_ID
, KLN.CC_AUTH_CODE CC_AUTH_CODE
, KLN.COMMITMENT_ID COMMITMENT_ID
, KLN.LOCKED_PRICE_LIST_ID LOCKED_PRICE_LIST_ID
, KLN.USAGE_EST_YN USAGE_EST_YN
, KLN.USAGE_EST_METHOD USAGE_EST_METHOD
, KLN.USAGE_EST_START_DATE USAGE_EST_START_DATE
, KLN.TERMN_METHOD TERMN_METHOD
, KLN.UBT_AMOUNT UBT_AMOUNT
, KLN.CREDIT_AMOUNT CREDIT_AMOUNT
, KLN.SUPPRESSED_CREDIT SUPPRESSED_CREDIT
, KLN.OVERRIDE_AMOUNT OVERRIDE_AMOUNT
, KLN.CUST_PO_NUMBER_REQ_YN CUST_PO_NUMBER_REQ_YN
, KLN.CUST_PO_NUMBER CUST_PO_NUMBER
, KLN.GRACE_DURATION GRACE_DURATION
, KLN.GRACE_PERIOD GRACE_PERIOD
, KLN.INV_PRINT_FLAG INV_PRINT_FLAG
, KLN.PRICE_UOM PRICE_UOM
, KLN.TAX_AMOUNT TAX_AMOUNT
, KLN.TAX_INCLUSIVE_YN TAX_INCLUSIVE_YN
, KLN.TAX_STATUS TAX_STATUS
, KLN.TAX_CODE TAX_CODE
, KLN.TAX_EXEMPTION_ID TAX_EXEMPTION_ID
, KLN.IB_TRANS_TYPE IB_TRANS_TYPE
, KLN.IB_TRANS_DATE IB_TRANS_DATE
, KLN.PROD_PRICE PROD_PRICE
, KLN.SERVICE_PRICE SERVICE_PRICE
, KLN.CLVL_LIST_PRICE CLVL_LIST_PRICE
, KLN.CLVL_QUANTITY CLVL_QUANTITY
, KLN.CLVL_EXTENDED_AMT CLVL_EXTENDED_AMT
, KLN.CLVL_UOM_CODE CLVL_UOM_CODE
, KLN.TOPLVL_OPERAND_CODE TOPLVL_OPERAND_CODE
, KLN.TOPLVL_OPERAND_VAL TOPLVL_OPERAND_VAL
, KLN.TOPLVL_QUANTITY TOPLVL_QUANTITY
, KLN.TOPLVL_UOM_CODE TOPLVL_UOM_CODE
, KLN.TOPLVL_ADJ_PRICE TOPLVL_ADJ_PRICE
, KLN.TOPLVL_PRICE_QTY TOPLVL_PRICE_QTY
, KLN.AVERAGING_INTERVAL AVERAGING_INTERVAL
, KLN.SETTLEMENT_INTERVAL SETTLEMENT_INTERVAL
, KLN.MINIMUM_QUANTITY MINIMUM_QUANTITY
, KLN.DEFAULT_QUANTITY DEFAULT_QUANTITY
, KLN.AMCV_FLAG AMCV_FLAG
, KLN.FIXED_QUANTITY FIXED_QUANTITY
, KLN.USAGE_DURATION USAGE_DURATION
, KLN.USAGE_PERIOD USAGE_PERIOD
, KLN.LEVEL_YN LEVEL_YN
, KLN.USAGE_TYPE USAGE_TYPE
, KLN.UOM_QUANTIFIED UOM_QUANTIFIED
, KLN.BASE_READING BASE_READING
, KLN.BILLING_SCHEDULE_TYPE BILLING_SCHEDULE_TYPE
, KLN.FULL_CREDIT FULL_CREDIT
, KLN.LOCKED_PRICE_LIST_LINE_ID LOCKED_PRICE_LIST_LINE_ID
, KLN.BREAK_UOM BREAK_UOM
, KLN.PRORATE PRORATE
, KLN.COVERAGE_TYPE COVERAGE_TYPE
, KLN.EXCEPTION_COV_ID EXCEPTION_COV_ID
, KLN.LIMIT_UOM_QUANTIFIED LIMIT_UOM_QUANTIFIED
, KLN.DISCOUNT_AMOUNT DISCOUNT_AMOUNT
, KLN.DISCOUNT_PERCENT DISCOUNT_PERCENT
, KLN.OFFSET_DURATION OFFSET_DURATION
, KLN.OFFSET_PERIOD OFFSET_PERIOD
, KLN.INCIDENT_SEVERITY_ID INCIDENT_SEVERITY_ID
, KLN.PDF_ID PDF_ID
, KLN.WORK_THRU_YN WORK_THRU_YN
, KLN.REACT_ACTIVE_YN REACT_ACTIVE_YN
, KLN.TRANSFER_OPTION TRANSFER_OPTION
, KLN.PROD_UPGRADE_YN PROD_UPGRADE_YN
, KLN.INHERITANCE_TYPE INHERITANCE_TYPE
, KLN.PM_PROGRAM_ID PM_PROGRAM_ID
, KLN.PM_CONF_REQ_YN PM_CONF_REQ_YN
, KLN.PM_SCH_EXISTS_YN PM_SCH_EXISTS_YN
, KLN.ALLOW_BT_DISCOUNT ALLOW_BT_DISCOUNT
, KLN.APPLY_DEFAULT_TIMEZONE APPLY_DEFAULT_TIMEZONE
, KLN.SYNC_DATE_INSTALL SYNC_DATE_INSTALL
, KLT.SFWT_FLAG SFWT_FLAG
, KLT.INVOICE_TEXT INVOICE_TEXT
, KLT.IB_TRX_DETAILS IB_TRX_DETAILS
, KLT.STATUS_TEXT STATUS_TEXT
, KLT.REACT_TIME_NAME REACT_TIME_NAME
, KLN.COVERAGE_ID COVERAGE_ID
, KLN.STANDARD_COV_YN STANDARD_COV_YN
, KLN.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, KLN.SECURITY_GROUP_ID SECURITY_GROUP_ID
, KLN.REQUEST_ID REQUEST_ID
, KLN.CREATED_BY CREATED_BY
, KLN.CREATION_DATE CREATION_DATE
, KLN.LAST_UPDATED_BY LAST_UPDATED_BY
, KLN.LAST_UPDATE_DATE LAST_UPDATE_DATE
, KLN.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, KLN.ORIG_SYSTEM_ID1 ORIG_SYSTEM_ID1
, KLN.ORIG_SYSTEM_REFERENCE1 ORIG_SYSTEM_REFERENCE1
, KLN.ORIG_SYSTEM_SOURCE_CODE ORIG_SYSTEM_SOURCE_CODE
, KLN.TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
, KLN.EXEMPT_CERTIFICATE_NUMBER EXEMPT_CERTIFICATE_NUMBER
, KLN.EXEMPT_REASON_CODE EXEMPT_REASON_CODE
, KLN.TRXN_EXTENSION_ID TRXN_EXTENSION_ID
, KLN.REVENUE_IMPACT_DATE REVENUE_IMPACT_DATE
, KLN.COUNTER_VALUE_ID COUNTER_VALUE_ID
FROM OKS_K_LINES_B KLN
, OKS_K_LINES_TL KLT
WHERE KLN.ID = KLT.ID
AND KLT.LANGUAGE = USERENV('LANG')