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

VIEW: APPS.OKC_GOVERNING_CONTRACT_V

Object Details
Object Name: OKC_GOVERNING_CONTRACT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKC.OKC_GOVERNING_CONTRACT_V
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.

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
The address of the row in the database
ID NUMBER
Yes Primary key column - Obsoleted
OBJECT_VERSION_NUMBER NUMBER (9) Yes Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed - Obsoleted
INV_ORGANIZATION_ID NUMBER
Yes Foreign key to MTL_SYSTEM_ITEMS - Obsoleted
STS_CODE VARCHAR2 (30) Yes Foreign key to FND_LOOKUP_VALUES - Obsoleted
SCS_CODE VARCHAR2 (30) Yes Foreign key to FND_LOOKUP_VALUES - Obsoleted
CONTRACT_NUMBER VARCHAR2 (120) Yes Contract (RFP,Proposal etc.) Legal Identifier - Obsoleted
CURRENCY_CODE VARCHAR2 (15)
Currency code - Obsoleted
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
A unique internal name for the contract number - Obsoleted
SHORT_DESCRIPTION VARCHAR2 (600)
User entered free format abbreviated text description - Obsoleted
COMMENTS VARCHAR2 (1995)
User entered comment - Obsoleted
DESCRIPTION VARCHAR2 (1995)
User entered free format text description - Obsoleted
CUSTOMER_ACCOUNT_ID VARCHAR2 (40)
TEMPLATE_YN VARCHAR2 (3) Yes Yes or No Flag - Obsoleted
GOVERNING_CONTRACT_YN VARCHAR2 (3)
Indicates if this contract is a governing contract or not - Obsoleted
TEMPLATE_USED VARCHAR2 (120)
Denotes if a template was used to create contract. - Obsoleted
DATE_APPROVED DATE

Date contract was approved - Obsoleted
DATETIME_CANCELLED DATE

Date / Time Contract was cancelled - Obsoleted
AUTO_RENEW_DAYS NUMBER (4)
Number of days before automatic renewal of contract - Obsoleted
DATE_ISSUED DATE

Date request issued - Obsoleted
CHR_TYPE VARCHAR2 (30) Yes Character type - Obsoleted
DATE_SIGNED DATE

Date contract was signed - Obsoleted
DATE_TERMINATED DATE

Date contract terminated - Obsoleted
DATE_RENEWED DATE

Date contract was renewed - Obsoleted
TRN_CODE VARCHAR2 (30)
Termination code - Obsoleted
START_DATE DATE

The beginning of the active period, one second after midnight on the date indicated - Obsoleted
END_DATE DATE

The end of the active period, one second before midnight on the date indicated - Obsoleted
AUTHORING_ORG_ID NUMBER
Yes Authoring organization id - Obsoleted
BUY_OR_SELL VARCHAR2 (3)
Buy or Sell - Obsoleted
ISSUE_OR_RECEIVE VARCHAR2 (3)
Issue or Receive - Obsoleted
ESTIMATED_AMOUNT NUMBER

Estimated amount of contract - Obsoleted
CHR_ID_RENEWED_TO NUMBER

Indicates the contract header that is the renewal of this contract header. Only present in renewed contracts - Obsoleted
ESTIMATED_AMOUNT_RENEWED NUMBER

The estimated amount of the contract of which this contract is a renewal. Only present in renewal contracts - Obsoleted
CURRENCY_CODE_RENEWED VARCHAR2 (15)
Currency code from FND_CURRENCIES. The currency for the contract of which this contract is a renewal. Only present in renewal contracts - Obsoleted
USER_ACCESS_LEVEL VARCHAR2 (4000)
Access level for the user - Obsoleted
UPG_ORIG_SYSTEM_REF VARCHAR2 (60)
Identifies original source of data - Obsoleted
UPG_ORIG_SYSTEM_REF_ID NUMBER

Unique Id from original system - Obsoleted
APPLICATION_ID NUMBER

