[Home] [Help]
14: v_sob_name := FND_PROFILE.VALUE('GL_SET_OF_BKS_NAME');
15:
16: SELECT count(*)
17: INTO v_count
18: FROM fv_facts_attributes
19: WHERE set_of_books_id =v_sob;
20:
21: IF v_count > 0
22: THEN
24: errbuf := 'Table already seeded for Set of Books: '||v_sob_name;
25: retcode := -1;
26: ELSE
27:
28: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
29: SGL_ATTRIBUTES_ID,
30: FACTS_ACCT_NUMBER,
31: USSGL_ACCT_NUMBER,
32: BALANCE_TYPE,
53: LAST_UPDATE_DATE,
54: LAST_UPDATED_BY,
55: LAST_UPDATE_LOGIN)
56: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
57: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
58: '1010', -- facct account number
59: '1010', -- ussgl account number
60: 'E', -- balance type
61: 'N', -- authority type
81: sysdate, -- last update date
82: FND_GLOBAL.USER_ID, -- last updated by
83: FND_GLOBAL.USER_ID -- last updated login
84: );
85: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
86: SGL_ATTRIBUTES_ID,
87: FACTS_ACCT_NUMBER,
88: USSGL_ACCT_NUMBER,
89: BALANCE_TYPE,
110: LAST_UPDATE_DATE,
111: LAST_UPDATED_BY,
112: LAST_UPDATE_LOGIN)
113: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
114: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
115: '1110', -- facct account number
116: '1110', -- ussgl account number
117: 'E', -- balance type
118: 'N', -- authority type
139: FND_GLOBAL.USER_ID, -- last updated by
140: FND_GLOBAL.USER_ID -- last updated login
141: );
142:
143: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
144: SGL_ATTRIBUTES_ID,
145: FACTS_ACCT_NUMBER,
146: USSGL_ACCT_NUMBER,
147: BALANCE_TYPE,
168: LAST_UPDATE_DATE,
169: LAST_UPDATED_BY,
170: LAST_UPDATE_LOGIN)
171: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
172: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
173: '1120', -- facct account number
174: '1120', -- ussgl account number
175: 'E', -- balance type
176: 'N', -- authority type
196: sysdate, -- last update date
197: FND_GLOBAL.USER_ID, -- last updated by
198: FND_GLOBAL.USER_ID -- last updated login
199: );
200: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
201: SGL_ATTRIBUTES_ID,
202: FACTS_ACCT_NUMBER,
203: USSGL_ACCT_NUMBER,
204: BALANCE_TYPE,
225: LAST_UPDATE_DATE,
226: LAST_UPDATED_BY,
227: LAST_UPDATE_LOGIN)
228: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
229: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
230: '1130', -- facct account number
231: '1130', -- ussgl account number
232: 'E', -- balance type
233: 'N', -- authority type
253: sysdate, -- last update date
254: FND_GLOBAL.USER_ID, -- last updated by
255: FND_GLOBAL.USER_ID -- last updated login
256: );
257: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
258: SGL_ATTRIBUTES_ID,
259: FACTS_ACCT_NUMBER,
260: USSGL_ACCT_NUMBER,
261: BALANCE_TYPE,
282: LAST_UPDATE_DATE,
283: LAST_UPDATED_BY,
284: LAST_UPDATE_LOGIN)
285: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
286: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
287: '1190', -- facct account number
288: '1190', -- ussgl account number
289: 'E', -- balance type
290: 'N', -- authority type
311: FND_GLOBAL.USER_ID, -- last updated by
312: FND_GLOBAL.USER_ID -- last updated login
313: );
314:
315: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
316: SGL_ATTRIBUTES_ID,
317: FACTS_ACCT_NUMBER,
318: USSGL_ACCT_NUMBER,
319: BALANCE_TYPE,
340: LAST_UPDATE_DATE,
341: LAST_UPDATED_BY,
342: LAST_UPDATE_LOGIN)
343: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
344: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
345: '1195', -- facct account number
346: '1195', -- ussgl account number
347: 'E', -- balance type
348: 'N', -- authority type
368: sysdate, -- last update date
369: FND_GLOBAL.USER_ID, -- last updated by
370: FND_GLOBAL.USER_ID -- last updated login
371: );
372: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
373: SGL_ATTRIBUTES_ID,
374: FACTS_ACCT_NUMBER,
375: USSGL_ACCT_NUMBER,
376: BALANCE_TYPE,
397: LAST_UPDATE_DATE,
398: LAST_UPDATED_BY,
399: LAST_UPDATE_LOGIN)
400: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
401: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
402: '1200', -- facct account number
403: '1200', -- ussgl account number
404: 'E', -- balance type
405: 'N', -- authority type
425: sysdate, -- last update date
426: FND_GLOBAL.USER_ID, -- last updated by
427: FND_GLOBAL.USER_ID -- last updated login
428: );
429: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
430: SGL_ATTRIBUTES_ID,
431: FACTS_ACCT_NUMBER,
432: USSGL_ACCT_NUMBER,
433: BALANCE_TYPE,
454: LAST_UPDATE_DATE,
455: LAST_UPDATED_BY,
456: LAST_UPDATE_LOGIN)
457: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
458: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
459: '1310', -- facct account number
460: '1310', -- ussgl account number
461: 'E', -- balance type
462: 'N', -- authority type
482: sysdate, -- last update date
483: FND_GLOBAL.USER_ID, -- last updated by
484: FND_GLOBAL.USER_ID -- last updated login
485: );
486: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
487: SGL_ATTRIBUTES_ID,
488: FACTS_ACCT_NUMBER,
489: USSGL_ACCT_NUMBER,
490: BALANCE_TYPE,
511: LAST_UPDATE_DATE,
512: LAST_UPDATED_BY,
513: LAST_UPDATE_LOGIN)
514: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
515: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
516: '1319', -- facct account number
517: '1319', -- ussgl account number
518: 'E', -- balance type
519: 'N', -- authority type
539: sysdate, -- last update date
540: FND_GLOBAL.USER_ID, -- last updated by
541: FND_GLOBAL.USER_ID -- last updated login
542: );
543: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
544: SGL_ATTRIBUTES_ID,
545: FACTS_ACCT_NUMBER,
546: USSGL_ACCT_NUMBER,
547: BALANCE_TYPE,
568: LAST_UPDATE_DATE,
569: LAST_UPDATED_BY,
570: LAST_UPDATE_LOGIN)
571: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
572: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
573: '1320', -- facct account number
574: '1320', -- ussgl account number
575: 'E', -- balance type
576: 'N', -- authority type
596: sysdate, -- last update date
597: FND_GLOBAL.USER_ID, -- last updated by
598: FND_GLOBAL.USER_ID -- last updated login
599: );
600: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
601: SGL_ATTRIBUTES_ID,
602: FACTS_ACCT_NUMBER,
603: USSGL_ACCT_NUMBER,
604: BALANCE_TYPE,
625: LAST_UPDATE_DATE,
626: LAST_UPDATED_BY,
627: LAST_UPDATE_LOGIN)
628: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
629: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
630: '1325', -- facct account number
631: '1325', -- ussgl account number
632: 'E', -- balance type
633: 'N', -- authority type
653: sysdate, -- last update date
654: FND_GLOBAL.USER_ID, -- last updated by
655: FND_GLOBAL.USER_ID -- last updated login
656: );
657: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
658: SGL_ATTRIBUTES_ID,
659: FACTS_ACCT_NUMBER,
660: USSGL_ACCT_NUMBER,
661: BALANCE_TYPE,
682: LAST_UPDATE_DATE,
683: LAST_UPDATED_BY,
684: LAST_UPDATE_LOGIN)
685: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
686: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
687: '1329', -- facct account number
688: '1329', -- ussgl account number
689: 'E', -- balance type
690: 'N', -- authority type
710: sysdate, -- last update date
711: FND_GLOBAL.USER_ID, -- last updated by
712: FND_GLOBAL.USER_ID -- last updated login
713: );
714: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
715: SGL_ATTRIBUTES_ID,
716: FACTS_ACCT_NUMBER,
717: USSGL_ACCT_NUMBER,
718: BALANCE_TYPE,
739: LAST_UPDATE_DATE,
740: LAST_UPDATED_BY,
741: LAST_UPDATE_LOGIN)
742: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
743: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
744: '1330', -- facct account number
745: '1330', -- ussgl account number
746: 'E', -- balance type
747: 'N', -- authority type
767: sysdate, -- last update date
768: FND_GLOBAL.USER_ID, -- last updated by
769: FND_GLOBAL.USER_ID -- last updated login
770: );
771: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
772: SGL_ATTRIBUTES_ID,
773: FACTS_ACCT_NUMBER,
774: USSGL_ACCT_NUMBER,
775: BALANCE_TYPE,
796: LAST_UPDATE_DATE,
797: LAST_UPDATED_BY,
798: LAST_UPDATE_LOGIN)
799: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
800: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
801: '1335', -- facct account number
802: '1335', -- ussgl account number
803: 'E', -- balance type
804: 'N', -- authority type
824: sysdate, -- last update date
825: FND_GLOBAL.USER_ID, -- last updated by
826: FND_GLOBAL.USER_ID -- last updated login
827: );
828: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
829: SGL_ATTRIBUTES_ID,
830: FACTS_ACCT_NUMBER,
831: USSGL_ACCT_NUMBER,
832: BALANCE_TYPE,
853: LAST_UPDATE_DATE,
854: LAST_UPDATED_BY,
855: LAST_UPDATE_LOGIN)
856: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
857: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
858: '1340', -- facct account number
859: '1340', -- ussgl account number
860: 'E', -- balance type
861: 'N', -- authority type
881: sysdate, -- last update date
882: FND_GLOBAL.USER_ID, -- last updated by
883: FND_GLOBAL.USER_ID -- last updated login
884: );
885: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
886: SGL_ATTRIBUTES_ID,
887: FACTS_ACCT_NUMBER,
888: USSGL_ACCT_NUMBER,
889: BALANCE_TYPE,
910: LAST_UPDATE_DATE,
911: LAST_UPDATED_BY,
912: LAST_UPDATE_LOGIN)
913: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
914: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
915: '1349', -- facct account number
916: '1349', -- ussgl account number
917: 'E', -- balance type
918: 'N', -- authority type
938: sysdate, -- last update date
939: FND_GLOBAL.USER_ID, -- last updated by
940: FND_GLOBAL.USER_ID -- last updated login
941: );
942: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
943: SGL_ATTRIBUTES_ID,
944: FACTS_ACCT_NUMBER,
945: USSGL_ACCT_NUMBER,
946: BALANCE_TYPE,
967: LAST_UPDATE_DATE,
968: LAST_UPDATED_BY,
969: LAST_UPDATE_LOGIN)
970: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
971: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
972: '1350', -- facct account number
973: '1350', -- ussgl account number
974: 'E', -- balance type
975: 'N', -- authority type
995: sysdate, -- last update date
996: FND_GLOBAL.USER_ID, -- last updated by
997: FND_GLOBAL.USER_ID -- last updated login
998: );
999: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1000: SGL_ATTRIBUTES_ID,
1001: FACTS_ACCT_NUMBER,
1002: USSGL_ACCT_NUMBER,
1003: BALANCE_TYPE,
1024: LAST_UPDATE_DATE,
1025: LAST_UPDATED_BY,
1026: LAST_UPDATE_LOGIN)
1027: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1028: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1029: '1359', -- facct account number
1030: '1359', -- ussgl account number
1031: 'E', -- balance type
1032: 'N', -- authority type
1052: sysdate, -- last update date
1053: FND_GLOBAL.USER_ID, -- last updated by
1054: FND_GLOBAL.USER_ID -- last updated login
1055: );
1056: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1057: SGL_ATTRIBUTES_ID,
1058: FACTS_ACCT_NUMBER,
1059: USSGL_ACCT_NUMBER,
1060: BALANCE_TYPE,
1081: LAST_UPDATE_DATE,
1082: LAST_UPDATED_BY,
1083: LAST_UPDATE_LOGIN)
1084: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1085: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1086: '1360', -- facct account number
1087: '1360', -- ussgl account number
1088: 'E', -- balance type
1089: 'N', -- authority type
1109: sysdate, -- last update date
1110: FND_GLOBAL.USER_ID, -- last updated by
1111: FND_GLOBAL.USER_ID -- last updated login
1112: );
1113: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1114: SGL_ATTRIBUTES_ID,
1115: FACTS_ACCT_NUMBER,
1116: USSGL_ACCT_NUMBER,
1117: BALANCE_TYPE,
1138: LAST_UPDATE_DATE,
1139: LAST_UPDATED_BY,
1140: LAST_UPDATE_LOGIN)
1141: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1142: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1143: '1369', -- facct account number
1144: '1369', -- ussgl account number
1145: 'E', -- balance type
1146: 'N', -- authority type
1166: sysdate, -- last update date
1167: FND_GLOBAL.USER_ID, -- last updated by
1168: FND_GLOBAL.USER_ID -- last updated login
1169: );
1170: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1171: SGL_ATTRIBUTES_ID,
1172: FACTS_ACCT_NUMBER,
1173: USSGL_ACCT_NUMBER,
1174: BALANCE_TYPE,
1195: LAST_UPDATE_DATE,
1196: LAST_UPDATED_BY,
1197: LAST_UPDATE_LOGIN)
1198: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1199: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1200: '1399', -- facct account number
1201: '1399', -- ussgl account number
1202: 'E', -- balance type
1203: 'N', -- authority type
1223: sysdate, -- last update date
1224: FND_GLOBAL.USER_ID, -- last updated by
1225: FND_GLOBAL.USER_ID -- last updated login
1226: );
1227: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1228: SGL_ATTRIBUTES_ID,
1229: FACTS_ACCT_NUMBER,
1230: USSGL_ACCT_NUMBER,
1231: BALANCE_TYPE,
1252: LAST_UPDATE_DATE,
1253: LAST_UPDATED_BY,
1254: LAST_UPDATE_LOGIN)
1255: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1256: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1257: '1410', -- facct account number
1258: '1410', -- ussgl account number
1259: 'E', -- balance type
1260: 'N', -- authority type
1280: sysdate, -- last update date
1281: FND_GLOBAL.USER_ID, -- last updated by
1282: FND_GLOBAL.USER_ID -- last updated login
1283: );
1284: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1285: SGL_ATTRIBUTES_ID,
1286: FACTS_ACCT_NUMBER,
1287: USSGL_ACCT_NUMBER,
1288: BALANCE_TYPE,
1309: LAST_UPDATE_DATE,
1310: LAST_UPDATED_BY,
1311: LAST_UPDATE_LOGIN)
1312: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1313: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1314: '1450', -- facct account number
1315: '1450', -- ussgl account number
1316: 'E', -- balance type
1317: 'N', -- authority type
1338: FND_GLOBAL.USER_ID, -- last updated by
1339: FND_GLOBAL.USER_ID -- last updated login
1340: );
1341:
1342: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1343: SGL_ATTRIBUTES_ID,
1344: FACTS_ACCT_NUMBER,
1345: USSGL_ACCT_NUMBER,
1346: BALANCE_TYPE,
1367: LAST_UPDATE_DATE,
1368: LAST_UPDATED_BY,
1369: LAST_UPDATE_LOGIN)
1370: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1371: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1372: '1511', -- facct account number
1373: '1511', -- ussgl account number
1374: 'E', -- balance type
1375: 'N', -- authority type
1395: sysdate, -- last update date
1396: FND_GLOBAL.USER_ID, -- last updated by
1397: FND_GLOBAL.USER_ID -- last updated login
1398: );
1399: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1400: SGL_ATTRIBUTES_ID,
1401: FACTS_ACCT_NUMBER,
1402: USSGL_ACCT_NUMBER,
1403: BALANCE_TYPE,
1424: LAST_UPDATE_DATE,
1425: LAST_UPDATED_BY,
1426: LAST_UPDATE_LOGIN)
1427: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1428: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1429: '1512', -- facct account number
1430: '1512', -- ussgl account number
1431: 'E', -- balance type
1432: 'N', -- authority type
1452: sysdate, -- last update date
1453: FND_GLOBAL.USER_ID, -- last updated by
1454: FND_GLOBAL.USER_ID -- last updated login
1455: );
1456: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1457: SGL_ATTRIBUTES_ID,
1458: FACTS_ACCT_NUMBER,
1459: USSGL_ACCT_NUMBER,
1460: BALANCE_TYPE,
1481: LAST_UPDATE_DATE,
1482: LAST_UPDATED_BY,
1483: LAST_UPDATE_LOGIN)
1484: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1485: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1486: '1513', -- facct account number
1487: '1513', -- ussgl account number
1488: 'E', -- balance type
1489: 'N', -- authority type
1509: sysdate, -- last update date
1510: FND_GLOBAL.USER_ID, -- last updated by
1511: FND_GLOBAL.USER_ID -- last updated login
1512: );
1513: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1514: SGL_ATTRIBUTES_ID,
1515: FACTS_ACCT_NUMBER,
1516: USSGL_ACCT_NUMBER,
1517: BALANCE_TYPE,
1538: LAST_UPDATE_DATE,
1539: LAST_UPDATED_BY,
1540: LAST_UPDATE_LOGIN)
1541: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1542: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1543: '1521', -- facct account number
1544: '1521', -- ussgl account number
1545: 'E', -- balance type
1546: 'N', -- authority type
1566: sysdate, -- last update date
1567: FND_GLOBAL.USER_ID, -- last updated by
1568: FND_GLOBAL.USER_ID -- last updated login
1569: );
1570: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1571: SGL_ATTRIBUTES_ID,
1572: FACTS_ACCT_NUMBER,
1573: USSGL_ACCT_NUMBER,
1574: BALANCE_TYPE,
1595: LAST_UPDATE_DATE,
1596: LAST_UPDATED_BY,
1597: LAST_UPDATE_LOGIN)
1598: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1599: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1600: '1522', -- facct account number
1601: '1522', -- ussgl account number
1602: 'E', -- balance type
1603: 'N', -- authority type
1623: sysdate, -- last update date
1624: FND_GLOBAL.USER_ID, -- last updated by
1625: FND_GLOBAL.USER_ID -- last updated login
1626: );
1627: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1628: SGL_ATTRIBUTES_ID,
1629: FACTS_ACCT_NUMBER,
1630: USSGL_ACCT_NUMBER,
1631: BALANCE_TYPE,
1652: LAST_UPDATE_DATE,
1653: LAST_UPDATED_BY,
1654: LAST_UPDATE_LOGIN)
1655: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1656: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1657: '1523', -- facct account number
1658: '1523', -- ussgl account number
1659: 'E', -- balance type
1660: 'N', -- authority type
1680: sysdate, -- last update date
1681: FND_GLOBAL.USER_ID, -- last updated by
1682: FND_GLOBAL.USER_ID -- last updated login
1683: );
1684: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1685: SGL_ATTRIBUTES_ID,
1686: FACTS_ACCT_NUMBER,
1687: USSGL_ACCT_NUMBER,
1688: BALANCE_TYPE,
1709: LAST_UPDATE_DATE,
1710: LAST_UPDATED_BY,
1711: LAST_UPDATE_LOGIN)
1712: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1713: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1714: '1524', -- facct account number
1715: '1524', -- ussgl account number
1716: 'E', -- balance type
1717: 'N', -- authority type
1737: sysdate, -- last update date
1738: FND_GLOBAL.USER_ID, -- last updated by
1739: FND_GLOBAL.USER_ID -- last updated login
1740: );
1741: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1742: SGL_ATTRIBUTES_ID,
1743: FACTS_ACCT_NUMBER,
1744: USSGL_ACCT_NUMBER,
1745: BALANCE_TYPE,
1766: LAST_UPDATE_DATE,
1767: LAST_UPDATED_BY,
1768: LAST_UPDATE_LOGIN)
1769: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1770: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1771: '1525', -- facct account number
1772: '1525', -- ussgl account number
1773: 'E', -- balance type
1774: 'N', -- authority type
1794: sysdate, -- last update date
1795: FND_GLOBAL.USER_ID, -- last updated by
1796: FND_GLOBAL.USER_ID -- last updated login
1797: );
1798: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1799: SGL_ATTRIBUTES_ID,
1800: FACTS_ACCT_NUMBER,
1801: USSGL_ACCT_NUMBER,
1802: BALANCE_TYPE,
1823: LAST_UPDATE_DATE,
1824: LAST_UPDATED_BY,
1825: LAST_UPDATE_LOGIN)
1826: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1827: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1828: '1526', -- facct account number
1829: '1526', -- ussgl account number
1830: 'E', -- balance type
1831: 'N', -- authority type
1851: sysdate, -- last update date
1852: FND_GLOBAL.USER_ID, -- last updated by
1853: FND_GLOBAL.USER_ID -- last updated login
1854: );
1855: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1856: SGL_ATTRIBUTES_ID,
1857: FACTS_ACCT_NUMBER,
1858: USSGL_ACCT_NUMBER,
1859: BALANCE_TYPE,
1880: LAST_UPDATE_DATE,
1881: LAST_UPDATED_BY,
1882: LAST_UPDATE_LOGIN)
1883: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1884: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1885: '1527', -- facct account number
1886: '1527', -- ussgl account number
1887: 'E', -- balance type
1888: 'N', -- authority type
1908: sysdate, -- last update date
1909: FND_GLOBAL.USER_ID, -- last updated by
1910: FND_GLOBAL.USER_ID -- last updated login
1911: );
1912: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1913: SGL_ATTRIBUTES_ID,
1914: FACTS_ACCT_NUMBER,
1915: USSGL_ACCT_NUMBER,
1916: BALANCE_TYPE,
1937: LAST_UPDATE_DATE,
1938: LAST_UPDATED_BY,
1939: LAST_UPDATE_LOGIN)
1940: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1941: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1942: '1529', -- facct account number
1943: '1529', -- ussgl account number
1944: 'E', -- balance type
1945: 'N', -- authority type
1965: sysdate, -- last update date
1966: FND_GLOBAL.USER_ID, -- last updated by
1967: FND_GLOBAL.USER_ID -- last updated login
1968: );
1969: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1970: SGL_ATTRIBUTES_ID,
1971: FACTS_ACCT_NUMBER,
1972: USSGL_ACCT_NUMBER,
1973: BALANCE_TYPE,
1994: LAST_UPDATE_DATE,
1995: LAST_UPDATED_BY,
1996: LAST_UPDATE_LOGIN)
1997: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1998: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1999: '1531', -- facct account number
2000: '1531', -- ussgl account number
2001: 'E', -- balance type
2002: 'N', -- authority type
2022: sysdate, -- last update date
2023: FND_GLOBAL.USER_ID, -- last updated by
2024: FND_GLOBAL.USER_ID -- last updated login
2025: );
2026: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2027: SGL_ATTRIBUTES_ID,
2028: FACTS_ACCT_NUMBER,
2029: USSGL_ACCT_NUMBER,
2030: BALANCE_TYPE,
2051: LAST_UPDATE_DATE,
2052: LAST_UPDATED_BY,
2053: LAST_UPDATE_LOGIN)
2054: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2055: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2056: '1532', -- facct account number
2057: '1532', -- ussgl account number
2058: 'E', -- balance type
2059: 'N', -- authority type
2079: sysdate, -- last update date
2080: FND_GLOBAL.USER_ID, -- last updated by
2081: FND_GLOBAL.USER_ID -- last updated login
2082: );
2083: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2084: SGL_ATTRIBUTES_ID,
2085: FACTS_ACCT_NUMBER,
2086: USSGL_ACCT_NUMBER,
2087: BALANCE_TYPE,
2108: LAST_UPDATE_DATE,
2109: LAST_UPDATED_BY,
2110: LAST_UPDATE_LOGIN)
2111: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2112: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2113: '1541', -- facct account number
2114: '1541', -- ussgl account number
2115: 'E', -- balance type
2116: 'N', -- authority type
2136: sysdate, -- last update date
2137: FND_GLOBAL.USER_ID, -- last updated by
2138: FND_GLOBAL.USER_ID -- last updated login
2139: );
2140: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2141: SGL_ATTRIBUTES_ID,
2142: FACTS_ACCT_NUMBER,
2143: USSGL_ACCT_NUMBER,
2144: BALANCE_TYPE,
2165: LAST_UPDATE_DATE,
2166: LAST_UPDATED_BY,
2167: LAST_UPDATE_LOGIN)
2168: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2169: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2170: '1542', -- facct account number
2171: '1542', -- ussgl account number
2172: 'E', -- balance type
2173: 'N', -- authority type
2193: sysdate, -- last update date
2194: FND_GLOBAL.USER_ID, -- last updated by
2195: FND_GLOBAL.USER_ID -- last updated login
2196: );
2197: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2198: SGL_ATTRIBUTES_ID,
2199: FACTS_ACCT_NUMBER,
2200: USSGL_ACCT_NUMBER,
2201: BALANCE_TYPE,
2222: LAST_UPDATE_DATE,
2223: LAST_UPDATED_BY,
2224: LAST_UPDATE_LOGIN)
2225: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2226: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2227: '1549', -- facct account number
2228: '1549', -- ussgl account number
2229: 'E', -- balance type
2230: 'N', -- authority type
2250: sysdate, -- last update date
2251: FND_GLOBAL.USER_ID, -- last updated by
2252: FND_GLOBAL.USER_ID -- last updated login
2253: );
2254: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2255: SGL_ATTRIBUTES_ID,
2256: FACTS_ACCT_NUMBER,
2257: USSGL_ACCT_NUMBER,
2258: BALANCE_TYPE,
2279: LAST_UPDATE_DATE,
2280: LAST_UPDATED_BY,
2281: LAST_UPDATE_LOGIN)
2282: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2283: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2284: '1551', -- facct account number
2285: '1551', -- ussgl account number
2286: 'E', -- balance type
2287: 'N', -- authority type
2307: sysdate, -- last update date
2308: FND_GLOBAL.USER_ID, -- last updated by
2309: FND_GLOBAL.USER_ID -- last updated login
2310: );
2311: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2312: SGL_ATTRIBUTES_ID,
2313: FACTS_ACCT_NUMBER,
2314: USSGL_ACCT_NUMBER,
2315: BALANCE_TYPE,
2336: LAST_UPDATE_DATE,
2337: LAST_UPDATED_BY,
2338: LAST_UPDATE_LOGIN)
2339: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2340: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2341: '1559', -- facct account number
2342: '1559', -- ussgl account number
2343: 'E', -- balance type
2344: 'N', -- authority type
2364: sysdate, -- last update date
2365: FND_GLOBAL.USER_ID, -- last updated by
2366: FND_GLOBAL.USER_ID -- last updated login
2367: );
2368: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2369: SGL_ATTRIBUTES_ID,
2370: FACTS_ACCT_NUMBER,
2371: USSGL_ACCT_NUMBER,
2372: BALANCE_TYPE,
2393: LAST_UPDATE_DATE,
2394: LAST_UPDATED_BY,
2395: LAST_UPDATE_LOGIN)
2396: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2397: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2398: '1561', -- facct account number
2399: '1561', -- ussgl account number
2400: 'E', -- balance type
2401: 'N', -- authority type
2421: sysdate, -- last update date
2422: FND_GLOBAL.USER_ID, -- last updated by
2423: FND_GLOBAL.USER_ID -- last updated login
2424: );
2425: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2426: SGL_ATTRIBUTES_ID,
2427: FACTS_ACCT_NUMBER,
2428: USSGL_ACCT_NUMBER,
2429: BALANCE_TYPE,
2450: LAST_UPDATE_DATE,
2451: LAST_UPDATED_BY,
2452: LAST_UPDATE_LOGIN)
2453: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2454: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2455: '1569', -- facct account number
2456: '1569', -- ussgl account number
2457: 'E', -- balance type
2458: 'N', -- authority type
2478: sysdate, -- last update date
2479: FND_GLOBAL.USER_ID, -- last updated by
2480: FND_GLOBAL.USER_ID -- last updated login
2481: );
2482: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2483: SGL_ATTRIBUTES_ID,
2484: FACTS_ACCT_NUMBER,
2485: USSGL_ACCT_NUMBER,
2486: BALANCE_TYPE,
2507: LAST_UPDATE_DATE,
2508: LAST_UPDATED_BY,
2509: LAST_UPDATE_LOGIN)
2510: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2511: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2512: '1571', -- facct account number
2513: '1571', -- ussgl account number
2514: 'E', -- balance type
2515: 'N', -- authority type
2535: sysdate, -- last update date
2536: FND_GLOBAL.USER_ID, -- last updated by
2537: FND_GLOBAL.USER_ID -- last updated login
2538: );
2539: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2540: SGL_ATTRIBUTES_ID,
2541: FACTS_ACCT_NUMBER,
2542: USSGL_ACCT_NUMBER,
2543: BALANCE_TYPE,
2564: LAST_UPDATE_DATE,
2565: LAST_UPDATED_BY,
2566: LAST_UPDATE_LOGIN)
2567: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2568: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2569: '1572', -- facct account number
2570: '1572', -- ussgl account number
2571: 'E', -- balance type
2572: 'N', -- authority type
2592: sysdate, -- last update date
2593: FND_GLOBAL.USER_ID, -- last updated by
2594: FND_GLOBAL.USER_ID -- last updated login
2595: );
2596: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2597: SGL_ATTRIBUTES_ID,
2598: FACTS_ACCT_NUMBER,
2599: USSGL_ACCT_NUMBER,
2600: BALANCE_TYPE,
2621: LAST_UPDATE_DATE,
2622: LAST_UPDATED_BY,
2623: LAST_UPDATE_LOGIN)
2624: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2625: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2626: '1591', -- facct account number
2627: '1591', -- ussgl account number
2628: 'E', -- balance type
2629: 'N', -- authority type
2649: sysdate, -- last update date
2650: FND_GLOBAL.USER_ID, -- last updated by
2651: FND_GLOBAL.USER_ID -- last updated login
2652: );
2653: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2654: SGL_ATTRIBUTES_ID,
2655: FACTS_ACCT_NUMBER,
2656: USSGL_ACCT_NUMBER,
2657: BALANCE_TYPE,
2678: LAST_UPDATE_DATE,
2679: LAST_UPDATED_BY,
2680: LAST_UPDATE_LOGIN)
2681: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2682: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2683: '1599', -- facct account number
2684: '1599', -- ussgl account number
2685: 'E', -- balance type
2686: 'N', -- authority type
2707: FND_GLOBAL.USER_ID, -- last updated by
2708: FND_GLOBAL.USER_ID -- last updated login
2709: );
2710:
2711: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2712: SGL_ATTRIBUTES_ID,
2713: FACTS_ACCT_NUMBER,
2714: USSGL_ACCT_NUMBER,
2715: BALANCE_TYPE,
2736: LAST_UPDATE_DATE,
2737: LAST_UPDATED_BY,
2738: LAST_UPDATE_LOGIN)
2739: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2740: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2741: '1610', -- facct account number
2742: '1610', -- ussgl account number
2743: 'S', -- balance type
2744: 'N', -- authority type
2764: sysdate, -- last update date
2765: FND_GLOBAL.USER_ID, -- last updated by
2766: FND_GLOBAL.USER_ID -- last updated login
2767: );
2768: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2769: SGL_ATTRIBUTES_ID,
2770: FACTS_ACCT_NUMBER,
2771: USSGL_ACCT_NUMBER,
2772: BALANCE_TYPE,
2793: LAST_UPDATE_DATE,
2794: LAST_UPDATED_BY,
2795: LAST_UPDATE_LOGIN)
2796: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2797: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2798: '1611', -- facct account number
2799: '1611', -- ussgl account number
2800: 'E', -- balance type
2801: 'N', -- authority type
2821: sysdate, -- last update date
2822: FND_GLOBAL.USER_ID, -- last updated by
2823: FND_GLOBAL.USER_ID -- last updated login
2824: );
2825: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2826: SGL_ATTRIBUTES_ID,
2827: FACTS_ACCT_NUMBER,
2828: USSGL_ACCT_NUMBER,
2829: BALANCE_TYPE,
2850: LAST_UPDATE_DATE,
2851: LAST_UPDATED_BY,
2852: LAST_UPDATE_LOGIN)
2853: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2854: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2855: '1612', -- facct account number
2856: '1612', -- sgl acct number
2857: 'E', -- balance type
2858: 'N', -- authority type
2878: sysdate, -- last update date
2879: FND_GLOBAL.USER_ID, -- last updated by
2880: FND_GLOBAL.USER_ID -- last updated login
2881: );
2882: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2883: SGL_ATTRIBUTES_ID,
2884: FACTS_ACCT_NUMBER,
2885: USSGL_ACCT_NUMBER,
2886: BALANCE_TYPE,
2907: LAST_UPDATE_DATE,
2908: LAST_UPDATED_BY,
2909: LAST_UPDATE_LOGIN)
2910: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2911: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2912: '1613', -- facct account number
2913: '1613', -- ussgl account number
2914: 'E', -- balance type
2915: 'N', -- authority type
2935: sysdate, -- last update date
2936: FND_GLOBAL.USER_ID, -- last updated by
2937: FND_GLOBAL.USER_ID -- last updated login
2938: );
2939: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2940: SGL_ATTRIBUTES_ID,
2941: FACTS_ACCT_NUMBER,
2942: USSGL_ACCT_NUMBER,
2943: BALANCE_TYPE,
2964: LAST_UPDATE_DATE,
2965: LAST_UPDATED_BY,
2966: LAST_UPDATE_LOGIN)
2967: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2968: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2969: '1620', -- facct account number
2970: '1620', -- ussgl account number
2971: 'S', -- balance type
2972: 'N', -- authority type
2992: sysdate, -- last update date
2993: FND_GLOBAL.USER_ID, -- last updated by
2994: FND_GLOBAL.USER_ID -- last updated login
2995: );
2996: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2997: SGL_ATTRIBUTES_ID,
2998: FACTS_ACCT_NUMBER,
2999: USSGL_ACCT_NUMBER,
3000: BALANCE_TYPE,
3021: LAST_UPDATE_DATE,
3022: LAST_UPDATED_BY,
3023: LAST_UPDATE_LOGIN)
3024: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3025: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3026: '1621', -- facct account number
3027: '1621', -- ussgl account number
3028: 'E', -- balance type
3029: 'N', -- authority type
3049: sysdate, -- last update date
3050: FND_GLOBAL.USER_ID, -- last updated by
3051: FND_GLOBAL.USER_ID -- last updated login
3052: );
3053: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3054: SGL_ATTRIBUTES_ID,
3055: FACTS_ACCT_NUMBER,
3056: USSGL_ACCT_NUMBER,
3057: BALANCE_TYPE,
3078: LAST_UPDATE_DATE,
3079: LAST_UPDATED_BY,
3080: LAST_UPDATE_LOGIN)
3081: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3082: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3083: '1622', -- facct account number
3084: '1622', -- ussgl account number
3085: 'E', -- balance type
3086: 'N', -- authority type
3106: sysdate, -- last update date
3107: FND_GLOBAL.USER_ID, -- last updated by
3108: FND_GLOBAL.USER_ID -- last updated login
3109: );
3110: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3111: SGL_ATTRIBUTES_ID,
3112: FACTS_ACCT_NUMBER,
3113: USSGL_ACCT_NUMBER,
3114: BALANCE_TYPE,
3135: LAST_UPDATE_DATE,
3136: LAST_UPDATED_BY,
3137: LAST_UPDATE_LOGIN)
3138: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3139: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3140: '1623', -- facct account number
3141: '1623', -- ussgl account number
3142: 'E', -- balance type
3143: 'N', -- authority type
3166: );
3167:
3168: --- New account seeded for Enhancement 1541559
3169:
3170: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3171: SGL_ATTRIBUTES_ID,
3172: FACTS_ACCT_NUMBER,
3173: USSGL_ACCT_NUMBER,
3174: BALANCE_TYPE,
3195: LAST_UPDATE_DATE,
3196: LAST_UPDATED_BY,
3197: LAST_UPDATE_LOGIN)
3198: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3199: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3200: '1630', -- facct account number
3201: '1630', -- ussgl account number
3202: 'S', -- balance type
3203: 'N', -- authority type
3224: FND_GLOBAL.USER_ID, -- last updated by
3225: FND_GLOBAL.USER_ID -- last updated login
3226: );
3227:
3228: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3229: SGL_ATTRIBUTES_ID,
3230: FACTS_ACCT_NUMBER,
3231: USSGL_ACCT_NUMBER,
3232: BALANCE_TYPE,
3253: LAST_UPDATE_DATE,
3254: LAST_UPDATED_BY,
3255: LAST_UPDATE_LOGIN)
3256: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3257: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3258: '1631', -- facct account number
3259: '1631', -- ussgl account number
3260: 'E', -- balance type
3261: 'N', -- authority type
3283: FND_GLOBAL.USER_ID -- last updated login
3284: );
3285:
3286:
3287: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3288: SGL_ATTRIBUTES_ID,
3289: FACTS_ACCT_NUMBER,
3290: USSGL_ACCT_NUMBER,
3291: BALANCE_TYPE,
3312: LAST_UPDATE_DATE,
3313: LAST_UPDATED_BY,
3314: LAST_UPDATE_LOGIN)
3315: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3316: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3317: '1633', -- facct account number
3318: '1633', -- ussgl account number
3319: 'E', -- balance type
3320: 'N', -- authority type
3341: FND_GLOBAL.USER_ID, -- last updated by
3342: FND_GLOBAL.USER_ID -- last updated login
3343: );
3344:
3345: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3346: SGL_ATTRIBUTES_ID,
3347: FACTS_ACCT_NUMBER,
3348: USSGL_ACCT_NUMBER,
3349: BALANCE_TYPE,
3370: LAST_UPDATE_DATE,
3371: LAST_UPDATED_BY,
3372: LAST_UPDATE_LOGIN)
3373: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3374: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3375: '1638', -- facct account number
3376: '1638', -- ussgl account number
3377: 'E', -- balance type
3378: 'N', -- authority type
3399: FND_GLOBAL.USER_ID, -- last updated by
3400: FND_GLOBAL.USER_ID -- last updated login
3401: );
3402:
3403: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3404: SGL_ATTRIBUTES_ID,
3405: FACTS_ACCT_NUMBER,
3406: USSGL_ACCT_NUMBER,
3407: BALANCE_TYPE,
3428: LAST_UPDATE_DATE,
3429: LAST_UPDATED_BY,
3430: LAST_UPDATE_LOGIN)
3431: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3432: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3433: '1639', -- facct account number
3434: '1639', -- ussgl account number
3435: 'E', -- balance type
3436: 'N', -- authority type
3459: );
3460:
3461: -- New seeding End
3462:
3463: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3464: SGL_ATTRIBUTES_ID,
3465: FACTS_ACCT_NUMBER,
3466: USSGL_ACCT_NUMBER,
3467: BALANCE_TYPE,
3488: LAST_UPDATE_DATE,
3489: LAST_UPDATED_BY,
3490: LAST_UPDATE_LOGIN)
3491: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3492: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3493: '1690', -- facct account number
3494: '1690', -- ussgl account number
3495: 'E', -- balance type
3496: 'N', -- authority type
3516: sysdate, -- last update date
3517: FND_GLOBAL.USER_ID, -- last updated by
3518: FND_GLOBAL.USER_ID -- last updated login
3519: );
3520: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3521: SGL_ATTRIBUTES_ID,
3522: FACTS_ACCT_NUMBER,
3523: USSGL_ACCT_NUMBER,
3524: BALANCE_TYPE,
3545: LAST_UPDATE_DATE,
3546: LAST_UPDATED_BY,
3547: LAST_UPDATE_LOGIN)
3548: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3549: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3550: '1711', -- facct account number
3551: '1711', -- ussgl account number
3552: 'E', -- balance type
3553: 'N', -- authority type
3573: sysdate, -- last update date
3574: FND_GLOBAL.USER_ID, -- last updated by
3575: FND_GLOBAL.USER_ID -- last updated login
3576: );
3577: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3578: SGL_ATTRIBUTES_ID,
3579: FACTS_ACCT_NUMBER,
3580: USSGL_ACCT_NUMBER,
3581: BALANCE_TYPE,
3602: LAST_UPDATE_DATE,
3603: LAST_UPDATED_BY,
3604: LAST_UPDATE_LOGIN)
3605: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3606: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3607: '1712', -- facct account number
3608: '1712', -- ussgl account number
3609: 'E', -- balance type
3610: 'N', -- authority type
3630: sysdate, -- last update date
3631: FND_GLOBAL.USER_ID, -- last updated by
3632: FND_GLOBAL.USER_ID -- last updated login
3633: );
3634: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3635: SGL_ATTRIBUTES_ID,
3636: FACTS_ACCT_NUMBER,
3637: USSGL_ACCT_NUMBER,
3638: BALANCE_TYPE,
3659: LAST_UPDATE_DATE,
3660: LAST_UPDATED_BY,
3661: LAST_UPDATE_LOGIN)
3662: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3663: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3664: '1719', -- facct account number
3665: '1719', -- ussgl account number
3666: 'E', -- balance type
3667: 'N', -- authority type
3687: sysdate, -- last update date
3688: FND_GLOBAL.USER_ID, -- last updated by
3689: FND_GLOBAL.USER_ID -- last updated login
3690: );
3691: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3692: SGL_ATTRIBUTES_ID,
3693: FACTS_ACCT_NUMBER,
3694: USSGL_ACCT_NUMBER,
3695: BALANCE_TYPE,
3716: LAST_UPDATE_DATE,
3717: LAST_UPDATED_BY,
3718: LAST_UPDATE_LOGIN)
3719: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3720: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3721: '1720', -- facct account number
3722: '1720', -- ussgl account number
3723: 'E', -- balance type
3724: 'N', -- authority type
3744: sysdate, -- last update date
3745: FND_GLOBAL.USER_ID, -- last updated by
3746: FND_GLOBAL.USER_ID -- last updated login
3747: );
3748: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3749: SGL_ATTRIBUTES_ID,
3750: FACTS_ACCT_NUMBER,
3751: USSGL_ACCT_NUMBER,
3752: BALANCE_TYPE,
3773: LAST_UPDATE_DATE,
3774: LAST_UPDATED_BY,
3775: LAST_UPDATE_LOGIN)
3776: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3777: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3778: '1730', -- facct account number
3779: '1730', -- ussgl account number
3780: 'E', -- balance type
3781: 'N', -- authority type
3801: sysdate, -- last update date
3802: FND_GLOBAL.USER_ID, -- last updated by
3803: FND_GLOBAL.USER_ID -- last updated login
3804: );
3805: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3806: SGL_ATTRIBUTES_ID,
3807: FACTS_ACCT_NUMBER,
3808: USSGL_ACCT_NUMBER,
3809: BALANCE_TYPE,
3830: LAST_UPDATE_DATE,
3831: LAST_UPDATED_BY,
3832: LAST_UPDATE_LOGIN)
3833: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3834: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3835: '1739', -- facct account number
3836: '1739', -- ussgl account number
3837: 'E', -- balance type
3838: 'N', -- authority type
3858: sysdate, -- last update date
3859: FND_GLOBAL.USER_ID, -- last updated by
3860: FND_GLOBAL.USER_ID -- last updated login
3861: );
3862: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3863: SGL_ATTRIBUTES_ID,
3864: FACTS_ACCT_NUMBER,
3865: USSGL_ACCT_NUMBER,
3866: BALANCE_TYPE,
3887: LAST_UPDATE_DATE,
3888: LAST_UPDATED_BY,
3889: LAST_UPDATE_LOGIN)
3890: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3891: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3892: '1740', -- facct account number
3893: '1740', -- ussgl account number
3894: 'E', -- balance type
3895: 'N', -- authority type
3915: sysdate, -- last update date
3916: FND_GLOBAL.USER_ID, -- last updated by
3917: FND_GLOBAL.USER_ID -- last updated login
3918: );
3919: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3920: SGL_ATTRIBUTES_ID,
3921: FACTS_ACCT_NUMBER,
3922: USSGL_ACCT_NUMBER,
3923: BALANCE_TYPE,
3944: LAST_UPDATE_DATE,
3945: LAST_UPDATED_BY,
3946: LAST_UPDATE_LOGIN)
3947: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3948: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3949: '1749', -- facct account number
3950: '1749', -- ussgl account number
3951: 'E', -- balance type
3952: 'N', -- authority type
3972: sysdate, -- last update date
3973: FND_GLOBAL.USER_ID, -- last updated by
3974: FND_GLOBAL.USER_ID -- last updated login
3975: );
3976: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3977: SGL_ATTRIBUTES_ID,
3978: FACTS_ACCT_NUMBER,
3979: USSGL_ACCT_NUMBER,
3980: BALANCE_TYPE,
4001: LAST_UPDATE_DATE,
4002: LAST_UPDATED_BY,
4003: LAST_UPDATE_LOGIN)
4004: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
4005: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
4006: '1750', -- facct account number
4007: '1750', -- ussgl account number
4008: 'E', -- balance type
4009: 'N', -- authority type
4029: sysdate, -- last update date
4030: FND_GLOBAL.USER_ID, -- last updated by
4031: FND_GLOBAL.USER_ID -- last updated login
4032: );
4033: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
4034: SGL_ATTRIBUTES_ID,
4035: FACTS_ACCT_NUMBER,
4036: USSGL_ACCT_NUMBER,
4037: BALANCE_TYPE,
4058: LAST_UPDATE_DATE,
4059: LAST_UPDATED_BY,
4060: LAST_UPDATE_LOGIN)
4061: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
4062: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
4063: '1759', -- facct account number
4064: '1759', -- ussgl account number
4065: 'E', -- balance type
4066: 'N', -- authority type
4086: sysdate, -- last update date
4087: FND_GLOBAL.USER_ID, -- last updated by
4088: FND_GLOBAL.USER_ID -- last updated login
4089: );
4090: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
4091: SGL_ATTRIBUTES_ID,
4092: FACTS_ACCT_NUMBER,
4093: USSGL_ACCT_NUMBER,
4094: BALANCE_TYPE,
4115: LAST_UPDATE_DATE,
4116: LAST_UPDATED_BY,
4117: LAST_UPDATE_LOGIN)
4118: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
4119: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
4120: '1810', -- facct account number
4121: '1810', -- ussgl account number
4122: 'E', -- balance type
4123: 'N', -- authority type
4143: sysdate, -- last update date
4144: FND_GLOBAL.USER_ID, -- last updated by
4145: FND_GLOBAL.USER_ID -- last updated login
4146: );
4147: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
4148: SGL_ATTRIBUTES_ID,
4149: FACTS_ACCT_NUMBER,
4150: USSGL_ACCT_NUMBER,
4151: BALANCE_TYPE,
4172: LAST_UPDATE_DATE,
4173: LAST_UPDATED_BY,
4174: LAST_UPDATE_LOGIN)
4175: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
4176: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
4177: '1819', -- facct account number
4178: '1819', -- ussgl account number
4179: 'E', -- balance type
4180: 'N', -- authority type
4201: FND_GLOBAL.USER_ID, -- last updated by
4202: FND_GLOBAL.USER_ID -- last updated login
4203: );
4204:
4205: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
4206: SGL_ATTRIBUTES_ID,
4207: FACTS_ACCT_NUMBER,
4208: USSGL_ACCT_NUMBER,
4209: BALANCE_TYPE,
4230: LAST_UPDATE_DATE,
4231: LAST_UPDATED_BY,
4232: LAST_UPDATE_LOGIN)
4233: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
4234: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
4235: '1820', -- facct account number
4236: '1820', -- ussgl account number
4237: 'E', -- balance type
4238: 'N', -- authority type
4258: sysdate, -- last update date
4259: FND_GLOBAL.USER_ID, -- last updated by
4260: FND_GLOBAL.USER_ID -- last updated login
4261: );
4262: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
4263: SGL_ATTRIBUTES_ID,
4264: FACTS_ACCT_NUMBER,
4265: USSGL_ACCT_NUMBER,
4266: BALANCE_TYPE,
4287: LAST_UPDATE_DATE,
4288: LAST_UPDATED_BY,
4289: LAST_UPDATE_LOGIN)
4290: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
4291: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
4292: '1829', -- facct account number
4293: '1829', -- ussgl account number
4294: 'E', -- balance type
4295: 'N', -- authority type
4315: sysdate, -- last update date
4316: FND_GLOBAL.USER_ID, -- last updated by
4317: FND_GLOBAL.USER_ID -- last updated login
4318: );
4319: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
4320: SGL_ATTRIBUTES_ID,
4321: FACTS_ACCT_NUMBER,
4322: USSGL_ACCT_NUMBER,
4323: BALANCE_TYPE,
4344: LAST_UPDATE_DATE,
4345: LAST_UPDATED_BY,
4346: LAST_UPDATE_LOGIN)
4347: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
4348: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
4349: '1830', -- facct account number
4350: '1830', -- ussgl account number
4351: 'E', -- balance type
4352: 'N', -- authority type
4372: sysdate, -- last update date
4373: FND_GLOBAL.USER_ID, -- last updated by
4374: FND_GLOBAL.USER_ID -- last updated login
4375: );
4376: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
4377: SGL_ATTRIBUTES_ID,
4378: FACTS_ACCT_NUMBER,
4379: USSGL_ACCT_NUMBER,
4380: BALANCE_TYPE,
4401: LAST_UPDATE_DATE,
4402: LAST_UPDATED_BY,
4403: LAST_UPDATE_LOGIN)
4404: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
4405: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
4406: '1839', -- facct account number
4407: '1839', -- ussgl account number
4408: 'E', -- balance type
4409: 'N', -- authority type
4429: sysdate, -- last update date
4430: FND_GLOBAL.USER_ID, -- last updated by
4431: FND_GLOBAL.USER_ID -- last updated login
4432: );
4433: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
4434: SGL_ATTRIBUTES_ID,
4435: FACTS_ACCT_NUMBER,
4436: USSGL_ACCT_NUMBER,
4437: BALANCE_TYPE,
4458: LAST_UPDATE_DATE,
4459: LAST_UPDATED_BY,
4460: LAST_UPDATE_LOGIN)
4461: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
4462: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
4463: '1840', -- facct account number
4464: '1840', -- ussgl account number
4465: 'E', -- balance type
4466: 'N', -- authority type
4486: sysdate, -- last update date
4487: FND_GLOBAL.USER_ID, -- last updated by
4488: FND_GLOBAL.USER_ID -- last updated login
4489: );
4490: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
4491: SGL_ATTRIBUTES_ID,
4492: FACTS_ACCT_NUMBER,
4493: USSGL_ACCT_NUMBER,
4494: BALANCE_TYPE,
4515: LAST_UPDATE_DATE,
4516: LAST_UPDATED_BY,
4517: LAST_UPDATE_LOGIN)
4518: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
4519: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
4520: '1849', -- facct account number
4521: '1849', -- ussgl account number
4522: 'E', -- balance type
4523: 'N', -- authority type
4543: sysdate, -- last update date
4544: FND_GLOBAL.USER_ID, -- last updated by
4545: FND_GLOBAL.USER_ID -- last updated login
4546: );
4547: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
4548: SGL_ATTRIBUTES_ID,
4549: FACTS_ACCT_NUMBER,
4550: USSGL_ACCT_NUMBER,
4551: BALANCE_TYPE,
4572: LAST_UPDATE_DATE,
4573: LAST_UPDATED_BY,
4574: LAST_UPDATE_LOGIN)
4575: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
4576: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
4577: '1890', -- facct account number
4578: '1890', -- ussgl account number
4579: 'E', -- balance type
4580: 'N', -- authority type
4600: sysdate, -- last update date
4601: FND_GLOBAL.USER_ID, -- last updated by
4602: FND_GLOBAL.USER_ID -- last updated login
4603: );
4604: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
4605: SGL_ATTRIBUTES_ID,
4606: FACTS_ACCT_NUMBER,
4607: USSGL_ACCT_NUMBER,
4608: BALANCE_TYPE,
4629: LAST_UPDATE_DATE,
4630: LAST_UPDATED_BY,
4631: LAST_UPDATE_LOGIN)
4632: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
4633: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
4634: '1920', -- facct account number
4635: '1920', -- ussgl account number
4636: 'E', -- balance type
4637: 'N', -- authority type
4657: sysdate, -- last update date
4658: FND_GLOBAL.USER_ID, -- last updated by
4659: FND_GLOBAL.USER_ID -- last updated login
4660: );
4661: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
4662: SGL_ATTRIBUTES_ID,
4663: FACTS_ACCT_NUMBER,
4664: USSGL_ACCT_NUMBER,
4665: BALANCE_TYPE,
4686: LAST_UPDATE_DATE,
4687: LAST_UPDATED_BY,
4688: LAST_UPDATE_LOGIN)
4689: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
4690: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
4691: '1921', -- facct account number
4692: '1921', -- ussgl account number
4693: 'E', -- balance type
4694: 'N', -- authority type
4714: sysdate, -- last update date
4715: FND_GLOBAL.USER_ID, -- last updated by
4716: FND_GLOBAL.USER_ID -- last updated login
4717: );
4718: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
4719: SGL_ATTRIBUTES_ID,
4720: FACTS_ACCT_NUMBER,
4721: USSGL_ACCT_NUMBER,
4722: BALANCE_TYPE,
4743: LAST_UPDATE_DATE,
4744: LAST_UPDATED_BY,
4745: LAST_UPDATE_LOGIN)
4746: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
4747: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
4748: '1990', -- facct account number
4749: '1990', -- ussgl account number
4750: 'E', -- balance type
4751: 'N', -- authority type
4771: sysdate, -- last update date
4772: FND_GLOBAL.USER_ID, -- last updated by
4773: FND_GLOBAL.USER_ID -- last updated login
4774: );
4775: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
4776: SGL_ATTRIBUTES_ID,
4777: FACTS_ACCT_NUMBER,
4778: USSGL_ACCT_NUMBER,
4779: BALANCE_TYPE,
4800: LAST_UPDATE_DATE,
4801: LAST_UPDATED_BY,
4802: LAST_UPDATE_LOGIN)
4803: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
4804: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
4805: '2110', -- facct account number
4806: '2110', -- ussgl account number
4807: 'E', -- balance type
4808: 'N', -- authority type
4828: sysdate, -- last update date
4829: FND_GLOBAL.USER_ID, -- last updated by
4830: FND_GLOBAL.USER_ID -- last updated login
4831: );
4832: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
4833: SGL_ATTRIBUTES_ID,
4834: FACTS_ACCT_NUMBER,
4835: USSGL_ACCT_NUMBER,
4836: BALANCE_TYPE,
4857: LAST_UPDATE_DATE,
4858: LAST_UPDATED_BY,
4859: LAST_UPDATE_LOGIN)
4860: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
4861: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
4862: '2120', -- facct account number
4863: '2120', -- ussgl account number
4864: 'E', -- balance type
4865: 'N', -- authority type
4885: sysdate, -- last update date
4886: FND_GLOBAL.USER_ID, -- last updated by
4887: FND_GLOBAL.USER_ID -- last updated login
4888: );
4889: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
4890: SGL_ATTRIBUTES_ID,
4891: FACTS_ACCT_NUMBER,
4892: USSGL_ACCT_NUMBER,
4893: BALANCE_TYPE,
4914: LAST_UPDATE_DATE,
4915: LAST_UPDATED_BY,
4916: LAST_UPDATE_LOGIN)
4917: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
4918: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
4919: '2130', -- facct account number
4920: '2130', -- ussgl account number
4921: 'E', -- balance type
4922: 'N', -- authority type
4942: sysdate, -- last update date
4943: FND_GLOBAL.USER_ID, -- last updated by
4944: FND_GLOBAL.USER_ID -- last updated login
4945: );
4946: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
4947: SGL_ATTRIBUTES_ID,
4948: FACTS_ACCT_NUMBER,
4949: USSGL_ACCT_NUMBER,
4950: BALANCE_TYPE,
4971: LAST_UPDATE_DATE,
4972: LAST_UPDATED_BY,
4973: LAST_UPDATE_LOGIN)
4974: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
4975: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
4976: '2140', -- facct account number
4977: '2140', -- ussgl account number
4978: 'E', -- balance type
4979: 'N', -- authority type
4999: sysdate, -- last update date
5000: FND_GLOBAL.USER_ID, -- last updated by
5001: FND_GLOBAL.USER_ID -- last updated login
5002: );
5003: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
5004: SGL_ATTRIBUTES_ID,
5005: FACTS_ACCT_NUMBER,
5006: USSGL_ACCT_NUMBER,
5007: BALANCE_TYPE,
5028: LAST_UPDATE_DATE,
5029: LAST_UPDATED_BY,
5030: LAST_UPDATE_LOGIN)
5031: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
5032: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
5033: '2150', -- facct account number
5034: '2150', -- ussgl account number
5035: 'E', -- balance type
5036: 'N', -- authority type
5056: sysdate, -- last update date
5057: FND_GLOBAL.USER_ID, -- last updated by
5058: FND_GLOBAL.USER_ID -- last updated login
5059: );
5060: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
5061: SGL_ATTRIBUTES_ID,
5062: FACTS_ACCT_NUMBER,
5063: USSGL_ACCT_NUMBER,
5064: BALANCE_TYPE,
5085: LAST_UPDATE_DATE,
5086: LAST_UPDATED_BY,
5087: LAST_UPDATE_LOGIN)
5088: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
5089: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
5090: '2155', -- facct account number
5091: '2155', -- ussgl account number
5092: 'E', -- balance type
5093: 'N', -- authority type
5113: sysdate, -- last update date
5114: FND_GLOBAL.USER_ID, -- last updated by
5115: FND_GLOBAL.USER_ID -- last updated login
5116: );
5117: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
5118: SGL_ATTRIBUTES_ID,
5119: FACTS_ACCT_NUMBER,
5120: USSGL_ACCT_NUMBER,
5121: BALANCE_TYPE,
5142: LAST_UPDATE_DATE,
5143: LAST_UPDATED_BY,
5144: LAST_UPDATE_LOGIN)
5145: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
5146: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
5147: '2160', -- facct account number
5148: '2160', -- ussgl account number
5149: 'E', -- balance type
5150: 'N', -- authority type
5170: sysdate, -- last update date
5171: FND_GLOBAL.USER_ID, -- last updated by
5172: FND_GLOBAL.USER_ID -- last updated login
5173: );
5174: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
5175: SGL_ATTRIBUTES_ID,
5176: FACTS_ACCT_NUMBER,
5177: USSGL_ACCT_NUMBER,
5178: BALANCE_TYPE,
5199: LAST_UPDATE_DATE,
5200: LAST_UPDATED_BY,
5201: LAST_UPDATE_LOGIN)
5202: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
5203: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
5204: '2170', -- facct account number
5205: '2170', -- ussgl account number
5206: 'E', -- balance type
5207: 'N', -- authority type
5227: sysdate, -- last update date
5228: FND_GLOBAL.USER_ID, -- last updated by
5229: FND_GLOBAL.USER_ID -- last updated login
5230: );
5231: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
5232: SGL_ATTRIBUTES_ID,
5233: FACTS_ACCT_NUMBER,
5234: USSGL_ACCT_NUMBER,
5235: BALANCE_TYPE,
5256: LAST_UPDATE_DATE,
5257: LAST_UPDATED_BY,
5258: LAST_UPDATE_LOGIN)
5259: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
5260: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
5261: '2179', -- facct account number
5262: '2179', -- ussgl account number
5263: 'E', -- balance type
5264: 'N', -- authority type
5284: sysdate, -- last update date
5285: FND_GLOBAL.USER_ID, -- last updated by
5286: FND_GLOBAL.USER_ID -- last updated login
5287: );
5288: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
5289: SGL_ATTRIBUTES_ID,
5290: FACTS_ACCT_NUMBER,
5291: USSGL_ACCT_NUMBER,
5292: BALANCE_TYPE,
5313: LAST_UPDATE_DATE,
5314: LAST_UPDATED_BY,
5315: LAST_UPDATE_LOGIN)
5316: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
5317: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
5318: '2180', -- facct account number
5319: '2180', -- ussgl account number
5320: 'E', -- balance type
5321: 'N', -- authority type
5341: sysdate, -- last update date
5342: FND_GLOBAL.USER_ID, -- last updated by
5343: FND_GLOBAL.USER_ID -- last updated login
5344: );
5345: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
5346: SGL_ATTRIBUTES_ID,
5347: FACTS_ACCT_NUMBER,
5348: USSGL_ACCT_NUMBER,
5349: BALANCE_TYPE,
5370: LAST_UPDATE_DATE,
5371: LAST_UPDATED_BY,
5372: LAST_UPDATE_LOGIN)
5373: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
5374: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
5375: '2190', -- facct account number
5376: '2190', -- ussgl account number
5377: 'E', -- balance type
5378: 'N', -- authority type
5398: sysdate, -- last update date
5399: FND_GLOBAL.USER_ID, -- last updated by
5400: FND_GLOBAL.USER_ID -- last updated login
5401: );
5402: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
5403: SGL_ATTRIBUTES_ID,
5404: FACTS_ACCT_NUMBER,
5405: USSGL_ACCT_NUMBER,
5406: BALANCE_TYPE,
5427: LAST_UPDATE_DATE,
5428: LAST_UPDATED_BY,
5429: LAST_UPDATE_LOGIN)
5430: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
5431: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
5432: '2210', -- facct account number
5433: '2210', -- ussgl account number
5434: 'E', -- balance type
5435: 'N', -- authority type
5455: sysdate, -- last update date
5456: FND_GLOBAL.USER_ID, -- last updated by
5457: FND_GLOBAL.USER_ID -- last updated login
5458: );
5459: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
5460: SGL_ATTRIBUTES_ID,
5461: FACTS_ACCT_NUMBER,
5462: USSGL_ACCT_NUMBER,
5463: BALANCE_TYPE,
5484: LAST_UPDATE_DATE,
5485: LAST_UPDATED_BY,
5486: LAST_UPDATE_LOGIN)
5487: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
5488: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
5489: '2211', -- facct account number
5490: '2211', -- ussgl account number
5491: 'E', -- balance type
5492: 'N', -- authority type
5512: sysdate, -- last update date
5513: FND_GLOBAL.USER_ID, -- last updated by
5514: FND_GLOBAL.USER_ID -- last updated login
5515: );
5516: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
5517: SGL_ATTRIBUTES_ID,
5518: FACTS_ACCT_NUMBER,
5519: USSGL_ACCT_NUMBER,
5520: BALANCE_TYPE,
5541: LAST_UPDATE_DATE,
5542: LAST_UPDATED_BY,
5543: LAST_UPDATE_LOGIN)
5544: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
5545: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
5546: '2213', -- facct account number
5547: '2213', -- ussgl account number
5548: 'E', -- balance type
5549: 'N', -- authority type
5569: sysdate, -- last update date
5570: FND_GLOBAL.USER_ID, -- last updated by
5571: FND_GLOBAL.USER_ID -- last updated login
5572: );
5573: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
5574: SGL_ATTRIBUTES_ID,
5575: FACTS_ACCT_NUMBER,
5576: USSGL_ACCT_NUMBER,
5577: BALANCE_TYPE,
5598: LAST_UPDATE_DATE,
5599: LAST_UPDATED_BY,
5600: LAST_UPDATE_LOGIN)
5601: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
5602: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
5603: '2215', -- facct account number
5604: '2215', -- ussgl account number
5605: 'E', -- balance type
5606: 'N', -- authority type
5626: sysdate, -- last update date
5627: FND_GLOBAL.USER_ID, -- last updated by
5628: FND_GLOBAL.USER_ID -- last updated login
5629: );
5630: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
5631: SGL_ATTRIBUTES_ID,
5632: FACTS_ACCT_NUMBER,
5633: USSGL_ACCT_NUMBER,
5634: BALANCE_TYPE,
5655: LAST_UPDATE_DATE,
5656: LAST_UPDATED_BY,
5657: LAST_UPDATE_LOGIN)
5658: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
5659: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
5660: '2216', -- facct account number
5661: '2216', -- ussgl account number
5662: 'E', -- balance type
5663: 'N', -- authority type
5683: sysdate, -- last update date
5684: FND_GLOBAL.USER_ID, -- last updated by
5685: FND_GLOBAL.USER_ID -- last updated login
5686: );
5687: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
5688: SGL_ATTRIBUTES_ID,
5689: FACTS_ACCT_NUMBER,
5690: USSGL_ACCT_NUMBER,
5691: BALANCE_TYPE,
5712: LAST_UPDATE_DATE,
5713: LAST_UPDATED_BY,
5714: LAST_UPDATE_LOGIN)
5715: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
5716: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
5717: '2217', -- facct account number
5718: '2217', -- ussgl account number
5719: 'E', -- balance type
5720: 'N', -- authority type
5740: sysdate, -- last update date
5741: FND_GLOBAL.USER_ID, -- last updated by
5742: FND_GLOBAL.USER_ID -- last updated login
5743: );
5744: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
5745: SGL_ATTRIBUTES_ID,
5746: FACTS_ACCT_NUMBER,
5747: USSGL_ACCT_NUMBER,
5748: BALANCE_TYPE,
5769: LAST_UPDATE_DATE,
5770: LAST_UPDATED_BY,
5771: LAST_UPDATE_LOGIN)
5772: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
5773: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
5774: '2218', -- facct account number
5775: '2218', -- ussgl account number
5776: 'E', -- balance type
5777: 'N', -- authority type
5797: sysdate, -- last update date
5798: FND_GLOBAL.USER_ID, -- last updated by
5799: FND_GLOBAL.USER_ID -- last updated login
5800: );
5801: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
5802: SGL_ATTRIBUTES_ID,
5803: FACTS_ACCT_NUMBER,
5804: USSGL_ACCT_NUMBER,
5805: BALANCE_TYPE,
5826: LAST_UPDATE_DATE,
5827: LAST_UPDATED_BY,
5828: LAST_UPDATE_LOGIN)
5829: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
5830: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
5831: '2220', -- facct account number
5832: '2220', -- ussgl account number
5833: 'E', -- balance type
5834: 'N', -- authority type
5854: sysdate, -- last update date
5855: FND_GLOBAL.USER_ID, -- last updated by
5856: FND_GLOBAL.USER_ID -- last updated login
5857: );
5858: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
5859: SGL_ATTRIBUTES_ID,
5860: FACTS_ACCT_NUMBER,
5861: USSGL_ACCT_NUMBER,
5862: BALANCE_TYPE,
5883: LAST_UPDATE_DATE,
5884: LAST_UPDATED_BY,
5885: LAST_UPDATE_LOGIN)
5886: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
5887: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
5888: '2225', -- facct account number
5889: '2225', -- ussgl account number
5890: 'E', -- balance type
5891: 'N', -- authority type
5911: sysdate, -- last update date
5912: FND_GLOBAL.USER_ID, -- last updated by
5913: FND_GLOBAL.USER_ID -- last updated login
5914: );
5915: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
5916: SGL_ATTRIBUTES_ID,
5917: FACTS_ACCT_NUMBER,
5918: USSGL_ACCT_NUMBER,
5919: BALANCE_TYPE,
5940: LAST_UPDATE_DATE,
5941: LAST_UPDATED_BY,
5942: LAST_UPDATE_LOGIN)
5943: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
5944: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
5945: '2290', -- facct account number
5946: '2290', -- ussgl account number
5947: 'E', -- balance type
5948: 'N', -- authority type
5968: sysdate, -- last update date
5969: FND_GLOBAL.USER_ID, -- last updated by
5970: FND_GLOBAL.USER_ID -- last updated login
5971: );
5972: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
5973: SGL_ATTRIBUTES_ID,
5974: FACTS_ACCT_NUMBER,
5975: USSGL_ACCT_NUMBER,
5976: BALANCE_TYPE,
5997: LAST_UPDATE_DATE,
5998: LAST_UPDATED_BY,
5999: LAST_UPDATE_LOGIN)
6000: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
6001: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
6002: '2310', -- facct account number
6003: '2310', -- ussgl account number
6004: 'E', -- balance type
6005: 'N', -- authority type
6025: sysdate, -- last update date
6026: FND_GLOBAL.USER_ID, -- last updated by
6027: FND_GLOBAL.USER_ID -- last updated login
6028: );
6029: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
6030: SGL_ATTRIBUTES_ID,
6031: FACTS_ACCT_NUMBER,
6032: USSGL_ACCT_NUMBER,
6033: BALANCE_TYPE,
6054: LAST_UPDATE_DATE,
6055: LAST_UPDATED_BY,
6056: LAST_UPDATE_LOGIN)
6057: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
6058: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
6059: '2320', -- facct account number
6060: '2320', -- ussgl account number
6061: 'E', -- balance type
6062: 'N', -- authority type
6082: sysdate, -- last update date
6083: FND_GLOBAL.USER_ID, -- last updated by
6084: FND_GLOBAL.USER_ID -- last updated login
6085: );
6086: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
6087: SGL_ATTRIBUTES_ID,
6088: FACTS_ACCT_NUMBER,
6089: USSGL_ACCT_NUMBER,
6090: BALANCE_TYPE,
6111: LAST_UPDATE_DATE,
6112: LAST_UPDATED_BY,
6113: LAST_UPDATE_LOGIN)
6114: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
6115: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
6116: '2400', -- facct account number
6117: '2400', -- ussgl account number
6118: 'E', -- balance type
6119: 'N', -- authority type
6139: sysdate, -- last update date
6140: FND_GLOBAL.USER_ID, -- last updated by
6141: FND_GLOBAL.USER_ID -- last updated login
6142: );
6143: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
6144: SGL_ATTRIBUTES_ID,
6145: FACTS_ACCT_NUMBER,
6146: USSGL_ACCT_NUMBER,
6147: BALANCE_TYPE,
6168: LAST_UPDATE_DATE,
6169: LAST_UPDATED_BY,
6170: LAST_UPDATE_LOGIN)
6171: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
6172: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
6173: '2510', -- facct account number
6174: '2510', -- ussgl account number
6175: 'E', -- balance type
6176: 'N', -- authority type
6196: sysdate, -- last update date
6197: FND_GLOBAL.USER_ID, -- last updated by
6198: FND_GLOBAL.USER_ID -- last updated login
6199: );
6200: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
6201: SGL_ATTRIBUTES_ID,
6202: FACTS_ACCT_NUMBER,
6203: USSGL_ACCT_NUMBER,
6204: BALANCE_TYPE,
6225: LAST_UPDATE_DATE,
6226: LAST_UPDATED_BY,
6227: LAST_UPDATE_LOGIN)
6228: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
6229: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
6230: '2520', -- facct account number
6231: '2520', -- ussgl account number
6232: 'E', -- balance type
6233: 'N', -- authority type
6253: sysdate, -- last update date
6254: FND_GLOBAL.USER_ID, -- last updated by
6255: FND_GLOBAL.USER_ID -- last updated login
6256: );
6257: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
6258: SGL_ATTRIBUTES_ID,
6259: FACTS_ACCT_NUMBER,
6260: USSGL_ACCT_NUMBER,
6261: BALANCE_TYPE,
6282: LAST_UPDATE_DATE,
6283: LAST_UPDATED_BY,
6284: LAST_UPDATE_LOGIN)
6285: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
6286: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
6287: '2530', -- facct account number
6288: '2530', -- ussgl account number
6289: 'E', -- balance type
6290: 'N', -- authority type
6310: sysdate, -- last update date
6311: FND_GLOBAL.USER_ID, -- last updated by
6312: FND_GLOBAL.USER_ID -- last updated login
6313: );
6314: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
6315: SGL_ATTRIBUTES_ID,
6316: FACTS_ACCT_NUMBER,
6317: USSGL_ACCT_NUMBER,
6318: BALANCE_TYPE,
6339: LAST_UPDATE_DATE,
6340: LAST_UPDATED_BY,
6341: LAST_UPDATE_LOGIN)
6342: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
6343: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
6344: '2540', -- facct account number
6345: '2540', -- ussgl account number
6346: 'E', -- balance type
6347: 'N', -- authority type
6367: sysdate, -- last update date
6368: FND_GLOBAL.USER_ID, -- last updated by
6369: FND_GLOBAL.USER_ID -- last updated login
6370: );
6371: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
6372: SGL_ATTRIBUTES_ID,
6373: FACTS_ACCT_NUMBER,
6374: USSGL_ACCT_NUMBER,
6375: BALANCE_TYPE,
6396: LAST_UPDATE_DATE,
6397: LAST_UPDATED_BY,
6398: LAST_UPDATE_LOGIN)
6399: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
6400: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
6401: '2590', -- facct account number
6402: '2590', -- ussgl account number
6403: 'E', -- balance type
6404: 'N', -- authority type
6424: sysdate, -- last update date
6425: FND_GLOBAL.USER_ID, -- last updated by
6426: FND_GLOBAL.USER_ID -- last updated login
6427: );
6428: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
6429: SGL_ATTRIBUTES_ID,
6430: FACTS_ACCT_NUMBER,
6431: USSGL_ACCT_NUMBER,
6432: BALANCE_TYPE,
6453: LAST_UPDATE_DATE,
6454: LAST_UPDATED_BY,
6455: LAST_UPDATE_LOGIN)
6456: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
6457: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
6458: '2610', -- facct account number
6459: '2610', -- ussgl account number
6460: 'E', -- balance type
6461: 'N', -- authority type
6481: sysdate, -- last update date
6482: FND_GLOBAL.USER_ID, -- last updated by
6483: FND_GLOBAL.USER_ID -- last updated login
6484: );
6485: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
6486: SGL_ATTRIBUTES_ID,
6487: FACTS_ACCT_NUMBER,
6488: USSGL_ACCT_NUMBER,
6489: BALANCE_TYPE,
6510: LAST_UPDATE_DATE,
6511: LAST_UPDATED_BY,
6512: LAST_UPDATE_LOGIN)
6513: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
6514: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
6515: '2620', -- facct account number
6516: '2620', -- ussgl account number
6517: 'E', -- balance type
6518: 'N', -- authority type
6538: sysdate, -- last update date
6539: FND_GLOBAL.USER_ID, -- last updated by
6540: FND_GLOBAL.USER_ID -- last updated login
6541: );
6542: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
6543: SGL_ATTRIBUTES_ID,
6544: FACTS_ACCT_NUMBER,
6545: USSGL_ACCT_NUMBER,
6546: BALANCE_TYPE,
6567: LAST_UPDATE_DATE,
6568: LAST_UPDATED_BY,
6569: LAST_UPDATE_LOGIN)
6570: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
6571: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
6572: '2630', -- facct account number
6573: '2630', -- ussgl account number
6574: 'E', -- balance type
6575: 'N', -- authority type
6595: sysdate, -- last update date
6596: FND_GLOBAL.USER_ID, -- last updated by
6597: FND_GLOBAL.USER_ID -- last updated login
6598: );
6599: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
6600: SGL_ATTRIBUTES_ID,
6601: FACTS_ACCT_NUMBER,
6602: USSGL_ACCT_NUMBER,
6603: BALANCE_TYPE,
6624: LAST_UPDATE_DATE,
6625: LAST_UPDATED_BY,
6626: LAST_UPDATE_LOGIN)
6627: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
6628: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
6629: '2650', -- facct account number
6630: '2650', -- ussgl account number
6631: 'E', -- balance type
6632: 'N', -- authority type
6652: sysdate, -- last update date
6653: FND_GLOBAL.USER_ID, -- last updated by
6654: FND_GLOBAL.USER_ID -- last updated login
6655: );
6656: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
6657: SGL_ATTRIBUTES_ID,
6658: FACTS_ACCT_NUMBER,
6659: USSGL_ACCT_NUMBER,
6660: BALANCE_TYPE,
6681: LAST_UPDATE_DATE,
6682: LAST_UPDATED_BY,
6683: LAST_UPDATE_LOGIN)
6684: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
6685: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
6686: '2690', -- facct account number
6687: '2690', -- ussgl account number
6688: 'E', -- balance type
6689: 'N', -- authority type
6709: sysdate, -- last update date
6710: FND_GLOBAL.USER_ID, -- last updated by
6711: FND_GLOBAL.USER_ID -- last updated login
6712: );
6713: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
6714: SGL_ATTRIBUTES_ID,
6715: FACTS_ACCT_NUMBER,
6716: USSGL_ACCT_NUMBER,
6717: BALANCE_TYPE,
6738: LAST_UPDATE_DATE,
6739: LAST_UPDATED_BY,
6740: LAST_UPDATE_LOGIN)
6741: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
6742: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
6743: '2910', -- facct account number
6744: '2910', -- ussgl account number
6745: 'E', -- balance type
6746: 'N', -- authority type
6766: sysdate, -- last update date
6767: FND_GLOBAL.USER_ID, -- last updated by
6768: FND_GLOBAL.USER_ID -- last updated login
6769: );
6770: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
6771: SGL_ATTRIBUTES_ID,
6772: FACTS_ACCT_NUMBER,
6773: USSGL_ACCT_NUMBER,
6774: BALANCE_TYPE,
6795: LAST_UPDATE_DATE,
6796: LAST_UPDATED_BY,
6797: LAST_UPDATE_LOGIN)
6798: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
6799: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
6800: '2920', -- facct account number
6801: '2920', -- ussgl account number
6802: 'E', -- balance type
6803: 'N', -- authority type
6823: sysdate, -- last update date
6824: FND_GLOBAL.USER_ID, -- last updated by
6825: FND_GLOBAL.USER_ID -- last updated login
6826: );
6827: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
6828: SGL_ATTRIBUTES_ID,
6829: FACTS_ACCT_NUMBER,
6830: USSGL_ACCT_NUMBER,
6831: BALANCE_TYPE,
6852: LAST_UPDATE_DATE,
6853: LAST_UPDATED_BY,
6854: LAST_UPDATE_LOGIN)
6855: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
6856: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
6857: '2940', -- facct account number
6858: '2940', -- ussgl account number
6859: 'E', -- balance type
6860: 'N', -- authority type
6880: sysdate, -- last update date
6881: FND_GLOBAL.USER_ID, -- last updated by
6882: FND_GLOBAL.USER_ID -- last updated login
6883: );
6884: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
6885: SGL_ATTRIBUTES_ID,
6886: FACTS_ACCT_NUMBER,
6887: USSGL_ACCT_NUMBER,
6888: BALANCE_TYPE,
6909: LAST_UPDATE_DATE,
6910: LAST_UPDATED_BY,
6911: LAST_UPDATE_LOGIN)
6912: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
6913: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
6914: '2950', -- facct account number
6915: '2950', -- ussgl account number
6916: 'E', -- balance type
6917: 'N', -- authority type
6937: sysdate, -- last update date
6938: FND_GLOBAL.USER_ID, -- last updated by
6939: FND_GLOBAL.USER_ID -- last updated login
6940: );
6941: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
6942: SGL_ATTRIBUTES_ID,
6943: FACTS_ACCT_NUMBER,
6944: USSGL_ACCT_NUMBER,
6945: BALANCE_TYPE,
6966: LAST_UPDATE_DATE,
6967: LAST_UPDATED_BY,
6968: LAST_UPDATE_LOGIN)
6969: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
6970: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
6971: '2960', -- facct account number
6972: '2960', -- ussgl account number
6973: 'E', -- balance type
6974: 'N', -- authority type
6994: sysdate, -- last update date
6995: FND_GLOBAL.USER_ID, -- last updated by
6996: FND_GLOBAL.USER_ID -- last updated login
6997: );
6998: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
6999: SGL_ATTRIBUTES_ID,
7000: FACTS_ACCT_NUMBER,
7001: USSGL_ACCT_NUMBER,
7002: BALANCE_TYPE,
7023: LAST_UPDATE_DATE,
7024: LAST_UPDATED_BY,
7025: LAST_UPDATE_LOGIN)
7026: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
7027: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
7028: '2970', -- facct account number
7029: '2970', -- ussgl account number
7030: 'E', -- balance type
7031: 'N', -- authority type
7051: sysdate, -- last update date
7052: FND_GLOBAL.USER_ID, -- last updated by
7053: FND_GLOBAL.USER_ID -- last updated login
7054: );
7055: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
7056: SGL_ATTRIBUTES_ID,
7057: FACTS_ACCT_NUMBER,
7058: USSGL_ACCT_NUMBER,
7059: BALANCE_TYPE,
7080: LAST_UPDATE_DATE,
7081: LAST_UPDATED_BY,
7082: LAST_UPDATE_LOGIN)
7083: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
7084: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
7085: '2980', -- facct account number
7086: '2980', -- ussgl account number
7087: 'E', -- balance type
7088: 'N', -- authority type
7109: FND_GLOBAL.USER_ID, -- last updated by
7110: FND_GLOBAL.USER_ID -- last updated login
7111: );
7112:
7113: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
7114: SGL_ATTRIBUTES_ID,
7115: FACTS_ACCT_NUMBER,
7116: USSGL_ACCT_NUMBER,
7117: BALANCE_TYPE,
7138: LAST_UPDATE_DATE,
7139: LAST_UPDATED_BY,
7140: LAST_UPDATE_LOGIN)
7141: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
7142: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
7143: '4032', -- facct account number
7144: '4032', -- ussgl account number
7145: 'E', -- balance type
7146: 'N', -- authority type
7166: sysdate, -- last update date
7167: FND_GLOBAL.USER_ID, -- last updated by
7168: FND_GLOBAL.USER_ID -- last updated login
7169: );
7170: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
7171: SGL_ATTRIBUTES_ID,
7172: FACTS_ACCT_NUMBER,
7173: USSGL_ACCT_NUMBER,
7174: BALANCE_TYPE,
7195: LAST_UPDATE_DATE,
7196: LAST_UPDATED_BY,
7197: LAST_UPDATE_LOGIN)
7198: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
7199: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
7200: '4034', -- facct account number
7201: '4034', -- ussgl account number
7202: 'E', -- balance type
7203: 'N', -- authority type
7223: sysdate, -- last update date
7224: FND_GLOBAL.USER_ID, -- last updated by
7225: FND_GLOBAL.USER_ID -- last updated login
7226: );
7227: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
7228: SGL_ATTRIBUTES_ID,
7229: FACTS_ACCT_NUMBER,
7230: USSGL_ACCT_NUMBER,
7231: BALANCE_TYPE,
7252: LAST_UPDATE_DATE,
7253: LAST_UPDATED_BY,
7254: LAST_UPDATE_LOGIN)
7255: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
7256: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
7257: '4042', -- facct account number
7258: '4042', -- ussgl account number
7259: 'E', -- balance type
7260: 'N', -- authority type
7280: sysdate, -- last update date
7281: FND_GLOBAL.USER_ID, -- last updated by
7282: FND_GLOBAL.USER_ID -- last updated login
7283: );
7284: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
7285: SGL_ATTRIBUTES_ID,
7286: FACTS_ACCT_NUMBER,
7287: USSGL_ACCT_NUMBER,
7288: BALANCE_TYPE,
7309: LAST_UPDATE_DATE,
7310: LAST_UPDATED_BY,
7311: LAST_UPDATE_LOGIN)
7312: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
7313: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
7314: '4044', -- facct account number
7315: '4044', -- ussgl account number
7316: 'E', -- balance type
7317: 'N', -- authority type
7337: sysdate, -- last update date
7338: FND_GLOBAL.USER_ID, -- last updated by
7339: FND_GLOBAL.USER_ID -- last updated login
7340: );
7341: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
7342: SGL_ATTRIBUTES_ID,
7343: FACTS_ACCT_NUMBER,
7344: USSGL_ACCT_NUMBER,
7345: BALANCE_TYPE,
7366: LAST_UPDATE_DATE,
7367: LAST_UPDATED_BY,
7368: LAST_UPDATE_LOGIN)
7369: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
7370: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
7371: '4047', -- facct account number
7372: '4047', -- ussgl account number
7373: 'E', -- balance type
7374: 'N', -- authority type
7394: sysdate, -- last update date
7395: FND_GLOBAL.USER_ID, -- last updated by
7396: FND_GLOBAL.USER_ID -- last updated login
7397: );
7398: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
7399: SGL_ATTRIBUTES_ID,
7400: FACTS_ACCT_NUMBER,
7401: USSGL_ACCT_NUMBER,
7402: BALANCE_TYPE,
7423: LAST_UPDATE_DATE,
7424: LAST_UPDATED_BY,
7425: LAST_UPDATE_LOGIN)
7426: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
7427: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
7428: '4060', -- facct account number
7429: '4060', -- ussgl account number
7430: 'E', -- balance type
7431: 'N', -- authority type
7451: sysdate, -- last update date
7452: FND_GLOBAL.USER_ID, -- last updated by
7453: FND_GLOBAL.USER_ID -- last updated login
7454: );
7455: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
7456: SGL_ATTRIBUTES_ID,
7457: FACTS_ACCT_NUMBER,
7458: USSGL_ACCT_NUMBER,
7459: BALANCE_TYPE,
7480: LAST_UPDATE_DATE,
7481: LAST_UPDATED_BY,
7482: LAST_UPDATE_LOGIN)
7483: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
7484: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
7485: '4070', -- facct account number
7486: '4070', -- ussgl account number
7487: 'E', -- balance type
7488: 'N', -- authority type
7508: sysdate, -- last update date
7509: FND_GLOBAL.USER_ID, -- last updated by
7510: FND_GLOBAL.USER_ID -- last updated login
7511: );
7512: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
7513: SGL_ATTRIBUTES_ID,
7514: FACTS_ACCT_NUMBER,
7515: USSGL_ACCT_NUMBER,
7516: BALANCE_TYPE,
7537: LAST_UPDATE_DATE,
7538: LAST_UPDATED_BY,
7539: LAST_UPDATE_LOGIN)
7540: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
7541: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
7542: '4111', -- facct account number
7543: '4111', -- ussgl account number
7544: 'E', -- balance type
7545: 'P', -- authority type
7565: sysdate, -- last update date
7566: FND_GLOBAL.USER_ID, -- last updated by
7567: FND_GLOBAL.USER_ID -- last updated login
7568: );
7569: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
7570: SGL_ATTRIBUTES_ID,
7571: FACTS_ACCT_NUMBER,
7572: USSGL_ACCT_NUMBER,
7573: BALANCE_TYPE,
7594: LAST_UPDATE_DATE,
7595: LAST_UPDATED_BY,
7596: LAST_UPDATE_LOGIN)
7597: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
7598: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
7599: '4112', -- facct account number
7600: '4112', -- sgl acct number
7601: 'E', -- balance type
7602: 'N', -- authority type
7622: sysdate, -- last update date
7623: FND_GLOBAL.USER_ID, -- last updated by
7624: FND_GLOBAL.USER_ID -- last updated login
7625: );
7626: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
7627: SGL_ATTRIBUTES_ID,
7628: FACTS_ACCT_NUMBER,
7629: USSGL_ACCT_NUMBER,
7630: BALANCE_TYPE,
7651: LAST_UPDATE_DATE,
7652: LAST_UPDATED_BY,
7653: LAST_UPDATE_LOGIN)
7654: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
7655: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
7656: '4114', -- facct account number
7657: '4114', -- ussgl account number
7658: 'E', -- balance type
7659: 'P', -- authority type
7679: sysdate, -- last update date
7680: FND_GLOBAL.USER_ID, -- last updated by
7681: FND_GLOBAL.USER_ID -- last updated login
7682: );
7683: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
7684: SGL_ATTRIBUTES_ID,
7685: FACTS_ACCT_NUMBER,
7686: USSGL_ACCT_NUMBER,
7687: BALANCE_TYPE,
7708: LAST_UPDATE_DATE,
7709: LAST_UPDATED_BY,
7710: LAST_UPDATE_LOGIN)
7711: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
7712: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
7713: '4115', -- facct account number
7714: '4115', -- ussgl account number
7715: 'E', -- balance type
7716: 'P', -- authority type
7736: sysdate, -- last update date
7737: FND_GLOBAL.USER_ID, -- last updated by
7738: FND_GLOBAL.USER_ID -- last updated login
7739: );
7740: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
7741: SGL_ATTRIBUTES_ID,
7742: FACTS_ACCT_NUMBER,
7743: USSGL_ACCT_NUMBER,
7744: BALANCE_TYPE,
7765: LAST_UPDATE_DATE,
7766: LAST_UPDATED_BY,
7767: LAST_UPDATE_LOGIN)
7768: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
7769: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
7770: '4116', -- facct account number
7771: '4116', -- ussgl account number
7772: 'E', -- balance type
7773: 'P', -- authority type
7793: sysdate, -- last update date
7794: FND_GLOBAL.USER_ID, -- last updated by
7795: FND_GLOBAL.USER_ID -- last updated login
7796: );
7797: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
7798: SGL_ATTRIBUTES_ID,
7799: FACTS_ACCT_NUMBER,
7800: USSGL_ACCT_NUMBER,
7801: BALANCE_TYPE,
7822: LAST_UPDATE_DATE,
7823: LAST_UPDATED_BY,
7824: LAST_UPDATE_LOGIN)
7825: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
7826: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
7827: '4117', -- facct account number
7828: '4117', -- ussgl account number
7829: 'E', -- balance type
7830: 'P', -- authority type
7850: sysdate, -- last update date
7851: FND_GLOBAL.USER_ID, -- last updated by
7852: FND_GLOBAL.USER_ID -- last updated login
7853: );
7854: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
7855: SGL_ATTRIBUTES_ID,
7856: FACTS_ACCT_NUMBER,
7857: USSGL_ACCT_NUMBER,
7858: BALANCE_TYPE,
7879: LAST_UPDATE_DATE,
7880: LAST_UPDATED_BY,
7881: LAST_UPDATE_LOGIN)
7882: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
7883: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
7884: '4118', -- facct account number
7885: '4118', -- ussgl account number
7886: 'E', -- balance type
7887: 'N', -- authority type
7907: sysdate, -- last update date
7908: FND_GLOBAL.USER_ID, -- last updated by
7909: FND_GLOBAL.USER_ID -- last updated login
7910: );
7911: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
7912: SGL_ATTRIBUTES_ID,
7913: FACTS_ACCT_NUMBER,
7914: USSGL_ACCT_NUMBER,
7915: BALANCE_TYPE,
7936: LAST_UPDATE_DATE,
7937: LAST_UPDATED_BY,
7938: LAST_UPDATE_LOGIN)
7939: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
7940: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
7941: '4119', -- facct account number
7942: '4119', -- ussgl account number
7943: 'E', -- balance type
7944: 'P', -- authority type
7964: sysdate, -- last update date
7965: FND_GLOBAL.USER_ID, -- last updated by
7966: FND_GLOBAL.USER_ID -- last updated login
7967: );
7968: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
7969: SGL_ATTRIBUTES_ID,
7970: FACTS_ACCT_NUMBER,
7971: USSGL_ACCT_NUMBER,
7972: BALANCE_TYPE,
7993: LAST_UPDATE_DATE,
7994: LAST_UPDATED_BY,
7995: LAST_UPDATE_LOGIN)
7996: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
7997: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
7998: '4120', -- facct account number
7999: '4120', -- ussgl account number
8000: 'E', -- balance type
8001: 'N', -- authority type
8021: sysdate, -- last update date
8022: FND_GLOBAL.USER_ID, -- last updated by
8023: FND_GLOBAL.USER_ID -- last updated login
8024: );
8025: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
8026: SGL_ATTRIBUTES_ID,
8027: FACTS_ACCT_NUMBER,
8028: USSGL_ACCT_NUMBER,
8029: BALANCE_TYPE,
8050: LAST_UPDATE_DATE,
8051: LAST_UPDATED_BY,
8052: LAST_UPDATE_LOGIN)
8053: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
8054: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
8055: '4121', -- facct account number
8056: '4121', -- ussgl account number
8057: 'E', -- balance type
8058: 'P', -- authority type
8078: sysdate, -- last update date
8079: FND_GLOBAL.USER_ID, -- last updated by
8080: FND_GLOBAL.USER_ID -- last updated login
8081: );
8082: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
8083: SGL_ATTRIBUTES_ID,
8084: FACTS_ACCT_NUMBER,
8085: USSGL_ACCT_NUMBER,
8086: BALANCE_TYPE,
8107: LAST_UPDATE_DATE,
8108: LAST_UPDATED_BY,
8109: LAST_UPDATE_LOGIN)
8110: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
8111: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
8112: '4125', -- facct account number
8113: '4125', -- ussgl account number
8114: 'E', -- balance type
8115: 'N', -- authority type
8138: );
8139:
8140: -- Seed data for Enhancement 1541559
8141:
8142: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
8143: SGL_ATTRIBUTES_ID,
8144: FACTS_ACCT_NUMBER,
8145: USSGL_ACCT_NUMBER,
8146: BALANCE_TYPE,
8167: LAST_UPDATE_DATE,
8168: LAST_UPDATED_BY,
8169: LAST_UPDATE_LOGIN)
8170: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
8171: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
8172: '4126', -- facct account number
8173: '4126', -- ussgl account number
8174: 'S', -- balance type
8175: 'N', -- authority type
8196: FND_GLOBAL.USER_ID, -- last updated by
8197: FND_GLOBAL.USER_ID -- last updated login
8198: );
8199:
8200: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
8201: SGL_ATTRIBUTES_ID,
8202: FACTS_ACCT_NUMBER,
8203: USSGL_ACCT_NUMBER,
8204: BALANCE_TYPE,
8225: LAST_UPDATE_DATE,
8226: LAST_UPDATED_BY,
8227: LAST_UPDATE_LOGIN)
8228: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
8229: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
8230: '4127', -- facct account number
8231: '4127', -- ussgl account number
8232: 'S', -- balance type
8233: 'N', -- authority type
8255: FND_GLOBAL.USER_ID -- last updated login
8256: );
8257:
8258:
8259: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
8260: SGL_ATTRIBUTES_ID,
8261: FACTS_ACCT_NUMBER,
8262: USSGL_ACCT_NUMBER,
8263: BALANCE_TYPE,
8284: LAST_UPDATE_DATE,
8285: LAST_UPDATED_BY,
8286: LAST_UPDATE_LOGIN)
8287: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
8288: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
8289: '4128', -- facct account number
8290: '4128', -- ussgl account number
8291: 'E', -- balance type
8292: 'N', -- authority type
8314: FND_GLOBAL.USER_ID -- last updated login
8315: );
8316:
8317:
8318: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
8319: SGL_ATTRIBUTES_ID,
8320: FACTS_ACCT_NUMBER,
8321: USSGL_ACCT_NUMBER,
8322: BALANCE_TYPE,
8343: LAST_UPDATE_DATE,
8344: LAST_UPDATED_BY,
8345: LAST_UPDATE_LOGIN)
8346: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
8347: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
8348: '4129', -- facct account number
8349: '4129', -- ussgl account number
8350: 'E', -- balance type
8351: 'N', -- authority type
8374: );
8375:
8376: -- End of Enhancement 1541559
8377:
8378: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
8379: SGL_ATTRIBUTES_ID,
8380: FACTS_ACCT_NUMBER,
8381: USSGL_ACCT_NUMBER,
8382: BALANCE_TYPE,
8403: LAST_UPDATE_DATE,
8404: LAST_UPDATED_BY,
8405: LAST_UPDATE_LOGIN)
8406: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
8407: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
8408: '4131', -- facct account number
8409: '4131', -- ussgl account number
8410: 'E', -- balance type
8411: 'N', -- authority type
8431: sysdate, -- last update date
8432: FND_GLOBAL.USER_ID, -- last updated by
8433: FND_GLOBAL.USER_ID -- last updated login
8434: );
8435: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
8436: SGL_ATTRIBUTES_ID,
8437: FACTS_ACCT_NUMBER,
8438: USSGL_ACCT_NUMBER,
8439: BALANCE_TYPE,
8460: LAST_UPDATE_DATE,
8461: LAST_UPDATED_BY,
8462: LAST_UPDATE_LOGIN)
8463: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
8464: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
8465: '4132', -- facct account number
8466: '4132', -- ussgl account number
8467: 'E', -- balance type
8468: 'N', -- authority type
8488: sysdate, -- last update date
8489: FND_GLOBAL.USER_ID, -- last updated by
8490: FND_GLOBAL.USER_ID -- last updated login
8491: );
8492: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
8493: SGL_ATTRIBUTES_ID,
8494: FACTS_ACCT_NUMBER,
8495: USSGL_ACCT_NUMBER,
8496: BALANCE_TYPE,
8517: LAST_UPDATE_DATE,
8518: LAST_UPDATED_BY,
8519: LAST_UPDATE_LOGIN)
8520: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
8521: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
8522: '4133', -- facct account number
8523: '4133', -- ussgl account number
8524: 'E', -- balance type
8525: 'N', -- authority type
8545: sysdate, -- last update date
8546: FND_GLOBAL.USER_ID, -- last updated by
8547: FND_GLOBAL.USER_ID -- last updated login
8548: );
8549: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
8550: SGL_ATTRIBUTES_ID,
8551: FACTS_ACCT_NUMBER,
8552: USSGL_ACCT_NUMBER,
8553: BALANCE_TYPE,
8574: LAST_UPDATE_DATE,
8575: LAST_UPDATED_BY,
8576: LAST_UPDATE_LOGIN)
8577: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
8578: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
8579: '4135', -- facct account number
8580: '4135', -- ussgl account number
8581: 'E', -- balance type
8582: 'C', -- authority type
8605: );
8606:
8607: -- Seed data added for Enhancement 1541559
8608:
8609: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
8610: SGL_ATTRIBUTES_ID,
8611: FACTS_ACCT_NUMBER,
8612: USSGL_ACCT_NUMBER,
8613: BALANCE_TYPE,
8634: LAST_UPDATE_DATE,
8635: LAST_UPDATED_BY,
8636: LAST_UPDATE_LOGIN)
8637: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
8638: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
8639: '4136', -- facct account number
8640: '4136', -- ussgl account number
8641: 'S', -- balance type
8642: 'N', -- authority type
8663: FND_GLOBAL.USER_ID, -- last updated by
8664: FND_GLOBAL.USER_ID -- last updated login
8665: );
8666:
8667: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
8668: SGL_ATTRIBUTES_ID,
8669: FACTS_ACCT_NUMBER,
8670: USSGL_ACCT_NUMBER,
8671: BALANCE_TYPE,
8692: LAST_UPDATE_DATE,
8693: LAST_UPDATED_BY,
8694: LAST_UPDATE_LOGIN)
8695: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
8696: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
8697: '4137', -- facct account number
8698: '4137', -- ussgl account number
8699: 'S', -- balance type
8700: 'N', -- authority type
8723: );
8724:
8725: -- Seed data end for Enhancement 1541559
8726:
8727: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
8728: SGL_ATTRIBUTES_ID,
8729: FACTS_ACCT_NUMBER,
8730: USSGL_ACCT_NUMBER,
8731: BALANCE_TYPE,
8752: LAST_UPDATE_DATE,
8753: LAST_UPDATED_BY,
8754: LAST_UPDATE_LOGIN)
8755: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
8756: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
8757: '4138', -- facct account number
8758: '4138', -- ussgl account number
8759: 'E', -- balance type
8760: 'N', -- authority type
8780: sysdate, -- last update date
8781: FND_GLOBAL.USER_ID, -- last updated by
8782: FND_GLOBAL.USER_ID -- last updated login
8783: );
8784: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
8785: SGL_ATTRIBUTES_ID,
8786: FACTS_ACCT_NUMBER,
8787: USSGL_ACCT_NUMBER,
8788: BALANCE_TYPE,
8809: LAST_UPDATE_DATE,
8810: LAST_UPDATED_BY,
8811: LAST_UPDATE_LOGIN)
8812: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
8813: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
8814: '4139', -- facct account number
8815: '4139', -- ussgl account number
8816: 'S', -- balance type
8817: 'N', -- authority type
8837: sysdate, -- last update date
8838: FND_GLOBAL.USER_ID, -- last updated by
8839: FND_GLOBAL.USER_ID -- last updated login
8840: );
8841: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
8842: SGL_ATTRIBUTES_ID,
8843: FACTS_ACCT_NUMBER,
8844: USSGL_ACCT_NUMBER,
8845: BALANCE_TYPE,
8866: LAST_UPDATE_DATE,
8867: LAST_UPDATED_BY,
8868: LAST_UPDATE_LOGIN)
8869: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
8870: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
8871: '4141', -- facct account number
8872: '4141', -- ussgl account number
8873: 'E', -- balance type
8874: 'N', -- authority type
8894: sysdate, -- last update date
8895: FND_GLOBAL.USER_ID, -- last updated by
8896: FND_GLOBAL.USER_ID -- last updated login
8897: );
8898: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
8899: SGL_ATTRIBUTES_ID,
8900: FACTS_ACCT_NUMBER,
8901: USSGL_ACCT_NUMBER,
8902: BALANCE_TYPE,
8923: LAST_UPDATE_DATE,
8924: LAST_UPDATED_BY,
8925: LAST_UPDATE_LOGIN)
8926: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
8927: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
8928: '4142', -- facct account number
8929: '4142', -- ussgl account number
8930: 'E', -- balance type
8931: 'N', -- authority type
8951: sysdate, -- last update date
8952: FND_GLOBAL.USER_ID, -- last updated by
8953: FND_GLOBAL.USER_ID -- last updated login
8954: );
8955: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
8956: SGL_ATTRIBUTES_ID,
8957: FACTS_ACCT_NUMBER,
8958: USSGL_ACCT_NUMBER,
8959: BALANCE_TYPE,
8980: LAST_UPDATE_DATE,
8981: LAST_UPDATED_BY,
8982: LAST_UPDATE_LOGIN)
8983: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
8984: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
8985: '4143', -- facct account number
8986: '4143', -- ussgl account number
8987: 'E', -- balance type
8988: 'N', -- authority type
9008: sysdate, -- last update date
9009: FND_GLOBAL.USER_ID, -- last updated by
9010: FND_GLOBAL.USER_ID -- last updated login
9011: );
9012: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
9013: SGL_ATTRIBUTES_ID,
9014: FACTS_ACCT_NUMBER,
9015: USSGL_ACCT_NUMBER,
9016: BALANCE_TYPE,
9037: LAST_UPDATE_DATE,
9038: LAST_UPDATED_BY,
9039: LAST_UPDATE_LOGIN)
9040: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
9041: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
9042: '4145', -- facct account number
9043: '4145', -- ussgl account number
9044: 'E', -- balance type
9045: 'N', -- authority type
9069:
9070:
9071: -- Seed data for enhancement 1541559
9072:
9073: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
9074: SGL_ATTRIBUTES_ID,
9075: FACTS_ACCT_NUMBER,
9076: USSGL_ACCT_NUMBER,
9077: BALANCE_TYPE,
9098: LAST_UPDATE_DATE,
9099: LAST_UPDATED_BY,
9100: LAST_UPDATE_LOGIN)
9101: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
9102: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
9103: '4146', -- facct account number
9104: '4146', -- ussgl account number
9105: 'E', -- balance type
9106: 'B', -- authority type
9129: );
9130:
9131: -- Seed Data End for enhancement 1541559
9132:
9133: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
9134: SGL_ATTRIBUTES_ID,
9135: FACTS_ACCT_NUMBER,
9136: USSGL_ACCT_NUMBER,
9137: BALANCE_TYPE,
9158: LAST_UPDATE_DATE,
9159: LAST_UPDATED_BY,
9160: LAST_UPDATE_LOGIN)
9161: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
9162: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
9163: '4147', -- facct account number
9164: '4147', -- ussgl account number
9165: 'E', -- balance type
9166: 'B', -- authority type
9186: sysdate, -- last update date
9187: FND_GLOBAL.USER_ID, -- last updated by
9188: FND_GLOBAL.USER_ID -- last updated login
9189: );
9190: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
9191: SGL_ATTRIBUTES_ID,
9192: FACTS_ACCT_NUMBER,
9193: USSGL_ACCT_NUMBER,
9194: BALANCE_TYPE,
9215: LAST_UPDATE_DATE,
9216: LAST_UPDATED_BY,
9217: LAST_UPDATE_LOGIN)
9218: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
9219: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
9220: '4148', -- facct account number
9221: '4148', -- ussgl account number
9222: 'E', -- balance type
9223: 'N', -- authority type
9243: sysdate, -- last update date
9244: FND_GLOBAL.USER_ID, -- last updated by
9245: FND_GLOBAL.USER_ID -- last updated login
9246: );
9247: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
9248: SGL_ATTRIBUTES_ID,
9249: FACTS_ACCT_NUMBER,
9250: USSGL_ACCT_NUMBER,
9251: BALANCE_TYPE,
9272: LAST_UPDATE_DATE,
9273: LAST_UPDATED_BY,
9274: LAST_UPDATE_LOGIN)
9275: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
9276: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
9277: '4149', -- facct account number
9278: '4149', -- ussgl account number
9279: 'S', -- balance type
9280: 'N', -- authority type
9300: sysdate, -- last update date
9301: FND_GLOBAL.USER_ID, -- last updated by
9302: FND_GLOBAL.USER_ID -- last updated login
9303: );
9304: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
9305: SGL_ATTRIBUTES_ID,
9306: FACTS_ACCT_NUMBER,
9307: USSGL_ACCT_NUMBER,
9308: BALANCE_TYPE,
9329: LAST_UPDATE_DATE,
9330: LAST_UPDATED_BY,
9331: LAST_UPDATE_LOGIN)
9332: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
9333: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
9334: '4150', -- facct account number
9335: '4150', -- ussgl account number
9336: 'E', -- balance type
9337: 'N', -- authority type
9360: );
9361:
9362: -- Seed data added for Enhancement 1541559
9363:
9364: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
9365: SGL_ATTRIBUTES_ID,
9366: FACTS_ACCT_NUMBER,
9367: USSGL_ACCT_NUMBER,
9368: BALANCE_TYPE,
9389: LAST_UPDATE_DATE,
9390: LAST_UPDATED_BY,
9391: LAST_UPDATE_LOGIN)
9392: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
9393: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
9394: '4151', -- facct account number
9395: '4151', -- ussgl account number
9396: 'E', -- balance type
9397: 'P', -- authority type
9418: FND_GLOBAL.USER_ID, -- last updated by
9419: FND_GLOBAL.USER_ID -- last updated login
9420: );
9421:
9422: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
9423: SGL_ATTRIBUTES_ID,
9424: FACTS_ACCT_NUMBER,
9425: USSGL_ACCT_NUMBER,
9426: BALANCE_TYPE,
9447: LAST_UPDATE_DATE,
9448: LAST_UPDATED_BY,
9449: LAST_UPDATE_LOGIN)
9450: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
9451: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
9452: '4152', -- facct account number
9453: '4152', -- ussgl account number
9454: 'E', -- balance type
9455: 'P', -- authority type
9476: FND_GLOBAL.USER_ID, -- last updated by
9477: FND_GLOBAL.USER_ID -- last updated login
9478: );
9479:
9480: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
9481: SGL_ATTRIBUTES_ID,
9482: FACTS_ACCT_NUMBER,
9483: USSGL_ACCT_NUMBER,
9484: BALANCE_TYPE,
9505: LAST_UPDATE_DATE,
9506: LAST_UPDATED_BY,
9507: LAST_UPDATE_LOGIN)
9508: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
9509: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
9510: '4157', -- facct account number
9511: '4157', -- ussgl account number
9512: 'E', -- balance type
9513: 'N', -- authority type
9534: FND_GLOBAL.USER_ID, -- last updated by
9535: FND_GLOBAL.USER_ID -- last updated login
9536: );
9537:
9538: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
9539: SGL_ATTRIBUTES_ID,
9540: FACTS_ACCT_NUMBER,
9541: USSGL_ACCT_NUMBER,
9542: BALANCE_TYPE,
9563: LAST_UPDATE_DATE,
9564: LAST_UPDATED_BY,
9565: LAST_UPDATE_LOGIN)
9566: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
9567: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
9568: '4158', -- facct account number
9569: '4158', -- ussgl account number
9570: 'E', -- balance type
9571: 'N', -- authority type
9595:
9596: --- Seed data end for Enhancement 1541559
9597:
9598:
9599: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
9600: SGL_ATTRIBUTES_ID,
9601: FACTS_ACCT_NUMBER,
9602: USSGL_ACCT_NUMBER,
9603: BALANCE_TYPE,
9624: LAST_UPDATE_DATE,
9625: LAST_UPDATED_BY,
9626: LAST_UPDATE_LOGIN)
9627: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
9628: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
9629: '4160', -- facct account number
9630: '4160', -- ussgl account number
9631: 'E', -- balance type
9632: 'N', -- authority type
9652: sysdate, -- last update date
9653: FND_GLOBAL.USER_ID, -- last updated by
9654: FND_GLOBAL.USER_ID -- last updated login
9655: );
9656: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
9657: SGL_ATTRIBUTES_ID,
9658: FACTS_ACCT_NUMBER,
9659: USSGL_ACCT_NUMBER,
9660: BALANCE_TYPE,
9681: LAST_UPDATE_DATE,
9682: LAST_UPDATED_BY,
9683: LAST_UPDATE_LOGIN)
9684: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
9685: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
9686: '4165', -- facct account number
9687: '4165', -- ussgl account number
9688: 'E', -- balance type
9689: 'N', -- authority type
9712: );
9713:
9714: -- Seed data added for Enhancement 1541559
9715:
9716: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
9717: SGL_ATTRIBUTES_ID,
9718: FACTS_ACCT_NUMBER,
9719: USSGL_ACCT_NUMBER,
9720: BALANCE_TYPE,
9741: LAST_UPDATE_DATE,
9742: LAST_UPDATED_BY,
9743: LAST_UPDATE_LOGIN)
9744: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
9745: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
9746: '4166', -- facct account number
9747: '4166', -- ussgl account number
9748: 'S', -- balance type
9749: 'N', -- authority type
9771: FND_GLOBAL.USER_ID -- last updated login
9772: );
9773:
9774:
9775: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
9776: SGL_ATTRIBUTES_ID,
9777: FACTS_ACCT_NUMBER,
9778: USSGL_ACCT_NUMBER,
9779: BALANCE_TYPE,
9800: LAST_UPDATE_DATE,
9801: LAST_UPDATED_BY,
9802: LAST_UPDATE_LOGIN)
9803: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
9804: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
9805: '4167', -- facct account number
9806: '4167', -- ussgl account number
9807: 'E', -- balance type
9808: 'N', -- authority type
9829: FND_GLOBAL.USER_ID, -- last updated by
9830: FND_GLOBAL.USER_ID -- last updated login
9831: );
9832: -- Seed data end for enhancement 1541559
9833: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
9834: SGL_ATTRIBUTES_ID,
9835: FACTS_ACCT_NUMBER,
9836: USSGL_ACCT_NUMBER,
9837: BALANCE_TYPE,
9858: LAST_UPDATE_DATE,
9859: LAST_UPDATED_BY,
9860: LAST_UPDATE_LOGIN)
9861: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
9862: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
9863: '4170', -- facct account number
9864: '4170', -- ussgl account number
9865: 'E', -- balance type
9866: 'P', -- authority type
9886: sysdate, -- last update date
9887: FND_GLOBAL.USER_ID, -- last updated by
9888: FND_GLOBAL.USER_ID -- last updated login
9889: );
9890: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
9891: SGL_ATTRIBUTES_ID,
9892: FACTS_ACCT_NUMBER,
9893: USSGL_ACCT_NUMBER,
9894: BALANCE_TYPE,
9915: LAST_UPDATE_DATE,
9916: LAST_UPDATED_BY,
9917: LAST_UPDATE_LOGIN)
9918: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
9919: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
9920: '4175', -- facct account number
9921: '4175', -- ussgl account number
9922: 'E', -- balance type
9923: 'P', -- authority type
9943: sysdate, -- last update date
9944: FND_GLOBAL.USER_ID, -- last updated by
9945: FND_GLOBAL.USER_ID -- last updated login
9946: );
9947: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
9948: SGL_ATTRIBUTES_ID,
9949: FACTS_ACCT_NUMBER,
9950: USSGL_ACCT_NUMBER,
9951: BALANCE_TYPE,
9972: LAST_UPDATE_DATE,
9973: LAST_UPDATED_BY,
9974: LAST_UPDATE_LOGIN)
9975: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
9976: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
9977: '4176', -- facct account number
9978: '4176', -- ussgl account number
9979: 'E', -- balance type
9980: 'N', -- authority type
10000: sysdate, -- last update date
10001: FND_GLOBAL.USER_ID, -- last updated by
10002: FND_GLOBAL.USER_ID -- last updated login
10003: );
10004: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
10005: SGL_ATTRIBUTES_ID,
10006: FACTS_ACCT_NUMBER,
10007: USSGL_ACCT_NUMBER,
10008: BALANCE_TYPE,
10029: LAST_UPDATE_DATE,
10030: LAST_UPDATED_BY,
10031: LAST_UPDATE_LOGIN)
10032: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
10033: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
10034: '4180', -- facct account number
10035: '4180', -- ussgl account number
10036: 'E', -- balance type
10037: 'N', -- authority type
10057: sysdate, -- last update date
10058: FND_GLOBAL.USER_ID, -- last updated by
10059: FND_GLOBAL.USER_ID -- last updated login
10060: );
10061: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
10062: SGL_ATTRIBUTES_ID,
10063: FACTS_ACCT_NUMBER,
10064: USSGL_ACCT_NUMBER,
10065: BALANCE_TYPE,
10086: LAST_UPDATE_DATE,
10087: LAST_UPDATED_BY,
10088: LAST_UPDATE_LOGIN)
10089: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
10090: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
10091: '4190', -- facct account number
10092: '4190', -- ussgl account number
10093: 'E', -- balance type
10094: 'N', -- authority type
10114: sysdate, -- last update date
10115: FND_GLOBAL.USER_ID, -- last updated by
10116: FND_GLOBAL.USER_ID -- last updated login
10117: );
10118: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
10119: SGL_ATTRIBUTES_ID,
10120: FACTS_ACCT_NUMBER,
10121: USSGL_ACCT_NUMBER,
10122: BALANCE_TYPE,
10143: LAST_UPDATE_DATE,
10144: LAST_UPDATED_BY,
10145: LAST_UPDATE_LOGIN)
10146: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
10147: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
10148: '4195', -- facct account number
10149: '4195', -- ussgl account number
10150: 'E', -- balance type
10151: 'N', -- authority type
10171: sysdate, -- last update date
10172: FND_GLOBAL.USER_ID, -- last updated by
10173: FND_GLOBAL.USER_ID -- last updated login
10174: );
10175: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
10176: SGL_ATTRIBUTES_ID,
10177: FACTS_ACCT_NUMBER,
10178: USSGL_ACCT_NUMBER,
10179: BALANCE_TYPE,
10200: LAST_UPDATE_DATE,
10201: LAST_UPDATED_BY,
10202: LAST_UPDATE_LOGIN)
10203: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
10204: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
10205: '4201', -- facct account number
10206: '4201', -- ussgl account number
10207: 'S', -- balance type
10208: 'N', -- authority type
10228: sysdate, -- last update date
10229: FND_GLOBAL.USER_ID, -- last updated by
10230: FND_GLOBAL.USER_ID -- last updated login
10231: );
10232: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
10233: SGL_ATTRIBUTES_ID,
10234: FACTS_ACCT_NUMBER,
10235: USSGL_ACCT_NUMBER,
10236: BALANCE_TYPE,
10257: LAST_UPDATE_DATE,
10258: LAST_UPDATED_BY,
10259: LAST_UPDATE_LOGIN)
10260: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
10261: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
10262: '4210', -- facct account number
10263: '4210', -- ussgl account number
10264: 'E', -- balance type
10265: 'N', -- authority type
10285: sysdate, -- last update date
10286: FND_GLOBAL.USER_ID, -- last updated by
10287: FND_GLOBAL.USER_ID -- last updated login
10288: );
10289: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
10290: SGL_ATTRIBUTES_ID,
10291: FACTS_ACCT_NUMBER,
10292: USSGL_ACCT_NUMBER,
10293: BALANCE_TYPE,
10314: LAST_UPDATE_DATE,
10315: LAST_UPDATED_BY,
10316: LAST_UPDATE_LOGIN)
10317: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
10318: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
10319: '4215', -- facct account number
10320: '4215', -- ussgl account number
10321: 'E', -- balance type
10322: 'N', -- authority type
10342: sysdate, -- last update date
10343: FND_GLOBAL.USER_ID, -- last updated by
10344: FND_GLOBAL.USER_ID -- last updated login
10345: );
10346: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
10347: SGL_ATTRIBUTES_ID,
10348: FACTS_ACCT_NUMBER,
10349: USSGL_ACCT_NUMBER,
10350: BALANCE_TYPE,
10371: LAST_UPDATE_DATE,
10372: LAST_UPDATED_BY,
10373: LAST_UPDATE_LOGIN)
10374: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
10375: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
10376: '4221', -- facct account number
10377: '4221', -- ussgl account number
10378: 'S', -- balance type
10379: 'N', -- authority type
10399: sysdate, -- last update date
10400: FND_GLOBAL.USER_ID, -- last updated by
10401: FND_GLOBAL.USER_ID -- last updated login
10402: );
10403: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
10404: SGL_ATTRIBUTES_ID,
10405: FACTS_ACCT_NUMBER,
10406: USSGL_ACCT_NUMBER,
10407: BALANCE_TYPE,
10428: LAST_UPDATE_DATE,
10429: LAST_UPDATED_BY,
10430: LAST_UPDATE_LOGIN)
10431: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
10432: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
10433: '4222', -- facct account number
10434: '4222', -- ussgl account number
10435: 'S', -- balance type
10436: 'N', -- authority type
10456: sysdate, -- last update date
10457: FND_GLOBAL.USER_ID, -- last updated by
10458: FND_GLOBAL.USER_ID -- last updated login
10459: );
10460: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
10461: SGL_ATTRIBUTES_ID,
10462: FACTS_ACCT_NUMBER,
10463: USSGL_ACCT_NUMBER,
10464: BALANCE_TYPE,
10485: LAST_UPDATE_DATE,
10486: LAST_UPDATED_BY,
10487: LAST_UPDATE_LOGIN)
10488: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
10489: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
10490: '4225', -- facct account number
10491: '4225', -- ussgl account number
10492: 'S', -- balance type
10493: 'N', -- authority type
10513: sysdate, -- last update date
10514: FND_GLOBAL.USER_ID, -- last updated by
10515: FND_GLOBAL.USER_ID -- last updated login
10516: );
10517: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
10518: SGL_ATTRIBUTES_ID,
10519: FACTS_ACCT_NUMBER,
10520: USSGL_ACCT_NUMBER,
10521: BALANCE_TYPE,
10542: LAST_UPDATE_DATE,
10543: LAST_UPDATED_BY,
10544: LAST_UPDATE_LOGIN)
10545: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
10546: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
10547: '4251', -- facct account number
10548: '4251', -- ussgl account number
10549: 'S', -- balance type
10550: 'N', -- authority type
10570: sysdate, -- last update date
10571: FND_GLOBAL.USER_ID, -- last updated by
10572: FND_GLOBAL.USER_ID -- last updated login
10573: );
10574: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
10575: SGL_ATTRIBUTES_ID,
10576: FACTS_ACCT_NUMBER,
10577: USSGL_ACCT_NUMBER,
10578: BALANCE_TYPE,
10599: LAST_UPDATE_DATE,
10600: LAST_UPDATED_BY,
10601: LAST_UPDATE_LOGIN)
10602: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
10603: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
10604: '4252', -- facct account number
10605: '4252', -- ussgl account number
10606: 'E', -- balance type
10607: 'N', -- authority type
10627: sysdate, -- last update date
10628: FND_GLOBAL.USER_ID, -- last updated by
10629: FND_GLOBAL.USER_ID -- last updated login
10630: );
10631: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
10632: SGL_ATTRIBUTES_ID,
10633: FACTS_ACCT_NUMBER,
10634: USSGL_ACCT_NUMBER,
10635: BALANCE_TYPE,
10656: LAST_UPDATE_DATE,
10657: LAST_UPDATED_BY,
10658: LAST_UPDATE_LOGIN)
10659: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
10660: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
10661: '4255', -- facct account number
10662: '4255', -- ussgl account number
10663: 'E', -- balance type
10664: 'N', -- authority type
10687: );
10688:
10689: -- Seed data added for Enhancement 1541559
10690:
10691: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
10692: SGL_ATTRIBUTES_ID,
10693: FACTS_ACCT_NUMBER,
10694: USSGL_ACCT_NUMBER,
10695: BALANCE_TYPE,
10716: LAST_UPDATE_DATE,
10717: LAST_UPDATED_BY,
10718: LAST_UPDATE_LOGIN)
10719: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
10720: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
10721: '4260', -- facct account number
10722: '4260', -- ussgl account number
10723: 'E', -- balance type
10724: 'N', -- authority type
10747: );
10748:
10749: -- seed data ended for enhancement 1541559
10750:
10751: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
10752: SGL_ATTRIBUTES_ID,
10753: FACTS_ACCT_NUMBER,
10754: USSGL_ACCT_NUMBER,
10755: BALANCE_TYPE,
10776: LAST_UPDATE_DATE,
10777: LAST_UPDATED_BY,
10778: LAST_UPDATE_LOGIN)
10779: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
10780: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
10781: '4261', -- facct account number
10782: '4261', -- ussgl account number
10783: 'E', -- balance type
10784: 'N', -- authority type
10804: sysdate, -- last update date
10805: FND_GLOBAL.USER_ID, -- last updated by
10806: FND_GLOBAL.USER_ID -- last updated login
10807: );
10808: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
10809: SGL_ATTRIBUTES_ID,
10810: FACTS_ACCT_NUMBER,
10811: USSGL_ACCT_NUMBER,
10812: BALANCE_TYPE,
10833: LAST_UPDATE_DATE,
10834: LAST_UPDATED_BY,
10835: LAST_UPDATE_LOGIN)
10836: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
10837: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
10838: '4262', -- facct account number
10839: '4262', -- ussgl account number
10840: 'E', -- balance type
10841: 'N', -- authority type
10861: sysdate, -- last update date
10862: FND_GLOBAL.USER_ID, -- last updated by
10863: FND_GLOBAL.USER_ID -- last updated login
10864: );
10865: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
10866: SGL_ATTRIBUTES_ID,
10867: FACTS_ACCT_NUMBER,
10868: USSGL_ACCT_NUMBER,
10869: BALANCE_TYPE,
10890: LAST_UPDATE_DATE,
10891: LAST_UPDATED_BY,
10892: LAST_UPDATE_LOGIN)
10893: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
10894: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
10895: '4263', -- facct account number
10896: '4263', -- ussgl account number
10897: 'E', -- balance type
10898: 'N', -- authority type
10918: sysdate, -- last update date
10919: FND_GLOBAL.USER_ID, -- last updated by
10920: FND_GLOBAL.USER_ID -- last updated login
10921: );
10922: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
10923: SGL_ATTRIBUTES_ID,
10924: FACTS_ACCT_NUMBER,
10925: USSGL_ACCT_NUMBER,
10926: BALANCE_TYPE,
10947: LAST_UPDATE_DATE,
10948: LAST_UPDATED_BY,
10949: LAST_UPDATE_LOGIN)
10950: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
10951: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
10952: '4264', -- facct account number
10953: '4264', -- ussgl account number
10954: 'E', -- balance type
10955: 'N', -- authority type
10975: sysdate, -- last update date
10976: FND_GLOBAL.USER_ID, -- last updated by
10977: FND_GLOBAL.USER_ID -- last updated login
10978: );
10979: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
10980: SGL_ATTRIBUTES_ID,
10981: FACTS_ACCT_NUMBER,
10982: USSGL_ACCT_NUMBER,
10983: BALANCE_TYPE,
11004: LAST_UPDATE_DATE,
11005: LAST_UPDATED_BY,
11006: LAST_UPDATE_LOGIN)
11007: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
11008: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
11009: '4265', -- facct account number
11010: '4265', -- ussgl account number
11011: 'E', -- balance type
11012: 'N', -- authority type
11032: sysdate, -- last update date
11033: FND_GLOBAL.USER_ID, -- last updated by
11034: FND_GLOBAL.USER_ID -- last updated login
11035: );
11036: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
11037: SGL_ATTRIBUTES_ID,
11038: FACTS_ACCT_NUMBER,
11039: USSGL_ACCT_NUMBER,
11040: BALANCE_TYPE,
11061: LAST_UPDATE_DATE,
11062: LAST_UPDATED_BY,
11063: LAST_UPDATE_LOGIN)
11064: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
11065: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
11066: '4266', -- facct account number
11067: '4266', -- ussgl account number
11068: 'E', -- balance type
11069: 'S', -- authority type
11091: FND_GLOBAL.USER_ID -- last updated login
11092: );
11093:
11094: -- Seed data added for Enhancement 1541559
11095: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
11096: SGL_ATTRIBUTES_ID,
11097: FACTS_ACCT_NUMBER,
11098: USSGL_ACCT_NUMBER,
11099: BALANCE_TYPE,
11120: LAST_UPDATE_DATE,
11121: LAST_UPDATED_BY,
11122: LAST_UPDATE_LOGIN)
11123: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
11124: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
11125: '4267', -- facct account number
11126: '4267', -- ussgl account number
11127: 'E', -- balance type
11128: 'N', -- authority type
11151: );
11152:
11153: -- Seed data Ended for Enhancement 1541559
11154:
11155: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
11156: SGL_ATTRIBUTES_ID,
11157: FACTS_ACCT_NUMBER,
11158: USSGL_ACCT_NUMBER,
11159: BALANCE_TYPE,
11180: LAST_UPDATE_DATE,
11181: LAST_UPDATED_BY,
11182: LAST_UPDATE_LOGIN)
11183: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
11184: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
11185: '4271', -- facct account number
11186: '4271', -- ussgl account number
11187: 'E', -- balance type
11188: 'N', -- authority type
11208: sysdate, -- last update date
11209: FND_GLOBAL.USER_ID, -- last updated by
11210: FND_GLOBAL.USER_ID -- last updated login
11211: );
11212: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
11213: SGL_ATTRIBUTES_ID,
11214: FACTS_ACCT_NUMBER,
11215: USSGL_ACCT_NUMBER,
11216: BALANCE_TYPE,
11237: LAST_UPDATE_DATE,
11238: LAST_UPDATED_BY,
11239: LAST_UPDATE_LOGIN)
11240: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
11241: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
11242: '4272', -- facct account number
11243: '4272', -- ussgl account number
11244: 'E', -- balance type
11245: 'N', -- authority type
11265: sysdate, -- last update date
11266: FND_GLOBAL.USER_ID, -- last updated by
11267: FND_GLOBAL.USER_ID -- last updated login
11268: );
11269: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
11270: SGL_ATTRIBUTES_ID,
11271: FACTS_ACCT_NUMBER,
11272: USSGL_ACCT_NUMBER,
11273: BALANCE_TYPE,
11294: LAST_UPDATE_DATE,
11295: LAST_UPDATED_BY,
11296: LAST_UPDATE_LOGIN)
11297: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
11298: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
11299: '4273', -- facct account number
11300: '4273', -- ussgl account number
11301: 'E', -- balance type
11302: 'N', -- authority type
11322: sysdate, -- last update date
11323: FND_GLOBAL.USER_ID, -- last updated by
11324: FND_GLOBAL.USER_ID -- last updated login
11325: );
11326: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
11327: SGL_ATTRIBUTES_ID,
11328: FACTS_ACCT_NUMBER,
11329: USSGL_ACCT_NUMBER,
11330: BALANCE_TYPE,
11351: LAST_UPDATE_DATE,
11352: LAST_UPDATED_BY,
11353: LAST_UPDATE_LOGIN)
11354: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
11355: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
11356: '4274', -- facct account number
11357: '4274', -- ussgl account number
11358: 'E', -- balance type
11359: 'N', -- authority type
11379: sysdate, -- last update date
11380: FND_GLOBAL.USER_ID, -- last updated by
11381: FND_GLOBAL.USER_ID -- last updated login
11382: );
11383: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
11384: SGL_ATTRIBUTES_ID,
11385: FACTS_ACCT_NUMBER,
11386: USSGL_ACCT_NUMBER,
11387: BALANCE_TYPE,
11408: LAST_UPDATE_DATE,
11409: LAST_UPDATED_BY,
11410: LAST_UPDATE_LOGIN)
11411: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
11412: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
11413: '4275', -- facct account number
11414: '4275', -- ussgl account number
11415: 'E', -- balance type
11416: 'N', -- authority type
11436: sysdate, -- last update date
11437: FND_GLOBAL.USER_ID, -- last updated by
11438: FND_GLOBAL.USER_ID -- last updated login
11439: );
11440: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
11441: SGL_ATTRIBUTES_ID,
11442: FACTS_ACCT_NUMBER,
11443: USSGL_ACCT_NUMBER,
11444: BALANCE_TYPE,
11465: LAST_UPDATE_DATE,
11466: LAST_UPDATED_BY,
11467: LAST_UPDATE_LOGIN)
11468: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
11469: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
11470: '4276', -- facct account number
11471: '4276', -- ussgl account number
11472: 'E', -- balance type
11473: 'N', -- authority type
11493: sysdate, -- last update date
11494: FND_GLOBAL.USER_ID, -- last updated by
11495: FND_GLOBAL.USER_ID -- last updated login
11496: );
11497: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
11498: SGL_ATTRIBUTES_ID,
11499: FACTS_ACCT_NUMBER,
11500: USSGL_ACCT_NUMBER,
11501: BALANCE_TYPE,
11522: LAST_UPDATE_DATE,
11523: LAST_UPDATED_BY,
11524: LAST_UPDATE_LOGIN)
11525: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
11526: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
11527: '4277', -- facct account number
11528: '4277', -- ussgl account number
11529: 'E', -- balance type
11530: 'N', -- authority type
11550: sysdate, -- last update date
11551: FND_GLOBAL.USER_ID, -- last updated by
11552: FND_GLOBAL.USER_ID -- last updated login
11553: );
11554: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
11555: SGL_ATTRIBUTES_ID,
11556: FACTS_ACCT_NUMBER,
11557: USSGL_ACCT_NUMBER,
11558: BALANCE_TYPE,
11579: LAST_UPDATE_DATE,
11580: LAST_UPDATED_BY,
11581: LAST_UPDATE_LOGIN)
11582: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
11583: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
11584: '4281', -- facct account number
11585: '4281', -- ussgl account number
11586: 'S', -- balance type
11587: 'N', -- authority type
11607: sysdate, -- last update date
11608: FND_GLOBAL.USER_ID, -- last updated by
11609: FND_GLOBAL.USER_ID -- last updated login
11610: );
11611: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
11612: SGL_ATTRIBUTES_ID,
11613: FACTS_ACCT_NUMBER,
11614: USSGL_ACCT_NUMBER,
11615: BALANCE_TYPE,
11636: LAST_UPDATE_DATE,
11637: LAST_UPDATED_BY,
11638: LAST_UPDATE_LOGIN)
11639: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
11640: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
11641: '4282', -- facct account number
11642: '4282', -- ussgl account number
11643: 'S', -- balance type
11644: 'N', -- authority type
11664: sysdate, -- last update date
11665: FND_GLOBAL.USER_ID, -- last updated by
11666: FND_GLOBAL.USER_ID -- last updated login
11667: );
11668: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
11669: SGL_ATTRIBUTES_ID,
11670: FACTS_ACCT_NUMBER,
11671: USSGL_ACCT_NUMBER,
11672: BALANCE_TYPE,
11693: LAST_UPDATE_DATE,
11694: LAST_UPDATED_BY,
11695: LAST_UPDATE_LOGIN)
11696: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
11697: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
11698: '4283', -- facct account number
11699: '4283', -- ussgl account number
11700: 'S', -- balance type
11701: 'N', -- authority type
11721: sysdate, -- last update date
11722: FND_GLOBAL.USER_ID, -- last updated by
11723: FND_GLOBAL.USER_ID -- last updated login
11724: );
11725: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
11726: SGL_ATTRIBUTES_ID,
11727: FACTS_ACCT_NUMBER,
11728: USSGL_ACCT_NUMBER,
11729: BALANCE_TYPE,
11750: LAST_UPDATE_DATE,
11751: LAST_UPDATED_BY,
11752: LAST_UPDATE_LOGIN)
11753: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
11754: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
11755: '4284', -- facct account number
11756: '4284', -- ussgl account number
11757: 'S', -- balance type
11758: 'N', -- authority type
11778: sysdate, -- last update date
11779: FND_GLOBAL.USER_ID, -- last updated by
11780: FND_GLOBAL.USER_ID -- last updated login
11781: );
11782: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
11783: SGL_ATTRIBUTES_ID,
11784: FACTS_ACCT_NUMBER,
11785: USSGL_ACCT_NUMBER,
11786: BALANCE_TYPE,
11807: LAST_UPDATE_DATE,
11808: LAST_UPDATED_BY,
11809: LAST_UPDATE_LOGIN)
11810: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
11811: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
11812: '4285', -- facct account number
11813: '4285', -- ussgl account number
11814: 'S', -- balance type
11815: 'N', -- authority type
11835: sysdate, -- last update date
11836: FND_GLOBAL.USER_ID, -- last updated by
11837: FND_GLOBAL.USER_ID -- last updated login
11838: );
11839: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
11840: SGL_ATTRIBUTES_ID,
11841: FACTS_ACCT_NUMBER,
11842: USSGL_ACCT_NUMBER,
11843: BALANCE_TYPE,
11864: LAST_UPDATE_DATE,
11865: LAST_UPDATED_BY,
11866: LAST_UPDATE_LOGIN)
11867: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
11868: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
11869: '4286', -- facct account number
11870: '4286', -- ussgl account number
11871: 'S', -- balance type
11872: 'N', -- authority type
11892: sysdate, -- last update date
11893: FND_GLOBAL.USER_ID, -- last updated by
11894: FND_GLOBAL.USER_ID -- last updated login
11895: );
11896: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
11897: SGL_ATTRIBUTES_ID,
11898: FACTS_ACCT_NUMBER,
11899: USSGL_ACCT_NUMBER,
11900: BALANCE_TYPE,
11921: LAST_UPDATE_DATE,
11922: LAST_UPDATED_BY,
11923: LAST_UPDATE_LOGIN)
11924: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
11925: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
11926: '4287', -- facct account number
11927: '4287', -- ussgl account number
11928: 'S', -- balance type
11929: 'N', -- authority type
11949: sysdate, -- last update date
11950: FND_GLOBAL.USER_ID, -- last updated by
11951: FND_GLOBAL.USER_ID -- last updated login
11952: );
11953: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
11954: SGL_ATTRIBUTES_ID,
11955: FACTS_ACCT_NUMBER,
11956: USSGL_ACCT_NUMBER,
11957: BALANCE_TYPE,
11978: LAST_UPDATE_DATE,
11979: LAST_UPDATED_BY,
11980: LAST_UPDATE_LOGIN)
11981: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
11982: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
11983: '4310', -- facct account number
11984: '4310', -- ussgl account number
11985: 'E', -- balance type
11986: 'N', -- authority type
12006: sysdate, -- last update date
12007: FND_GLOBAL.USER_ID, -- last updated by
12008: FND_GLOBAL.USER_ID -- last updated login
12009: );
12010: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
12011: SGL_ATTRIBUTES_ID,
12012: FACTS_ACCT_NUMBER,
12013: USSGL_ACCT_NUMBER,
12014: BALANCE_TYPE,
12035: LAST_UPDATE_DATE,
12036: LAST_UPDATED_BY,
12037: LAST_UPDATE_LOGIN)
12038: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
12039: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
12040: '4350', -- facct account number
12041: '4350', -- ussgl account number
12042: 'E', -- balance type
12043: 'P', -- authority type
12063: sysdate, -- last update date
12064: FND_GLOBAL.USER_ID, -- last updated by
12065: FND_GLOBAL.USER_ID -- last updated login
12066: );
12067: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
12068: SGL_ATTRIBUTES_ID,
12069: FACTS_ACCT_NUMBER,
12070: USSGL_ACCT_NUMBER,
12071: BALANCE_TYPE,
12092: LAST_UPDATE_DATE,
12093: LAST_UPDATED_BY,
12094: LAST_UPDATE_LOGIN)
12095: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
12096: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
12097: '4391', -- facct account number
12098: '4391', -- ussgl account number
12099: 'E', -- balance type
12100: 'N', -- authority type
12120: sysdate, -- last update date
12121: FND_GLOBAL.USER_ID, -- last updated by
12122: FND_GLOBAL.USER_ID -- last updated login
12123: );
12124: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
12125: SGL_ATTRIBUTES_ID,
12126: FACTS_ACCT_NUMBER,
12127: USSGL_ACCT_NUMBER,
12128: BALANCE_TYPE,
12149: LAST_UPDATE_DATE,
12150: LAST_UPDATED_BY,
12151: LAST_UPDATE_LOGIN)
12152: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
12153: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
12154: '4392', -- facct account number
12155: '4392', -- ussgl account number
12156: 'E', -- balance type
12157: 'P', -- authority type
12177: sysdate, -- last update date
12178: FND_GLOBAL.USER_ID, -- last updated by
12179: FND_GLOBAL.USER_ID -- last updated login
12180: );
12181: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
12182: SGL_ATTRIBUTES_ID,
12183: FACTS_ACCT_NUMBER,
12184: USSGL_ACCT_NUMBER,
12185: BALANCE_TYPE,
12206: LAST_UPDATE_DATE,
12207: LAST_UPDATED_BY,
12208: LAST_UPDATE_LOGIN)
12209: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
12210: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
12211: '4393', -- facct account number
12212: '4393', -- ussgl account number
12213: 'E', -- balance type
12214: 'P', -- authority type
12235: FND_GLOBAL.USER_ID, -- last updated by
12236: FND_GLOBAL.USER_ID -- last updated login
12237: );
12238: -- Seed data added for enhancement 1541559
12239: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
12240: SGL_ATTRIBUTES_ID,
12241: FACTS_ACCT_NUMBER,
12242: USSGL_ACCT_NUMBER,
12243: BALANCE_TYPE,
12264: LAST_UPDATE_DATE,
12265: LAST_UPDATED_BY,
12266: LAST_UPDATE_LOGIN)
12267: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
12268: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
12269: '4394', -- facct account number
12270: '4394', -- ussgl account number
12271: 'S', -- balance type
12272: 'N', -- authority type
12295: );
12296:
12297: -- Seed data ended for enhancement 1541559
12298:
12299: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
12300: SGL_ATTRIBUTES_ID,
12301: FACTS_ACCT_NUMBER,
12302: USSGL_ACCT_NUMBER,
12303: BALANCE_TYPE,
12324: LAST_UPDATE_DATE,
12325: LAST_UPDATED_BY,
12326: LAST_UPDATE_LOGIN)
12327: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
12328: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
12329: '4395', -- facct account number
12330: '4395', -- ussgl account number
12331: 'E', -- balance type
12332: 'P', -- authority type
12352: sysdate, -- last update date
12353: FND_GLOBAL.USER_ID, -- last updated by
12354: FND_GLOBAL.USER_ID -- last updated login
12355: );
12356: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
12357: SGL_ATTRIBUTES_ID,
12358: FACTS_ACCT_NUMBER,
12359: USSGL_ACCT_NUMBER,
12360: BALANCE_TYPE,
12381: LAST_UPDATE_DATE,
12382: LAST_UPDATED_BY,
12383: LAST_UPDATE_LOGIN)
12384: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
12385: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
12386: '4396', -- facct account number
12387: '4396', -- ussgl account number
12388: 'E', -- balance type
12389: 'P', -- authority type
12412: );
12413:
12414: -- Seed data added for Enhancement 1541559
12415:
12416: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
12417: SGL_ATTRIBUTES_ID,
12418: FACTS_ACCT_NUMBER,
12419: USSGL_ACCT_NUMBER,
12420: BALANCE_TYPE,
12441: LAST_UPDATE_DATE,
12442: LAST_UPDATED_BY,
12443: LAST_UPDATE_LOGIN)
12444: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
12445: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
12446: '4397', -- facct account number
12447: '4397', -- ussgl account number
12448: 'S', -- balance type
12449: 'N', -- authority type
12470: FND_GLOBAL.USER_ID, -- last updated by
12471: FND_GLOBAL.USER_ID -- last updated login
12472: );
12473:
12474: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
12475: SGL_ATTRIBUTES_ID,
12476: FACTS_ACCT_NUMBER,
12477: USSGL_ACCT_NUMBER,
12478: BALANCE_TYPE,
12499: LAST_UPDATE_DATE,
12500: LAST_UPDATED_BY,
12501: LAST_UPDATE_LOGIN)
12502: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
12503: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
12504: '4398', -- facct account number
12505: '4398', -- ussgl account number
12506: 'S', -- balance type
12507: 'N', -- authority type
12529: FND_GLOBAL.USER_ID -- last updated login
12530: );
12531: -- Seed dadat ended for enhancement 1541559
12532:
12533: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
12534: SGL_ATTRIBUTES_ID,
12535: FACTS_ACCT_NUMBER,
12536: USSGL_ACCT_NUMBER,
12537: BALANCE_TYPE,
12558: LAST_UPDATE_DATE,
12559: LAST_UPDATED_BY,
12560: LAST_UPDATE_LOGIN)
12561: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
12562: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
12563: '4420', -- facct account number
12564: '4420', -- ussgl account number
12565: 'E', -- balance type
12566: 'N', -- authority type
12586: sysdate, -- last update date
12587: FND_GLOBAL.USER_ID, -- last updated by
12588: FND_GLOBAL.USER_ID -- last updated login
12589: );
12590: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
12591: SGL_ATTRIBUTES_ID,
12592: FACTS_ACCT_NUMBER,
12593: USSGL_ACCT_NUMBER,
12594: BALANCE_TYPE,
12615: LAST_UPDATE_DATE,
12616: LAST_UPDATED_BY,
12617: LAST_UPDATE_LOGIN)
12618: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
12619: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
12620: '4430', -- facct account number
12621: '4430', -- ussgl account number
12622: 'E', -- balance type
12623: 'N', -- authority type
12643: sysdate, -- last update date
12644: FND_GLOBAL.USER_ID, -- last updated by
12645: FND_GLOBAL.USER_ID -- last updated login
12646: );
12647: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
12648: SGL_ATTRIBUTES_ID,
12649: FACTS_ACCT_NUMBER,
12650: USSGL_ACCT_NUMBER,
12651: BALANCE_TYPE,
12672: LAST_UPDATE_DATE,
12673: LAST_UPDATED_BY,
12674: LAST_UPDATE_LOGIN)
12675: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
12676: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
12677: '4450', -- facct account number
12678: '4450', -- ussgl account number
12679: 'S', -- balance type
12680: 'N', -- authority type
12700: sysdate, -- last update date
12701: FND_GLOBAL.USER_ID, -- last updated by
12702: FND_GLOBAL.USER_ID -- last updated login
12703: );
12704: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
12705: SGL_ATTRIBUTES_ID,
12706: FACTS_ACCT_NUMBER,
12707: USSGL_ACCT_NUMBER,
12708: BALANCE_TYPE,
12729: LAST_UPDATE_DATE,
12730: LAST_UPDATED_BY,
12731: LAST_UPDATE_LOGIN)
12732: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
12733: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
12734: '4510', -- facct account number
12735: '4510', -- ussgl account number
12736: 'E', -- balance type
12737: 'N', -- authority type
12757: sysdate, -- last update date
12758: FND_GLOBAL.USER_ID, -- last updated by
12759: FND_GLOBAL.USER_ID -- last updated login
12760: );
12761: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
12762: SGL_ATTRIBUTES_ID,
12763: FACTS_ACCT_NUMBER,
12764: USSGL_ACCT_NUMBER,
12765: BALANCE_TYPE,
12786: LAST_UPDATE_DATE,
12787: LAST_UPDATED_BY,
12788: LAST_UPDATE_LOGIN)
12789: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
12790: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
12791: '4590', -- facct account number
12792: '4590', -- ussgl account number
12793: 'E', -- balance type
12794: 'N', -- authority type
12814: sysdate, -- last update date
12815: FND_GLOBAL.USER_ID, -- last updated by
12816: FND_GLOBAL.USER_ID -- last updated login
12817: );
12818: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
12819: SGL_ATTRIBUTES_ID,
12820: FACTS_ACCT_NUMBER,
12821: USSGL_ACCT_NUMBER,
12822: BALANCE_TYPE,
12843: LAST_UPDATE_DATE,
12844: LAST_UPDATED_BY,
12845: LAST_UPDATE_LOGIN)
12846: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
12847: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
12848: '4610', -- facct account number
12849: '4610', -- ussgl account number
12850: 'E', -- balance type
12851: 'N', -- authority type
12871: sysdate, -- last update date
12872: FND_GLOBAL.USER_ID, -- last updated by
12873: FND_GLOBAL.USER_ID -- last updated login
12874: );
12875: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
12876: SGL_ATTRIBUTES_ID,
12877: FACTS_ACCT_NUMBER,
12878: USSGL_ACCT_NUMBER,
12879: BALANCE_TYPE,
12900: LAST_UPDATE_DATE,
12901: LAST_UPDATED_BY,
12902: LAST_UPDATE_LOGIN)
12903: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
12904: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
12905: '4620', -- facct account number
12906: '4620', -- ussgl account number
12907: 'S', -- balance type
12908: 'N', -- authority type
12928: sysdate, -- last update date
12929: FND_GLOBAL.USER_ID, -- last updated by
12930: FND_GLOBAL.USER_ID -- last updated login
12931: );
12932: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
12933: SGL_ATTRIBUTES_ID,
12934: FACTS_ACCT_NUMBER,
12935: USSGL_ACCT_NUMBER,
12936: BALANCE_TYPE,
12957: LAST_UPDATE_DATE,
12958: LAST_UPDATED_BY,
12959: LAST_UPDATE_LOGIN)
12960: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
12961: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
12962: '4630', -- facct account number
12963: '4630', -- ussgl account number
12964: 'E', -- balance type
12965: 'N', -- authority type
12985: sysdate, -- last update date
12986: FND_GLOBAL.USER_ID, -- last updated by
12987: FND_GLOBAL.USER_ID -- last updated login
12988: );
12989: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
12990: SGL_ATTRIBUTES_ID,
12991: FACTS_ACCT_NUMBER,
12992: USSGL_ACCT_NUMBER,
12993: BALANCE_TYPE,
13014: LAST_UPDATE_DATE,
13015: LAST_UPDATED_BY,
13016: LAST_UPDATE_LOGIN)
13017: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
13018: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
13019: '4650', -- facct account number
13020: '4650', -- ussgl account number
13021: 'S', -- balance type
13022: 'N', -- authority type
13042: sysdate, -- last update date
13043: FND_GLOBAL.USER_ID, -- last updated by
13044: FND_GLOBAL.USER_ID -- last updated login
13045: );
13046: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
13047: SGL_ATTRIBUTES_ID,
13048: FACTS_ACCT_NUMBER,
13049: USSGL_ACCT_NUMBER,
13050: BALANCE_TYPE,
13071: LAST_UPDATE_DATE,
13072: LAST_UPDATED_BY,
13073: LAST_UPDATE_LOGIN)
13074: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
13075: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
13076: '4700', -- facct account number
13077: '4700', -- ussgl account number
13078: 'E', -- balance type
13079: 'N', -- authority type
13099: sysdate, -- last update date
13100: FND_GLOBAL.USER_ID, -- last updated by
13101: FND_GLOBAL.USER_ID -- last updated login
13102: );
13103: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
13104: SGL_ATTRIBUTES_ID,
13105: FACTS_ACCT_NUMBER,
13106: USSGL_ACCT_NUMBER,
13107: BALANCE_TYPE,
13128: LAST_UPDATE_DATE,
13129: LAST_UPDATED_BY,
13130: LAST_UPDATE_LOGIN)
13131: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
13132: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
13133: '4801', -- facct account number
13134: '4801', -- ussgl account number
13135: 'S', -- balance type
13136: 'N', -- authority type
13156: sysdate, -- last update date
13157: FND_GLOBAL.USER_ID, -- last updated by
13158: FND_GLOBAL.USER_ID -- last updated login
13159: );
13160: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
13161: SGL_ATTRIBUTES_ID,
13162: FACTS_ACCT_NUMBER,
13163: USSGL_ACCT_NUMBER,
13164: BALANCE_TYPE,
13185: LAST_UPDATE_DATE,
13186: LAST_UPDATED_BY,
13187: LAST_UPDATE_LOGIN)
13188: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
13189: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
13190: '4802', -- facct account number
13191: '4802', -- ussgl account number
13192: 'S', -- balance type
13193: 'N', -- authority type
13213: sysdate, -- last update date
13214: FND_GLOBAL.USER_ID, -- last updated by
13215: FND_GLOBAL.USER_ID -- last updated login
13216: );
13217: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
13218: SGL_ATTRIBUTES_ID,
13219: FACTS_ACCT_NUMBER,
13220: USSGL_ACCT_NUMBER,
13221: BALANCE_TYPE,
13242: LAST_UPDATE_DATE,
13243: LAST_UPDATED_BY,
13244: LAST_UPDATE_LOGIN)
13245: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
13246: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
13247: '4831', -- facct account number
13248: '4831', -- ussgl account number
13249: 'E', -- balance type
13250: 'N', -- authority type
13270: sysdate, -- last update date
13271: FND_GLOBAL.USER_ID, -- last updated by
13272: FND_GLOBAL.USER_ID -- last updated login
13273: );
13274: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
13275: SGL_ATTRIBUTES_ID,
13276: FACTS_ACCT_NUMBER,
13277: USSGL_ACCT_NUMBER,
13278: BALANCE_TYPE,
13299: LAST_UPDATE_DATE,
13300: LAST_UPDATED_BY,
13301: LAST_UPDATE_LOGIN)
13302: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
13303: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
13304: '4832', -- facct account number
13305: '4832', -- ussgl account number
13306: 'E', -- balance type
13307: 'N', -- authority type
13327: sysdate, -- last update date
13328: FND_GLOBAL.USER_ID, -- last updated by
13329: FND_GLOBAL.USER_ID -- last updated login
13330: );
13331: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
13332: SGL_ATTRIBUTES_ID,
13333: FACTS_ACCT_NUMBER,
13334: USSGL_ACCT_NUMBER,
13335: BALANCE_TYPE,
13356: LAST_UPDATE_DATE,
13357: LAST_UPDATED_BY,
13358: LAST_UPDATE_LOGIN)
13359: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
13360: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
13361: '4871', -- facct account number
13362: '4871', -- ussgl account number
13363: 'E', -- balance type
13364: 'N', -- authority type
13384: sysdate, -- last update date
13385: FND_GLOBAL.USER_ID, -- last updated by
13386: FND_GLOBAL.USER_ID -- last updated login
13387: );
13388: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
13389: SGL_ATTRIBUTES_ID,
13390: FACTS_ACCT_NUMBER,
13391: USSGL_ACCT_NUMBER,
13392: BALANCE_TYPE,
13413: LAST_UPDATE_DATE,
13414: LAST_UPDATED_BY,
13415: LAST_UPDATE_LOGIN)
13416: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
13417: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
13418: '4872', -- facct account number
13419: '4872', -- ussgl account number
13420: 'E', -- balance type
13421: 'N', -- authority type
13441: sysdate, -- last update date
13442: FND_GLOBAL.USER_ID, -- last updated by
13443: FND_GLOBAL.USER_ID -- last updated login
13444: );
13445: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
13446: SGL_ATTRIBUTES_ID,
13447: FACTS_ACCT_NUMBER,
13448: USSGL_ACCT_NUMBER,
13449: BALANCE_TYPE,
13470: LAST_UPDATE_DATE,
13471: LAST_UPDATED_BY,
13472: LAST_UPDATE_LOGIN)
13473: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
13474: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
13475: '4881', -- facct account number
13476: '4881', -- ussgl account number
13477: 'E', -- balance type
13478: 'N', -- authority type
13498: sysdate, -- last update date
13499: FND_GLOBAL.USER_ID, -- last updated by
13500: FND_GLOBAL.USER_ID -- last updated login
13501: );
13502: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
13503: SGL_ATTRIBUTES_ID,
13504: FACTS_ACCT_NUMBER,
13505: USSGL_ACCT_NUMBER,
13506: BALANCE_TYPE,
13527: LAST_UPDATE_DATE,
13528: LAST_UPDATED_BY,
13529: LAST_UPDATE_LOGIN)
13530: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
13531: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
13532: '4882', -- facct account number
13533: '4882', -- ussgl account number
13534: 'E', -- balance type
13535: 'N', -- authority type
13555: sysdate, -- last update date
13556: FND_GLOBAL.USER_ID, -- last updated by
13557: FND_GLOBAL.USER_ID -- last updated login
13558: );
13559: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
13560: SGL_ATTRIBUTES_ID,
13561: FACTS_ACCT_NUMBER,
13562: USSGL_ACCT_NUMBER,
13563: BALANCE_TYPE,
13584: LAST_UPDATE_DATE,
13585: LAST_UPDATED_BY,
13586: LAST_UPDATE_LOGIN)
13587: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
13588: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
13589: '4901', -- facct account number
13590: '4901', -- ussgl account number
13591: 'S', -- balance type
13592: 'N', -- authority type
13612: sysdate, -- last update date
13613: FND_GLOBAL.USER_ID, -- last updated by
13614: FND_GLOBAL.USER_ID -- last updated login
13615: );
13616: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
13617: SGL_ATTRIBUTES_ID,
13618: FACTS_ACCT_NUMBER,
13619: USSGL_ACCT_NUMBER,
13620: BALANCE_TYPE,
13641: LAST_UPDATE_DATE,
13642: LAST_UPDATED_BY,
13643: LAST_UPDATE_LOGIN)
13644: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
13645: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
13646: '4902', -- facct account number
13647: '4902', -- ussgl account number
13648: 'E', -- balance type
13649: 'N', -- authority type
13669: sysdate, -- last update date
13670: FND_GLOBAL.USER_ID, -- last updated by
13671: FND_GLOBAL.USER_ID -- last updated login
13672: );
13673: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
13674: SGL_ATTRIBUTES_ID,
13675: FACTS_ACCT_NUMBER,
13676: USSGL_ACCT_NUMBER,
13677: BALANCE_TYPE,
13698: LAST_UPDATE_DATE,
13699: LAST_UPDATED_BY,
13700: LAST_UPDATE_LOGIN)
13701: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
13702: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
13703: '4931', -- facct account number
13704: '4931', -- ussgl account number
13705: 'E', -- balance type
13706: 'N', -- authority type
13726: sysdate, -- last update date
13727: FND_GLOBAL.USER_ID, -- last updated by
13728: FND_GLOBAL.USER_ID -- last updated login
13729: );
13730: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
13731: SGL_ATTRIBUTES_ID,
13732: FACTS_ACCT_NUMBER,
13733: USSGL_ACCT_NUMBER,
13734: BALANCE_TYPE,
13755: LAST_UPDATE_DATE,
13756: LAST_UPDATED_BY,
13757: LAST_UPDATE_LOGIN)
13758: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
13759: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
13760: '4971', -- facct account number
13761: '4971', -- ussgl account number
13762: 'E', -- balance type
13763: 'N', -- authority type
13783: sysdate, -- last update date
13784: FND_GLOBAL.USER_ID, -- last updated by
13785: FND_GLOBAL.USER_ID -- last updated login
13786: );
13787: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
13788: SGL_ATTRIBUTES_ID,
13789: FACTS_ACCT_NUMBER,
13790: USSGL_ACCT_NUMBER,
13791: BALANCE_TYPE,
13812: LAST_UPDATE_DATE,
13813: LAST_UPDATED_BY,
13814: LAST_UPDATE_LOGIN)
13815: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
13816: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
13817: '4972', -- facct account number
13818: '4972', -- ussgl account number
13819: 'E', -- balance type
13820: 'N', -- authority type
13840: sysdate, -- last update date
13841: FND_GLOBAL.USER_ID, -- last updated by
13842: FND_GLOBAL.USER_ID -- last updated login
13843: );
13844: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
13845: SGL_ATTRIBUTES_ID,
13846: FACTS_ACCT_NUMBER,
13847: USSGL_ACCT_NUMBER,
13848: BALANCE_TYPE,
13869: LAST_UPDATE_DATE,
13870: LAST_UPDATED_BY,
13871: LAST_UPDATE_LOGIN)
13872: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
13873: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
13874: '4981', -- facct account number
13875: '4981', -- ussgl account number
13876: 'E', -- balance type
13877: 'N', -- authority type
13897: sysdate, -- last update date
13898: FND_GLOBAL.USER_ID, -- last updated by
13899: FND_GLOBAL.USER_ID -- last updated login
13900: );
13901: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
13902: SGL_ATTRIBUTES_ID,
13903: FACTS_ACCT_NUMBER,
13904: USSGL_ACCT_NUMBER,
13905: BALANCE_TYPE,
13926: LAST_UPDATE_DATE,
13927: LAST_UPDATED_BY,
13928: LAST_UPDATE_LOGIN)
13929: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
13930: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
13931: '4982', -- facct account number
13932: '4982', -- ussgl account number
13933: 'E', -- balance type
13934: 'N', -- authority type