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.AMW_FINSTMT_CERT_BES_PKG dependencies on AMW_FIN_PROC_CERT_RELAN

Line 245: AMW_FIN_PROC_CERT_RELAN rel

241: Select distinct fin.PROCESS_ID, fin.ORGANIZATION_ID
242: FROM
243: AMW_OPINION_MV aov,
244: amw_fin_cert_scope fin,
245: AMW_FIN_PROC_CERT_RELAN rel
246: WHERE
247: rel.FIN_STMT_CERT_ID = ' || P_CERTIFICATION_ID || '
248: and fin.FIN_CERTIFICATION_ID = :1
249: and rel.end_date is null

Line 1205: amw_fin_proc_cert_relan rel

1201: Select distinct fin.process_ID, fin.ORGANIZATION_ID
1202: FROM
1203: AMW_OPINION_MV aov,
1204: amw_fin_cert_scope fin,
1205: amw_fin_proc_cert_relan rel
1206: WHERE
1207: rel.FIN_STMT_CERT_ID = ' || P_CERTIFICATION_ID || '
1208: and fin.FIN_CERTIFICATION_ID= :1
1209: and fin.process_id is not null

Line 1224: (select proc_cert_Id from AMW_FIN_PROC_CERT_RELAN

1220: where aov2.object_opinion_type_id
1221: = aov.object_opinion_type_id
1222: and aov2.pk3_value = aov.pk3_value
1223: AND aov2.pk2_value in
1224: (select proc_cert_Id from AMW_FIN_PROC_CERT_RELAN
1225: where fin_stmt_cert_id = fin.FIN_CERTIFICATION_ID
1226: and end_date is null)
1227: and aov2.pk1_value = aov.pk1_value) ';
1228:

Line 1281: AMW_FIN_PROC_CERT_RELAN rel

