General Ledger - EBS (MOSC)

MOSC Banner

How to get Sub Ledger accounting lines for Inventory

edited May 16, 2014 12:00PM in General Ledger - EBS (MOSC) 3 commentsAnswered

Dear All

I want to get Sub Ledger accounting lines for Inventory. Query is almost done but there is one in join condition. I am using a table named XLA.XLA_TRANSACTION_ENTITIES in which there is a column named SOURCE_ID_INT_1. I am confused how to join it to RCV_TRANSACTIONS or MTL_MATERIAL_TRANSACTIONS. If I join this column to RCV_TRANSACTIONS then no of records become less which results into incorrect sub ledger balances.

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