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

VIEW: APPS.JTF_FM_TEMPLATE_CONTENTS_V

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

View Type

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


Store detailed information about the fulfillment templates and their contents


[View Source]

Columns
Name Datatype Length Mandatory Comments
FRC_DEFAULT_OUTPUT_ID NUMBER

Default Output Id
FRC_CONTENT_NUMBER NUMBER (30) Yes Frc Content Number
FRC_OUTPUT_TYPE VARCHAR2 (240)
Frc Output Type
FRC_MES_DOC_ID NUMBER

Frc Mes Doc Id
FRC_CONTENT_NAME VARCHAR2 (50)
Frc Content Name
FRC_CONTENT_DESC VARCHAR2 (255)
Frc Content Desc
FRT_SOURCE_CODE_ID NUMBER

Frt Source Code Id
FRT_SOURCE_CODE VARCHAR2 (100)
Frt Source Code
FRT_OBJECT_TYPE VARCHAR2 (30)
Frt Object Type
FRT_OBJECT_ID NUMBER

Frt Object Id
FRT_TEMPLATE_NAME VARCHAR2 (50)
Frt Template Name
FRT_TEMPLATE_DESC VARCHAR2 (255)
Frt Template Desc
Query Text

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


SELECT FRC_DEFAULT_OUTPUT_ID
,      FRC_CONTENT_NUMBER
,      FRC_OUTPUT_TYPE
,      FRC_MES_DOC_ID
,      FRC_CONTENT_NAME
,      FRC_CONTENT_DESC
,      FRT_SOURCE_CODE_ID
,      FRT_SOURCE_CODE
,      FRT_OBJECT_TYPE
,      FRT_OBJECT_ID
,      FRT_TEMPLATE_NAME
,      FRT_TEMPLATE_DESC
FROM APPS.JTF_FM_TEMPLATE_CONTENTS_V;

Dependencies

[top of page]

APPS.JTF_FM_TEMPLATE_CONTENTS_V references the following:

SchemaAPPS
SynonymJTF_FM_TEMPLATE_ALL
SynonymJTF_FM_TEMPLATE_CONTENTS

APPS.JTF_FM_TEMPLATE_CONTENTS_V is not referenced by any database object