DBA Data[Home] [Help]

APPS.FVFCSGL1 dependencies on FV_FACTS_USSGL_ACCOUNTS

Line 17: FROM fv_facts_ussgl_accounts;

13: v_sob_name := FND_PROFILE.VALUE('GL_SET_OF_BKS_NAME');*/
14:
15: SELECT count(*)
16: INTO v_count
17: FROM fv_facts_ussgl_accounts;
18:
19: IF v_count > 0
20: THEN
21: null;

Line 26: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

22: errbuf := 'Table already seeded. Can not run the same process twice, unless the existing records are deleted.';
23: retcode := -1;
24: ELSE
25:
26: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
27: DESCRIPTION,
28: NATURAL_BALANCE,
29: REPORTING_TYPE,
30: TOTAL_RESOURCE_BE_FLAG,

Line 73: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

69: sysdate, -- last update date
70: FND_GLOBAL.USER_ID, -- last updated by
71: FND_GLOBAL.USER_ID -- last updated login
72: );
73: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
74: DESCRIPTION,
75: NATURAL_BALANCE,
76: REPORTING_TYPE,
77: TOTAL_RESOURCE_BE_FLAG,

Line 120: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

116: sysdate, -- last update date
117: FND_GLOBAL.USER_ID, -- last updated by
118: FND_GLOBAL.USER_ID -- last updated login
119: );
120: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
121: DESCRIPTION,
122: NATURAL_BALANCE,
123: REPORTING_TYPE,
124: TOTAL_RESOURCE_BE_FLAG,

Line 167: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

163: sysdate, -- last update date
164: FND_GLOBAL.USER_ID, -- last updated by
165: FND_GLOBAL.USER_ID -- last updated login
166: );
167: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
168: DESCRIPTION,
169: NATURAL_BALANCE,
170: REPORTING_TYPE,
171: TOTAL_RESOURCE_BE_FLAG,

Line 214: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

210: sysdate, -- last update date
211: FND_GLOBAL.USER_ID, -- last updated by
212: FND_GLOBAL.USER_ID -- last updated login
213: );
214: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
215: DESCRIPTION,
216: NATURAL_BALANCE,
217: REPORTING_TYPE,
218: TOTAL_RESOURCE_BE_FLAG,

Line 261: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

257: sysdate, -- last update date
258: FND_GLOBAL.USER_ID, -- last updated by
259: FND_GLOBAL.USER_ID -- last updated login
260: );
261: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
262: DESCRIPTION,
263: NATURAL_BALANCE,
264: REPORTING_TYPE,
265: TOTAL_RESOURCE_BE_FLAG,

Line 308: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

304: sysdate, -- last update date
305: FND_GLOBAL.USER_ID, -- last updated by
306: FND_GLOBAL.USER_ID -- last updated login
307: );
308: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
309: DESCRIPTION,
310: NATURAL_BALANCE,
311: REPORTING_TYPE,
312: TOTAL_RESOURCE_BE_FLAG,

Line 355: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

351: sysdate, -- last update date
352: FND_GLOBAL.USER_ID, -- last updated by
353: FND_GLOBAL.USER_ID -- last updated login
354: );
355: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
356: DESCRIPTION,
357: NATURAL_BALANCE,
358: REPORTING_TYPE,
359: TOTAL_RESOURCE_BE_FLAG,

Line 402: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

398: sysdate, -- last update date
399: FND_GLOBAL.USER_ID, -- last updated by
400: FND_GLOBAL.USER_ID -- last updated login
401: );
402: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
403: DESCRIPTION,
404: NATURAL_BALANCE,
405: REPORTING_TYPE,
406: TOTAL_RESOURCE_BE_FLAG,

Line 449: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

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

Line 496: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

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

Line 543: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

539: sysdate, -- last update date
540: FND_GLOBAL.USER_ID, -- last updated by
541: FND_GLOBAL.USER_ID -- last updated login
542: );
543: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
544: DESCRIPTION,
545: NATURAL_BALANCE,
546: REPORTING_TYPE,
547: 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 637: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

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

Line 684: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

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

Line 731: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

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

Line 778: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

774: sysdate, -- last update date
775: FND_GLOBAL.USER_ID, -- last updated by
776: FND_GLOBAL.USER_ID -- last updated login
777: );
778: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
779: DESCRIPTION,
780: NATURAL_BALANCE,
781: REPORTING_TYPE,
782: TOTAL_RESOURCE_BE_FLAG,

Line 825: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

821: sysdate, -- last update date
822: FND_GLOBAL.USER_ID, -- last updated by
823: FND_GLOBAL.USER_ID -- last updated login
824: );
825: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
826: DESCRIPTION,
827: NATURAL_BALANCE,
828: REPORTING_TYPE,
829: TOTAL_RESOURCE_BE_FLAG,

Line 872: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

868: sysdate, -- last update date
869: FND_GLOBAL.USER_ID, -- last updated by
870: FND_GLOBAL.USER_ID -- last updated login
871: );
872: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
873: DESCRIPTION,
874: NATURAL_BALANCE,
875: REPORTING_TYPE,
876: TOTAL_RESOURCE_BE_FLAG,

Line 919: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

