Skip to content

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

VIEW: OKS.OKS_CON_HEADERS_INT_ALL#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
CONTRACT_ID NUMBER
Yes
CONTRACT_NUMBER VARCHAR2 (120) Yes
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
BATCH_NUMBER NUMBER
Yes
CONTRACT_AMOUNT NUMBER

ORDER_HEADER_ID NUMBER

SHORT_DESCRIPTION VARCHAR2 (600)
KNOWN_AS VARCHAR2 (120)
START_DATE DATE
Yes
END_DATE DATE
Yes
CONTRACT_CATEGORY_CODE VARCHAR2 (30) Yes
STATUS_CODE VARCHAR2 (30) Yes
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
CONTEXT VARCHAR2 (150)
ORG_ID NUMBER

INV_ORGANIZATION_ID NUMBER

CUSTOMER_ID NUMBER
Yes
THIRD_PARTY_ID NUMBER

BILL_TO_SITE_USE_ID NUMBER
Yes
SHIP_TO_SITE_USE_ID NUMBER

SALESPERSON_ID NUMBER

AGREEMENT_ID NUMBER

PRICE_LIST_ID NUMBER
Yes
INVOICING_RULE_ID NUMBER
Yes
ACCOUNTING_RULE_ID NUMBER
Yes
PAYMENT_TERMS_ID NUMBER
Yes
CURRENCY_CODE VARCHAR2 (15) Yes
CONVERSION_TYPE_CODE VARCHAR2 (30)
CONVERSION_RATE NUMBER

CONVERSION_DATE DATE

PRE_PAYMENT_REQUIRED VARCHAR2 (1)
PO_REQUIRED VARCHAR2 (1)
PO_NUMBER VARCHAR2 (30)
BILLING_TXN_TYPE_ID NUMBER

AR_INTERFACE_YN VARCHAR2 (1)
HOLD_BILLING_YN VARCHAR2 (1)
SUMMARY_INVOICE_YN VARCHAR2 (1)
TAX_EXEMPT_STATUS VARCHAR2 (80)
TAX_EXEMPT_NUM VARCHAR2 (80)
TAX_EXEMPT_REASON_CODE VARCHAR2 (30)
RENEWAL_TYPE VARCHAR2 (50)
RENEW_UPTO_DATE DATE

RENEWAL_PRICING_METHOD VARCHAR2 (30)
RENEWAL_PRICE_LIST_ID NUMBER

RENEWAL_MARKUP VARCHAR2 (20)
RENEWAL_PO_REQUIRED_YN VARCHAR2 (1)
RENEWAL_PO_NUMBER VARCHAR2 (30)
RENEWAL_ESTIMATED_PERCENT NUMBER

RENEWAL_DURATION NUMBER

RENEWAL_PERIOD_UOM NUMBER

DATE_APPROVED DATE

DATE_SIGNED DATE

DATE_CANCELED DATE

DATE_TERMINATED DATE

DATE_RENEWED DATE

QA_CHECK_ID NUMBER

TEMPLATE_YN VARCHAR2 (1)
CONTRACT_GROUP_ID NUMBER

APPROVAL_WF_PROCESS_ID NUMBER

RENEWAL_WF_PROCESS_ID NUMBER

TERMINATE_WF_PROCESS_ID NUMBER

CREDIT_CARD_NUMBER NUMBER

CREDIT_CARD_EXP_DATE DATE

COMMENTS VARCHAR2 (2000)
INTERFACED_STATUS_FLAG VARCHAR2 (1)
CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

BILLING_PROFILE_ID NUMBER

REQUEST_ID NUMBER

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# references the following:

SchemaOKS
TableOKS_CON_HEADERS_INT_ALL
OKS.OKS_CON_HEADERS_INT_ALL# is referenced by following:

SchemaAPPS
SynonymOKS_CON_HEADERS_INT_ALL