View: BIC_DIMV_PERIOD_TYPES

View Text

SELECT 'MONTH' CODE
, PERIOD_TYPE NAME
, 'COL0' ATTRIBUTE_CODE
FROM GL_PERIOD_TYPES
WHERE PERIOD_TYPE = JTF_BIS_UTIL.PROFILEVALUE('CRMBIS:PERIOD_TYPE') UNION SELECT ATTRIBUTE3 CODE
, ATTRIBUTE_LABEL_LONG NAME
, ATTRIBUTE_CODE
FROM AK_REGION_ITEMS_VL
WHERE REGION_CODE = 'BIC_PERIOD_TYPES' WITH READ ONLY

Columns