DBA Data[Home] [Help]

APPS.FVFCSGL2 dependencies on FV_FACTS_USSGL_ACCOUNTS

Line 15: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

11: v_sob := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
12: v_sob_name := FND_PROFILE.VALUE('GL_SET_OF_BKS_NAME');
13: */
14:
15: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
16: DESCRIPTION,
17: NATURAL_BALANCE,
18: REPORTING_TYPE,
19: TOTAL_RESOURCE_BE_FLAG,

Line 62: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

58: sysdate, -- last update date
59: FND_GLOBAL.USER_ID, -- last updated by
60: FND_GLOBAL.USER_ID -- last updated login
61: );
62: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
63: DESCRIPTION,
64: NATURAL_BALANCE,
65: REPORTING_TYPE,
66: TOTAL_RESOURCE_BE_FLAG,

Line 110: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

106: sysdate, -- last update date
107: FND_GLOBAL.USER_ID, -- last updated by
108: FND_GLOBAL.USER_ID -- last updated login
109: );
110: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
111: DESCRIPTION,
112: NATURAL_BALANCE,
113: REPORTING_TYPE,
114: TOTAL_RESOURCE_BE_FLAG,

Line 158: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

154: sysdate, -- last update date
155: FND_GLOBAL.USER_ID, -- last updated by
156: FND_GLOBAL.USER_ID -- last updated login
157: );
158: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
159: DESCRIPTION,
160: NATURAL_BALANCE,
161: REPORTING_TYPE,
162: TOTAL_RESOURCE_BE_FLAG,

Line 206: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

202: sysdate, -- last update date
203: FND_GLOBAL.USER_ID, -- last updated by
204: FND_GLOBAL.USER_ID -- last updated login
205: );
206: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
207: DESCRIPTION,
208: NATURAL_BALANCE,
209: REPORTING_TYPE,
210: TOTAL_RESOURCE_BE_FLAG,

Line 254: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

250: sysdate, -- last update date
251: FND_GLOBAL.USER_ID, -- last updated by
252: FND_GLOBAL.USER_ID -- last updated login
253: );
254: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
255: DESCRIPTION,
256: NATURAL_BALANCE,
257: REPORTING_TYPE,
258: TOTAL_RESOURCE_BE_FLAG,

Line 302: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

298: sysdate, -- last update date
299: FND_GLOBAL.USER_ID, -- last updated by
300: FND_GLOBAL.USER_ID -- last updated login
301: );
302: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
303: DESCRIPTION,
304: NATURAL_BALANCE,
305: REPORTING_TYPE,
306: TOTAL_RESOURCE_BE_FLAG,

Line 350: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

346: sysdate, -- last update date
347: FND_GLOBAL.USER_ID, -- last updated by
348: FND_GLOBAL.USER_ID -- last updated login
349: );
350: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
351: DESCRIPTION,
352: NATURAL_BALANCE,
353: REPORTING_TYPE,
354: TOTAL_RESOURCE_BE_FLAG,

Line 398: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

394: sysdate, -- last update date
395: FND_GLOBAL.USER_ID, -- last updated by
396: FND_GLOBAL.USER_ID -- last updated login
397: );
398: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
399: DESCRIPTION,
400: NATURAL_BALANCE,
401: REPORTING_TYPE,
402: TOTAL_RESOURCE_BE_FLAG,

Line 446: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

442: sysdate, -- last update date
443: FND_GLOBAL.USER_ID, -- last updated by
444: FND_GLOBAL.USER_ID -- last updated login
445: );
446: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
447: DESCRIPTION,
448: NATURAL_BALANCE,
449: REPORTING_TYPE,
450: TOTAL_RESOURCE_BE_FLAG,

Line 494: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

490: sysdate, -- last update date
491: FND_GLOBAL.USER_ID, -- last updated by
492: FND_GLOBAL.USER_ID -- last updated login
493: );
494: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
495: DESCRIPTION,
496: NATURAL_BALANCE,
497: REPORTING_TYPE,
498: TOTAL_RESOURCE_BE_FLAG,

Line 542: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

538: sysdate, -- last update date
539: FND_GLOBAL.USER_ID, -- last updated by
540: FND_GLOBAL.USER_ID -- last updated login
541: );
542: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
543: DESCRIPTION,
544: NATURAL_BALANCE,
545: REPORTING_TYPE,
546: TOTAL_RESOURCE_BE_FLAG,

Line 590: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

586: sysdate, -- last update date
587: FND_GLOBAL.USER_ID, -- last updated by
588: FND_GLOBAL.USER_ID -- last updated login
589: );
590: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
591: DESCRIPTION,
592: NATURAL_BALANCE,
593: REPORTING_TYPE,
594: TOTAL_RESOURCE_BE_FLAG,

Line 638: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

634: sysdate, -- last update date
635: FND_GLOBAL.USER_ID, -- last updated by
636: FND_GLOBAL.USER_ID -- last updated login
637: );
638: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
639: DESCRIPTION,
640: NATURAL_BALANCE,
641: REPORTING_TYPE,
642: TOTAL_RESOURCE_BE_FLAG,

Line 686: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

682: sysdate, -- last update date
683: FND_GLOBAL.USER_ID, -- last updated by
684: FND_GLOBAL.USER_ID -- last updated login
685: );
686: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
687: DESCRIPTION,
688: NATURAL_BALANCE,
689: REPORTING_TYPE,
690: TOTAL_RESOURCE_BE_FLAG,

Line 734: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

730: sysdate, -- last update date
731: FND_GLOBAL.USER_ID, -- last updated by
732: FND_GLOBAL.USER_ID -- last updated login
733: );
734: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
735: DESCRIPTION,
736: NATURAL_BALANCE,
737: REPORTING_TYPE,
738: TOTAL_RESOURCE_BE_FLAG,

Line 782: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

778: sysdate, -- last update date
779: FND_GLOBAL.USER_ID, -- last updated by
780: FND_GLOBAL.USER_ID -- last updated login
781: );
782: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
783: DESCRIPTION,
784: NATURAL_BALANCE,
785: REPORTING_TYPE,
786: TOTAL_RESOURCE_BE_FLAG,

Line 830: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

826: sysdate, -- last update date
827: FND_GLOBAL.USER_ID, -- last updated by
828: FND_GLOBAL.USER_ID -- last updated login
829: );
830: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
831: DESCRIPTION,
832: NATURAL_BALANCE,
833: REPORTING_TYPE,
834: TOTAL_RESOURCE_BE_FLAG,

Line 878: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

874: sysdate, -- last update date
875: FND_GLOBAL.USER_ID, -- last updated by
876: FND_GLOBAL.USER_ID -- last updated login
877: );
878: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
879: DESCRIPTION,
880: NATURAL_BALANCE,
881: REPORTING_TYPE,
882: TOTAL_RESOURCE_BE_FLAG,

Line 926: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

922: sysdate, -- last update date
923: FND_GLOBAL.USER_ID, -- last updated by
924: FND_GLOBAL.USER_ID -- last updated login
925: );
926: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
927: DESCRIPTION,
928: NATURAL_BALANCE,
929: REPORTING_TYPE,
930: TOTAL_RESOURCE_BE_FLAG,

Line 974: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

970: sysdate, -- last update date
971: FND_GLOBAL.USER_ID, -- last updated by
972: FND_GLOBAL.USER_ID -- last updated login
973: );
974: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
975: DESCRIPTION,
976: NATURAL_BALANCE,
977: REPORTING_TYPE,
978: TOTAL_RESOURCE_BE_FLAG,

Line 1022: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1018: sysdate, -- last update date
1019: FND_GLOBAL.USER_ID, -- last updated by
1020: FND_GLOBAL.USER_ID -- last updated login
1021: );
1022: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1023: DESCRIPTION,
1024: NATURAL_BALANCE,
1025: REPORTING_TYPE,
1026: TOTAL_RESOURCE_BE_FLAG,

Line 1070: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1066: sysdate, -- last update date
1067: FND_GLOBAL.USER_ID, -- last updated by
1068: FND_GLOBAL.USER_ID -- last updated login
1069: );
1070: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1071: DESCRIPTION,
1072: NATURAL_BALANCE,
1073: REPORTING_TYPE,
1074: TOTAL_RESOURCE_BE_FLAG,

Line 1118: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1114: sysdate, -- last update date
1115: FND_GLOBAL.USER_ID, -- last updated by
1116: FND_GLOBAL.USER_ID -- last updated login
1117: );
1118: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1119: DESCRIPTION,
1120: NATURAL_BALANCE,
1121: REPORTING_TYPE,
1122: TOTAL_RESOURCE_BE_FLAG,

Line 1166: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1162: sysdate, -- last update date
1163: FND_GLOBAL.USER_ID, -- last updated by
1164: FND_GLOBAL.USER_ID -- last updated login
1165: );
1166: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1167: DESCRIPTION,
1168: NATURAL_BALANCE,
1169: REPORTING_TYPE,
1170: TOTAL_RESOURCE_BE_FLAG,

Line 1214: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1210: sysdate, -- last update date
1211: FND_GLOBAL.USER_ID, -- last updated by
1212: FND_GLOBAL.USER_ID -- last updated login
1213: );
1214: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1215: DESCRIPTION,
1216: NATURAL_BALANCE,
1217: REPORTING_TYPE,
1218: TOTAL_RESOURCE_BE_FLAG,

Line 1262: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1258: sysdate, -- last update date
1259: FND_GLOBAL.USER_ID, -- last updated by
1260: FND_GLOBAL.USER_ID -- last updated login
1261: );
1262: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1263: DESCRIPTION,
1264: NATURAL_BALANCE,
1265: REPORTING_TYPE,
1266: TOTAL_RESOURCE_BE_FLAG,

