xla_transaction_entities 表SOURCE_ID_INT_1 SOURCE_ID_INT_2 SOURCE_ID_INT_3 相关字段映射关系

xla_transaction_entities 表SOURCE_ID_INT_1 SOURCE_ID_INT_2 SOURCE_ID_INT_3 相关字段映射关系

查询sql如下：

SELECT fa.application_id,
       fa.application_short_name app,
       fat.application_name,
       DECODE(fpi.status, 'I', 'Licensed', 'S', 'Shared', 'N', 'Not Licensed') status,
       fpi.product_version,
       fpi.patch_level,
       xeim.entity_code,
       xeim.source_id_col_name_1,
       xeim.transaction_id_col_name_1,
       xeim.source_id_col_name_2,
       xeim.transaction_id_col_name_2,
       xeim.source_id_col_name_3,
       xeim.transaction_id_col_name_3,
       xeim.source_id_col_name_4,
       xeim.transaction_id_col_name_4
  FROM xla.xla_entity_id_mappings xeim
  JOIN applsys.fnd_application fa
    ON xeim.application_id = fa.application_id
  JOIN applsys.fnd_application_tl fat
    ON fa.application_id = fat.application_id
  LEFT JOIN applsys.fnd_product_installations fpi
    ON fpi.application_id = fa.application_id
 WHERE 1 = 1
       AND xeim.source_id_col_name_1 IS NOT NULL
--       AND fpi.status <> 'N'
 ORDER BY fat.application_name, xeim.entity_code;