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

VIEW: APPS.OKS_MSCHG_OPERATIONS_DTLS_V

Object Details
Object Name: OKS_MSCHG_OPERATIONS_DTLS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKS.OKS_MSCHG_OPERATIONS_DTLS_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
ID NUMBER
Yes Masschange operation details Id
MRD_ID NUMBER
Yes MRD ID
OIE_ID NUMBER

Id of okc_operation_instances
OLE_ID NUMBER

Id of okc_operation_lines
MSCHG_TYPE VARCHAR2 (40)
Stores Masschange Operation type.
ATTRIBUTE_LEVEL VARCHAR2 (3)
Stores whether it is a header level or line level
QA_CHECK_YN VARCHAR2 (3)
Stores QA check required or not
OBJECT_VERSION_NUMBER NUMBER (9)
Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
CREATED_BY NUMBER (15) Yes ID of the user whom created the record.
CREATION_DATE DATE
Yes Date the record was created.
LAST_UPDATED_BY NUMBER (15) Yes ID of the last user who updated the record.
LAST_UPDATE_DATE DATE
Yes Date the record was last updated.
LAST_UPDATE_LOGIN NUMBER (15)
OS ID of the user who last updated the record.
SECURITY_GROUP_ID NUMBER

Used to create a Virtual Private Database which was originally designed to be used by Hosting services. Now obsolete.
ATTRIBUTE1 VARCHAR2 (450)
Descriptive flexfield
ATTRIBUTE2 VARCHAR2 (450)
Descriptive flexfield
ATTRIBUTE3 VARCHAR2 (450)
Descriptive flexfield
ATTRIBUTE4 VARCHAR2 (450)
Descriptive flexfield
ATTRIBUTE5 VARCHAR2 (450)
Descriptive flexfield
ATTRIBUTE6 VARCHAR2 (450)
Descriptive flexfield
ATTRIBUTE7 VARCHAR2 (450)
Descriptive flexfield
ATTRIBUTE8 VARCHAR2 (450)
Descriptive flexfield
ATTRIBUTE9 VARCHAR2 (450)
Descriptive flexfield
ATTRIBUTE10 VARCHAR2 (450)
Descriptive flexfield
ATTRIBUTE11 VARCHAR2 (450)
Descriptive flexfield
ATTRIBUTE12 VARCHAR2 (450)
Descriptive flexfield
ATTRIBUTE13 VARCHAR2 (450)
Descriptive flexfield
ATTRIBUTE14 VARCHAR2 (450)
Descriptive flexfield
ATTRIBUTE15 VARCHAR2 (450)
Descriptive flexfield
Query Text

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


SELECT ID
,      MRD_ID
,      OIE_ID
,      OLE_ID
,      MSCHG_TYPE
,      ATTRIBUTE_LEVEL
,      QA_CHECK_YN
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM APPS.OKS_MSCHG_OPERATIONS_DTLS_V;

Dependencies

[top of page]

APPS.OKS_MSCHG_OPERATIONS_DTLS_V references the following:

SchemaAPPS
SynonymOKS_MSCHG_OPERATIONS_DTLS
APPS.OKS_MSCHG_OPERATIONS_DTLS_V is referenced by following:

SchemaAPPS
PL/SQL PackageOKS_MOD_PVT - show dependent code
Package BodyOKS_MOD_PVT - show dependent code