Inventory Management - EBS (MOSC)

MOSC Banner

Please help for OPM Inventory question

edited Jul 24, 2009 3:09AM in Inventory Management - EBS (MOSC) 2 commentsAnswered
Hi we are using R12, OPM Inventory. I am trying to write a SQL query to link the rcv_transactions with the XLA tables. In discrete inventory, I can link the receiving transaction using the follwoing table links: rcv_transactions --> rcv_receiving_sub_ledgers --> xla_distribution_links --> xla_ae_headers --> xla_ae_lines

How do I establish the similar link for OPM Inventory? I found the followoing link so far:

rcv_transaction --> gmf_rcv_accounting_txns

Howver, beyond this table how do I find the link to xla tables?

Thanks,

Milan

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