915: sysdate, -- last update date
916: FND_GLOBAL.USER_ID, -- last updated by
917: FND_GLOBAL.USER_ID -- last updated login
918: );
919: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
920: DESCRIPTION,
921: NATURAL_BALANCE,
922: REPORTING_TYPE,
923: TOTAL_RESOURCE_BE_FLAG,

Line 966: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

962: sysdate, -- last update date
963: FND_GLOBAL.USER_ID, -- last updated by
964: FND_GLOBAL.USER_ID -- last updated login
965: );
966: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
967: DESCRIPTION,
968: NATURAL_BALANCE,
969: REPORTING_TYPE,
970: TOTAL_RESOURCE_BE_FLAG,

Line 1013: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1009: sysdate, -- last update date
1010: FND_GLOBAL.USER_ID, -- last updated by
1011: FND_GLOBAL.USER_ID -- last updated login
1012: );
1013: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1014: DESCRIPTION,
1015: NATURAL_BALANCE,
1016: REPORTING_TYPE,
1017: TOTAL_RESOURCE_BE_FLAG,

Line 1060: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1056: sysdate, -- last update date
1057: FND_GLOBAL.USER_ID, -- last updated by
1058: FND_GLOBAL.USER_ID -- last updated login
1059: );
1060: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1061: DESCRIPTION,
1062: NATURAL_BALANCE,
1063: REPORTING_TYPE,
1064: TOTAL_RESOURCE_BE_FLAG,

Line 1107: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1103: sysdate, -- last update date
1104: FND_GLOBAL.USER_ID, -- last updated by
1105: FND_GLOBAL.USER_ID -- last updated login
1106: );
1107: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1108: DESCRIPTION,
1109: NATURAL_BALANCE,
1110: REPORTING_TYPE,
1111: TOTAL_RESOURCE_BE_FLAG,

Line 1154: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1150: sysdate, -- last update date
1151: FND_GLOBAL.USER_ID, -- last updated by
1152: FND_GLOBAL.USER_ID -- last updated login
1153: );
1154: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1155: DESCRIPTION,
1156: NATURAL_BALANCE,
1157: REPORTING_TYPE,
1158: TOTAL_RESOURCE_BE_FLAG,

Line 1201: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1197: sysdate, -- last update date
1198: FND_GLOBAL.USER_ID, -- last updated by
1199: FND_GLOBAL.USER_ID -- last updated login
1200: );
1201: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1202: DESCRIPTION,
1203: NATURAL_BALANCE,
1204: REPORTING_TYPE,
1205: TOTAL_RESOURCE_BE_FLAG,

Line 1249: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1245: FND_GLOBAL.USER_ID, -- last updated by
1246: FND_GLOBAL.USER_ID -- last updated login
1247: );
1248:
1249: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1250: DESCRIPTION,
1251: NATURAL_BALANCE,
1252: REPORTING_TYPE,
1253: TOTAL_RESOURCE_BE_FLAG,

Line 1297: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1293: FND_GLOBAL.USER_ID, -- last updated by
1294: FND_GLOBAL.USER_ID -- last updated login
1295: );
1296:
1297: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1298: DESCRIPTION,
1299: NATURAL_BALANCE,
1300: REPORTING_TYPE,
1301: TOTAL_RESOURCE_BE_FLAG,

Line 1345: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1341: FND_GLOBAL.USER_ID, -- last updated by
1342: FND_GLOBAL.USER_ID -- last updated login
1343: );
1344:
1345: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1346: DESCRIPTION,
1347: NATURAL_BALANCE,
1348: REPORTING_TYPE,
1349: TOTAL_RESOURCE_BE_FLAG,

Line 1392: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1388: sysdate, -- last update date
1389: FND_GLOBAL.USER_ID, -- last updated by
1390: FND_GLOBAL.USER_ID -- last updated login
1391: );
1392: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1393: DESCRIPTION,
1394: NATURAL_BALANCE,
1395: REPORTING_TYPE,
1396: TOTAL_RESOURCE_BE_FLAG,

Line 1439: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1435: sysdate, -- last update date
1436: FND_GLOBAL.USER_ID, -- last updated by
1437: FND_GLOBAL.USER_ID -- last updated login
1438: );
1439: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1440: DESCRIPTION,
1441: NATURAL_BALANCE,
1442: REPORTING_TYPE,
1443: TOTAL_RESOURCE_BE_FLAG,

Line 1486: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1482: sysdate, -- last update date
1483: FND_GLOBAL.USER_ID, -- last updated by
1484: FND_GLOBAL.USER_ID -- last updated login
1485: );
1486: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1487: DESCRIPTION,
1488: NATURAL_BALANCE,
1489: REPORTING_TYPE,
1490: TOTAL_RESOURCE_BE_FLAG,

Line 1533: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1529: sysdate, -- last update date
1530: FND_GLOBAL.USER_ID, -- last updated by
1531: FND_GLOBAL.USER_ID -- last updated login
1532: );
1533: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1534: DESCRIPTION,
1535: NATURAL_BALANCE,
1536: REPORTING_TYPE,
1537: TOTAL_RESOURCE_BE_FLAG,

