View: PSP_XDO_TEMPLATES_V

Product:	PSP - Labor Distribution
Description:
Implementation/DBA Data:	APPS.PSP_XDO_TEMPLATES_V

View Text

SELECT DISTINCT TEMPLATE_CODE
, SUBSTR(TEMPLATE_CODE
, 4
, 2) AS REPORT_TYPE
, SUBSTR(TEMPLATE_CODE
, 6
, 3) AS TEMPLATE_CODE
, XDOTL.TEMPLATE_NAME
FROM XDO_TEMPLATES_TL XDOTL
, PSP_LAYOUT_OPTIONS PLO
WHERE APPLICATION_SHORT_NAME ='PSP'
AND XDOTL.TEMPLATE_CODE =PLO.REPORT_TEMPLATE_CODE
AND PLO.LAYOUT_LOOKUP_TYPE !='PSP_FRONT_PAGE'
AND XDOTL.LANGUAGE= USERENV('LANG')

Columns