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_ORG_HIERARCHY_DENORM

Line 578: from Amw_Org_Hierarchy_Denorm

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
579: union
580: select process_id, organization_id, process_id child_process_id, 'D' up_down_ind
581: from amw_process_organization) hier
582: where acct_assoc.natural_account_id in

Line 644: from Amw_Org_Hierarchy_Denorm

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
646: select process_id, organization_id, process_id child_process_id, 'D' up_down_ind
647: from amw_process_organization) hier
648: WHERE acct_assoc.natural_account_id in

Line 716: from Amw_Org_Hierarchy_Denorm

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
719: from amw_process_organization) hier
720: WHERE acct_assoc.natural_account_id in

Line 780: from Amw_Org_Hierarchy_Denorm

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
782: select process_id, organization_id, process_id child_process_id, 'D' up_down_ind
783: from amw_process_organization) hier
784: WHERE acct_assoc.natural_account_id in

Line 840: from Amw_Org_Hierarchy_Denorm

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
843: from amw_process_organization) hier
844: WHERE acct_assoc.natural_account_id in

Line 901: from Amw_Org_Hierarchy_Denorm

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
903: select process_id, organization_id, process_id child_process_id, 'D' up_down_ind
904: from amw_process_organization) hier
905: WHERE acct_assoc.natural_account_id in

Line 960: from Amw_Org_Hierarchy_Denorm

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
962: select process_id, organization_id, process_id child_process_id, 'D' up_down_ind
963: from amw_process_organization) hier
964: WHERE acct_assoc.natural_account_id in

Line 1024: from Amw_Org_Hierarchy_Denorm

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
1026: select process_id, organization_id, process_id child_process_id, 'D' up_down_ind
1027: from amw_process_organization) hier
1028: WHERE acct_assoc.natural_account_id in

Line 1092: from Amw_Org_Hierarchy_Denorm

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
1092: from Amw_Org_Hierarchy_Denorm
1093: union
1094: select process_id, organization_id, process_id child_process_id, 'D' up_down_ind
1095: from amw_process_organization) hier
1096: WHERE acct_assoc.natural_account_id in

Line 1165: from Amw_Org_Hierarchy_Denorm

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
1165: from Amw_Org_Hierarchy_Denorm
1166: union
1167: select process_id, organization_id, process_id child_process_id, 'D' up_down_ind
1168: from amw_process_organization) hier
1169: WHERE acct_assoc.natural_account_id in

Line 1236: from Amw_Org_Hierarchy_Denorm

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
1238: select process_id, organization_id, process_id child_process_id, 'D' up_down_ind
1239: from amw_process_organization) hier
1240: WHERE acct_assoc.natural_account_id in

Line 2299: from Amw_Org_Hierarchy_Denorm hier

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'
2301: from amw_process_organization) hier
2302: WHERE aa.object_type = 'PROCESS_ORG'
2303: AND po.process_organization_id = aa.pk1

Line 2350: from Amw_Org_Hierarchy_Denorm hier

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'
2352: from amw_process_organization) hier,
2353: AMW_OPINIONS_V aov
2354: WHERE aa.object_type = 'PROCESS_ORG'

Line 2418: from Amw_Org_Hierarchy_Denorm hier

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'
2420: from amw_process_organization) hier,
2421: AMW_OPINIONS_V aov
2422: WHERE aa.object_type = 'PROCESS_ORG'

Line 2485: from Amw_Org_Hierarchy_Denorm hier

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'
2487: from amw_process_organization) hier,
2488: AMW_OPINIONS_V aov
2489: WHERE aa.object_type = 'PROCESS_ORG'

Line 2547: from Amw_Org_Hierarchy_Denorm hier

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'
2549: from amw_process_organization) hier,
2550: AMW_PROCESS_ORGANIZATION po2,
2551: AMW_RISK_ASSOCIATIONS ara,

Line 2616: from Amw_Org_Hierarchy_Denorm hier

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'
2618: from amw_process_organization) hier,
2619: AMW_PROCESS_ORGANIZATION po2,
2620: AMW_RISK_ASSOCIATIONS ara

Line 2672: from Amw_Org_Hierarchy_Denorm hier

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'
2674: from amw_process_organization) hier,
2675: AMW_PROCESS_ORGANIZATION po2,
2676: AMW_RISK_ASSOCIATIONS ara,

Line 2743: from Amw_Org_Hierarchy_Denorm hier

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'
2745: from amw_process_organization) hier,
2746: AMW_PROCESS_ORGANIZATION po2,
2747: AMW_RISK_ASSOCIATIONS ara,