Line 1310: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1306: sysdate, -- last update date
1307: FND_GLOBAL.USER_ID, -- last updated by
1308: FND_GLOBAL.USER_ID -- last updated login
1309: );
1310: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1311: DESCRIPTION,
1312: NATURAL_BALANCE,
1313: REPORTING_TYPE,
1314: TOTAL_RESOURCE_BE_FLAG,

Line 1358: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1354: sysdate, -- last update date
1355: FND_GLOBAL.USER_ID, -- last updated by
1356: FND_GLOBAL.USER_ID -- last updated login
1357: );
1358: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1359: DESCRIPTION,
1360: NATURAL_BALANCE,
1361: REPORTING_TYPE,
1362: TOTAL_RESOURCE_BE_FLAG,

Line 1406: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1402: sysdate, -- last update date
1403: FND_GLOBAL.USER_ID, -- last updated by
1404: FND_GLOBAL.USER_ID -- last updated login
1405: );
1406: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1407: DESCRIPTION,
1408: NATURAL_BALANCE,
1409: REPORTING_TYPE,
1410: TOTAL_RESOURCE_BE_FLAG,

Line 1454: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1450: sysdate, -- last update date
1451: FND_GLOBAL.USER_ID, -- last updated by
1452: FND_GLOBAL.USER_ID -- last updated login
1453: );
1454: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1455: DESCRIPTION,
1456: NATURAL_BALANCE,
1457: REPORTING_TYPE,
1458: TOTAL_RESOURCE_BE_FLAG,

Line 1502: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1498: sysdate, -- last update date
1499: FND_GLOBAL.USER_ID, -- last updated by
1500: FND_GLOBAL.USER_ID -- last updated login
1501: );
1502: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1503: DESCRIPTION,
1504: NATURAL_BALANCE,
1505: REPORTING_TYPE,
1506: TOTAL_RESOURCE_BE_FLAG,

Line 1550: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1546: sysdate, -- last update date
1547: FND_GLOBAL.USER_ID, -- last updated by
1548: FND_GLOBAL.USER_ID -- last updated login
1549: );
1550: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1551: DESCRIPTION,
1552: NATURAL_BALANCE,
1553: REPORTING_TYPE,
1554: TOTAL_RESOURCE_BE_FLAG,

Line 1598: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1594: sysdate, -- last update date
1595: FND_GLOBAL.USER_ID, -- last updated by
1596: FND_GLOBAL.USER_ID -- last updated login
1597: );
1598: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1599: DESCRIPTION,
1600: NATURAL_BALANCE,
1601: REPORTING_TYPE,
1602: TOTAL_RESOURCE_BE_FLAG,

Line 1646: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1642: sysdate, -- last update date
1643: FND_GLOBAL.USER_ID, -- last updated by
1644: FND_GLOBAL.USER_ID -- last updated login
1645: );
1646: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1647: DESCRIPTION,
1648: NATURAL_BALANCE,
1649: REPORTING_TYPE,
1650: TOTAL_RESOURCE_BE_FLAG,

Line 1694: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1690: sysdate, -- last update date
1691: FND_GLOBAL.USER_ID, -- last updated by
1692: FND_GLOBAL.USER_ID -- last updated login
1693: );
1694: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1695: DESCRIPTION,
1696: NATURAL_BALANCE,
1697: REPORTING_TYPE,
1698: TOTAL_RESOURCE_BE_FLAG,

Line 1742: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1738: sysdate, -- last update date
1739: FND_GLOBAL.USER_ID, -- last updated by
1740: FND_GLOBAL.USER_ID -- last updated login
1741: );
1742: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1743: DESCRIPTION,
1744: NATURAL_BALANCE,
1745: REPORTING_TYPE,
1746: TOTAL_RESOURCE_BE_FLAG,

Line 1790: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1786: sysdate, -- last update date
1787: FND_GLOBAL.USER_ID, -- last updated by
1788: FND_GLOBAL.USER_ID -- last updated login
1789: );
1790: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1791: DESCRIPTION,
1792: NATURAL_BALANCE,
1793: REPORTING_TYPE,
1794: TOTAL_RESOURCE_BE_FLAG,

Line 1838: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1834: sysdate, -- last update date
1835: FND_GLOBAL.USER_ID, -- last updated by
1836: FND_GLOBAL.USER_ID -- last updated login
1837: );
1838: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1839: DESCRIPTION,
1840: NATURAL_BALANCE,
1841: REPORTING_TYPE,
1842: TOTAL_RESOURCE_BE_FLAG,

Line 1886: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1882: sysdate, -- last update date
1883: FND_GLOBAL.USER_ID, -- last updated by
1884: FND_GLOBAL.USER_ID -- last updated login
1885: );
1886: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1887: DESCRIPTION,
1888: NATURAL_BALANCE,
1889: REPORTING_TYPE,
1890: TOTAL_RESOURCE_BE_FLAG,

Line 1934: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1930: sysdate, -- last update date
1931: FND_GLOBAL.USER_ID, -- last updated by
1932: FND_GLOBAL.USER_ID -- last updated login
1933: );
1934: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1935: DESCRIPTION,
1936: NATURAL_BALANCE,
1937: REPORTING_TYPE,
1938: TOTAL_RESOURCE_BE_FLAG,

Line 1982: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1978: sysdate, -- last update date
1979: FND_GLOBAL.USER_ID, -- last updated by
1980: FND_GLOBAL.USER_ID -- last updated login
1981: );
1982: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1983: DESCRIPTION,
1984: NATURAL_BALANCE,
1985: REPORTING_TYPE,
1986: TOTAL_RESOURCE_BE_FLAG,

Line 2030: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2026: sysdate, -- last update date
2027: FND_GLOBAL.USER_ID, -- last updated by
2028: FND_GLOBAL.USER_ID -- last updated login
2029: );
2030: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2031: DESCRIPTION,
2032: NATURAL_BALANCE,
2033: REPORTING_TYPE,
2034: TOTAL_RESOURCE_BE_FLAG,

Line 2078: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2074: sysdate, -- last update date
2075: FND_GLOBAL.USER_ID, -- last updated by
2076: FND_GLOBAL.USER_ID -- last updated login
2077: );
2078: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2079: DESCRIPTION,
2080: NATURAL_BALANCE,
2081: REPORTING_TYPE,
2082: TOTAL_RESOURCE_BE_FLAG,

Line 2126: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2122: sysdate, -- last update date
2123: FND_GLOBAL.USER_ID, -- last updated by
2124: FND_GLOBAL.USER_ID -- last updated login
2125: );
2126: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2127: DESCRIPTION,
2128: NATURAL_BALANCE,
2129: REPORTING_TYPE,
2130: TOTAL_RESOURCE_BE_FLAG,

Line 2174: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2170: sysdate, -- last update date
2171: FND_GLOBAL.USER_ID, -- last updated by
2172: FND_GLOBAL.USER_ID -- last updated login
2173: );
2174: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2175: DESCRIPTION,
2176: NATURAL_BALANCE,
2177: REPORTING_TYPE,
2178: TOTAL_RESOURCE_BE_FLAG,

Line 2222: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2218: sysdate, -- last update date
2219: FND_GLOBAL.USER_ID, -- last updated by
2220: FND_GLOBAL.USER_ID -- last updated login
2221: );
2222: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2223: DESCRIPTION,
2224: NATURAL_BALANCE,
2225: REPORTING_TYPE,
2226: TOTAL_RESOURCE_BE_FLAG,

Line 2270: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2266: sysdate, -- last update date
2267: FND_GLOBAL.USER_ID, -- last updated by
2268: FND_GLOBAL.USER_ID -- last updated login
2269: );
2270: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2271: DESCRIPTION,
2272: NATURAL_BALANCE,
2273: REPORTING_TYPE,
2274: TOTAL_RESOURCE_BE_FLAG,

Line 2317: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2313: sysdate, -- last update date
2314: FND_GLOBAL.USER_ID, -- last updated by
2315: FND_GLOBAL.USER_ID -- last updated login
2316: );
2317: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2318: DESCRIPTION,
2319: NATURAL_BALANCE,
2320: REPORTING_TYPE,
2321: TOTAL_RESOURCE_BE_FLAG,

Line 2364: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2360: sysdate, -- last update date
2361: FND_GLOBAL.USER_ID, -- last updated by
2362: FND_GLOBAL.USER_ID -- last updated login
2363: );
2364: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2365: DESCRIPTION,
2366: NATURAL_BALANCE,
2367: REPORTING_TYPE,
2368: TOTAL_RESOURCE_BE_FLAG,

Line 2411: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2407: sysdate, -- last update date
2408: FND_GLOBAL.USER_ID, -- last updated by
2409: FND_GLOBAL.USER_ID -- last updated login
2410: );
2411: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2412: DESCRIPTION,
2413: NATURAL_BALANCE,
2414: REPORTING_TYPE,
2415: TOTAL_RESOURCE_BE_FLAG,

Line 2458: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2454: sysdate, -- last update date
2455: FND_GLOBAL.USER_ID, -- last updated by
2456: FND_GLOBAL.USER_ID -- last updated login
2457: );
2458: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2459: DESCRIPTION,
2460: NATURAL_BALANCE,
2461: REPORTING_TYPE,
2462: TOTAL_RESOURCE_BE_FLAG,

Line 2505: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2501: sysdate, -- last update date
2502: FND_GLOBAL.USER_ID, -- last updated by
2503: FND_GLOBAL.USER_ID -- last updated login
2504: );
2505: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2506: DESCRIPTION,
2507: NATURAL_BALANCE,
2508: REPORTING_TYPE,
2509: TOTAL_RESOURCE_BE_FLAG,

