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


VIEW: JTF.JTF_PERZ_QUERY_RAW_SQL#

Object Details
Object Name: JTF_PERZ_QUERY_RAW_SQL#
Object Type: VIEW
Owner: JTF
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
QUERY_RAW_SQL_ID NUMBER
Yes
QUERY_ID NUMBER

SELECT_STRING VARCHAR2 (200)
FROM_STRING VARCHAR2 (200)
WHERE_STRING VARCHAR2 (200)
ORDER_BY_STRING VARCHAR2 (200)
GROUP_BY_STRING VARCHAR2 (200)
HAVING_STRING VARCHAR2 (200)
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
SECURITY_GROUP_ID NUMBER

ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT QUERY_RAW_SQL_ID
,      QUERY_ID
,      SELECT_STRING
,      FROM_STRING
,      WHERE_STRING
,      ORDER_BY_STRING
,      GROUP_BY_STRING
,      HAVING_STRING
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      ZD_EDITION_NAME
FROM JTF.JTF_PERZ_QUERY_RAW_SQL#;

Dependencies

[top of page]

JTF.JTF_PERZ_QUERY_RAW_SQL# references the following:

SchemaJTF
TableJTF_PERZ_QUERY_RAW_SQL
JTF.JTF_PERZ_QUERY_RAW_SQL# is referenced by following:

SchemaAPPS
SynonymJTF_PERZ_QUERY_RAW_SQL
TriggerJTF_PERZ_QUERY_RAW_SQL+