[Home] [Help]
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
Name |
REQUEST_ID |
JOB |
PARTY_ID |
FAILURE |
ADDRESS |
MEDIA_TYPE |
CORRECTED_ADDRESS |
CORRECTED_FLAG |