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

TABLE: OKS.OKS_LINES_INTERFACE

Object Details
Object Name: OKS_LINES_INTERFACE
Object Type: TABLE
Owner: OKS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKS_LINES_INTERFACE_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_INTERFACE_ID
OKS_LINES_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnHEADER_INTERFACE_ID
Columns
Name Datatype Length Mandatory Comments
LINE_INTERFACE_ID NUMBER
Yes Primary Key
HEADER_INTERFACE_ID NUMBER
Yes Header Interface ID
LINE_NUMBER NUMBER

Line Number
LINE_TYPE VARCHAR2 (25) Yes Line Type
ITEM_ORGANIZATION_ID NUMBER

Item Organization
ITEM_NAME VARCHAR2 (800)
Item Name
ITEM_ID NUMBER

Item Id
REFERENCE_TEMPLATE_ID NUMBER

Coverage ID
LINE_REFERENCE VARCHAR2 (300)
Line Reference
STATUS_CODE VARCHAR2 (30)
Status
START_DATE DATE

Line start date
END_DATE DATE

Line end date
BILL_TO_SITE_USAGE_CODE VARCHAR2 (40)
Bill to site usage code
BILL_TO_SITE_USAGE_ID NUMBER

Bill to site usage id
SHIP_TO_SITE_USAGE_CODE VARCHAR2 (40)
Ship to site usage code
SHIP_TO_SITE_USAGE_ID NUMBER

Ship to site usage id
BILLING_CONTACT_NAME VARCHAR2 (360)
Billing contact name
BILLING_CONTACT_ID NUMBER

Billing contact id
SHIPPING_CONTACT_NAME VARCHAR2 (360)
Shipping Contact Name
SHIPPING_CONTACT_ID NUMBER

Shipping Contact Id
RENEWAL_TYPE_CODE VARCHAR2 (30)
Renewal Type Code
CANCELLATION_DATE DATE

Cancellation Date
CANCELLATION_REASON VARCHAR2 (30)
Cancellation Reason
PRICE_LIST_NAME VARCHAR2 (240)
Price List Name
PRICE_LIST_ID NUMBER

Price List Id
INVOICE_TEXT VARCHAR2 (2000)
Invoice Text
PRINT_INVOICE VARCHAR2 (1)
Print Invoice
SUBTOTAL NUMBER

Subtotal to be populated for Subsciption lines
TAX_AMOUNT NUMBER

Tax Amount to be populated for Subsciption lines
TAX_EXEMPTION_CONTROL VARCHAR2 (30)
Tax Exemption Control
TAX_EXEMPTION_NUMBER VARCHAR2 (80)
Tax Exemption Number
TAX_CLASSIFICATION_CODE VARCHAR2 (30)
Tax Classification Code
PAYMENT_INSTRUCTION VARCHAR2 (3)
Payment Instruction
PO_REQUIRED VARCHAR2 (3)
Po Required
PAYMENT_INSTRUCTION_DETAILS VARCHAR2 (150)
Payment Instruction Details
PAYMENT_METHOD_CODE VARCHAR2 (30)
Payment Method Code
COMMITMENT_ID NUMBER

Commitment Id
ACCOUNTING_RULE_NAME VARCHAR2 (30)
Accounting Rule
ACCOUNTING_RULE_ID NUMBER

Accounting Rule Id
INVOICING_RULE_NAME VARCHAR2 (30)
Invoicing Rule Name
INVOICING_RULE_ID NUMBER

Invoicing Rule Id
BILLING_INTERVAL_DURATION NUMBER

Billing Interval Duration
BILLING_INTERVAL_PERIOD VARCHAR2 (30)
Billing Interval Period
FIRST_BILL_UPTO_DATE DATE

First Bill Upto Date
EXEMPT_REASON_CODE VARCHAR2 (30)
Exempt Reason Code
RECUR_BILL_OCCURANCES NUMBER

Frequency
SUBSCRIPTION_QUANTITY NUMBER

Subscription Quantity to be populated for Subsciption lines
QUANTITY_UOM VARCHAR2 (3)
Subscription quantity unit of measure code to be populated for Subsciption lines
PRICE_UOM VARCHAR2 (3)
Subscription price unit of measure code to be populated for Subsciption lines
UNIT_PRICE NUMBER

Subscription unit price to be populated for Subsciption lines
FIRST_BILLED_AMOUNT NUMBER

Subscription first bill amount to be populated for Subsciption lines
LAST_BILLED_AMOUNT NUMBER

Subscription last bill amount to be populated for Subsciption lines
USAGE_TYPE VARCHAR2 (10)
Usage Type
USAGE_PERIOD VARCHAR2 (3)
Usage Period
AVERAGING_INTERVAL NUMBER

Averaging Interval
SETTLEMENT_INTERVAL VARCHAR2 (30)
Settlement Interval
USAGE_TERMINATION_METHOD VARCHAR2 (30)
Usage Termination Method
Query Text

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


SELECT LINE_INTERFACE_ID
,      HEADER_INTERFACE_ID
,      LINE_NUMBER
,      LINE_TYPE
,      ITEM_ORGANIZATION_ID
,      ITEM_NAME
,      ITEM_ID
,      REFERENCE_TEMPLATE_ID
,      LINE_REFERENCE
,      STATUS_CODE
,      START_DATE
,      END_DATE
,      BILL_TO_SITE_USAGE_CODE
,      BILL_TO_SITE_USAGE_ID
,      SHIP_TO_SITE_USAGE_CODE
,      SHIP_TO_SITE_USAGE_ID
,      BILLING_CONTACT_NAME
,      BILLING_CONTACT_ID
,      SHIPPING_CONTACT_NAME
,      SHIPPING_CONTACT_ID
,      RENEWAL_TYPE_CODE
,      CANCELLATION_DATE
,      CANCELLATION_REASON
,      PRICE_LIST_NAME
,      PRICE_LIST_ID
,      INVOICE_TEXT
,      PRINT_INVOICE
,      SUBTOTAL
,      TAX_AMOUNT
,      TAX_EXEMPTION_CONTROL
,      TAX_EXEMPTION_NUMBER
,      TAX_CLASSIFICATION_CODE
,      PAYMENT_INSTRUCTION
,      PO_REQUIRED
,      PAYMENT_INSTRUCTION_DETAILS
,      PAYMENT_METHOD_CODE
,      COMMITMENT_ID
,      ACCOUNTING_RULE_NAME
,      ACCOUNTING_RULE_ID
,      INVOICING_RULE_NAME
,      INVOICING_RULE_ID
,      BILLING_INTERVAL_DURATION
,      BILLING_INTERVAL_PERIOD
,      FIRST_BILL_UPTO_DATE
,      EXEMPT_REASON_CODE
,      RECUR_BILL_OCCURANCES
,      SUBSCRIPTION_QUANTITY
,      QUANTITY_UOM
,      PRICE_UOM
,      UNIT_PRICE
,      FIRST_BILLED_AMOUNT
,      LAST_BILLED_AMOUNT
,      USAGE_TYPE
,      USAGE_PERIOD
,      AVERAGING_INTERVAL
,      SETTLEMENT_INTERVAL
,      USAGE_TERMINATION_METHOD
FROM OKS.OKS_LINES_INTERFACE;

Dependencies

[top of page]

OKS.OKS_LINES_INTERFACE does not reference any database object

OKS.OKS_LINES_INTERFACE is referenced by following:

SchemaAPPS
SynonymOKS_LINES_INTERFACE