Relation between Receivables and Inventory Tables
Posted: Tue Feb 12, 2008 9:33 am
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
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