what is the joining of Gl to Fixed Asset

Summary:

here i just needed to add up asset number which is missing on some dr+cr entries in XLA tables that is must for every entered entry.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

select gjh.je_header_id
,glb.name JournalBATCHNumber
,gjh.name Journal_name
,gjh.description
, case when gjh.status = 'P' then 'Yes' else 'No' END "ISPOSTED"
,gjh.JE_SOURCE ACCOUNTTYPE
,gjh.JE_CATEGORY TRANSACTIONTYPE
--, XEP.NAME LEGAL_EMP
, gjh.CURRENCY_CODE CURRENCYCODE
, gjl.je_line_num LINENUMBER