APPS.AMW_FINSTMT_CERT_PVT dependencies on AMW_FIN_KEY_ACCOUNTS_B

Line 584: -- from amw_fin_key_accounts_b

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
583: -- (select natural_account_id
584: -- from amw_fin_key_accounts_b
585: -- start with (natural_account_id, account_group_id) in
586: -- (select natural_account_id, account_group_id
587: -- from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
588: -- where cert.certification_id = p_certification_id and

Line 613: from amw_fin_key_accounts_b acc

609: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID
610: )
611: union
612: select distinct acc.natural_account_id
613: from amw_fin_key_accounts_b acc
614: where ( acc.natural_account_id, acc.account_group_id ) in
615: ( select natural_account_id, account_group_id
616: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
617: where cert.certification_id = p_certification_id

Line 650: -- from amw_fin_key_accounts_b

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
649: -- (select natural_account_id
650: -- from amw_fin_key_accounts_b
651: -- start with (natural_account_id, account_group_id) in
652: -- (select natural_account_id, account_group_id
653: -- from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
654: -- where cert.certification_id = p_certification_id and

Line 673: from amw_fin_key_accounts_b acc

669: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID
670: )
671: union
672: select distinct acc.natural_account_id
673: from amw_fin_key_accounts_b acc
674: where ( acc.natural_account_id, acc.account_group_id ) in
675: ( select natural_account_id, account_group_id
676: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
677: where cert.certification_id = p_certification_id

Line 722: -- from amw_fin_key_accounts_b

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
721: -- (select natural_account_id
722: -- from amw_fin_key_accounts_b
723: -- start with (natural_account_id, account_group_id) in
724: -- (select natural_account_id, account_group_id
725: -- from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
726: -- where cert.certification_id = p_certification_id and

Line 745: from amw_fin_key_accounts_b acc

741: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID
742: )
743: union
744: select distinct acc.natural_account_id
745: from amw_fin_key_accounts_b acc
746: where ( acc.natural_account_id, acc.account_group_id ) in
747: ( select natural_account_id, account_group_id
748: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
749: where cert.certification_id = p_certification_id

Line 786: -- from amw_fin_key_accounts_b

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
785: -- (select natural_account_id
786: -- from amw_fin_key_accounts_b
787: -- start with (natural_account_id, account_group_id) in
788: -- (select natural_account_id, account_group_id
789: -- from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
790: -- where cert.certification_id = p_certification_id and

Line 809: from amw_fin_key_accounts_b acc

805: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID
806: )
807: union
808: select distinct acc.natural_account_id
809: from amw_fin_key_accounts_b acc
810: where ( acc.natural_account_id, acc.account_group_id ) in
811: ( select natural_account_id, account_group_id
812: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
813: where cert.certification_id = p_certification_id

Line 846: -- from amw_fin_key_accounts_b

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
845: -- (select natural_account_id
846: -- from amw_fin_key_accounts_b
847: -- start with (natural_account_id, account_group_id) in
848: -- (select natural_account_id, account_group_id
849: -- from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
850: -- where cert.certification_id = p_certification_id and

Line 869: from amw_fin_key_accounts_b acc

865: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID
866: )
867: union
868: select distinct acc.natural_account_id
869: from amw_fin_key_accounts_b acc
870: where ( acc.natural_account_id, acc.account_group_id ) in
871: ( select natural_account_id, account_group_id
872: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
873: where cert.certification_id = p_certification_id

Line 907: -- from amw_fin_key_accounts_b

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
906: -- (select natural_account_id
907: -- from amw_fin_key_accounts_b
908: -- start with (natural_account_id, account_group_id) in
909: -- (select natural_account_id, account_group_id
910: -- from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
911: -- where cert.certification_id = p_certification_id and

Line 930: from amw_fin_key_accounts_b acc

926: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID
927: )
928: union
929: select distinct acc.natural_account_id
930: from amw_fin_key_accounts_b acc
931: where ( acc.natural_account_id, acc.account_group_id ) in
932: ( select natural_account_id, account_group_id
933: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
934: where cert.certification_id = p_certification_id

Line 966: -- from amw_fin_key_accounts_b

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
965: -- (select natural_account_id
966: -- from amw_fin_key_accounts_b
967: -- start with (natural_account_id, account_group_id) in
968: -- (select natural_account_id, account_group_id
969: -- from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
970: -- where cert.certification_id = p_certification_id and

Line 989: from amw_fin_key_accounts_b acc

985: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID
986: )
987: union
988: select distinct acc.natural_account_id
989: from amw_fin_key_accounts_b acc
990: where ( acc.natural_account_id, acc.account_group_id ) in
991: ( select natural_account_id, account_group_id
992: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
993: where cert.certification_id = p_certification_id

Line 1031: -- from amw_fin_key_accounts_b

1027: from amw_process_organization) hier
1028: WHERE acct_assoc.natural_account_id in
1029:
1030: -- (select natural_account_id
1031: -- from amw_fin_key_accounts_b
1032: -- start with (natural_account_id, account_group_id) in
1033: -- (select natural_account_id, account_group_id
1034: -- from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
1035: -- where cert.certification_id = p_certification_id and

Line 1054: from amw_fin_key_accounts_b acc

1050: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID
1051: )
1052: union
1053: select distinct acc.natural_account_id
1054: from amw_fin_key_accounts_b acc
1055: where ( acc.natural_account_id, acc.account_group_id ) in
1056: ( select natural_account_id, account_group_id
1057: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
1058: where cert.certification_id = p_certification_id

Line 1099: -- from amw_fin_key_accounts_b

1095: from amw_process_organization) hier
1096: WHERE acct_assoc.natural_account_id in
1097:
1098: -- (select natural_account_id
1099: -- from amw_fin_key_accounts_b
1100: -- start with (natural_account_id, account_group_id) in
1101: -- (select natural_account_id, account_group_id
1102: -- from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
1103: -- where cert.certification_id = p_certification_id and

Line 1122: from amw_fin_key_accounts_b acc

1118: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID
1119: )
1120: union
1121: select distinct acc.natural_account_id
1122: from amw_fin_key_accounts_b acc
1123: where ( acc.natural_account_id, acc.account_group_id ) in
1124: ( select natural_account_id, account_group_id
1125: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
1126: where cert.certification_id = p_certification_id

Line 1172: -- from amw_fin_key_accounts_b

1168: from amw_process_organization) hier
1169: WHERE acct_assoc.natural_account_id in
1170:
1171: -- (select natural_account_id
1172: -- from amw_fin_key_accounts_b
1173: -- start with (natural_account_id, account_group_id) in
1174: -- (select natural_account_id, account_group_id
1175: -- from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
1176: -- where cert.certification_id = p_certification_id and

Line 1195: from amw_fin_key_accounts_b acc

1191: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID
1192: )
1193: union
1194: select distinct acc.natural_account_id
1195: from amw_fin_key_accounts_b acc
1196: where ( acc.natural_account_id, acc.account_group_id ) in
1197: ( select natural_account_id, account_group_id
1198: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
1199: where cert.certification_id = p_certification_id

Line 1243: -- from amw_fin_key_accounts_b

1239: from amw_process_organization) hier
1240: WHERE acct_assoc.natural_account_id in
1241:
1242: -- (select natural_account_id
1243: -- from amw_fin_key_accounts_b
1244: -- start with (natural_account_id, account_group_id) in
1245: -- (select natural_account_id, account_group_id
1246: -- from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
1247: -- where cert.certification_id = p_certification_id and

Line 1266: from amw_fin_key_accounts_b acc

1262: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID
1263: )
1264: union
1265: select distinct acc.natural_account_id
1266: from amw_fin_key_accounts_b acc
1267: where ( acc.natural_account_id, acc.account_group_id ) in
1268: ( select natural_account_id, account_group_id
1269: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
1270: where cert.certification_id = p_certification_id

Line 1299: -- from amw_fin_key_accounts_b

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
1300: -- start with (natural_account_id, account_group_id) in
1301: -- (select natural_account_id, account_group_id
1302: -- from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
1303: -- where cert.certification_id = p_certification_id and

Line 1322: from amw_fin_key_accounts_b acc

1318: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID
1319: )
1320: union
1321: select distinct acc.natural_account_id
1322: from amw_fin_key_accounts_b acc
1323: where ( acc.natural_account_id, acc.account_group_id ) in
1324: ( select natural_account_id, account_group_id
1325: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
1326: where cert.certification_id = p_certification_id

Line 1596: -- from AMW_FIN_KEY_ACCOUNTS_B acc

1592: WHERE aa.object_type = 'PROCESS_ORG'
1593: AND aa.pk1 = po.process_organization_id
1594: AND aa.natural_account_id in
1595: -- (select acc.natural_account_id
1596: -- from AMW_FIN_KEY_ACCOUNTS_B acc
1597: -- START WITH acc.natural_account_id = fika.natural_account_id
1598: -- and acc.account_group_id = fika.account_group_id
1599: -- CONNECT BY PRIOR acc.natural_account_id = acc.parent_natural_account_id
1600: -- and PRIOR acc.account_group_id = acc.account_group_id)

Line 1608: from amw_fin_key_accounts_b acc

1604: where acc.parent_natural_account_id = fika.natural_account_id
1605: and acc.account_group_id = fika.account_group_id
1606: union
1607: select distinct acc.natural_account_id
1608: from amw_fin_key_accounts_b acc
1609: where acc.natural_account_id = fika.natural_account_id
1610: and acc.account_group_id = fika.account_group_id
1611: )
1612:

Line 1998: -- from AMW_FIN_KEY_ACCOUNTS_B acc

1994: AND aa.pk1 = po.process_organization_id
1995: AND aa.natural_account_id in
1996:
1997: -- (select acc.natural_account_id
1998: -- from AMW_FIN_KEY_ACCOUNTS_B acc
1999: -- START WITH acc.natural_account_id = fika.natural_account_id
2000: -- and acc.account_group_id = fika.account_group_id
2001: -- CONNECT BY PRIOR acc.natural_account_id = acc.parent_natural_account_id
2002: -- and PRIOR acc.account_group_id = acc.account_group_id)

Line 2010: from amw_fin_key_accounts_b acc

2006: where acc.parent_natural_account_id = fika.natural_account_id
2007: and acc.account_group_id = fika.account_group_id
2008: union
2009: select distinct acc.natural_account_id
2010: from amw_fin_key_accounts_b acc
2011: where acc.natural_account_id = fika.natural_account_id
2012: and acc.account_group_id = fika.account_group_id
2013: )
2014:

Line 2265: -- from AMW_FIN_KEY_ACCOUNTS_B acc

2261: and PRIOR organization_id = organization_id)
2262: AND aa.natural_account_id in
2263:
2264: -- (select acc.natural_account_id
2265: -- from AMW_FIN_KEY_ACCOUNTS_B acc
2266: -- START WITH acc.natural_account_id = fika.natural_account_id
2267: -- and acc.account_group_id = fika.account_group_id
2268: -- CONNECT BY PRIOR acc.natural_account_id = acc.parent_natural_account_id
2269: -- and PRIOR acc.account_group_id = acc.account_group_id)

Line 2277: from amw_fin_key_accounts_b acc

2273: where acc.parent_natural_account_id = fika.natural_account_id
2274: and acc.account_group_id = fika.account_group_id
2275: union
2276: select distinct acc.natural_account_id
2277: from amw_fin_key_accounts_b acc
2278: where acc.natural_account_id = fika.natural_account_id
2279: and acc.account_group_id = fika.account_group_id
2280: )
2281: AND fika.statement_group_id = cert.statement_group_id

Line 2310: -- from AMW_FIN_KEY_ACCOUNTS_B acc

2306: AND hier.up_down_ind = 'D'
2307: AND aa.natural_account_id in
2308:
2309: -- (select acc.natural_account_id
2310: -- from AMW_FIN_KEY_ACCOUNTS_B acc
2311: -- START WITH ((acc.natural_account_id, acc.account_group_id) in
2312: -- (select fika.natural_account_id, fika.account_group_id
2313: -- from AMW_FIN_ITEMS_KEY_ACC fika,
2314: -- AMW_CERTIFICATION_B cert

Line 2332: from amw_fin_key_accounts_b acc

2328: and cert.financial_statement_id = fika.FINANCIAL_STATEMENT_ID
2329: )
2330: union
2331: select distinct acc.natural_account_id
2332: from amw_fin_key_accounts_b acc
2333: where ( acc.natural_account_id, acc.account_group_id ) in
2334: ( select natural_account_id, account_group_id
2335: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika
2336: where cert.certification_id = p_certification_id

Line 2362: -- from AMW_FIN_KEY_ACCOUNTS_B acc

2358: AND hier.up_down_ind = 'D'
2359: AND aa.natural_account_id in
2360:
2361: -- (select acc.natural_account_id
2362: -- from AMW_FIN_KEY_ACCOUNTS_B acc
2363: -- START WITH ((acc.natural_account_id, acc.account_group_id) in
2364: -- (select fika.natural_account_id, fika.account_group_id
2365: -- from AMW_FIN_ITEMS_KEY_ACC fika,
2366: -- AMW_CERTIFICATION_B cert

Line 2384: from amw_fin_key_accounts_b acc

2380: and cert.financial_statement_id = fika.FINANCIAL_STATEMENT_ID
2381: )
2382: union
2383: select distinct acc.natural_account_id
2384: from amw_fin_key_accounts_b acc
2385: where ( acc.natural_account_id, acc.account_group_id ) in
2386: ( select natural_account_id, account_group_id
2387: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika
2388: where cert.certification_id = p_certification_id

Line 2430: -- from AMW_FIN_KEY_ACCOUNTS_B acc

2426: AND hier.up_down_ind = 'D'
2427: AND aa.natural_account_id in
2428:
2429: -- (select acc.natural_account_id
2430: -- from AMW_FIN_KEY_ACCOUNTS_B acc
2431: -- START WITH ((acc.natural_account_id, acc.account_group_id) in
2432: -- (select fika.natural_account_id, fika.account_group_id
2433: -- from AMW_FIN_ITEMS_KEY_ACC fika,
2434: -- AMW_CERTIFICATION_B cert

Line 2452: from amw_fin_key_accounts_b acc

2448: and cert.financial_statement_id = fika.FINANCIAL_STATEMENT_ID
2449: )
2450: union
2451: select distinct acc.natural_account_id
2452: from amw_fin_key_accounts_b acc
2453: where ( acc.natural_account_id, acc.account_group_id ) in
2454: ( select natural_account_id, account_group_id
2455: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika
2456: where cert.certification_id = p_certification_id

Line 2497: -- from AMW_FIN_KEY_ACCOUNTS_B acc

2493: AND hier.up_down_ind = 'D'
2494: AND aa.natural_account_id in
2495:
2496: -- (select acc.natural_account_id
2497: -- from AMW_FIN_KEY_ACCOUNTS_B acc
2498: -- START WITH ((acc.natural_account_id, acc.account_group_id) in
2499: -- (select fika.natural_account_id, fika.account_group_id
2500: -- from AMW_FIN_ITEMS_KEY_ACC fika,
2501: -- AMW_CERTIFICATION_B cert

Line 2519: from amw_fin_key_accounts_b acc

2515: and cert.financial_statement_id = fika.FINANCIAL_STATEMENT_ID
2516: )
2517: union
2518: select distinct acc.natural_account_id
2519: from amw_fin_key_accounts_b acc
2520: where ( acc.natural_account_id, acc.account_group_id ) in
2521: ( select natural_account_id, account_group_id
2522: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika
2523: where cert.certification_id = p_certification_id

Line 2561: -- from AMW_FIN_KEY_ACCOUNTS_B acc

2557: AND hier.up_down_ind = 'D'
2558: AND aa.natural_account_id in
2559:
2560: -- (select acc.natural_account_id
2561: -- from AMW_FIN_KEY_ACCOUNTS_B acc
2562: -- START WITH ((acc.natural_account_id, acc.account_group_id) in
2563: -- (select fika.natural_account_id, fika.account_group_id
2564: -- from AMW_FIN_ITEMS_KEY_ACC fika,
2565: -- AMW_CERTIFICATION_B cert

Line 2583: from amw_fin_key_accounts_b acc

2579: and cert.financial_statement_id = fika.FINANCIAL_STATEMENT_ID
2580: )
2581: union
2582: select distinct acc.natural_account_id
2583: from amw_fin_key_accounts_b acc
2584: where ( acc.natural_account_id, acc.account_group_id ) in
2585: ( select natural_account_id, account_group_id
2586: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika
2587: where cert.certification_id = p_certification_id

Line 2628: -- from AMW_FIN_KEY_ACCOUNTS_B acc

2624: AND hier.process_id = po.process_id
2625: AND hier.up_down_ind = 'D'
2626: AND aa.natural_account_id in
2627: -- (select acc.natural_account_id
2628: -- from AMW_FIN_KEY_ACCOUNTS_B acc
2629: -- START WITH ((acc.natural_account_id, acc.account_group_id) in
2630: -- (select fika.natural_account_id, fika.account_group_id
2631: -- from AMW_FIN_ITEMS_KEY_ACC fika,
2632: -- AMW_CERTIFICATION_B cert

Line 2650: from amw_fin_key_accounts_b acc

2646: and cert.financial_statement_id = fika.FINANCIAL_STATEMENT_ID
2647: )
2648: union
2649: select distinct acc.natural_account_id
2650: from amw_fin_key_accounts_b acc
2651: where ( acc.natural_account_id, acc.account_group_id ) in
2652: ( select natural_account_id, account_group_id
2653: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika
2654: where cert.certification_id = p_certification_id

Line 2687: -- from AMW_FIN_KEY_ACCOUNTS_B acc

2683: AND hier.up_down_ind = 'D'
2684: AND aa.natural_account_id in
2685:
2686: -- (select acc.natural_account_id
2687: -- from AMW_FIN_KEY_ACCOUNTS_B acc
2688: -- START WITH ((acc.natural_account_id, acc.account_group_id) in
2689: -- (select fika.natural_account_id, fika.account_group_id
2690: -- from AMW_FIN_ITEMS_KEY_ACC fika,
2691: -- AMW_CERTIFICATION_B cert

Line 2709: from amw_fin_key_accounts_b acc

2705: and cert.financial_statement_id = fika.FINANCIAL_STATEMENT_ID
2706: )
2707: union
2708: select distinct acc.natural_account_id
2709: from amw_fin_key_accounts_b acc
2710: where ( acc.natural_account_id, acc.account_group_id ) in
2711: ( select natural_account_id, account_group_id
2712: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika
2713: where cert.certification_id = p_certification_id

Line 2756: -- from AMW_FIN_KEY_ACCOUNTS_B acc

2752: AND hier.process_id = po.process_id
2753: AND hier.up_down_ind = 'D'
2754: AND aa.natural_account_id in
2755: -- (select acc.natural_account_id
2756: -- from AMW_FIN_KEY_ACCOUNTS_B acc
2757: -- START WITH ((acc.natural_account_id, acc.account_group_id) in
2758: -- (select fika.natural_account_id, fika.account_group_id
2759: -- from AMW_FIN_ITEMS_KEY_ACC fika,
2760: -- AMW_CERTIFICATION_B cert

Line 2778: from amw_fin_key_accounts_b acc

2774: and cert.financial_statement_id = fika.FINANCIAL_STATEMENT_ID
2775: )
2776: union
2777: select distinct acc.natural_account_id
2778: from amw_fin_key_accounts_b acc
2779: where ( acc.natural_account_id, acc.account_group_id ) in
2780: ( select natural_account_id, account_group_id
2781: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika
2782: where cert.certification_id = p_certification_id

Line 3037: -- from AMW_FIN_KEY_ACCOUNTS_B acc

3033: AND aa.pk1 = po.process_organization_id
3034: AND aa.natural_account_id in
3035:
3036: -- (select acc.natural_account_id
3037: -- from AMW_FIN_KEY_ACCOUNTS_B acc
3038: -- START WITH acc.natural_account_id = fika.natural_account_id
3039: -- and acc.account_group_id = fika.account_group_id
3040: -- CONNECT BY PRIOR acc.natural_account_id = acc.parent_natural_account_id
3041: -- and PRIOR acc.account_group_id = acc.account_group_id)

Line 3049: from amw_fin_key_accounts_b acc

3045: where acc.parent_natural_account_id = fika.natural_account_id
3046: and acc.account_group_id = fika.account_group_id
3047: union
3048: select distinct acc.natural_account_id
3049: from amw_fin_key_accounts_b acc
3050: where acc.natural_account_id = fika.natural_account_id
3051: and acc.account_group_id = fika.account_group_id
3052: )
3053:

Line 3082: -- from AMW_FIN_KEY_ACCOUNTS_B acc

3078: AND aa.pk1 = po.process_organization_id
3079: AND aa.natural_account_id in
3080:
3081: -- (select acc.natural_account_id
3082: -- from AMW_FIN_KEY_ACCOUNTS_B acc
3083: -- START WITH acc.natural_account_id = fika.natural_account_id
3084: -- and acc.account_group_id = fika.account_group_id
3085: -- CONNECT BY PRIOR acc.natural_account_id = acc.parent_natural_account_id
3086: -- and PRIOR acc.account_group_id = acc.account_group_id)

Line 3094: from amw_fin_key_accounts_b acc

3090: where acc.parent_natural_account_id = fika.natural_account_id
3091: and acc.account_group_id = fika.account_group_id
3092: union
3093: select distinct acc.natural_account_id
3094: from amw_fin_key_accounts_b acc
3095: where acc.natural_account_id = fika.natural_account_id
3096: and acc.account_group_id = fika.account_group_id
3097: )
3098: AND fika.statement_group_id = cert.statement_group_id

Line 3608: AMW_FIN_KEY_ACCOUNTS_B KeyAccChild2,

3604: KeyAccChild2.NATURAL_ACCOUNT_ID,
3605: KeyAccChild2.PARENT_NATURAL_ACCOUNT_ID,
3606: KeyAccChild2.NATURAL_ACCOUNT_VALUE
3607: From
3608: AMW_FIN_KEY_ACCOUNTS_B KeyAccChild2,
3609: AMW_FIN_ITEMS_KEY_ACC finitemAcc2
3610: Where
3611: (KeyAccChild2.PARENT_NATURAL_ACCOUNT_ID is not null)
3612: and KeyAccChild2.ACCOUNT_GROUP_ID = finitemAcc.ACCOUNT_GROUP_ID

Line 3650: AMW_FIN_KEY_ACCOUNTS_B

3646: select
3647: ACCOUNT_GROUP_ID,
3648: NATURAL_ACCOUNT_ID
3649: from
3650: AMW_FIN_KEY_ACCOUNTS_B
3651: where
3652: PARENT_NATURAL_ACCOUNT_ID = P_ACCOUNT_ID
3653: and ACCOUNT_GROUP_ID = P_ACCOUNT_GROUP_ID;
3654:

Line 4770: -- from AMW_FIN_KEY_ACCOUNTS_B acc

4766: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
4767: and AccProcs.natural_account_id in
4768: --(select
4769: -- distinct(acc.natural_account_id)
4770: -- from AMW_FIN_KEY_ACCOUNTS_B acc
4771: -- START WITH acc.natural_account_id = P_NATURAL_ACCOUNT_ID
4772: -- and acc.account_group_id = P_account_group_id
4773: --CONNECT BY PRIOR
4774: -- acc.natural_account_id = acc.parent_natural_account_id

Line 4784: from amw_fin_key_accounts_b acc

4780: where acc.parent_natural_account_id = p_natural_account_id
4781: and acc.account_group_id = p_account_group_id
4782: union
4783: select distinct acc.natural_account_id
4784: from amw_fin_key_accounts_b acc
4785: where acc.natural_account_id = p_natural_account_id
4786: and acc.account_group_id = p_account_group_id
4787: )
4788:

Line 4839: -- from AMW_FIN_KEY_ACCOUNTS_B acc

4835: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
4836: and AccProcs.natural_account_id in
4837: -- (select
4838: -- distinct(acc.natural_account_id)
4839: -- from AMW_FIN_KEY_ACCOUNTS_B acc
4840: -- START WITH acc.natural_account_id = P_NATURAL_ACCOUNT_ID
4841: -- and acc.account_group_id = P_account_group_id
4842: --CONNECT BY PRIOR
4843: -- acc.natural_account_id = acc.parent_natural_account_id

Line 4853: from amw_fin_key_accounts_b acc

4849: where acc.parent_natural_account_id = p_natural_account_id
4850: and acc.account_group_id = p_account_group_id
4851: union
4852: select distinct acc.natural_account_id
4853: from amw_fin_key_accounts_b acc
4854: where acc.natural_account_id = p_natural_account_id
4855: and acc.account_group_id = p_account_group_id
4856: )
4857:

Line 4922: -- from AMW_FIN_KEY_ACCOUNTS_B acc

4918: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
4919: and AccProcs.natural_account_id in
4920: -- (select
4921: -- distinct(acc.natural_account_id)
4922: -- from AMW_FIN_KEY_ACCOUNTS_B acc
4923: -- START WITH acc.natural_account_id = P_NATURAL_ACCOUNT_ID
4924: -- and acc.account_group_id = P_account_group_id
4925: --CONNECT BY PRIOR
4926: -- acc.natural_account_id = acc.parent_natural_account_id

Line 4936: from amw_fin_key_accounts_b acc

4932: where acc.parent_natural_account_id = p_natural_account_id
4933: and acc.account_group_id = p_account_group_id
4934: union
4935: select distinct acc.natural_account_id
4936: from amw_fin_key_accounts_b acc
4937: where acc.natural_account_id = p_natural_account_id
4938: and acc.account_group_id = p_account_group_id
4939: )
4940:

Line 5003: -- from AMW_FIN_KEY_ACCOUNTS_B acc

4999: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
5000: and AccProcs.natural_account_id in
5001: -- (select
5002: -- distinct(acc.natural_account_id)
5003: -- from AMW_FIN_KEY_ACCOUNTS_B acc
5004: -- START WITH acc.natural_account_id = P_NATURAL_ACCOUNT_ID
5005: -- and acc.account_group_id = P_account_group_id
5006: --CONNECT BY PRIOR
5007: -- acc.natural_account_id = acc.parent_natural_account_id

Line 5017: from amw_fin_key_accounts_b acc

5013: where acc.parent_natural_account_id = p_natural_account_id
5014: and acc.account_group_id = p_account_group_id
5015: union
5016: select distinct acc.natural_account_id
5017: from amw_fin_key_accounts_b acc
5018: where acc.natural_account_id = p_natural_account_id
5019: and acc.account_group_id = p_account_group_id
5020: )
5021:

Line 5080: -- from AMW_FIN_KEY_ACCOUNTS_B acc

5076: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
5077: and AccProcs.natural_account_id in
5078: -- (select
5079: -- distinct(acc.natural_account_id)
5080: -- from AMW_FIN_KEY_ACCOUNTS_B acc
5081: -- START WITH acc.natural_account_id = P_NATURAL_ACCOUNT_ID
5082: -- and acc.account_group_id = P_account_group_id
5083: --CONNECT BY PRIOR
5084: -- acc.natural_account_id = acc.parent_natural_account_id

Line 5094: from amw_fin_key_accounts_b acc

5090: where acc.parent_natural_account_id = p_natural_account_id
5091: and acc.account_group_id = p_account_group_id
5092: union
5093: select distinct acc.natural_account_id
5094: from amw_fin_key_accounts_b acc
5095: where acc.natural_account_id = p_natural_account_id
5096: and acc.account_group_id = p_account_group_id
5097: )
5098:

Line 5159: -- from AMW_FIN_KEY_ACCOUNTS_B acc

5155: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
5156: and AccProcs.natural_account_id in
5157: -- (select
5158: -- distinct(acc.natural_account_id)
5159: -- from AMW_FIN_KEY_ACCOUNTS_B acc
5160: -- START WITH acc.natural_account_id = P_NATURAL_ACCOUNT_ID
5161: -- and acc.account_group_id = P_account_group_id
5162: --CONNECT BY PRIOR
5163: -- acc.natural_account_id = acc.parent_natural_account_id

Line 5173: from amw_fin_key_accounts_b acc

5169: where acc.parent_natural_account_id = p_natural_account_id
5170: and acc.account_group_id = p_account_group_id
5171: union
5172: select distinct acc.natural_account_id
5173: from amw_fin_key_accounts_b acc
5174: where acc.natural_account_id = p_natural_account_id
5175: and acc.account_group_id = p_account_group_id
5176: )
5177:

Line 5207: -- from AMW_FIN_KEY_ACCOUNTS_B acc

5203: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
5204: and AccProcs.natural_account_id in
5205: -- (select
5206: -- distinct(acc.natural_account_id)
5207: -- from AMW_FIN_KEY_ACCOUNTS_B acc
5208: -- START WITH acc.natural_account_id = P_NATURAL_ACCOUNT_ID
5209: -- and acc.account_group_id = P_account_group_id
5210: --CONNECT BY PRIOR
5211: -- acc.natural_account_id = acc.parent_natural_account_id

Line 5221: from amw_fin_key_accounts_b acc

5217: where acc.parent_natural_account_id = p_natural_account_id
5218: and acc.account_group_id = p_account_group_id
5219: union
5220: select distinct acc.natural_account_id
5221: from amw_fin_key_accounts_b acc
5222: where acc.natural_account_id = p_natural_account_id
5223: and acc.account_group_id = p_account_group_id
5224: )
5225:

Line 5275: -- from AMW_FIN_KEY_ACCOUNTS_B acc

5271: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
5272: and AccProcs.natural_account_id in
5273: -- (select
5274: -- distinct(acc.natural_account_id)
5275: -- from AMW_FIN_KEY_ACCOUNTS_B acc
5276: -- START WITH acc.natural_account_id = P_NATURAL_ACCOUNT_ID
5277: -- and acc.account_group_id = P_account_group_id
5278: --CONNECT BY PRIOR
5279: -- acc.natural_account_id = acc.parent_natural_account_id

Line 5289: from amw_fin_key_accounts_b acc

5285: where acc.parent_natural_account_id = p_natural_account_id
5286: and acc.account_group_id = p_account_group_id
5287: union
5288: select distinct acc.natural_account_id
5289: from amw_fin_key_accounts_b acc
5290: where acc.natural_account_id = p_natural_account_id
5291: and acc.account_group_id = p_account_group_id
5292: )
5293:

Line 5361: -- from AMW_FIN_KEY_ACCOUNTS_B acc

5357: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
5358: and AccProcs.natural_account_id in
5359: -- (select
5360: -- distinct(acc.natural_account_id)
5361: -- from AMW_FIN_KEY_ACCOUNTS_B acc
5362: -- START WITH acc.natural_account_id = P_NATURAL_ACCOUNT_ID
5363: -- and acc.account_group_id = P_account_group_id
5364: --CONNECT BY PRIOR
5365: -- acc.natural_account_id = acc.parent_natural_account_id

Line 5375: from amw_fin_key_accounts_b acc

5371: where acc.parent_natural_account_id = p_natural_account_id
5372: and acc.account_group_id = p_account_group_id
5373: union
5374: select distinct acc.natural_account_id
5375: from amw_fin_key_accounts_b acc
5376: where acc.natural_account_id = p_natural_account_id
5377: and acc.account_group_id = p_account_group_id
5378: )
5379:

Line 5441: -- from AMW_FIN_KEY_ACCOUNTS_B acc

5437: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
5438: and AccProcs.natural_account_id in
5439: -- (select
5440: -- distinct(acc.natural_account_id)
5441: -- from AMW_FIN_KEY_ACCOUNTS_B acc
5442: -- START WITH acc.natural_account_id = P_NATURAL_ACCOUNT_ID
5443: -- and acc.account_group_id = P_account_group_id
5444: --CONNECT BY PRIOR
5445: -- acc.natural_account_id = acc.parent_natural_account_id and PRIOR

Line 5454: from amw_fin_key_accounts_b acc

5450: where acc.parent_natural_account_id = p_natural_account_id
5451: and acc.account_group_id = p_account_group_id
5452: union
5453: select distinct acc.natural_account_id
5454: from amw_fin_key_accounts_b acc
5455: where acc.natural_account_id = p_natural_account_id
5456: and acc.account_group_id = p_account_group_id
5457: )
5458:

Line 5533: -- from AMW_FIN_KEY_ACCOUNTS_B acc

5529: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
5530: and AccProcs.natural_account_id in
5531: -- (select
5532: -- distinct(acc.natural_account_id)
5533: -- from AMW_FIN_KEY_ACCOUNTS_B acc
5534: -- START WITH acc.natural_account_id = P_NATURAL_ACCOUNT_ID
5535: -- and acc.account_group_id = P_account_group_id
5536: --CONNECT BY PRIOR
5537: -- acc.natural_account_id = acc.parent_natural_account_id

Line 5547: from amw_fin_key_accounts_b acc

5543: where acc.parent_natural_account_id = p_natural_account_id
5544: and acc.account_group_id = p_account_group_id
5545: union
5546: select distinct acc.natural_account_id
5547: from amw_fin_key_accounts_b acc
5548: where acc.natural_account_id = p_natural_account_id
5549: and acc.account_group_id = p_account_group_id
5550: )
5551:

Line 5622: -- from AMW_FIN_KEY_ACCOUNTS_B acc

5618: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
5619: and AccProcs.natural_account_id in
5620: -- (select
5621: -- distinct(acc.natural_account_id)
5622: -- from AMW_FIN_KEY_ACCOUNTS_B acc
5623: -- START WITH acc.natural_account_id = P_NATURAL_ACCOUNT_ID
5624: -- and acc.account_group_id = P_account_group_id
5625: --CONNECT BY PRIOR
5626: -- acc.natural_account_id = acc.parent_natural_account_id

Line 5636: from amw_fin_key_accounts_b acc

5632: where acc.parent_natural_account_id = p_natural_account_id
5633: and acc.account_group_id = p_account_group_id
5634: union
5635: select distinct acc.natural_account_id
5636: from amw_fin_key_accounts_b acc
5637: where acc.natural_account_id = p_natural_account_id
5638: and acc.account_group_id = p_account_group_id
5639: )
5640:

Line 5679: -- from AMW_FIN_KEY_ACCOUNTS_B acc

5675: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
5676: and AccProcs.natural_account_id in
5677: -- (select
5678: -- distinct(acc.natural_account_id)
5679: -- from AMW_FIN_KEY_ACCOUNTS_B acc
5680: -- START WITH acc.natural_account_id = P_NATURAL_ACCOUNT_ID
5681: -- and acc.account_group_id = P_account_group_id
5682: --CONNECT BY PRIOR
5683: -- acc.natural_account_id = acc.parent_natural_account_id

Line 5693: from amw_fin_key_accounts_b acc

5689: where acc.parent_natural_account_id = p_natural_account_id
5690: and acc.account_group_id = p_account_group_id
5691: union
5692: select distinct acc.natural_account_id
5693: from amw_fin_key_accounts_b acc
5694: where acc.natural_account_id = p_natural_account_id
5695: and acc.account_group_id = p_account_group_id
5696: )
5697:

Line 5757: -- from AMW_FIN_KEY_ACCOUNTS_B acc

5753: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
5754: and AccProcs.natural_account_id in
5755: -- (select
5756: -- distinct(acc.natural_account_id)
5757: -- from AMW_FIN_KEY_ACCOUNTS_B acc
5758: -- START WITH acc.natural_account_id = P_NATURAL_ACCOUNT_ID
5759: -- and acc.account_group_id = P_account_group_id
5760: --CONNECT BY PRIOR
5761: -- acc.natural_account_id = acc.parent_natural_account_id

Line 5771: from amw_fin_key_accounts_b acc

5767: where acc.parent_natural_account_id = p_natural_account_id
5768: and acc.account_group_id = p_account_group_id
5769: union
5770: select distinct acc.natural_account_id
5771: from amw_fin_key_accounts_b acc
5772: where acc.natural_account_id = p_natural_account_id
5773: and acc.account_group_id = p_account_group_id
5774: )
5775:

Line 5821: -- from AMW_FIN_KEY_ACCOUNTS_B acc

5817: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
5818: and AccProcs.natural_account_id in
5819: -- (select
5820: -- distinct(acc.natural_account_id)
5821: -- from AMW_FIN_KEY_ACCOUNTS_B acc
5822: -- START WITH acc.natural_account_id = P_NATURAL_ACCOUNT_ID
5823: -- and acc.account_group_id = P_account_group_id
5824: --CONNECT BY PRIOR
5825: -- acc.natural_account_id = acc.parent_natural_account_id

Line 5835: from amw_fin_key_accounts_b acc

5831: where acc.parent_natural_account_id = p_natural_account_id
5832: and acc.account_group_id = p_account_group_id
5833: union
5834: select distinct acc.natural_account_id
5835: from amw_fin_key_accounts_b acc
5836: where acc.natural_account_id = p_natural_account_id
5837: and acc.account_group_id = p_account_group_id
5838: )
5839:

Line 5901: -- from AMW_FIN_KEY_ACCOUNTS_B acc

5897: AccProcs .pk1= orgprocess2.PROCESS_ORGANIZATION_ID
5898: and AccProcs.natural_account_id in
5899: -- (select
5900: -- distinct(acc.natural_account_id)
5901: -- from AMW_FIN_KEY_ACCOUNTS_B acc
5902: -- START WITH acc.natural_account_id = P_NATURAL_ACCOUNT_ID
5903: -- and acc.account_group_id = P_account_group_id
5904: --CONNECT BY PRIOR
5905: -- acc.natural_account_id = acc.parent_natural_account_id

Line 5915: from amw_fin_key_accounts_b acc

5911: where acc.parent_natural_account_id = p_natural_account_id
5912: and acc.account_group_id = p_account_group_id
5913: union
5914: select distinct acc.natural_account_id
5915: from amw_fin_key_accounts_b acc
5916: where acc.natural_account_id = p_natural_account_id
5917: and acc.account_group_id = p_account_group_id
5918: )
5919:

Line 5947: -- from AMW_FIN_KEY_ACCOUNTS_B acc

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
5948: -- START WITH ( (acc.natural_account_id, acc.account_group_id) in
5949: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc
5950: --where
5951: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID

Line 5994: from amw_fin_key_accounts_b acc

5990: )
5991: )
5992: union
5993: select distinct acc.natural_account_id
5994: from amw_fin_key_accounts_b acc
5995: where ( acc.natural_account_id, acc.account_group_id ) in
5996: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
5997: from amw_fin_items_key_acc finkeyacc
5998: where finkeyacc.statement_group_id = p_statement_group_id

Line 6066: -- from AMW_FIN_KEY_ACCOUNTS_B acc

6062: AccProcs.pk1= orgprocess2.PROCESS_ORGANIZATION_ID
6063: and AccProcs.natural_account_id in
6064:
6065: --(select distinct(acc.natural_account_id)
6066: -- from AMW_FIN_KEY_ACCOUNTS_B acc
6067: -- START WITH ( (acc.natural_account_id, acc.account_group_id) in
6068: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc
6069: --where
6070: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID

Line 6113: from amw_fin_key_accounts_b acc

6109: )
6110: )
6111: union
6112: select distinct acc.natural_account_id
6113: from amw_fin_key_accounts_b acc
6114: where ( acc.natural_account_id, acc.account_group_id ) in
6115: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
6116: from amw_fin_items_key_acc finkeyacc
6117: where finkeyacc.statement_group_id = p_statement_group_id

Line 6202: -- from AMW_FIN_KEY_ACCOUNTS_B acc

6198: AccProcs.pk1= orgprocess2.PROCESS_ORGANIZATION_ID
6199: and AccProcs.natural_account_id in
6200:
6201: --(select distinct(acc.natural_account_id)
6202: -- from AMW_FIN_KEY_ACCOUNTS_B acc
6203: -- START WITH ( (acc.natural_account_id, acc.account_group_id) in
6204: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc
6205: --where
6206: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID

Line 6249: from amw_fin_key_accounts_b acc

6245: )
6246: )
6247: union
6248: select distinct acc.natural_account_id
6249: from amw_fin_key_accounts_b acc
6250: where ( acc.natural_account_id, acc.account_group_id ) in
6251: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
6252: from amw_fin_items_key_acc finkeyacc
6253: where finkeyacc.statement_group_id = p_statement_group_id

Line 6335: -- from AMW_FIN_KEY_ACCOUNTS_B acc

6331: AccProcs.pk1= orgprocess2.PROCESS_ORGANIZATION_ID
6332: and AccProcs.natural_account_id in
6333:
6334: --(select distinct(acc.natural_account_id)
6335: -- from AMW_FIN_KEY_ACCOUNTS_B acc
6336: -- START WITH ( (acc.natural_account_id, acc.account_group_id) in
6337: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc
6338: --where
6339: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID

Line 6382: from amw_fin_key_accounts_b acc

6378: )
6379: )
6380: union
6381: select distinct acc.natural_account_id
6382: from amw_fin_key_accounts_b acc
6383: where ( acc.natural_account_id, acc.account_group_id ) in
6384: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
6385: from amw_fin_items_key_acc finkeyacc
6386: where finkeyacc.statement_group_id = p_statement_group_id

Line 6469: -- from AMW_FIN_KEY_ACCOUNTS_B acc

6465: AccProcs.pk1= orgprocess2.PROCESS_ORGANIZATION_ID
6466: and AccProcs.natural_account_id in
6467:
6468: --(select distinct(acc.natural_account_id)
6469: -- from AMW_FIN_KEY_ACCOUNTS_B acc
6470: -- START WITH ( (acc.natural_account_id, acc.account_group_id) in
6471: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc
6472: --where
6473: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID

Line 6516: from amw_fin_key_accounts_b acc

6512: )
6513: )
6514: union
6515: select distinct acc.natural_account_id
6516: from amw_fin_key_accounts_b acc
6517: where ( acc.natural_account_id, acc.account_group_id ) in
6518: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
6519: from amw_fin_items_key_acc finkeyacc
6520: where finkeyacc.statement_group_id = p_statement_group_id

Line 6574: -- from AMW_FIN_KEY_ACCOUNTS_B acc

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
6575: -- START WITH ( (acc.natural_account_id, acc.account_group_id) in
6576: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc
6577: --where
6578: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID

Line 6621: from amw_fin_key_accounts_b acc

6617: )
6618: )
6619: union
6620: select distinct acc.natural_account_id
6621: from amw_fin_key_accounts_b acc
6622: where ( acc.natural_account_id, acc.account_group_id ) in
6623: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
6624: from amw_fin_items_key_acc finkeyacc
6625: where finkeyacc.statement_group_id = p_statement_group_id

Line 6694: -- from AMW_FIN_KEY_ACCOUNTS_B acc

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
6695: -- START WITH ( (acc.natural_account_id, acc.account_group_id) in
6696: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc
6697: --where
6698: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID

Line 6741: from amw_fin_key_accounts_b acc

6737: )
6738: )
6739: union
6740: select distinct acc.natural_account_id
6741: from amw_fin_key_accounts_b acc
6742: where ( acc.natural_account_id, acc.account_group_id ) in
6743: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
6744: from amw_fin_items_key_acc finkeyacc
6745: where finkeyacc.statement_group_id = p_statement_group_id

Line 6824: -- from AMW_FIN_KEY_ACCOUNTS_B acc

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
6825: -- START WITH ( (acc.natural_account_id, acc.account_group_id) in
6826: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc
6827: --where
6828: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID

Line 6871: from amw_fin_key_accounts_b acc

6867: )
6868: )
6869: union
6870: select distinct acc.natural_account_id
6871: from amw_fin_key_accounts_b acc
6872: where ( acc.natural_account_id, acc.account_group_id ) in
6873: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
6874: from amw_fin_items_key_acc finkeyacc
6875: where finkeyacc.statement_group_id = p_statement_group_id

Line 6956: -- from AMW_FIN_KEY_ACCOUNTS_B acc

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
6957: -- START WITH ( (acc.natural_account_id, acc.account_group_id) in
6958: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc
6959: --where
6960: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID

Line 7003: from amw_fin_key_accounts_b acc

6999: )
7000: )
7001: union
7002: select distinct acc.natural_account_id
7003: from amw_fin_key_accounts_b acc
7004: where ( acc.natural_account_id, acc.account_group_id ) in
7005: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
7006: from amw_fin_items_key_acc finkeyacc
7007: where finkeyacc.statement_group_id = p_statement_group_id

Line 7104: -- from AMW_FIN_KEY_ACCOUNTS_B acc

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
7105: -- START WITH ( (acc.natural_account_id, acc.account_group_id) in
7106: --- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc
7107: --where
7108: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID

Line 7151: from amw_fin_key_accounts_b acc

7147: )
7148: )
7149: union
7150: select distinct acc.natural_account_id
7151: from amw_fin_key_accounts_b acc
7152: where ( acc.natural_account_id, acc.account_group_id ) in
7153: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
7154: from amw_fin_items_key_acc finkeyacc
7155: where finkeyacc.statement_group_id = p_statement_group_id

Line 7247: -- from AMW_FIN_KEY_ACCOUNTS_B acc

7243: AccProcs.pk1= orgprocess2.PROCESS_ORGANIZATION_ID
7244: and AccProcs.natural_account_id in
7245:
7246: --(select distinct(acc.natural_account_id)
7247: -- from AMW_FIN_KEY_ACCOUNTS_B acc
7248: -- START WITH ( (acc.natural_account_id, acc.account_group_id) in
7249: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc
7250: --where
7251: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID

Line 7294: from amw_fin_key_accounts_b acc

7290: )
7291: )
7292: union
7293: select distinct acc.natural_account_id
7294: from amw_fin_key_accounts_b acc
7295: where ( acc.natural_account_id, acc.account_group_id ) in
7296: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
7297: from amw_fin_items_key_acc finkeyacc
7298: where finkeyacc.statement_group_id = p_statement_group_id

Line 7357: -- from AMW_FIN_KEY_ACCOUNTS_B acc

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
7358: -- START WITH ( (acc.natural_account_id, acc.account_group_id) in
7359: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc
7360: --where
7361: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID

Line 7404: from amw_fin_key_accounts_b acc

7400: )
7401: )
7402: union
7403: select distinct acc.natural_account_id
7404: from amw_fin_key_accounts_b acc
7405: where ( acc.natural_account_id, acc.account_group_id ) in
7406: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
7407: from amw_fin_items_key_acc finkeyacc
7408: where finkeyacc.statement_group_id = p_statement_group_id

Line 7484: -- from AMW_FIN_KEY_ACCOUNTS_B acc

7480: AccProcs.pk1= orgprocess2.PROCESS_ORGANIZATION_ID
7481: and AccProcs.natural_account_id in
7482:
7483: --(select distinct(acc.natural_account_id)
7484: -- from AMW_FIN_KEY_ACCOUNTS_B acc
7485: -- START WITH ( (acc.natural_account_id, acc.account_group_id) in
7486: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc
7487: --where
7488: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID

Line 7531: from amw_fin_key_accounts_b acc

7527: )
7528: )
7529: union
7530: select distinct acc.natural_account_id
7531: from amw_fin_key_accounts_b acc
7532: where ( acc.natural_account_id, acc.account_group_id ) in
7533: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
7534: from amw_fin_items_key_acc finkeyacc
7535: where finkeyacc.statement_group_id = p_statement_group_id

Line 7601: -- from AMW_FIN_KEY_ACCOUNTS_B acc

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
7602: -- START WITH ( (acc.natural_account_id, acc.account_group_id) in
7603: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc
7604: --where
7605: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID

Line 7648: from amw_fin_key_accounts_b acc

7644: )
7645: )
7646: union
7647: select distinct acc.natural_account_id
7648: from amw_fin_key_accounts_b acc
7649: where ( acc.natural_account_id, acc.account_group_id ) in
7650: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
7651: from amw_fin_items_key_acc finkeyacc
7652: where finkeyacc.statement_group_id = p_statement_group_id

Line 7731: -- from AMW_FIN_KEY_ACCOUNTS_B acc

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
7732: -- START WITH ( (acc.natural_account_id, acc.account_group_id) in
7733: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc
7734: --where
7735: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID

Line 7778: from amw_fin_key_accounts_b acc

7774: )
7775: )
7776: union
7777: select distinct acc.natural_account_id
7778: from amw_fin_key_accounts_b acc
7779: where ( acc.natural_account_id, acc.account_group_id ) in
7780: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
7781: from amw_fin_items_key_acc finkeyacc
7782: where finkeyacc.statement_group_id = p_statement_group_id

Line 7858: -- from AMW_FIN_KEY_ACCOUNTS_B acc

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
7859: -- START WITH ( (acc.natural_account_id, acc.account_group_id) in
7860: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc
7861: --where
7862: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID

Line 7905: from amw_fin_key_accounts_b acc

7901: )
7902: )
7903: union
7904: select distinct acc.natural_account_id
7905: from amw_fin_key_accounts_b acc
7906: where ( acc.natural_account_id, acc.account_group_id ) in
7907: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
7908: from amw_fin_items_key_acc finkeyacc
7909: where finkeyacc.statement_group_id = p_statement_group_id