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: OKI.OKI_SALES_K_HDRS

Object Details

Object Name:	OKI_SALES_K_HDRS
Object Type:	TABLE
Owner:	OKI
FND Design Data:	OKI.OKI_SALES_K_HDRS
Subobject Name:
Status:	VALID

Denormalized table for contract headers and related information for contracts of the sell intent. It is maintained by the Load Sales Contract Headers, Contracts Intelligence concurrent manager job. In order to appear in this table, the contract must be of the sell intent and not be a template. Some currency conversion is done when adding a contract to this table, including converting the contract currency to a base currency in order to speed up display in the HTML bins. If no conversion is specified from the contract currency to the base currency, as defined by the profile option OKI_BASE_CURRENCY_CODE, the contract will not appear in this table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKI_SALES_K_HDRS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CHR_ID
OKI_SALES_K_HDRS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	CONTRACT_NUMBER CONTRACT_NUMBER_MODIFIER
OKI_SALES_K_HDRS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	IS_NEW_YN
OKI_SALES_K_HDRS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_NAME
OKI_SALES_K_HDRS_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMPLETE_CONTRACT_NUMBER
OKI_SALES_K_HDRS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CLOSE_DATE
OKI_SALES_K_HDRS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	END_DATE
OKI_SALES_K_HDRS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_PARTY_ID
OKI_SALES_K_HDRS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DATE_CANCELED
OKI_SALES_K_HDRS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	START_DATE
OKI_SALES_K_HDRS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DATE_TERMINATED
OKI_SALES_K_HDRS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AUTHORING_ORG_ID
OKI_SALES_K_HDRS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DATE_APPROVED

Columns