Line 1580: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1576: sysdate, -- last update date
1577: FND_GLOBAL.USER_ID, -- last updated by
1578: FND_GLOBAL.USER_ID -- last updated login
1579: );
1580: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1581: DESCRIPTION,
1582: NATURAL_BALANCE,
1583: REPORTING_TYPE,
1584: TOTAL_RESOURCE_BE_FLAG,

Line 1627: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1623: sysdate, -- last update date
1624: FND_GLOBAL.USER_ID, -- last updated by
1625: FND_GLOBAL.USER_ID -- last updated login
1626: );
1627: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1628: DESCRIPTION,
1629: NATURAL_BALANCE,
1630: REPORTING_TYPE,
1631: TOTAL_RESOURCE_BE_FLAG,

Line 1674: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1670: sysdate, -- last update date
1671: FND_GLOBAL.USER_ID, -- last updated by
1672: FND_GLOBAL.USER_ID -- last updated login
1673: );
1674: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1675: DESCRIPTION,
1676: NATURAL_BALANCE,
1677: REPORTING_TYPE,
1678: TOTAL_RESOURCE_BE_FLAG,

Line 1721: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1717: sysdate, -- last update date
1718: FND_GLOBAL.USER_ID, -- last updated by
1719: FND_GLOBAL.USER_ID -- last updated login
1720: );
1721: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1722: DESCRIPTION,
1723: NATURAL_BALANCE,
1724: REPORTING_TYPE,
1725: TOTAL_RESOURCE_BE_FLAG,

Line 1768: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1764: sysdate, -- last update date
1765: FND_GLOBAL.USER_ID, -- last updated by
1766: FND_GLOBAL.USER_ID -- last updated login
1767: );
1768: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1769: DESCRIPTION,
1770: NATURAL_BALANCE,
1771: REPORTING_TYPE,
1772: TOTAL_RESOURCE_BE_FLAG,

Line 1815: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1811: sysdate, -- last update date
1812: FND_GLOBAL.USER_ID, -- last updated by
1813: FND_GLOBAL.USER_ID -- last updated login
1814: );
1815: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1816: DESCRIPTION,
1817: NATURAL_BALANCE,
1818: REPORTING_TYPE,
1819: TOTAL_RESOURCE_BE_FLAG,

Line 1862: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1858: sysdate, -- last update date
1859: FND_GLOBAL.USER_ID, -- last updated by
1860: FND_GLOBAL.USER_ID -- last updated login
1861: );
1862: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1863: DESCRIPTION,
1864: NATURAL_BALANCE,
1865: REPORTING_TYPE,
1866: TOTAL_RESOURCE_BE_FLAG,

Line 1909: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1905: sysdate, -- last update date
1906: FND_GLOBAL.USER_ID, -- last updated by
1907: FND_GLOBAL.USER_ID -- last updated login
1908: );
1909: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1910: DESCRIPTION,
1911: NATURAL_BALANCE,
1912: REPORTING_TYPE,
1913: TOTAL_RESOURCE_BE_FLAG,

Line 1956: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1952: sysdate, -- last update date
1953: FND_GLOBAL.USER_ID, -- last updated by
1954: FND_GLOBAL.USER_ID -- last updated login
1955: );
1956: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
1957: DESCRIPTION,
1958: NATURAL_BALANCE,
1959: REPORTING_TYPE,
1960: TOTAL_RESOURCE_BE_FLAG,

Line 2003: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

1999: sysdate, -- last update date
2000: FND_GLOBAL.USER_ID, -- last updated by
2001: FND_GLOBAL.USER_ID -- last updated login
2002: );
2003: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2004: DESCRIPTION,
2005: NATURAL_BALANCE,
2006: REPORTING_TYPE,
2007: TOTAL_RESOURCE_BE_FLAG,

Line 2050: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2046: sysdate, -- last update date
2047: FND_GLOBAL.USER_ID, -- last updated by
2048: FND_GLOBAL.USER_ID -- last updated login
2049: );
2050: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2051: DESCRIPTION,
2052: NATURAL_BALANCE,
2053: REPORTING_TYPE,
2054: TOTAL_RESOURCE_BE_FLAG,

Line 2097: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2093: sysdate, -- last update date
2094: FND_GLOBAL.USER_ID, -- last updated by
2095: FND_GLOBAL.USER_ID -- last updated login
2096: );
2097: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2098: DESCRIPTION,
2099: NATURAL_BALANCE,
2100: REPORTING_TYPE,
2101: TOTAL_RESOURCE_BE_FLAG,

Line 2144: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2140: sysdate, -- last update date
2141: FND_GLOBAL.USER_ID, -- last updated by
2142: FND_GLOBAL.USER_ID -- last updated login
2143: );
2144: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2145: DESCRIPTION,
2146: NATURAL_BALANCE,
2147: REPORTING_TYPE,
2148: TOTAL_RESOURCE_BE_FLAG,

Line 2191: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2187: sysdate, -- last update date
2188: FND_GLOBAL.USER_ID, -- last updated by
2189: FND_GLOBAL.USER_ID -- last updated login
2190: );
2191: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2192: DESCRIPTION,
2193: NATURAL_BALANCE,
2194: REPORTING_TYPE,
2195: TOTAL_RESOURCE_BE_FLAG,

