Relation between Receivables and Inventory Tables

[Pirzada]

Hello All,
I am new to oracle apps. I am creating a report having details of customer transaction. I want to pick the particular lot number of the item in transaction. I am not able to find the realtionship between the RA and MTL tables.
I am picking the transaction details from RA_CUSTOMER_TRX_ALL and TRX_LINES_ALL and want to pick the lot number from MTL_LOT_NUMBERS.
Need some guidance.

Regards
Ali Pirzada

[Wim van der Veer]

Hello Pirzada,

Maybe this will help you to solve your problem;

-- used tables
, ra_cust_trx_line_gl_dist_all rctlgd
, mtl_material_transactions mmt
there is also a standard view in oracle but you have to set the client, it contains a lot of info for AR view; ra_customer_trx_v rctv

-- link Material transaction to detail row ar-distr invoice
and mmt.trx_source_line_id = rctlgd.customer_trx_line_id (+)

Regards,

Wim van der Veer
Capgemini Belgium