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

TABLE: OKS.OKS_CON_HEADERS_INT_ALL

Object Details
Object Name: OKS_CON_HEADERS_INT_ALL
Object Type: TABLE
Owner: OKS
FND Design Data: TableOKS.OKS_CON_HEADERS_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_ID NUMBER
Yes FK to Contract Header.
CONTRACT_NUMBER VARCHAR2 (120) Yes With CONTRACT_NUMBER_MODIFIER, used to uniquely identify a contract as a business entity.
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
With CONTRACT_NUMBER, used to uniquely identify a contract as a business entity.
BATCH_NUMBER NUMBER
Yes Batch Identifier to be used by Import Concurrent Process.
CONTRACT_AMOUNT NUMBER

Contract Amount
ORDER_HEADER_ID NUMBER

Order Header Id
SHORT_DESCRIPTION VARCHAR2 (600)
Short Description
KNOWN_AS VARCHAR2 (120)
Known As
START_DATE DATE
Yes Start Date
END_DATE DATE
Yes End Date
CONTRACT_CATEGORY_CODE VARCHAR2 (30) Yes Contract Category Code
STATUS_CODE VARCHAR2 (30) Yes Status Code
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
CONTEXT VARCHAR2 (150)
Context
ORG_ID NUMBER

Org Id
INV_ORGANIZATION_ID NUMBER

Inv Organization Id
CUSTOMER_ID NUMBER
Yes Customer Id
THIRD_PARTY_ID NUMBER

Third Party Id
BILL_TO_SITE_USE_ID NUMBER
Yes Bill To Site Use Id
SHIP_TO_SITE_USE_ID NUMBER

Ship To Site Use Id
SALESPERSON_ID NUMBER

Salesperson Id
AGREEMENT_ID NUMBER

Agreement Id
PRICE_LIST_ID NUMBER
Yes Price List Id
INVOICING_RULE_ID NUMBER
Yes Invoicing Rule Id
ACCOUNTING_RULE_ID NUMBER
Yes Accounting Rule Id
PAYMENT_TERMS_ID NUMBER
Yes Payment Terms Id
CURRENCY_CODE VARCHAR2 (15) Yes Currency Code
CONVERSION_TYPE_CODE VARCHAR2 (30)
Conversion Type Code
CONVERSION_RATE NUMBER

Conversion Rate
CONVERSION_DATE DATE

Conversion Date
PRE_PAYMENT_REQUIRED VARCHAR2 (1)
Pre Payment Required
PO_REQUIRED VARCHAR2 (1)
Po Required
PO_NUMBER VARCHAR2 (30)
Po Number
BILLING_TXN_TYPE_ID NUMBER

Billing Txn Type Id
AR_INTERFACE_YN VARCHAR2 (1)
Ar Interface Yn
HOLD_BILLING_YN VARCHAR2 (1)
Hold Billing Yn
SUMMARY_INVOICE_YN VARCHAR2 (1)
Summary Invoice Yn
TAX_EXEMPT_STATUS VARCHAR2 (80)
Tax Exempt Status
TAX_EXEMPT_NUM VARCHAR2 (80)
Tax Exempt Num
TAX_EXEMPT_REASON_CODE VARCHAR2 (30)
Tax Exempt Reason Code
RENEWAL_TYPE VARCHAR2 (50)
Renewal Type
RENEW_UPTO_DATE DATE

Renew Upto Date
RENEWAL_PRICING_METHOD VARCHAR2 (30)
Renewal Pricing Method
RENEWAL_PRICE_LIST_ID NUMBER

Renewal Price List Id
RENEWAL_MARKUP VARCHAR2 (20)
Renewal Markup
RENEWAL_PO_REQUIRED_YN VARCHAR2 (1)
Renewal Po Required Yn
RENEWAL_PO_NUMBER VARCHAR2 (30)
Renewal Po Number
RENEWAL_ESTIMATED_PERCENT NUMBER

Renewal Estimated Percent
RENEWAL_DURATION NUMBER

Renewal Duration
RENEWAL_PERIOD_UOM NUMBER

Renewal Period Uom
DATE_APPROVED DATE

Date Approved
DATE_SIGNED DATE

Date Signed
DATE_CANCELED DATE

