eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMW_FINSTMT_CERT_PVT dependencies on AMW_FIN_ITEMS_KEY_ACC

Line 454: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc,

450:
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

Line 587: -- from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
589: -- cert.object_type = 'FIN_STMT' and
590: -- cert.statement_group_id = key_acc.statement_group_id and
591: -- cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID)

Line 605: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
607: and cert.object_type = 'FIN_STMT'
608: and cert.statement_group_id = key_acc.statement_group_id
609: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID

Line 616: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
618: and cert.object_type = 'FIN_STMT'
619: and cert.statement_group_id = key_acc.statement_group_id
620: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID

Line 653: -- from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
655: -- cert.object_type = 'FIN_STMT' and
656: -- cert.statement_group_id = key_acc.statement_group_id and
657: -- cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID)

Line 665: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
667: and cert.object_type = 'FIN_STMT'
668: and cert.statement_group_id = key_acc.statement_group_id
669: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID

Line 676: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
678: and cert.object_type = 'FIN_STMT'
679: and cert.statement_group_id = key_acc.statement_group_id
680: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID

Line 725: -- from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
727: -- cert.object_type = 'FIN_STMT' and
728: -- cert.statement_group_id = key_acc.statement_group_id and
729: -- cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID)

Line 737: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
739: and cert.object_type = 'FIN_STMT'
740: and cert.statement_group_id = key_acc.statement_group_id
741: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID

Line 748: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
750: and cert.object_type = 'FIN_STMT'
751: and cert.statement_group_id = key_acc.statement_group_id
752: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID

Line 789: -- from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
791: -- cert.object_type = 'FIN_STMT' and
792: -- cert.statement_group_id = key_acc.statement_group_id and
793: -- cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID)

Line 801: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
803: and cert.object_type = 'FIN_STMT'
804: and cert.statement_group_id = key_acc.statement_group_id
805: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID

Line 812: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
814: and cert.object_type = 'FIN_STMT'
815: and cert.statement_group_id = key_acc.statement_group_id
816: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID

Line 849: -- from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
851: -- cert.object_type = 'FIN_STMT' and
852: -- cert.statement_group_id = key_acc.statement_group_id and
853: -- cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID)

Line 861: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
863: and cert.object_type = 'FIN_STMT'
864: and cert.statement_group_id = key_acc.statement_group_id
865: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID

Line 872: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
874: and cert.object_type = 'FIN_STMT'
875: and cert.statement_group_id = key_acc.statement_group_id
876: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID

Line 910: -- from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
912: -- cert.object_type = 'FIN_STMT' and
913: -- cert.statement_group_id = key_acc.statement_group_id and
914: -- cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID)

Line 922: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
924: and cert.object_type = 'FIN_STMT'
925: and cert.statement_group_id = key_acc.statement_group_id
926: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID

Line 933: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
935: and cert.object_type = 'FIN_STMT'
936: and cert.statement_group_id = key_acc.statement_group_id
937: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID

Line 969: -- from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
971: -- cert.object_type = 'FIN_STMT' and
972: -- cert.statement_group_id = key_acc.statement_group_id and
973: -- cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID)

Line 981: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
983: and cert.object_type = 'FIN_STMT'
984: and cert.statement_group_id = key_acc.statement_group_id
985: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID

Line 992: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
994: and cert.object_type = 'FIN_STMT'
995: and cert.statement_group_id = key_acc.statement_group_id
996: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID

Line 1034: -- from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
1036: -- cert.object_type = 'FIN_STMT' and
1037: -- cert.statement_group_id = key_acc.statement_group_id and
1038: -- cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID)

Line 1046: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
1048: and cert.object_type = 'FIN_STMT'
1049: and cert.statement_group_id = key_acc.statement_group_id
1050: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID

Line 1057: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
1059: and cert.object_type = 'FIN_STMT'
1060: and cert.statement_group_id = key_acc.statement_group_id
1061: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID

Line 1102: -- from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
1104: -- cert.object_type = 'FIN_STMT' and
1105: -- cert.statement_group_id = key_acc.statement_group_id and
1106: -- cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID)

Line 1114: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
1116: and cert.object_type = 'FIN_STMT'
1117: and cert.statement_group_id = key_acc.statement_group_id
1118: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID

Line 1125: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
1127: and cert.object_type = 'FIN_STMT'
1128: and cert.statement_group_id = key_acc.statement_group_id
1129: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID

