APPS.AMW_FINSTMT_CERT_PVT dependencies on AMW_FIN_KEY_ACCT_FLAT

Line 602: from amw_fin_key_acct_flat acc

598: -- second part of the query returns the actual pair (x, y). Such unions
599: -- are used in all the flattened queries in this file.
600:
601: ( select distinct acc.child_natural_account_id
602: from amw_fin_key_acct_flat acc
603: where ( acc.parent_natural_account_id, acc.account_group_id ) in
604: ( select natural_account_id, account_group_id
605: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
606: where cert.certification_id = p_certification_id

Line 662: from amw_fin_key_acct_flat acc

658: -- connect by parent_natural_account_id = PRIOR natural_account_id and
659: -- account_group_id = PRIOR account_group_id)
660: -- Modifed for flatting key_acct table
661: ( select distinct acc.child_natural_account_id
662: from amw_fin_key_acct_flat acc
663: where ( acc.parent_natural_account_id, acc.account_group_id ) in
664: ( select natural_account_id, account_group_id
665: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
666: where cert.certification_id = p_certification_id

Line 734: from amw_fin_key_acct_flat acc

730: -- connect by parent_natural_account_id = PRIOR natural_account_id and
731: -- account_group_id = PRIOR account_group_id)
732:
733: ( select distinct acc.child_natural_account_id
734: from amw_fin_key_acct_flat acc
735: where ( acc.parent_natural_account_id, acc.account_group_id ) in
736: ( select natural_account_id, account_group_id
737: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
738: where cert.certification_id = p_certification_id

Line 798: from amw_fin_key_acct_flat acc

794: -- connect by parent_natural_account_id = PRIOR natural_account_id and
795: -- account_group_id = PRIOR account_group_id)
796:
797: ( select distinct acc.child_natural_account_id
798: from amw_fin_key_acct_flat acc
799: where ( acc.parent_natural_account_id, acc.account_group_id ) in
800: ( select natural_account_id, account_group_id
801: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
802: where cert.certification_id = p_certification_id

Line 858: from amw_fin_key_acct_flat acc

854: -- connect by parent_natural_account_id = PRIOR natural_account_id and
855: -- account_group_id = PRIOR account_group_id)
856:
857: ( select distinct acc.child_natural_account_id
858: from amw_fin_key_acct_flat acc
859: where ( acc.parent_natural_account_id, acc.account_group_id ) in
860: ( select natural_account_id, account_group_id
861: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
862: where cert.certification_id = p_certification_id

Line 919: from amw_fin_key_acct_flat acc

915: -- connect by parent_natural_account_id = PRIOR natural_account_id and
916: -- account_group_id = PRIOR account_group_id)
917:
918: ( select distinct acc.child_natural_account_id
919: from amw_fin_key_acct_flat acc
920: where ( acc.parent_natural_account_id, acc.account_group_id ) in
921: ( select natural_account_id, account_group_id
922: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
923: where cert.certification_id = p_certification_id

Line 978: from amw_fin_key_acct_flat acc

974: -- connect by parent_natural_account_id = PRIOR natural_account_id and
975: -- account_group_id = PRIOR account_group_id)
976:
977: ( select distinct acc.child_natural_account_id
978: from amw_fin_key_acct_flat acc
979: where ( acc.parent_natural_account_id, acc.account_group_id ) in
980: ( select natural_account_id, account_group_id
981: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
982: where cert.certification_id = p_certification_id

Line 1043: from amw_fin_key_acct_flat acc

1039: -- connect by parent_natural_account_id = PRIOR natural_account_id and
1040: -- account_group_id = PRIOR account_group_id)
1041:
1042: ( select distinct acc.child_natural_account_id
1043: from amw_fin_key_acct_flat acc
1044: where ( acc.parent_natural_account_id, acc.account_group_id ) in
1045: ( select natural_account_id, account_group_id
1046: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
1047: where cert.certification_id = p_certification_id

Line 1111: from amw_fin_key_acct_flat acc

1107: -- connect by parent_natural_account_id = PRIOR natural_account_id and
1108: -- account_group_id = PRIOR account_group_id)
1109:
1110: ( select distinct acc.child_natural_account_id
1111: from amw_fin_key_acct_flat acc
1112: where ( acc.parent_natural_account_id, acc.account_group_id ) in
1113: ( select natural_account_id, account_group_id
1114: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
1115: where cert.certification_id = p_certification_id

Line 1184: from amw_fin_key_acct_flat acc

1180: -- connect by parent_natural_account_id = PRIOR natural_account_id and
1181: -- account_group_id = PRIOR account_group_id)
1182:
1183: ( select distinct acc.child_natural_account_id
1184: from amw_fin_key_acct_flat acc
1185: where ( acc.parent_natural_account_id, acc.account_group_id ) in
1186: ( select natural_account_id, account_group_id
1187: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
1188: where cert.certification_id = p_certification_id

Line 1255: from amw_fin_key_acct_flat acc

1251: -- connect by parent_natural_account_id = PRIOR natural_account_id and
1252: -- account_group_id = PRIOR account_group_id)
1253:
1254: ( select distinct acc.child_natural_account_id
1255: from amw_fin_key_acct_flat acc
1256: where ( acc.parent_natural_account_id, acc.account_group_id ) in
1257: ( select natural_account_id, account_group_id
1258: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
1259: where cert.certification_id = p_certification_id

Line 1311: from amw_fin_key_acct_flat acc

1307: -- connect by parent_natural_account_id = PRIOR natural_account_id and
1308: -- account_group_id = PRIOR account_group_id)
1309:
1310: ( select distinct acc.child_natural_account_id
1311: from amw_fin_key_acct_flat acc
1312: where ( acc.parent_natural_account_id, acc.account_group_id ) in
1313: ( select natural_account_id, account_group_id
1314: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc
1315: where cert.certification_id = p_certification_id

Line 1603: from AMW_FIN_KEY_ACCT_FLAT acc

1599: -- CONNECT BY PRIOR acc.natural_account_id = acc.parent_natural_account_id
1600: -- and PRIOR acc.account_group_id = acc.account_group_id)
1601:
1602: ( select distinct acc.child_natural_account_id
1603: from AMW_FIN_KEY_ACCT_FLAT 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

Line 2005: from AMW_FIN_KEY_ACCT_FLAT acc

2001: -- CONNECT BY PRIOR acc.natural_account_id = acc.parent_natural_account_id
2002: -- and PRIOR acc.account_group_id = acc.account_group_id)
2003:
2004: ( select distinct acc.child_natural_account_id
2005: from AMW_FIN_KEY_ACCT_FLAT 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

Line 2272: from AMW_FIN_KEY_ACCT_FLAT acc

2268: -- CONNECT BY PRIOR acc.natural_account_id = acc.parent_natural_account_id
2269: -- and PRIOR acc.account_group_id = acc.account_group_id)
2270:
2271: ( select distinct acc.child_natural_account_id
2272: from AMW_FIN_KEY_ACCT_FLAT 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

Line 2322: from amw_fin_key_acct_flat acc

2318: -- CONNECT BY PRIOR acc.natural_account_id = acc.parent_natural_account_id
2319: -- and PRIOR acc.account_group_id = acc.account_group_id)
2320:
2321: ( select distinct acc.child_natural_account_id
2322: from amw_fin_key_acct_flat acc
2323: where ( acc.parent_natural_account_id, acc.account_group_id ) in
2324: ( select natural_account_id, account_group_id
2325: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika
2326: where cert.certification_id = p_certification_id

Line 2374: from amw_fin_key_acct_flat acc

2370: -- CONNECT BY PRIOR acc.natural_account_id = acc.parent_natural_account_id
2371: -- and PRIOR acc.account_group_id = acc.account_group_id)
2372:
2373: ( select distinct acc.child_natural_account_id
2374: from amw_fin_key_acct_flat acc
2375: where ( acc.parent_natural_account_id, acc.account_group_id ) in
2376: ( select natural_account_id, account_group_id
2377: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika
2378: where cert.certification_id = p_certification_id

Line 2442: from amw_fin_key_acct_flat acc

2438: -- CONNECT BY PRIOR acc.natural_account_id = acc.parent_natural_account_id
2439: -- and PRIOR acc.account_group_id = acc.account_group_id)
2440:
2441: ( select distinct acc.child_natural_account_id
2442: from amw_fin_key_acct_flat acc
2443: where ( acc.parent_natural_account_id, acc.account_group_id ) in
2444: ( select natural_account_id, account_group_id
2445: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika
2446: where cert.certification_id = p_certification_id

Line 2509: from amw_fin_key_acct_flat acc

2505: -- CONNECT BY PRIOR acc.natural_account_id = acc.parent_natural_account_id
2506: -- and PRIOR acc.account_group_id = acc.account_group_id)
2507:
2508: ( select distinct acc.child_natural_account_id
2509: from amw_fin_key_acct_flat acc
2510: where ( acc.parent_natural_account_id, acc.account_group_id ) in
2511: ( select natural_account_id, account_group_id
2512: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika
2513: where cert.certification_id = p_certification_id

Line 2573: from amw_fin_key_acct_flat acc

2569: -- CONNECT BY PRIOR acc.natural_account_id = acc.parent_natural_account_id
2570: -- and PRIOR acc.account_group_id = acc.account_group_id)
2571:
2572: ( select distinct acc.child_natural_account_id
2573: from amw_fin_key_acct_flat acc
2574: where ( acc.parent_natural_account_id, acc.account_group_id ) in
2575: ( select natural_account_id, account_group_id
2576: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika
2577: where cert.certification_id = p_certification_id

Line 2640: from amw_fin_key_acct_flat acc

2636: -- CONNECT BY PRIOR acc.natural_account_id = acc.parent_natural_account_id
2637: -- and PRIOR acc.account_group_id = acc.account_group_id)
2638:
2639: ( select distinct acc.child_natural_account_id
2640: from amw_fin_key_acct_flat acc
2641: where ( acc.parent_natural_account_id, acc.account_group_id ) in
2642: ( select natural_account_id, account_group_id
2643: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika
2644: where cert.certification_id = p_certification_id

Line 2699: from amw_fin_key_acct_flat acc

2695: -- CONNECT BY PRIOR acc.natural_account_id = acc.parent_natural_account_id
2696: -- and PRIOR acc.account_group_id = acc.account_group_id)
2697:
2698: ( select distinct acc.child_natural_account_id
2699: from amw_fin_key_acct_flat acc
2700: where ( acc.parent_natural_account_id, acc.account_group_id ) in
2701: ( select natural_account_id, account_group_id
2702: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika
2703: where cert.certification_id = p_certification_id

Line 2768: from amw_fin_key_acct_flat acc

2764: -- CONNECT BY PRIOR acc.natural_account_id = acc.parent_natural_account_id
2765: -- and PRIOR acc.account_group_id = acc.account_group_id)
2766:
2767: ( select distinct acc.child_natural_account_id
2768: from amw_fin_key_acct_flat acc
2769: where ( acc.parent_natural_account_id, acc.account_group_id ) in
2770: ( select natural_account_id, account_group_id
2771: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika
2772: where cert.certification_id = p_certification_id

Line 3044: from AMW_FIN_KEY_ACCT_FLAT acc

3040: -- CONNECT BY PRIOR acc.natural_account_id = acc.parent_natural_account_id
3041: -- and PRIOR acc.account_group_id = acc.account_group_id)
3042:
3043: ( select distinct acc.child_natural_account_id
3044: from AMW_FIN_KEY_ACCT_FLAT 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

Line 3089: from AMW_FIN_KEY_ACCT_FLAT acc

3085: -- CONNECT BY PRIOR acc.natural_account_id = acc.parent_natural_account_id
3086: -- and PRIOR acc.account_group_id = acc.account_group_id)
3087:
3088: ( select distinct acc.child_natural_account_id
3089: from AMW_FIN_KEY_ACCT_FLAT 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

Line 4779: from AMW_FIN_KEY_ACCT_FLAT acc

4775: -- and PRIOR
4776: --acc.account_group_id = acc.account_group_id)
4777:
4778: ( select distinct acc.child_natural_account_id
4779: from AMW_FIN_KEY_ACCT_FLAT 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

Line 4848: from AMW_FIN_KEY_ACCT_FLAT acc

4844: -- and PRIOR
4845: --acc.account_group_id = acc.account_group_id)
4846:
4847: ( select distinct acc.child_natural_account_id
4848: from AMW_FIN_KEY_ACCT_FLAT 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

Line 4931: from AMW_FIN_KEY_ACCT_FLAT acc

4927: -- and PRIOR
4928: --acc.account_group_id = acc.account_group_id)
4929:
4930: ( select distinct acc.child_natural_account_id
4931: from AMW_FIN_KEY_ACCT_FLAT 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

Line 5012: from AMW_FIN_KEY_ACCT_FLAT acc

5008: -- and PRIOR
5009: --acc.account_group_id = acc.account_group_id)
5010:
5011: ( select distinct acc.child_natural_account_id
5012: from AMW_FIN_KEY_ACCT_FLAT 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

Line 5089: from AMW_FIN_KEY_ACCT_FLAT acc

5085: -- and PRIOR
5086: --acc.account_group_id = acc.account_group_id)
5087:
5088: ( select distinct acc.child_natural_account_id
5089: from AMW_FIN_KEY_ACCT_FLAT 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

Line 5168: from AMW_FIN_KEY_ACCT_FLAT acc

5164: -- and PRIOR
5165: --acc.account_group_id = acc.account_group_id)
5166:
5167: ( select distinct acc.child_natural_account_id
5168: from AMW_FIN_KEY_ACCT_FLAT 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

Line 5216: from AMW_FIN_KEY_ACCT_FLAT acc

5212: -- and PRIOR
5213: --acc.account_group_id = acc.account_group_id)
5214:
5215: ( select distinct acc.child_natural_account_id
5216: from AMW_FIN_KEY_ACCT_FLAT 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

Line 5284: from AMW_FIN_KEY_ACCT_FLAT acc

5280: -- and PRIOR
5281: --acc.account_group_id = acc.account_group_id)
5282:
5283: ( select distinct acc.child_natural_account_id
5284: from AMW_FIN_KEY_ACCT_FLAT 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

Line 5370: from AMW_FIN_KEY_ACCT_FLAT acc

5366: -- and PRIOR
5367: --acc.account_group_id = acc.account_group_id)
5368:
5369: ( select distinct acc.child_natural_account_id
5370: from AMW_FIN_KEY_ACCT_FLAT 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

Line 5449: from AMW_FIN_KEY_ACCT_FLAT acc

5445: -- acc.natural_account_id = acc.parent_natural_account_id and PRIOR
5446: --acc.account_group_id = acc.account_group_id)
5447:
5448: ( select distinct acc.child_natural_account_id
5449: from AMW_FIN_KEY_ACCT_FLAT 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

Line 5542: from AMW_FIN_KEY_ACCT_FLAT acc

5538: -- and PRIOR
5539: --acc.account_group_id = acc.account_group_id)
5540:
5541: ( select distinct acc.child_natural_account_id
5542: from AMW_FIN_KEY_ACCT_FLAT 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

Line 5631: from AMW_FIN_KEY_ACCT_FLAT acc

5627: -- and PRIOR
5628: --acc.account_group_id = acc.account_group_id)
5629:
5630: ( select distinct acc.child_natural_account_id
5631: from AMW_FIN_KEY_ACCT_FLAT 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

Line 5688: from AMW_FIN_KEY_ACCT_FLAT acc

5684: -- and PRIOR
5685: --acc.account_group_id = acc.account_group_id)
5686:
5687: ( select distinct acc.child_natural_account_id
5688: from AMW_FIN_KEY_ACCT_FLAT 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

Line 5766: from AMW_FIN_KEY_ACCT_FLAT acc

5762: -- and PRIOR
5763: --acc.account_group_id = acc.account_group_id)
5764:
5765: ( select distinct acc.child_natural_account_id
5766: from AMW_FIN_KEY_ACCT_FLAT 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

Line 5830: from AMW_FIN_KEY_ACCT_FLAT acc

5826: -- and PRIOR
5827: --acc.account_group_id = acc.account_group_id)
5828:
5829: ( select distinct acc.child_natural_account_id
5830: from AMW_FIN_KEY_ACCT_FLAT 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

Line 5910: from AMW_FIN_KEY_ACCT_FLAT acc

5906: -- and PRIOR
5907: --acc.account_group_id = acc.account_group_id)
5908:
5909: ( select distinct acc.child_natural_account_id
5910: from AMW_FIN_KEY_ACCT_FLAT 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

Line 5972: from amw_fin_key_acct_flat acc

5968: -- and PRIOR
5969: --acc.account_group_id = acc.account_group_id) -- end of acc
5970:
5971: ( select distinct acc.child_natural_account_id
5972: from amw_fin_key_acct_flat acc
5973: where ( acc.parent_natural_account_id, acc.account_group_id ) in
5974: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
5975: from amw_fin_items_key_acc finkeyacc
5976: where finkeyacc.statement_group_id = p_statement_group_id

Line 6091: from amw_fin_key_acct_flat acc

6087: -- and PRIOR
6088: --acc.account_group_id = acc.account_group_id) -- end of acc
6089:
6090: ( select distinct acc.child_natural_account_id
6091: from amw_fin_key_acct_flat acc
6092: where ( acc.parent_natural_account_id, acc.account_group_id ) in
6093: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
6094: from amw_fin_items_key_acc finkeyacc
6095: where finkeyacc.statement_group_id = p_statement_group_id

Line 6227: from amw_fin_key_acct_flat acc

6223: -- and PRIOR
6224: --acc.account_group_id = acc.account_group_id) -- end of acc
6225:
6226: ( select distinct acc.child_natural_account_id
6227: from amw_fin_key_acct_flat acc
6228: where ( acc.parent_natural_account_id, acc.account_group_id ) in
6229: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
6230: from amw_fin_items_key_acc finkeyacc
6231: where finkeyacc.statement_group_id = p_statement_group_id

Line 6360: from amw_fin_key_acct_flat acc

6356: -- and PRIOR
6357: --acc.account_group_id = acc.account_group_id) -- end of acc
6358:
6359: ( select distinct acc.child_natural_account_id
6360: from amw_fin_key_acct_flat acc
6361: where ( acc.parent_natural_account_id, acc.account_group_id ) in
6362: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
6363: from amw_fin_items_key_acc finkeyacc
6364: where finkeyacc.statement_group_id = p_statement_group_id

Line 6494: from amw_fin_key_acct_flat acc

6490: -- and PRIOR
6491: --acc.account_group_id = acc.account_group_id) -- end of acc
6492:
6493: ( select distinct acc.child_natural_account_id
6494: from amw_fin_key_acct_flat acc
6495: where ( acc.parent_natural_account_id, acc.account_group_id ) in
6496: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
6497: from amw_fin_items_key_acc finkeyacc
6498: where finkeyacc.statement_group_id = p_statement_group_id

Line 6599: from amw_fin_key_acct_flat acc

6595: -- and PRIOR
6596: --acc.account_group_id = acc.account_group_id) -- end of acc
6597:
6598: ( select distinct acc.child_natural_account_id
6599: from amw_fin_key_acct_flat acc
6600: where ( acc.parent_natural_account_id, acc.account_group_id ) in
6601: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
6602: from amw_fin_items_key_acc finkeyacc
6603: where finkeyacc.statement_group_id = p_statement_group_id

Line 6719: from amw_fin_key_acct_flat acc

6715: -- and PRIOR
6716: --acc.account_group_id = acc.account_group_id) -- end of acc
6717:
6718: ( select distinct acc.child_natural_account_id
6719: from amw_fin_key_acct_flat acc
6720: where ( acc.parent_natural_account_id, acc.account_group_id ) in
6721: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
6722: from amw_fin_items_key_acc finkeyacc
6723: where finkeyacc.statement_group_id = p_statement_group_id

Line 6849: from amw_fin_key_acct_flat acc

6845: -- and PRIOR
6846: --acc.account_group_id = acc.account_group_id) -- end of acc
6847:
6848: ( select distinct acc.child_natural_account_id
6849: from amw_fin_key_acct_flat acc
6850: where ( acc.parent_natural_account_id, acc.account_group_id ) in
6851: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
6852: from amw_fin_items_key_acc finkeyacc
6853: where finkeyacc.statement_group_id = p_statement_group_id

Line 6981: from amw_fin_key_acct_flat acc

6977: -- and PRIOR
6978: --acc.account_group_id = acc.account_group_id) -- end of acc
6979:
6980: ( select distinct acc.child_natural_account_id
6981: from amw_fin_key_acct_flat acc
6982: where ( acc.parent_natural_account_id, acc.account_group_id ) in
6983: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
6984: from amw_fin_items_key_acc finkeyacc
6985: where finkeyacc.statement_group_id = p_statement_group_id

Line 7129: from amw_fin_key_acct_flat acc

7125: -- and PRIOR
7126: --acc.account_group_id = acc.account_group_id) -- end of acc
7127:
7128: ( select distinct acc.child_natural_account_id
7129: from amw_fin_key_acct_flat acc
7130: where ( acc.parent_natural_account_id, acc.account_group_id ) in
7131: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
7132: from amw_fin_items_key_acc finkeyacc
7133: where finkeyacc.statement_group_id = p_statement_group_id

Line 7272: from amw_fin_key_acct_flat acc

7268: -- and PRIOR
7269: --acc.account_group_id = acc.account_group_id) -- end of acc
7270:
7271: ( select distinct acc.child_natural_account_id
7272: from amw_fin_key_acct_flat acc
7273: where ( acc.parent_natural_account_id, acc.account_group_id ) in
7274: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
7275: from amw_fin_items_key_acc finkeyacc
7276: where finkeyacc.statement_group_id = p_statement_group_id

Line 7382: from amw_fin_key_acct_flat acc

7378: -- and PRIOR
7379: --acc.account_group_id = acc.account_group_id) -- end of acc
7380:
7381: ( select distinct acc.child_natural_account_id
7382: from amw_fin_key_acct_flat acc
7383: where ( acc.parent_natural_account_id, acc.account_group_id ) in
7384: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
7385: from amw_fin_items_key_acc finkeyacc
7386: where finkeyacc.statement_group_id = p_statement_group_id

Line 7509: from amw_fin_key_acct_flat acc

7505: -- and PRIOR
7506: --acc.account_group_id = acc.account_group_id) -- end of acc
7507:
7508: ( select distinct acc.child_natural_account_id
7509: from amw_fin_key_acct_flat acc
7510: where ( acc.parent_natural_account_id, acc.account_group_id ) in
7511: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
7512: from amw_fin_items_key_acc finkeyacc
7513: where finkeyacc.statement_group_id = p_statement_group_id

Line 7626: from amw_fin_key_acct_flat acc

7622: -- and PRIOR
7623: --acc.account_group_id = acc.account_group_id) -- end of acc
7624:
7625: ( select distinct acc.child_natural_account_id
7626: from amw_fin_key_acct_flat acc
7627: where ( acc.parent_natural_account_id, acc.account_group_id ) in
7628: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
7629: from amw_fin_items_key_acc finkeyacc
7630: where finkeyacc.statement_group_id = p_statement_group_id

Line 7756: from amw_fin_key_acct_flat acc

7752: -- and PRIOR
7753: --acc.account_group_id = acc.account_group_id) -- end of acc
7754:
7755: ( select distinct acc.child_natural_account_id
7756: from amw_fin_key_acct_flat acc
7757: where ( acc.parent_natural_account_id, acc.account_group_id ) in
7758: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
7759: from amw_fin_items_key_acc finkeyacc
7760: where finkeyacc.statement_group_id = p_statement_group_id

Line 7883: from amw_fin_key_acct_flat acc

7879: -- and PRIOR
7880: --acc.account_group_id = acc.account_group_id) -- end of acc
7881:
7882: ( select distinct acc.child_natural_account_id
7883: from amw_fin_key_acct_flat acc
7884: where ( acc.parent_natural_account_id, acc.account_group_id ) in
7885: ( select finkeyacc.natural_account_id, finkeyacc.account_group_id
7886: from amw_fin_items_key_acc finkeyacc
7887: where finkeyacc.statement_group_id = p_statement_group_id