View: JTF_FM_FAILURES_V

Product:	JTF - CRM Foundation
Description:	View on JTF_FM_CONTENT_FAILURES and JTF_FM_PROCESSED table to provide information on a given request for a given party_id
Implementation/DBA Data:	APPS.JTF_FM_FAILURES_V

View Text

SELECT JFUFFE.REQUEST_ID
, JFUFFE.JOB
, JFUFPD.PARTY_ID
, JFUFFE.FAILURE
, JFUFFE.ADDRESS
, JFUFFE.MEDIA_TYPE
, JFUFFE.CORRECTED_ADDRESS
, JFUFFE.CORRECTED_FLAG
FROM JTF_FM_CONTENT_FAILURES JFUFFE
, JTF_FM_PROCESSED JFUFPD
WHERE JFUFFE.REQUEST_ID=JFUFPD.REQUEST_ID
AND JFUFFE.JOB=JFUFPD.JOB

Columns