eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IEC_G_REP_LIST_DETAILS_V

Source

View Text - Preformatted


SELECT DISTINCT A.CAMPAIGN_ID , C.STATUS_CODE , A.SCHEDULE_ID , A.SCHEDULE_STATUS , A.LIST_HEADER_ID , A.STATUS_CODE , A.DIALING_METHOD , NVL(D.RECORD_LOADED, 0) , NVL(NVL(D.RECORD_LOADED, 0) - NVL(E.RECORDS_VALID_SOME_CPS, 0), 0) , NVL(E.RECORDS_VALID_SOME_CPS, 0) , NVL(F.RECORDS_INVALID, 0) , NVL(D.RECORD_CALLED_ONCE, 0) , NVL(D.RECORD_CALLED_ONCE / Iec_CleanDivisor(D.RECORD_LOADED) * 100, 0) , NVL(D.RECORD_REMOVED, 0) , NVL(D.RECORD_REMOVED / Iec_CleanDivisor(D.RECORD_LOADED) * 100, 0) , NVL(D.RECORD_REMAINING, 0) , NVL(D.RECORD_REMAINING / Iec_CleanDivisor(D.RECORD_LOADED) * 100, 0) , NVL(D.RECORD_AVAILABLE, 0) , NVL(D.RECORD_AVAILABLE / Iec_CleanDivisor(D.RECORD_REMAINING) * 100, 0) , NVL(D.RECORD_UNAVAILABLE, 0) , NVL(D.RECORD_UNAVAILABLE / Iec_CleanDivisor(D.RECORD_REMAINING) * 100, 0) , Iec_GetPredictedExhaustion( NVL(D.RECORD_AVAILABLE, 0) + NVL(D.RECORD_UNAVAILABLE, 0) , NVL(D.RECORD_CALLED_AND_REMOVED, 0) , A.EXECUTION_START_TIME , SYSDATE ) FROM IEC_G_AO_LISTS_V A , IEC_G_CAMPAIGNS_V C , (SELECT E.LIST_HEADER_ID LIST_HEADER_ID , SUM(E.RECORD_LOADED) RECORD_LOADED , SUM(E.RECORD_CALLED_ONCE) RECORD_CALLED_ONCE , SUM(E.RECORD_REMOVED) RECORD_REMOVED , SUM(E.RECORD_REMAINING) RECORD_REMAINING , SUM(E.RECORD_AVAILABLE) RECORD_AVAILABLE , SUM(E.RECORD_UNAVAILABLE) RECORD_UNAVAILABLE , SUM(E.RECORD_CALLED_AND_REMOVED) RECORD_CALLED_AND_REMOVED FROM IEC_G_REP_SUBSET_DETAILS_V E GROUP BY E.LIST_HEADER_ID) D , (SELECT LIST_HEADER_ID, COUNT(*) RECORDS_VALID_SOME_CPS FROM IEC_O_VALIDATION_REPORT_DETS WHERE ( DO_NOT_USE_REASON_S1 IS NULL OR DO_NOT_USE_REASON_S2 IS NULL OR DO_NOT_USE_REASON_S3 IS NULL OR DO_NOT_USE_REASON_S4 IS NULL OR DO_NOT_USE_REASON_S5 IS NULL OR DO_NOT_USE_REASON_S6 IS NULL ) GROUP BY LIST_HEADER_ID) E , (SELECT LIST_HEADER_ID, COUNT(*) RECORDS_INVALID FROM IEC_O_VALIDATION_REPORT_DETS WHERE ( DO_NOT_USE_REASON_S1 IS NOT NULL AND DO_NOT_USE_REASON_S2 IS NOT NULL AND DO_NOT_USE_REASON_S3 IS NOT NULL AND DO_NOT_USE_REASON_S4 IS NOT NULL AND DO_NOT_USE_REASON_S5 IS NOT NULL AND DO_NOT_USE_REASON_S6 IS NOT NULL ) GROUP BY LIST_HEADER_ID) F WHERE A.CAMPAIGN_ID = C.CAMPAIGN_ID AND A.LIST_HEADER_ID = D.LIST_HEADER_ID(+) AND A.LIST_HEADER_ID = E.LIST_HEADER_ID(+) AND A.LIST_HEADER_ID = F.LIST_HEADER_ID(+)

View Text - HTML Formatted

