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

VIEW: BOM.BOM_FORM_QUERY#

Object Details
Object Name: BOM_FORM_QUERY#
Object Type: VIEW
Owner: BOM
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

NUMBER11 NUMBER

NUMBER12 NUMBER

NUMBER13 NUMBER

NUMBER14 NUMBER

NUMBER15 NUMBER

REQUEST_ID NUMBER

CHAR1 VARCHAR2 (80)
CHAR2 VARCHAR2 (80)
CHAR3 VARCHAR2 (80)
CHAR4 VARCHAR2 (80)
CHAR5 VARCHAR2 (80)
CHAR6 VARCHAR2 (80)
CHAR7 VARCHAR2 (80)
CHAR8 VARCHAR2 (80)
CHAR9 VARCHAR2 (250)
PROGRAM_UPDATE_DATE DATE

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

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
,      NUMBER11
,      NUMBER12
,      NUMBER13
,      NUMBER14
,      NUMBER15
,      REQUEST_ID
,      CHAR1
,      CHAR2
,      CHAR3
,      CHAR4
,      CHAR5
,      CHAR6
,      CHAR7
,      CHAR8
,      CHAR9
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
FROM BOM.BOM_FORM_QUERY#;

Dependencies

[top of page]

BOM.BOM_FORM_QUERY# references the following:

SchemaBOM
TableBOM_FORM_QUERY
BOM.BOM_FORM_QUERY# is referenced by following:

SchemaAPPS
SynonymBOM_FORM_QUERY