Line 1175: -- from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
1177: -- cert.object_type = 'FIN_STMT' and
1178: -- cert.statement_group_id = key_acc.statement_group_id and
1179: -- cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID)

Line 1187: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
1189: and cert.object_type = 'FIN_STMT'
1190: and cert.statement_group_id = key_acc.statement_group_id
1191: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID

Line 1198: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
1200: and cert.object_type = 'FIN_STMT'
1201: and cert.statement_group_id = key_acc.statement_group_id
1202: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID

Line 1246: -- from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
1248: -- cert.object_type = 'FIN_STMT' and
1249: -- cert.statement_group_id = key_acc.statement_group_id and
1250: -- cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID)

Line 1258: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
1260: and cert.object_type = 'FIN_STMT'
1261: and cert.statement_group_id = key_acc.statement_group_id
1262: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID

Line 1269: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
1271: and cert.object_type = 'FIN_STMT'
1272: and cert.statement_group_id = key_acc.statement_group_id
1273: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID

Line 1302: -- from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
1304: -- cert.object_type = 'FIN_STMT' and
1305: -- cert.statement_group_id = key_acc.statement_group_id and
1306: -- cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID)

Line 1314: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
1316: and cert.object_type = 'FIN_STMT'
1317: and cert.statement_group_id = key_acc.statement_group_id
1318: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID

Line 1325: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC key_acc

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
1327: and cert.object_type = 'FIN_STMT'
1328: and cert.statement_group_id = key_acc.statement_group_id
1329: and cert.financial_statement_id = key_acc.FINANCIAL_STATEMENT_ID

Line 1589: AMW_FIN_ITEMS_KEY_ACC fika,

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'
1593: AND aa.pk1 = po.process_organization_id

Line 1990: AMW_FIN_ITEMS_KEY_ACC fika,

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'
1994: AND aa.pk1 = po.process_organization_id

Line 2249: AMW_FIN_ITEMS_KEY_ACC fika,

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
2253: WHERE aa.object_type = 'PROCESS_ORG'

Line 2313: -- from AMW_FIN_ITEMS_KEY_ACC fika,

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
2315: -- where fika.statement_group_id = cert.statement_group_id
2316: -- AND fika.financial_statement_id = cert.financial_statement_id
2317: -- AND cert.certification_id = p_certification_id))

Line 2325: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika

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
2327: and cert.statement_group_id = fika.statement_group_id
2328: and cert.financial_statement_id = fika.FINANCIAL_STATEMENT_ID
2329: )

Line 2335: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika

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
2337: and cert.statement_group_id = fika.statement_group_id
2338: and cert.financial_statement_id = fika.FINANCIAL_STATEMENT_ID
2339: )

Line 2365: -- from AMW_FIN_ITEMS_KEY_ACC fika,

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
2367: -- where fika.statement_group_id = cert.statement_group_id
2368: -- AND fika.financial_statement_id = cert.financial_statement_id
2369: -- AND cert.certification_id = p_certification_id))

Line 2377: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika

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
2379: and cert.statement_group_id = fika.statement_group_id
2380: and cert.financial_statement_id = fika.FINANCIAL_STATEMENT_ID
2381: )

Line 2387: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika

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
2389: and cert.statement_group_id = fika.statement_group_id
2390: and cert.financial_statement_id = fika.FINANCIAL_STATEMENT_ID
2391: )

Line 2433: -- from AMW_FIN_ITEMS_KEY_ACC fika,

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
2435: -- where fika.statement_group_id = cert.statement_group_id
2436: -- AND fika.financial_statement_id = cert.financial_statement_id
2437: -- AND cert.certification_id = p_certification_id))

Line 2445: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika

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
2447: and cert.statement_group_id = fika.statement_group_id
2448: and cert.financial_statement_id = fika.FINANCIAL_STATEMENT_ID
2449: )

Line 2455: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika

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
2457: and cert.statement_group_id = fika.statement_group_id
2458: and cert.financial_statement_id = fika.FINANCIAL_STATEMENT_ID
2459: )

Line 2500: -- from AMW_FIN_ITEMS_KEY_ACC fika,

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
2502: -- where fika.statement_group_id = cert.statement_group_id
2503: -- AND fika.financial_statement_id = cert.financial_statement_id
2504: -- AND cert.certification_id = p_certification_id))

Line 2512: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika

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
2514: and cert.statement_group_id = fika.statement_group_id
2515: and cert.financial_statement_id = fika.FINANCIAL_STATEMENT_ID
2516: )