Name	Datatype	Length	Mandatory	Comments
CHR_ID	NUMBER		Yes	The internal contract header identifier.
CONTRACT_NUMBER	VARCHAR2	(120)		Contract number for this contract.
CONTRACT_NUMBER_MODIFIER	VARCHAR2	(120)		Contract number modifier for this contract.
COMPLETE_CONTRACT_NUMBER	VARCHAR2	(241)		Concatenated contract number and modifier.
AUTHORING_ORG_ID	NUMBER			The internal identifier of the operating unit in which the contract was authored.
ORGANIZATION_NAME	VARCHAR2	(240)		The name of the operating unit in which the contract was authored.
SCS_CODE	VARCHAR2	(30)		The category (sub-class) code for the contract.
STS_CODE	VARCHAR2	(30)		The code value representing the status type of the contract, such as ACTIVE or ENTERED.
STE_CODE	VARCHAR2	(30)		The code value representing the status type of the contract, such as ACTIVE or ENTERED.
CUSTOMER_PARTY_ID	NUMBER			The internal party identifier of the contract customer.
CUSTOMER_NAME	VARCHAR2	(360)		The name of the customer in the contract.
CONTRACT_AMOUNT	NUMBER			The total amount of the contract, in the contract transaction currency.
CURRENCY_CODE	VARCHAR2	(15)		The currency code of the contract transaction currency.
CONTRACT_AMOUNT_RENEWED	NUMBER			The amount of the contract renewed by this contract, in the transaction currency.
CURRENCY_CODE_RENEWED	VARCHAR2	(15)		The transaction currency code of the contract renewed by this contract.
WIN_PERCENT	NUMBER			The estimated percentage probability that the contract will be signed.
FORECAST_AMOUNT	NUMBER			The forecasted value of the contract.
SOB_ID	NUMBER			The internal identifier for the set of books.
SOB_CONTRACT_AMOUNT	NUMBER			The amount of the contract, converted into the set of books currency.
SOB_FORECAST_AMOUNT	NUMBER			The forecasted amount of this contract, converted into the set of books currency.
SOB_CONTRACT_AMOUNT_RENEWED	NUMBER			The amount of the contract renewed by this contract, converted into the set of books currency.
SOB_CURRENCY_CODE	VARCHAR2	(15)		The set of books currency code.
BASE_CONTRACT_AMOUNT	NUMBER			The value of the contract, in the base currency.
BASE_FORECAST_AMOUNT	NUMBER			The forecasted amount for the contract, in the base currency.
BASE_CONTRACT_AMOUNT_RENEWED	NUMBER			The amount of the contract renewed by this contract, in the base currency.
BASE_CURRENCY_CODE	VARCHAR2	(15)		The currency code of the base currency.
CLOSE_DATE	DATE			The expected renewal close date.
START_DATE	DATE			The starting effective date of the contract.
END_DATE	DATE			The ending effective date of the contract.
DATE_APPROVED	DATE			The date the contract was approved.
DATE_SIGNED	DATE			The date the contract was signed.
DATE_RENEWED	DATE			The date the contract was renewed.
DATE_CANCELED	DATE			The date the contract was canceled.
DATE_TERMINATED	DATE			The date the contract was terminated.
START_PERIOD_NUM	NUMBER	(15)		The number of the General Ledger period in which the contract starts.
START_PERIOD_NAME	VARCHAR2	(15)		The name of the General Ledger period in which the contract starts.
START_QUARTER	NUMBER	(15)		The General Ledger quarter in which the contract starts.
START_YEAR	NUMBER	(15)		The General Ledger year in which the contract starts.
CLOSE_PERIOD_NUM	NUMBER	(15)		The General Ledger period nunber in which the contract is expected to close.
CLOSE_PERIOD_NAME	VARCHAR2	(15)		The General Ledger period name in which the contract is expected to close.
CLOSE_QUARTER	NUMBER	(15)		The General Ledger quarter in which the contract is expected to close.
CLOSE_YEAR	NUMBER	(15)		The General Ledger year in which the contract is expected to close.
TRN_CODE	VARCHAR2	(30)		The contract termination reason code.
INVENTORY_ORGANIZATION_ID	NUMBER			The internal identifier for the inventory organization.
IS_NEW_YN	VARCHAR2	(240)		Indicates if this is a new or renewed contract, where a Y means it is a new contract.
IS_LATEST_YN	VARCHAR2	(1)		Indicates if this is the latest renewal for a contract, where 'N' means it is not.
MAJOR_VERSION	NUMBER			The major version of the contract header
MINOR_VERSION	NUMBER			The minor version of the contract header
APPLICATION_ID	NUMBER			The internal identifier of the Oracle Application that created the contract.
CREATION_DATE	DATE			Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column.
ATTRIBUTE_CATEGORY	VARCHAR2	(90)		Descriptive Flexfield structure defining column.
ATTRIBUTE1	VARCHAR2	(450)		Descriptive Flexfield segment column.
ATTRIBUTE2	VARCHAR2	(450)		Descriptive Flexfield segment column.
ATTRIBUTE3	VARCHAR2	(450)		Descriptive Flexfield segment column.
ATTRIBUTE4	VARCHAR2	(450)		Descriptive Flexfield segment column.
ATTRIBUTE5	VARCHAR2	(450)		Descriptive Flexfield segment column.
ATTRIBUTE6	VARCHAR2	(450)		Descriptive Flexfield segment column.
ATTRIBUTE7	VARCHAR2	(450)		Descriptive Flexfield segment column.
ATTRIBUTE8	VARCHAR2	(450)		Descriptive Flexfield segment column.
ATTRIBUTE9	VARCHAR2	(450)		Descriptive Flexfield segment column.
ATTRIBUTE10	VARCHAR2	(450)		Descriptive Flexfield segment column.
ATTRIBUTE11	VARCHAR2	(450)		Descriptive Flexfield segment column.
ATTRIBUTE12	VARCHAR2	(450)		Descriptive Flexfield segment column.
ATTRIBUTE13	VARCHAR2	(450)		Descriptive Flexfield segment column.
ATTRIBUTE14	VARCHAR2	(450)		Descriptive Flexfield segment column.
ATTRIBUTE15	VARCHAR2	(450)		Descriptive Flexfield segment column.
SECURITY_GROUP_ID	NUMBER			Used for application hosting.
ORDER_NUMBER	VARCHAR2	(22)		Order number
CUSTOMER_NUMBER	VARCHAR2	(30)		Customer number
DURATION	NUMBER			Duration of the contract
PERIOD	VARCHAR2	(30)		Period code of the duration
TERMINATED_AMOUNT	NUMBER			Terminated amount
SOB_TERMINATED_AMOUNT	NUMBER			erminated amount in functional currency
BASE_TERMINATED_AMOUNT	NUMBER			Terminated amount in base currency
ORIG_SYSTEM_SOURCE_CODE	VARCHAR2	(30)		Original system source code
ORIG_SYSTEM_ID1	NUMBER			Original system id1
ORIG_SYSTEM_REFERENCE1	VARCHAR2	(30)		Original system reference1
CONTRACT_TYPE	VARCHAR2	(30)		Contract type
ACCT_RULE_ID	NUMBER			Accounting rule ID
INV_RULE_ID	NUMBER	(15)		Invoicing rule ID
GRACE_DURATION	NUMBER			Duration for which the contract line will be kept active even after the end date.
GRACE_PERIOD_CODE	VARCHAR2	(30)		Period for which the contract line will be kept active even after the line end date
AGREEMENT_ID	NUMBER			Agreement ID
LIST_HEADER_ID	NUMBER			Price list ID
PAYMENT_TERM_ID	NUMBER	(15)		Payment term ID
QUOTE_TO_CONTACT_ID	NUMBER			Quote to contact ID
QUOTE_TO_SITE_ID	NUMBER			Quote to sIte ID
QUOTE_TO_EMAIL_ID	NUMBER			Quote to email ID
QUOTE_TO_PHONE_ID	NUMBER			Quote to phone ID
QUOTE_TO_FAX_ID	NUMBER			Quote to fax ID
RENEWAL_TYPE_USED	VARCHAR2	(10)		Renewal Type Used

