8: v_sob_name Varchar2(100);
9: begin
10: -- Verify that the table is not already seeded for an specific set_of_books
11:
12: v_sob := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
13: v_sob_name := FND_PROFILE.VALUE('GL_SET_OF_BKS_NAME');
14:
15: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
16: SGL_ATTRIBUTES_ID,
9: begin
10: -- Verify that the table is not already seeded for an specific set_of_books
11:
12: v_sob := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
13: v_sob_name := FND_PROFILE.VALUE('GL_SET_OF_BKS_NAME');
14:
15: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
16: SGL_ATTRIBUTES_ID,
17: FACTS_ACCT_NUMBER,
39: CREATED_BY,
40: LAST_UPDATE_DATE,
41: LAST_UPDATED_BY,
42: LAST_UPDATE_LOGIN)
43: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
44: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
45: '2990', -- facct account number
46: '2990', -- ussgl account number
47: 'E', -- balance type
96: CREATED_BY,
97: LAST_UPDATE_DATE,
98: LAST_UPDATED_BY,
99: LAST_UPDATE_LOGIN)
100: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
101: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
102: '2995', -- facct account number
103: '2995', -- ussgl account number
104: 'E', -- balance type
153: CREATED_BY,
154: LAST_UPDATE_DATE,
155: LAST_UPDATED_BY,
156: LAST_UPDATE_LOGIN)
157: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
158: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
159: '3100', -- facct account number
160: '3100', -- ussgl account number
161: 'E', -- balance type
210: CREATED_BY,
211: LAST_UPDATE_DATE,
212: LAST_UPDATED_BY,
213: LAST_UPDATE_LOGIN)
214: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
215: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
216: '3105', -- facct account number
217: '3105', -- ussgl account number
218: 'E', -- balance type
267: CREATED_BY,
268: LAST_UPDATE_DATE,
269: LAST_UPDATED_BY,
270: LAST_UPDATE_LOGIN)
271: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
272: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
273: '3310', -- facct account number
274: '3310', -- ussgl account number
275: 'E', -- balance type
324: CREATED_BY,
325: LAST_UPDATE_DATE,
326: LAST_UPDATED_BY,
327: LAST_UPDATE_LOGIN)
328: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
329: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
330: '5100', -- facct account number
331: '5100', -- ussgl account number
332: 'E', -- balance type
381: CREATED_BY,
382: LAST_UPDATE_DATE,
383: LAST_UPDATED_BY,
384: LAST_UPDATE_LOGIN)
385: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
386: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
387: '5109', -- facct account number
388: '5109', -- ussgl account number
389: 'E', -- balance type
438: CREATED_BY,
439: LAST_UPDATE_DATE,
440: LAST_UPDATED_BY,
441: LAST_UPDATE_LOGIN)
442: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
443: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
444: '5200', -- facct account number
445: '5200', -- ussgl account number
446: 'E', -- balance type
495: CREATED_BY,
496: LAST_UPDATE_DATE,
497: LAST_UPDATED_BY,
498: LAST_UPDATE_LOGIN)
499: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
500: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
501: '5209', -- facct account number
502: '5209', -- ussgl account number
503: 'E', -- balance type
552: CREATED_BY,
553: LAST_UPDATE_DATE,
554: LAST_UPDATED_BY,
555: LAST_UPDATE_LOGIN)
556: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
557: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
558: '5310', -- facct account number
559: '5310', -- ussgl account number
560: 'E', -- balance type
609: CREATED_BY,
610: LAST_UPDATE_DATE,
611: LAST_UPDATED_BY,
612: LAST_UPDATE_LOGIN)
613: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
614: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
615: '5319', -- facct account number
616: '5319', -- ussgl account number
617: 'E', -- balance type
666: CREATED_BY,
667: LAST_UPDATE_DATE,
668: LAST_UPDATED_BY,
669: LAST_UPDATE_LOGIN)
670: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
671: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
672: '5320', -- facct account number
673: '5320', -- ussgl account number
674: 'E', -- balance type
723: CREATED_BY,
724: LAST_UPDATE_DATE,
725: LAST_UPDATED_BY,
726: LAST_UPDATE_LOGIN)
727: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
728: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
729: '5329', -- facct account number
730: '5329', -- ussgl account number
731: 'E', -- balance type
780: CREATED_BY,
781: LAST_UPDATE_DATE,
782: LAST_UPDATED_BY,
783: LAST_UPDATE_LOGIN)
784: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
785: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
786: '5400', -- facct account number
787: '5400', -- ussgl account number
788: 'E', -- balance type
837: CREATED_BY,
838: LAST_UPDATE_DATE,
839: LAST_UPDATED_BY,
840: LAST_UPDATE_LOGIN)
841: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
842: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
843: '5409', -- facct account number
844: '5409', -- ussgl account number
845: 'E', -- balance type
894: CREATED_BY,
895: LAST_UPDATE_DATE,
896: LAST_UPDATED_BY,
897: LAST_UPDATE_LOGIN)
898: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
899: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
900: '5500', -- facct account number
901: '5500', -- ussgl account number
902: 'E', -- balance type
951: CREATED_BY,
952: LAST_UPDATE_DATE,
953: LAST_UPDATED_BY,
954: LAST_UPDATE_LOGIN)
955: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
956: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
957: '5509', -- facct account number
958: '5509', -- ussgl account number
959: 'E', -- balance type
1008: CREATED_BY,
1009: LAST_UPDATE_DATE,
1010: LAST_UPDATED_BY,
1011: LAST_UPDATE_LOGIN)
1012: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1013: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1014: '5600', -- facct account number
1015: '5600', -- ussgl account number
1016: 'E', -- balance type
1065: CREATED_BY,
1066: LAST_UPDATE_DATE,
1067: LAST_UPDATED_BY,
1068: LAST_UPDATE_LOGIN)
1069: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1070: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1071: '5609', -- facct account number
1072: '5609', -- ussgl account number
1073: 'E', -- balance type
1122: CREATED_BY,
1123: LAST_UPDATE_DATE,
1124: LAST_UPDATED_BY,
1125: LAST_UPDATE_LOGIN)
1126: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1127: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1128: '5610', -- facct account number
1129: '5610', -- ussgl account number
1130: 'E', -- balance type
1179: CREATED_BY,
1180: LAST_UPDATE_DATE,
1181: LAST_UPDATED_BY,
1182: LAST_UPDATE_LOGIN)
1183: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1184: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1185: '5619', -- facct account number
1186: '5619', -- ussgl account number
1187: 'E', -- balance type
1236: CREATED_BY,
1237: LAST_UPDATE_DATE,
1238: LAST_UPDATED_BY,
1239: LAST_UPDATE_LOGIN)
1240: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1241: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1242: '5700', -- facct account number
1243: '5700', -- ussgl account number
1244: 'E', -- balance type
1293: CREATED_BY,
1294: LAST_UPDATE_DATE,
1295: LAST_UPDATED_BY,
1296: LAST_UPDATE_LOGIN)
1297: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1298: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1299: '5720', -- facct account number
1300: '5720', -- ussgl account number
1301: 'E', -- balance type
1350: CREATED_BY,
1351: LAST_UPDATE_DATE,
1352: LAST_UPDATED_BY,
1353: LAST_UPDATE_LOGIN)
1354: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1355: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1356: '5730', -- facct account number
1357: '5730', -- ussgl account number
1358: 'E', -- balance type
1407: CREATED_BY,
1408: LAST_UPDATE_DATE,
1409: LAST_UPDATED_BY,
1410: LAST_UPDATE_LOGIN)
1411: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1412: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1413: '5740', -- facct account number
1414: '5740', -- ussgl account number
1415: 'E', -- balance type
1464: CREATED_BY,
1465: LAST_UPDATE_DATE,
1466: LAST_UPDATED_BY,
1467: LAST_UPDATE_LOGIN)
1468: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1469: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1470: '5745', -- facct account number
1471: '5745', -- ussgl account number
1472: 'E', -- balance type
1521: CREATED_BY,
1522: LAST_UPDATE_DATE,
1523: LAST_UPDATED_BY,
1524: LAST_UPDATE_LOGIN)
1525: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1526: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1527: '5750', -- facct account number
1528: '5750', -- ussgl account number
1529: 'E', -- balance type
1578: CREATED_BY,
1579: LAST_UPDATE_DATE,
1580: LAST_UPDATED_BY,
1581: LAST_UPDATE_LOGIN)
1582: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1583: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1584: '5755', -- facct account number
1585: '5755', -- ussgl account number
1586: 'E', -- balance type
1635: CREATED_BY,
1636: LAST_UPDATE_DATE,
1637: LAST_UPDATED_BY,
1638: LAST_UPDATE_LOGIN)
1639: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1640: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1641: '5760', -- facct account number
1642: '5760', -- ussgl account number
1643: 'E', -- balance type
1692: CREATED_BY,
1693: LAST_UPDATE_DATE,
1694: LAST_UPDATED_BY,
1695: LAST_UPDATE_LOGIN)
1696: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1697: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1698: '5765', -- facct account number
1699: '5765', -- ussgl account number
1700: 'E', -- balance type
1749: CREATED_BY,
1750: LAST_UPDATE_DATE,
1751: LAST_UPDATED_BY,
1752: LAST_UPDATE_LOGIN)
1753: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1754: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1755: '5780', -- facct account number
1756: '5780', -- ussgl account number
1757: 'E', -- balance type
1806: CREATED_BY,
1807: LAST_UPDATE_DATE,
1808: LAST_UPDATED_BY,
1809: LAST_UPDATE_LOGIN)
1810: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1811: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1812: '5790', -- facct account number
1813: '5790', -- ussgl account number
1814: 'E', -- balance type
1863: CREATED_BY,
1864: LAST_UPDATE_DATE,
1865: LAST_UPDATED_BY,
1866: LAST_UPDATE_LOGIN)
1867: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1868: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1869: '5799', -- facct account number
1870: '5799', -- ussgl account number
1871: 'E', -- balance type
1920: CREATED_BY,
1921: LAST_UPDATE_DATE,
1922: LAST_UPDATED_BY,
1923: LAST_UPDATE_LOGIN)
1924: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1925: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1926: '5800', -- facct account number
1927: '5800', -- ussgl account number
1928: 'E', -- balance type
1977: CREATED_BY,
1978: LAST_UPDATE_DATE,
1979: LAST_UPDATED_BY,
1980: LAST_UPDATE_LOGIN)
1981: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1982: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1983: '5801', -- facct account number
1984: '5801', -- ussgl account number
1985: 'E', -- balance type
2034: CREATED_BY,
2035: LAST_UPDATE_DATE,
2036: LAST_UPDATED_BY,
2037: LAST_UPDATE_LOGIN)
2038: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2039: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2040: '5809', -- facct account number
2041: '5809', -- ussgl account number
2042: 'E', -- balance type
2091: CREATED_BY,
2092: LAST_UPDATE_DATE,
2093: LAST_UPDATED_BY,
2094: LAST_UPDATE_LOGIN)
2095: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2096: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2097: '5890', -- facct account number
2098: '5890', -- ussgl account number
2099: 'E', -- balance type
2148: CREATED_BY,
2149: LAST_UPDATE_DATE,
2150: LAST_UPDATED_BY,
2151: LAST_UPDATE_LOGIN)
2152: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2153: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2154: '5900', -- facct account number
2155: '5900', -- ussgl account number
2156: 'E', -- balance type
2205: CREATED_BY,
2206: LAST_UPDATE_DATE,
2207: LAST_UPDATED_BY,
2208: LAST_UPDATE_LOGIN)
2209: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2210: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2211: '5909', -- facct account number
2212: '5909', -- ussgl account number
2213: 'E', -- balance type
2262: CREATED_BY,
2263: LAST_UPDATE_DATE,
2264: LAST_UPDATED_BY,
2265: LAST_UPDATE_LOGIN)
2266: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2267: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2268: '5990', -- facct account number
2269: '5990', -- ussgl account number
2270: 'E', -- balance type
2319: CREATED_BY,
2320: LAST_UPDATE_DATE,
2321: LAST_UPDATED_BY,
2322: LAST_UPDATE_LOGIN)
2323: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2324: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2325: '5991', -- facct account number
2326: '5991', -- ussgl account number
2327: 'E', -- balance type
2376: CREATED_BY,
2377: LAST_UPDATE_DATE,
2378: LAST_UPDATED_BY,
2379: LAST_UPDATE_LOGIN)
2380: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2381: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2382: '6100', -- facct account number
2383: '6100', -- ussgl account number
2384: 'E', -- balance type
2433: CREATED_BY,
2434: LAST_UPDATE_DATE,
2435: LAST_UPDATED_BY,
2436: LAST_UPDATE_LOGIN)
2437: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2438: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2439: '6190', -- facct account number
2440: '6190', -- ussgl account number
2441: 'E', -- balance type
2490: CREATED_BY,
2491: LAST_UPDATE_DATE,
2492: LAST_UPDATED_BY,
2493: LAST_UPDATE_LOGIN)
2494: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2495: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2496: '6199', -- facct account number
2497: '6199', -- ussgl account number
2498: 'E', -- balance type
2547: CREATED_BY,
2548: LAST_UPDATE_DATE,
2549: LAST_UPDATED_BY,
2550: LAST_UPDATE_LOGIN)
2551: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2552: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2553: '6310', -- facct account number
2554: '6310', -- ussgl account number
2555: 'E', -- balance type
2604: CREATED_BY,
2605: LAST_UPDATE_DATE,
2606: LAST_UPDATED_BY,
2607: LAST_UPDATE_LOGIN)
2608: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2609: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2610: '6320', -- facct account number
2611: '6320', -- ussgl account number
2612: 'E', -- balance type
2661: CREATED_BY,
2662: LAST_UPDATE_DATE,
2663: LAST_UPDATED_BY,
2664: LAST_UPDATE_LOGIN)
2665: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2666: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2667: '6330', -- facct account number
2668: '6330', -- ussgl account number
2669: 'E', -- balance type
2718: CREATED_BY,
2719: LAST_UPDATE_DATE,
2720: LAST_UPDATED_BY,
2721: LAST_UPDATE_LOGIN)
2722: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2723: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2724: '6400', -- facct account number
2725: '6400', -- ussgl account number
2726: 'E', -- balance type
2775: CREATED_BY,
2776: LAST_UPDATE_DATE,
2777: LAST_UPDATED_BY,
2778: LAST_UPDATE_LOGIN)
2779: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2780: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2781: '6500', -- facct account number
2782: '6500', -- ussgl account number
2783: 'E', -- balance type
2832: CREATED_BY,
2833: LAST_UPDATE_DATE,
2834: LAST_UPDATED_BY,
2835: LAST_UPDATE_LOGIN)
2836: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2837: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2838: '6600', -- facct account number
2839: '6600', -- ussgl account number
2840: 'E', -- balance type
2890: CREATED_BY,
2891: LAST_UPDATE_DATE,
2892: LAST_UPDATED_BY,
2893: LAST_UPDATE_LOGIN)
2894: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2895: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2896: '6710', -- facct account number
2897: '6710', -- ussgl account number
2898: 'E', -- balance type
2947: CREATED_BY,
2948: LAST_UPDATE_DATE,
2949: LAST_UPDATED_BY,
2950: LAST_UPDATE_LOGIN)
2951: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2952: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2953: '6720', -- facct account number
2954: '6720', -- ussgl account number
2955: 'E', -- balance type
3004: CREATED_BY,
3005: LAST_UPDATE_DATE,
3006: LAST_UPDATED_BY,
3007: LAST_UPDATE_LOGIN)
3008: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3009: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3010: '6730', -- facct account number
3011: '6730', -- ussgl account number
3012: 'E', -- balance type
3061: CREATED_BY,
3062: LAST_UPDATE_DATE,
3063: LAST_UPDATED_BY,
3064: LAST_UPDATE_LOGIN)
3065: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3066: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3067: '6790', -- facct account number
3068: '6790', -- ussgl account number
3069: 'E', -- balance type
3118: CREATED_BY,
3119: LAST_UPDATE_DATE,
3120: LAST_UPDATED_BY,
3121: LAST_UPDATE_LOGIN)
3122: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3123: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3124: '6800', -- facct account number
3125: '6800', -- ussgl account number
3126: 'E', -- balance type
3175: CREATED_BY,
3176: LAST_UPDATE_DATE,
3177: LAST_UPDATED_BY,
3178: LAST_UPDATE_LOGIN)
3179: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3180: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3181: '6850', -- facct account number
3182: '6850', -- ussgl account number
3183: 'E', -- balance type
3232: CREATED_BY,
3233: LAST_UPDATE_DATE,
3234: LAST_UPDATED_BY,
3235: LAST_UPDATE_LOGIN)
3236: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3237: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3238: '6900', -- facct account number
3239: '6900', -- ussgl account number
3240: 'E', -- balance type
3289: CREATED_BY,
3290: LAST_UPDATE_DATE,
3291: LAST_UPDATED_BY,
3292: LAST_UPDATE_LOGIN)
3293: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3294: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3295: '7110', -- facct account number
3296: '7110', -- ussgl account number
3297: 'E', -- balance type
3346: CREATED_BY,
3347: LAST_UPDATE_DATE,
3348: LAST_UPDATED_BY,
3349: LAST_UPDATE_LOGIN)
3350: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3351: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3352: '7180', -- facct account number
3353: '7180', -- ussgl account number
3354: 'E', -- balance type
3403: CREATED_BY,
3404: LAST_UPDATE_DATE,
3405: LAST_UPDATED_BY,
3406: LAST_UPDATE_LOGIN)
3407: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3408: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3409: '7190', -- facct account number
3410: '7190', -- ussgl account number
3411: 'E', -- balance type
3460: CREATED_BY,
3461: LAST_UPDATE_DATE,
3462: LAST_UPDATED_BY,
3463: LAST_UPDATE_LOGIN)
3464: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3465: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3466: '7210', -- facct account number
3467: '7210', -- ussgl account number
3468: 'E', -- balance type
3517: CREATED_BY,
3518: LAST_UPDATE_DATE,
3519: LAST_UPDATED_BY,
3520: LAST_UPDATE_LOGIN)
3521: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3522: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3523: '7280', -- facct account number
3524: '7280', -- ussgl account number
3525: 'E', -- balance type
3574: CREATED_BY,
3575: LAST_UPDATE_DATE,
3576: LAST_UPDATED_BY,
3577: LAST_UPDATE_LOGIN)
3578: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3579: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3580: '7290', -- facct account number
3581: '7290', -- ussgl account number
3582: 'E', -- balance type
3631: CREATED_BY,
3632: LAST_UPDATE_DATE,
3633: LAST_UPDATED_BY,
3634: LAST_UPDATE_LOGIN)
3635: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3636: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3637: '7300', -- facct account number
3638: '7300', -- ussgl account number
3639: 'E', -- balance type
3688: CREATED_BY,
3689: LAST_UPDATE_DATE,
3690: LAST_UPDATED_BY,
3691: LAST_UPDATE_LOGIN)
3692: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3693: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3694: '7400', -- facct account number
3695: '7400', -- ussgl account number
3696: 'E', -- balance type
3745: CREATED_BY,
3746: LAST_UPDATE_DATE,
3747: LAST_UPDATED_BY,
3748: LAST_UPDATE_LOGIN)
3749: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3750: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3751: '7500', -- facct account number
3752: '7500', -- ussgl account number
3753: 'E', -- balance type
3802: CREATED_BY,
3803: LAST_UPDATE_DATE,
3804: LAST_UPDATED_BY,
3805: LAST_UPDATE_LOGIN)
3806: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3807: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3808: '7600', -- facct account number
3809: '7600', -- ussgl account number
3810: 'E', -- balance type