VIEW: APPS.IEC_G_REP_SUBSET_DETAILS_V

Source

View Text - Preformatted

SELECT DISTINCT A.CAMPAIGN_ID , F.STATUS_CODE , A.SCHEDULE_ID , E.SCHEDULE_STATUS , A.LIST_HEADER_ID , E.STATUS_CODE , A.SUBSET_ID , NVL(A.RECORD_LOADED, 0) , NVL(A.RECORD_CALLED_ONCE, 0) , NVL(A.RECORD_CALLED_ONCE / Iec_CleanDivisor(A.RECORD_LOADED) * 100, 0) , NVL(A.RECORD_LOADED, 0) - (NVL(B.RECORD_AVAILABLE, 0) + NVL(C.RECORD_UNAVAILABLE, 0)) , NVL((NVL(A.RECORD_LOADED, 0) - (NVL(B.RECORD_AVAILABLE, 0) + NVL(C.RECORD_UNAVAILABLE, 0))) / Iec_CleanDivisor(A.RECORD_LOADED) * 100, 0) , NVL(B.RECORD_AVAILABLE, 0) + NVL(C.RECORD_UNAVAILABLE, 0) , NVL((NVL(B.RECORD_AVAILABLE, 0) + NVL(C.RECORD_UNAVAILABLE, 0)) / Iec_CleanDivisor(A.RECORD_LOADED) * 100, 0) , NVL(B.RECORD_AVAILABLE, 0) , NVL(B.RECORD_AVAILABLE / Iec_CleanDivisor(NVL(B.RECORD_AVAILABLE, 0) + NVL(C.RECORD_UNAVAILABLE, 0)) * 100, 0) , NVL(C.RECORD_UNAVAILABLE, 0) , NVL(C.RECORD_UNAVAILABLE / Iec_CleanDivisor(NVL(B.RECORD_AVAILABLE, 0) + NVL(C.RECORD_UNAVAILABLE, 0)) * 100, 0) , TO_DATE(NULL) , NVL(A.RECORD_CALLED_AND_REMOVED, 0) FROM IEC_G_REP_SUBSET_COUNTS A , IEC_G_REP_SUBSET_AVAIL_RECS B , IEC_G_REP_SUBSET_UNAVAIL_RECS C , IEC_G_LIST_SUBSETS D , IEC_G_AO_LISTS_V E , IEC_G_CAMPAIGNS_V F WHERE A.SUBSET_ID = B.SUBSET_ID(+) AND A.SUBSET_ID = C.SUBSET_ID(+) AND A.SUBSET_ID = D.LIST_SUBSET_ID AND D.STATUS_CODE <> 'DELETED' AND D.LIST_HEADER_ID = E.LIST_HEADER_ID AND A.CAMPAIGN_ID = F.CAMPAIGN_ID

View Text - HTML Formatted

SELECT DISTINCT A.CAMPAIGN_ID
, F.STATUS_CODE
, A.SCHEDULE_ID
, E.SCHEDULE_STATUS
, A.LIST_HEADER_ID
, E.STATUS_CODE
, A.SUBSET_ID
, NVL(A.RECORD_LOADED
, 0)
, NVL(A.RECORD_CALLED_ONCE
, 0)
, NVL(A.RECORD_CALLED_ONCE / IEC_CLEANDIVISOR(A.RECORD_LOADED) * 100
, 0)
, NVL(A.RECORD_LOADED
, 0) - (NVL(B.RECORD_AVAILABLE
, 0) + NVL(C.RECORD_UNAVAILABLE
, 0))
, NVL((NVL(A.RECORD_LOADED
, 0) - (NVL(B.RECORD_AVAILABLE
, 0) + NVL(C.RECORD_UNAVAILABLE
, 0))) / IEC_CLEANDIVISOR(A.RECORD_LOADED) * 100
, 0)
, NVL(B.RECORD_AVAILABLE
, 0) + NVL(C.RECORD_UNAVAILABLE
, 0)
, NVL((NVL(B.RECORD_AVAILABLE
, 0) + NVL(C.RECORD_UNAVAILABLE
, 0)) / IEC_CLEANDIVISOR(A.RECORD_LOADED) * 100
, 0)
, NVL(B.RECORD_AVAILABLE
, 0)
, NVL(B.RECORD_AVAILABLE / IEC_CLEANDIVISOR(NVL(B.RECORD_AVAILABLE
, 0) + NVL(C.RECORD_UNAVAILABLE
, 0)) * 100
, 0)
, NVL(C.RECORD_UNAVAILABLE
, 0)
, NVL(C.RECORD_UNAVAILABLE / IEC_CLEANDIVISOR(NVL(B.RECORD_AVAILABLE
, 0) + NVL(C.RECORD_UNAVAILABLE
, 0)) * 100
, 0)
, TO_DATE(NULL)
, NVL(A.RECORD_CALLED_AND_REMOVED
, 0)
FROM IEC_G_REP_SUBSET_COUNTS A
, IEC_G_REP_SUBSET_AVAIL_RECS B
, IEC_G_REP_SUBSET_UNAVAIL_RECS C
, IEC_G_LIST_SUBSETS D
, IEC_G_AO_LISTS_V E
, IEC_G_CAMPAIGNS_V F
WHERE A.SUBSET_ID = B.SUBSET_ID(+)
AND A.SUBSET_ID = C.SUBSET_ID(+)
AND A.SUBSET_ID = D.LIST_SUBSET_ID
AND D.STATUS_CODE <> 'DELETED'
AND D.LIST_HEADER_ID = E.LIST_HEADER_ID
AND A.CAMPAIGN_ID = F.CAMPAIGN_ID