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