Line 2552: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2548: sysdate, -- last update date
2549: FND_GLOBAL.USER_ID, -- last updated by
2550: FND_GLOBAL.USER_ID -- last updated login
2551: );
2552: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2553: DESCRIPTION,
2554: NATURAL_BALANCE,
2555: REPORTING_TYPE,
2556: TOTAL_RESOURCE_BE_FLAG,

Line 2599: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2595: sysdate, -- last update date
2596: FND_GLOBAL.USER_ID, -- last updated by
2597: FND_GLOBAL.USER_ID -- last updated login
2598: );
2599: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2600: DESCRIPTION,
2601: NATURAL_BALANCE,
2602: REPORTING_TYPE,
2603: TOTAL_RESOURCE_BE_FLAG,

Line 2646: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2642: sysdate, -- last update date
2643: FND_GLOBAL.USER_ID, -- last updated by
2644: FND_GLOBAL.USER_ID -- last updated login
2645: );
2646: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2647: DESCRIPTION,
2648: NATURAL_BALANCE,
2649: REPORTING_TYPE,
2650: TOTAL_RESOURCE_BE_FLAG,

Line 2693: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2689: sysdate, -- last update date
2690: FND_GLOBAL.USER_ID, -- last updated by
2691: FND_GLOBAL.USER_ID -- last updated login
2692: );
2693: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2694: DESCRIPTION,
2695: NATURAL_BALANCE,
2696: REPORTING_TYPE,
2697: TOTAL_RESOURCE_BE_FLAG,

Line 2740: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2736: sysdate, -- last update date
2737: FND_GLOBAL.USER_ID, -- last updated by
2738: FND_GLOBAL.USER_ID -- last updated login
2739: );
2740: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2741: DESCRIPTION,
2742: NATURAL_BALANCE,
2743: REPORTING_TYPE,
2744: TOTAL_RESOURCE_BE_FLAG,

Line 2787: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2783: sysdate, -- last update date
2784: FND_GLOBAL.USER_ID, -- last updated by
2785: FND_GLOBAL.USER_ID -- last updated login
2786: );
2787: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2788: DESCRIPTION,
2789: NATURAL_BALANCE,
2790: REPORTING_TYPE,
2791: TOTAL_RESOURCE_BE_FLAG,

Line 2834: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2830: sysdate, -- last update date
2831: FND_GLOBAL.USER_ID, -- last updated by
2832: FND_GLOBAL.USER_ID -- last updated login
2833: );
2834: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2835: DESCRIPTION,
2836: NATURAL_BALANCE,
2837: REPORTING_TYPE,
2838: TOTAL_RESOURCE_BE_FLAG,

Line 2881: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2877: sysdate, -- last update date
2878: FND_GLOBAL.USER_ID, -- last updated by
2879: FND_GLOBAL.USER_ID -- last updated login
2880: );
2881: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2882: DESCRIPTION,
2883: NATURAL_BALANCE,
2884: REPORTING_TYPE,
2885: TOTAL_RESOURCE_BE_FLAG,

Line 2928: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2924: sysdate, -- last update date
2925: FND_GLOBAL.USER_ID, -- last updated by
2926: FND_GLOBAL.USER_ID -- last updated login
2927: );
2928: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2929: DESCRIPTION,
2930: NATURAL_BALANCE,
2931: REPORTING_TYPE,
2932: TOTAL_RESOURCE_BE_FLAG,

Line 2975: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2971: sysdate, -- last update date
2972: FND_GLOBAL.USER_ID, -- last updated by
2973: FND_GLOBAL.USER_ID -- last updated login
2974: );
2975: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2976: DESCRIPTION,
2977: NATURAL_BALANCE,
2978: REPORTING_TYPE,
2979: TOTAL_RESOURCE_BE_FLAG,

Line 3022: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3018: sysdate, -- last update date
3019: FND_GLOBAL.USER_ID, -- last updated by
3020: FND_GLOBAL.USER_ID -- last updated login
3021: );
3022: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3023: DESCRIPTION,
3024: NATURAL_BALANCE,
3025: REPORTING_TYPE,
3026: TOTAL_RESOURCE_BE_FLAG,

Line 3069: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3065: sysdate, -- last update date
3066: FND_GLOBAL.USER_ID, -- last updated by
3067: FND_GLOBAL.USER_ID -- last updated login
3068: );
3069: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3070: DESCRIPTION,
3071: NATURAL_BALANCE,
3072: REPORTING_TYPE,
3073: TOTAL_RESOURCE_BE_FLAG,

Line 3116: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3112: sysdate, -- last update date
3113: FND_GLOBAL.USER_ID, -- last updated by
3114: FND_GLOBAL.USER_ID -- last updated login
3115: );
3116: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3117: DESCRIPTION,
3118: NATURAL_BALANCE,
3119: REPORTING_TYPE,
3120: TOTAL_RESOURCE_BE_FLAG,

Line 3163: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3159: sysdate, -- last update date
3160: FND_GLOBAL.USER_ID, -- last updated by
3161: FND_GLOBAL.USER_ID -- last updated login
3162: );
3163: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3164: DESCRIPTION,
3165: NATURAL_BALANCE,
3166: REPORTING_TYPE,
3167: TOTAL_RESOURCE_BE_FLAG,

Line 3210: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3206: sysdate, -- last update date
3207: FND_GLOBAL.USER_ID, -- last updated by
3208: FND_GLOBAL.USER_ID -- last updated login
3209: );
3210: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3211: DESCRIPTION,
3212: NATURAL_BALANCE,
3213: REPORTING_TYPE,
3214: TOTAL_RESOURCE_BE_FLAG,

Line 3257: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3253: sysdate, -- last update date
3254: FND_GLOBAL.USER_ID, -- last updated by
3255: FND_GLOBAL.USER_ID -- last updated login
3256: );
3257: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3258: DESCRIPTION,
3259: NATURAL_BALANCE,
3260: REPORTING_TYPE,
3261: TOTAL_RESOURCE_BE_FLAG,

Line 3304: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3300: sysdate, -- last update date
3301: FND_GLOBAL.USER_ID, -- last updated by
3302: FND_GLOBAL.USER_ID -- last updated login
3303: );
3304: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3305: DESCRIPTION,
3306: NATURAL_BALANCE,
3307: REPORTING_TYPE,
3308: TOTAL_RESOURCE_BE_FLAG,

Line 3351: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3347: sysdate, -- last update date
3348: FND_GLOBAL.USER_ID, -- last updated by
3349: FND_GLOBAL.USER_ID -- last updated login
3350: );
3351: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3352: DESCRIPTION,
3353: NATURAL_BALANCE,
3354: REPORTING_TYPE,
3355: TOTAL_RESOURCE_BE_FLAG,

Line 3398: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3394: sysdate, -- last update date
3395: FND_GLOBAL.USER_ID, -- last updated by
3396: FND_GLOBAL.USER_ID -- last updated login
3397: );
3398: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3399: DESCRIPTION,
3400: NATURAL_BALANCE,
3401: REPORTING_TYPE,
3402: TOTAL_RESOURCE_BE_FLAG,

Line 3445: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3441: sysdate, -- last update date
3442: FND_GLOBAL.USER_ID, -- last updated by
3443: FND_GLOBAL.USER_ID -- last updated login
3444: );
3445: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3446: DESCRIPTION,
3447: NATURAL_BALANCE,
3448: REPORTING_TYPE,
3449: TOTAL_RESOURCE_BE_FLAG,

Line 3492: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3488: sysdate, -- last update date
3489: FND_GLOBAL.USER_ID, -- last updated by
3490: FND_GLOBAL.USER_ID -- last updated login
3491: );
3492: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3493: DESCRIPTION,
3494: NATURAL_BALANCE,
3495: REPORTING_TYPE,
3496: TOTAL_RESOURCE_BE_FLAG,

Line 3539: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3535: sysdate, -- last update date
3536: FND_GLOBAL.USER_ID, -- last updated by
3537: FND_GLOBAL.USER_ID -- last updated login
3538: );
3539: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3540: DESCRIPTION,
3541: NATURAL_BALANCE,
3542: REPORTING_TYPE,
3543: TOTAL_RESOURCE_BE_FLAG,

Line 3586: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3582: sysdate, -- last update date
3583: FND_GLOBAL.USER_ID, -- last updated by
3584: FND_GLOBAL.USER_ID -- last updated login
3585: );
3586: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3587: DESCRIPTION,
3588: NATURAL_BALANCE,
3589: REPORTING_TYPE,
3590: TOTAL_RESOURCE_BE_FLAG,

Line 3633: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3629: sysdate, -- last update date
3630: FND_GLOBAL.USER_ID, -- last updated by
3631: FND_GLOBAL.USER_ID -- last updated login
3632: );
3633: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3634: DESCRIPTION,
3635: NATURAL_BALANCE,
3636: REPORTING_TYPE,
3637: TOTAL_RESOURCE_BE_FLAG,

Line 3680: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3676: sysdate, -- last update date
3677: FND_GLOBAL.USER_ID, -- last updated by
3678: FND_GLOBAL.USER_ID -- last updated login
3679: );
3680: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3681: DESCRIPTION,
3682: NATURAL_BALANCE,
3683: REPORTING_TYPE,
3684: TOTAL_RESOURCE_BE_FLAG,

