[Home] [Help] [Dependency Information]
Object Name: | JTF_FM_PREVIEWS# |
---|---|
Object Type: | VIEW |
Owner: | JTF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CREATED_BY | NUMBER | Yes | ||
FM_BATCH_NO | NUMBER | Yes | ||
FM_CONTENT | BLOB | (4000) | Yes | |
FM_CONTENT_BATCH_NO | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
FM_CONTENT_ID | NUMBER | Yes | ||
FM_CONTENT_NAME | VARCHAR2 | (50) | Yes | |
FM_CONTENT_TYPE_ID | VARCHAR2 | (5) | Yes | |
FM_DEST_ADDRESS | VARCHAR2 | (128) | Yes | |
FM_DEST_ADDRESS_TYPE | VARCHAR2 | (15) | Yes | |
FM_DOCUMENT_NAME | VARCHAR2 | (128) | Yes | |
FM_IS_ATTACHED | VARCHAR2 | (10) | Yes | |
FM_MIME_TYPE | VARCHAR2 | (64) | Yes | |
FM_PARTY_ID | NUMBER | Yes | ||
FM_QUANTITY | NUMBER | Yes | ||
FM_REQUEST_ID | NUMBER | Yes | ||
FM_USER_NOTE | VARCHAR2 | (2000) | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
SECURITY_GROUP_ID | NUMBER |
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#;
|
|
|