Application Identifier - Obsoleted
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive flexfield category column - Obsoleted
ATTRIBUTE1 VARCHAR2 (450)
Descriptive flexfield column - Obsoleted
ATTRIBUTE2 VARCHAR2 (450)
Descriptive flexfield column - Obsoleted
ATTRIBUTE3 VARCHAR2 (450)
Descriptive flexfield column - Obsoleted
ATTRIBUTE4 VARCHAR2 (450)
Descriptive flexfield column - Obsoleted
ATTRIBUTE5 VARCHAR2 (450)
Descriptive flexfield column - Obsoleted
ATTRIBUTE6 VARCHAR2 (450)
Descriptive flexfield column - Obsoleted
ATTRIBUTE7 VARCHAR2 (450)
Descriptive flexfield column - Obsoleted
ATTRIBUTE8 VARCHAR2 (450)
Descriptive flexfield column - Obsoleted
ATTRIBUTE9 VARCHAR2 (450)
Descriptive flexfield column - Obsoleted
ATTRIBUTE10 VARCHAR2 (450)
Descriptive flexfield column - Obsoleted
ATTRIBUTE11 VARCHAR2 (450)
Descriptive flexfield column - Obsoleted
ATTRIBUTE12 VARCHAR2 (450)
Descriptive flexfield column - Obsoleted
ATTRIBUTE13 VARCHAR2 (450)
Descriptive flexfield column - Obsoleted
ATTRIBUTE14 VARCHAR2 (450)
Descriptive flexfield column - Obsoleted
ATTRIBUTE15 VARCHAR2 (450)
Descriptive flexfield column - Obsoleted
CREATED_BY NUMBER (15) Yes Standard Who column - Obsoleted
CREATION_DATE DATE
Yes Standard Who column - Obsoleted
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column - Obsoleted
LAST_UPDATE_DATE DATE
Yes Standard Who column - Obsoleted
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column - Obsoleted
ORIG_SYSTEM_SOURCE_CODE VARCHAR2 (30)
Identifier of the source system - Obsoleted
ORIG_SYSTEM_ID1 NUMBER

Unique identifier in the source system - Obsoleted
ORIG_SYSTEM_REFERENCE1 VARCHAR2 (30)
Unique identifier in the source system - Obsoleted
PROGRAM_APPLICATION_ID NUMBER

Standard Who Column - Obsoleted
PROGRAM_ID NUMBER

Standard Who Column - Obsoleted
PROGRAM_UPDATE_DATE DATE

Standard Who Column - Obsoleted
REQUEST_ID NUMBER

Standard Who Column - Obsoleted
PRICE_LIST_ID NUMBER

Identifier of the Price List used for pricing this Contract. Quickcodes : LIST_HEADER_ID from QP_LIST_HEADERS_B - Obsoleted
PRICING_DATE DATE

Effective date used for pricing this Contract - Obsoleted
TOTAL_LINE_LIST_PRICE NUMBER

Sum of the list price of all the priced lines in the Contract - Obsoleted
SIGN_BY_DATE DATE

Date by which the Contract must be signed - Obsoleted
USER_ESTIMATED_AMOUNT NUMBER

User updateable estimated amount of the contract - Obsoleted
Query Text

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


SELECT ROW_ID
,      ID
,      OBJECT_VERSION_NUMBER
,      INV_ORGANIZATION_ID
,      STS_CODE
,      SCS_CODE
,      CONTRACT_NUMBER
,      CURRENCY_CODE
,      CONTRACT_NUMBER_MODIFIER
,      SHORT_DESCRIPTION
,      COMMENTS
,      DESCRIPTION
,      CUSTOMER_ACCOUNT_ID
,      TEMPLATE_YN
,      GOVERNING_CONTRACT_YN
,      TEMPLATE_USED
,      DATE_APPROVED
,      DATETIME_CANCELLED
,      AUTO_RENEW_DAYS
,      DATE_ISSUED
,      CHR_TYPE
,      DATE_SIGNED
,      DATE_TERMINATED
,      DATE_RENEWED
,      TRN_CODE
,      START_DATE
,      END_DATE
,      AUTHORING_ORG_ID
,      BUY_OR_SELL
,      ISSUE_OR_RECEIVE
,      ESTIMATED_AMOUNT
,      CHR_ID_RENEWED_TO
,      ESTIMATED_AMOUNT_RENEWED
,      CURRENCY_CODE_RENEWED
,      USER_ACCESS_LEVEL
,      UPG_ORIG_SYSTEM_REF
,      UPG_ORIG_SYSTEM_REF_ID
,      APPLICATION_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORIG_SYSTEM_SOURCE_CODE
,      ORIG_SYSTEM_ID1
,      ORIG_SYSTEM_REFERENCE1
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      PRICE_LIST_ID
,      PRICING_DATE
,      TOTAL_LINE_LIST_PRICE
,      SIGN_BY_DATE
,      USER_ESTIMATED_AMOUNT
FROM APPS.OKC_GOVERNING_CONTRACT_V;

Dependencies

[top of page]

APPS.OKC_GOVERNING_CONTRACT_V references the following:

SchemaAPPS
SynonymOKC_K_HEADERS_B
SynonymOKC_K_HEADERS_TL
SynonymOKC_RULES_B
SynonymOKC_RULE_GROUPS_B
SynonymOKC_SUBCLASSES_B
PL/SQL PackageOKC_UTIL - show dependent code

APPS.OKC_GOVERNING_CONTRACT_V is not referenced by any database object