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

Line 455: AMW_ACCT_ASSOCIATIONS acct_assoc, AMW_PROCESS_ORGANIZATION process_org

451: cursor proc is
452:
453: select process_id, organization_id
454: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc,
455: AMW_ACCT_ASSOCIATIONS acct_assoc, AMW_PROCESS_ORGANIZATION process_org
456: where cert.certification_id = p_certification_id and cert.object_type = 'FIN_STMT'
457: and cert.statement_group_id = key_acc.statement_group_id and
458: cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID and
459: acct_assoc.natural_account_id = key_acc.natural_account_id and

Line 574: from AMW_ACCT_ASSOCIATIONS acct_assoc,

570: WHERE creation_date >= p_start_date
571: AND object_type = 'PROCESS_ORG'
572: AND pk1 in (
573: select distinct p_org.process_organization_id
574: from AMW_ACCT_ASSOCIATIONS acct_assoc,
575: AMW_PROCESS_ORGANIZATION process_org,
576: AMW_PROCESS_ORGANIZATION p_org,
577: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
578: from Amw_Org_Hierarchy_Denorm

Line 641: AMW_ACCT_ASSOCIATIONS acct_assoc,

637: SELECT distinct aca.control_id, p_org.organization_id
638: FROM AMW_CONTROL_ASSOCIATIONS aca,
639: AMW_RISK_ASSOCIATIONS ara,
640: AMW_PROCESS_ORGANIZATION apo,
641: AMW_ACCT_ASSOCIATIONS acct_assoc,
642: AMW_PROCESS_ORGANIZATION p_org,
643: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
644: from Amw_Org_Hierarchy_Denorm
645: union

Line 714: AMW_ACCT_ASSOCIATIONS acct_assoc,

710: SELECT count(1)
711: FROM (
712: SELECT distinct hier.organization_id, hier.child_process_id
713: FROM AMW_PROCESS_ORGANIZATION apo,
714: AMW_ACCT_ASSOCIATIONS acct_assoc,
715: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
716: from Amw_Org_Hierarchy_Denorm
717: union
718: select process_id, organization_id, process_id child_process_id, 'D' up_down_ind

Line 777: AMW_ACCT_ASSOCIATIONS acct_assoc,

773: SELECT count(1)
774: FROM (
775: SELECT distinct hier.organization_id, hier.child_process_id
776: FROM AMW_PROCESS_ORGANIZATION apo,
777: AMW_ACCT_ASSOCIATIONS acct_assoc,
778: AMW_OPINIONS_V aov,
779: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
780: from Amw_Org_Hierarchy_Denorm
781: union

Line 838: AMW_ACCT_ASSOCIATIONS acct_assoc,

834: CURSOR local_proc_not_certified IS
835: SELECT count(1)
836: FROM (SELECT distinct hier.organization_id, hier.child_process_id
837: FROM AMW_PROCESS_ORGANIZATION apo,
838: AMW_ACCT_ASSOCIATIONS acct_assoc,
839: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
840: from Amw_Org_Hierarchy_Denorm
841: union
842: select process_id, organization_id, process_id child_process_id, 'D' up_down_ind

Line 898: AMW_ACCT_ASSOCIATIONS acct_assoc,

894: CURSOR local_proc_with_issue IS
895: SELECT count(1)
896: FROM (SELECT distinct hier.organization_id, hier.child_process_id
897: FROM AMW_PROCESS_ORGANIZATION apo,
898: AMW_ACCT_ASSOCIATIONS acct_assoc,
899: AMW_OPINIONS_V aov,
900: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
901: from Amw_Org_Hierarchy_Denorm
902: union

Line 957: AMW_ACCT_ASSOCIATIONS acct_assoc,

953:
954: CURSOR global_proc_with_ineff_ctrl IS
955: SELECT count(distinct hier.child_process_id)
956: FROM AMW_PROCESS_ORGANIZATION apo,
957: AMW_ACCT_ASSOCIATIONS acct_assoc,
958: AMW_OPINIONS_V aov,
959: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
960: from Amw_Org_Hierarchy_Denorm
961: union

Line 1021: AMW_ACCT_ASSOCIATIONS acct_assoc,

1017: CURSOR local_proc_with_ineff_ctrl IS
1018: SELECT count(1)
1019: FROM (SELECT distinct hier.organization_id, hier.child_process_id
1020: FROM AMW_PROCESS_ORGANIZATION apo,
1021: AMW_ACCT_ASSOCIATIONS acct_assoc,
1022: AMW_OPINIONS_V aov,
1023: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
1024: from Amw_Org_Hierarchy_Denorm
1025: union

Line 1087: AMW_ACCT_ASSOCIATIONS acct_assoc,

1083: CURSOR unmitigated_risks IS
1084: SELECT count(1)
1085: FROM (SELECT distinct p_org.organization_id, p_org.process_id, ara.risk_id
1086: FROM AMW_PROCESS_ORGANIZATION apo,
1087: AMW_ACCT_ASSOCIATIONS acct_assoc,
1088: AMW_RISK_ASSOCIATIONS ara,
1089: AMW_OPINIONS_V aov,
1090: AMW_PROCESS_ORGANIZATION p_org,
1091: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind

Line 1160: AMW_ACCT_ASSOCIATIONS acct_assoc,

1156: CURSOR ineffective_controls IS
1157: SELECT count(1)
1158: FROM (SELECT distinct p_org.organization_id, aca.control_id
1159: FROM AMW_PROCESS_ORGANIZATION apo,
1160: AMW_ACCT_ASSOCIATIONS acct_assoc,
1161: AMW_RISK_ASSOCIATIONS ara, AMW_CONTROL_ASSOCIATIONS aca,
1162: AMW_OPINIONS_V aov,
1163: AMW_PROCESS_ORGANIZATION p_org,
1164: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind

Line 1233: AMW_ACCT_ASSOCIATIONS acct_assoc,

1229:
1230: CURSOR orgs_pending_in_scope IS
1231: SELECT count(distinct p_org.organization_id)
1232: FROM AMW_PROCESS_ORGANIZATION apo,
1233: AMW_ACCT_ASSOCIATIONS acct_assoc,
1234: AMW_PROCESS_ORGANIZATION p_org,
1235: (select process_id, organization_id, parent_child_id child_process_id, up_down_ind
1236: from Amw_Org_Hierarchy_Denorm
1237: union

Line 1295: AMW_ACCT_ASSOCIATIONS acct_assoc

1291:
1292: CURSOR orgs_in_scope IS
1293: SELECT count(distinct apo.organization_id)
1294: FROM AMW_PROCESS_ORGANIZATION apo,
1295: AMW_ACCT_ASSOCIATIONS acct_assoc
1296: WHERE acct_assoc.natural_account_id in
1297:
1298: -- (select natural_account_id
1299: -- from amw_fin_key_accounts_b

Line 1588: FROM AMW_ACCT_ASSOCIATIONS aa,

1584:
1585:
1586: CURSOR total_org_processes IS
1587: SELECT count(distinct po.organization_id)
1588: FROM AMW_ACCT_ASSOCIATIONS aa,
1589: AMW_FIN_ITEMS_KEY_ACC fika,
1590: AMW_PROCESS_ORGANIZATION po,
1591: AMW_CERTIFICATION_B cert
1592: WHERE aa.object_type = 'PROCESS_ORG'

Line 1989: FROM AMW_ACCT_ASSOCIATIONS aa,

1985:
1986: -- select all the processes based on the certification_id
1987: CURSOR c_process(p_cert_id NUMBER) IS
1988: SELECT distinct aa.pk1 process_organization_id,po.process_id,po.organization_id
1989: FROM AMW_ACCT_ASSOCIATIONS aa,
1990: AMW_FIN_ITEMS_KEY_ACC fika,
1991: AMW_PROCESS_ORGANIZATION po,
1992: AMW_CERTIFICATION_B cert
1993: WHERE aa.object_type = 'PROCESS_ORG'

Line 2248: FROM AMW_ACCT_ASSOCIATIONS aa,

2244:
2245: /*
2246: CURSOR proc_pending_cert IS
2247: SELECT count(distinct apo.process_id)
2248: FROM AMW_ACCT_ASSOCIATIONS aa,
2249: AMW_FIN_ITEMS_KEY_ACC fika,
2250: AMW_CERTIFICATION_B cert,
2251: AMW_PROCESS_ORGANIZATION apo,
2252: AMW_PROCESS_ORGANIZATION apo2

Line 2296: FROM AMW_ACCT_ASSOCIATIONS aa,

2292: AND aov.authored_date <= p_end_date);
2293: */
2294: CURSOR total_num_of_proc IS
2295: SELECT count(distinct hier.parent_child_id)
2296: FROM AMW_ACCT_ASSOCIATIONS aa,
2297: AMW_PROCESS_ORGANIZATION po,
2298: (select process_id, organization_id, parent_child_id, up_down_ind
2299: from Amw_Org_Hierarchy_Denorm hier
2300: union select process_id, organization_id, process_id, 'D'

Line 2347: FROM AMW_ACCT_ASSOCIATIONS aa,

2343:
2344:
2345: CURSOR proc_with_issue IS
2346: SELECT count(distinct hier.parent_child_id)
2347: FROM AMW_ACCT_ASSOCIATIONS aa,
2348: AMW_PROCESS_ORGANIZATION po,
2349: (select process_id, organization_id, parent_child_id, up_down_ind
2350: from Amw_Org_Hierarchy_Denorm hier
2351: union select process_id, organization_id, process_id, 'D'

Line 2415: FROM AMW_ACCT_ASSOCIATIONS aa,

2411:
2412:
2413: CURSOR proc_without_issue IS
2414: SELECT count(distinct hier.parent_child_id)
2415: FROM AMW_ACCT_ASSOCIATIONS aa,
2416: AMW_PROCESS_ORGANIZATION po,
2417: (select process_id, organization_id, parent_child_id, up_down_ind
2418: from Amw_Org_Hierarchy_Denorm hier
2419: union select process_id, organization_id, process_id, 'D'

Line 2482: FROM AMW_ACCT_ASSOCIATIONS aa,

2478: AND aov.audit_result_code = 'EFFECTIVE';
2479:
2480: CURSOR proc_with_ineff_ctrl IS
2481: SELECT count(distinct hier.parent_child_id)
2482: FROM AMW_ACCT_ASSOCIATIONS aa,
2483: AMW_PROCESS_ORGANIZATION po,
2484: (select process_id, organization_id, parent_child_id, up_down_ind
2485: from Amw_Org_Hierarchy_Denorm hier
2486: union select process_id, organization_id, process_id, 'D'

Line 2544: FROM AMW_ACCT_ASSOCIATIONS aa,

2540: AND aov.audit_result_code <> 'EFFECTIVE';
2541:
2542: CURSOR unmitigated_risks IS
2543: SELECT count(distinct ara.risk_association_id)
2544: FROM AMW_ACCT_ASSOCIATIONS aa,
2545: AMW_PROCESS_ORGANIZATION po,
2546: (select process_id, organization_id, parent_child_id, up_down_ind
2547: from Amw_Org_Hierarchy_Denorm hier
2548: union select process_id, organization_id, process_id, 'D'

Line 2613: FROM AMW_ACCT_ASSOCIATIONS aa,

2609: AND aov.audit_result_code <> 'EFFECTIVE';
2610:
2611: CURSOR total_risks IS
2612: SELECT count(distinct ara.risk_association_id)
2613: FROM AMW_ACCT_ASSOCIATIONS aa,
2614: AMW_PROCESS_ORGANIZATION po,
2615: (select process_id, organization_id, parent_child_id, up_down_ind
2616: from Amw_Org_Hierarchy_Denorm hier
2617: union select process_id, organization_id, process_id, 'D'

Line 2669: FROM AMW_ACCT_ASSOCIATIONS aa,

2665:
2666:
2667: CURSOR ineffective_controls IS
2668: SELECT count(distinct aca.control_id)
2669: FROM AMW_ACCT_ASSOCIATIONS aa,
2670: AMW_PROCESS_ORGANIZATION po,
2671: (select process_id, organization_id, parent_child_id, up_down_ind
2672: from Amw_Org_Hierarchy_Denorm hier
2673: union select process_id, organization_id, process_id, 'D'

Line 2740: FROM AMW_ACCT_ASSOCIATIONS aa,

2736:
2737:
2738: CURSOR total_controls IS
2739: SELECT count(distinct aca.control_id)
2740: FROM AMW_ACCT_ASSOCIATIONS aa,
2741: AMW_PROCESS_ORGANIZATION po,
2742: (select process_id, organization_id, parent_child_id, up_down_ind
2743: from Amw_Org_Hierarchy_Denorm hier
2744: union select process_id, organization_id, process_id, 'D'

Line 3028: FROM AMW_ACCT_ASSOCIATIONS aa,

3024:
3025: -- select all the processes based on the certification_id
3026: CURSOR c_org(p_cert_id NUMBER) IS
3027: SELECT distinct po.organization_id
3028: FROM AMW_ACCT_ASSOCIATIONS aa,
3029: AMW_FIN_ITEMS_KEY_ACC fika,
3030: AMW_PROCESS_ORGANIZATION po,
3031: AMW_CERTIFICATION_B cert
3032: WHERE aa.object_type = 'PROCESS_ORG'

Line 3073: FROM AMW_ACCT_ASSOCIATIONS aa,

3069: DELETE from AMW_FIN_ORG_EVAL_SUM orgevalsum
3070: where FIN_CERTIFICATION_ID = p_certification_id
3071: and not exists
3072: (SELECT 'Y'
3073: FROM AMW_ACCT_ASSOCIATIONS aa,
3074: AMW_FIN_ITEMS_KEY_ACC fika,
3075: AMW_PROCESS_ORGANIZATION po,
3076: AMW_CERTIFICATION_B cert
3077: WHERE aa.object_type = 'PROCESS_ORG'

Line 3111: FROM AMW_ACCT_ASSOCIATIONS aa,

3107: ELSE
3108: DELETE from AMW_FIN_ORG_EVAL_SUM orgevalsum
3109: where not exists
3110: (SELECT 'Y'
3111: FROM AMW_ACCT_ASSOCIATIONS aa,
3112: AMW_FIN_ITEMS_KEY_ACC fika,
3113: AMW_PROCESS_ORGANIZATION po,
3114: AMW_CERTIFICATION_B cert
3115: WHERE aa.object_type = 'PROCESS_ORG'

Line 4765: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and

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
4769: -- distinct(acc.natural_account_id)

Line 4834: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and

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
4838: -- distinct(acc.natural_account_id)

Line 4917: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and

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
4921: -- distinct(acc.natural_account_id)

Line 4998: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and

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
5002: -- distinct(acc.natural_account_id)

Line 5075: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and

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
5079: -- distinct(acc.natural_account_id)

Line 5154: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and

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
5158: -- distinct(acc.natural_account_id)

Line 5202: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and

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
5206: -- distinct(acc.natural_account_id)

Line 5270: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and

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
5274: -- distinct(acc.natural_account_id)

Line 5356: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and

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
5360: -- distinct(acc.natural_account_id)

Line 5436: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and

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
5440: -- distinct(acc.natural_account_id)

Line 5528: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and

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
5532: -- distinct(acc.natural_account_id)

Line 5617: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and

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
5621: -- distinct(acc.natural_account_id)

Line 5674: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and

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
5678: -- distinct(acc.natural_account_id)

Line 5752: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and

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
5756: -- distinct(acc.natural_account_id)

Line 5816: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and

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
5820: -- distinct(acc.natural_account_id)

Line 5896: Amw_acct_associations AccProcs where AccProcs .object_type = 'PROCESS_ORG' and

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
5900: -- distinct(acc.natural_account_id)

Line 5943: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and

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)
5947: -- from AMW_FIN_KEY_ACCOUNTS_B acc

Line 6061: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and

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:
6065: --(select distinct(acc.natural_account_id)

Line 6197: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and

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:
6201: --(select distinct(acc.natural_account_id)

Line 6330: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and

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:
6334: --(select distinct(acc.natural_account_id)

Line 6464: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and

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:
6468: --(select distinct(acc.natural_account_id)

Line 6570: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and

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)
6574: -- from AMW_FIN_KEY_ACCOUNTS_B acc

Line 6690: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and

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)
6694: -- from AMW_FIN_KEY_ACCOUNTS_B acc

Line 6820: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and

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)
6824: -- from AMW_FIN_KEY_ACCOUNTS_B acc

Line 6952: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and

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)
6956: -- from AMW_FIN_KEY_ACCOUNTS_B acc

Line 7100: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and

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)
7104: -- from AMW_FIN_KEY_ACCOUNTS_B acc

Line 7242: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and

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:
7246: --(select distinct(acc.natural_account_id)

Line 7353: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and

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)
7357: -- from AMW_FIN_KEY_ACCOUNTS_B acc

Line 7479: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and

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:
7483: --(select distinct(acc.natural_account_id)

Line 7597: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and

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)
7601: -- from AMW_FIN_KEY_ACCOUNTS_B acc

Line 7727: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and

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)
7731: -- from AMW_FIN_KEY_ACCOUNTS_B acc

Line 7854: Amw_acct_associations AccProcs where AccProcs.object_type = 'PROCESS_ORG' and

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)
7858: -- from AMW_FIN_KEY_ACCOUNTS_B acc