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

VIEW: APPS.OKI_SALES_K_NEW_V

Object Details
Object Name: OKI_SALES_K_NEW_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKI.OKI_SALES_K_NEW_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view is a subset of the contracts in OKI_SALES_K_HEADERS_V, showing only those contracts that are "new", i.e. they are not renewal contracts.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CONTRACT_ID NUMBER
Yes The internal identifier of the contract.
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.
SHORT_DESCRIPTION VARCHAR2 (600)
Short description
ORDER_NUMBER VARCHAR2 (22)
Order number
AUTHORING_ORG_ID NUMBER

The internal identifier of the operating unit in which the contract was authored.
ORGANIZATION_NAME VARCHAR2 (240) Yes The name of the operating unit in which the contract was authored.
SOB_ID NUMBER

Set of books id
CATEGORY_CODE VARCHAR2 (30)
The code of the contract category.
CATEGORY_MEANING VARCHAR2 (90) Yes The user description for the contract category.
STATUS_CODE VARCHAR2 (30)
The code value representing the status of the contract.
STATUS_MEANING VARCHAR2 (90) Yes The external description of the status of the contract.
STATUS_TYPE_CODE VARCHAR2 (30) Yes The external description of the status type of the contract.
STATUS_TYPE_MEANING VARCHAR2 (80) Yes The external description of the status type of the contract.
IS_NEW_YN VARCHAR2 (240)
Y - New contract N- Renewal contract
IS_LATEST_YN VARCHAR2 (1)
Latest renewal
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
CUSTOMER_PARTY_ID NUMBER

The internal party identifier of the contract customer.
CUSTOMER_NAME VARCHAR2 (360) Yes The name of the customer in the contract.
CUSTOMER_NUMBER VARCHAR2 (30) Yes Customer number
CONTRACT_AMOUNT NUMBER

The total amount of the contract, in the contract transaction currency.
FORECAST_AMOUNT NUMBER

The forecasted value of the contract.
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.
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.
WIN_PERCENT NUMBER

The estimated percentage probability that the contract will be signed.
EXPECTED_CLOSE_DATE DATE

The date on which the contract is expected to be signed.
START_DATE DATE

The starting effective date of the contract.
END_DATE DATE

The ending effective date of the contract.
DURATION NUMBER

Duration of the contract
PERIOD VARCHAR2 (30)
Period code for the duration
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.
TERMINATED_AMOUNT NUMBER

Terminated amount
SOB_TERMINATED_AMOUNT NUMBER

Terminated amount in functional currency
BASE_TERMINATED_AMOUNT NUMBER

Terminated amount in base currency
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.
TERMINATION_MEANING VARCHAR2 (80)
The external description of the termination reason.
INVENTORY_ORGANIZATION_ID NUMBER

The internal identifier for the inventory organization.
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.
RENEWAL_TYPE_USED_CODE VARCHAR2 (10)
Renewal Type code used
RENEWAL_TYPES_USED VARCHAR2 (80)
Renewal Type Used Meaning
Query Text

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


SELECT CONTRACT_ID
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      COMPLETE_CONTRACT_NUMBER
,      SHORT_DESCRIPTION
,      ORDER_NUMBER
,      AUTHORING_ORG_ID
,      ORGANIZATION_NAME
,      SOB_ID
,      CATEGORY_CODE
,      CATEGORY_MEANING
,      STATUS_CODE
,      STATUS_MEANING
,      STATUS_TYPE_CODE
,      STATUS_TYPE_MEANING
,      IS_NEW_YN
,      IS_LATEST_YN
,      ORIG_SYSTEM_SOURCE_CODE
,      ORIG_SYSTEM_ID1
,      ORIG_SYSTEM_REFERENCE1
,      CONTRACT_TYPE
,      CUSTOMER_PARTY_ID
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      CONTRACT_AMOUNT
,      FORECAST_AMOUNT
,      CURRENCY_CODE
,      CONTRACT_AMOUNT_RENEWED
,      CURRENCY_CODE_RENEWED
,      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
,      WIN_PERCENT
,      EXPECTED_CLOSE_DATE
,      START_DATE
,      END_DATE
,      DURATION
,      PERIOD
,      DATE_APPROVED
,      DATE_SIGNED
,      DATE_RENEWED
,      DATE_CANCELED
,      DATE_TERMINATED
,      TERMINATED_AMOUNT
,      SOB_TERMINATED_AMOUNT
,      BASE_TERMINATED_AMOUNT
,      START_PERIOD_NUM
,      START_PERIOD_NAME
,      START_QUARTER
,      START_YEAR
,      CLOSE_PERIOD_NUM
,      CLOSE_PERIOD_NAME
,      CLOSE_QUARTER
,      CLOSE_YEAR
,      TRN_CODE
,      TERMINATION_MEANING
,      INVENTORY_ORGANIZATION_ID
,      APPLICATION_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      RENEWAL_TYPE_USED_CODE
,      RENEWAL_TYPES_USED
FROM APPS.OKI_SALES_K_NEW_V;

Dependencies

[top of page]

APPS.OKI_SALES_K_NEW_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymHZ_PARTIES
SynonymOKC_K_HEADERS_TL
ViewOKC_STATUSES_V
ViewOKC_SUBCLASSES_V
PL/SQL PackageOKC_UTIL - show dependent code
SynonymOKI_SALES_K_HDRS

APPS.OKI_SALES_K_NEW_V is not referenced by any database object