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

VIEW: APPS.OKC_K_PROCESSES_V

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

View Type

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


A process to be used for a particular purpose on a contract.
RULE
The process must be of usage RENEW, APPROVE, or TERMINATE


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Auto-generated by Headstart Utilities
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.
PDF_ID NUMBER
Yes Foreign key to OKC_PROCESS_DEFS_B.
CHR_ID NUMBER

Foreign key to OKC_K_HEADERS_B.
USER_ID NUMBER (15)
Application user identifier.
CRT_ID NUMBER

Foreign key to OKC_CHANGE_REQUESTS_B.
PROCESS_ID VARCHAR2 (240)
Surrogate key used for primary unique identifiers.
IN_PROCESS_YN VARCHAR2 (3)
Yes/No field.
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
,      PDF_ID
,      CHR_ID
,      USER_ID
,      CRT_ID
,      PROCESS_ID
,      IN_PROCESS_YN
,      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_PROCESSES_V;

Dependencies

[top of page]

APPS.OKC_K_PROCESSES_V references the following:

SchemaAPPS
SynonymOKC_K_PROCESSES
APPS.OKC_K_PROCESSES_V is referenced by following:

SchemaAPPS
Package BodyOKC_CONTRACT_APPROVAL_PVT - show dependent code
Package BodyOKC_COPY_CONTRACT_PVT - show dependent code
PL/SQL PackageOKC_CPS_PVT - show dependent code
Package BodyOKC_CPS_PVT - show dependent code
Package BodyOKC_DELETE_CONTRACT_PVT - show dependent code
ViewOKC_K_CPS_PDF_V
Package BodyOKE_CONTRACT_APPROVAL_PVT - show dependent code
PL/SQL PackageOKL_VENDOR_PROGRAM_PVT - show dependent code
Package BodyOKL_VENDOR_PROGRAM_PVT - show dependent code
Package BodyOKS_COPY_CONTRACT_PVT - show dependent code
Package BodyOKS_RENCPY_PVT - show dependent code