Query Text

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


SELECT CHR_ID
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      COMPLETE_CONTRACT_NUMBER
,      AUTHORING_ORG_ID
,      ORGANIZATION_NAME
,      SCS_CODE
,      STS_CODE
,      STE_CODE
,      CUSTOMER_PARTY_ID
,      CUSTOMER_NAME
,      CONTRACT_AMOUNT
,      CURRENCY_CODE
,      CONTRACT_AMOUNT_RENEWED
,      CURRENCY_CODE_RENEWED
,      WIN_PERCENT
,      FORECAST_AMOUNT
,      SOB_ID
,      SOB_CONTRACT_AMOUNT
,      SOB_FORECAST_AMOUNT
,      SOB_CONTRACT_AMOUNT_RENEWED
,      SOB_CURRENCY_CODE
,      BASE_CONTRACT_AMOUNT
,      BASE_FORECAST_AMOUNT
,      BASE_CONTRACT_AMOUNT_RENEWED
,      BASE_CURRENCY_CODE
,      CLOSE_DATE
,      START_DATE
,      END_DATE
,      DATE_APPROVED
,      DATE_SIGNED
,      DATE_RENEWED
,      DATE_CANCELED
,      DATE_TERMINATED
,      START_PERIOD_NUM
,      START_PERIOD_NAME
,      START_QUARTER
,      START_YEAR
,      CLOSE_PERIOD_NUM
,      CLOSE_PERIOD_NAME
,      CLOSE_QUARTER
,      CLOSE_YEAR
,      TRN_CODE
,      INVENTORY_ORGANIZATION_ID
,      IS_NEW_YN
,      IS_LATEST_YN
,      MAJOR_VERSION
,      MINOR_VERSION
,      APPLICATION_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      ORDER_NUMBER
,      CUSTOMER_NUMBER
,      DURATION
,      PERIOD
,      TERMINATED_AMOUNT
,      SOB_TERMINATED_AMOUNT
,      BASE_TERMINATED_AMOUNT
,      ORIG_SYSTEM_SOURCE_CODE
,      ORIG_SYSTEM_ID1
,      ORIG_SYSTEM_REFERENCE1
,      CONTRACT_TYPE
,      ACCT_RULE_ID
,      INV_RULE_ID
,      GRACE_DURATION
,      GRACE_PERIOD_CODE
,      AGREEMENT_ID
,      LIST_HEADER_ID
,      PAYMENT_TERM_ID
,      QUOTE_TO_CONTACT_ID
,      QUOTE_TO_SITE_ID
,      QUOTE_TO_EMAIL_ID
,      QUOTE_TO_PHONE_ID
,      QUOTE_TO_FAX_ID
,      RENEWAL_TYPE_USED
FROM OKI.OKI_SALES_K_HDRS;

Dependencies

[top of page]

OKI.OKI_SALES_K_HDRS does not reference any database object

OKI.OKI_SALES_K_HDRS is referenced by following:

APPS: OKI_SALES_K_HDRS