VIEW: OKS.OKS_K_LINES_B#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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