General Ledger - EBS (MOSC)

MOSC Banner

XLA_DSIRTIBUTION_LINKS : What is the primari key ? It;s JOIN with other XLA tables ?

edited Jun 17, 2013 1:26PM in General Ledger - EBS (MOSC) 2 commentsAnswered
Hi there,

The ETRM specifies that the primary key for XLA_DISTRIBUTION_LINKS is :

Primary Key: XLA_DISTRIBUTION_LINKS_PK
  1. EVENT_ID
  2. AE_HEADER_ID
  3. AE_LINE_NUM
  4. 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center