DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.JTF_FM_HIST_V

Object Details
Object Name: JTF_FM_HIST_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_FM_HIST_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


View to show detailed history of each fulfillment request


[View Source]

Columns
Name Datatype Length Mandatory Comments
CON_DOCUMENT_TYPE VARCHAR2 (50)
Con Document Type
CON_PARTY_ID NUMBER

Con Party Id
CON_BATCH_NUMBER NUMBER
Yes Con Batch Number
CON_MES_DOC_ID VARCHAR2 (20)
Con Doc Id
CON_CONTENT_NUMBER VARCHAR2 (100)
Con Content Number
CON_CONTENT_TYPE VARCHAR2 (400)
Con Content Type
CON_CONTENT_NAME NUMBER

Con Content Name
CON_DESTINATION_ADDR VARCHAR2 (2000)
Con Destination Addr
CON_OUTPUT_ID VARCHAR2 (20)
Con Output Id
CON_USER_NOTES VARCHAR2 (2000)
Con User Notes
CON_OUTCOME_CODE NUMBER (15)
Con Outcome Code
CON_OUTCOME_DESC NUMBER (15) Yes Con Outcome Desc
HIS_SOURCE_CODE_ID NUMBER

His Source Code Id
HIS_SOURCE_CODE VARCHAR2 (100)
His Source Code
HIS_OBJECT_TYPE VARCHAR2 (30)
His Object Type
HIS_OBJECT_ID NUMBER

His Object Id
HIS_ORDER_ID NUMBER

His Order Id
HIS_RESUBMIT_COUNT NUMBER

His Resubmit Count
HIS_REQUEST CLOB (4000)
His Request
HIS_SUBMIT_DT_TM DATE
Yes His Submit Dt Tm
HIS_SERVER_ID NUMBER

His Server Id
HIS_TEMPLATE_ID NUMBER

His Template Id
HIS_APP_INFO VARCHAR2 (240)
His App Info
HIS_GROUP_ID NUMBER

His Group Id
HIS_HIST_REQ_ID NUMBER
Yes His Hist Req Id
HIS_USER_ID NUMBER (15)
His User Id
HIS_PRIORITY NUMBER

His Priority
HIS_PROCESSED_DT_TM VARCHAR2 (240)
His Processed Dt Tm
HIS_MESSAGE_ID RAW (16)
His Message Id
HIS_ORG_ID NUMBER (15)
His Org Id
Query Text

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


SELECT CON_DOCUMENT_TYPE
,      CON_PARTY_ID
,      CON_BATCH_NUMBER
,      CON_MES_DOC_ID
,      CON_CONTENT_NUMBER
,      CON_CONTENT_TYPE
,      CON_CONTENT_NAME
,      CON_DESTINATION_ADDR
,      CON_OUTPUT_ID
,      CON_USER_NOTES
,      CON_OUTCOME_CODE
,      CON_OUTCOME_DESC
,      HIS_SOURCE_CODE_ID
,      HIS_SOURCE_CODE
,      HIS_OBJECT_TYPE
,      HIS_OBJECT_ID
,      HIS_ORDER_ID
,      HIS_RESUBMIT_COUNT
,      HIS_REQUEST
,      HIS_SUBMIT_DT_TM
,      HIS_SERVER_ID
,      HIS_TEMPLATE_ID
,      HIS_APP_INFO
,      HIS_GROUP_ID
,      HIS_HIST_REQ_ID
,      HIS_USER_ID
,      HIS_PRIORITY
,      HIS_PROCESSED_DT_TM
,      HIS_MESSAGE_ID
,      HIS_ORG_ID
FROM APPS.JTF_FM_HIST_V;

Dependencies

[top of page]

APPS.JTF_FM_HIST_V references the following:

SchemaAPPS
SynonymJTF_FM_CONTENT_HISTORY
SynonymJTF_FM_REQUEST_HISTORY_ALL

APPS.JTF_FM_HIST_V is not referenced by any database object