SELECT DISTRIBUTION_SET_NAME DISTRIBUTION , DISTRIBUTION_SET_ID DISTRIBUTION_SET_ID , TOTAL_PERCENT_DISTRIBUTION TOTAL_PERCENT_DISTRIBUTION FROM AP_DISTRIBUTION_SETS WHERE NVL(INACTIVE_DATE, SYSDATE + 1) > SYSDATE AND TOTAL_PERCENT_DISTRIBUTION = 100
SELECT DISTRIBUTION_SET_NAME DISTRIBUTION
, DISTRIBUTION_SET_ID DISTRIBUTION_SET_ID
, TOTAL_PERCENT_DISTRIBUTION TOTAL_PERCENT_DISTRIBUTION
FROM AP_DISTRIBUTION_SETS
WHERE NVL(INACTIVE_DATE
, SYSDATE + 1) > SYSDATE
AND TOTAL_PERCENT_DISTRIBUTION = 100
|
|
|