View: PA_DISTRIBUTION_RULES_LOV_V

Product:	PA - Projects
Description:	This view displays all the relevant Distribution Rules for a template
Implementation/DBA Data:	APPS.PA_DISTRIBUTION_RULES_LOV_V

View Text

SELECT PTD.DISTRIBUTION_RULE
, DR.MEANING
, PTD.PROJECT_TYPE
, PAP.PROJECT_ID
FROM PA_PROJECT_TYPE_DISTRIBUTIONS PTD
, PA_DISTRIBUTION_RULES DR
, PA_PROJECTS PAP
WHERE PTD.DISTRIBUTION_RULE = DR.DISTRIBUTION_RULE
AND PTD.PROJECT_TYPE = PAP.PROJECT_TYPE
AND PAP.TEMPLATE_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN DR.START_DATE_ACTIVE
AND NVL(DR.END_DATE_ACTIVE
, TRUNC(SYSDATE))

Columns