Line 3727: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3723: sysdate, -- last update date
3724: FND_GLOBAL.USER_ID, -- last updated by
3725: FND_GLOBAL.USER_ID -- last updated login
3726: );
3727: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3728: DESCRIPTION,
3729: NATURAL_BALANCE,
3730: REPORTING_TYPE,
3731: TOTAL_RESOURCE_BE_FLAG,

Line 3774: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3770: sysdate, -- last update date
3771: FND_GLOBAL.USER_ID, -- last updated by
3772: FND_GLOBAL.USER_ID -- last updated login
3773: );
3774: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3775: DESCRIPTION,
3776: NATURAL_BALANCE,
3777: REPORTING_TYPE,
3778: TOTAL_RESOURCE_BE_FLAG,

Line 3821: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3817: sysdate, -- last update date
3818: FND_GLOBAL.USER_ID, -- last updated by
3819: FND_GLOBAL.USER_ID -- last updated login
3820: );
3821: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3822: DESCRIPTION,
3823: NATURAL_BALANCE,
3824: REPORTING_TYPE,
3825: TOTAL_RESOURCE_BE_FLAG,

Line 3868: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3864: sysdate, -- last update date
3865: FND_GLOBAL.USER_ID, -- last updated by
3866: FND_GLOBAL.USER_ID -- last updated login
3867: );
3868: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3869: DESCRIPTION,
3870: NATURAL_BALANCE,
3871: REPORTING_TYPE,
3872: TOTAL_RESOURCE_BE_FLAG,

Line 3915: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3911: sysdate, -- last update date
3912: FND_GLOBAL.USER_ID, -- last updated by
3913: FND_GLOBAL.USER_ID -- last updated login
3914: );
3915: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3916: DESCRIPTION,
3917: NATURAL_BALANCE,
3918: REPORTING_TYPE,
3919: TOTAL_RESOURCE_BE_FLAG,

Line 3962: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3958: sysdate, -- last update date
3959: FND_GLOBAL.USER_ID, -- last updated by
3960: FND_GLOBAL.USER_ID -- last updated login
3961: );
3962: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3963: DESCRIPTION,
3964: NATURAL_BALANCE,
3965: REPORTING_TYPE,
3966: TOTAL_RESOURCE_BE_FLAG,

Line 4009: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4005: sysdate, -- last update date
4006: FND_GLOBAL.USER_ID, -- last updated by
4007: FND_GLOBAL.USER_ID -- last updated login
4008: );
4009: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4010: DESCRIPTION,
4011: NATURAL_BALANCE,
4012: REPORTING_TYPE,
4013: TOTAL_RESOURCE_BE_FLAG,

Line 4056: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4052: sysdate, -- last update date
4053: FND_GLOBAL.USER_ID, -- last updated by
4054: FND_GLOBAL.USER_ID -- last updated login
4055: );
4056: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4057: DESCRIPTION,
4058: NATURAL_BALANCE,
4059: REPORTING_TYPE,
4060: TOTAL_RESOURCE_BE_FLAG,

Line 4103: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4099: sysdate, -- last update date
4100: FND_GLOBAL.USER_ID, -- last updated by
4101: FND_GLOBAL.USER_ID -- last updated login
4102: );
4103: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4104: DESCRIPTION,
4105: NATURAL_BALANCE,
4106: REPORTING_TYPE,
4107: TOTAL_RESOURCE_BE_FLAG,

Line 4150: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4146: sysdate, -- last update date
4147: FND_GLOBAL.USER_ID, -- last updated by
4148: FND_GLOBAL.USER_ID -- last updated login
4149: );
4150: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4151: DESCRIPTION,
4152: NATURAL_BALANCE,
4153: REPORTING_TYPE,
4154: TOTAL_RESOURCE_BE_FLAG,

Line 4197: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4193: sysdate, -- last update date
4194: FND_GLOBAL.USER_ID, -- last updated by
4195: FND_GLOBAL.USER_ID -- last updated login
4196: );
4197: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4198: DESCRIPTION,
4199: NATURAL_BALANCE,
4200: REPORTING_TYPE,
4201: TOTAL_RESOURCE_BE_FLAG,

Line 4244: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4240: sysdate, -- last update date
4241: FND_GLOBAL.USER_ID, -- last updated by
4242: FND_GLOBAL.USER_ID -- last updated login
4243: );
4244: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4245: DESCRIPTION,
4246: NATURAL_BALANCE,
4247: REPORTING_TYPE,
4248: TOTAL_RESOURCE_BE_FLAG,

Line 4291: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4287: sysdate, -- last update date
4288: FND_GLOBAL.USER_ID, -- last updated by
4289: FND_GLOBAL.USER_ID -- last updated login
4290: );
4291: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4292: DESCRIPTION,
4293: NATURAL_BALANCE,
4294: REPORTING_TYPE,
4295: TOTAL_RESOURCE_BE_FLAG,

Line 4338: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4334: sysdate, -- last update date
4335: FND_GLOBAL.USER_ID, -- last updated by
4336: FND_GLOBAL.USER_ID -- last updated login
4337: );
4338: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4339: DESCRIPTION,
4340: NATURAL_BALANCE,
4341: REPORTING_TYPE,
4342: TOTAL_RESOURCE_BE_FLAG,

Line 4385: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4381: sysdate, -- last update date
4382: FND_GLOBAL.USER_ID, -- last updated by
4383: FND_GLOBAL.USER_ID -- last updated login
4384: );
4385: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4386: DESCRIPTION,
4387: NATURAL_BALANCE,
4388: REPORTING_TYPE,
4389: TOTAL_RESOURCE_BE_FLAG,

Line 4432: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4428: sysdate, -- last update date
4429: FND_GLOBAL.USER_ID, -- last updated by
4430: FND_GLOBAL.USER_ID -- last updated login
4431: );
4432: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4433: DESCRIPTION,
4434: NATURAL_BALANCE,
4435: REPORTING_TYPE,
4436: TOTAL_RESOURCE_BE_FLAG,

Line 4479: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4475: sysdate, -- last update date
4476: FND_GLOBAL.USER_ID, -- last updated by
4477: FND_GLOBAL.USER_ID -- last updated login
4478: );
4479: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4480: DESCRIPTION,
4481: NATURAL_BALANCE,
4482: REPORTING_TYPE,
4483: TOTAL_RESOURCE_BE_FLAG,

Line 4526: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4522: sysdate, -- last update date
4523: FND_GLOBAL.USER_ID, -- last updated by
4524: FND_GLOBAL.USER_ID -- last updated login
4525: );
4526: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4527: DESCRIPTION,
4528: NATURAL_BALANCE,
4529: REPORTING_TYPE,
4530: TOTAL_RESOURCE_BE_FLAG,

Line 4573: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4569: sysdate, -- last update date
4570: FND_GLOBAL.USER_ID, -- last updated by
4571: FND_GLOBAL.USER_ID -- last updated login
4572: );
4573: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4574: DESCRIPTION,
4575: NATURAL_BALANCE,
4576: REPORTING_TYPE,
4577: TOTAL_RESOURCE_BE_FLAG,

Line 4620: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4616: sysdate, -- last update date
4617: FND_GLOBAL.USER_ID, -- last updated by
4618: FND_GLOBAL.USER_ID -- last updated login
4619: );
4620: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4621: DESCRIPTION,
4622: NATURAL_BALANCE,
4623: REPORTING_TYPE,
4624: TOTAL_RESOURCE_BE_FLAG,

Line 4667: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4663: sysdate, -- last update date
4664: FND_GLOBAL.USER_ID, -- last updated by
4665: FND_GLOBAL.USER_ID -- last updated login
4666: );
4667: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4668: DESCRIPTION,
4669: NATURAL_BALANCE,
4670: REPORTING_TYPE,
4671: TOTAL_RESOURCE_BE_FLAG,

Line 4714: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4710: sysdate, -- last update date
4711: FND_GLOBAL.USER_ID, -- last updated by
4712: FND_GLOBAL.USER_ID -- last updated login
4713: );
4714: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4715: DESCRIPTION,
4716: NATURAL_BALANCE,
4717: REPORTING_TYPE,
4718: TOTAL_RESOURCE_BE_FLAG,

Line 4761: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4757: sysdate, -- last update date
4758: FND_GLOBAL.USER_ID, -- last updated by
4759: FND_GLOBAL.USER_ID -- last updated login
4760: );
4761: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4762: DESCRIPTION,
4763: NATURAL_BALANCE,
4764: REPORTING_TYPE,
4765: TOTAL_RESOURCE_BE_FLAG,

Line 4808: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4804: sysdate, -- last update date
4805: FND_GLOBAL.USER_ID, -- last updated by
4806: FND_GLOBAL.USER_ID -- last updated login
4807: );
4808: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4809: DESCRIPTION,
4810: NATURAL_BALANCE,
4811: REPORTING_TYPE,
4812: TOTAL_RESOURCE_BE_FLAG,

Line 4855: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4851: sysdate, -- last update date
4852: FND_GLOBAL.USER_ID, -- last updated by
4853: FND_GLOBAL.USER_ID -- last updated login
4854: );
4855: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4856: DESCRIPTION,
4857: NATURAL_BALANCE,
4858: REPORTING_TYPE,
4859: TOTAL_RESOURCE_BE_FLAG,

Line 4902: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4898: sysdate, -- last update date
4899: FND_GLOBAL.USER_ID, -- last updated by
4900: FND_GLOBAL.USER_ID -- last updated login
4901: );
4902: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4903: DESCRIPTION,
4904: NATURAL_BALANCE,
4905: REPORTING_TYPE,
4906: TOTAL_RESOURCE_BE_FLAG,

