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: APPLSYS.FND_RUN_REQ_PP_ACTIONS

Object Details

Object Name:	FND_RUN_REQ_PP_ACTIONS
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_RUN_REQ_PP_ACTIONS
Subobject Name:
Status:	VALID

FND_RUN_REQ_PP_ACTIONS stores the post request processing actions (ie. print, notification) for the submitted request set programs that are stored in FND_RUN_REQUESTS.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	20
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_RUN_REQ_PP_ACTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_REQUEST_ID REQUEST_SET_PROGRAM_ID REQUEST_SET_ID SET_APPLICATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PARENT_REQUEST_ID	NUMBER		Yes	Identifier for the parent request
REQUEST_SET_PROGRAM_ID	NUMBER		Yes	Identifier for the request set program
SET_APPLICATION_ID	NUMBER	(15)	Yes	Application identifier for the request set
REQUEST_SET_ID	NUMBER	(15)	Yes	Identifier for the request set
ACTION_TYPE	NUMBER		Yes	Type of action
STATUS_S_FLAG	VARCHAR2	(1)	Yes	Perform action on success
STATUS_W_FLAG	VARCHAR2	(1)	Yes	Perform action on warning
STATUS_F_FLAG	VARCHAR2	(1)	Yes	Perform action on failure
PROGRAM_APPLICATION_ID	NUMBER			Identifier for program application
PROGRAM_ID	NUMBER			Identifier for program
ARGUMENTS	VARCHAR2	(255)		Concurrent Request Arguments
SEQUENCE	NUMBER			Indicates the order for the post processing actions
NUMBER_OF_COPIES	NUMBER			Indicates the number of copies to print
ORIG_SYSTEM	VARCHAR2	(48)		Notification user originating system
ORIG_SYSTEM_ID	NUMBER			Notification user originating system id
NLS_LANGUAGE	VARCHAR2	(30)		NLS Language
OPS_INSTANCE	NUMBER	(15)	Yes	OPS Instance
ARGUMENT1	VARCHAR2	(255)		pp action argument1
ARGUMENT2	VARCHAR2	(255)		pp action argument2
ARGUMENT3	VARCHAR2	(255)		pp action argument3
ARGUMENT4	VARCHAR2	(255)		pp action argument4
ARGUMENT5	VARCHAR2	(255)		pp action argument5
ARGUMENT6	VARCHAR2	(255)		pp action argument6
ARGUMENT7	VARCHAR2	(255)		pp action argument7
ARGUMENT8	VARCHAR2	(255)		pp action argument8
ARGUMENT9	VARCHAR2	(255)		pp action argument9
ARGUMENT10	VARCHAR2	(255)		pp action argument10

Query Text

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


SELECT PARENT_REQUEST_ID
,      REQUEST_SET_PROGRAM_ID
,      SET_APPLICATION_ID
,      REQUEST_SET_ID
,      ACTION_TYPE
,      STATUS_S_FLAG
,      STATUS_W_FLAG
,      STATUS_F_FLAG
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      ARGUMENTS
,      SEQUENCE
,      NUMBER_OF_COPIES
,      ORIG_SYSTEM
,      ORIG_SYSTEM_ID
,      NLS_LANGUAGE
,      OPS_INSTANCE
,      ARGUMENT1
,      ARGUMENT2
,      ARGUMENT3
,      ARGUMENT4
,      ARGUMENT5
,      ARGUMENT6
,      ARGUMENT7
,      ARGUMENT8
,      ARGUMENT9
,      ARGUMENT10
FROM APPLSYS.FND_RUN_REQ_PP_ACTIONS;

Dependencies

[top of page]

APPLSYS.FND_RUN_REQ_PP_ACTIONS does not reference any database object

APPLSYS.FND_RUN_REQ_PP_ACTIONS is referenced by following:

APPLSYS: FND_RUN_REQ_PP_ACTIONS#