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

VIEW: APPS.OKC_K_VERS_NUMBERS_V

Object Details
Object Name: OKC_K_VERS_NUMBERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKC.OKC_K_VERS_NUMBERS_V
Subobject Name:
Status: VALID

View Type

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


Indicates the current version of the contract as a document.
A row is created upon contract creation. When created, the major version is 0 and the minor verison is 1. The versioning process increments the major version by one and sets the minor version to 0.
Any change to any part of the contract (insert, update, delete) increments the minor version by 1.
When updated, the previous information should be pushed to history for this entity. This will keep a log of when the contract was updated and by whom, although the contents of the update are not known.
Modeled as a separate entity to prevent updates to the header when other parts of the contract changed and to enable maintaining a history of minor versions.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Auto-generated by Headstart Utilities
CHR_ID NUMBER
Yes Foreign key to OKC_K_HEADERS_B.
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.
MAJOR_VERSION NUMBER (4) Yes The version of the contract for this history record.
MINOR_VERSION NUMBER
Yes Notes and comments.
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
,      CHR_ID
,      OBJECT_VERSION_NUMBER
,      MAJOR_VERSION
,      MINOR_VERSION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.OKC_K_VERS_NUMBERS_V;

Dependencies

[top of page]

APPS.OKC_K_VERS_NUMBERS_V references the following:

SchemaAPPS
SynonymOKC_K_VERS_NUMBERS
APPS.OKC_K_VERS_NUMBERS_V is referenced by following:

SchemaAPPS
Package BodyOKC_CVM_PVT - show dependent code
PL/SQL PackageOKC_CVM_PVT - show dependent code
Package BodyOKC_REPORT_PVT - show dependent code
Package BodyOKL_DEAL_CREATE_PUB - show dependent code
Package BodyOKL_DEAL_CREAT_PVT - show dependent code
ViewOKL_K_HDRS_FULL_UV
PL/SQL PackageOKL_OKC_MIGRATION_PVT - show dependent code
Package BodyOKS_ENTITLEMENTS_WEB - show dependent code
ViewPOFV_BKT_PO_LINES
ViewPOFV_PLAN_PO_LINES
ViewPOFV_PO_LINES
ViewPOFV_REQUISITION_LINES
ViewPOFV_STD_PO_LINES