Inventory Cost Currency And UserId

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
AIMAM
Posts: 139
Joined: Thu May 17, 2007 6:04 am
Location: Egypt

Inventory Cost Currency And UserId

Post by AIMAM »

Hi,

In Oracle Apps 11i I have developed a customized report for the onhand inventory in the different subinventories from the following tables:
mtl_material_transactions
MTL_SYSTEM_ITEMS_B
MTL_ITEM_LOCATIONS
org_organization_definitions
CST_ITEM_COST_TYPE_V
I have taken the item cost from the last table mentioned above.
I was looking for the currency code of the item cost and I'm not sure what to do.
Can someone tell me where can I get the currency code from ...

Another question concerns the userid of the person generating (running) the report from the application(Inventory repsonsibility) .
How can I add that to the customized report?

Thank you ...
Post Reply

Who is online

Users browsing this forum: Ahrefs [Bot], Google Adsense [Bot] and 2 guests