Line 2238: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2234: sysdate, -- last update date
2235: FND_GLOBAL.USER_ID, -- last updated by
2236: FND_GLOBAL.USER_ID -- last updated login
2237: );
2238: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2239: DESCRIPTION,
2240: NATURAL_BALANCE,
2241: REPORTING_TYPE,
2242: TOTAL_RESOURCE_BE_FLAG,

Line 2285: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2281: sysdate, -- last update date
2282: FND_GLOBAL.USER_ID, -- last updated by
2283: FND_GLOBAL.USER_ID -- last updated login
2284: );
2285: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2286: DESCRIPTION,
2287: NATURAL_BALANCE,
2288: REPORTING_TYPE,
2289: TOTAL_RESOURCE_BE_FLAG,

Line 2332: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2328: sysdate, -- last update date
2329: FND_GLOBAL.USER_ID, -- last updated by
2330: FND_GLOBAL.USER_ID -- last updated login
2331: );
2332: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2333: DESCRIPTION,
2334: NATURAL_BALANCE,
2335: REPORTING_TYPE,
2336: TOTAL_RESOURCE_BE_FLAG,

Line 2379: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2375: sysdate, -- last update date
2376: FND_GLOBAL.USER_ID, -- last updated by
2377: FND_GLOBAL.USER_ID -- last updated login
2378: );
2379: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2380: DESCRIPTION,
2381: NATURAL_BALANCE,
2382: REPORTING_TYPE,
2383: TOTAL_RESOURCE_BE_FLAG,

Line 2426: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2422: sysdate, -- last update date
2423: FND_GLOBAL.USER_ID, -- last updated by
2424: FND_GLOBAL.USER_ID -- last updated login
2425: );
2426: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2427: DESCRIPTION,
2428: NATURAL_BALANCE,
2429: REPORTING_TYPE,
2430: TOTAL_RESOURCE_BE_FLAG,

Line 2473: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2469: sysdate, -- last update date
2470: FND_GLOBAL.USER_ID, -- last updated by
2471: FND_GLOBAL.USER_ID -- last updated login
2472: );
2473: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2474: DESCRIPTION,
2475: NATURAL_BALANCE,
2476: REPORTING_TYPE,
2477: TOTAL_RESOURCE_BE_FLAG,

Line 2521: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2517: FND_GLOBAL.USER_ID, -- last updated by
2518: FND_GLOBAL.USER_ID -- last updated login
2519: );
2520:
2521: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2522: DESCRIPTION,
2523: NATURAL_BALANCE,
2524: REPORTING_TYPE,
2525: TOTAL_RESOURCE_BE_FLAG,

Line 2569: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2565: FND_GLOBAL.USER_ID, -- last updated by
2566: FND_GLOBAL.USER_ID -- last updated login
2567: );
2568:
2569: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2570: DESCRIPTION,
2571: NATURAL_BALANCE,
2572: REPORTING_TYPE,
2573: TOTAL_RESOURCE_BE_FLAG,

Line 2616: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2612: sysdate, -- last update date
2613: FND_GLOBAL.USER_ID, -- last updated by
2614: FND_GLOBAL.USER_ID -- last updated login
2615: );
2616: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2617: DESCRIPTION,
2618: NATURAL_BALANCE,
2619: REPORTING_TYPE,
2620: TOTAL_RESOURCE_BE_FLAG,

Line 2663: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2659: sysdate, -- last update date
2660: FND_GLOBAL.USER_ID, -- last updated by
2661: FND_GLOBAL.USER_ID -- last updated login
2662: );
2663: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2664: DESCRIPTION,
2665: NATURAL_BALANCE,
2666: REPORTING_TYPE,
2667: TOTAL_RESOURCE_BE_FLAG,

Line 2710: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2706: sysdate, -- last update date
2707: FND_GLOBAL.USER_ID, -- last updated by
2708: FND_GLOBAL.USER_ID -- last updated login
2709: );
2710: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2711: DESCRIPTION,
2712: NATURAL_BALANCE,
2713: REPORTING_TYPE,
2714: TOTAL_RESOURCE_BE_FLAG,

Line 2758: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2754: FND_GLOBAL.USER_ID, -- last updated by
2755: FND_GLOBAL.USER_ID -- last updated login
2756: );
2757:
2758: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2759: DESCRIPTION,
2760: NATURAL_BALANCE,
2761: REPORTING_TYPE,
2762: TOTAL_RESOURCE_BE_FLAG,

Line 2806: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2802: FND_GLOBAL.USER_ID, -- last updated by
2803: FND_GLOBAL.USER_ID -- last updated login
2804: );
2805:
2806: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2807: DESCRIPTION,
2808: NATURAL_BALANCE,
2809: REPORTING_TYPE,
2810: TOTAL_RESOURCE_BE_FLAG,

Line 2854: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2850: FND_GLOBAL.USER_ID, -- last updated by
2851: FND_GLOBAL.USER_ID -- last updated login
2852: );
2853:
2854: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2855: DESCRIPTION,
2856: NATURAL_BALANCE,
2857: REPORTING_TYPE,
2858: TOTAL_RESOURCE_BE_FLAG,