Line 4949: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4945: sysdate, -- last update date
4946: FND_GLOBAL.USER_ID, -- last updated by
4947: FND_GLOBAL.USER_ID -- last updated login
4948: );
4949: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4950: DESCRIPTION,
4951: NATURAL_BALANCE,
4952: REPORTING_TYPE,
4953: TOTAL_RESOURCE_BE_FLAG,

Line 4996: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4992: sysdate, -- last update date
4993: FND_GLOBAL.USER_ID, -- last updated by
4994: FND_GLOBAL.USER_ID -- last updated login
4995: );
4996: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4997: DESCRIPTION,
4998: NATURAL_BALANCE,
4999: REPORTING_TYPE,
5000: TOTAL_RESOURCE_BE_FLAG,

Line 5043: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5039: sysdate, -- last update date
5040: FND_GLOBAL.USER_ID, -- last updated by
5041: FND_GLOBAL.USER_ID -- last updated login
5042: );
5043: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5044: DESCRIPTION,
5045: NATURAL_BALANCE,
5046: REPORTING_TYPE,
5047: TOTAL_RESOURCE_BE_FLAG,

Line 5090: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5086: sysdate, -- last update date
5087: FND_GLOBAL.USER_ID, -- last updated by
5088: FND_GLOBAL.USER_ID -- last updated login
5089: );
5090: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5091: DESCRIPTION,
5092: NATURAL_BALANCE,
5093: REPORTING_TYPE,
5094: TOTAL_RESOURCE_BE_FLAG,

Line 5137: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5133: sysdate, -- last update date
5134: FND_GLOBAL.USER_ID, -- last updated by
5135: FND_GLOBAL.USER_ID -- last updated login
5136: );
5137: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5138: DESCRIPTION,
5139: NATURAL_BALANCE,
5140: REPORTING_TYPE,
5141: TOTAL_RESOURCE_BE_FLAG,

Line 5184: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5180: sysdate, -- last update date
5181: FND_GLOBAL.USER_ID, -- last updated by
5182: FND_GLOBAL.USER_ID -- last updated login
5183: );
5184: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5185: DESCRIPTION,
5186: NATURAL_BALANCE,
5187: REPORTING_TYPE,
5188: TOTAL_RESOURCE_BE_FLAG,

Line 5231: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

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_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5232: DESCRIPTION,
5233: NATURAL_BALANCE,
5234: REPORTING_TYPE,
5235: TOTAL_RESOURCE_BE_FLAG,

Line 5278: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5274: sysdate, -- last update date
5275: FND_GLOBAL.USER_ID, -- last updated by
5276: FND_GLOBAL.USER_ID -- last updated login
5277: );
5278: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5279: DESCRIPTION,
5280: NATURAL_BALANCE,
5281: REPORTING_TYPE,
5282: TOTAL_RESOURCE_BE_FLAG,

Line 5325: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5321: sysdate, -- last update date
5322: FND_GLOBAL.USER_ID, -- last updated by
5323: FND_GLOBAL.USER_ID -- last updated login
5324: );
5325: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5326: DESCRIPTION,
5327: NATURAL_BALANCE,
5328: REPORTING_TYPE,
5329: TOTAL_RESOURCE_BE_FLAG,

Line 5372: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5368: sysdate, -- last update date
5369: FND_GLOBAL.USER_ID, -- last updated by
5370: FND_GLOBAL.USER_ID -- last updated login
5371: );
5372: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5373: DESCRIPTION,
5374: NATURAL_BALANCE,
5375: REPORTING_TYPE,
5376: TOTAL_RESOURCE_BE_FLAG,

Line 5419: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5415: sysdate, -- last update date
5416: FND_GLOBAL.USER_ID, -- last updated by
5417: FND_GLOBAL.USER_ID -- last updated login
5418: );
5419: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5420: DESCRIPTION,
5421: NATURAL_BALANCE,
5422: REPORTING_TYPE,
5423: TOTAL_RESOURCE_BE_FLAG,

Line 5466: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5462: sysdate, -- last update date
5463: FND_GLOBAL.USER_ID, -- last updated by
5464: FND_GLOBAL.USER_ID -- last updated login
5465: );
5466: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5467: DESCRIPTION,
5468: NATURAL_BALANCE,
5469: REPORTING_TYPE,
5470: TOTAL_RESOURCE_BE_FLAG,

Line 5513: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5509: sysdate, -- last update date
5510: FND_GLOBAL.USER_ID, -- last updated by
5511: FND_GLOBAL.USER_ID -- last updated login
5512: );
5513: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5514: DESCRIPTION,
5515: NATURAL_BALANCE,
5516: REPORTING_TYPE,
5517: TOTAL_RESOURCE_BE_FLAG,

Line 5560: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5556: sysdate, -- last update date
5557: FND_GLOBAL.USER_ID, -- last updated by
5558: FND_GLOBAL.USER_ID -- last updated login
5559: );
5560: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5561: DESCRIPTION,
5562: NATURAL_BALANCE,
5563: REPORTING_TYPE,
5564: TOTAL_RESOURCE_BE_FLAG,

Line 5607: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5603: sysdate, -- last update date
5604: FND_GLOBAL.USER_ID, -- last updated by
5605: FND_GLOBAL.USER_ID -- last updated login
5606: );
5607: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5608: DESCRIPTION,
5609: NATURAL_BALANCE,
5610: REPORTING_TYPE,
5611: TOTAL_RESOURCE_BE_FLAG,

Line 5654: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5650: sysdate, -- last update date
5651: FND_GLOBAL.USER_ID, -- last updated by
5652: FND_GLOBAL.USER_ID -- last updated login
5653: );
5654: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5655: DESCRIPTION,
5656: NATURAL_BALANCE,
5657: REPORTING_TYPE,
5658: TOTAL_RESOURCE_BE_FLAG,

Line 5701: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5697: sysdate, -- last update date
5698: FND_GLOBAL.USER_ID, -- last updated by
5699: FND_GLOBAL.USER_ID -- last updated login
5700: );
5701: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5702: DESCRIPTION,
5703: NATURAL_BALANCE,
5704: REPORTING_TYPE,
5705: TOTAL_RESOURCE_BE_FLAG,

Line 5748: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5744: sysdate, -- last update date
5745: FND_GLOBAL.USER_ID, -- last updated by
5746: FND_GLOBAL.USER_ID -- last updated login
5747: );
5748: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5749: DESCRIPTION,
5750: NATURAL_BALANCE,
5751: REPORTING_TYPE,
5752: TOTAL_RESOURCE_BE_FLAG,

Line 5795: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5791: sysdate, -- last update date
5792: FND_GLOBAL.USER_ID, -- last updated by
5793: FND_GLOBAL.USER_ID -- last updated login
5794: );
5795: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5796: DESCRIPTION,
5797: NATURAL_BALANCE,
5798: REPORTING_TYPE,
5799: TOTAL_RESOURCE_BE_FLAG,

Line 5842: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5838: sysdate, -- last update date
5839: FND_GLOBAL.USER_ID, -- last updated by
5840: FND_GLOBAL.USER_ID -- last updated login
5841: );
5842: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5843: DESCRIPTION,
5844: NATURAL_BALANCE,
5845: REPORTING_TYPE,
5846: TOTAL_RESOURCE_BE_FLAG,

Line 5889: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5885: sysdate, -- last update date
5886: FND_GLOBAL.USER_ID, -- last updated by
5887: FND_GLOBAL.USER_ID -- last updated login
5888: );
5889: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5890: DESCRIPTION,
5891: NATURAL_BALANCE,
5892: REPORTING_TYPE,
5893: TOTAL_RESOURCE_BE_FLAG,

Line 5936: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5932: sysdate, -- last update date
5933: FND_GLOBAL.USER_ID, -- last updated by
5934: FND_GLOBAL.USER_ID -- last updated login
5935: );
5936: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5937: DESCRIPTION,
5938: NATURAL_BALANCE,
5939: REPORTING_TYPE,
5940: TOTAL_RESOURCE_BE_FLAG,

Line 5983: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5979: sysdate, -- last update date
5980: FND_GLOBAL.USER_ID, -- last updated by
5981: FND_GLOBAL.USER_ID -- last updated login
5982: );
5983: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5984: DESCRIPTION,
5985: NATURAL_BALANCE,
5986: REPORTING_TYPE,
5987: TOTAL_RESOURCE_BE_FLAG,

Line 6030: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

6026: sysdate, -- last update date
6027: FND_GLOBAL.USER_ID, -- last updated by
6028: FND_GLOBAL.USER_ID -- last updated login
6029: );
6030: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
6031: DESCRIPTION,
6032: NATURAL_BALANCE,
6033: REPORTING_TYPE,
6034: TOTAL_RESOURCE_BE_FLAG,

Line 6077: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

6073: sysdate, -- last update date
6074: FND_GLOBAL.USER_ID, -- last updated by
6075: FND_GLOBAL.USER_ID -- last updated login
6076: );
6077: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
6078: DESCRIPTION,
6079: NATURAL_BALANCE,
6080: REPORTING_TYPE,
6081: TOTAL_RESOURCE_BE_FLAG,

Line 6124: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

6120: sysdate, -- last update date
6121: FND_GLOBAL.USER_ID, -- last updated by
6122: FND_GLOBAL.USER_ID -- last updated login
6123: );
6124: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
6125: DESCRIPTION,
6126: NATURAL_BALANCE,
6127: REPORTING_TYPE,
6128: TOTAL_RESOURCE_BE_FLAG,

Line 6171: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

6167: sysdate, -- last update date
6168: FND_GLOBAL.USER_ID, -- last updated by
6169: FND_GLOBAL.USER_ID -- last updated login
6170: );
6171: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
6172: DESCRIPTION,
6173: NATURAL_BALANCE,
6174: REPORTING_TYPE,
6175: TOTAL_RESOURCE_BE_FLAG,

