eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: CRP.CRP_FORM_QUERY

Object Details

Object Name:	CRP_FORM_QUERY
Object Type:	TABLE
Owner:	CRP
FND Design Data:	CRP.CRP_FORM_QUERY
Subobject Name:
Status:	VALID

CRP_FORM_QUERY is a generic table used by forms for querying data
populated by user-exits. Each row represents some information that the
user needs displayed in a form. This table is populated by the user
exit CAP_PLAN, for the RCCP and CRP inquiries.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CRP_FORM_QUERY_N1	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	QUERY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
QUERY_ID	NUMBER		Yes	Query identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
DATE1	DATE			Generic date column
DATE2	DATE			Generic date column
DATE3	DATE			Generic date column
DATE4	DATE			Generic date column
DATE5	DATE			Generic date column
DATE6	DATE			Generic date column
DATE7	DATE			Generic date column
DATE8	DATE			Generic date column
NUMBER1	NUMBER			Generic number column
NUMBER2	NUMBER			Generic number column
NUMBER3	NUMBER			Generic number column
NUMBER4	NUMBER			Generic number column
NUMBER5	NUMBER			Generic number column
NUMBER6	NUMBER			Generic number column
NUMBER7	NUMBER			Generic number column
NUMBER8	NUMBER			Generic number column
NUMBER9	NUMBER			Generic number column
NUMBER10	NUMBER			Generic number column
CHAR1	VARCHAR2	(255)		Generic character column
CHAR2	VARCHAR2	(255)		Generic character column
CHAR3	VARCHAR2	(255)		Generic character column
CHAR4	VARCHAR2	(255)		Generic character column
CHAR5	VARCHAR2	(255)		Generic character column
CHAR6	VARCHAR2	(255)		Generic character column
CHAR7	VARCHAR2	(255)		Generic character column
CHAR8	VARCHAR2	(255)		Generic character column
REQUEST_ID	NUMBER			Concurrent Who column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Who column
PROGRAM_ID	NUMBER			Concurrent Who column
PROGRAM_UPDATE_DATE	DATE			Concurrent Who column
NUMBER11	NUMBER			Generic number column
NUMBER12	NUMBER			Generic number column
NUMBER13	NUMBER			Generic number column
NUMBER14	NUMBER			Generic number column
NUMBER15	NUMBER			Generic number column
NUMBER16	NUMBER			Generic number column
NUMBER17	NUMBER			Generic number column
NUMBER18	NUMBER			Generic number column
CHAR9	VARCHAR2	(255)		Generic character column
CHAR10	VARCHAR2	(255)		Generic character column

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 does not reference any database object

CRP.CRP_FORM_QUERY is referenced by following:

APPS: CRP_FORM_QUERY