Inventory Cost Currency And UserId
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) .