Date Canceled
DATE_TERMINATED DATE

Date Terminated
DATE_RENEWED DATE

Date Renewed
QA_CHECK_ID NUMBER

Qa Check Id
TEMPLATE_YN VARCHAR2 (1)
Template Yn
CONTRACT_GROUP_ID NUMBER

Contract Group Id
APPROVAL_WF_PROCESS_ID NUMBER

Approval Wf Process Id
RENEWAL_WF_PROCESS_ID NUMBER

Renewal Wf Process Id
TERMINATE_WF_PROCESS_ID NUMBER

Terminate Wf Process Id
CREDIT_CARD_NUMBER NUMBER

Credit Card Number
CREDIT_CARD_EXP_DATE DATE

Credit Card Exp Date
COMMENTS VARCHAR2 (2000)
Comments
INTERFACED_STATUS_FLAG VARCHAR2 (1)
Interfaced Status Flag
CREATION_DATE DATE

Date the record was created.
CREATED_BY NUMBER

ID of the user whom created the record.
LAST_UPDATE_DATE DATE

Date the record was last updated.
LAST_UPDATED_BY NUMBER

ID of the last user who updated the record.
LAST_UPDATE_LOGIN NUMBER

OS ID of the user who last updated the record.
BILLING_PROFILE_ID NUMBER

Billing Profile Id
REQUEST_ID NUMBER

Unique Identifier of a concurrent request.
Query Text

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


SELECT CONTRACT_ID
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      BATCH_NUMBER
,      CONTRACT_AMOUNT
,      ORDER_HEADER_ID
,      SHORT_DESCRIPTION
,      KNOWN_AS
,      START_DATE
,      END_DATE
,      CONTRACT_CATEGORY_CODE
,      STATUS_CODE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CONTEXT
,      ORG_ID
,      INV_ORGANIZATION_ID
,      CUSTOMER_ID
,      THIRD_PARTY_ID
,      BILL_TO_SITE_USE_ID
,      SHIP_TO_SITE_USE_ID
,      SALESPERSON_ID
,      AGREEMENT_ID
,      PRICE_LIST_ID
,      INVOICING_RULE_ID
,      ACCOUNTING_RULE_ID
,      PAYMENT_TERMS_ID
,      CURRENCY_CODE
,      CONVERSION_TYPE_CODE
,      CONVERSION_RATE
,      CONVERSION_DATE
,      PRE_PAYMENT_REQUIRED
,      PO_REQUIRED
,      PO_NUMBER
,      BILLING_TXN_TYPE_ID
,      AR_INTERFACE_YN
,      HOLD_BILLING_YN
,      SUMMARY_INVOICE_YN
,      TAX_EXEMPT_STATUS
,      TAX_EXEMPT_NUM
,      TAX_EXEMPT_REASON_CODE
,      RENEWAL_TYPE
,      RENEW_UPTO_DATE
,      RENEWAL_PRICING_METHOD
,      RENEWAL_PRICE_LIST_ID
,      RENEWAL_MARKUP
,      RENEWAL_PO_REQUIRED_YN
,      RENEWAL_PO_NUMBER
,      RENEWAL_ESTIMATED_PERCENT
,      RENEWAL_DURATION
,      RENEWAL_PERIOD_UOM
,      DATE_APPROVED
,      DATE_SIGNED
,      DATE_CANCELED
,      DATE_TERMINATED
,      DATE_RENEWED
,      QA_CHECK_ID
,      TEMPLATE_YN
,      CONTRACT_GROUP_ID
,      APPROVAL_WF_PROCESS_ID
,      RENEWAL_WF_PROCESS_ID
,      TERMINATE_WF_PROCESS_ID
,      CREDIT_CARD_NUMBER
,      CREDIT_CARD_EXP_DATE
,      COMMENTS
,      INTERFACED_STATUS_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      BILLING_PROFILE_ID
,      REQUEST_ID
FROM OKS.OKS_CON_HEADERS_INT_ALL;

Dependencies

[top of page]

OKS.OKS_CON_HEADERS_INT_ALL does not reference any database object

OKS.OKS_CON_HEADERS_INT_ALL is referenced by following:

SchemaOKS
ViewOKS_CON_HEADERS_INT_ALL#