View: GCS_FEM_ACTIVE_DIMS_V

View Text

SELECT FTCB.DISPLAY_NAME
, FTCB.COLUMN_NAME
, DECODE(FTCB.COLUMN_NAME
, 'COMPANY_COST_CENTER_ORG_ID'
, 1
, 'LINE_ITEM_ID'
, 2
, 'USER_DIM10_ID'
, 4
, 'INTERCOMPANY_ID'
, 5
, 3) COLUMN_ORDER
FROM FEM_TAB_COLUMNS_TL FTCB
, FEM_TAB_COLUMN_PROP FTCP
WHERE FTCB.TABLE_NAME = 'FEM_BALANCES'
AND FTCB.TABLE_NAME = FTCP.TABLE_NAME
AND FTCB.LANGUAGE = USERENV('LANG')
AND FTCB.COLUMN_NAME = FTCP.COLUMN_NAME
AND FTCP.COLUMN_PROPERTY_CODE = 'PROCESSING_KEY'
AND FTCB.COLUMN_NAME IN ('CHANNEL_ID'
, 'COMPANY_COST_CENTER_ORG_ID'
, 'CUSTOMER_ID'
, 'FINANCIAL_ELEM_ID'
, 'INTERCOMPANY_ID'
, 'LINE_ITEM_ID'
, 'NATURAL_ACCOUNT_ID'
, 'PRODUCT_ID'
, 'PROJECT_ID'
, 'TASK_ID'
, 'USER_DIM10_ID'
, 'USER_DIM1_ID'
, 'USER_DIM2_ID'
, 'USER_DIM3_ID'
, 'USER_DIM4_ID'
, 'USER_DIM5_ID'
, 'USER_DIM6_ID'
, 'USER_DIM7_ID'
, 'USER_DIM8_ID'
, 'USER_DIM9_ID') ORDER BY 3
, 2

Columns