[Home] [Help] [Dependency Information]
Object Name: | JTF_FM_PREVIEWS |
---|---|
Object Type: | TABLE |
Owner: | JTF |
FND Design Data: | JTF.JTF_FM_PREVIEWS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000169410C00003$$ | LOB | UNIQUE | APPS_TS_TX_DATA |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CREATED_BY | NUMBER | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
FM_BATCH_NO | NUMBER | Yes | Batch Number for the request. | |
FM_CONTENT | BLOB | (4000) | Yes | Content for the request. |
FM_CONTENT_BATCH_NO | NUMBER | Yes | Content Number for the batch (one for each content in the batch) | |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
FM_CONTENT_ID | NUMBER | Yes | Content Number for the request. | |
FM_CONTENT_NAME | VARCHAR2 | (50) | Yes | Name of the content. |
FM_CONTENT_TYPE_ID | VARCHAR2 | (5) | Yes | Type of content. |
FM_DEST_ADDRESS | VARCHAR2 | (128) | Yes | FM Content Receiver's address |
FM_DEST_ADDRESS_TYPE | VARCHAR2 | (15) | Yes | Type of Destination address. Could be Email, Fax or Printer. |
FM_DOCUMENT_NAME | VARCHAR2 | (128) | Yes | Name of the Document. |
FM_IS_ATTACHED | VARCHAR2 | (10) | Yes | Boolean Value to store value, to determineif content is to attached, or be inline when sent. |
FM_MIME_TYPE | VARCHAR2 | (64) | Yes | Store mime type. Could be htm,zip... |
FM_PARTY_ID | NUMBER | Yes | Party_id of the customer receiving this Fulfillment Request. | |
FM_QUANTITY | NUMBER | Yes | Number of copies to be sent. | |
FM_REQUEST_ID | NUMBER | Yes | Request Id of this request. | |
FM_USER_NOTE | VARCHAR2 | (2000) | User note associated with the content. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT CREATED_BY
, FM_BATCH_NO
, FM_CONTENT
, FM_CONTENT_BATCH_NO
, CREATION_DATE
, FM_CONTENT_ID
, FM_CONTENT_NAME
, FM_CONTENT_TYPE_ID
, FM_DEST_ADDRESS
, FM_DEST_ADDRESS_TYPE
, FM_DOCUMENT_NAME
, FM_IS_ATTACHED
, FM_MIME_TYPE
, FM_PARTY_ID
, FM_QUANTITY
, FM_REQUEST_ID
, FM_USER_NOTE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
FROM JTF.JTF_FM_PREVIEWS;
JTF.JTF_FM_PREVIEWS does not reference any database object
JTF.JTF_FM_PREVIEWS is referenced by following:
|
|
|