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.FUN_REPORT_PVT dependencies on FND_GLOBAL

Line 46: (SELECT FND_GLOBAL.user_id() AS user_id FROM DUAL) CURR

42: INTO l_person_id
43: FROM HZ_PARTIES HZP,
44: FND_USER U,
45: PER_ALL_PEOPLE_F PAP,
46: (SELECT FND_GLOBAL.user_id() AS user_id FROM DUAL) CURR
47: WHERE CURR.user_id = U.user_id
48: AND U.employee_id = PAP.person_id
49: AND PAP.party_id = HZP.party_id;
50: EXCEPTION

Line 160: AND LKUP.security_group_id=fnd_global.lookup_security_group(LKUP.lookup_type,435)

156: AND LKUP.lookup_type = ''FUN_BATCH_STATUS''
157: AND LKUP.lookup_code = FTB.status
158: AND LKUP.VIEW_APPLICATION_ID = 435
159: AND LKUP.language=USERENV(''LANG'')
160: AND LKUP.security_group_id=fnd_global.lookup_security_group(LKUP.lookup_type,435)
161: AND FTB.status IN (''NEW'', ''SENT'', ''ERROR'', ''COMPLETE'')
162: AND INIT_P.party_id = FTB.initiator_id
163: AND FTTVL.trx_type_id = FTB.trx_type_id
164: AND RECI_P.party_id(+) = FTH.recipient_id

Line 170: AND LKUP1.security_group_id=fnd_global.lookup_security_group(LKUP1.lookup_type,435)

166: AND FCV.currency_code = FTB.currency_code
167: AND LKUP1.lookup_type(+) = ''FUN_TRX_STATUS''
168: AND LKUP1.lookup_code(+) = FTH.status
169: AND LKUP1.view_application_id = 435
170: AND LKUP1.security_group_id=fnd_global.lookup_security_group(LKUP1.lookup_type,435)
171: AND LKUP1.language = USERENV(''LANG'')
172: AND GL.ledger_id = FTB.from_ledger_id
173: AND FTB_ORIG.batch_id(+) = FTB.original_batch_id
174: AND FTB_REV.batch_id(+) = FTB.reversed_batch_id

Line 317: (SELECT FND_GLOBAL.user_id() AS user_id FROM DUAL) CURR

313: INTO l_person_id
314: FROM HZ_PARTIES HZP,
315: FND_USER U,
316: PER_ALL_PEOPLE_F PAP,
317: (SELECT FND_GLOBAL.user_id() AS user_id FROM DUAL) CURR
318: WHERE CURR.user_id = U.user_id
319: AND U.employee_id = PAP.person_id
320: AND PAP.party_id = HZP.party_id;
321:

Line 478: AND lkup1.security_group_id = fnd_global.lookup_security_group(lkup1.lookup_type,435)

474: AND lkup.lookup_type =''ACCOUNT_TYPE''
475: AND lkup.lookup_code IN (''A'',''E'',''L'',''R'')
476: AND lkup1.lookup_type =''FUN_BATCH_STATUS''
477: AND lkup1.view_application_id = 435
478: AND lkup1.security_group_id = fnd_global.lookup_security_group(lkup1.lookup_type,435)
479: AND lkup1.language = USERENV(''LANG'')
480: AND lkup1.lookup_code = FTB.status
481: AND lkup1.lookup_code IN (''NEW'',''SENT'',''ERROR'',''COMPLETE'')
482: AND INIT_P.party_id = FTB.initiator_id

Line 486: AND lkup2.security_group_id = fnd_global.lookup_security_group(lkup2.lookup_type,435)

482: AND INIT_P.party_id = FTB.initiator_id
483: AND RECI_P.party_id(+) = FTH.recipient_id
484: AND lkup2.lookup_code = FTH.status
485: AND lkup2.view_application_id = 435
486: AND lkup2.security_group_id = fnd_global.lookup_security_group(lkup2.lookup_type,435)
487: AND lkup2.language = USERENV(''LANG'')
488: AND LKUP2.lookup_type = ''FUN_TRX_STATUS''
489: AND FTH.batch_id(+) = FTB.batch_id
490: AND FTTVL.trx_type_id = FTB.trx_type_id

Line 709: (SELECT FND_GLOBAL.user_id() AS user_id FROM DUAL) CURR

705: INTO l_person_id
706: FROM HZ_PARTIES HZP,
707: FND_USER U,
708: PER_ALL_PEOPLE_F PAP,
709: (SELECT FND_GLOBAL.user_id() AS user_id FROM DUAL) CURR
710: WHERE CURR.user_id = U.user_id
711: AND U.employee_id = PAP.person_id
712: AND PAP.party_id = HZP.party_id;
713: EXCEPTION

Line 819: AND LKUP.security_group_id=fnd_global.lookup_security_group(lkup.lookup_type,435)

815: AND XLE.legal_entity_id = FTB.from_le_id
816: AND LKUP.lookup_type = ''FUN_BATCH_STATUS''
817: AND LKUP.lookup_code = FTB.status
818: AND LKUP.view_application_id = 435
819: AND LKUP.security_group_id=fnd_global.lookup_security_group(lkup.lookup_type,435)
820: AND LKUP.language = USERENV(''LANG'')
821: AND FTH.status IN (''RECEIVED'', ''APPROVED'', ''REJECTED'',
822: ''COMPLETE'', ''XFER_RECI_GL'', ''XFER_AR'', ''XFER_INI_GL'')
823: AND INIT_P.party_id = FTB.initiator_id