Line 2902: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2898: FND_GLOBAL.USER_ID, -- last updated by
2899: FND_GLOBAL.USER_ID -- last updated login
2900: );
2901:
2902: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2903: DESCRIPTION,
2904: NATURAL_BALANCE,
2905: REPORTING_TYPE,
2906: TOTAL_RESOURCE_BE_FLAG,

Line 2950: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2946: FND_GLOBAL.USER_ID, -- last updated by
2947: FND_GLOBAL.USER_ID -- last updated login
2948: );
2949:
2950: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2951: DESCRIPTION,
2952: NATURAL_BALANCE,
2953: REPORTING_TYPE,
2954: TOTAL_RESOURCE_BE_FLAG,

Line 2998: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

2994: FND_GLOBAL.USER_ID, -- last updated by
2995: FND_GLOBAL.USER_ID -- last updated login
2996: );
2997:
2998: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
2999: DESCRIPTION,
3000: NATURAL_BALANCE,
3001: REPORTING_TYPE,
3002: TOTAL_RESOURCE_BE_FLAG,

Line 3045: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3041: sysdate, -- last update date
3042: FND_GLOBAL.USER_ID, -- last updated by
3043: FND_GLOBAL.USER_ID -- last updated login
3044: );
3045: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3046: DESCRIPTION,
3047: NATURAL_BALANCE,
3048: REPORTING_TYPE,
3049: TOTAL_RESOURCE_BE_FLAG,

Line 3092: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3088: sysdate, -- last update date
3089: FND_GLOBAL.USER_ID, -- last updated by
3090: FND_GLOBAL.USER_ID -- last updated login
3091: );
3092: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3093: DESCRIPTION,
3094: NATURAL_BALANCE,
3095: REPORTING_TYPE,
3096: TOTAL_RESOURCE_BE_FLAG,

Line 3139: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3135: sysdate, -- last update date
3136: FND_GLOBAL.USER_ID, -- last updated by
3137: FND_GLOBAL.USER_ID -- last updated login
3138: );
3139: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3140: DESCRIPTION,
3141: NATURAL_BALANCE,
3142: REPORTING_TYPE,
3143: TOTAL_RESOURCE_BE_FLAG,

Line 3186: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3182: sysdate, -- last update date
3183: FND_GLOBAL.USER_ID, -- last updated by
3184: FND_GLOBAL.USER_ID -- last updated login
3185: );
3186: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3187: DESCRIPTION,
3188: NATURAL_BALANCE,
3189: REPORTING_TYPE,
3190: TOTAL_RESOURCE_BE_FLAG,

Line 3233: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3229: sysdate, -- last update date
3230: FND_GLOBAL.USER_ID, -- last updated by
3231: FND_GLOBAL.USER_ID -- last updated login
3232: );
3233: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3234: DESCRIPTION,
3235: NATURAL_BALANCE,
3236: REPORTING_TYPE,
3237: TOTAL_RESOURCE_BE_FLAG,

Line 3280: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3276: sysdate, -- last update date
3277: FND_GLOBAL.USER_ID, -- last updated by
3278: FND_GLOBAL.USER_ID -- last updated login
3279: );
3280: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3281: DESCRIPTION,
3282: NATURAL_BALANCE,
3283: REPORTING_TYPE,
3284: TOTAL_RESOURCE_BE_FLAG,

Line 3327: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3323: sysdate, -- last update date
3324: FND_GLOBAL.USER_ID, -- last updated by
3325: FND_GLOBAL.USER_ID -- last updated login
3326: );
3327: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3328: DESCRIPTION,
3329: NATURAL_BALANCE,
3330: REPORTING_TYPE,
3331: TOTAL_RESOURCE_BE_FLAG,

Line 3374: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3370: sysdate, -- last update date
3371: FND_GLOBAL.USER_ID, -- last updated by
3372: FND_GLOBAL.USER_ID -- last updated login
3373: );
3374: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3375: DESCRIPTION,
3376: NATURAL_BALANCE,
3377: REPORTING_TYPE,
3378: TOTAL_RESOURCE_BE_FLAG,

Line 3421: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3417: sysdate, -- last update date
3418: FND_GLOBAL.USER_ID, -- last updated by
3419: FND_GLOBAL.USER_ID -- last updated login
3420: );
3421: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3422: DESCRIPTION,
3423: NATURAL_BALANCE,
3424: REPORTING_TYPE,
3425: TOTAL_RESOURCE_BE_FLAG,

Line 3468: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3464: sysdate, -- last update date
3465: FND_GLOBAL.USER_ID, -- last updated by
3466: FND_GLOBAL.USER_ID -- last updated login
3467: );
3468: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3469: DESCRIPTION,
3470: NATURAL_BALANCE,
3471: REPORTING_TYPE,
3472: TOTAL_RESOURCE_BE_FLAG,

Line 3515: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3511: sysdate, -- last update date
3512: FND_GLOBAL.USER_ID, -- last updated by
3513: FND_GLOBAL.USER_ID -- last updated login
3514: );
3515: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3516: DESCRIPTION,
3517: NATURAL_BALANCE,
3518: REPORTING_TYPE,
3519: TOTAL_RESOURCE_BE_FLAG,

