FV GTAS Activity Balance Exception

SELECT je_source, je_category,
       account_number
      ,sgl_acct_num
      ,amount 
      ,doc_num
      ,trading_partner_name
      ,trading_partner_agency_id
      ,trading_partner_main_account
      ,bud_trx_type,
	DECODE(exception_category,
         'NO_SINGLE_AUTH_TYPE_CODE','A single Authority Type Code cannot be derived from the GL Account'
        ,'INVALID_AUTH_TYPE_CODE','Invalid Authority Type Code'
        ,'INVALID_AUTH_TYPE_CODE_SUB','Budget Transaction Sub Type Authority Type Code Does not Match GTAS Authority Type Code GL Attribute'
        ,'INVALID_AUTH_TYPE_CODE_TRX','Budget Transaction Type Authority Type Code Does not Match GTAS Authority Type Code GL Attribute'
	,'FED_TP_MUST_HAVE_AGENCY_ID','Federal Trading Partner must have an Agency ID between 000-999'
	,'INVALID_FED_NONFED_CODE','Trading Partner not Compatible with the GTAS Federal or Non-Federal Code GL Attribute'
        ,'INVALID_FED_NONFED_CODE_TAS','Trading Partner not Compatible with the GTAS Federal or Non-Federal Code GL Attribute and/or TAS'
	,'INVALID_BUD_IMPACT_IND','Derived Budget Impact Indicator not valid for GL Account'
	,'INVALID_GL_REFERENCE_INFOMATION','Invalid General Ledger reference information'
        ,'FED_ACCT_SYM_NOT_FOUND','Trading Partner Treasury Account Symbol not found'
        ,'PARTY_INFO_NOT_FOUND','Party information not found'
	,'NO_REDUCTION_TYPE_CODE','Reduction Type code cannnot be derived'
	,exception_category)  exception_category1
  FROM fv_gtas_exceptions
 WHERE set_of_books_id = :P_LEDGER
 ORDER BY je_source, je_category, exception_category