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

TABLE: OKS.OKS_CON_LINES_INT_ALL

Object Details
Object Name: OKS_CON_LINES_INT_ALL
Object Type: TABLE
Owner: OKS
FND Design Data: TableOKS.OKS_CON_LINES_INT_ALL
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CONTRACT_LINE_ID NUMBER

Contract Line Id
CONTRACT_ID NUMBER

FK to Contract Header.
CONTRACT_LINE_NUMBER VARCHAR2 (150)
Contract Line Number
CONTRACT_LINE_TYPE VARCHAR2 (120)
Contract Line Type
SERVICE_INVENTORY_ITEM_ID NUMBER

Service Inventory Item Id
SERVICE_MANUFACTURING_ORG_ID NUMBER

Service Manufacturing Org Id
CONTRACT_LINE_REF VARCHAR2 (300)
Contract Line Ref
ORDER_HEADER_ID NUMBER

Order Header Id
ORDER_LINE_ID NUMBER

Order Line Id
CUST_ACCOUNT_ID NUMBER

Cust Account Id
CUST_BILL_TO_SITE_USE_ID NUMBER

Cust Bill To Site Use Id
CUST_SHIP_TO_SITE_USE_ID NUMBER

Cust Ship To Site Use Id
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Typically, a reference field from which a descriptive flexfield can get a context field value (optional, but recommended).
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield
BILL_TO_CONTACT_ID NUMBER

Bill To Contact Id
SHIP_TO_CONTACT_ID NUMBER

Ship To Contact Id
LINE_STATUS_CODE VARCHAR2 (30)
Line Status Code
START_DATE DATE

Start Date
END_DATE DATE

End Date
RENEWAL_TYPE VARCHAR2 (100)
Renewal Type
INVOICE_TEXT VARCHAR2 (300)
Text of the Invoice.
COVERAGE_ID NUMBER

Internal Unique Identifier of a Coverage.
COVERAGE_TEMPLATE_ID NUMBER

Coverage Template Id
EXCEPT_COVERAGE_ID NUMBER

Except Coverage Id
PRICE_LIST_ID NUMBER

Price List Id
PRICE_UNIT NUMBER

Price Unit
PRICE_NEGOTIATED NUMBER

Price Negotiated
PRICE_UNIT_PERCENT NUMBER

Price Unit Percent
CURRENCY_CODE VARCHAR2 (30)
Currency Code
CONVERSION_TYPE VARCHAR2 (30)
Conversion Type
CONVERSION_RATE NUMBER

Conversion Rate
CONVERSION_DATE DATE

Conversion Date
INVOICE_PRINT_FLAG VARCHAR2 (30)
Invoice Print Flag
ACCOUNTING_RULE_ID NUMBER

Accounting Rule Id
INVOICING_RULE_ID NUMBER

Invoicing Rule Id
PAYMENT_TERMS_ID NUMBER

Payment Terms Id
SUMMARY_INVOICE_YN VARCHAR2 (1)
Summary Invoice Yn
RENEWAL_PO_NUMBER VARCHAR2 (30)
Renewal Po Number
AR_INTERFACE_YN VARCHAR2 (1)
Ar Interface Yn
HOLD_BILLING_YN VARCHAR2 (1)
Hold Billing Yn
BILLING_TXN_TYPE_ID NUMBER

Billing Txn Type Id
TAX_STATUS VARCHAR2 (30)
Tax Status
TAX_EXEMPT_NUMBER VARCHAR2 (30)
Tax Exempt Number
TAX_CODE VARCHAR2 (30)
Tax Code
TAX_EXEMPT_REASON VARCHAR2 (100)
Tax Exempt Reason
CREATED_BY NUMBER (15)
ID of the user whom created the record.
CREATION_DATE DATE

Date the record was created.
LAST_UPDATED_BY NUMBER (15)
ID of the last user who updated the record.
LAST_UPDATE_DATE DATE

Date the record was last updated.
LAST_UPDATE_LOGIN NUMBER (15)
OS ID of the user who last updated the record.
AUTHORING_ORG_ID NUMBER (15)
Authoring Org Id
INTERFACED_STATUS_FLAG VARCHAR2 (1)
Interfaced Status Flag
MERGE_ID NUMBER

Merge Id
Query Text

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


SELECT CONTRACT_LINE_ID
,      CONTRACT_ID
,      CONTRACT_LINE_NUMBER
,      CONTRACT_LINE_TYPE
,      SERVICE_INVENTORY_ITEM_ID
,      SERVICE_MANUFACTURING_ORG_ID
,      CONTRACT_LINE_REF
,      ORDER_HEADER_ID
,      ORDER_LINE_ID
,      CUST_ACCOUNT_ID
,      CUST_BILL_TO_SITE_USE_ID
,      CUST_SHIP_TO_SITE_USE_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      BILL_TO_CONTACT_ID
,      SHIP_TO_CONTACT_ID
,      LINE_STATUS_CODE
,      START_DATE
,      END_DATE
,      RENEWAL_TYPE
,      INVOICE_TEXT
,      COVERAGE_ID
,      COVERAGE_TEMPLATE_ID
,      EXCEPT_COVERAGE_ID
,      PRICE_LIST_ID
,      PRICE_UNIT
,      PRICE_NEGOTIATED
,      PRICE_UNIT_PERCENT
,      CURRENCY_CODE
,      CONVERSION_TYPE
,      CONVERSION_RATE
,      CONVERSION_DATE
,      INVOICE_PRINT_FLAG
,      ACCOUNTING_RULE_ID
,      INVOICING_RULE_ID
,      PAYMENT_TERMS_ID
,      SUMMARY_INVOICE_YN
,      RENEWAL_PO_NUMBER
,      AR_INTERFACE_YN
,      HOLD_BILLING_YN
,      BILLING_TXN_TYPE_ID
,      TAX_STATUS
,      TAX_EXEMPT_NUMBER
,      TAX_CODE
,      TAX_EXEMPT_REASON
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      AUTHORING_ORG_ID
,      INTERFACED_STATUS_FLAG
,      MERGE_ID
FROM OKS.OKS_CON_LINES_INT_ALL;

Dependencies

[top of page]

OKS.OKS_CON_LINES_INT_ALL does not reference any database object

OKS.OKS_CON_LINES_INT_ALL is referenced by following:

SchemaOKS
ViewOKS_CON_LINES_INT_ALL#