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_RELATIONS

Line 43: from Amw_Process_Org_Relations

39: PROCEDURE Update_Next_Level_Proc_Info(p_process_id IN NUMBER, p_org_id IN NUMBER, p_certification_id IN NUMBER) is
40:
41: cursor c2 (l_process_id number,l_org_id number) is
42: select CHILD_PROCESS_ID
43: from Amw_Process_Org_Relations
44: where PARENT_PROCESS_ID=l_process_id and ORGANIZATION_ID = l_org_id;
45:
46: c2_rec c2%rowtype;
47:

Line 1558: from AMW_PROCESS_ORG_RELATIONS orgrel

1554: -- AND aov.authored_date <= p_end_date
1555: AND aov.pk2_value in (select proc_cert_Id from AMW_FIN_PROC_CERT_RELAN
1556: where fin_stmt_cert_id = p_certification_id)
1557: AND aov.pk1_value in (select distinct(orgrel.child_process_id)
1558: from AMW_PROCESS_ORG_RELATIONS orgrel
1559: START WITH orgrel.parent_process_id = p_process_id
1560: and orgrel.organization_id = p_organization_id
1561: CONNECT BY PRIOR orgrel.child_process_id = orgrel.parent_process_id
1562: and PRIOR orgrel.organization_id = orgrel.organization_id);

Line 1566: FROM AMW_PROCESS_ORG_RELATIONS

1562: and PRIOR orgrel.organization_id = orgrel.organization_id);
1563:
1564: CURSOR total_sub_processes IS
1565: SELECT count(distinct child_process_id)
1566: FROM AMW_PROCESS_ORG_RELATIONS
1567: START WITH parent_process_id = p_process_id
1568: AND organization_id = p_organization_id
1569: CONNECT BY PRIOR child_process_id = parent_process_id
1570: AND PRIOR organization_id = organization_id;

Line 1660: from AMW_PROCESS_ORG_RELATIONS orgrel

1656: AMW_RISK_ASSOCIATIONS ara,
1657: AMW_OPINIONS_V aov
1658: WHERE apo.organization_id = p_organization_id
1659: AND apo.process_id in ( select distinct(orgrel.child_process_id)
1660: from AMW_PROCESS_ORG_RELATIONS orgrel
1661: START WITH orgrel.child_process_id = p_process_id
1662: and orgrel.organization_id = apo.organization_id
1663: CONNECT BY PRIOR orgrel.child_process_id = orgrel.parent_process_id
1664: and PRIOR orgrel.organization_id = orgrel.organization_id )

Line 1693: from AMW_PROCESS_ORG_RELATIONS orgrel

1689: AMW_CONTROL_ASSOCIATIONS aca,
1690: AMW_OPINIONS_V aov
1691: WHERE apo.organization_id = p_organization_id
1692: AND apo.process_id in ( select distinct(orgrel.child_process_id)
1693: from AMW_PROCESS_ORG_RELATIONS orgrel
1694: START WITH orgrel.child_process_id = p_process_id
1695: and orgrel.organization_id = apo.organization_id
1696: CONNECT BY PRIOR orgrel.child_process_id = orgrel.parent_process_id
1697: and PRIOR orgrel.organization_id = orgrel.organization_id )

Line 2022: FROM AMW_PROCESS_ORG_RELATIONS

2018:
2019: --Select all the child processes .
2020: CURSOR c_child_processes(p_proc_id NUMBER, p_org_id NUMBER) IS
2021: SELECT distinct child_process_id
2022: FROM AMW_PROCESS_ORG_RELATIONS
2023: START WITH parent_process_id = p_proc_id
2024: AND organization_id = p_org_id
2025: CONNECT BY PRIOR child_process_id = parent_process_id
2026: AND PRIOR organization_id = organization_id;

Line 2257: from Amw_Process_Org_Relations

2253: WHERE aa.object_type = 'PROCESS_ORG'
2254: AND apo2.process_organization_id = aa.pk1
2255: AND (apo.process_id, apo.organization_id) in
2256: (select child_process_id, organization_id
2257: from Amw_Process_Org_Relations
2258: start with child_process_id = apo2.process_id
2259: and organization_id = apo2.organization_Id
2260: CONNECT BY PRIOR child_process_id = parent_process_id
2261: and PRIOR organization_id = organization_id)

