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_PROC_DETAIL_ETL_PKG dependencies on AMW_FIN_PROC_CERT_RELAN

Line 331: AMW_FIN_PROC_CERT_RELAN REL,

327: sysdate,
328: G_USER_ID,
329: G_LOGIN_ID
330: from AMW_FIN_CERT_SCOPE finscope,
331: AMW_FIN_PROC_CERT_RELAN REL,
332: AMW_FIN_PROCESS_EVAL_SUM finprocsum,
333: HR_ALL_ORGANIZATION_UNITS o,
334: HR_ALL_ORGANIZATION_UNITS_TL otl,
335: AMW_PROCESS_ORGANIZATION_VL proc,

Line 361: from AMW_FIN_PROC_CERT_RELAN

357: AND certopn.authored_date = (select max(aov2.authored_date) from AMW_OPINIONS aov2
358: where aov2.object_opinion_type_id = certopn.object_opinion_type_id
359: and aov2.pk3_value = certopn.pk3_value
360: AND aov2.pk2_value in (select proc_cert_Id
361: from AMW_FIN_PROC_CERT_RELAN
362: where fin_stmt_cert_id = finprocsum.FIN_CERTIFICATION_ID
363: and end_date is null)
364: and aov2.pk1_value = certopn.pk1_value)
365: ***/

Line 538: AMW_FIN_PROC_CERT_RELAN afpcr,

534: amw_audit_units_v audit_v,
535: amw_certification_vl acv,
536: amw_audit_projects_v aapv,
537: amw_certification_vl acv2,
538: AMW_FIN_PROC_CERT_RELAN afpcr,
539: (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,
540: AMW_FIN_KEY_ACCOUNTS_VL AFKAV,
541: /** 10.19.2005 npanandi begin ***/
542: amw_gl_periods_v agpv

Line 740: AMW_FIN_PROC_CERT_RELAN REL,

736: sysdate,
737: G_USER_ID,
738: G_LOGIN_ID
739: from AMW_FIN_CERT_SCOPE finscope,
740: AMW_FIN_PROC_CERT_RELAN REL,
741: AMW_FIN_PROCESS_EVAL_SUM finprocsum,
742: HR_ALL_ORGANIZATION_UNITS o,
743: HR_ALL_ORGANIZATION_UNITS_TL otl,
744: AMW_PROCESS_ORGANIZATION_VL proc,

Line 770: from AMW_FIN_PROC_CERT_RELAN

766: AND certopn.authored_date = (select max(aov2.authored_date) from AMW_OPINIONS aov2
767: where aov2.object_opinion_type_id = certopn.object_opinion_type_id
768: and aov2.pk3_value = certopn.pk3_value
769: AND aov2.pk2_value in (select proc_cert_Id
770: from AMW_FIN_PROC_CERT_RELAN
771: where fin_stmt_cert_id = finprocsum.FIN_CERTIFICATION_ID
772: and end_date is null)
773: and aov2.pk1_value = certopn.pk1_value)
774: ***/

Line 932: AMW_FIN_PROC_CERT_RELAN afpcr,

928: amw_audit_units_v audit_v,
929: amw_certification_vl acv,
930: amw_audit_projects_v aapv,
931: amw_certification_vl acv2,
932: AMW_FIN_PROC_CERT_RELAN afpcr,
933: (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,
934: AMW_FIN_KEY_ACCOUNTS_VL AFKAV,
935: /** 10.19.2005 npanandi begin ***/
936: amw_gl_periods_v agpv