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.

[Home] [Help]

APPS.RCI_ORG_CERT_ETL_PKG dependencies on AMW_CERTIFICATION_VL

Line 347: amw_certification_vl acv,

343: amw_fin_org_eval_sum orgeval,
344: amw_audit_units_v auv,
345: amw_opinions_log_v certopinion,
346: amw_opinions_log_v evalopinion,
347: amw_certification_vl acv,
348: amw_gl_periods_v agpv,
349: amw_fin_cert_scope afcs
350: WHERE hier.entity_type = 'FINSTMT_CERTIFICATION'
351: AND hier.entity_id = orgeval.fin_certification_id

Line 607: ,amw_certification_vl acv

603: ,sysdate
604: ,G_USER_ID
605: ,G_LOGIN_ID
606: from amw_execution_scope aes
607: ,amw_certification_vl acv
608: ,amw_process ap
609: ,amw_process_names_tl apnt
610: ,amw_process_organization aop
611: ,hr_all_organization_units haou

Line 616: ,amw_certification_vl acv2

612: ,hr_all_organization_units_tl haout
613: ,hr_organization_information hoi
614: ,amw_opinions_v orgcert_aov
615: ,amw_opinions_v proccert_aolv
616: ,amw_certification_vl acv2
617: ,AMW_FIN_PROC_CERT_RELAN afpcr
618: ,(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
619: ,AMW_FIN_KEY_ACCOUNTS_VL AFKAV
620: /** 10.20.2005 npanandi begin ***/

Line 893: amw_certification_vl acv,

889: amw_fin_org_eval_sum orgeval,
890: amw_audit_units_v auv,
891: amw_opinions_log_v certopinion,
892: amw_opinions_log_v evalopinion,
893: amw_certification_vl acv,
894: amw_gl_periods_v agpv,
895: amw_fin_cert_scope afcs
896: WHERE hier.entity_type = 'FINSTMT_CERTIFICATION'
897: AND hier.entity_id = orgeval.fin_certification_id

Line 1124: ,amw_certification_vl acv

1120: ,sysdate
1121: ,G_USER_ID
1122: ,G_LOGIN_ID
1123: from amw_execution_scope aes
1124: ,amw_certification_vl acv
1125: ,amw_process ap
1126: ,amw_process_names_tl apnt
1127: ,amw_process_organization aop
1128: ,hr_all_organization_units haou

Line 1133: ,amw_certification_vl acv2

1129: ,hr_all_organization_units_tl haout
1130: ,hr_organization_information hoi
1131: ,amw_opinions_v orgcert_aov
1132: ,amw_opinions_log_v proccert_aolv
1133: ,amw_certification_vl acv2
1134: ,AMW_FIN_PROC_CERT_RELAN afpcr
1135: ,(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
1136: ,AMW_FIN_KEY_ACCOUNTS_VL AFKAV
1137: /** 10.20.2005 npanandi begin ***/