Line 3562: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3558: sysdate, -- last update date
3559: FND_GLOBAL.USER_ID, -- last updated by
3560: FND_GLOBAL.USER_ID -- last updated login
3561: );
3562: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3563: DESCRIPTION,
3564: NATURAL_BALANCE,
3565: REPORTING_TYPE,
3566: TOTAL_RESOURCE_BE_FLAG,

Line 3609: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3605: sysdate, -- last update date
3606: FND_GLOBAL.USER_ID, -- last updated by
3607: FND_GLOBAL.USER_ID -- last updated login
3608: );
3609: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3610: DESCRIPTION,
3611: NATURAL_BALANCE,
3612: REPORTING_TYPE,
3613: TOTAL_RESOURCE_BE_FLAG,

Line 3656: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3652: sysdate, -- last update date
3653: FND_GLOBAL.USER_ID, -- last updated by
3654: FND_GLOBAL.USER_ID -- last updated login
3655: );
3656: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3657: DESCRIPTION,
3658: NATURAL_BALANCE,
3659: REPORTING_TYPE,
3660: TOTAL_RESOURCE_BE_FLAG,

Line 3703: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3699: sysdate, -- last update date
3700: FND_GLOBAL.USER_ID, -- last updated by
3701: FND_GLOBAL.USER_ID -- last updated login
3702: );
3703: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3704: DESCRIPTION,
3705: NATURAL_BALANCE,
3706: REPORTING_TYPE,
3707: TOTAL_RESOURCE_BE_FLAG,

Line 3750: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3746: sysdate, -- last update date
3747: FND_GLOBAL.USER_ID, -- last updated by
3748: FND_GLOBAL.USER_ID -- last updated login
3749: );
3750: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3751: DESCRIPTION,
3752: NATURAL_BALANCE,
3753: REPORTING_TYPE,
3754: TOTAL_RESOURCE_BE_FLAG,

Line 3799: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3795: FND_GLOBAL.USER_ID -- last updated login
3796: );
3797:
3798:
3799: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3800: DESCRIPTION,
3801: NATURAL_BALANCE,
3802: REPORTING_TYPE,
3803: TOTAL_RESOURCE_BE_FLAG,

Line 3846: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3842: sysdate, -- last update date
3843: FND_GLOBAL.USER_ID, -- last updated by
3844: FND_GLOBAL.USER_ID -- last updated login
3845: );
3846: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3847: DESCRIPTION,
3848: NATURAL_BALANCE,
3849: REPORTING_TYPE,
3850: TOTAL_RESOURCE_BE_FLAG,

Line 3893: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3889: sysdate, -- last update date
3890: FND_GLOBAL.USER_ID, -- last updated by
3891: FND_GLOBAL.USER_ID -- last updated login
3892: );
3893: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3894: DESCRIPTION,
3895: NATURAL_BALANCE,
3896: REPORTING_TYPE,
3897: TOTAL_RESOURCE_BE_FLAG,

Line 3940: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3936: sysdate, -- last update date
3937: FND_GLOBAL.USER_ID, -- last updated by
3938: FND_GLOBAL.USER_ID -- last updated login
3939: );
3940: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3941: DESCRIPTION,
3942: NATURAL_BALANCE,
3943: REPORTING_TYPE,
3944: TOTAL_RESOURCE_BE_FLAG,

Line 3987: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

3983: sysdate, -- last update date
3984: FND_GLOBAL.USER_ID, -- last updated by
3985: FND_GLOBAL.USER_ID -- last updated login
3986: );
3987: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
3988: DESCRIPTION,
3989: NATURAL_BALANCE,
3990: REPORTING_TYPE,
3991: TOTAL_RESOURCE_BE_FLAG,

Line 4034: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4030: sysdate, -- last update date
4031: FND_GLOBAL.USER_ID, -- last updated by
4032: FND_GLOBAL.USER_ID -- last updated login
4033: );
4034: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4035: DESCRIPTION,
4036: NATURAL_BALANCE,
4037: REPORTING_TYPE,
4038: TOTAL_RESOURCE_BE_FLAG,

Line 4081: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4077: sysdate, -- last update date
4078: FND_GLOBAL.USER_ID, -- last updated by
4079: FND_GLOBAL.USER_ID -- last updated login
4080: );
4081: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4082: DESCRIPTION,
4083: NATURAL_BALANCE,
4084: REPORTING_TYPE,
4085: TOTAL_RESOURCE_BE_FLAG,

Line 4128: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4124: sysdate, -- last update date
4125: FND_GLOBAL.USER_ID, -- last updated by
4126: FND_GLOBAL.USER_ID -- last updated login
4127: );
4128: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4129: DESCRIPTION,
4130: NATURAL_BALANCE,
4131: REPORTING_TYPE,
4132: TOTAL_RESOURCE_BE_FLAG,

Line 4175: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4171: sysdate, -- last update date
4172: FND_GLOBAL.USER_ID, -- last updated by
4173: FND_GLOBAL.USER_ID -- last updated login
4174: );
4175: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4176: DESCRIPTION,
4177: NATURAL_BALANCE,
4178: REPORTING_TYPE,
4179: TOTAL_RESOURCE_BE_FLAG,

