View: AP_DISTRIBUTION_SETS_DSN_V

Product:	AP - Payables
Description:	(Release 10SC Only)
Implementation/DBA Data:	APPS.AP_DISTRIBUTION_SETS_DSN_V

View Text

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

Columns