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.RCI_UNMTG_RISKS_ETL_PKG dependencies on AMW_ACCT_ASSOCIATIONS

Line 265: (select pk1,pk2,NATURAL_ACCOUNT_ID from AMW_ACCT_ASSOCIATIONS where object_type='PROCESS_ORG' and approval_date is not null and deletion_approval_date is null) aaa,

261: HR_ALL_ORGANIZATION_UNITS o,
262: HR_ALL_ORGANIZATION_UNITS_TL otl,
263: AMW_OPINIONS_LOG_V op,
264: amw_certification_vl acv,
265: (select pk1,pk2,NATURAL_ACCOUNT_ID from AMW_ACCT_ASSOCIATIONS where object_type='PROCESS_ORG' and approval_date is not null and deletion_approval_date is null) aaa,
266: AMW_FIN_KEY_ACCOUNTS_VL AFKAV,
267: amw_gl_periods_v agpv
268: WHERE risks.object_type = 'PROCESS_FINCERT'
269: and all_risks.risk_rev_id = risks.risk_rev_id

Line 452: (select pk1,pk2,NATURAL_ACCOUNT_ID from AMW_ACCT_ASSOCIATIONS where object_type='PROCESS_ORG' and approval_date is not null and deletion_approval_date is null) aaa,

448: AMW_CERTIFICATION_B acb,
449: AMW_CERTIFICATION_TL ACT,
450: amw_certification_vl acv2,
451: AMW_FIN_PROC_CERT_RELAN afpcr,
452: (select pk1,pk2,NATURAL_ACCOUNT_ID from AMW_ACCT_ASSOCIATIONS where object_type='PROCESS_ORG' and approval_date is not null and deletion_approval_date is null) aaa,
453: AMW_FIN_KEY_ACCOUNTS_VL AFKAV
454: /** 10.20.2005 npanandi begin ***/
455: ,amw_gl_periods_v agpv
456: /** 10.20.2005 npanandi end ***/

Line 660: (select pk1,pk2,NATURAL_ACCOUNT_ID from AMW_ACCT_ASSOCIATIONS where object_type='PROCESS_ORG' and approval_date is not null and deletion_approval_date is null) aaa,

656: HR_ALL_ORGANIZATION_UNITS o,
657: HR_ALL_ORGANIZATION_UNITS_TL otl,
658: AMW_OPINIONS_LOG_V op,
659: amw_certification_vl acv,
660: (select pk1,pk2,NATURAL_ACCOUNT_ID from AMW_ACCT_ASSOCIATIONS where object_type='PROCESS_ORG' and approval_date is not null and deletion_approval_date is null) aaa,
661: AMW_FIN_KEY_ACCOUNTS_VL AFKAV,
662: amw_gl_periods_v agpv
663: WHERE risks.object_type = 'PROCESS_FINCERT'
664: and all_risks.risk_rev_id = risks.risk_rev_id