Line 4222: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4218: sysdate, -- last update date
4219: FND_GLOBAL.USER_ID, -- last updated by
4220: FND_GLOBAL.USER_ID -- last updated login
4221: );
4222: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4223: DESCRIPTION,
4224: NATURAL_BALANCE,
4225: REPORTING_TYPE,
4226: TOTAL_RESOURCE_BE_FLAG,

Line 4269: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4265: sysdate, -- last update date
4266: FND_GLOBAL.USER_ID, -- last updated by
4267: FND_GLOBAL.USER_ID -- last updated login
4268: );
4269: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4270: DESCRIPTION,
4271: NATURAL_BALANCE,
4272: REPORTING_TYPE,
4273: TOTAL_RESOURCE_BE_FLAG,

Line 4316: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4312: sysdate, -- last update date
4313: FND_GLOBAL.USER_ID, -- last updated by
4314: FND_GLOBAL.USER_ID -- last updated login
4315: );
4316: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4317: DESCRIPTION,
4318: NATURAL_BALANCE,
4319: REPORTING_TYPE,
4320: TOTAL_RESOURCE_BE_FLAG,

Line 4363: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4359: sysdate, -- last update date
4360: FND_GLOBAL.USER_ID, -- last updated by
4361: FND_GLOBAL.USER_ID -- last updated login
4362: );
4363: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4364: DESCRIPTION,
4365: NATURAL_BALANCE,
4366: REPORTING_TYPE,
4367: TOTAL_RESOURCE_BE_FLAG,

Line 4410: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4406: sysdate, -- last update date
4407: FND_GLOBAL.USER_ID, -- last updated by
4408: FND_GLOBAL.USER_ID -- last updated login
4409: );
4410: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4411: DESCRIPTION,
4412: NATURAL_BALANCE,
4413: REPORTING_TYPE,
4414: TOTAL_RESOURCE_BE_FLAG,

Line 4457: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4453: sysdate, -- last update date
4454: FND_GLOBAL.USER_ID, -- last updated by
4455: FND_GLOBAL.USER_ID -- last updated login
4456: );
4457: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4458: DESCRIPTION,
4459: NATURAL_BALANCE,
4460: REPORTING_TYPE,
4461: TOTAL_RESOURCE_BE_FLAG,

Line 4504: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4500: sysdate, -- last update date
4501: FND_GLOBAL.USER_ID, -- last updated by
4502: FND_GLOBAL.USER_ID -- last updated login
4503: );
4504: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4505: DESCRIPTION,
4506: NATURAL_BALANCE,
4507: REPORTING_TYPE,
4508: TOTAL_RESOURCE_BE_FLAG,

Line 4551: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4547: sysdate, -- last update date
4548: FND_GLOBAL.USER_ID, -- last updated by
4549: FND_GLOBAL.USER_ID -- last updated login
4550: );
4551: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4552: DESCRIPTION,
4553: NATURAL_BALANCE,
4554: REPORTING_TYPE,
4555: TOTAL_RESOURCE_BE_FLAG,

Line 4598: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4594: sysdate, -- last update date
4595: FND_GLOBAL.USER_ID, -- last updated by
4596: FND_GLOBAL.USER_ID -- last updated login
4597: );
4598: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4599: DESCRIPTION,
4600: NATURAL_BALANCE,
4601: REPORTING_TYPE,
4602: TOTAL_RESOURCE_BE_FLAG,

Line 4645: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4641: sysdate, -- last update date
4642: FND_GLOBAL.USER_ID, -- last updated by
4643: FND_GLOBAL.USER_ID -- last updated login
4644: );
4645: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4646: DESCRIPTION,
4647: NATURAL_BALANCE,
4648: REPORTING_TYPE,
4649: TOTAL_RESOURCE_BE_FLAG,

Line 4692: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4688: sysdate, -- last update date
4689: FND_GLOBAL.USER_ID, -- last updated by
4690: FND_GLOBAL.USER_ID -- last updated login
4691: );
4692: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4693: DESCRIPTION,
4694: NATURAL_BALANCE,
4695: REPORTING_TYPE,
4696: TOTAL_RESOURCE_BE_FLAG,

Line 4739: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4735: sysdate, -- last update date
4736: FND_GLOBAL.USER_ID, -- last updated by
4737: FND_GLOBAL.USER_ID -- last updated login
4738: );
4739: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4740: DESCRIPTION,
4741: NATURAL_BALANCE,
4742: REPORTING_TYPE,
4743: TOTAL_RESOURCE_BE_FLAG,

Line 4786: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4782: sysdate, -- last update date
4783: FND_GLOBAL.USER_ID, -- last updated by
4784: FND_GLOBAL.USER_ID -- last updated login
4785: );
4786: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4787: DESCRIPTION,
4788: NATURAL_BALANCE,
4789: REPORTING_TYPE,
4790: TOTAL_RESOURCE_BE_FLAG,