SELECT DISTINCT A.CAMPAIGN_ID
, C.STATUS_CODE
, A.SCHEDULE_ID
, A.SCHEDULE_STATUS
, A.LIST_HEADER_ID
, A.STATUS_CODE
, A.DIALING_METHOD
, NVL(D.RECORD_LOADED
, 0)
, NVL(NVL(D.RECORD_LOADED
, 0) - NVL(E.RECORDS_VALID_SOME_CPS
, 0)
, 0)
, NVL(E.RECORDS_VALID_SOME_CPS
, 0)
, NVL(F.RECORDS_INVALID
, 0)
, NVL(D.RECORD_CALLED_ONCE
, 0)
, NVL(D.RECORD_CALLED_ONCE / IEC_CLEANDIVISOR(D.RECORD_LOADED) * 100
, 0)
, NVL(D.RECORD_REMOVED
, 0)
, NVL(D.RECORD_REMOVED / IEC_CLEANDIVISOR(D.RECORD_LOADED) * 100
, 0)
, NVL(D.RECORD_REMAINING
, 0)
, NVL(D.RECORD_REMAINING / IEC_CLEANDIVISOR(D.RECORD_LOADED) * 100
, 0)
, NVL(D.RECORD_AVAILABLE
, 0)
, NVL(D.RECORD_AVAILABLE / IEC_CLEANDIVISOR(D.RECORD_REMAINING) * 100
, 0)
, NVL(D.RECORD_UNAVAILABLE
, 0)
, NVL(D.RECORD_UNAVAILABLE / IEC_CLEANDIVISOR(D.RECORD_REMAINING) * 100
, 0)
, IEC_GETPREDICTEDEXHAUSTION( NVL(D.RECORD_AVAILABLE
, 0) + NVL(D.RECORD_UNAVAILABLE
, 0)
, NVL(D.RECORD_CALLED_AND_REMOVED
, 0)
, A.EXECUTION_START_TIME
, SYSDATE )
FROM IEC_G_AO_LISTS_V A
, IEC_G_CAMPAIGNS_V C
, (SELECT E.LIST_HEADER_ID LIST_HEADER_ID
, SUM(E.RECORD_LOADED) RECORD_LOADED
, SUM(E.RECORD_CALLED_ONCE) RECORD_CALLED_ONCE
, SUM(E.RECORD_REMOVED) RECORD_REMOVED
, SUM(E.RECORD_REMAINING) RECORD_REMAINING
, SUM(E.RECORD_AVAILABLE) RECORD_AVAILABLE
, SUM(E.RECORD_UNAVAILABLE) RECORD_UNAVAILABLE
, SUM(E.RECORD_CALLED_AND_REMOVED) RECORD_CALLED_AND_REMOVED
FROM IEC_G_REP_SUBSET_DETAILS_V E GROUP BY E.LIST_HEADER_ID) D
, (SELECT LIST_HEADER_ID
, COUNT(*) RECORDS_VALID_SOME_CPS
FROM IEC_O_VALIDATION_REPORT_DETS
WHERE ( DO_NOT_USE_REASON_S1 IS NULL OR DO_NOT_USE_REASON_S2 IS NULL OR DO_NOT_USE_REASON_S3 IS NULL OR DO_NOT_USE_REASON_S4 IS NULL OR DO_NOT_USE_REASON_S5 IS NULL OR DO_NOT_USE_REASON_S6 IS NULL ) GROUP BY LIST_HEADER_ID) E
, (SELECT LIST_HEADER_ID
, COUNT(*) RECORDS_INVALID
FROM IEC_O_VALIDATION_REPORT_DETS
WHERE ( DO_NOT_USE_REASON_S1 IS NOT NULL
AND DO_NOT_USE_REASON_S2 IS NOT NULL
AND DO_NOT_USE_REASON_S3 IS NOT NULL
AND DO_NOT_USE_REASON_S4 IS NOT NULL
AND DO_NOT_USE_REASON_S5 IS NOT NULL
AND DO_NOT_USE_REASON_S6 IS NOT NULL ) GROUP BY LIST_HEADER_ID) F
WHERE A.CAMPAIGN_ID = C.CAMPAIGN_ID
AND A.LIST_HEADER_ID = D.LIST_HEADER_ID(+)
AND A.LIST_HEADER_ID = E.LIST_HEADER_ID(+)
AND A.LIST_HEADER_ID = F.LIST_HEADER_ID(+)