39: ' ', -- RT7 borrowing source
40: 'Investments Purchased at a Discount - Unrealized Discount', -- Transaction Type
41: 'O', -- RT7 authority type
42: sysdate, -- creation_date
43: FND_GLOBAL.USER_ID, -- created by
44: sysdate, -- last update date
45: FND_GLOBAL.USER_ID, -- last updated by
46: FND_GLOBAL.USER_ID -- last updated login
47: );
41: 'O', -- RT7 authority type
42: sysdate, -- creation_date
43: FND_GLOBAL.USER_ID, -- created by
44: sysdate, -- last update date
45: FND_GLOBAL.USER_ID, -- last updated by
46: FND_GLOBAL.USER_ID -- last updated login
47: );
48:
49: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
42: sysdate, -- creation_date
43: FND_GLOBAL.USER_ID, -- created by
44: sysdate, -- last update date
45: FND_GLOBAL.USER_ID, -- last updated by
46: FND_GLOBAL.USER_ID -- last updated login
47: );
48:
49: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
50: RT7_ACCOUNT_ID,
63: 'E', -- Begin/End flag
64: '1611', -- USSGL Account
65: 'N', -- Transaction Partner
66: sysdate, -- creation_date
67: FND_GLOBAL.USER_ID, -- created by
68: sysdate, -- last update date
69: FND_GLOBAL.USER_ID, -- last updated by
70: FND_GLOBAL.USER_ID -- last updated login
71: );
65: 'N', -- Transaction Partner
66: sysdate, -- creation_date
67: FND_GLOBAL.USER_ID, -- created by
68: sysdate, -- last update date
69: FND_GLOBAL.USER_ID, -- last updated by
70: FND_GLOBAL.USER_ID -- last updated login
71: );
72: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
73: RT7_ACCOUNT_ID,
66: sysdate, -- creation_date
67: FND_GLOBAL.USER_ID, -- created by
68: sysdate, -- last update date
69: FND_GLOBAL.USER_ID, -- last updated by
70: FND_GLOBAL.USER_ID -- last updated login
71: );
72: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
73: RT7_ACCOUNT_ID,
74: RT7_CODE_ID,
86: 'E', -- Begin/End flag
87: '1621', -- USSGL Account
88: 'N', -- Transaction Partner
89: sysdate, -- creation_date
90: FND_GLOBAL.USER_ID, -- created by
91: sysdate, -- last update date
92: FND_GLOBAL.USER_ID, -- last updated by
93: FND_GLOBAL.USER_ID -- last updated login
94: );
88: 'N', -- Transaction Partner
89: sysdate, -- creation_date
90: FND_GLOBAL.USER_ID, -- created by
91: sysdate, -- last update date
92: FND_GLOBAL.USER_ID, -- last updated by
93: FND_GLOBAL.USER_ID -- last updated login
94: );
95:
96: INSERT INTO FV_FACTS_RT7_CODES (SET_OF_BOOKS_ID,
89: sysdate, -- creation_date
90: FND_GLOBAL.USER_ID, -- created by
91: sysdate, -- last update date
92: FND_GLOBAL.USER_ID, -- last updated by
93: FND_GLOBAL.USER_ID -- last updated login
94: );
95:
96: INSERT INTO FV_FACTS_RT7_CODES (SET_OF_BOOKS_ID,
97: RT7_CODE_ID,
110: ' ', -- RT7 borrowing source
111: 'Funds Held Outside the Treasury - Imprest Funds', -- Transaction Type
112: 'O', -- RT7 authority type
113: sysdate, -- creation_date
114: FND_GLOBAL.USER_ID, -- created by
115: sysdate, -- last update date
116: FND_GLOBAL.USER_ID, -- last updated by
117: FND_GLOBAL.USER_ID -- last updated login
118: );
112: 'O', -- RT7 authority type
113: sysdate, -- creation_date
114: FND_GLOBAL.USER_ID, -- created by
115: sysdate, -- last update date
116: FND_GLOBAL.USER_ID, -- last updated by
117: FND_GLOBAL.USER_ID -- last updated login
118: );
119: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
120: RT7_ACCOUNT_ID,
113: sysdate, -- creation_date
114: FND_GLOBAL.USER_ID, -- created by
115: sysdate, -- last update date
116: FND_GLOBAL.USER_ID, -- last updated by
117: FND_GLOBAL.USER_ID -- last updated login
118: );
119: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
120: RT7_ACCOUNT_ID,
121: RT7_CODE_ID,
133: 'E', -- Begin/End flag
134: '1120', -- USSGL Account
135: 'N', -- Transaction Partner
136: sysdate, -- creation_date
137: FND_GLOBAL.USER_ID, -- created by
138: sysdate, -- last update date
139: FND_GLOBAL.USER_ID, -- last updated by
140: FND_GLOBAL.USER_ID -- last updated login
141: );
135: 'N', -- Transaction Partner
136: sysdate, -- creation_date
137: FND_GLOBAL.USER_ID, -- created by
138: sysdate, -- last update date
139: FND_GLOBAL.USER_ID, -- last updated by
140: FND_GLOBAL.USER_ID -- last updated login
141: );
142: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
143: RT7_ACCOUNT_ID,
136: sysdate, -- creation_date
137: FND_GLOBAL.USER_ID, -- created by
138: sysdate, -- last update date
139: FND_GLOBAL.USER_ID, -- last updated by
140: FND_GLOBAL.USER_ID -- last updated login
141: );
142: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
143: RT7_ACCOUNT_ID,
144: RT7_CODE_ID,
156: 'E', -- Begin/End flag
157: '1130', -- USSGL Account
158: 'N', -- Transaction Partner
159: sysdate, -- creation_date
160: FND_GLOBAL.USER_ID, -- created by
161: sysdate, -- last update date
162: FND_GLOBAL.USER_ID, -- last updated by
163: FND_GLOBAL.USER_ID -- last updated login
164: );
158: 'N', -- Transaction Partner
159: sysdate, -- creation_date
160: FND_GLOBAL.USER_ID, -- created by
161: sysdate, -- last update date
162: FND_GLOBAL.USER_ID, -- last updated by
163: FND_GLOBAL.USER_ID -- last updated login
164: );
165:
166:
159: sysdate, -- creation_date
160: FND_GLOBAL.USER_ID, -- created by
161: sysdate, -- last update date
162: FND_GLOBAL.USER_ID, -- last updated by
163: FND_GLOBAL.USER_ID -- last updated login
164: );
165:
166:
167: INSERT INTO FV_FACTS_RT7_CODES (SET_OF_BOOKS_ID,
181: ' ', -- RT7 borrowing source
182: 'Investments Purchased at a Discount - Unamortized Premium and Discount', -- Transaction Type
183: 'O', -- RT7 authority type
184: sysdate, -- creation_date
185: FND_GLOBAL.USER_ID, -- created by
186: sysdate, -- last update date
187: FND_GLOBAL.USER_ID, -- last updated by
188: FND_GLOBAL.USER_ID -- last updated login
189: );
183: 'O', -- RT7 authority type
184: sysdate, -- creation_date
185: FND_GLOBAL.USER_ID, -- created by
186: sysdate, -- last update date
187: FND_GLOBAL.USER_ID, -- last updated by
188: FND_GLOBAL.USER_ID -- last updated login
189: );
190: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
191: RT7_ACCOUNT_ID,
184: sysdate, -- creation_date
185: FND_GLOBAL.USER_ID, -- created by
186: sysdate, -- last update date
187: FND_GLOBAL.USER_ID, -- last updated by
188: FND_GLOBAL.USER_ID -- last updated login
189: );
190: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
191: RT7_ACCOUNT_ID,
192: RT7_CODE_ID,
204: 'E', -- Begin/End flag
205: '1611', -- USSGL Account
206: 'N', -- Transaction Partner
207: sysdate, -- creation_date
208: FND_GLOBAL.USER_ID, -- created by
209: sysdate, -- last update date
210: FND_GLOBAL.USER_ID, -- last updated by
211: FND_GLOBAL.USER_ID -- last updated login
212: );
206: 'N', -- Transaction Partner
207: sysdate, -- creation_date
208: FND_GLOBAL.USER_ID, -- created by
209: sysdate, -- last update date
210: FND_GLOBAL.USER_ID, -- last updated by
211: FND_GLOBAL.USER_ID -- last updated login
212: );
213: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
214: RT7_ACCOUNT_ID,
207: sysdate, -- creation_date
208: FND_GLOBAL.USER_ID, -- created by
209: sysdate, -- last update date
210: FND_GLOBAL.USER_ID, -- last updated by
211: FND_GLOBAL.USER_ID -- last updated login
212: );
213: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
214: RT7_ACCOUNT_ID,
215: RT7_CODE_ID,
227: 'E', -- Begin/End flag
228: '1612', -- USSGL Account
229: 'N', -- Transaction Partner
230: sysdate, -- creation_date
231: FND_GLOBAL.USER_ID, -- created by
232: sysdate, -- last update date
233: FND_GLOBAL.USER_ID, -- last updated by
234: FND_GLOBAL.USER_ID -- last updated login
235: );
229: 'N', -- Transaction Partner
230: sysdate, -- creation_date
231: FND_GLOBAL.USER_ID, -- created by
232: sysdate, -- last update date
233: FND_GLOBAL.USER_ID, -- last updated by
234: FND_GLOBAL.USER_ID -- last updated login
235: );
236: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
237: RT7_ACCOUNT_ID,
230: sysdate, -- creation_date
231: FND_GLOBAL.USER_ID, -- created by
232: sysdate, -- last update date
233: FND_GLOBAL.USER_ID, -- last updated by
234: FND_GLOBAL.USER_ID -- last updated login
235: );
236: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
237: RT7_ACCOUNT_ID,
238: RT7_CODE_ID,
250: 'E', -- Begin/End flag
251: '1613', -- USSGL Account
252: 'N', -- Transaction Partner
253: sysdate, -- creation_date
254: FND_GLOBAL.USER_ID, -- created by
255: sysdate, -- last update date
256: FND_GLOBAL.USER_ID, -- last updated by
257: FND_GLOBAL.USER_ID -- last updated login
258: );
252: 'N', -- Transaction Partner
253: sysdate, -- creation_date
254: FND_GLOBAL.USER_ID, -- created by
255: sysdate, -- last update date
256: FND_GLOBAL.USER_ID, -- last updated by
257: FND_GLOBAL.USER_ID -- last updated login
258: );
259:
260: INSERT INTO FV_FACTS_RT7_CODES (SET_OF_BOOKS_ID,
253: sysdate, -- creation_date
254: FND_GLOBAL.USER_ID, -- created by
255: sysdate, -- last update date
256: FND_GLOBAL.USER_ID, -- last updated by
257: FND_GLOBAL.USER_ID -- last updated login
258: );
259:
260: INSERT INTO FV_FACTS_RT7_CODES (SET_OF_BOOKS_ID,
261: RT7_CODE_ID,
274: ' ', -- RT7 borrowing source
275: 'Unfunded Contract Authority', -- Transaction Type
276: 'C', -- RT7 authority type
277: sysdate, -- creation_date
278: FND_GLOBAL.USER_ID, -- created by
279: sysdate, -- last update date
280: FND_GLOBAL.USER_ID, -- last updated by
281: FND_GLOBAL.USER_ID -- last updated login
282: );
276: 'C', -- RT7 authority type
277: sysdate, -- creation_date
278: FND_GLOBAL.USER_ID, -- created by
279: sysdate, -- last update date
280: FND_GLOBAL.USER_ID, -- last updated by
281: FND_GLOBAL.USER_ID -- last updated login
282: );
283: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
284: RT7_ACCOUNT_ID,
277: sysdate, -- creation_date
278: FND_GLOBAL.USER_ID, -- created by
279: sysdate, -- last update date
280: FND_GLOBAL.USER_ID, -- last updated by
281: FND_GLOBAL.USER_ID -- last updated login
282: );
283: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
284: RT7_ACCOUNT_ID,
285: RT7_CODE_ID,
297: 'E', -- Begin/End flag
298: '4032', -- USSGL Account
299: 'N', -- Transaction Partner
300: sysdate, -- creation_date
301: FND_GLOBAL.USER_ID, -- created by
302: sysdate, -- last update date
303: FND_GLOBAL.USER_ID, -- last updated by
304: FND_GLOBAL.USER_ID -- last updated login
305: );
299: 'N', -- Transaction Partner
300: sysdate, -- creation_date
301: FND_GLOBAL.USER_ID, -- created by
302: sysdate, -- last update date
303: FND_GLOBAL.USER_ID, -- last updated by
304: FND_GLOBAL.USER_ID -- last updated login
305: );
306:
307: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
300: sysdate, -- creation_date
301: FND_GLOBAL.USER_ID, -- created by
302: sysdate, -- last update date
303: FND_GLOBAL.USER_ID, -- last updated by
304: FND_GLOBAL.USER_ID -- last updated login
305: );
306:
307: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
308: RT7_ACCOUNT_ID,
321: 'E', -- Begin/End flag
322: '4034', -- USSGL Account
323: 'N', -- Transaction Partner
324: sysdate, -- creation_date
325: FND_GLOBAL.USER_ID, -- created by
326: sysdate, -- last update date
327: FND_GLOBAL.USER_ID, -- last updated by
328: FND_GLOBAL.USER_ID -- last updated login
329: );
323: 'N', -- Transaction Partner
324: sysdate, -- creation_date
325: FND_GLOBAL.USER_ID, -- created by
326: sysdate, -- last update date
327: FND_GLOBAL.USER_ID, -- last updated by
328: FND_GLOBAL.USER_ID -- last updated login
329: );
330:
331: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
324: sysdate, -- creation_date
325: FND_GLOBAL.USER_ID, -- created by
326: sysdate, -- last update date
327: FND_GLOBAL.USER_ID, -- last updated by
328: FND_GLOBAL.USER_ID -- last updated login
329: );
330:
331: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
332: RT7_ACCOUNT_ID,
345: 'E', -- Begin/End flag
346: '4131', -- USSGL Account
347: 'N', -- Transaction Partner
348: sysdate, -- creation_date
349: FND_GLOBAL.USER_ID, -- created by
350: sysdate, -- last update date
351: FND_GLOBAL.USER_ID, -- last updated by
352: FND_GLOBAL.USER_ID -- last updated login
353: );
347: 'N', -- Transaction Partner
348: sysdate, -- creation_date
349: FND_GLOBAL.USER_ID, -- created by
350: sysdate, -- last update date
351: FND_GLOBAL.USER_ID, -- last updated by
352: FND_GLOBAL.USER_ID -- last updated login
353: );
354:
355: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
348: sysdate, -- creation_date
349: FND_GLOBAL.USER_ID, -- created by
350: sysdate, -- last update date
351: FND_GLOBAL.USER_ID, -- last updated by
352: FND_GLOBAL.USER_ID -- last updated login
353: );
354:
355: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
356: RT7_ACCOUNT_ID,
369: 'E', -- Begin/End flag
370: '4132', -- USSGL Account
371: 'N', -- Transaction Partner
372: sysdate, -- creation_date
373: FND_GLOBAL.USER_ID, -- created by
374: sysdate, -- last update date
375: FND_GLOBAL.USER_ID, -- last updated by
376: FND_GLOBAL.USER_ID -- last updated login
377: );
371: 'N', -- Transaction Partner
372: sysdate, -- creation_date
373: FND_GLOBAL.USER_ID, -- created by
374: sysdate, -- last update date
375: FND_GLOBAL.USER_ID, -- last updated by
376: FND_GLOBAL.USER_ID -- last updated login
377: );
378:
379: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
372: sysdate, -- creation_date
373: FND_GLOBAL.USER_ID, -- created by
374: sysdate, -- last update date
375: FND_GLOBAL.USER_ID, -- last updated by
376: FND_GLOBAL.USER_ID -- last updated login
377: );
378:
379: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
380: RT7_ACCOUNT_ID,
393: 'E', -- Begin/End flag
394: '4133', -- USSGL Account
395: 'N', -- Transaction Partner
396: sysdate, -- creation_date
397: FND_GLOBAL.USER_ID, -- created by
398: sysdate, -- last update date
399: FND_GLOBAL.USER_ID, -- last updated by
400: FND_GLOBAL.USER_ID -- last updated login
401: );
395: 'N', -- Transaction Partner
396: sysdate, -- creation_date
397: FND_GLOBAL.USER_ID, -- created by
398: sysdate, -- last update date
399: FND_GLOBAL.USER_ID, -- last updated by
400: FND_GLOBAL.USER_ID -- last updated login
401: );
402:
403: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
396: sysdate, -- creation_date
397: FND_GLOBAL.USER_ID, -- created by
398: sysdate, -- last update date
399: FND_GLOBAL.USER_ID, -- last updated by
400: FND_GLOBAL.USER_ID -- last updated login
401: );
402:
403: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
404: RT7_ACCOUNT_ID,
417: 'E', -- Begin/End flag
418: '4135', -- USSGL Account
419: 'N', -- Transaction Partner
420: sysdate, -- creation_date
421: FND_GLOBAL.USER_ID, -- created by
422: sysdate, -- last update date
423: FND_GLOBAL.USER_ID, -- last updated by
424: FND_GLOBAL.USER_ID -- last updated login
425: );
419: 'N', -- Transaction Partner
420: sysdate, -- creation_date
421: FND_GLOBAL.USER_ID, -- created by
422: sysdate, -- last update date
423: FND_GLOBAL.USER_ID, -- last updated by
424: FND_GLOBAL.USER_ID -- last updated login
425: );
426:
427: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
420: sysdate, -- creation_date
421: FND_GLOBAL.USER_ID, -- created by
422: sysdate, -- last update date
423: FND_GLOBAL.USER_ID, -- last updated by
424: FND_GLOBAL.USER_ID -- last updated login
425: );
426:
427: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
428: RT7_ACCOUNT_ID,
441: 'E', -- Begin/End flag
442: '4138', -- USSGL Account
443: 'N', -- Transaction Partner
444: sysdate, -- creation_date
445: FND_GLOBAL.USER_ID, -- created by
446: sysdate, -- last update date
447: FND_GLOBAL.USER_ID, -- last updated by
448: FND_GLOBAL.USER_ID -- last updated login
449: );
443: 'N', -- Transaction Partner
444: sysdate, -- creation_date
445: FND_GLOBAL.USER_ID, -- created by
446: sysdate, -- last update date
447: FND_GLOBAL.USER_ID, -- last updated by
448: FND_GLOBAL.USER_ID -- last updated login
449: );
450:
451: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
444: sysdate, -- creation_date
445: FND_GLOBAL.USER_ID, -- created by
446: sysdate, -- last update date
447: FND_GLOBAL.USER_ID, -- last updated by
448: FND_GLOBAL.USER_ID -- last updated login
449: );
450:
451: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
452: RT7_ACCOUNT_ID,
465: 'B', -- Begin/End flag
466: '4139', -- USSGL Account
467: 'N', -- Transaction Partner
468: sysdate, -- creation_date
469: FND_GLOBAL.USER_ID, -- created by
470: sysdate, -- last update date
471: FND_GLOBAL.USER_ID, -- last updated by
472: FND_GLOBAL.USER_ID -- last updated login
473: );
467: 'N', -- Transaction Partner
468: sysdate, -- creation_date
469: FND_GLOBAL.USER_ID, -- created by
470: sysdate, -- last update date
471: FND_GLOBAL.USER_ID, -- last updated by
472: FND_GLOBAL.USER_ID -- last updated login
473: );
474:
475: INSERT INTO FV_FACTS_RT7_CODES (SET_OF_BOOKS_ID,
468: sysdate, -- creation_date
469: FND_GLOBAL.USER_ID, -- created by
470: sysdate, -- last update date
471: FND_GLOBAL.USER_ID, -- last updated by
472: FND_GLOBAL.USER_ID -- last updated login
473: );
474:
475: INSERT INTO FV_FACTS_RT7_CODES (SET_OF_BOOKS_ID,
476: RT7_CODE_ID,
489: 'T', -- RT7 borrowing source
490: 'Authority to Borrow from the Treasury', -- Transaction Type
491: 'B', -- RT7 authority type
492: sysdate, -- creation_date
493: FND_GLOBAL.USER_ID, -- created by
494: sysdate, -- last update date
495: FND_GLOBAL.USER_ID, -- last updated by
496: FND_GLOBAL.USER_ID -- last updated login
497: );
491: 'B', -- RT7 authority type
492: sysdate, -- creation_date
493: FND_GLOBAL.USER_ID, -- created by
494: sysdate, -- last update date
495: FND_GLOBAL.USER_ID, -- last updated by
496: FND_GLOBAL.USER_ID -- last updated login
497: );
498: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
499: RT7_ACCOUNT_ID,
492: sysdate, -- creation_date
493: FND_GLOBAL.USER_ID, -- created by
494: sysdate, -- last update date
495: FND_GLOBAL.USER_ID, -- last updated by
496: FND_GLOBAL.USER_ID -- last updated login
497: );
498: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
499: RT7_ACCOUNT_ID,
500: RT7_CODE_ID,
512: 'E', -- Begin/End flag
513: '4042', -- USSGL Account
514: 'N', -- Transaction Partner
515: sysdate, -- creation_date
516: FND_GLOBAL.USER_ID, -- created by
517: sysdate, -- last update date
518: FND_GLOBAL.USER_ID, -- last updated by
519: FND_GLOBAL.USER_ID -- last updated login
520: );
514: 'N', -- Transaction Partner
515: sysdate, -- creation_date
516: FND_GLOBAL.USER_ID, -- created by
517: sysdate, -- last update date
518: FND_GLOBAL.USER_ID, -- last updated by
519: FND_GLOBAL.USER_ID -- last updated login
520: );
521:
522: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
515: sysdate, -- creation_date
516: FND_GLOBAL.USER_ID, -- created by
517: sysdate, -- last update date
518: FND_GLOBAL.USER_ID, -- last updated by
519: FND_GLOBAL.USER_ID -- last updated login
520: );
521:
522: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
523: RT7_ACCOUNT_ID,
536: 'E', -- Begin/End flag
537: '4044', -- USSGL Account
538: 'N', -- Transaction Partner
539: sysdate, -- creation_date
540: FND_GLOBAL.USER_ID, -- created by
541: sysdate, -- last update date
542: FND_GLOBAL.USER_ID, -- last updated by
543: FND_GLOBAL.USER_ID -- last updated login
544: );
538: 'N', -- Transaction Partner
539: sysdate, -- creation_date
540: FND_GLOBAL.USER_ID, -- created by
541: sysdate, -- last update date
542: FND_GLOBAL.USER_ID, -- last updated by
543: FND_GLOBAL.USER_ID -- last updated login
544: );
545:
546: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
539: sysdate, -- creation_date
540: FND_GLOBAL.USER_ID, -- created by
541: sysdate, -- last update date
542: FND_GLOBAL.USER_ID, -- last updated by
543: FND_GLOBAL.USER_ID -- last updated login
544: );
545:
546: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
547: RT7_ACCOUNT_ID,
560: 'E', -- Begin/End flag
561: '4141', -- USSGL Account
562: 'N', -- Transaction Partner
563: sysdate, -- creation_date
564: FND_GLOBAL.USER_ID, -- created by
565: sysdate, -- last update date
566: FND_GLOBAL.USER_ID, -- last updated by
567: FND_GLOBAL.USER_ID -- last updated login
568: );
562: 'N', -- Transaction Partner
563: sysdate, -- creation_date
564: FND_GLOBAL.USER_ID, -- created by
565: sysdate, -- last update date
566: FND_GLOBAL.USER_ID, -- last updated by
567: FND_GLOBAL.USER_ID -- last updated login
568: );
569:
570: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
563: sysdate, -- creation_date
564: FND_GLOBAL.USER_ID, -- created by
565: sysdate, -- last update date
566: FND_GLOBAL.USER_ID, -- last updated by
567: FND_GLOBAL.USER_ID -- last updated login
568: );
569:
570: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
571: RT7_ACCOUNT_ID,
584: 'E', -- Begin/End flag
585: '4142', -- USSGL Account
586: 'N', -- Transaction Partner
587: sysdate, -- creation_date
588: FND_GLOBAL.USER_ID, -- created by
589: sysdate, -- last update date
590: FND_GLOBAL.USER_ID, -- last updated by
591: FND_GLOBAL.USER_ID -- last updated login
592: );
586: 'N', -- Transaction Partner
587: sysdate, -- creation_date
588: FND_GLOBAL.USER_ID, -- created by
589: sysdate, -- last update date
590: FND_GLOBAL.USER_ID, -- last updated by
591: FND_GLOBAL.USER_ID -- last updated login
592: );
593:
594: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
587: sysdate, -- creation_date
588: FND_GLOBAL.USER_ID, -- created by
589: sysdate, -- last update date
590: FND_GLOBAL.USER_ID, -- last updated by
591: FND_GLOBAL.USER_ID -- last updated login
592: );
593:
594: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
595: RT7_ACCOUNT_ID,
608: 'E', -- Begin/End flag
609: '4143', -- USSGL Account
610: 'N', -- Transaction Partner
611: sysdate, -- creation_date
612: FND_GLOBAL.USER_ID, -- created by
613: sysdate, -- last update date
614: FND_GLOBAL.USER_ID, -- last updated by
615: FND_GLOBAL.USER_ID -- last updated login
616: );
610: 'N', -- Transaction Partner
611: sysdate, -- creation_date
612: FND_GLOBAL.USER_ID, -- created by
613: sysdate, -- last update date
614: FND_GLOBAL.USER_ID, -- last updated by
615: FND_GLOBAL.USER_ID -- last updated login
616: );
617:
618: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
611: sysdate, -- creation_date
612: FND_GLOBAL.USER_ID, -- created by
613: sysdate, -- last update date
614: FND_GLOBAL.USER_ID, -- last updated by
615: FND_GLOBAL.USER_ID -- last updated login
616: );
617:
618: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
619: RT7_ACCOUNT_ID,
632: 'E', -- Begin/End flag
633: '4145', -- USSGL Account
634: 'N', -- Transaction Partner
635: sysdate, -- creation_date
636: FND_GLOBAL.USER_ID, -- created by
637: sysdate, -- last update date
638: FND_GLOBAL.USER_ID, -- last updated by
639: FND_GLOBAL.USER_ID -- last updated login
640: );
634: 'N', -- Transaction Partner
635: sysdate, -- creation_date
636: FND_GLOBAL.USER_ID, -- created by
637: sysdate, -- last update date
638: FND_GLOBAL.USER_ID, -- last updated by
639: FND_GLOBAL.USER_ID -- last updated login
640: );
641:
642: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
635: sysdate, -- creation_date
636: FND_GLOBAL.USER_ID, -- created by
637: sysdate, -- last update date
638: FND_GLOBAL.USER_ID, -- last updated by
639: FND_GLOBAL.USER_ID -- last updated login
640: );
641:
642: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
643: RT7_ACCOUNT_ID,
656: 'E', -- Begin/End flag
657: '4148', -- USSGL Account
658: 'N', -- Transaction Partner
659: sysdate, -- creation_date
660: FND_GLOBAL.USER_ID, -- created by
661: sysdate, -- last update date
662: FND_GLOBAL.USER_ID, -- last updated by
663: FND_GLOBAL.USER_ID -- last updated login
664: );
658: 'N', -- Transaction Partner
659: sysdate, -- creation_date
660: FND_GLOBAL.USER_ID, -- created by
661: sysdate, -- last update date
662: FND_GLOBAL.USER_ID, -- last updated by
663: FND_GLOBAL.USER_ID -- last updated login
664: );
665:
666: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
659: sysdate, -- creation_date
660: FND_GLOBAL.USER_ID, -- created by
661: sysdate, -- last update date
662: FND_GLOBAL.USER_ID, -- last updated by
663: FND_GLOBAL.USER_ID -- last updated login
664: );
665:
666: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
667: RT7_ACCOUNT_ID,
680: 'B', -- Begin/End flag
681: '4149', -- USSGL Account
682: 'N', -- Transaction Partner
683: sysdate, -- creation_date
684: FND_GLOBAL.USER_ID, -- created by
685: sysdate, -- last update date
686: FND_GLOBAL.USER_ID, -- last updated by
687: FND_GLOBAL.USER_ID -- last updated login
688: );
682: 'N', -- Transaction Partner
683: sysdate, -- creation_date
684: FND_GLOBAL.USER_ID, -- created by
685: sysdate, -- last update date
686: FND_GLOBAL.USER_ID, -- last updated by
687: FND_GLOBAL.USER_ID -- last updated login
688: );
689:
690: INSERT INTO FV_FACTS_RT7_CODES (SET_OF_BOOKS_ID,
683: sysdate, -- creation_date
684: FND_GLOBAL.USER_ID, -- created by
685: sysdate, -- last update date
686: FND_GLOBAL.USER_ID, -- last updated by
687: FND_GLOBAL.USER_ID -- last updated login
688: );
689:
690: INSERT INTO FV_FACTS_RT7_CODES (SET_OF_BOOKS_ID,
691: RT7_CODE_ID,
704: 'P', -- RT7 borrowing source
705: 'Authority to Borrow from the Public', -- Transaction Type
706: 'B', -- RT7 authority type
707: sysdate, -- creation_date
708: FND_GLOBAL.USER_ID, -- created by
709: sysdate, -- last update date
710: FND_GLOBAL.USER_ID, -- last updated by
711: FND_GLOBAL.USER_ID -- last updated login
712: );
706: 'B', -- RT7 authority type
707: sysdate, -- creation_date
708: FND_GLOBAL.USER_ID, -- created by
709: sysdate, -- last update date
710: FND_GLOBAL.USER_ID, -- last updated by
711: FND_GLOBAL.USER_ID -- last updated login
712: );
713: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
714: RT7_ACCOUNT_ID,
707: sysdate, -- creation_date
708: FND_GLOBAL.USER_ID, -- created by
709: sysdate, -- last update date
710: FND_GLOBAL.USER_ID, -- last updated by
711: FND_GLOBAL.USER_ID -- last updated login
712: );
713: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
714: RT7_ACCOUNT_ID,
715: RT7_CODE_ID,
727: 'E', -- Begin/End flag
728: '4042', -- USSGL Account
729: 'N', -- Transaction Partner
730: sysdate, -- creation_date
731: FND_GLOBAL.USER_ID, -- created by
732: sysdate, -- last update date
733: FND_GLOBAL.USER_ID, -- last updated by
734: FND_GLOBAL.USER_ID -- last updated login
735: );
729: 'N', -- Transaction Partner
730: sysdate, -- creation_date
731: FND_GLOBAL.USER_ID, -- created by
732: sysdate, -- last update date
733: FND_GLOBAL.USER_ID, -- last updated by
734: FND_GLOBAL.USER_ID -- last updated login
735: );
736:
737: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
730: sysdate, -- creation_date
731: FND_GLOBAL.USER_ID, -- created by
732: sysdate, -- last update date
733: FND_GLOBAL.USER_ID, -- last updated by
734: FND_GLOBAL.USER_ID -- last updated login
735: );
736:
737: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
738: RT7_ACCOUNT_ID,
751: 'E', -- Begin/End flag
752: '4044', -- USSGL Account
753: 'N', -- Transaction Partner
754: sysdate, -- creation_date
755: FND_GLOBAL.USER_ID, -- created by
756: sysdate, -- last update date
757: FND_GLOBAL.USER_ID, -- last updated by
758: FND_GLOBAL.USER_ID -- last updated login
759: );
753: 'N', -- Transaction Partner
754: sysdate, -- creation_date
755: FND_GLOBAL.USER_ID, -- created by
756: sysdate, -- last update date
757: FND_GLOBAL.USER_ID, -- last updated by
758: FND_GLOBAL.USER_ID -- last updated login
759: );
760:
761: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
754: sysdate, -- creation_date
755: FND_GLOBAL.USER_ID, -- created by
756: sysdate, -- last update date
757: FND_GLOBAL.USER_ID, -- last updated by
758: FND_GLOBAL.USER_ID -- last updated login
759: );
760:
761: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
762: RT7_ACCOUNT_ID,
775: 'E', -- Begin/End flag
776: '4141', -- USSGL Account
777: 'N', -- Transaction Partner
778: sysdate, -- creation_date
779: FND_GLOBAL.USER_ID, -- created by
780: sysdate, -- last update date
781: FND_GLOBAL.USER_ID, -- last updated by
782: FND_GLOBAL.USER_ID -- last updated login
783: );
777: 'N', -- Transaction Partner
778: sysdate, -- creation_date
779: FND_GLOBAL.USER_ID, -- created by
780: sysdate, -- last update date
781: FND_GLOBAL.USER_ID, -- last updated by
782: FND_GLOBAL.USER_ID -- last updated login
783: );
784:
785: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
778: sysdate, -- creation_date
779: FND_GLOBAL.USER_ID, -- created by
780: sysdate, -- last update date
781: FND_GLOBAL.USER_ID, -- last updated by
782: FND_GLOBAL.USER_ID -- last updated login
783: );
784:
785: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
786: RT7_ACCOUNT_ID,
799: 'E', -- Begin/End flag
800: '4142', -- USSGL Account
801: 'N', -- Transaction Partner
802: sysdate, -- creation_date
803: FND_GLOBAL.USER_ID, -- created by
804: sysdate, -- last update date
805: FND_GLOBAL.USER_ID, -- last updated by
806: FND_GLOBAL.USER_ID -- last updated login
807: );
801: 'N', -- Transaction Partner
802: sysdate, -- creation_date
803: FND_GLOBAL.USER_ID, -- created by
804: sysdate, -- last update date
805: FND_GLOBAL.USER_ID, -- last updated by
806: FND_GLOBAL.USER_ID -- last updated login
807: );
808:
809: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
802: sysdate, -- creation_date
803: FND_GLOBAL.USER_ID, -- created by
804: sysdate, -- last update date
805: FND_GLOBAL.USER_ID, -- last updated by
806: FND_GLOBAL.USER_ID -- last updated login
807: );
808:
809: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
810: RT7_ACCOUNT_ID,
823: 'E', -- Begin/End flag
824: '4143', -- USSGL Account
825: 'N', -- Transaction Partner
826: sysdate, -- creation_date
827: FND_GLOBAL.USER_ID, -- created by
828: sysdate, -- last update date
829: FND_GLOBAL.USER_ID, -- last updated by
830: FND_GLOBAL.USER_ID -- last updated login
831: );
825: 'N', -- Transaction Partner
826: sysdate, -- creation_date
827: FND_GLOBAL.USER_ID, -- created by
828: sysdate, -- last update date
829: FND_GLOBAL.USER_ID, -- last updated by
830: FND_GLOBAL.USER_ID -- last updated login
831: );
832:
833: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
826: sysdate, -- creation_date
827: FND_GLOBAL.USER_ID, -- created by
828: sysdate, -- last update date
829: FND_GLOBAL.USER_ID, -- last updated by
830: FND_GLOBAL.USER_ID -- last updated login
831: );
832:
833: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
834: RT7_ACCOUNT_ID,
847: 'E', -- Begin/End flag
848: '4145', -- USSGL Account
849: 'N', -- Transaction Partner
850: sysdate, -- creation_date
851: FND_GLOBAL.USER_ID, -- created by
852: sysdate, -- last update date
853: FND_GLOBAL.USER_ID, -- last updated by
854: FND_GLOBAL.USER_ID -- last updated login
855: );
849: 'N', -- Transaction Partner
850: sysdate, -- creation_date
851: FND_GLOBAL.USER_ID, -- created by
852: sysdate, -- last update date
853: FND_GLOBAL.USER_ID, -- last updated by
854: FND_GLOBAL.USER_ID -- last updated login
855: );
856:
857: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
850: sysdate, -- creation_date
851: FND_GLOBAL.USER_ID, -- created by
852: sysdate, -- last update date
853: FND_GLOBAL.USER_ID, -- last updated by
854: FND_GLOBAL.USER_ID -- last updated login
855: );
856:
857: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
858: RT7_ACCOUNT_ID,
871: 'E', -- Begin/End flag
872: '4148', -- USSGL Account
873: 'N', -- Transaction Partner
874: sysdate, -- creation_date
875: FND_GLOBAL.USER_ID, -- created by
876: sysdate, -- last update date
877: FND_GLOBAL.USER_ID, -- last updated by
878: FND_GLOBAL.USER_ID -- last updated login
879: );
873: 'N', -- Transaction Partner
874: sysdate, -- creation_date
875: FND_GLOBAL.USER_ID, -- created by
876: sysdate, -- last update date
877: FND_GLOBAL.USER_ID, -- last updated by
878: FND_GLOBAL.USER_ID -- last updated login
879: );
880:
881: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
874: sysdate, -- creation_date
875: FND_GLOBAL.USER_ID, -- created by
876: sysdate, -- last update date
877: FND_GLOBAL.USER_ID, -- last updated by
878: FND_GLOBAL.USER_ID -- last updated login
879: );
880:
881: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
882: RT7_ACCOUNT_ID,
895: 'B', -- Begin/End flag
896: '4149', -- USSGL Account
897: 'N', -- Transaction Partner
898: sysdate, -- creation_date
899: FND_GLOBAL.USER_ID, -- created by
900: sysdate, -- last update date
901: FND_GLOBAL.USER_ID, -- last updated by
902: FND_GLOBAL.USER_ID -- last updated login
903: );
897: 'N', -- Transaction Partner
898: sysdate, -- creation_date
899: FND_GLOBAL.USER_ID, -- created by
900: sysdate, -- last update date
901: FND_GLOBAL.USER_ID, -- last updated by
902: FND_GLOBAL.USER_ID -- last updated login
903: );
904:
905: INSERT INTO FV_FACTS_RT7_CODES (SET_OF_BOOKS_ID,
898: sysdate, -- creation_date
899: FND_GLOBAL.USER_ID, -- created by
900: sysdate, -- last update date
901: FND_GLOBAL.USER_ID, -- last updated by
902: FND_GLOBAL.USER_ID -- last updated login
903: );
904:
905: INSERT INTO FV_FACTS_RT7_CODES (SET_OF_BOOKS_ID,
906: RT7_CODE_ID,
919: ' ', -- RT7 borrowing source
920: 'Investments in Public Debt Securities', -- Transaction Type
921: 'O', -- RT7 authority type
922: sysdate, -- creation_date
923: FND_GLOBAL.USER_ID, -- created by
924: sysdate, -- last update date
925: FND_GLOBAL.USER_ID, -- last updated by
926: FND_GLOBAL.USER_ID -- last updated login
927: );
921: 'O', -- RT7 authority type
922: sysdate, -- creation_date
923: FND_GLOBAL.USER_ID, -- created by
924: sysdate, -- last update date
925: FND_GLOBAL.USER_ID, -- last updated by
926: FND_GLOBAL.USER_ID -- last updated login
927: );
928: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
929: RT7_ACCOUNT_ID,
922: sysdate, -- creation_date
923: FND_GLOBAL.USER_ID, -- created by
924: sysdate, -- last update date
925: FND_GLOBAL.USER_ID, -- last updated by
926: FND_GLOBAL.USER_ID -- last updated login
927: );
928: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
929: RT7_ACCOUNT_ID,
930: RT7_CODE_ID,
942: 'E', -- Begin/End flag
943: '1610', -- USSGL Account
944: 'N', -- Transaction Partner
945: sysdate, -- creation_date
946: FND_GLOBAL.USER_ID, -- created by
947: sysdate, -- last update date
948: FND_GLOBAL.USER_ID, -- last updated by
949: FND_GLOBAL.USER_ID -- last updated login
950: );
944: 'N', -- Transaction Partner
945: sysdate, -- creation_date
946: FND_GLOBAL.USER_ID, -- created by
947: sysdate, -- last update date
948: FND_GLOBAL.USER_ID, -- last updated by
949: FND_GLOBAL.USER_ID -- last updated login
950: );
951:
952: INSERT INTO FV_FACTS_RT7_CODES (SET_OF_BOOKS_ID,
945: sysdate, -- creation_date
946: FND_GLOBAL.USER_ID, -- created by
947: sysdate, -- last update date
948: FND_GLOBAL.USER_ID, -- last updated by
949: FND_GLOBAL.USER_ID -- last updated login
950: );
951:
952: INSERT INTO FV_FACTS_RT7_CODES (SET_OF_BOOKS_ID,
953: RT7_CODE_ID,
966: ' ', -- RT7 borrowing source
967: 'Investments in Agency Securities', -- Transaction Type
968: 'O', -- RT7 authority type
969: sysdate, -- creation_date
970: FND_GLOBAL.USER_ID, -- created by
971: sysdate, -- last update date
972: FND_GLOBAL.USER_ID, -- last updated by
973: FND_GLOBAL.USER_ID -- last updated login
974: );
968: 'O', -- RT7 authority type
969: sysdate, -- creation_date
970: FND_GLOBAL.USER_ID, -- created by
971: sysdate, -- last update date
972: FND_GLOBAL.USER_ID, -- last updated by
973: FND_GLOBAL.USER_ID -- last updated login
974: );
975:
976: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
969: sysdate, -- creation_date
970: FND_GLOBAL.USER_ID, -- created by
971: sysdate, -- last update date
972: FND_GLOBAL.USER_ID, -- last updated by
973: FND_GLOBAL.USER_ID -- last updated login
974: );
975:
976: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
977: RT7_ACCOUNT_ID,
990: 'E', -- Begin/End flag
991: '1620', -- USSGL Account
992: 'F', -- Transaction Partner
993: sysdate, -- creation_date
994: FND_GLOBAL.USER_ID, -- created by
995: sysdate, -- last update date
996: FND_GLOBAL.USER_ID, -- last updated by
997: FND_GLOBAL.USER_ID -- last updated login
998: );
992: 'F', -- Transaction Partner
993: sysdate, -- creation_date
994: FND_GLOBAL.USER_ID, -- created by
995: sysdate, -- last update date
996: FND_GLOBAL.USER_ID, -- last updated by
997: FND_GLOBAL.USER_ID -- last updated login
998: );
999:
1000: end if;
993: sysdate, -- creation_date
994: FND_GLOBAL.USER_ID, -- created by
995: sysdate, -- last update date
996: FND_GLOBAL.USER_ID, -- last updated by
997: FND_GLOBAL.USER_ID -- last updated login
998: );
999:
1000: end if;
1001: