eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMV_WFAPPROVAL_PVT dependencies on FND_USER

Line 46: select FND.USER_NAME

42: from jtf_amv_items_vl
43: where item_id = ItemId;
44:
45: CURSOR Requestor_Name IS
46: select FND.USER_NAME
47: from JTF_RS_RESOURCE_EXTNS RD
48: , FND_USER FND
49: where RD.USER_ID = FND.USER_ID
50: and RD.RESOURCE_ID = RequestorId;

Line 48: , FND_USER FND

44:
45: CURSOR Requestor_Name IS
46: select FND.USER_NAME
47: from JTF_RS_RESOURCE_EXTNS RD
48: , FND_USER FND
49: where RD.USER_ID = FND.USER_ID
50: and RD.RESOURCE_ID = RequestorId;
51:
52: CURSOR ItemKey_csr IS

Line 49: where RD.USER_ID = FND.USER_ID

45: CURSOR Requestor_Name IS
46: select FND.USER_NAME
47: from JTF_RS_RESOURCE_EXTNS RD
48: , FND_USER FND
49: where RD.USER_ID = FND.USER_ID
50: and RD.RESOURCE_ID = RequestorId;
51:
52: CURSOR ItemKey_csr IS
53: select amv_wf_requests_s.nextval

Line 525: , FND_USER FND1

521: -- NOTE Remove PPX relation in the cursor
522: CURSOR Chan_Approvers(chn_id NUMBER) IS
523: select FND1.USER_NAME
524: from JTF_RS_RESOURCE_EXTNS RD
525: , FND_USER FND1
526: , AMV_C_CHANNELS_B CHN
527: where RD.USER_ID = FND1.USER_ID
528: and RD.RESOURCE_ID = CHN.DEFAULT_APPROVER_USER_ID
529: and CHN.CHANNEL_ID = chn_id;

Line 534: , fnd_user fu

530:
531: CURSOR Secn_Approvers IS
532: select fu.user_name
533: from amv_u_access acc
534: , fnd_user fu
535: where acc.access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL
536: and acc.access_to_table_record_id = GetApprover.channel_id
537: and acc.user_or_group_type = AMV_UTILITY_PVT.G_USER
538: and acc.user_or_group_id = fu.user_id;