FLA_REGIME_DETAILS_V

Details

• Schema: FUSION

• Object owner: FUN

• Object type: VIEW

Columns

Name
ORG_ID PRIMARY_FLAG REGIME_CODE LEDGER_ID PROP_SCOPE_CHANGE_CODE EQUIP_SCOPE_CHANGE_CODE

Query

SQL_Statement

SELECT org_id, 'Y' primary_flag, primary_regime_code regime_code, ledger_id, prim_prop_scope_change_code prop_scope_change_code, prim_equip_scope_change_code equip_scope_change_code FROM fla_system_options_all UNION ALL SELECT org_id, 'N' primary_flag, secondary_regime_code regime_code, secondary_ledger_id ledger_id, secd_prop_scope_change_code prop_scope_change_code, secd_equip_scope_change_code equip_scope_change_code FROM fla_system_options_all WHERE secondary_regime_code IS NOT NULL