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.PA_DISTRIBUTION_RULES_LOV_V

Source

View Text - Preformatted


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))

View Text - HTML Formatted

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))