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

VIEW: CRP.CRP_FORM_QUERY#

Object Details
Object Name: CRP_FORM_QUERY#
Object Type: VIEW
Owner: CRP
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
QUERY_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

DATE1 DATE

DATE2 DATE

DATE3 DATE

DATE4 DATE

DATE5 DATE

DATE6 DATE

DATE7 DATE

DATE8 DATE

NUMBER1 NUMBER

NUMBER2 NUMBER

NUMBER3 NUMBER

NUMBER4 NUMBER

NUMBER5 NUMBER

NUMBER6 NUMBER

NUMBER7 NUMBER

NUMBER8 NUMBER

NUMBER9 NUMBER

NUMBER10 NUMBER

CHAR1 VARCHAR2 (255)
CHAR2 VARCHAR2 (255)
CHAR3 VARCHAR2 (255)
CHAR4 VARCHAR2 (255)
CHAR5 VARCHAR2 (255)
CHAR6 VARCHAR2 (255)
CHAR7 VARCHAR2 (255)
CHAR8 VARCHAR2 (255)
REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

NUMBER11 NUMBER

NUMBER12 NUMBER

NUMBER13 NUMBER

NUMBER14 NUMBER

NUMBER15 NUMBER

NUMBER16 NUMBER

NUMBER17 NUMBER

NUMBER18 NUMBER

CHAR9 VARCHAR2 (255)
CHAR10 VARCHAR2 (255)
Query Text

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


SELECT QUERY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DATE1
,      DATE2
,      DATE3
,      DATE4
,      DATE5
,      DATE6
,      DATE7
,      DATE8
,      NUMBER1
,      NUMBER2
,      NUMBER3
,      NUMBER4
,      NUMBER5
,      NUMBER6
,      NUMBER7
,      NUMBER8
,      NUMBER9
,      NUMBER10
,      CHAR1
,      CHAR2
,      CHAR3
,      CHAR4
,      CHAR5
,      CHAR6
,      CHAR7
,      CHAR8
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      NUMBER11
,      NUMBER12
,      NUMBER13
,      NUMBER14
,      NUMBER15
,      NUMBER16
,      NUMBER17
,      NUMBER18
,      CHAR9
,      CHAR10
FROM CRP.CRP_FORM_QUERY#;

Dependencies

[top of page]

CRP.CRP_FORM_QUERY# references the following:

SchemaCRP
TableCRP_FORM_QUERY
CRP.CRP_FORM_QUERY# is referenced by following:

SchemaAPPS
SynonymCRP_FORM_QUERY