Line 2522: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika

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
2524: and cert.statement_group_id = fika.statement_group_id
2525: and cert.financial_statement_id = fika.FINANCIAL_STATEMENT_ID
2526: )

Line 2564: -- from AMW_FIN_ITEMS_KEY_ACC fika,

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
2566: -- where fika.statement_group_id = cert.statement_group_id
2567: -- AND fika.financial_statement_id = cert.financial_statement_id
2568: -- AND cert.certification_id = p_certification_id))

Line 2576: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika

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
2578: and cert.statement_group_id = fika.statement_group_id
2579: and cert.financial_statement_id = fika.FINANCIAL_STATEMENT_ID
2580: )

Line 2586: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika

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
2588: and cert.statement_group_id = fika.statement_group_id
2589: and cert.financial_statement_id = fika.FINANCIAL_STATEMENT_ID
2590: )

Line 2631: -- from AMW_FIN_ITEMS_KEY_ACC fika,

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
2633: -- where fika.statement_group_id = cert.statement_group_id
2634: -- AND fika.financial_statement_id = cert.financial_statement_id
2635: -- AND cert.certification_id = p_certification_id))

Line 2643: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika

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
2645: and cert.statement_group_id = fika.statement_group_id
2646: and cert.financial_statement_id = fika.FINANCIAL_STATEMENT_ID
2647: )

Line 2653: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika

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
2655: and cert.statement_group_id = fika.statement_group_id
2656: and cert.financial_statement_id = fika.FINANCIAL_STATEMENT_ID
2657: )

Line 2690: -- from AMW_FIN_ITEMS_KEY_ACC fika,

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
2692: -- where fika.statement_group_id = cert.statement_group_id
2693: -- AND fika.financial_statement_id = cert.financial_statement_id
2694: -- AND cert.certification_id = p_certification_id))

Line 2702: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika

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
2704: and cert.statement_group_id = fika.statement_group_id
2705: and cert.financial_statement_id = fika.FINANCIAL_STATEMENT_ID
2706: )

Line 2712: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika

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
2714: and cert.statement_group_id = fika.statement_group_id
2715: and cert.financial_statement_id = fika.FINANCIAL_STATEMENT_ID
2716: )

Line 2759: -- from AMW_FIN_ITEMS_KEY_ACC fika,

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
2761: -- where fika.statement_group_id = cert.statement_group_id
2762: -- AND fika.financial_statement_id = cert.financial_statement_id
2763: -- AND cert.certification_id = p_certification_id))

Line 2771: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika

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
2773: and cert.statement_group_id = fika.statement_group_id
2774: and cert.financial_statement_id = fika.FINANCIAL_STATEMENT_ID
2775: )

Line 2781: from amw_certification_b cert, AMW_FIN_ITEMS_KEY_ACC fika

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
2783: and cert.statement_group_id = fika.statement_group_id
2784: and cert.financial_statement_id = fika.FINANCIAL_STATEMENT_ID
2785: )

Line 3029: AMW_FIN_ITEMS_KEY_ACC fika,

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'
3033: AND aa.pk1 = po.process_organization_id

Line 3074: AMW_FIN_ITEMS_KEY_ACC fika,

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'
3078: AND aa.pk1 = po.process_organization_id

Line 3112: AMW_FIN_ITEMS_KEY_ACC fika,

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'
3116: AND aa.pk1 = po.process_organization_id

Line 3593: AMW_FIN_ITEMS_KEY_ACC finitemAcc

3589: FINANCIAL_STATEMENT_ID,
3590: FINANCIAL_ITEM_ID,
3591: NATURAL_ACCOUNT_ID
3592: from
3593: AMW_FIN_ITEMS_KEY_ACC finitemAcc
3594: where
3595: STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
3596: and FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
3597: and FINANCIAL_ITEM_ID = P_FINANCIAL_ITEM_ID

Line 3609: AMW_FIN_ITEMS_KEY_ACC finitemAcc2

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
3613: AND KeyAccChild2.NATURAL_ACCOUNT_ID = finitemAcc.NATURAL_ACCOUNT_ID

Line 3634: AMW_FIN_ITEMS_KEY_ACC

3630: FINANCIAL_STATEMENT_ID,
3631: FINANCIAL_ITEM_ID,
3632: NATURAL_ACCOUNT_ID
3633: from
3634: AMW_FIN_ITEMS_KEY_ACC
3635: where
3636: STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
3637: and FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
3638: and FINANCIAL_ITEM_ID = P_FINANCIAL_ITEM_ID ;

