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

VIEW: APPS.OKC_QA_CHECK_LISTS_V

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

View Type

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


A collection of processes to be run to qa a contract.


[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.
SFWT_FLAG VARCHAR2 (3) Yes Indicates a value was changed in another language. Not fully implemented in 11i
NAME VARCHAR2 (150) Yes QA checklist name.
SHORT_DESCRIPTION VARCHAR2 (600)
User entered free format abbreviated text description.
BEGIN_DATE DATE
Yes Begin Date.
END_DATE DATE

The end of the active period, one second before midnight on the date indicated.
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.
APPLICATION_ID NUMBER

Application Identifier
DEFAULT_YN VARCHAR2 (3)
Indicates application default QA checklist
Query Text

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


SELECT ROW_ID
,      ID
,      OBJECT_VERSION_NUMBER
,      SFWT_FLAG
,      NAME
,      SHORT_DESCRIPTION
,      BEGIN_DATE
,      END_DATE
,      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
,      APPLICATION_ID
,      DEFAULT_YN
FROM APPS.OKC_QA_CHECK_LISTS_V;

Dependencies

[top of page]

APPS.OKC_QA_CHECK_LISTS_V references the following:

SchemaAPPS
SynonymOKC_QA_CHECK_LISTS_B
SynonymOKC_QA_CHECK_LISTS_TL
APPS.OKC_QA_CHECK_LISTS_V is referenced by following:

SchemaAPPS
Package BodyOKC_QCL_PVT - show dependent code
PL/SQL PackageOKC_QCL_PVT - show dependent code
Package BodyOKL_CONTRACT_BOOK_PVT - show dependent code
Package BodyOKL_MASS_REBOOK_PVT - show dependent code
Package BodyOKL_OPEN_INTERFACE_PVT - show dependent code
Package BodyOKL_SPLIT_CONTRACT_PVT - show dependent code
Package BodyOKL_UBB_INTEGRATION_PVT - show dependent code
Package BodyOKL_VENDOR_PROGRAM_PVT - show dependent code