eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKS_LINES_INTERFACE_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LINE_INTERFACE_ID
OKS_LINES_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	HEADER_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:

OKS: OKS_LINES_INTERFACE#