Line 4833: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4829: sysdate, -- last update date
4830: FND_GLOBAL.USER_ID, -- last updated by
4831: FND_GLOBAL.USER_ID -- last updated login
4832: );
4833: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4834: DESCRIPTION,
4835: NATURAL_BALANCE,
4836: REPORTING_TYPE,
4837: TOTAL_RESOURCE_BE_FLAG,

Line 4880: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4876: sysdate, -- last update date
4877: FND_GLOBAL.USER_ID, -- last updated by
4878: FND_GLOBAL.USER_ID -- last updated login
4879: );
4880: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4881: DESCRIPTION,
4882: NATURAL_BALANCE,
4883: REPORTING_TYPE,
4884: TOTAL_RESOURCE_BE_FLAG,

Line 4927: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4923: sysdate, -- last update date
4924: FND_GLOBAL.USER_ID, -- last updated by
4925: FND_GLOBAL.USER_ID -- last updated login
4926: );
4927: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4928: DESCRIPTION,
4929: NATURAL_BALANCE,
4930: REPORTING_TYPE,
4931: TOTAL_RESOURCE_BE_FLAG,

Line 4974: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

4970: sysdate, -- last update date
4971: FND_GLOBAL.USER_ID, -- last updated by
4972: FND_GLOBAL.USER_ID -- last updated login
4973: );
4974: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4975: DESCRIPTION,
4976: NATURAL_BALANCE,
4977: REPORTING_TYPE,
4978: TOTAL_RESOURCE_BE_FLAG,

Line 5021: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5017: sysdate, -- last update date
5018: FND_GLOBAL.USER_ID, -- last updated by
5019: FND_GLOBAL.USER_ID -- last updated login
5020: );
5021: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5022: DESCRIPTION,
5023: NATURAL_BALANCE,
5024: REPORTING_TYPE,
5025: TOTAL_RESOURCE_BE_FLAG,

Line 5068: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5064: sysdate, -- last update date
5065: FND_GLOBAL.USER_ID, -- last updated by
5066: FND_GLOBAL.USER_ID -- last updated login
5067: );
5068: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5069: DESCRIPTION,
5070: NATURAL_BALANCE,
5071: REPORTING_TYPE,
5072: TOTAL_RESOURCE_BE_FLAG,

Line 5115: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5111: sysdate, -- last update date
5112: FND_GLOBAL.USER_ID, -- last updated by
5113: FND_GLOBAL.USER_ID -- last updated login
5114: );
5115: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5116: DESCRIPTION,
5117: NATURAL_BALANCE,
5118: REPORTING_TYPE,
5119: TOTAL_RESOURCE_BE_FLAG,

Line 5162: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5158: sysdate, -- last update date
5159: FND_GLOBAL.USER_ID, -- last updated by
5160: FND_GLOBAL.USER_ID -- last updated login
5161: );
5162: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5163: DESCRIPTION,
5164: NATURAL_BALANCE,
5165: REPORTING_TYPE,
5166: TOTAL_RESOURCE_BE_FLAG,

Line 5209: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5205: sysdate, -- last update date
5206: FND_GLOBAL.USER_ID, -- last updated by
5207: FND_GLOBAL.USER_ID -- last updated login
5208: );
5209: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5210: DESCRIPTION,
5211: NATURAL_BALANCE,
5212: REPORTING_TYPE,
5213: TOTAL_RESOURCE_BE_FLAG,

Line 5256: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5252: sysdate, -- last update date
5253: FND_GLOBAL.USER_ID, -- last updated by
5254: FND_GLOBAL.USER_ID -- last updated login
5255: );
5256: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5257: DESCRIPTION,
5258: NATURAL_BALANCE,
5259: REPORTING_TYPE,
5260: TOTAL_RESOURCE_BE_FLAG,

Line 5303: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5299: sysdate, -- last update date
5300: FND_GLOBAL.USER_ID, -- last updated by
5301: FND_GLOBAL.USER_ID -- last updated login
5302: );
5303: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5304: DESCRIPTION,
5305: NATURAL_BALANCE,
5306: REPORTING_TYPE,
5307: TOTAL_RESOURCE_BE_FLAG,

Line 5350: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5346: sysdate, -- last update date
5347: FND_GLOBAL.USER_ID, -- last updated by
5348: FND_GLOBAL.USER_ID -- last updated login
5349: );
5350: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5351: DESCRIPTION,
5352: NATURAL_BALANCE,
5353: REPORTING_TYPE,
5354: TOTAL_RESOURCE_BE_FLAG,

Line 5397: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5393: sysdate, -- last update date
5394: FND_GLOBAL.USER_ID, -- last updated by
5395: FND_GLOBAL.USER_ID -- last updated login
5396: );
5397: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5398: DESCRIPTION,
5399: NATURAL_BALANCE,
5400: REPORTING_TYPE,
5401: TOTAL_RESOURCE_BE_FLAG,

Line 5444: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,

5440: sysdate, -- last update date
5441: FND_GLOBAL.USER_ID, -- last updated by
5442: FND_GLOBAL.USER_ID -- last updated login
5443: );
5444: INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5445: DESCRIPTION,
5446: NATURAL_BALANCE,
5447: REPORTING_TYPE,
5448: TOTAL_RESOURCE_BE_FLAG,