[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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;
JTF.JTF_FM_REQUEST_CONTENTS does not reference any database object
JTF.JTF_FM_REQUEST_CONTENTS is referenced by following:
|
|
|