This content has been marked as final. Show 3 replies
You will have to join with gl_sets_of_Books and get the currency code from there.1 person found this helpful
And you can get the userid by using the following function fnd_global.userid
using fnd_global.userid gave me -1.
I need to know how to print the user id of the application user who requested of the customized report .
what do i need to add to the report?
my query is as follows and i have no customized PLSQL programs in the report:
i.SEGMENT1 AS "ITEM ID"
,i.DESCRIPTION AS "ITEM DESCRIPTION"
,o.ORGANIZATION_CODE AS "ORGANIZATION"
,m.SUBINVENTORY_CODE AS "SUBINVENTORY"
,round(c.ITEM_COST,2) As ITEM_COST
,SUM(m.TRANSACTION_QUANTITY) AS "QUANTITY"
,round(((SUM(m.TRANSACTION_QUANTITY))*c.ITEM_COST),2) AS "Total COST"
AND c.INVENTORY_ITEM_ID= i.INVENTORY_ITEM_ID
AND c.ITEM_COST > 0
and m.SUBINVENTORY_CODE in ('MWarehouse','MWAREHOUSE')
AND o.ORGANIZATION_ID = NVL(:P_ORG, o.ORGANIZATION_ID)
AND m.SUBINVENTORY_CODE = NVL(:P_SUBINV,m.SUBINVENTORY_CODE)
AND TRUNC(m.TRANSACTION_DATE) BETWEEN NVL(:P_DATE_FROM, TRUNC(m.TRANSACTION_DATE ))
AND NVL(:P_DATE_TO, TRUNC(m.TRANSACTION_DATE ))
ORDER BY m.SUBINVENTORY_CODE;
I will appreciate any help
If you run this from sql and you have not initialized your environment, then
fnd_global.user_id will give you -1.
However, if you are logged into EBS and running this report, fnd_global.user_id will work.
Hope this answers your question.
Edited by: Sandeep Gandhi, Independent Consultant on May 14, 2009 8:05 AM