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

VIEW: APPS.IGSBV_PRIVACY_DETAILS

Object Details
Object Name: IGSBV_PRIVACY_DETAILS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGSBV_PRIVACY_DETAILS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This entity contains information about the privacy details of a person.


[View Source]

Columns
Name Datatype Length Mandatory Comments
DATA_GROUP VARCHAR2 (20) Yes A group of data that is associated with a privacy level
LVL NUMBER (10)
Level associated with a private data group
_LA:ACTION CHAR (62)
The action that has to be taken or has been taken for a privacy level
_LA:TO_WHOM CHAR (59)
To whom the Action can be taken.
START_DATE DATE
Yes Start date for data privacy details
END_DATE DATE

End date for data privacy details
PRIVACY_LEVEL_ID NUMBER (15) Yes Unique identifier of the privacy level of the person
PERSON_ID NUMBER (15) Yes Unique identifier of a person
DATA_GROUP_ID NUMBER (15) Yes Unique identifier of the data group
REF_NOTES_ID NUMBER (15)
Unique identifier of the reference note
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
Query Text

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


SELECT DATA_GROUP
,      LVL
,      _LA:ACTION
,      _LA:TO_WHOM
,      START_DATE
,      END_DATE
,      PRIVACY_LEVEL_ID
,      PERSON_ID
,      DATA_GROUP_ID
,      REF_NOTES_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_PRIVACY_DETAILS;

Dependencies

[top of page]

APPS.IGSBV_PRIVACY_DETAILS references the following:

SchemaAPPS
SynonymIGS_PE_PRIV_LEVEL

APPS.IGSBV_PRIVACY_DETAILS is not referenced by any database object