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

VIEW: APPS.CSC_CONTACT_RESTRICTIONS_V

Object Details
Object Name: CSC_CONTACT_RESTRICTIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSC.CSC_CONTACT_RESTRICTIONS_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

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
CONTACT_RESTRICTION_ID VARCHAR2 (0)
CONTACT_TYPE VARCHAR2 (0)
RESTRICT_START_DATE VARCHAR2 (0)
RESTRICT_END_DATE VARCHAR2 (0)
RESTRICT_REASON VARCHAR2 (0)
CREATED_BY VARCHAR2 (0)
CREATION_DATE VARCHAR2 (0)
LAST_UPDATE_LOGIN VARCHAR2 (0)
LAST_UPDATED_DATE VARCHAR2 (0)
REQUEST_ID VARCHAR2 (0)
PROGRAM_APPLICATION_ID VARCHAR2 (0)
PROGRAM_ID VARCHAR2 (0)
PROGRAM_UPDATE_DATE VARCHAR2 (0)
WH_UPDATE_DATE VARCHAR2 (0)
SUBJECT_TABLE VARCHAR2 (0)
SUBJECT_ID VARCHAR2 (0)
Query Text

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


SELECT CONTACT_RESTRICTION_ID
,      CONTACT_TYPE
,      RESTRICT_START_DATE
,      RESTRICT_END_DATE
,      RESTRICT_REASON
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      WH_UPDATE_DATE
,      SUBJECT_TABLE
,      SUBJECT_ID
FROM APPS.CSC_CONTACT_RESTRICTIONS_V;

Dependencies

[top of page]

APPS.CSC_CONTACT_RESTRICTIONS_V references the following:

SchemaPUBLIC
SynonymDUAL

APPS.CSC_CONTACT_RESTRICTIONS_V is not referenced by any database object