[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKS_ENT_HEADERS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  OKS.OKS_ENT_HEADERS_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View of all contracts Header Information
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ORG_ID | NUMBER | Yes | Organization Identifier | |
| 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. |
| SHORT_DESCRIPTION | VARCHAR2 | (600) | Short Description | |
| CONTRACT_AMOUNT | NUMBER | Contract Amount | ||
| CONTRACT_STATUS_CODE | VARCHAR2 | (30) | Yes | Contract Status Code |
| CONTRACT_TYPE_CODE | VARCHAR2 | (30) | Yes | Contract Type Code |
| PARTY_ID | NUMBER | Party Identifier. Party of the Contract | ||
| CONTRACT_TEMPLATE_YN | VARCHAR2 | (3) | Yes | Template Flag. Possible Values Y or N |
| CONTRACT_TEMPLATE_USED | VARCHAR2 | (120) | Template Used | |
| DURATION | NUMBER | Duration of the Contract | ||
| PERIOD_CODE | VARCHAR2 | (25) | Period of the Contract | |
| START_DATE_ACTIVE | DATE | Start Date Active of the Contract | ||
| END_DATE_ACTIVE | DATE | End Date Active of the Contract | ||
| BILL_TO_SITE_USE_ID | NUMBER | (15) | Bill to Site Use Identifier | |
| SHIP_TO_SITE_USE_ID | NUMBER | (15) | Ship to Site Use Identifier | |
| AGREEMENT_ID | NUMBER | Agreement Identifier | ||
| PRICE_LIST_ID | NUMBER | Price List Identifier | ||
| MODIFIER | VARCHAR2 | (0) | Modifier | |
| CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
| ACCOUNTING_RULE_ID | NUMBER | Accounting rule Identifier | ||
| INVOICING_RULE_ID | NUMBER | (15) | Invoicing rule Identifier | |
| TERMS_ID | NUMBER | (15) | Terms Identifier | |
| PO_NUMBER | VARCHAR2 | (150) | Purchase Order number | |
| BILLING_PROFILE_ID | NUMBER | Billing Profile Identifier | ||
| BILLING_FREQUENCY | VARCHAR2 | (0) | Billing Frequency | |
| BILLING_METHOD | VARCHAR2 | (0) | Billing Method | |
| REGULAR_OFFSET_DAYS | VARCHAR2 | (0) | Regular Offset Days | |
| FIRST_BILL_TO | VARCHAR2 | (0) | First Bill To Date | |
| FIRST_BILL_ON | VARCHAR2 | (0) | First Bill On date | |
| AUTO_RENEW_BEFORE_DAYS | NUMBER | (4) | Automatic Renewal of the contract before days. | |
| QA_CHECK_LIST_ID | NUMBER | QA Check List Identifier | ||
| RENEWAL_NOTE | VARCHAR2 | (0) | Renewal Note | |
| TERMINATION_NOTE | VARCHAR2 | (0) | Termination Note | |
| TAX_EXEMPTION | NUMBER | Tax Exemption Code | ||
| TAX_STATUS | VARCHAR2 | (30) | Tax Status | |
| CONVERSION_TYPE | VARCHAR2 | (30) | Conversion Type(Currency) | |
| PERIOD_TYPE | VARCHAR2 | (10) | Partial Period attribute that defines how partial periods are calculated. 'Service Start' - count full periods from service start date, then partial period at end.'Calendar Month Start' - count full periods based on full calendar months that span the duration. Partial period can occur at beginning of duration, end of duration, or at both beginning and end of the duration. | |
| PERIOD_START | VARCHAR2 | (30) | Partial Period attribute represents type of period i.e. Fixed or Actual. While calculating partial periods, 'Fixed' type divides number of days in partial period by 30 days all months, 'Actual' the divides with actual number days in the calendar month. | |
| PRICE_UOM | VARCHAR2 | (10) | Partial Periods Computation - Price UOM used for partial period computation |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_ID
, CONTRACT_ID
, CONTRACT_NUMBER
, SHORT_DESCRIPTION
, CONTRACT_AMOUNT
, CONTRACT_STATUS_CODE
, CONTRACT_TYPE_CODE
, PARTY_ID
, CONTRACT_TEMPLATE_YN
, CONTRACT_TEMPLATE_USED
, DURATION
, PERIOD_CODE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, BILL_TO_SITE_USE_ID
, SHIP_TO_SITE_USE_ID
, AGREEMENT_ID
, PRICE_LIST_ID
, MODIFIER
, CURRENCY_CODE
, ACCOUNTING_RULE_ID
, INVOICING_RULE_ID
, TERMS_ID
, PO_NUMBER
, BILLING_PROFILE_ID
, BILLING_FREQUENCY
, BILLING_METHOD
, REGULAR_OFFSET_DAYS
, FIRST_BILL_TO
, FIRST_BILL_ON
, AUTO_RENEW_BEFORE_DAYS
, QA_CHECK_LIST_ID
, RENEWAL_NOTE
, TERMINATION_NOTE
, TAX_EXEMPTION
, TAX_STATUS
, CONVERSION_TYPE
, PERIOD_TYPE
, PERIOD_START
, PRICE_UOM
FROM APPS.OKS_ENT_HEADERS_V;
APPS
OKC_K_HEADERS_ALL_B
OKC_K_HEADERS_TL
OKC_K_PARTY_ROLES_B
OKS_ENT_UTIL_PVT
- show dependent code
OKS_K_HEADERS_B
APPS
CS_CONTRACT_COVERAGES_V
|
|
|
|