Oracle EBS 子分类帐定义事件与各模块对应关系

Oracle EBS 子分类帐定义事件与各模块对应关系

设置->财务系统->子分类帐会计->会计方法生成器->事件->事件模型

--  子分类帐定义事件与各模块对应关系

SELECT fav.application_id

     ,fav.application_short_name

     ,fav.application_name

     ,xet.entity_code

     ,xet.name    

     ,nvl(xem_entity.transaction_id_col_name_1

         ,'x') || ' = ' || nvl(xem_identifier.source_id_col_name_1

                          ,'x') relation_key1

     ,nvl(xem_entity.transaction_id_col_name_2

         ,'x') || ' = ' || nvl(xem_identifier.source_id_col_name_2

                          ,'x') relation_key2

     ,nvl(xem_entity.transaction_id_col_name_3

         ,'x') || ' = ' || nvl(xem_identifier.source_id_col_name_3

                          ,'x') relation_key3

     ,nvl(xem_entity.transaction_id_col_name_4

         ,'x') || ' = ' || nvl(xem_identifier.source_id_col_name_4

                          ,'x')  relation_key4

  FROM fnd_application_vl    fav

     ,xla_entity_types_vl    xet

     ,xla_entity_id_mappings xem_entity

     ,xla_entity_id_mappings xem_identifier

 WHERE fav.application_id = xet.application_id

   AND xet.application_id  in (140,200,222,201,300,275,401)

   AND  xet.application_id = xem_entity.application_id

   AND  xet.application_id = xem_identifier.application_id  

   AND xet.entity_code = xem_entity.entity_code

   AND xem_entity.entity_code = xem_identifier.entity_code

   AND nvl(xem_entity.transaction_id_col_name_1

         ,'x') = nvl(xem_identifier.transaction_id_col_name_1

                  ,'x')

   AND nvl(xem_entity.transaction_id_col_name_2

         ,'x') = nvl(xem_identifier.transaction_id_col_name_2

                  ,'x')

   AND nvl(xem_entity.transaction_id_col_name_3

         ,'x') = nvl(xem_identifier.transaction_id_col_name_3

                  ,'x')

   AND nvl(xem_entity.transaction_id_col_name_4

         ,'x') = nvl(xem_identifier.transaction_id_col_name_4

                  ,'x')

   AND nvl(xem_entity.source_id_col_name_1

         ,'x') = nvl(xem_identifier.source_id_col_name_1

                  ,'x')

   AND nvl(xem_entity.source_id_col_name_2

         ,'x') = nvl(xem_identifier.source_id_col_name_2

                  ,'x')

   AND nvl(xem_entity.source_id_col_name_3

         ,'x') = nvl(xem_identifier.source_id_col_name_3

                  ,'x')

   AND nvl(xem_entity.source_id_col_name_4

         ,'x') = nvl(xem_identifier.source_id_col_name_4

                  ,'x')    

   AND (  xem_entity.transaction_id_col_name_1 IS NOT NULL 

              OR  xem_identifier.transaction_id_col_name_1 IS NOT NULL 

              OR xem_entity.transaction_id_col_name_2 IS NOT NULL 

              OR  xem_identifier.transaction_id_col_name_2 IS NOT NULL

              OR xem_entity.transaction_id_col_name_3 IS NOT NULL 

              OR  xem_identifier.transaction_id_col_name_3 IS NOT NULL 

              OR xem_entity.transaction_id_col_name_4 IS NOT NULL 

              OR  xem_identifier.transaction_id_col_name_4 IS NOT NULL

              )         

         ;

-- 刘轶鹤

分享：