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_PVT dependencies on AMW_PROCESS_ORG_BASICINFO_V

Line 4764: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

4760: Select
4761: Count(1) into P_TOTAL_NUMBER_OF_PROCESSES from
4762: (select distinct procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln
4763: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
4764: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
4765: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and
4766: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
4767: and AccProcs.natural_account_id in
4768: --(select

Line 4819: amw_process_org_basicinfo_v orgprocess

4815: AMW_OPINIONS_V opinion,
4816: AMW_OPINION_TYPES_B opiniontype,
4817: FND_OBJECTS fndobject,
4818: AMW_OBJECT_OPINION_TYPES objectopiniontype,
4819: amw_process_org_basicinfo_v orgprocess
4820: WHERE
4821: opinion.OBJECT_OPINION_TYPE_ID = objectopiniontype.OBJECT_OPINION_TYPE_ID AND
4822: opiniontype.OPINION_TYPE_ID = objectopiniontype.OPINION_TYPE_ID AND
4823: opiniontype.OPINION_TYPE_CODE = 'CERTIFICATION' AND

Line 4833: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

4829: and ( orgprocess.ORGANIZATION_ID , orgprocess.PROCESS_ID )
4830: in
4831: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln
4832: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
4833: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
4834: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and
4835: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
4836: and AccProcs.natural_account_id in
4837: -- (select

Line 4888: amw_process_org_basicinfo_v orgprocess

4884: AMW_OPINIONS_V opinion,
4885: AMW_OPINION_TYPES_B opiniontype,
4886: FND_OBJECTS fndobject,
4887: AMW_OBJECT_OPINION_TYPES objectopiniontype,
4888: amw_process_org_basicinfo_v orgprocess
4889: WHERE
4890: (opinion.AUTHORED_DATE in
4891: (Select
4892: MAX(opinion2.AUTHORED_DATE)

Line 4916: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

4912: and ( orgprocess.ORGANIZATION_ID , orgprocess.PROCESS_ID )
4913: in
4914: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln
4915: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
4916: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
4917: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and
4918: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
4919: and AccProcs.natural_account_id in
4920: -- (select

Line 4969: amw_process_org_basicinfo_v orgprocess

4965: AMW_OPINIONS_V opinion,
4966: AMW_OPINION_TYPES_B opiniontype,
4967: FND_OBJECTS fndobject,
4968: AMW_OBJECT_OPINION_TYPES objectopiniontype,
4969: amw_process_org_basicinfo_v orgprocess
4970: WHERE
4971: (opinion.AUTHORED_DATE in
4972: (Select
4973: MAX(opinion2.AUTHORED_DATE)

Line 4997: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

4993: and orgprocess.ORGANIZATION_ID
4994: in
4995: (select procRln.ORGANIZATION_ID from Amw_Process_Org_Relations procRln
4996: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
4997: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
4998: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and
4999: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
5000: and AccProcs.natural_account_id in
5001: -- (select

Line 5049: amw_process_org_basicinfo_v orgprocess

5045: AMW_OPINIONS_V opinion,
5046: AMW_OPINION_TYPES_B opiniontype,
5047: FND_OBJECTS fndobject,
5048: AMW_OBJECT_OPINION_TYPES objectopiniontype,
5049: amw_process_org_basicinfo_v orgprocess
5050: WHERE
5051: (opinion.AUTHORED_DATE in
5052: (Select
5053: MAX(opinion2.AUTHORED_DATE)

Line 5074: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

5070: and orgprocess.ORGANIZATION_ID
5071: in
5072: (select procRln.ORGANIZATION_ID from Amw_Process_Org_Relations procRln
5073: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
5074: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
5075: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and
5076: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
5077: and AccProcs.natural_account_id in
5078: -- (select

Line 5129: amw_process_org_basicinfo_v orgprocess

5125: AMW_OPINIONS_V opinion,
5126: AMW_OPINION_TYPES_B opiniontype,
5127: FND_OBJECTS fndobject,
5128: AMW_OBJECT_OPINION_TYPES objectopiniontype,
5129: amw_process_org_basicinfo_v orgprocess
5130: WHERE
5131: (opinion.AUTHORED_DATE in
5132: (Select
5133: MAX(opinion2.AUTHORED_DATE)

Line 5153: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

5149: and orgprocess.ORGANIZATION_ID
5150: in
5151: (select procRln.ORGANIZATION_ID from Amw_Process_Org_Relations procRln
5152: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
5153: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
5154: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and
5155: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
5156: and AccProcs.natural_account_id in
5157: -- (select

Line 5201: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

5197: into P_org_evaluated
5198: from
5199: (select distinct procRln.ORGANIZATION_ID from Amw_Process_Org_Relations procRln
5200: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
5201: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
5202: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and
5203: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
5204: and AccProcs.natural_account_id in
5205: -- (select

Line 5245: amw_process_org_basicinfo_v orgprocess

5241: AMW_OPINIONS_V opinion,
5242: AMW_OPINION_TYPES_B opiniontype,
5243: FND_OBJECTS fndobject,
5244: AMW_OBJECT_OPINION_TYPES objectopiniontype,
5245: amw_process_org_basicinfo_v orgprocess
5246: WHERE
5247: (opinion.AUTHORED_DATE in
5248: (Select
5249: MAX(opinion2.AUTHORED_DATE)

Line 5269: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

5265: and orgprocess.ORGANIZATION_ID
5266: in
5267: (select procRln.ORGANIZATION_ID from Amw_Process_Org_Relations procRln
5268: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
5269: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
5270: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and
5271: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
5272: and AccProcs.natural_account_id in
5273: -- (select

Line 5325: amw_process_org_basicinfo_v orgprocess

5321: AMW_OPINIONS_V opinion,
5322: AMW_OPINION_TYPES_B opiniontype,
5323: FND_OBJECTS fndobject,
5324: AMW_OBJECT_OPINION_TYPES objectopiniontype,
5325: amw_process_org_basicinfo_v orgprocess
5326: WHERE
5327: (opinion.AUTHORED_DATE in
5328: (Select
5329: MAX(opinion2.AUTHORED_DATE)

Line 5355: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

5351: and ( orgprocess.ORGANIZATION_ID , orgprocess.PROCESS_ID )
5352: in
5353: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln
5354: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
5355: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
5356: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and
5357: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
5358: and AccProcs.natural_account_id in
5359: -- (select

Line 5408: amw_process_org_basicinfo_v orgprocess

5404: AMW_OPINIONS_V opinion,
5405: AMW_OPINION_TYPES_B opiniontype,
5406: FND_OBJECTS fndobject,
5407: AMW_OBJECT_OPINION_TYPES objectopiniontype,
5408: amw_process_org_basicinfo_v orgprocess
5409: WHERE
5410: (opinion.AUTHORED_DATE in
5411: (Select
5412: MAX(opinion2.AUTHORED_DATE)

Line 5435: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

5431: and ( orgprocess.ORGANIZATION_ID , orgprocess.PROCESS_ID )
5432: in
5433: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln
5434: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
5435: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
5436: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and
5437: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
5438: and AccProcs.natural_account_id in
5439: -- (select

Line 5487: amw_process_org_basicinfo_v orgprocess,

5483: AMW_OPINIONS_V opinion,
5484: AMW_OPINION_TYPES_B opiniontype,
5485: FND_OBJECTS fndobject,
5486: AMW_OBJECT_OPINION_TYPES objectopiniontype,
5487: amw_process_org_basicinfo_v orgprocess,
5488: amw_risk_associations riskassoc,
5489: amw_control_associations ctrlassoc
5490: WHERE
5491: (opinion.AUTHORED_DATE in

Line 5527: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

5523: in
5524: -- and ( opinion.pk4_value ) in
5525: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln
5526: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
5527: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
5528: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and
5529: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
5530: and AccProcs.natural_account_id in
5531: -- (select

Line 5578: amw_process_org_basicinfo_v orgprocess,

5574: AMW_OPINIONS_V opinion,
5575: AMW_OPINION_TYPES_B opiniontype,
5576: FND_OBJECTS fndobject,
5577: AMW_OBJECT_OPINION_TYPES objectopiniontype,
5578: amw_process_org_basicinfo_v orgprocess,
5579: amw_risk_associations riskassoc
5580: WHERE
5581: (opinion.AUTHORED_DATE in
5582: (Select

Line 5616: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

5612: in
5613: -- and ( opinion.pk4_value ) in
5614: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln
5615: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
5616: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
5617: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and
5618: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
5619: and AccProcs.natural_account_id in
5620: -- (select

Line 5664: amw_process_org_basicinfo_v orgprocess,

5660: Select
5661: count(1) into p_risks_verified
5662: from (select distinct riskassoc.risk_id ,orgprocess.organization_id, orgprocess.Process_ID
5663: FROM
5664: amw_process_org_basicinfo_v orgprocess,
5665: amw_risk_associations riskassoc
5666: WHERE
5667: orgprocess.process_organization_id = riskassoc.pk1
5668: and riskassoc.object_type = 'PROCESS_ORG' AND

Line 5673: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

5669: ( orgprocess.ORGANIZATION_ID , orgprocess.PROCESS_ID )
5670: in
5671: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln
5672: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
5673: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
5674: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and
5675: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
5676: and AccProcs.natural_account_id in
5677: -- (select

Line 5715: amw_process_org_basicinfo_v orgprocess,

5711: AMW_OPINIONS_V opinion,
5712: AMW_OPINION_TYPES_B opiniontype,
5713: FND_OBJECTS fndobject,
5714: AMW_OBJECT_OPINION_TYPES objectopiniontype,
5715: amw_process_org_basicinfo_v orgprocess,
5716: amw_risk_associations riskassoc
5717: WHERE
5718: (opinion.AUTHORED_DATE in
5719: (Select

Line 5751: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

5747: in
5748: -- and ( opinion.pk4_value ) in
5749: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln
5750: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
5751: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
5752: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and
5753: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
5754: and AccProcs.natural_account_id in
5755: -- (select

Line 5803: amw_process_org_basicinfo_v orgprocess,

5799: COUNT(1) into p_controls_verified
5800: FROM
5801: ( select distinct ctrlassoc.control_id, orgprocess.organization_id
5802: FROM
5803: amw_process_org_basicinfo_v orgprocess,
5804: amw_risk_associations riskassoc,
5805: amw_control_associations ctrlassoc
5806: WHERE
5807: orgprocess.process_organization_id = riskassoc.pk1

Line 5815: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

5811: and ( orgprocess.ORGANIZATION_ID , orgprocess.PROCESS_ID )
5812: in
5813: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln
5814: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
5815: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
5816: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and
5817: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
5818: and AccProcs.natural_account_id in
5819: -- (select

Line 5859: amw_process_org_basicinfo_v orgprocess,

5855: AMW_OPINIONS_V opinion,
5856: AMW_OPINION_TYPES_B opiniontype,
5857: FND_OBJECTS fndobject,
5858: AMW_OBJECT_OPINION_TYPES objectopiniontype,
5859: amw_process_org_basicinfo_v orgprocess,
5860: amw_risk_associations riskassoc,
5861: amw_control_associations ctrlassoc
5862: WHERE
5863: (opinion.AUTHORED_DATE in

Line 5895: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

5891: in
5892: -- and ( opinion.pk4_value ) in
5893: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln
5894: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
5895: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
5896: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and
5897: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
5898: and AccProcs.natural_account_id in
5899: -- (select

Line 5942: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

5938:
5939: select COUNT(1) into P_TOTAL_NUMBER_OF_PROCESSES from (
5940: (select distinct procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln
5941: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
5942: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
5943: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and
5944: AccProcs.pk1= orgprocess2.PROCESS_ORGANIZATION_ID
5945: and AccProcs.natural_account_id in
5946: --(select distinct(acc.natural_account_id)

Line 6046: amw_process_org_basicinfo_v orgprocess

6042: AMW_OPINIONS_V opinion,
6043: AMW_OPINION_TYPES_B opiniontype,
6044: FND_OBJECTS fndobject,
6045: AMW_OBJECT_OPINION_TYPES objectopiniontype,
6046: amw_process_org_basicinfo_v orgprocess
6047: WHERE
6048: opinion.OBJECT_OPINION_TYPE_ID = objectopiniontype.OBJECT_OPINION_TYPE_ID AND
6049: opiniontype.OPINION_TYPE_ID = objectopiniontype.OPINION_TYPE_ID AND
6050: opiniontype.OPINION_TYPE_CODE = 'CERTIFICATION' AND

Line 6060: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

6056: and ( orgprocess.ORGANIZATION_ID , orgprocess.PROCESS_ID )
6057: in
6058: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln
6059: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
6060: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
6061: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and
6062: AccProcs.pk1= orgprocess2.PROCESS_ORGANIZATION_ID
6063: and AccProcs.natural_account_id in
6064:

Line 6168: amw_process_org_basicinfo_v orgprocess

6164: AMW_OPINIONS_V opinion,
6165: AMW_OPINION_TYPES_B opiniontype,
6166: FND_OBJECTS fndobject,
6167: AMW_OBJECT_OPINION_TYPES objectopiniontype,
6168: amw_process_org_basicinfo_v orgprocess
6169: WHERE
6170: (opinion.AUTHORED_DATE in
6171: (Select
6172: MAX(opinion2.AUTHORED_DATE)

Line 6196: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

6192: and ( orgprocess.ORGANIZATION_ID , orgprocess.PROCESS_ID )
6193: in
6194: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln
6195: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
6196: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
6197: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and
6198: AccProcs.pk1= orgprocess2.PROCESS_ORGANIZATION_ID
6199: and AccProcs.natural_account_id in
6200:

Line 6303: amw_process_org_basicinfo_v orgprocess

6299: AMW_OPINIONS_V opinion,
6300: AMW_OPINION_TYPES_B opiniontype,
6301: FND_OBJECTS fndobject,
6302: AMW_OBJECT_OPINION_TYPES objectopiniontype,
6303: amw_process_org_basicinfo_v orgprocess
6304: WHERE
6305: (opinion.AUTHORED_DATE in
6306: (Select
6307: MAX(opinion2.AUTHORED_DATE)

Line 6329: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

6325: and ( orgprocess.ORGANIZATION_ID , orgprocess.PROCESS_ID )
6326: in
6327: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln
6328: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
6329: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
6330: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and
6331: AccProcs.pk1= orgprocess2.PROCESS_ORGANIZATION_ID
6332: and AccProcs.natural_account_id in
6333:

Line 6435: amw_process_org_basicinfo_v orgprocess

6431: AMW_OPINIONS_V opinion,
6432: AMW_OPINION_TYPES_B opiniontype,
6433: FND_OBJECTS fndobject,
6434: AMW_OBJECT_OPINION_TYPES objectopiniontype,
6435: amw_process_org_basicinfo_v orgprocess
6436: WHERE
6437: (opinion.AUTHORED_DATE in
6438: (Select
6439: MAX(opinion2.AUTHORED_DATE)

Line 6463: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

6459: in
6460: -- ?
6461: (select procRln.ORGANIZATION_ID from Amw_Process_Org_Relations procRln
6462: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
6463: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
6464: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and
6465: AccProcs.pk1= orgprocess2.PROCESS_ORGANIZATION_ID
6466: and AccProcs.natural_account_id in
6467:

Line 6569: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

6565: into P_org_evaluated
6566: from (
6567: (select distinct procRln.ORGANIZATION_ID from Amw_Process_Org_Relations procRln
6568: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
6569: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
6570: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and
6571: AccProcs.pk1= orgprocess2.PROCESS_ORGANIZATION_ID
6572: and AccProcs.natural_account_id in
6573: --(select distinct(acc.natural_account_id)

Line 6664: amw_process_org_basicinfo_v orgprocess

6660: AMW_OPINIONS_V opinion,
6661: AMW_OPINION_TYPES_B opiniontype,
6662: FND_OBJECTS fndobject,
6663: AMW_OBJECT_OPINION_TYPES objectopiniontype,
6664: amw_process_org_basicinfo_v orgprocess
6665: WHERE
6666: (opinion.AUTHORED_DATE in
6667: (Select
6668: MAX(opinion2.AUTHORED_DATE)

Line 6689: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

6685: and orgprocess.ORGANIZATION_ID
6686: in
6687: (select procRln.ORGANIZATION_ID from Amw_Process_Org_Relations procRln
6688: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
6689: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
6690: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and
6691: AccProcs.pk1= orgprocess2.PROCESS_ORGANIZATION_ID
6692: and AccProcs.natural_account_id in
6693: --(select distinct(acc.natural_account_id)

Line 6794: amw_process_org_basicinfo_v orgprocess

6790: AMW_OPINIONS_V opinion,
6791: AMW_OPINION_TYPES_B opiniontype,
6792: FND_OBJECTS fndobject,
6793: AMW_OBJECT_OPINION_TYPES objectopiniontype,
6794: amw_process_org_basicinfo_v orgprocess
6795: WHERE
6796: (opinion.AUTHORED_DATE in
6797: (Select
6798: MAX(opinion2.AUTHORED_DATE)

Line 6819: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

6815: and orgprocess.ORGANIZATION_ID
6816: in
6817: (select procRln.ORGANIZATION_ID from Amw_Process_Org_Relations procRln
6818: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
6819: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
6820: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and
6821: AccProcs.pk1= orgprocess2.PROCESS_ORGANIZATION_ID
6822: and AccProcs.natural_account_id in
6823: --(select distinct(acc.natural_account_id)

Line 6922: amw_process_org_basicinfo_v orgprocess

6918: AMW_OPINIONS_V opinion,
6919: AMW_OPINION_TYPES_B opiniontype,
6920: FND_OBJECTS fndobject,
6921: AMW_OBJECT_OPINION_TYPES objectopiniontype,
6922: amw_process_org_basicinfo_v orgprocess
6923: WHERE
6924: (opinion.AUTHORED_DATE in
6925: (Select
6926: MAX(opinion2.AUTHORED_DATE)

Line 6951: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

6947: and ( orgprocess.ORGANIZATION_ID , orgprocess.PROCESS_ID )
6948: IN
6949: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln
6950: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
6951: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
6952: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and
6953: AccProcs.pk1= orgprocess2.PROCESS_ORGANIZATION_ID
6954: and AccProcs.natural_account_id in
6955: --(select distinct(acc.natural_account_id)

Line 7057: amw_process_org_basicinfo_v orgprocess,

7053: AMW_OPINIONS_V opinion,
7054: AMW_OPINION_TYPES_B opiniontype,
7055: FND_OBJECTS fndobject,
7056: AMW_OBJECT_OPINION_TYPES objectopiniontype,
7057: amw_process_org_basicinfo_v orgprocess,
7058: amw_risk_associations riskassoc,
7059: amw_control_associations ctrlassoc
7060: WHERE
7061: (opinion.AUTHORED_DATE in

Line 7099: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

7095: ( orgprocess.ORGANIZATION_ID , orgprocess.PROCESS_ID )
7096: in
7097: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln
7098: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
7099: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
7100: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and
7101: AccProcs.pk1= orgprocess2.PROCESS_ORGANIZATION_ID
7102: and AccProcs.natural_account_id in
7103: --(select distinct(acc.natural_account_id)

Line 7203: amw_process_org_basicinfo_v orgprocess,

7199: AMW_OPINIONS_V opinion,
7200: AMW_OPINION_TYPES_B opiniontype,
7201: FND_OBJECTS fndobject,
7202: AMW_OBJECT_OPINION_TYPES objectopiniontype,
7203: amw_process_org_basicinfo_v orgprocess,
7204: amw_risk_associations riskassoc
7205: WHERE
7206: (opinion.AUTHORED_DATE in
7207: (Select

Line 7241: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

7237: ( orgprocess.ORGANIZATION_ID , orgprocess.PROCESS_ID )
7238: in
7239: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln
7240: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
7241: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
7242: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and
7243: AccProcs.pk1= orgprocess2.PROCESS_ORGANIZATION_ID
7244: and AccProcs.natural_account_id in
7245:

Line 7343: amw_process_org_basicinfo_v orgprocess,

7339: into p_risks_verified
7340: from (
7341: select distinct riskassoc.risk_id ,orgprocess.organization_id, orgprocess.Process_ID
7342: FROM
7343: amw_process_org_basicinfo_v orgprocess,
7344: amw_risk_associations riskassoc
7345: WHERE
7346: orgprocess.process_organization_id = riskassoc.pk1
7347: and riskassoc.object_type = 'PROCESS_ORG'

Line 7352: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

7348: and (orgprocess.ORGANIZATION_ID , orgprocess.PROCESS_ID )
7349: in
7350: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln
7351: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
7352: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
7353: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and
7354: AccProcs.pk1= orgprocess2.PROCESS_ORGANIZATION_ID
7355: and AccProcs.natural_account_id in
7356: --(select distinct(acc.natural_account_id)

Line 7443: amw_process_org_basicinfo_v orgprocess,

7439: AMW_OPINIONS_V opinion,
7440: AMW_OPINION_TYPES_B opiniontype,
7441: FND_OBJECTS fndobject,
7442: AMW_OBJECT_OPINION_TYPES objectopiniontype,
7443: amw_process_org_basicinfo_v orgprocess,
7444: amw_risk_associations riskassoc
7445: WHERE
7446: (opinion.AUTHORED_DATE in
7447: (Select

Line 7478: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

7474: ( orgprocess.ORGANIZATION_ID , orgprocess.PROCESS_ID )
7475: in
7476: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln
7477: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
7478: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
7479: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and
7480: AccProcs.pk1= orgprocess2.PROCESS_ORGANIZATION_ID
7481: and AccProcs.natural_account_id in
7482:

Line 7583: amw_process_org_basicinfo_v orgprocess,

7579: into p_controls_verified
7580: from (
7581: select distinct ctrlassoc.control_id, orgprocess.organization_id
7582: FROM
7583: amw_process_org_basicinfo_v orgprocess,
7584: amw_risk_associations riskassoc,
7585: amw_control_associations ctrlassoc
7586: WHERE
7587: orgprocess.process_organization_id = riskassoc.pk1

Line 7596: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

7592: ( orgprocess.ORGANIZATION_ID , orgprocess.PROCESS_ID )
7593: in
7594: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln
7595: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
7596: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
7597: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and
7598: AccProcs.pk1= orgprocess2.PROCESS_ORGANIZATION_ID
7599: and AccProcs.natural_account_id in
7600: --(select distinct(acc.natural_account_id)

Line 7689: amw_process_org_basicinfo_v orgprocess,

7685: AMW_OPINIONS_V opinion,
7686: AMW_OPINION_TYPES_B opiniontype,
7687: FND_OBJECTS fndobject,
7688: AMW_OBJECT_OPINION_TYPES objectopiniontype,
7689: amw_process_org_basicinfo_v orgprocess,
7690: amw_risk_associations riskassoc,
7691: amw_control_associations ctrlassoc
7692: WHERE
7693: (opinion.AUTHORED_DATE in

Line 7726: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

7722: ( orgprocess.ORGANIZATION_ID , orgprocess.PROCESS_ID )
7723: in
7724: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln
7725: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
7726: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
7727: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and
7728: AccProcs.pk1= orgprocess2.PROCESS_ORGANIZATION_ID
7729: and AccProcs.natural_account_id in
7730: --(select distinct(acc.natural_account_id)

Line 7827: amw_process_org_basicinfo_v orgprocess

7823: AMW_OPINIONS_V opinion,
7824: AMW_OPINION_TYPES_B opiniontype,
7825: FND_OBJECTS fndobject,
7826: AMW_OBJECT_OPINION_TYPES objectopiniontype,
7827: amw_process_org_basicinfo_v orgprocess
7828: WHERE
7829: (opinion.AUTHORED_DATE in
7830: (Select
7831: MAX(opinion2.AUTHORED_DATE)

Line 7853: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,

7849: and orgprocess.ORGANIZATION_ID
7850: in
7851: (select procRln.ORGANIZATION_ID from Amw_Process_Org_Relations procRln
7852: START WITH ((procRln.CHILD_PROCESS_ID , procRln.ORGANIZATION_ID) in
7853: ( select orgprocess2.PROCESS_ID , orgprocess2.ORGANIZATION_ID from amw_process_org_basicinfo_v orgprocess2,
7854: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and
7855: AccProcs.pk1= orgprocess2.PROCESS_ORGANIZATION_ID
7856: and AccProcs.natural_account_id in
7857: --(select distinct(acc.natural_account_id)