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

VIEW: APPS.OKC_K_HDR_AGREEDS_V

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

Internal

[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.
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.
SFWT_FLAG VARCHAR2 (3) Yes Indicates a value was changed in another language. Not fully implemented in 11i
CHR_ID_AWARD NUMBER

Surrogate key used for primary unique identifiers.
STS_CODE VARCHAR2 (30) Yes Foreign key to FND_LOOKUP_VALUES.
QCL_ID NUMBER

Foreign key to OKC_QA_CHECK_LISTS_B.
SCS_CODE VARCHAR2 (30) Yes Foreign key to FND_LOOKUP_VALUES.
CONTRACT_NUMBER VARCHAR2 (120) Yes Contract (RFP,Proposal etc.) Legal Identifier.
CURRENCY_CODE VARCHAR2 (15)
Currency code.
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
A unique internal name for the contract number.
CUST_PO_NUMBER_REQ_YN VARCHAR2 (3)
Purchase Order required flag.
PRE_PAY_REQ_YN VARCHAR2 (3)
Contract pre-payment required flag.
CUST_PO_NUMBER VARCHAR2 (150)
Customer's Purchase Order Number.
ARCHIVED_YN VARCHAR2 (3) Yes Lookup type for Yes/No columns
DELETED_YN VARCHAR2 (3) Yes Lookup type for Yes/No columns
SHORT_DESCRIPTION VARCHAR2 (600)
User entered free format abbreviated text description.
COMMENTS VARCHAR2 (1995)
User entered comment.
DESCRIPTION VARCHAR2 (1995)
User entered free format text description.
DPAS_RATING VARCHAR2 (24)
DPAS rating.
COGNOMEN VARCHAR2 (300)
Cognomen field.
TEMPLATE_YN VARCHAR2 (3) Yes Yes or No Flag.
TEMPLATE_USED VARCHAR2 (120)
Denotes if a template was used to create contract.
DATE_APPROVED DATE

Date contract was approved.
DATETIME_CANCELLED DATE

Date / Time Contract was cancelled.
AUTO_RENEW_DAYS NUMBER (4)
Number of days before automatic renewal of contract.
DATE_SIGNED DATE

Date contract was signed.
DATE_TERMINATED DATE

Date contract terminated.
DATE_RENEWED DATE

Date contract was renewed.
TRN_CODE VARCHAR2 (30)
Transaction code.
START_DATE DATE

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

The end of the active period, one second before midnight on the date indicated.
AUTHORING_ORG_ID NUMBER
Yes Authoring Organization ID.
BUY_OR_SELL VARCHAR2 (3)
Buy or Sell.
ISSUE_OR_RECEIVE VARCHAR2 (3)
Issue or Receive.
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive flexfield category column.
ATTRIBUTE1 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE2 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE3 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE4 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE5 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE6 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE7 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE8 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE9 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE10 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE11 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE12 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE13 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE14 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE15 VARCHAR2 (450)
Descriptive flexfield column.
CREATED_BY NUMBER (15) Yes Standard Who column.
CREATION_DATE DATE
Yes Standard Who column.
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column.
LAST_UPDATE_DATE DATE
Yes Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
Query Text

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


SELECT ROW_ID
,      ID
,      OBJECT_VERSION_NUMBER
,      SFWT_FLAG
,      CHR_ID_AWARD
,      STS_CODE
,      QCL_ID
,      SCS_CODE
,      CONTRACT_NUMBER
,      CURRENCY_CODE
,      CONTRACT_NUMBER_MODIFIER
,      CUST_PO_NUMBER_REQ_YN
,      PRE_PAY_REQ_YN
,      CUST_PO_NUMBER
,      ARCHIVED_YN
,      DELETED_YN
,      SHORT_DESCRIPTION
,      COMMENTS
,      DESCRIPTION
,      DPAS_RATING
,      COGNOMEN
,      TEMPLATE_YN
,      TEMPLATE_USED
,      DATE_APPROVED
,      DATETIME_CANCELLED
,      AUTO_RENEW_DAYS
,      DATE_SIGNED
,      DATE_TERMINATED
,      DATE_RENEWED
,      TRN_CODE
,      START_DATE
,      END_DATE
,      AUTHORING_ORG_ID
,      BUY_OR_SELL
,      ISSUE_OR_RECEIVE
,      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
FROM APPS.OKC_K_HDR_AGREEDS_V;

Dependencies

[top of page]

APPS.OKC_K_HDR_AGREEDS_V references the following:

SchemaAPPS
SynonymOKC_K_HEADERS_B
SynonymOKC_K_HEADERS_TL
APPS.OKC_K_HDR_AGREEDS_V is referenced by following:

SchemaAPPS
Package BodyOKC_CHANGE_CONTRACT_PVT - show dependent code
Package BodyOKC_CHANGE_REQUEST_PVT - show dependent code
Package BodyOKC_CONTRACT_APPROVAL_PVT - show dependent code
Package BodyOKC_CRT_PVT - show dependent code
Package BodyOKE_CONTRACT_APPROVAL_PVT - show dependent code