XLA_DSIRTIBUTION_LINKS : What is the primari key ? It;s JOIN with other XLA tables ?
The ETRM specifies that the primary key for XLA_DISTRIBUTION_LINKS is :
Primary Key: XLA_DISTRIBUTION_LINKS_PK
- EVENT_ID
- AE_HEADER_ID
- AE_LINE_NUM
- APPLICATION_ID
But when we see the table decription in PL/SQL developer, there is no such PRIMARY KEY ?
It shows that there is a unique key --- XLA_DISTRIBUTION_LINKS_U1
APPLICATION_ID, REF_AE_HEADER_ID, TEMP_LINE_NUM, AE_HEADER_ID
We need to know the correct way of Joining XLA_DISTRIBUTION_LINKS with other XLA TABLES for example : XLA_AE_HEADERS.
Regards,
Amol