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]

VIEW: APPS.FND_AMP_REQUESTS_V

Object Details

Object Name:	FND_AMP_REQUESTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FND.FND_AMP_REQUESTS_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

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory
REQUEST_ID	NUMBER	(15)	Yes
PROGRAM	VARCHAR2	(486)
PHASE_CODE	VARCHAR2	(1)	Yes
STATUS_CODE	VARCHAR2	(1)	Yes
PHASE	VARCHAR2	(4000)
STATUS	VARCHAR2	(4000)
USER_NAME	VARCHAR2	(100)	Yes
RESPONSIBILITY_NAME	VARCHAR2	(100)	Yes
APPLICATION_NAME	VARCHAR2	(240)	Yes
REQUESTED_START_DATE	DATE		Yes
ACTUAL_START_DATE	DATE
ACTUAL_COMPLETION_DATE	DATE
REQUEST_DATE	DATE		Yes
PRIORITY	NUMBER	(15)	Yes
ARGUMENT_TEXT	VARCHAR2	(240)
ORACLE_SESSION_ID	NUMBER	(15)
COMPLETION_TEXT	VARCHAR2	(240)
CONTROLLING_MANAGER	NUMBER	(15)
SINGLE_THREAD_FLAG	VARCHAR2	(1)	Yes
REQUESTED_BY	NUMBER	(15)	Yes
REQUEST_LIMIT	VARCHAR2	(1)
PROGRAM_APPLICATION_ID	NUMBER	(15)	Yes
CONCURRENT_PROGRAM_ID	NUMBER	(15)	Yes
IS_SUB_REQUEST	VARCHAR2	(1)	Yes
PARENT_REQUEST_ID	NUMBER	(15)
QUEUE_METHOD_CODE	VARCHAR2	(1)	Yes
CD_ID	NUMBER
HOLD_FLAG	VARCHAR2	(1)	Yes
RUN_ALONE_FLAG	VARCHAR2	(1)	Yes
ENABLED_FLAG	VARCHAR2	(1)	Yes
CONCURRENT_PROGRAM_NAME	VARCHAR2	(30)	Yes
USER_CONCURRENT_PROGRAM_NAME	VARCHAR2	(240)	Yes
OS_PROCESS_ID	VARCHAR2	(240)
NLS_LANGUAGE	VARCHAR2	(30)
NLS_TERRITORY	VARCHAR2	(30)
NLS_NUMERIC_CHARACTERS	VARCHAR2	(2)
DESCRIPTION	VARCHAR2	(240)

Query Text

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


SELECT REQUEST_ID
,      PROGRAM
,      PHASE_CODE
,      STATUS_CODE
,      PHASE
,      STATUS
,      USER_NAME
,      RESPONSIBILITY_NAME
,      APPLICATION_NAME
,      REQUESTED_START_DATE
,      ACTUAL_START_DATE
,      ACTUAL_COMPLETION_DATE
,      REQUEST_DATE
,      PRIORITY
,      ARGUMENT_TEXT
,      ORACLE_SESSION_ID
,      COMPLETION_TEXT
,      CONTROLLING_MANAGER
,      SINGLE_THREAD_FLAG
,      REQUESTED_BY
,      REQUEST_LIMIT
,      PROGRAM_APPLICATION_ID
,      CONCURRENT_PROGRAM_ID
,      IS_SUB_REQUEST
,      PARENT_REQUEST_ID
,      QUEUE_METHOD_CODE
,      CD_ID
,      HOLD_FLAG
,      RUN_ALONE_FLAG
,      ENABLED_FLAG
,      CONCURRENT_PROGRAM_NAME
,      USER_CONCURRENT_PROGRAM_NAME
,      OS_PROCESS_ID
,      NLS_LANGUAGE
,      NLS_TERRITORY
,      NLS_NUMERIC_CHARACTERS
,      DESCRIPTION
FROM APPS.FND_AMP_REQUESTS_V;

Dependencies

[top of page]

APPS.FND_AMP_REQUESTS_V references the following:

APPS: FND_AMP_PRIVATE - show dependent code; FND_APPLICATION_TL; FND_CONCURRENT_PROGRAMS_TL; FND_CONCURRENT_PROGRAMS_VL; FND_CONCURRENT_REQUESTS; FND_RESPONSIBILITY_TL; FND_USER

APPS.FND_AMP_REQUESTS_V is referenced by following:

APPS: FND_CONC_WAITING_REQUESTS; FND_OAM_CPCHARTS_COL - show dependent code