Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: OKS.OKS_K_LINES_B#

Object Details
Object Name: OKS_K_LINES_B#
Object Type: VIEW
Owner: OKS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes
CLE_ID NUMBER
Yes
DNZ_CHR_ID NUMBER
Yes
DISCOUNT_LIST NUMBER

ACCT_RULE_ID NUMBER

PAYMENT_TYPE VARCHAR2 (30)
CC_NO VARCHAR2 (80)
CC_EXPIRY_DATE DATE

CC_BANK_ACCT_ID NUMBER

CC_AUTH_CODE VARCHAR2 (150)
COMMITMENT_ID NUMBER

LOCKED_PRICE_LIST_ID NUMBER

USAGE_EST_YN VARCHAR2 (1)
USAGE_EST_METHOD VARCHAR2 (30)
USAGE_EST_START_DATE DATE

TERMN_METHOD VARCHAR2 (30)
UBT_AMOUNT NUMBER

CREDIT_AMOUNT NUMBER

SUPPRESSED_CREDIT NUMBER

OVERRIDE_AMOUNT NUMBER

CUST_PO_NUMBER_REQ_YN VARCHAR2 (1)
CUST_PO_NUMBER VARCHAR2 (150)
GRACE_DURATION NUMBER

GRACE_PERIOD VARCHAR2 (30)
INV_PRINT_FLAG VARCHAR2 (1)
PRICE_UOM VARCHAR2 (30)
TAX_AMOUNT NUMBER

TAX_INCLUSIVE_YN VARCHAR2 (1)
TAX_STATUS VARCHAR2 (30)
TAX_CODE NUMBER

TAX_EXEMPTION_ID NUMBER

IB_TRANS_TYPE VARCHAR2 (10)
IB_TRANS_DATE DATE

PROD_PRICE NUMBER

SERVICE_PRICE NUMBER

CLVL_LIST_PRICE NUMBER

CLVL_QUANTITY NUMBER

CLVL_EXTENDED_AMT NUMBER

CLVL_UOM_CODE VARCHAR2 (3)
TOPLVL_OPERAND_CODE VARCHAR2 (30)
TOPLVL_OPERAND_VAL NUMBER

TOPLVL_QUANTITY NUMBER

TOPLVL_UOM_CODE VARCHAR2 (3)
TOPLVL_ADJ_PRICE NUMBER

TOPLVL_PRICE_QTY NUMBER

AVERAGING_INTERVAL NUMBER

SETTLEMENT_INTERVAL VARCHAR2 (30)
MINIMUM_QUANTITY NUMBER

DEFAULT_QUANTITY NUMBER

AMCV_FLAG VARCHAR2 (1)
FIXED_QUANTITY NUMBER

USAGE_DURATION NUMBER

USAGE_PERIOD VARCHAR2 (3)
LEVEL_YN VARCHAR2 (1)
USAGE_TYPE VARCHAR2 (10)
UOM_QUANTIFIED VARCHAR2 (3)
BASE_READING NUMBER

BILLING_SCHEDULE_TYPE VARCHAR2 (10)
FULL_CREDIT VARCHAR2 (1)
LOCKED_PRICE_LIST_LINE_ID NUMBER

BREAK_UOM VARCHAR2 (3)
PRORATE VARCHAR2 (5)
COVERAGE_TYPE VARCHAR2 (30)
EXCEPTION_COV_ID NUMBER

LIMIT_UOM_QUANTIFIED VARCHAR2 (3)
DISCOUNT_AMOUNT NUMBER

DISCOUNT_PERCENT NUMBER

OFFSET_DURATION NUMBER

OFFSET_PERIOD VARCHAR2 (3)
INCIDENT_SEVERITY_ID NUMBER

PDF_ID NUMBER

WORK_THRU_YN VARCHAR2 (1)
REACT_ACTIVE_YN VARCHAR2 (1)
TRANSFER_OPTION VARCHAR2 (30)
PROD_UPGRADE_YN VARCHAR2 (1)
INHERITANCE_TYPE VARCHAR2 (30)
PM_PROGRAM_ID NUMBER

PM_CONF_REQ_YN VARCHAR2 (1)
PM_SCH_EXISTS_YN VARCHAR2 (1)
ALLOW_BT_DISCOUNT VARCHAR2 (1)
APPLY_DEFAULT_TIMEZONE VARCHAR2 (1)
SYNC_DATE_INSTALL VARCHAR2 (1)
OBJECT_VERSION_NUMBER NUMBER
Yes
SECURITY_GROUP_ID NUMBER

REQUEST_ID NUMBER

CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
TRXN_EXTENSION_ID NUMBER

TAX_CLASSIFICATION_CODE VARCHAR2 (50)
EXEMPT_CERTIFICATE_NUMBER VARCHAR2 (80)
EXEMPT_REASON_CODE VARCHAR2 (30)
COVERAGE_ID NUMBER

STANDARD_COV_YN VARCHAR2 (1)
ORIG_SYSTEM_ID1 NUMBER

ORIG_SYSTEM_REFERENCE1 VARCHAR2 (30)
ORIG_SYSTEM_SOURCE_CODE VARCHAR2 (30)
REVENUE_IMPACT_DATE DATE

COUNTER_VALUE_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

OKS.OKS_K_LINES_B# references the following:

SchemaOKS
TableOKS_K_LINES_B
OKS.OKS_K_LINES_B# is referenced by following:

SchemaAPPS
SynonymOKS_K_LINES_B