Line 6218: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

6214: sysdate, -- last update date
6215: FND_GLOBAL.USER_ID, -- last updated by
6216: FND_GLOBAL.USER_ID -- last updated login
6217: );
6218: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
6219: DESCRIPTION,
6220: NATURAL_BALANCE,
6221: REPORTING_TYPE,
6222: TOTAL_RESOURCE_BE_FLAG,

Line 6265: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

6261: sysdate, -- last update date
6262: FND_GLOBAL.USER_ID, -- last updated by
6263: FND_GLOBAL.USER_ID -- last updated login
6264: );
6265: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
6266: DESCRIPTION,
6267: NATURAL_BALANCE,
6268: REPORTING_TYPE,
6269: TOTAL_RESOURCE_BE_FLAG,

Line 6312: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

6308: sysdate, -- last update date
6309: FND_GLOBAL.USER_ID, -- last updated by
6310: FND_GLOBAL.USER_ID -- last updated login
6311: );
6312: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
6313: DESCRIPTION,
6314: NATURAL_BALANCE,
6315: REPORTING_TYPE,
6316: TOTAL_RESOURCE_BE_FLAG,

Line 6359: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

6355: sysdate, -- last update date
6356: FND_GLOBAL.USER_ID, -- last updated by
6357: FND_GLOBAL.USER_ID -- last updated login
6358: );
6359: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
6360: DESCRIPTION,
6361: NATURAL_BALANCE,
6362: REPORTING_TYPE,
6363: TOTAL_RESOURCE_BE_FLAG,

Line 6406: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

6402: sysdate, -- last update date
6403: FND_GLOBAL.USER_ID, -- last updated by
6404: FND_GLOBAL.USER_ID -- last updated login
6405: );
6406: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
6407: DESCRIPTION,
6408: NATURAL_BALANCE,
6409: REPORTING_TYPE,
6410: TOTAL_RESOURCE_BE_FLAG,

Line 6453: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

6449: sysdate, -- last update date
6450: FND_GLOBAL.USER_ID, -- last updated by
6451: FND_GLOBAL.USER_ID -- last updated login
6452: );
6453: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
6454: DESCRIPTION,
6455: NATURAL_BALANCE,
6456: REPORTING_TYPE,
6457: TOTAL_RESOURCE_BE_FLAG,

Line 6500: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

6496: sysdate, -- last update date
6497: FND_GLOBAL.USER_ID, -- last updated by
6498: FND_GLOBAL.USER_ID -- last updated login
6499: );
6500: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
6501: DESCRIPTION,
6502: NATURAL_BALANCE,
6503: REPORTING_TYPE,
6504: TOTAL_RESOURCE_BE_FLAG,

Line 6547: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

6543: sysdate, -- last update date
6544: FND_GLOBAL.USER_ID, -- last updated by
6545: FND_GLOBAL.USER_ID -- last updated login
6546: );
6547: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
6548: DESCRIPTION,
6549: NATURAL_BALANCE,
6550: REPORTING_TYPE,
6551: TOTAL_RESOURCE_BE_FLAG,

Line 6594: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

6590: sysdate, -- last update date
6591: FND_GLOBAL.USER_ID, -- last updated by
6592: FND_GLOBAL.USER_ID -- last updated login
6593: );
6594: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
6595: DESCRIPTION,
6596: NATURAL_BALANCE,
6597: REPORTING_TYPE,
6598: TOTAL_RESOURCE_BE_FLAG,

Line 6641: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

6637: sysdate, -- last update date
6638: FND_GLOBAL.USER_ID, -- last updated by
6639: FND_GLOBAL.USER_ID -- last updated login
6640: );
6641: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
6642: DESCRIPTION,
6643: NATURAL_BALANCE,
6644: REPORTING_TYPE,
6645: TOTAL_RESOURCE_BE_FLAG,

Line 6688: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

6684: sysdate, -- last update date
6685: FND_GLOBAL.USER_ID, -- last updated by
6686: FND_GLOBAL.USER_ID -- last updated login
6687: );
6688: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
6689: DESCRIPTION,
6690: NATURAL_BALANCE,
6691: REPORTING_TYPE,
6692: TOTAL_RESOURCE_BE_FLAG,

Line 6735: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

6731: sysdate, -- last update date
6732: FND_GLOBAL.USER_ID, -- last updated by
6733: FND_GLOBAL.USER_ID -- last updated login
6734: );
6735: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
6736: DESCRIPTION,
6737: NATURAL_BALANCE,
6738: REPORTING_TYPE,
6739: TOTAL_RESOURCE_BE_FLAG,

Line 6782: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

6778: sysdate, -- last update date
6779: FND_GLOBAL.USER_ID, -- last updated by
6780: FND_GLOBAL.USER_ID -- last updated login
6781: );
6782: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
6783: DESCRIPTION,
6784: NATURAL_BALANCE,
6785: REPORTING_TYPE,
6786: TOTAL_RESOURCE_BE_FLAG,

Line 6829: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

6825: sysdate, -- last update date
6826: FND_GLOBAL.USER_ID, -- last updated by
6827: FND_GLOBAL.USER_ID -- last updated login
6828: );
6829: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
6830: DESCRIPTION,
6831: NATURAL_BALANCE,
6832: REPORTING_TYPE,
6833: TOTAL_RESOURCE_BE_FLAG,

Line 6876: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

6872: sysdate, -- last update date
6873: FND_GLOBAL.USER_ID, -- last updated by
6874: FND_GLOBAL.USER_ID -- last updated login
6875: );
6876: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
6877: DESCRIPTION,
6878: NATURAL_BALANCE,
6879: REPORTING_TYPE,
6880: TOTAL_RESOURCE_BE_FLAG,

Line 6923: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

6919: sysdate, -- last update date
6920: FND_GLOBAL.USER_ID, -- last updated by
6921: FND_GLOBAL.USER_ID -- last updated login
6922: );
6923: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
6924: DESCRIPTION,
6925: NATURAL_BALANCE,
6926: REPORTING_TYPE,
6927: TOTAL_RESOURCE_BE_FLAG,

Line 6970: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

6966: sysdate, -- last update date
6967: FND_GLOBAL.USER_ID, -- last updated by
6968: FND_GLOBAL.USER_ID -- last updated login
6969: );
6970: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
6971: DESCRIPTION,
6972: NATURAL_BALANCE,
6973: REPORTING_TYPE,
6974: TOTAL_RESOURCE_BE_FLAG,

Line 7017: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

7013: sysdate, -- last update date
7014: FND_GLOBAL.USER_ID, -- last updated by
7015: FND_GLOBAL.USER_ID -- last updated login
7016: );
7017: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
7018: DESCRIPTION,
7019: NATURAL_BALANCE,
7020: REPORTING_TYPE,
7021: TOTAL_RESOURCE_BE_FLAG,

Line 7064: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

7060: sysdate, -- last update date
7061: FND_GLOBAL.USER_ID, -- last updated by
7062: FND_GLOBAL.USER_ID -- last updated login
7063: );
7064: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
7065: DESCRIPTION,
7066: NATURAL_BALANCE,
7067: REPORTING_TYPE,
7068: TOTAL_RESOURCE_BE_FLAG,

Line 7111: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

7107: sysdate, -- last update date
7108: FND_GLOBAL.USER_ID, -- last updated by
7109: FND_GLOBAL.USER_ID -- last updated login
7110: );
7111: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
7112: DESCRIPTION,
7113: NATURAL_BALANCE,
7114: REPORTING_TYPE,
7115: TOTAL_RESOURCE_BE_FLAG,

Line 7158: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

7154: sysdate, -- last update date
7155: FND_GLOBAL.USER_ID, -- last updated by
7156: FND_GLOBAL.USER_ID -- last updated login
7157: );
7158: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
7159: DESCRIPTION,
7160: NATURAL_BALANCE,
7161: REPORTING_TYPE,
7162: TOTAL_RESOURCE_BE_FLAG,

Line 7205: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

7201: sysdate, -- last update date
7202: FND_GLOBAL.USER_ID, -- last updated by
7203: FND_GLOBAL.USER_ID -- last updated login
7204: );
7205: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
7206: DESCRIPTION,
7207: NATURAL_BALANCE,
7208: REPORTING_TYPE,
7209: TOTAL_RESOURCE_BE_FLAG,

Line 7252: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

7248: sysdate, -- last update date
7249: FND_GLOBAL.USER_ID, -- last updated by
7250: FND_GLOBAL.USER_ID -- last updated login
7251: );
7252: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
7253: DESCRIPTION,
7254: NATURAL_BALANCE,
7255: REPORTING_TYPE,
7256: TOTAL_RESOURCE_BE_FLAG,

Line 7299: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

7295: sysdate, -- last update date
7296: FND_GLOBAL.USER_ID, -- last updated by
7297: FND_GLOBAL.USER_ID -- last updated login
7298: );
7299: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
7300: DESCRIPTION,
7301: NATURAL_BALANCE,
7302: REPORTING_TYPE,
7303: TOTAL_RESOURCE_BE_FLAG,

Line 7346: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

7342: sysdate, -- last update date
7343: FND_GLOBAL.USER_ID, -- last updated by
7344: FND_GLOBAL.USER_ID -- last updated login
7345: );
7346: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
7347: DESCRIPTION,
7348: NATURAL_BALANCE,
7349: REPORTING_TYPE,
7350: TOTAL_RESOURCE_BE_FLAG,

Line 7393: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