1277: WHERE proc.fin_certification_id = p_certification_id
1278: AND proc.organization_id = NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'), -999)
1279: AND not exists (SELECT 'Y'
1280: FROM AMW_OPINION_MV aov,
1281: AMW_FIN_PROC_CERT_RELAN rel
1282: WHERE aov.object_name = 'AMW_ORG_PROCESS'
1283: AND aov.opinion_type_code = 'CERTIFICATION'
1284: AND aov.opinion_component_code = 'OVERALL'
1285: AND aov.pk3_value = proc.organization_id

Line 1309: AMW_FIN_PROC_CERT_RELAN rel

1305: WHERE proc.fin_certification_id = p_certification_id
1306: AND proc.organization_id <> NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'),-999)
1307: AND not exists (SELECT 'Y'
1308: FROM AMW_OPINION_MV aov,
1309: AMW_FIN_PROC_CERT_RELAN rel
1310: WHERE aov.object_name = 'AMW_ORG_PROCESS'
1311: AND aov.opinion_type_code = 'CERTIFICATION'
1312: AND aov.opinion_component_code = 'OVERALL'
1313: AND aov.pk3_value = proc.organization_id

Line 1334: AMW_FIN_PROC_CERT_RELAN rel

1330: SELECT count(1) INTO x_global_proc_with_issue
1331: FROM (SELECT DISTINCT proc.organization_id, proc.process_id
1332: FROM AMW_FIN_PROCESS_EVAL_SUM proc,
1333: AMW_OPINION_MV aov,
1334: AMW_FIN_PROC_CERT_RELAN rel
1335: WHERE proc.fin_certification_id = p_certification_id
1336: AND proc.organization_id = NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'), -999)
1337: AND aov.object_name = 'AMW_ORG_PROCESS'
1338: AND aov.opinion_component_code = 'OVERALL'

Line 1364: AMW_FIN_PROC_CERT_RELAN rel

1360: SELECT count(1) INTO x_local_proc_with_issue
1361: FROM (SELECT DISTINCT proc.organization_id, proc.process_id
1362: FROM AMW_FIN_PROCESS_EVAL_SUM proc,
1363: AMW_OPINION_MV aov,
1364: AMW_FIN_PROC_CERT_RELAN rel
1365: WHERE proc.fin_certification_id = p_certification_id
1366: AND proc.organization_id <> NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'), -999)
1367: AND aov.object_name = 'AMW_ORG_PROCESS'
1368: AND aov.opinion_type_code = 'CERTIFICATION'

Line 3779: AND aov.pk2_value in (select proc_cert_Id from AMW_FIN_PROC_CERT_RELAN

3775: AND aov.pk3_value in (select distinct evalsum.organization_id
3776: from amw_fin_process_eval_sum evalsum
3777: where evalsum.fin_certification_id = p_cert_id
3778: and evalsum.process_id=p_process_id)
3779: AND aov.pk2_value in (select proc_cert_Id from AMW_FIN_PROC_CERT_RELAN
3780: where fin_stmt_cert_id = p_cert_id and end_date is null );
3781:
3782: CURSOR total_org_processes(p_cert_id NUMBER,p_process_id NUMBER) IS
3783: select count(distinct evalsum.organization_id)

Line 3807: select proc_cert_Id from AMW_FIN_PROC_CERT_RELAN

3803: WHERE aov.object_name = 'AMW_ORG_PROCESS'
3804: AND aov.opinion_type_code = 'CERTIFICATION'
3805: AND aov.opinion_component_code = 'OVERALL'
3806: AND aov.pk2_value in (
3807: select proc_cert_Id from AMW_FIN_PROC_CERT_RELAN
3808: where fin_stmt_cert_id = p_cert_id
3809: and end_date is null)
3810: AND aov.pk1_value in (SELECT varproc.process_id
3811: FROM AMW_PROCESS varproc

Line 4022: AND aov.pk2_value in (select proc_cert_Id from AMW_FIN_PROC_CERT_RELAN

4018: WHERE aov.object_name = 'AMW_ORG_PROCESS'
4019: AND aov.opinion_type_code = 'CERTIFICATION'
4020: AND aov.opinion_component_code = 'OVERALL'
4021: AND aov.pk3_value = p_organization_id
4022: AND aov.pk2_value in (select proc_cert_Id from AMW_FIN_PROC_CERT_RELAN
4023: where fin_stmt_cert_id = p_certification_id
4024: and end_date is null)
4025: AND aov.pk1_value in (select distinct(orgrel.child_process_id)
4026: from AMW_FIN_PROCESS_FLAT orgrel

Line 4048: AND aov.pk2_value in (select proc_cert_Id from AMW_FIN_PROC_CERT_RELAN

4044: WHERE aov.object_name = 'AMW_ORG_PROCESS'
4045: AND aov.opinion_type_code = 'CERTIFICATION'
4046: AND aov.opinion_component_code = 'OVERALL'
4047: AND aov.pk3_value = p_organization_id
4048: AND aov.pk2_value in (select proc_cert_Id from AMW_FIN_PROC_CERT_RELAN
4049: where fin_stmt_cert_id = p_certification_id
4050: and end_date is null)
4051: AND aov.pk1_value = p_process_id
4052: AND aov.authored_date = (select max(aov2.authored_date)

Line 4058: (select proc_cert_Id from AMW_FIN_PROC_CERT_RELAN

4054: where aov2.object_opinion_type_id = aov.object_opinion_type_id
4055: and aov2.pk3_value = aov.pk3_value
4056: and aov2.pk1_value = aov.pk1_value
4057: and aov2.pk2_value in
4058: (select proc_cert_Id from AMW_FIN_PROC_CERT_RELAN
4059: where fin_stmt_cert_id = p_certification_id
4060: and end_date is null));
4061:
4062:

Line 5690: AND aov.pk2_value in (select proc_cert_Id from AMW_FIN_PROC_CERT_RELAN

5686: AND aov.authored_date = (select max(aov2.authored_date)
5687: from AMW_OPINIONS aov2
5688: where aov2.object_opinion_type_id = aov.object_opinion_type_id
5689: and aov2.pk1_value = aov.pk1_value)
5690: AND aov.pk2_value in (select proc_cert_Id from AMW_FIN_PROC_CERT_RELAN
5691: where fin_stmt_cert_id = p_certification_id
5692: and end_date is null );
5693:
5694: CURSOR last_certification_history(l_opinion_id number) IS

Line 5722: AND aov.pk2_value in (select proc_cert_Id from AMW_FIN_PROC_CERT_RELAN

5718: AND aov.object_name = 'AMW_ORG_PROCESS'
5719: AND aov.opinion_type_code = 'CERTIFICATION'
5720: AND aov.opinion_component_code = 'OVERALL'
5721: AND aov.pk3_value = p_organization_id
5722: AND aov.pk2_value in (select proc_cert_Id from AMW_FIN_PROC_CERT_RELAN
5723: where fin_stmt_cert_id = p_certification_id
5724: and end_date is null )
5725: AND aov.pk1_value = proeval.process_id
5726: AND aov.authored_date = (select max(aov2.authored_date)

Line 5732: (select proc_cert_Id from AMW_FIN_PROC_CERT_RELAN

5728: where aov2.object_opinion_type_id
5729: = aov.object_opinion_type_id
5730: and aov2.pk3_value = aov.pk3_value
5731: AND aov2.pk2_value in
5732: (select proc_cert_Id from AMW_FIN_PROC_CERT_RELAN
5733: where fin_stmt_cert_id = p_certification_id
5734: and end_date is null)
5735: and aov2.pk1_value = aov.pk1_value)
5736: AND aov.OPINION_VALUE_CODE <> 'EFFECTIVE';

Line 5748: AND aov.pk2_value in (select proc_cert_Id from AMW_FIN_PROC_CERT_RELAN

5744: AND aov.object_name = 'AMW_ORG_PROCESS'
5745: AND aov.opinion_type_code = 'CERTIFICATION'
5746: AND aov.opinion_component_code = 'OVERALL'
5747: AND aov.pk3_value = p_organization_id
5748: AND aov.pk2_value in (select proc_cert_Id from AMW_FIN_PROC_CERT_RELAN
5749: where fin_stmt_cert_id = p_certification_id
5750: and end_date is null)
5751: AND aov.pk1_value = proeval.process_id
5752: AND aov.authored_date = (select max(aov2.authored_date)

Line 5758: (select proc_cert_Id from AMW_FIN_PROC_CERT_RELAN

5754: where aov2.object_opinion_type_id
5755: = aov.object_opinion_type_id
5756: and aov2.pk3_value = aov.pk3_value
5757: AND aov2.pk2_value in
5758: (select proc_cert_Id from AMW_FIN_PROC_CERT_RELAN
5759: where fin_stmt_cert_id = p_certification_id
5760: and end_date is null)
5761: and aov2.pk1_value = aov.pk1_value)
5762: AND aov.OPINION_VALUE_CODE = 'EFFECTIVE';

Line 8743: AND fin.fin_certification_id in (select rel.fin_stmt_cert_id from amw_fin_proc_cert_relan rel, amw_opinions_log opin

8739: FROM amw_fin_process_flat proc
8740: WHERE proc.fin_certification_id = fin.fin_certification_id
8741: AND proc.organization_id = l_org_id
8742: AND proc.child_process_id = l_process_id)
8743: AND fin.fin_certification_id in (select rel.fin_stmt_cert_id from amw_fin_proc_cert_relan rel, amw_opinions_log opin
8744: where rel.proc_cert_id = opin.pk2_value
8745: and opin.opinion_log_id = l_opinion_log_id
8746: and rel.end_date is null);
8747: