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

Line 325: and aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = ''CANC'')

321: and aov.opinion_component_code = ''OVERALL''
322: and aov.PK3_VALUE = fin.ORGANIZATION_ID
323: and aov.PK1_VALUE = fin.PROCESS_ID
324: --fix bug 5724066
325: and aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = ''CANC'')
326: and fin.process_id is not null
327: and fin.FIN_CERTIFICATION_ID = :1 ';
328:
329: IF P_OBJECT_TYPE = 'FINANCIAL ITEM' THEN

Line 391: and aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = ''CANC'')

387: and aov.OPINION_VALUE_CODE <> ''EFFECTIVE''
388: and aov.opinion_component_code = ''OVERALL''
389: and aov.pk1_value = fin.organization_id
390: --fix bug 5724066
391: and aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = ''CANC'')
392: and fin.FIN_CERTIFICATION_ID= :1 ';
393:
394:
395: IF P_OBJECT_TYPE = 'FINANCIAL ITEM' THEN

Line 451: and aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = ''CANC'')

447: and aov.object_name = ''AMW_ORGANIZATION''
448: and aov.opinion_component_code = ''OVERALL''
449: and aov.pk1_value = fin.organization_id
450: --fix bug 5724066
451: and aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = ''CANC'')
452: and fin.FIN_CERTIFICATION_ID= :1 ';
453:
454:
455: IF P_OBJECT_TYPE = 'FINANCIAL ITEM' THEN

Line 641: and aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = ''CANC'')

637: and aov.opinion_component_code = ''OVERALL''
638: and aov.PK3_VALUE = fin.ORGANIZATION_ID
639: and aov.PK1_VALUE = fin.process_id
640: --fix bug 5724066
641: and aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = ''CANC'')
642: and fin.process_id is not null
643: and fin.FIN_CERTIFICATION_ID= :1 ';
644:
645:

Line 916: and aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = ''CANC'')

912: and aov.opinion_component_code = ''OVERALL''
913: AND aov.pk1_value = fin.control_id
914: AND aov.pk3_value = fin.organization_id
915: --fix bug 5724066
916: and aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = ''CANC'')
917: and fin.object_type = ''' || P_OBJECT_TYPE || '''' || '
918: and fin.fin_certification_id = :1 ';
919: ****************/
920:

Line 1012: and aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = ''CANC'')

1008: and aov.opinion_component_code = ''OVERALL''
1009: AND aov.pk1_value = fin.control_id
1010: AND aov.pk3_value = fin.organization_id
1011: --fix bug 5724066
1012: and aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = ''CANC'')
1013: and fin.object_type = ''' || P_OBJECT_TYPE || '''' || '
1014: and fin.fin_certification_id = :1 ';
1015: ******/
1016: l_stmt := 'select count(1) from(

Line 1399: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')

1395: WHERE proc.fin_certification_id = p_certification_id
1396: AND proc.organization_id = aov.pk3_value
1397: AND proc.process_id = aov.pk1_value
1398: --fix bug 5724066
1399: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
1400: AND proc.organization_id = NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'), -999)
1401: AND aov.object_name = 'AMW_ORG_PROCESS'
1402: AND aov.opinion_type_code = 'EVALUATION'
1403: AND aov.opinion_component_code = 'OVERALL'

Line 1428: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')

1424: WHERE proc.fin_certification_id = p_certification_id
1425: AND proc.organization_id = aov.pk3_value
1426: AND proc.process_id = aov.pk1_value
1427: --fix bug 5724066
1428: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
1429: AND proc.organization_id <> NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'), -999)
1430: AND aov.object_name = 'AMW_ORG_PROCESS'
1431: AND aov.opinion_type_code = 'EVALUATION'
1432: AND aov.opinion_component_code = 'OVERALL'

Line 1469: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')

1465: AND aov.pk1_value = fin.risk_id
1466: AND aov.pk3_value = fin.organization_id
1467: AND aov.pk4_value = fin.process_ID
1468: --fix bug 5724066
1469: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
1470: AND aov.OPINION_VALUE_CODE <> 'EFFECTIVE');
1471: *******/
1472:
1473: ----unmitigated_risks IS

Line 1502: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')

1498: AND fin.object_type = 'FINANCIAL STATEMENT'
1499: AND aov.pk1_value = fin.control_id
1500: AND aov.pk3_value = fin.organization_id
1501: --fix bug 5724066
1502: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
1503: AND aov.OPINION_TYPE_CODE = 'EVALUATION'
1504: AND aov.object_name = 'AMW_ORG_CONTROL'
1505: AND aov.opinion_component_code = 'OVERALL'
1506: AND aov.AUTHORED_DATE in (select max(aov2.authored_date)

Line 4079: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')

4075: AND aov.opinion_component_code = 'OVERALL'
4076: AND aov.pk3_value = p_organization_id
4077: AND aov.pk1_value = p_process_id
4078: --fix bug 5724066
4079: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
4080: AND aov.authored_date = (select max(aov2.authored_date)
4081: from AMW_OPINIONS aov2
4082: where aov2.object_opinion_type_id = aov.object_opinion_type_id
4083: and aov2.pk3_value = aov.pk3_value

Line 4113: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')

4109: AND aov.pk3_value = ara.pk1
4110: AND aov.pk4_value = ara.pk2
4111: AND aov.pk1_value = ara.risk_id
4112: --fix bug 5724066
4113: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
4114: AND aov.authored_date = (select max(aov2.authored_date)
4115: from AMW_OPINIONS aov2
4116: where aov2.object_opinion_type_id = aov.object_opinion_type_id
4117: and aov2.pk4_value = aov.pk4_value

Line 4163: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')

4159: AND aov.pk3_value = ara.pk1
4160: AND aov.pk4_value = ara.pk2
4161: AND aov.pk1_value = ara.risk_id
4162: --fix bug 5724066
4163: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
4164: );
4165:
4166:
4167: CURSOR ineffective_controls IS

Line 4188: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')

4184: AND aov.opinion_component_code = 'OVERALL'
4185: AND aov.pk3_value = aca.pk1
4186: AND aov.pk1_value = aca.control_id
4187: --fix bug 5724066
4188: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
4189: AND aov.authored_date = (select max(aov2.authored_date)
4190: from AMW_OPINIONS aov2
4191: where aov2.object_opinion_type_id = aov.object_opinion_type_id
4192: and aov2.pk3_value = aov.pk3_value

Line 4234: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')

4230: AND aov.opinion_component_code = 'OVERALL'
4231: AND aov.pk3_value = aca.pk1
4232: AND aov.pk1_value = aca.control_id
4233: --fix bug 5724066
4234: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
4235: ;
4236:
4237:
4238: l_sub_processes_certified NUMBER;

Line 4644: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')

4640: AND aov.pk3_value = l_organization_id
4641: AND aov.pk4_value = l_process_id
4642: AND aov.pk1_value = l_risk_id
4643: --fix bug 5724066
4644: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
4645: AND aov.authored_date = (select max(aov2.authored_date)
4646: from AMW_OPINIONS aov2
4647: where aov2.object_opinion_type_id = aov.object_opinion_type_id
4648: and aov2.pk3_value = aov.pk3_value

Line 4987: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')

4983: AND aov.opinion_type_code = 'EVALUATION'
4984: AND aov.pk3_value = l_organization_id
4985: AND aov.pk1_value = l_control_id
4986: --fix bug 5724066
4987: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
4988: AND aov.authored_date = (select max(aov2.authored_date)
4989: from AMW_OPINIONS aov2
4990: where aov2.object_opinion_type_id = aov.object_opinion_type_id
4991: and aov2.pk3_value = aov.pk3_value

Line 5322: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')

5318: AND aov.pk3_value = l_organization_id
5319: AND aov.pk4_value = l_audit_procedure_id
5320: AND aov.pk1_value = l_control_id
5321: --fix bug 5724066
5322: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
5323: AND aov.authored_date = (select max(aov2.authored_date)
5324: from AMW_OPINIONS aov2
5325: where aov2.object_opinion_type_id = aov.object_opinion_type_id
5326: and aov2.pk3_value = aov.pk3_value

Line 5668: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')

5664: AND aov.opinion_type_code = 'EVALUATION'
5665: AND aov.opinion_component_code = 'OVERALL'
5666: AND aov.pk1_value = p_organization_id
5667: --fix bug 5724066
5668: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
5669: AND aov.authored_date = (select max(aov2.authored_date)
5670: from AMW_OPINIONS aov2
5671: where aov2.object_opinion_type_id = aov.object_opinion_type_id
5672: and aov2.pk1_value = aov.pk1_value);

Line 5776: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')

5772: AND aov.opinion_component_code = 'OVERALL'
5773: AND aov.pk3_value = p_organization_id
5774: AND aov.pk1_value = proeval.process_id
5775: --fix bug 5724066
5776: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
5777: AND aov.authored_date =
5778: (select max(aov2.authored_date)
5779: from AMW_OPINIONS aov2
5780: where aov2.object_opinion_type_id = aov.object_opinion_type_id

Line 5797: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC');

5793: AND aov.opinion_component_code = 'OVERALL'
5794: AND aov.pk3_value = p_organization_id
5795: AND aov.pk1_value = proeval.process_id
5796: --fix bug 5724066
5797: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC');
5798:
5799:
5800:
5801: CURSOR unmitigated_risks IS

Line 5815: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')

5811: AND aov.pk3_value = ara.pk2
5812: AND aov.pk4_value = ara.pk3
5813: AND aov.pk1_value = ara.risk_id
5814: --fix bug 5724066
5815: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
5816: AND aov.authored_date = (select max(aov2.authored_date)
5817: from AMW_OPINIONS aov2
5818: where aov2.object_opinion_type_id = aov.object_opinion_type_id
5819: and aov2.pk4_value = aov.pk4_value

Line 5846: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC');

5842: AND aov.pk3_value = ara.pk2
5843: AND aov.pk4_value = ara.pk3
5844: AND aov.pk1_value = ara.risk_id
5845: --fix bug 5724066
5846: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC');
5847:
5848: CURSOR ineffective_controls IS
5849: SELECT count(distinct aca.control_id)
5850: FROM AMW_CONTROL_ASSOCIATIONS aca ,

Line 5861: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')

5857: AND aov.opinion_component_code = 'OVERALL'
5858: AND aov.pk3_value = p_organization_id
5859: AND aov.pk1_value = aca.control_id
5860: --fix bug 5724066
5861: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
5862: AND aov.authored_date = (select max(aov2.authored_date)
5863: from AMW_OPINIONS aov2
5864: where aov2.object_opinion_type_id = aov.object_opinion_type_id
5865: and aov2.pk3_value = aov.pk3_value

Line 5890: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC');

5886: AND aov.opinion_component_code = 'OVERALL'
5887: AND aov.pk3_value = p_organization_id
5888: AND aov.pk1_value = aca.control_id
5889: --fix bug 5724066
5890: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC');
5891:
5892: CURSOR c_org IS
5893: SELECT subsidiary_valueset, company_code, lob_valueset, lob_code
5894: FROM amw_audit_units_v

Line 10076: AND ao.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')

10072: and ao.pk3_value = l_organization_id
10073: and ao.pk4_value = l_process_id
10074: and ao.pk1_value = l_risk_id
10075: --fix bug 5724066
10076: AND ao.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
10077: and ao.authored_date = (select max(aov2.authored_date)
10078: from AMW_OPINIONS aov2
10079: where aov2.object_opinion_type_id = ao.object_opinion_type_id
10080: and aov2.pk3_value = ao.pk3_value

Line 10288: and ao.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')

10284: and aot.opinion_type_code = 'EVALUATION'
10285: and ao.pk3_value = l_organization_id
10286: and ao.pk1_value = l_control_id
10287: --fix bug 5724066
10288: and ao.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
10289: and ao.authored_date = (select max(aov2.authored_date)
10290: from AMW_OPINIONS aov2
10291: where aov2.object_opinion_type_id = ao.object_opinion_type_id
10292: and aov2.pk3_value = ao.pk3_value

Line 10492: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')

10488: AND aov.pk3_value = l_organization_id
10489: AND aov.pk4_value = l_audit_procedure_id
10490: AND aov.pk1_value = l_control_id
10491: --fix bug 5724066
10492: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
10493: AND aov.authored_date = (select max(aov2.authored_date)
10494: from AMW_OPINIONS aov2
10495: where aov2.object_opinion_type_id = aov.object_opinion_type_id
10496: and aov2.pk3_value = aov.pk3_value

Line 10661: and aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = ''CANC'')

10657: and aov.opinion_component_code = ''OVERALL''
10658: and aov.PK3_VALUE = fin.ORGANIZATION_ID
10659: and aov.PK1_VALUE = fin.PROCESS_ID
10660: --fix bug 5724066
10661: and aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = ''CANC'')
10662: and fin.process_id is not null
10663: and fin.FIN_CERTIFICATION_ID = :1 ';
10664:
10665: IF P_OBJECT_TYPE = 'FINANCIAL ITEM' THEN

Line 10722: and aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = ''CANC'')

10718: and aov.object_name = ''AMW_ORGANIZATION''
10719: and aov.opinion_component_code = ''OVERALL''
10720: and aov.pk1_value = fin.organization_id
10721: --fix bug 5724066
10722: and aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = ''CANC'')
10723: and fin.FIN_CERTIFICATION_ID= :1 ';
10724:
10725:
10726: IF P_OBJECT_TYPE = 'FINANCIAL ITEM' THEN

Line 10786: and aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = ''CANC'')

10782: and aov.pk1_value = fin.risk_id
10783: and aov.pk3_value = fin.organization_id
10784: and aov.pk4_value = fin.process_ID
10785: --fix bug 5724066
10786: and aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = ''CANC'')
10787: and fin.object_type = ''' || P_OBJECT_TYPE || '''' || '
10788: and fin.FIN_CERTIFICATION_ID= :1 ';
10789: ************/
10790:

Line 10869: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = ''CANC'')

10865: and aov.opinion_component_code = ''OVERALL''
10866: AND aov.pk1_value = fin.control_id
10867: AND aov.pk3_value = fin.organization_id
10868: --fix bug 5724066
10869: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = ''CANC'')
10870: and fin.object_type = ''' || P_OBJECT_TYPE || '''' || '
10871: and fin.fin_certification_id = :1 ';
10872: ****************************/
10873: