DBA Data[Home] [Help]

APPS.FVFCATT2 dependencies on FND_PROFILE

Line 12: v_sob := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');

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,

Line 13: v_sob_name := FND_PROFILE.VALUE('GL_SET_OF_BKS_NAME');

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,

Line 43: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 100: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 157: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 214: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 271: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 328: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 385: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 442: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 499: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 556: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 613: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 670: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 727: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 784: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 841: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 898: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 955: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 1012: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 1069: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 1126: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 1183: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 1240: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 1297: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 1354: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 1411: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 1468: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 1525: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 1582: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 1639: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 1696: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 1753: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 1810: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 1867: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 1924: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 1981: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 2038: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 2095: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 2152: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 2209: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 2266: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 2323: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 2380: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 2437: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 2494: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 2551: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 2608: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 2665: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 2722: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 2779: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 2836: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 2894: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 2951: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 3008: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 3065: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 3122: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 3179: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 3236: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 3293: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 3350: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 3407: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 3464: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 3521: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 3578: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 3635: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 3692: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 3749: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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

Line 3806: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

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