[Home] [Help]
View: JTF_FM_TEMPLATE_CONTENTS_V
Product: | JTF - CRM Foundation |
Description: | Stores detailed information about the fulfillment templates and their contents |
Implementation/DBA Data: |
APPS.JTF_FM_TEMPLATE_CONTENTS_V
|
View Text
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 JTF_FM_TEMPLATE_ALL FRT
, JTF_FM_TEMPLATE_CONTENTS FRC
WHERE FRC.TEMPLATE_ID=FRT.TEMPLATE_ID
Columns
Name |
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 |