Line 4762: (select distinct procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln

4758: begin
4759:
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

Line 4831: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln

4827: and (opinion.PK3_VALUE = orgprocess.ORGANIZATION_ID
4828: and opinion.PK1_VALUE = orgprocess.PROCESS_ID)
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

Line 4914: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln

4910: and (opinion.PK3_VALUE = orgprocess.ORGANIZATION_ID
4911: and opinion.PK1_VALUE = orgprocess.PROCESS_ID)
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

Line 4995: (select procRln.ORGANIZATION_ID from Amw_Process_Org_Relations procRln

4991: )
4992: and opinion.PK1_VALUE = orgprocess.ORGANIZATION_ID
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

Line 5072: (select procRln.ORGANIZATION_ID from Amw_Process_Org_Relations procRln

5068: )
5069: and opinion.PK1_VALUE = orgprocess.ORGANIZATION_ID
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

Line 5151: (select procRln.ORGANIZATION_ID from Amw_Process_Org_Relations procRln

5147: )
5148: and opinion.PK1_VALUE = orgprocess.ORGANIZATION_ID
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

Line 5199: (select distinct procRln.ORGANIZATION_ID from Amw_Process_Org_Relations procRln

5195: Select
5196: Count(1)
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

Line 5267: (select procRln.ORGANIZATION_ID from Amw_Process_Org_Relations procRln

5263: )
5264: and opinion.PK1_VALUE = orgprocess.ORGANIZATION_ID
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

Line 5353: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln

5349: and (opinion.PK3_VALUE = orgprocess.ORGANIZATION_ID
5350: and opinion.PK1_VALUE = orgprocess.PROCESS_ID)
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

Line 5433: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln

5429: and (opinion.PK3_VALUE = orgprocess.ORGANIZATION_ID
5430: and opinion.PK1_VALUE = orgprocess.PROCESS_ID)
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

Line 5525: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln

5521: --and opinion.pk4_value = orgprocess.PROCESS_ID and
5522: and ( orgprocess.ORGANIZATION_ID , orgprocess.PROCESS_ID )
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

Line 5614: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln

5610: and (opinion.pk3_value = orgprocess.ORGANIZATION_ID and opinion.pk4_value = orgprocess.PROCESS_ID ) and
5611: ( orgprocess.ORGANIZATION_ID , orgprocess.PROCESS_ID )
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

Line 5671: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln

5667: orgprocess.process_organization_id = riskassoc.pk1
5668: and riskassoc.object_type = 'PROCESS_ORG' AND
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

Line 5749: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln

5745: and (opinion.pk3_value = orgprocess.ORGANIZATION_ID and opinion.pk4_value = orgprocess.PROCESS_ID ) and
5746: ( orgprocess.ORGANIZATION_ID , orgprocess.PROCESS_ID )
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

Line 5813: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln

5809: and riskassoc.risk_association_id = ctrlassoc.pk1
5810: and ctrlassoc.object_type = 'RISK_ORG'
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

Line 5893: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln

5889: --and opinion.pk4_value = orgprocess.PROCESS_ID and
5890: and ( orgprocess.ORGANIZATION_ID , orgprocess.PROCESS_ID )
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

Line 5940: (select distinct procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln

5936:
5937: is begin
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

Line 6058: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln

6054: and (opinion.PK3_VALUE = orgprocess.ORGANIZATION_ID
6055: and opinion.PK1_VALUE = orgprocess.PROCESS_ID)
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

Line 6194: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln

6190: and (opinion.PK3_VALUE = orgprocess.ORGANIZATION_ID
6191: and opinion.PK1_VALUE = orgprocess.PROCESS_ID)
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

Line 6327: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln

6323: and (opinion.PK3_VALUE = orgprocess.ORGANIZATION_ID
6324: and opinion.PK1_VALUE = orgprocess.PROCESS_ID)
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

Line 6461: (select procRln.ORGANIZATION_ID from Amw_Process_Org_Relations procRln

6457: and opinion.PK1_VALUE = orgprocess.ORGANIZATION_ID
6458: and orgprocess.ORGANIZATION_ID
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

Line 6567: (select distinct procRln.ORGANIZATION_ID from Amw_Process_Org_Relations procRln

6563:
6564: select COUNT(1)
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

Line 6687: (select procRln.ORGANIZATION_ID from Amw_Process_Org_Relations procRln

6683: )
6684: and opinion.PK1_VALUE = orgprocess.ORGANIZATION_ID
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

Line 6817: (select procRln.ORGANIZATION_ID from Amw_Process_Org_Relations procRln

6813: )
6814: and opinion.PK1_VALUE = orgprocess.ORGANIZATION_ID
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

Line 6949: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln

6945: and (opinion.PK3_VALUE = orgprocess.ORGANIZATION_ID
6946: and opinion.PK1_VALUE = orgprocess.PROCESS_ID)
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

Line 7097: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln

7093: --and opinion.pk4_value = orgprocess.PROCESS_ID )
7094: and
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

Line 7239: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln

7235: -- and (opinion.pk3_value , opinion.pk4_value )
7236: and (opinion.pk3_value = orgprocess.ORGANIZATION_ID and opinion.pk4_value = orgprocess.PROCESS_ID ) and
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

Line 7350: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln

7346: orgprocess.process_organization_id = riskassoc.pk1
7347: and riskassoc.object_type = 'PROCESS_ORG'
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

Line 7476: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln

7472: -- and (opinion.pk3_value , opinion.pk4_value )
7473: and (opinion.pk3_value = orgprocess.ORGANIZATION_ID and opinion.pk4_value = orgprocess.PROCESS_ID ) and
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

Line 7594: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln

7590: and ctrlassoc.object_type = 'RISK_ORG'
7591: and
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

Line 7724: (select procRln.ORGANIZATION_ID ,procRln.CHILD_PROCESS_ID from Amw_Process_Org_Relations procRln

7720: --and opinion.pk4_value = orgprocess.PROCESS_ID )
7721: and
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

Line 7851: (select procRln.ORGANIZATION_ID from Amw_Process_Org_Relations procRln

7847: )
7848: and opinion.PK1_VALUE = orgprocess.ORGANIZATION_ID
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