FA-SLA-GL Linking in R12:

FA-SLA-GL Linking in R12:

 select * from apps.fnd_application_vl where application_name like '%Asset%'

   
   1> Fixed Asset Tables :      
  
      select * from  apps.FA_Transaction_Headers where BOOK_TYPE_CODE= 'OPS CORP' and  asset_id=110279--event_id=4229742
     
      select * from apps.FA_ADDITIONS_B where ASSET_ID=110279
     
      select * from apps.FA_BOOKS where asset_id=110279
     
      select * from apps.FA_DEPRN_SUMMARY where ASSET_ID=110279
     
      select * from apps.FA_DEPRN_DETAIL where ASSET_ID=110279
      
      select * from apps.FA_DEPRN_PERIODS where BOOK_TYPE_CODE= 'OPS CORP' and FISCAL_YEAR=2008 and PERIOD_NUM=3
      
 
     
   2> SLA Tables:  
      select * from apps.xla_ae_headers xah where application_id=140 and event_id=4229742 --Get Event_id From FA_Transaction_Headers Tables And Note Down AE_HEADER_ID
            
      select * from apps.xla_ae_lines xal where application_id=140 and AE_HEADER_ID=4968977 --Get AE_HEADER_ID from xla_ae_headers and Note Down GL_SL_LINK_TABLE='XLAJEL' GL_SL_LINK_ID=925293,925292
     
      select * from apps.xla_distribution_links   xdl where application_id=140 and AE_HEADER_ID=4968977 --Get AE_HEADER_ID from xla_ae_headers and SOURCE_DISTRIBUTION_ID_NUM_1=186213 and SOURCE_DISTRIBUTION_ID_NUM_2=24082 and SOURCE_DISTRIBUTION_ID_NUM_3=13009
     
      select * from apps.xla_events xe where application_id=140 and event_id=4229742 --Get Event_id From FA_Transaction_Headers Tables
     
      select * from apps.XLA_TRANSACTION_ENTITIES  where application_id=140 and ENTITY_ID=4162281  --and SOURCE_ID_INT_1=186213 and SOURCE_ID_INT_2=24082 and SOURCE_ID_INT_3=13009
     
      --Note:apps.XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1=apps.xla_distribution_links.SOURCE_DISTRIBUTION_ID_NUM_1
     
   
      3>GL Tables
     
       select * from apps.gl_import_references where GL_SL_LINK_TABLE='XLAJEL' and GL_SL_LINK_ID IN(6891055 ,6891056)
      
       select * from apps.GL_je_headers where JE_HEADER_ID=4711169
      
       select * from apps.gl_je_lines gll where JE_HEADER_ID=4711169
      
       select * from apps.gl_periods ps
      
       select * from apps.gl_ledgers gl where LEDGER_ID=1
      
       select * from apps.gl_code_combinations  where CHART_OF_ACCOUNTS_ID=101