7389: sysdate, -- last update date
7390: FND_GLOBAL.USER_ID, -- last updated by
7391: FND_GLOBAL.USER_ID -- last updated login
7392: );
7393: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
7394: DESCRIPTION,
7395: NATURAL_BALANCE,
7396: REPORTING_TYPE,
7397: TOTAL_RESOURCE_BE_FLAG,

Line 7440: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

7436: sysdate, -- last update date
7437: FND_GLOBAL.USER_ID, -- last updated by
7438: FND_GLOBAL.USER_ID -- last updated login
7439: );
7440: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
7441: DESCRIPTION,
7442: NATURAL_BALANCE,
7443: REPORTING_TYPE,
7444: TOTAL_RESOURCE_BE_FLAG,

Line 7487: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

7483: sysdate, -- last update date
7484: FND_GLOBAL.USER_ID, -- last updated by
7485: FND_GLOBAL.USER_ID -- last updated login
7486: );
7487: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
7488: DESCRIPTION,
7489: NATURAL_BALANCE,
7490: REPORTING_TYPE,
7491: TOTAL_RESOURCE_BE_FLAG,

Line 7534: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

7530: sysdate, -- last update date
7531: FND_GLOBAL.USER_ID, -- last updated by
7532: FND_GLOBAL.USER_ID -- last updated login
7533: );
7534: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
7535: DESCRIPTION,
7536: NATURAL_BALANCE,
7537: REPORTING_TYPE,
7538: TOTAL_RESOURCE_BE_FLAG,

Line 7581: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

7577: sysdate, -- last update date
7578: FND_GLOBAL.USER_ID, -- last updated by
7579: FND_GLOBAL.USER_ID -- last updated login
7580: );
7581: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
7582: DESCRIPTION,
7583: NATURAL_BALANCE,
7584: REPORTING_TYPE,
7585: TOTAL_RESOURCE_BE_FLAG,

Line 7628: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

7624: sysdate, -- last update date
7625: FND_GLOBAL.USER_ID, -- last updated by
7626: FND_GLOBAL.USER_ID -- last updated login
7627: );
7628: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
7629: DESCRIPTION,
7630: NATURAL_BALANCE,
7631: REPORTING_TYPE,
7632: TOTAL_RESOURCE_BE_FLAG,

Line 7675: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

7671: sysdate, -- last update date
7672: FND_GLOBAL.USER_ID, -- last updated by
7673: FND_GLOBAL.USER_ID -- last updated login
7674: );
7675: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
7676: DESCRIPTION,
7677: NATURAL_BALANCE,
7678: REPORTING_TYPE,
7679: TOTAL_RESOURCE_BE_FLAG,

Line 7722: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

7718: sysdate, -- last update date
7719: FND_GLOBAL.USER_ID, -- last updated by
7720: FND_GLOBAL.USER_ID -- last updated login
7721: );
7722: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
7723: DESCRIPTION,
7724: NATURAL_BALANCE,
7725: REPORTING_TYPE,
7726: TOTAL_RESOURCE_BE_FLAG,

Line 7769: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

7765: sysdate, -- last update date
7766: FND_GLOBAL.USER_ID, -- last updated by
7767: FND_GLOBAL.USER_ID -- last updated login
7768: );
7769: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
7770: DESCRIPTION,
7771: NATURAL_BALANCE,
7772: REPORTING_TYPE,
7773: TOTAL_RESOURCE_BE_FLAG,

Line 7816: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

7812: sysdate, -- last update date
7813: FND_GLOBAL.USER_ID, -- last updated by
7814: FND_GLOBAL.USER_ID -- last updated login
7815: );
7816: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
7817: DESCRIPTION,
7818: NATURAL_BALANCE,
7819: REPORTING_TYPE,
7820: TOTAL_RESOURCE_BE_FLAG,

Line 7863: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

7859: sysdate, -- last update date
7860: FND_GLOBAL.USER_ID, -- last updated by
7861: FND_GLOBAL.USER_ID -- last updated login
7862: );
7863: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
7864: DESCRIPTION,
7865: NATURAL_BALANCE,
7866: REPORTING_TYPE,
7867: TOTAL_RESOURCE_BE_FLAG,

Line 7910: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

7906: sysdate, -- last update date
7907: FND_GLOBAL.USER_ID, -- last updated by
7908: FND_GLOBAL.USER_ID -- last updated login
7909: );
7910: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
7911: DESCRIPTION,
7912: NATURAL_BALANCE,
7913: REPORTING_TYPE,
7914: TOTAL_RESOURCE_BE_FLAG,

Line 7957: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

7953: sysdate, -- last update date
7954: FND_GLOBAL.USER_ID, -- last updated by
7955: FND_GLOBAL.USER_ID -- last updated login
7956: );
7957: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
7958: DESCRIPTION,
7959: NATURAL_BALANCE,
7960: REPORTING_TYPE,
7961: TOTAL_RESOURCE_BE_FLAG,

Line 8004: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

8000: sysdate, -- last update date
8001: FND_GLOBAL.USER_ID, -- last updated by
8002: FND_GLOBAL.USER_ID -- last updated login
8003: );
8004: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
8005: DESCRIPTION,
8006: NATURAL_BALANCE,
8007: REPORTING_TYPE,
8008: TOTAL_RESOURCE_BE_FLAG,

Line 8051: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

8047: sysdate, -- last update date
8048: FND_GLOBAL.USER_ID, -- last updated by
8049: FND_GLOBAL.USER_ID -- last updated login
8050: );
8051: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
8052: DESCRIPTION,
8053: NATURAL_BALANCE,
8054: REPORTING_TYPE,
8055: TOTAL_RESOURCE_BE_FLAG,

Line 8098: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

8094: sysdate, -- last update date
8095: FND_GLOBAL.USER_ID, -- last updated by
8096: FND_GLOBAL.USER_ID -- last updated login
8097: );
8098: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
8099: DESCRIPTION,
8100: NATURAL_BALANCE,
8101: REPORTING_TYPE,
8102: TOTAL_RESOURCE_BE_FLAG,

Line 8145: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

8141: sysdate, -- last update date
8142: FND_GLOBAL.USER_ID, -- last updated by
8143: FND_GLOBAL.USER_ID -- last updated login
8144: );
8145: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
8146: DESCRIPTION,
8147: NATURAL_BALANCE,
8148: REPORTING_TYPE,
8149: TOTAL_RESOURCE_BE_FLAG,

Line 8192: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

8188: sysdate, -- last update date
8189: FND_GLOBAL.USER_ID, -- last updated by
8190: FND_GLOBAL.USER_ID -- last updated login
8191: );
8192: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
8193: DESCRIPTION,
8194: NATURAL_BALANCE,
8195: REPORTING_TYPE,
8196: TOTAL_RESOURCE_BE_FLAG,

Line 8239: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

8235: sysdate, -- last update date
8236: FND_GLOBAL.USER_ID, -- last updated by
8237: FND_GLOBAL.USER_ID -- last updated login
8238: );
8239: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
8240: DESCRIPTION,
8241: NATURAL_BALANCE,
8242: REPORTING_TYPE,
8243: TOTAL_RESOURCE_BE_FLAG,

Line 8286: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

8282: sysdate, -- last update date
8283: FND_GLOBAL.USER_ID, -- last updated by
8284: FND_GLOBAL.USER_ID -- last updated login
8285: );
8286: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
8287: DESCRIPTION,
8288: NATURAL_BALANCE,
8289: REPORTING_TYPE,
8290: TOTAL_RESOURCE_BE_FLAG,

Line 8333: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

8329: sysdate, -- last update date
8330: FND_GLOBAL.USER_ID, -- last updated by
8331: FND_GLOBAL.USER_ID -- last updated login
8332: );
8333: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
8334: DESCRIPTION,
8335: NATURAL_BALANCE,
8336: REPORTING_TYPE,
8337: TOTAL_RESOURCE_BE_FLAG,

Line 8380: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

8376: sysdate, -- last update date
8377: FND_GLOBAL.USER_ID, -- last updated by
8378: FND_GLOBAL.USER_ID -- last updated login
8379: );
8380: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
8381: DESCRIPTION,
8382: NATURAL_BALANCE,
8383: REPORTING_TYPE,
8384: TOTAL_RESOURCE_BE_FLAG,

Line 8427: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

8423: sysdate, -- last update date
8424: FND_GLOBAL.USER_ID, -- last updated by
8425: FND_GLOBAL.USER_ID -- last updated login
8426: );
8427: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
8428: DESCRIPTION,
8429: NATURAL_BALANCE,
8430: REPORTING_TYPE,
8431: TOTAL_RESOURCE_BE_FLAG,

Line 8474: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

8470: sysdate, -- last update date
8471: FND_GLOBAL.USER_ID, -- last updated by
8472: FND_GLOBAL.USER_ID -- last updated login
8473: );
8474: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
8475: DESCRIPTION,
8476: NATURAL_BALANCE,
8477: REPORTING_TYPE,
8478: TOTAL_RESOURCE_BE_FLAG,

Line 8521: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

8517: sysdate, -- last update date
8518: FND_GLOBAL.USER_ID, -- last updated by
8519: FND_GLOBAL.USER_ID -- last updated login
8520: );
8521: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
8522: DESCRIPTION,
8523: NATURAL_BALANCE,
8524: REPORTING_TYPE,
8525: TOTAL_RESOURCE_BE_FLAG,

Line 8568: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

8564: sysdate, -- last update date
8565: FND_GLOBAL.USER_ID, -- last updated by
8566: FND_GLOBAL.USER_ID -- last updated login
8567: );
8568: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
8569: DESCRIPTION,
8570: NATURAL_BALANCE,
8571: REPORTING_TYPE,
8572: TOTAL_RESOURCE_BE_FLAG,