Line 830: AND LKUP1.security_group_id=fnd_global.lookup_security_group(lkup1.lookup_type,435)

826: AND XLE1.legal_entity_id(+) = FTH.to_le_id
827: AND FCV.currency_code = FTB.currency_code
828: AND LKUP1.lookup_type(+) = ''FUN_TRX_STATUS''
829: AND LKUP1.view_application_id = 435
830: AND LKUP1.security_group_id=fnd_global.lookup_security_group(lkup1.lookup_type,435)
831: AND LKUP1.language = USERENV(''LANG'')
832: AND LKUP1.lookup_code(+) = FTH.status
833: AND GL.ledger_id = FTB.from_ledger_id
834: AND FTB_ORIG.batch_id(+) = FTB.original_batch_id

Line 964: (SELECT FND_GLOBAL.user_id() AS user_id FROM DUAL) CURR

960: INTO l_person_id
961: FROM HZ_PARTIES HZP,
962: FND_USER U,
963: PER_ALL_PEOPLE_F PAP,
964: (SELECT FND_GLOBAL.user_id() AS user_id FROM DUAL) CURR
965: WHERE CURR.user_id = U.user_id
966: AND U.employee_id = PAP.person_id
967: AND PAP.party_id = HZP.party_id;
968:

Line 1122: AND lkup1.security_group_id =fnd_global.lookup_security_group(lkup1.lookup_type,435)

1118: AND lkup.lookup_code IN (''A'',''E'',''L'',''R'')
1119: AND lkup1.lookup_type =''FUN_BATCH_STATUS''
1120: AND lkup1.lookup_code = FTB.status
1121: AND lkup1.view_application_id = 435
1122: AND lkup1.security_group_id =fnd_global.lookup_security_group(lkup1.lookup_type,435)
1123: AND lkup1.language = USERENV(''LANG'')
1124: AND INIT_P.party_id = FTB.initiator_id
1125: AND RECI_P.party_id(+) = FTH.recipient_id
1126: AND lkup2.lookup_code = FTH.status

Line 1129: AND lkup2.security_group_id =fnd_global.lookup_security_group(lkup2.lookup_type,435)

1125: AND RECI_P.party_id(+) = FTH.recipient_id
1126: AND lkup2.lookup_code = FTH.status
1127: AND LKUP2.lookup_type = ''FUN_TRX_STATUS''
1128: AND lkup2.view_application_id = 435
1129: AND lkup2.security_group_id =fnd_global.lookup_security_group(lkup2.lookup_type,435)
1130: AND lkup2.language = USERENV(''LANG'')
1131: AND LKUP2.lookup_code IN (''RECEIVED'',''APPROVED'',''REJECTED'',''COMPLETE'',''XFER_RECI_GL'',''XFER_AR'',''XFER_INI_GL'')
1132: AND FTH.batch_id(+) = FTB.batch_id
1133: AND FTTVL.trx_type_id = FTB.trx_type_id

Line 1415: AND security_group_id =fnd_global.lookup_security_group(lookup_type,435)

1411: INTO l_batch_status
1412: FROM FND_LOOKUP_VALUES
1413: WHERE lookup_type = 'FUN_BATCH_STATUS'
1414: AND view_application_id = 435
1415: AND security_group_id =fnd_global.lookup_security_group(lookup_type,435)
1416: AND language = USERENV('LANG')
1417: AND lookup_code = p_para_rec.batch_status;
1418: END IF;
1419:

Line 1426: AND security_group_id=fnd_global.lookup_security_group(lookup_type,435)

1422: INTO l_trx_status
1423: FROM FND_LOOKUP_VALUES
1424: WHERE lookup_type = 'FUN_TRX_STATUS'
1425: AND view_application_id = 435
1426: AND security_group_id=fnd_global.lookup_security_group(lookup_type,435)
1427: AND language = USERENV('LANG')
1428: AND lookup_code = p_para_rec.transaction_status;
1429: END IF;
1430: IF p_para_rec.trx_type_id IS NOT NULL THEN

Line 1664: AND security_group_id=fnd_global.lookup_security_group(lookup_type,435)

1660: INTO l_batch_status
1661: FROM FND_LOOKUP_VALUES
1662: WHERE lookup_type = 'FUN_BATCH_STATUS'
1663: AND view_application_id = 435
1664: AND security_group_id=fnd_global.lookup_security_group(lookup_type,435)
1665: AND language = USERENV('LANG')
1666: AND lookup_code = p_para_rec.batch_status;
1667: END IF;
1668: IF p_para_rec.transaction_status IS NOT NULL THEN

Line 1674: AND security_group_id=fnd_global.lookup_security_group(lookup_type,435)

1670: INTO l_trx_status
1671: FROM FND_LOOKUP_VALUES
1672: WHERE lookup_type = 'FUN_TRX_STATUS'
1673: AND view_application_id = 435
1674: AND security_group_id=fnd_global.lookup_security_group(lookup_type,435)
1675: AND language = USERENV('LANG')
1676: AND lookup_code = p_para_rec.transaction_status;
1677: END IF;
1678: IF p_para_rec.trx_type_id IS NOT NULL THEN