VIEW: APPS.GCS_FEM_ACTIVE_DIMS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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