Line 5949: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc

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
5952: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
5953: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select

Line 5975: from amw_fin_items_key_acc finkeyacc

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
5977: and finkeyacc.financial_statement_id = p_financial_statement_id
5978: and finkeyacc.financial_item_id in
5979: ( select distinct item.child_financial_item_id

Line 5997: from amw_fin_items_key_acc finkeyacc

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
5999: and finkeyacc.financial_statement_id = p_financial_statement_id
6000: and finkeyacc.financial_item_id in
6001: ( select distinct item.child_financial_item_id

Line 6068: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc

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
6071: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
6072: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select

Line 6094: from amw_fin_items_key_acc finkeyacc

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
6096: and finkeyacc.financial_statement_id = p_financial_statement_id
6097: and finkeyacc.financial_item_id in
6098: ( select distinct item.child_financial_item_id

Line 6116: from amw_fin_items_key_acc finkeyacc

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
6118: and finkeyacc.financial_statement_id = p_financial_statement_id
6119: and finkeyacc.financial_item_id in
6120: ( select distinct item.child_financial_item_id

Line 6204: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc

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
6207: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
6208: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select

Line 6230: from amw_fin_items_key_acc finkeyacc

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
6232: and finkeyacc.financial_statement_id = p_financial_statement_id
6233: and finkeyacc.financial_item_id in
6234: ( select distinct item.child_financial_item_id

Line 6252: from amw_fin_items_key_acc finkeyacc

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
6254: and finkeyacc.financial_statement_id = p_financial_statement_id
6255: and finkeyacc.financial_item_id in
6256: ( select distinct item.child_financial_item_id

Line 6337: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc

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
6340: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
6341: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select

Line 6363: from amw_fin_items_key_acc finkeyacc

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
6365: and finkeyacc.financial_statement_id = p_financial_statement_id
6366: and finkeyacc.financial_item_id in
6367: ( select distinct item.child_financial_item_id

Line 6385: from amw_fin_items_key_acc finkeyacc

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
6387: and finkeyacc.financial_statement_id = p_financial_statement_id
6388: and finkeyacc.financial_item_id in
6389: ( select distinct item.child_financial_item_id

Line 6471: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc

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
6474: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
6475: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select

Line 6497: from amw_fin_items_key_acc finkeyacc

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
6499: and finkeyacc.financial_statement_id = p_financial_statement_id
6500: and finkeyacc.financial_item_id in
6501: ( select distinct item.child_financial_item_id

Line 6519: from amw_fin_items_key_acc finkeyacc

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
6521: and finkeyacc.financial_statement_id = p_financial_statement_id
6522: and finkeyacc.financial_item_id in
6523: ( select distinct item.child_financial_item_id

Line 6576: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc

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
6579: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
6580: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select

Line 6602: from amw_fin_items_key_acc finkeyacc

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
6604: and finkeyacc.financial_statement_id = p_financial_statement_id
6605: and finkeyacc.financial_item_id in
6606: ( select distinct item.child_financial_item_id

Line 6624: from amw_fin_items_key_acc finkeyacc

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
6626: and finkeyacc.financial_statement_id = p_financial_statement_id
6627: and finkeyacc.financial_item_id in
6628: ( select distinct item.child_financial_item_id

Line 6696: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc

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
6699: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
6700: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select

Line 6722: from amw_fin_items_key_acc finkeyacc

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
6724: and finkeyacc.financial_statement_id = p_financial_statement_id
6725: and finkeyacc.financial_item_id in
6726: ( select distinct item.child_financial_item_id

Line 6744: from amw_fin_items_key_acc finkeyacc

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
6746: and finkeyacc.financial_statement_id = p_financial_statement_id
6747: and finkeyacc.financial_item_id in
6748: ( select distinct item.child_financial_item_id

Line 6826: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc

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
6829: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
6830: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select

Line 6852: from amw_fin_items_key_acc finkeyacc

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
6854: and finkeyacc.financial_statement_id = p_financial_statement_id
6855: and finkeyacc.financial_item_id in
6856: ( select distinct item.child_financial_item_id

Line 6874: from amw_fin_items_key_acc finkeyacc

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
6876: and finkeyacc.financial_statement_id = p_financial_statement_id
6877: and finkeyacc.financial_item_id in
6878: ( select distinct item.child_financial_item_id

Line 6958: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc

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
6961: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
6962: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select

Line 6984: from amw_fin_items_key_acc finkeyacc

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
6986: and finkeyacc.financial_statement_id = p_financial_statement_id
6987: and finkeyacc.financial_item_id in
6988: ( select distinct item.child_financial_item_id

Line 7006: from amw_fin_items_key_acc finkeyacc

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
7008: and finkeyacc.financial_statement_id = p_financial_statement_id
7009: and finkeyacc.financial_item_id in
7010: ( select distinct item.child_financial_item_id

Line 7106: --- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc

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
7109: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
7110: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select

Line 7132: from amw_fin_items_key_acc finkeyacc

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
7134: and finkeyacc.financial_statement_id = p_financial_statement_id
7135: and finkeyacc.financial_item_id in
7136: ( select distinct item.child_financial_item_id

Line 7154: from amw_fin_items_key_acc finkeyacc

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
7156: and finkeyacc.financial_statement_id = p_financial_statement_id
7157: and finkeyacc.financial_item_id in
7158: ( select distinct item.child_financial_item_id

Line 7249: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc

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
7252: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
7253: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select

Line 7275: from amw_fin_items_key_acc finkeyacc

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
7277: and finkeyacc.financial_statement_id = p_financial_statement_id
7278: and finkeyacc.financial_item_id in
7279: ( select distinct item.child_financial_item_id

Line 7297: from amw_fin_items_key_acc finkeyacc

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
7299: and finkeyacc.financial_statement_id = p_financial_statement_id
7300: and finkeyacc.financial_item_id in
7301: ( select distinct item.child_financial_item_id

Line 7359: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc

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
7362: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
7363: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select

Line 7385: from amw_fin_items_key_acc finkeyacc

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
7387: and finkeyacc.financial_statement_id = p_financial_statement_id
7388: and finkeyacc.financial_item_id in
7389: ( select distinct item.child_financial_item_id

Line 7407: from amw_fin_items_key_acc finkeyacc

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
7409: and finkeyacc.financial_statement_id = p_financial_statement_id
7410: and finkeyacc.financial_item_id in
7411: ( select distinct item.child_financial_item_id

Line 7486: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc

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
7489: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
7490: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select

Line 7512: from amw_fin_items_key_acc finkeyacc

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
7514: and finkeyacc.financial_statement_id = p_financial_statement_id
7515: and finkeyacc.financial_item_id in
7516: ( select distinct item.child_financial_item_id

Line 7534: from amw_fin_items_key_acc finkeyacc

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
7536: and finkeyacc.financial_statement_id = p_financial_statement_id
7537: and finkeyacc.financial_item_id in
7538: ( select distinct item.child_financial_item_id

Line 7603: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc

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
7606: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
7607: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select

Line 7629: from amw_fin_items_key_acc finkeyacc

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
7631: and finkeyacc.financial_statement_id = p_financial_statement_id
7632: and finkeyacc.financial_item_id in
7633: ( select distinct item.child_financial_item_id

Line 7651: from amw_fin_items_key_acc finkeyacc

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
7653: and finkeyacc.financial_statement_id = p_financial_statement_id
7654: and finkeyacc.financial_item_id in
7655: ( select distinct item.child_financial_item_id

Line 7733: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc

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
7736: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
7737: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select

Line 7759: from amw_fin_items_key_acc finkeyacc

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
7761: and finkeyacc.financial_statement_id = p_financial_statement_id
7762: and finkeyacc.financial_item_id in
7763: ( select distinct item.child_financial_item_id

Line 7781: from amw_fin_items_key_acc finkeyacc

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
7783: and finkeyacc.financial_statement_id = p_financial_statement_id
7784: and finkeyacc.financial_item_id in
7785: ( select distinct item.child_financial_item_id

Line 7860: -- (select finkeyacc.NATURAL_ACCOUNT_ID,finkeyacc.account_group_id from AMW_FIN_ITEMS_KEY_ACC finkeyacc

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
7863: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
7864: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select

Line 7886: from amw_fin_items_key_acc finkeyacc

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
7888: and finkeyacc.financial_statement_id = p_financial_statement_id
7889: and finkeyacc.financial_item_id in
7890: ( select distinct item.child_financial_item_id

Line 7908: from amw_fin_items_key_acc finkeyacc

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
7910: and finkeyacc.financial_statement_id = p_financial_statement_id
7911: and finkeyacc.financial_item_id in
7912: ( select distinct item.child_financial_item_id