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

Source

View Text - Preformatted


SELECT TMPB.ROWID AS ROW_ID, TMPB.TEMPLATE_CODE AS TEMPLATE_CODE, TMPT.TEMPLATE_NAME AS TEMPLATE_NAME, DECODE(TMPB.ORG_ID,NULL,'Y','N') AS ALL_ORG_FLAG, ATTACHMENT_CATEGORY_ID AS ATTACHMENT_CATEGORY_ID FROM POR_TEMPLATES_ALL_B TMPB, POR_TEMPLATES_ALL_TL TMPT WHERE TMPB.TEMPLATE_CODE=TMPT.TEMPLATE_CODE AND TMPT.LANGUAGE=USERENV('LANG') AND NVL(ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

View Text - HTML Formatted

SELECT TMPB.ROWID AS ROW_ID
, TMPB.TEMPLATE_CODE AS TEMPLATE_CODE
, TMPT.TEMPLATE_NAME AS TEMPLATE_NAME
, DECODE(TMPB.ORG_ID
, NULL
, 'Y'
, 'N') AS ALL_ORG_FLAG
, ATTACHMENT_CATEGORY_ID AS ATTACHMENT_CATEGORY_ID
FROM POR_TEMPLATES_ALL_B TMPB
, POR_TEMPLATES_ALL_TL TMPT
WHERE TMPB.TEMPLATE_CODE=TMPT.TEMPLATE_CODE
AND TMPT.LANGUAGE=USERENV('LANG')
AND NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)