View: POR_TEMPLATES_V

Product:	ICX - Oracle iProcurement
Description:	Information Template View
Implementation/DBA Data:	APPS.POR_TEMPLATES_V

View Text

SELECT AR.ROWID ROW_ID
, AR.REGION_CODE REGION_CODE
, ART.NAME NAME
FROM AK_REGIONS_VL ART
, AK_REGIONS AR
WHERE AR.REGION_CODE LIKE 'IFT_%'
AND AR.DATABASE_OBJECT_NAME = 'POR_INFO_TEMPLATE_V'
AND AR.REGION_STYLE = 'TABLE'
AND AR.REGION_CODE = ART.REGION_CODE

Columns