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_CERTIFICATION_B

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 1492: FROM AMW_CERTIFICATION_B cert, AMW_GL_PERIODS_V period

1488: IS
1489: -- select all processes in scope for the certification
1490: CURSOR c_cert IS
1491: SELECT cert.CERTIFICATION_ID, period.start_date
1492: FROM AMW_CERTIFICATION_B cert, AMW_GL_PERIODS_V period
1493: WHERE cert.object_type = 'FIN_STMT' and cert.certification_period_name = period.period_name
1494: AND cert.certification_period_set_name = period.period_set_name
1495: and cert.CERTIFICATION_STATUS in ('ACTIVE', 'DRAFT');
1496:

Line 1499: FROM AMW_CERTIFICATION_B cert, AMW_GL_PERIODS_V period

1495: and cert.CERTIFICATION_STATUS in ('ACTIVE', 'DRAFT');
1496:
1497: CURSOR c_start_date IS
1498: SELECT period.start_date
1499: FROM AMW_CERTIFICATION_B cert, AMW_GL_PERIODS_V period
1500: WHERE cert.object_type = 'FIN_STMT' and cert.certification_period_name = period.period_name
1501: AND cert.certification_period_set_name = period.period_set_name
1502: and cert.CERTIFICATION_STATUS in ('ACTIVE', 'DRAFT')
1503: AND cert.certification_id = p_certification_id;

Line 1591: AMW_CERTIFICATION_B cert

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
1594: AND aa.natural_account_id in
1595: -- (select acc.natural_account_id

Line 1872: FROM AMW_CERTIFICATION_B cert, AMW_GL_PERIODS_V period

1868:
1869: -- select all processes in scope for the certification
1870: CURSOR c_cert IS
1871: SELECT cert.CERTIFICATION_ID, period.start_date
1872: FROM AMW_CERTIFICATION_B cert, AMW_GL_PERIODS_V period
1873: WHERE cert.object_type = 'FIN_STMT' and cert.certification_period_name = period.period_name
1874: AND cert.certification_period_set_name = period.period_set_name
1875: and cert.CERTIFICATION_STATUS in ('ACTIVE', 'DRAFT');
1876:

Line 1971: FROM AMW_CERTIFICATION_B cert,

1967: IS
1968:
1969: CURSOR c_cert IS
1970: SELECT cert.certification_id, period.start_date,period.end_date
1971: FROM AMW_CERTIFICATION_B cert,
1972: AMW_GL_PERIODS_V period
1973: WHERE cert.certification_period_name = period.period_name
1974: AND cert.certification_period_set_name = period.period_set_name
1975: AND cert.object_type='FIN_STMT'

Line 1980: FROM AMW_CERTIFICATION_B cert,

1976: AND cert.certification_status in ('ACTIVE','DRAFT');
1977:
1978: CURSOR c_period_dates IS
1979: SELECT period.start_date,period.end_date
1980: FROM AMW_CERTIFICATION_B cert,
1981: AMW_GL_PERIODS_V period
1982: WHERE cert.certification_period_name = period.period_name
1983: AND cert.certification_period_set_name = period.period_set_name
1984: AND cert.certification_id = p_certification_id;

Line 1992: AMW_CERTIFICATION_B cert

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
1995: AND aa.natural_account_id in
1996:

Line 2250: AMW_CERTIFICATION_B cert,

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

Line 2314: -- AMW_CERTIFICATION_B cert

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))
2318: -- CONNECT BY PRIOR acc.natural_account_id = acc.parent_natural_account_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 2366: -- AMW_CERTIFICATION_B cert

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))
2370: -- CONNECT BY PRIOR acc.natural_account_id = acc.parent_natural_account_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 2434: -- AMW_CERTIFICATION_B cert

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))
2438: -- CONNECT BY PRIOR acc.natural_account_id = acc.parent_natural_account_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 2501: -- AMW_CERTIFICATION_B cert

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))
2505: -- CONNECT BY PRIOR acc.natural_account_id = acc.parent_natural_account_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 2565: -- AMW_CERTIFICATION_B cert

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))
2569: -- CONNECT BY PRIOR acc.natural_account_id = acc.parent_natural_account_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 2632: -- AMW_CERTIFICATION_B cert

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))
2636: -- CONNECT BY PRIOR acc.natural_account_id = acc.parent_natural_account_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 2691: -- AMW_CERTIFICATION_B cert

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))
2695: -- CONNECT BY PRIOR acc.natural_account_id = acc.parent_natural_account_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 2760: -- AMW_CERTIFICATION_B cert

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))
2764: -- CONNECT BY PRIOR acc.natural_account_id = acc.parent_natural_account_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 3009: FROM AMW_CERTIFICATION_B cert,

3005: IS
3006:
3007: CURSOR c_cert IS
3008: SELECT cert.certification_id, period.start_date, period.end_date
3009: FROM AMW_CERTIFICATION_B cert,
3010: AMW_GL_PERIODS_V period
3011: WHERE cert.certification_period_name = period.period_name
3012: AND cert.certification_period_set_name = period.period_set_name
3013: AND cert.object_type='FIN_STMT'

Line 3019: FROM AMW_CERTIFICATION_B cert,

3015:
3016:
3017: CURSOR c_period_date IS
3018: SELECT period.start_date, period.end_date
3019: FROM AMW_CERTIFICATION_B cert,
3020: AMW_GL_PERIODS_V period
3021: WHERE cert.certification_period_name = period.period_name
3022: AND cert.certification_period_set_name = period.period_set_name
3023: AND cert.certification_id = p_certification_id;

Line 3031: AMW_CERTIFICATION_B cert

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
3034: AND aa.natural_account_id in
3035:

Line 3076: AMW_CERTIFICATION_B cert

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
3079: AND aa.natural_account_id in
3080:

Line 3114: AMW_CERTIFICATION_B cert

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
3117: AND aa.natural_account_id = fika.natural_account_id
3118: AND fika.statement_group_id = cert.statement_group_id