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_ORG_DFCY_ETL_PKG dependencies on AMW_ACCT_ASSOCIATIONS

Line 276: ,(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

272: ,amw_certification_b acb
273: ,amw_latest_revisions_v alrv
274: ,amw_opinions_log_v aolv1
275: ,amw_opinions_log_v aolv2
276: ,(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
277: ,AMW_FIN_KEY_ACCOUNTS_VL AFKAV
278: ,amw_gl_periods_v agpv
279: where afpes.fin_certification_id = acb.certification_id
280: and afpes.process_id = alrv.process_id

Line 361: ,(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

357: ,HR_ALL_ORGANIZATION_UNITS_TL haout
358: ,amw_opinions_v aov1
359: ,amw_opinions_v aov2
360: ,amw_certification_b acb
361: ,(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
362: ,AMW_FIN_KEY_ACCOUNTS_VL AFKAV
363: ,amw_gl_periods_v agpv
364: where aca.object_type='RISK_FINCERT'
365: and aca.pk5=aolv.opinion_log_id

Line 622: (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,

618: amw_audit_projects_v aapv,
619: amw_certification_vl acv,
620: amw_certification_vl acv2,
621: AMW_FIN_PROC_CERT_RELAN afpcr,
622: (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,
623: AMW_FIN_KEY_ACCOUNTS_VL AFKAV
624: /** 10.20.2005 npanandi begin ***/
625: ,amw_gl_periods_v agpv
626: /** 10.20.2005 npanandi end ***/

Line 891: ,(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

887: ,amw_certification_b acb
888: ,amw_latest_revisions_v alrv
889: ,amw_opinions_log_v aolv1
890: ,amw_opinions_log_v aolv2
891: ,(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
892: ,AMW_FIN_KEY_ACCOUNTS_VL AFKAV
893: ,amw_gl_periods_v agpv
894: where afpes.fin_certification_id = acb.certification_id
895: and afpes.process_id = alrv.process_id

Line 1146: (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,

1142: amw_audit_projects_v aapv,
1143: amw_certification_vl acv,
1144: amw_certification_vl acv2,
1145: AMW_FIN_PROC_CERT_RELAN afpcr,
1146: (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,
1147: AMW_FIN_KEY_ACCOUNTS_VL AFKAV
1148: /** 10.20.2005 npanandi begin ***/
1149: ,amw_gl_periods_v agpv
1150: /** 10.20.2005 npanandi end ***/