Line 8615: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

8611: sysdate, -- last update date
8612: FND_GLOBAL.USER_ID, -- last updated by
8613: FND_GLOBAL.USER_ID -- last updated login
8614: );
8615: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
8616: DESCRIPTION,
8617: NATURAL_BALANCE,
8618: REPORTING_TYPE,
8619: TOTAL_RESOURCE_BE_FLAG,

Line 8662: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

8658: sysdate, -- last update date
8659: FND_GLOBAL.USER_ID, -- last updated by
8660: FND_GLOBAL.USER_ID -- last updated login
8661: );
8662: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
8663: DESCRIPTION,
8664: NATURAL_BALANCE,
8665: REPORTING_TYPE,
8666: TOTAL_RESOURCE_BE_FLAG,

Line 8709: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

8705: sysdate, -- last update date
8706: FND_GLOBAL.USER_ID, -- last updated by
8707: FND_GLOBAL.USER_ID -- last updated login
8708: );
8709: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
8710: DESCRIPTION,
8711: NATURAL_BALANCE,
8712: REPORTING_TYPE,
8713: TOTAL_RESOURCE_BE_FLAG,

Line 8756: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

8752: sysdate, -- last update date
8753: FND_GLOBAL.USER_ID, -- last updated by
8754: FND_GLOBAL.USER_ID -- last updated login
8755: );
8756: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
8757: DESCRIPTION,
8758: NATURAL_BALANCE,
8759: REPORTING_TYPE,
8760: TOTAL_RESOURCE_BE_FLAG,

Line 8803: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

8799: sysdate, -- last update date
8800: FND_GLOBAL.USER_ID, -- last updated by
8801: FND_GLOBAL.USER_ID -- last updated login
8802: );
8803: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
8804: DESCRIPTION,
8805: NATURAL_BALANCE,
8806: REPORTING_TYPE,
8807: TOTAL_RESOURCE_BE_FLAG,

Line 8850: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

8846: sysdate, -- last update date
8847: FND_GLOBAL.USER_ID, -- last updated by
8848: FND_GLOBAL.USER_ID -- last updated login
8849: );
8850: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
8851: DESCRIPTION,
8852: NATURAL_BALANCE,
8853: REPORTING_TYPE,
8854: TOTAL_RESOURCE_BE_FLAG,

Line 8897: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

8893: sysdate, -- last update date
8894: FND_GLOBAL.USER_ID, -- last updated by
8895: FND_GLOBAL.USER_ID -- last updated login
8896: );
8897: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
8898: DESCRIPTION,
8899: NATURAL_BALANCE,
8900: REPORTING_TYPE,
8901: TOTAL_RESOURCE_BE_FLAG,

Line 8944: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

8940: sysdate, -- last update date
8941: FND_GLOBAL.USER_ID, -- last updated by
8942: FND_GLOBAL.USER_ID -- last updated login
8943: );
8944: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
8945: DESCRIPTION,
8946: NATURAL_BALANCE,
8947: REPORTING_TYPE,
8948: TOTAL_RESOURCE_BE_FLAG,

Line 8991: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

8987: sysdate, -- last update date
8988: FND_GLOBAL.USER_ID, -- last updated by
8989: FND_GLOBAL.USER_ID -- last updated login
8990: );
8991: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
8992: DESCRIPTION,
8993: NATURAL_BALANCE,
8994: REPORTING_TYPE,
8995: TOTAL_RESOURCE_BE_FLAG,

Line 9038: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

9034: sysdate, -- last update date
9035: FND_GLOBAL.USER_ID, -- last updated by
9036: FND_GLOBAL.USER_ID -- last updated login
9037: );
9038: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
9039: DESCRIPTION,
9040: NATURAL_BALANCE,
9041: REPORTING_TYPE,
9042: TOTAL_RESOURCE_BE_FLAG,

Line 9085: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

9081: sysdate, -- last update date
9082: FND_GLOBAL.USER_ID, -- last updated by
9083: FND_GLOBAL.USER_ID -- last updated login
9084: );
9085: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
9086: DESCRIPTION,
9087: NATURAL_BALANCE,
9088: REPORTING_TYPE,
9089: TOTAL_RESOURCE_BE_FLAG,

Line 9132: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

9128: sysdate, -- last update date
9129: FND_GLOBAL.USER_ID, -- last updated by
9130: FND_GLOBAL.USER_ID -- last updated login
9131: );
9132: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
9133: DESCRIPTION,
9134: NATURAL_BALANCE,
9135: REPORTING_TYPE,
9136: TOTAL_RESOURCE_BE_FLAG,

Line 9179: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

9175: sysdate, -- last update date
9176: FND_GLOBAL.USER_ID, -- last updated by
9177: FND_GLOBAL.USER_ID -- last updated login
9178: );
9179: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
9180: DESCRIPTION,
9181: NATURAL_BALANCE,
9182: REPORTING_TYPE,
9183: TOTAL_RESOURCE_BE_FLAG,

Line 9226: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

9222: sysdate, -- last update date
9223: FND_GLOBAL.USER_ID, -- last updated by
9224: FND_GLOBAL.USER_ID -- last updated login
9225: );
9226: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
9227: DESCRIPTION,
9228: NATURAL_BALANCE,
9229: REPORTING_TYPE,
9230: TOTAL_RESOURCE_BE_FLAG,

Line 9273: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

9269: sysdate, -- last update date
9270: FND_GLOBAL.USER_ID, -- last updated by
9271: FND_GLOBAL.USER_ID -- last updated login
9272: );
9273: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
9274: DESCRIPTION,
9275: NATURAL_BALANCE,
9276: REPORTING_TYPE,
9277: TOTAL_RESOURCE_BE_FLAG,

Line 9320: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

9316: sysdate, -- last update date
9317: FND_GLOBAL.USER_ID, -- last updated by
9318: FND_GLOBAL.USER_ID -- last updated login
9319: );
9320: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
9321: DESCRIPTION,
9322: NATURAL_BALANCE,
9323: REPORTING_TYPE,
9324: TOTAL_RESOURCE_BE_FLAG,

Line 9367: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

9363: sysdate, -- last update date
9364: FND_GLOBAL.USER_ID, -- last updated by
9365: FND_GLOBAL.USER_ID -- last updated login
9366: );
9367: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
9368: DESCRIPTION,
9369: NATURAL_BALANCE,
9370: REPORTING_TYPE,
9371: TOTAL_RESOURCE_BE_FLAG,

Line 9414: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

9410: sysdate, -- last update date
9411: FND_GLOBAL.USER_ID, -- last updated by
9412: FND_GLOBAL.USER_ID -- last updated login
9413: );
9414: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
9415: DESCRIPTION,
9416: NATURAL_BALANCE,
9417: REPORTING_TYPE,
9418: TOTAL_RESOURCE_BE_FLAG,

Line 9461: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

9457: sysdate, -- last update date
9458: FND_GLOBAL.USER_ID, -- last updated by
9459: FND_GLOBAL.USER_ID -- last updated login
9460: );
9461: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
9462: DESCRIPTION,
9463: NATURAL_BALANCE,
9464: REPORTING_TYPE,
9465: TOTAL_RESOURCE_BE_FLAG,

Line 9508: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

9504: sysdate, -- last update date
9505: FND_GLOBAL.USER_ID, -- last updated by
9506: FND_GLOBAL.USER_ID -- last updated login
9507: );
9508: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
9509: DESCRIPTION,
9510: NATURAL_BALANCE,
9511: REPORTING_TYPE,
9512: TOTAL_RESOURCE_BE_FLAG,

Line 9555: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

9551: sysdate, -- last update date
9552: FND_GLOBAL.USER_ID, -- last updated by
9553: FND_GLOBAL.USER_ID -- last updated login
9554: );
9555: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
9556: DESCRIPTION,
9557: NATURAL_BALANCE,
9558: REPORTING_TYPE,
9559: TOTAL_RESOURCE_BE_FLAG,

Line 9602: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

9598: sysdate, -- last update date
9599: FND_GLOBAL.USER_ID, -- last updated by
9600: FND_GLOBAL.USER_ID -- last updated login
9601: );
9602: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
9603: DESCRIPTION,
9604: NATURAL_BALANCE,
9605: REPORTING_TYPE,
9606: TOTAL_RESOURCE_BE_FLAG,

Line 9649: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

9645: sysdate, -- last update date
9646: FND_GLOBAL.USER_ID, -- last updated by
9647: FND_GLOBAL.USER_ID -- last updated login
9648: );
9649: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
9650: DESCRIPTION,
9651: NATURAL_BALANCE,
9652: REPORTING_TYPE,
9653: TOTAL_RESOURCE_BE_FLAG,

Line 9699: UPDATE fv_facts_ussgl_accounts

9695: );
9696:
9697: -- Start Bug 2212263
9698:
9699: UPDATE fv_facts_ussgl_accounts
9700: SET edck12_balance_type='E'
9701: WHERE disbursements_flag='Y' OR collections_flag='Y';
9702:
9703: UPDATE fv_facts_ussgl_accounts

Line 9703: UPDATE fv_facts_ussgl_accounts

9699: UPDATE fv_facts_ussgl_accounts
9700: SET edck12_balance_type='E'
9701: WHERE disbursements_flag='Y' OR collections_flag='Y';
9702:
9703: UPDATE fv_facts_ussgl_accounts
9704: SET edck12_balance_type='S'
9705: WHERE (disbursements_flag='Y' OR collections_flag='Y') AND
9706: ussgl_account IN ('4802','4222');
9707: