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: JTF.JTF_FM_REQUEST_CONTENTS

Object Details

Object Name:	JTF_FM_REQUEST_CONTENTS
Object Type:	TABLE
Owner:	JTF
FND Design Data:	JTF.JTF_FM_REQUEST_CONTENTS
Subobject Name:
Status:	VALID

Table to hold details on the contents within the request.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
REQUEST_ID	NUMBER		Yes	unique request identifier
CONTENT_ID	NUMBER		Yes	coud be templated id for OCM content or could be MES content id
CONTENT_NUMBER	NUMBER		Yes	The order in which the docs are put with in a request
CONTENT_NAME	VARCHAR2	(256)		name of the actual file in fnd_lobs
CONTENT_TYPE	VARCHAR2	(20)		could be 10,20,30(MES)
DOCUMENT_TYPE	VARCHAR2	(50)		type of file,possible values,htm,txt..
BODY	VARCHAR2	(1)		flag to denote if ths doc gets plugged into the body of the request or not
USER_NOTES	VARCHAR2	(2000)		a special merge field that cane be passed other than the regular bind data.
QUANTITY	NUMBER			is for future use.
OUTCOME_CODE	VARCHAR2	(20)		denotes the outcome code per request per content
CREATED_BY	NUMBER		Yes	created by
CREATION_DATE	DATE		Yes	creation date
LAST_UPDATED_BY	NUMBER		Yes	last update by
LAST_UPDATE_DATE	DATE		Yes	last update date
LAST_UPDATE_LOGIN	NUMBER		Yes	last update login
MEDIA_TYPE	VARCHAR2	(3)	Yes	possible values are EMAIL,FAX,PRINTER
CONTENT_SOURCE	VARCHAR2	(3)		values are OCM or JMES as of (11.5.9)
FND_FILE_ID	NUMBER		Yes	The actual File Id from fnd_lobs

Query Text

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


SELECT REQUEST_ID
,      CONTENT_ID
,      CONTENT_NUMBER
,      CONTENT_NAME
,      CONTENT_TYPE
,      DOCUMENT_TYPE
,      BODY
,      USER_NOTES
,      QUANTITY
,      OUTCOME_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      MEDIA_TYPE
,      CONTENT_SOURCE
,      FND_FILE_ID
FROM JTF.JTF_FM_REQUEST_CONTENTS;

Dependencies

[top of page]

JTF.JTF_FM_REQUEST_CONTENTS does not reference any database object

JTF.JTF_FM_REQUEST_CONTENTS is referenced by following:

APPS: JTF_FM_REQUEST_CONTENTS