[Home] [Help]
PACKAGE BODY: APPS.FVFCSGL1
Source
1 PAckage Body FVFCSGL1 as
2 /* $Header: FVFCUG1B.pls 115.11 2002/06/17 00:41:46 ksriniva ship $ */
3 Procedure Main (errbuf out varchar2,
4 retcode out varchar2) IS
5 v_count number;
6 v_sob number;
7 v_sob_name Varchar2(100);
8 begin
9 -- Verify that the table is not already seeded for an specific set_of_books
10 -- Removed, since US SGL Accounts doest not have set of books.
11
12 /* v_sob := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
13 v_sob_name := FND_PROFILE.VALUE('GL_SET_OF_BKS_NAME');*/
14
15 SELECT count(*)
16 INTO v_count
17 FROM fv_facts_ussgl_accounts;
18
19 IF v_count > 0
20 THEN
21 null;
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,
31 TOTAL_RESOURCE_DC_FLAG,
32 RESOURCE_STATUS_BE_FLAG,
33 RESOURCE_STATUS_DC_FLAG,
34 YE_ANTICIPATED_FLAG,
35 YE_RESOURCE_EQUITY_FLAG,
36 YE_RESOURCE_EQUITY_BE_FLAG,
37 FUND_BALANCE_ACCOUNT_FLAG,
38 YE_GENERAL_FLAG,
39 YE_NEG_RECEIVABLES_FLAG,
40 YE_NEG_PAYABLES_FLAG,
41 DISBURSEMENTS_FLAG,
42 COLLECTIONS_FLAG,
43 USSGL_ENABLED_FLAG,
44 CREATION_DATE,
45 CREATED_BY,
46 LAST_UPDATE_DATE,
47 LAST_UPDATED_BY,
48 LAST_UPDATE_LOGIN)
49 VALUES ('1010', -- ussgl account number
50 'Fund Balance With Treasury', -- description
51 'D', -- natural balance
52 '3', -- reporting type
53 ' ', -- total resource begin/end flag
54 ' ', -- total resource debit/credit flag
55 ' ', -- resource status begin//end flag
56 ' ', -- resource status debit/credit flag
57 'N', -- ye end anticipated flag
58 'R', -- ye resource/equity flag
59 'E', -- ye resource/equity begin/end flag
60 'Y', -- fund balance account flag
61 'N', -- ye general flag
62 'N', -- ye negative receivables flag
63 'N', -- ye negative payables flag
64 'N', -- disbursement flag
65 'N', -- collections flag
66 'Y', -- ussgl enabled flag
67 sysdate, -- creation_date
68 FND_GLOBAL.USER_ID, -- created by
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,
78 TOTAL_RESOURCE_DC_FLAG,
79 RESOURCE_STATUS_BE_FLAG,
80 RESOURCE_STATUS_DC_FLAG,
81 YE_ANTICIPATED_FLAG,
82 YE_RESOURCE_EQUITY_FLAG,
83 YE_RESOURCE_EQUITY_BE_FLAG,
84 FUND_BALANCE_ACCOUNT_FLAG,
85 YE_GENERAL_FLAG,
86 YE_NEG_RECEIVABLES_FLAG,
87 YE_NEG_PAYABLES_FLAG,
88 DISBURSEMENTS_FLAG,
89 COLLECTIONS_FLAG,
90 USSGL_ENABLED_FLAG,
91 CREATION_DATE,
92 CREATED_BY,
93 LAST_UPDATE_DATE,
94 LAST_UPDATED_BY,
95 LAST_UPDATE_LOGIN)
96 VALUES ('1110', -- ussgl account number
97 'Undeposited Collections', -- description
98 'D', -- natural balance
99 '1', -- reporting type
100 ' ', -- total resource begin/end flag
101 ' ', -- total resource debit/credit flag
102 ' ', -- resource status begin//end flag
103 ' ', -- resource status debit/credit flag
104 'N', -- ye end anticipated flag
105 ' ', -- ye resource/equity flag
106 ' ', -- ye resource/equity begin/end flag
107 'N', -- fund balance account flag
108 'N', -- ye general flag
109 'N', -- ye negative receivables flag
110 'N', -- ye negative payables flag
111 'N', -- disbursement flag
112 'N', -- collections flag
113 'Y', -- ussgl enabled flag
114 sysdate, -- creation_date
115 FND_GLOBAL.USER_ID, -- created by
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,
125 TOTAL_RESOURCE_DC_FLAG,
126 RESOURCE_STATUS_BE_FLAG,
127 RESOURCE_STATUS_DC_FLAG,
128 YE_ANTICIPATED_FLAG,
129 YE_RESOURCE_EQUITY_FLAG,
130 YE_RESOURCE_EQUITY_BE_FLAG,
131 FUND_BALANCE_ACCOUNT_FLAG,
132 YE_GENERAL_FLAG,
133 YE_NEG_RECEIVABLES_FLAG,
134 YE_NEG_PAYABLES_FLAG,
135 DISBURSEMENTS_FLAG,
136 COLLECTIONS_FLAG,
137 USSGL_ENABLED_FLAG,
138 CREATION_DATE,
139 CREATED_BY,
140 LAST_UPDATE_DATE,
141 LAST_UPDATED_BY,
142 LAST_UPDATE_LOGIN)
143 VALUES ('1120', -- ussgl account number
144 'Imprest Funds', -- description
145 'D', -- natural balance
146 '3', -- reporting type
147 ' ', -- total resource begin/end flag
148 ' ', -- total resource debit/credit flag
149 ' ', -- resource status begin//end flag
150 ' ', -- resource status debit/credit flag
151 'N', -- ye end anticipated flag
152 'R', -- ye resource/equity flag
153 'E', -- ye resource/equity begin/end flag
154 'N', -- fund balance account flag
155 'N', -- ye general flag
156 'N', -- ye negative receivables flag
157 'N', -- ye negative payables flag
158 'N', -- disbursement flag
159 'N', -- collections flag
160 'Y', -- ussgl enabled flag
161 sysdate, -- creation_date
162 FND_GLOBAL.USER_ID, -- created by
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,
172 TOTAL_RESOURCE_DC_FLAG,
173 RESOURCE_STATUS_BE_FLAG,
174 RESOURCE_STATUS_DC_FLAG,
175 YE_ANTICIPATED_FLAG,
176 YE_RESOURCE_EQUITY_FLAG,
177 YE_RESOURCE_EQUITY_BE_FLAG,
178 FUND_BALANCE_ACCOUNT_FLAG,
179 YE_GENERAL_FLAG,
180 YE_NEG_RECEIVABLES_FLAG,
181 YE_NEG_PAYABLES_FLAG,
182 DISBURSEMENTS_FLAG,
183 COLLECTIONS_FLAG,
184 USSGL_ENABLED_FLAG,
185 CREATION_DATE,
186 CREATED_BY,
187 LAST_UPDATE_DATE,
188 LAST_UPDATED_BY,
189 LAST_UPDATE_LOGIN)
190 VALUES ('1130', -- ussgl account number
191 'Funds Held by the Public', -- description
192 'D', -- natural balance
193 '3', -- reporting type
194 ' ', -- total resource begin/end flag
195 ' ', -- total resource debit/credit flag
196 ' ', -- resource status begin//end flag
197 ' ', -- resource status debit/credit flag
198 'N', -- ye end anticipated flag
199 'R', -- ye resource/equity flag
200 'E', -- ye resource/equity begin/end flag
201 'N', -- fund balance account flag
202 'N', -- ye general flag
203 'N', -- ye negative receivables flag
204 'N', -- ye negative payables flag
205 'N', -- disbursement flag
206 'N', -- collections flag
207 'Y', -- ussgl enabled flag
208 sysdate, -- creation_date
209 FND_GLOBAL.USER_ID, -- created by
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,
219 TOTAL_RESOURCE_DC_FLAG,
220 RESOURCE_STATUS_BE_FLAG,
221 RESOURCE_STATUS_DC_FLAG,
222 YE_ANTICIPATED_FLAG,
223 YE_RESOURCE_EQUITY_FLAG,
224 YE_RESOURCE_EQUITY_BE_FLAG,
225 FUND_BALANCE_ACCOUNT_FLAG,
226 YE_GENERAL_FLAG,
227 YE_NEG_RECEIVABLES_FLAG,
228 YE_NEG_PAYABLES_FLAG,
229 DISBURSEMENTS_FLAG,
230 COLLECTIONS_FLAG,
231 USSGL_ENABLED_FLAG,
232 CREATION_DATE,
233 CREATED_BY,
234 LAST_UPDATE_DATE,
235 LAST_UPDATED_BY,
236 LAST_UPDATE_LOGIN)
237 VALUES ('1190', -- ussgl account number
238 'Other Cash', -- description
239 'D', -- natural balance
240 '1', -- reporting type
241 ' ', -- total resource begin/end flag
242 ' ', -- total resource debit/credit flag
243 ' ', -- resource status begin//end flag
244 ' ', -- resource status debit/credit flag
245 'N', -- ye end anticipated flag
246 ' ', -- ye resource/equity flag
247 ' ', -- ye resource/equity begin/end flag
248 'N', -- fund balance account flag
249 'N', -- ye general flag
250 'N', -- ye negative receivables flag
251 'N', -- ye negative payables flag
252 'N', -- disbursement flag
253 'N', -- collections flag
254 'Y', -- ussgl enabled flag
255 sysdate, -- creation_date
256 FND_GLOBAL.USER_ID, -- created by
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,
266 TOTAL_RESOURCE_DC_FLAG,
267 RESOURCE_STATUS_BE_FLAG,
268 RESOURCE_STATUS_DC_FLAG,
269 YE_ANTICIPATED_FLAG,
270 YE_RESOURCE_EQUITY_FLAG,
271 YE_RESOURCE_EQUITY_BE_FLAG,
272 FUND_BALANCE_ACCOUNT_FLAG,
273 YE_GENERAL_FLAG,
274 YE_NEG_RECEIVABLES_FLAG,
275 YE_NEG_PAYABLES_FLAG,
276 DISBURSEMENTS_FLAG,
277 COLLECTIONS_FLAG,
278 USSGL_ENABLED_FLAG,
279 CREATION_DATE,
280 CREATED_BY,
281 LAST_UPDATE_DATE,
282 LAST_UPDATED_BY,
283 LAST_UPDATE_LOGIN)
284 VALUES ('1195', -- ussgl account number
285 'Other Monetary Assets', -- description
286 'D', -- natural balance
287 '3', -- reporting type
288 ' ', -- total resource begin/end flag
289 ' ', -- total resource debit/credit flag
290 ' ', -- resource status begin//end flag
291 ' ', -- resource status debit/credit flag
292 'N', -- ye end anticipated flag
293 'R', -- ye resource/equity flag
294 'E', -- ye resource/equity begin/end flag
295 'N', -- fund balance account flag
296 'N', -- ye general flag
297 'N', -- ye negative receivables flag
298 'N', -- ye negative payables flag
299 'N', -- disbursement flag
300 'N', -- collections flag
301 'Y', -- ussgl enabled flag
302 sysdate, -- creation_date
303 FND_GLOBAL.USER_ID, -- created by
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,
313 TOTAL_RESOURCE_DC_FLAG,
314 RESOURCE_STATUS_BE_FLAG,
315 RESOURCE_STATUS_DC_FLAG,
316 YE_ANTICIPATED_FLAG,
317 YE_RESOURCE_EQUITY_FLAG,
318 YE_RESOURCE_EQUITY_BE_FLAG,
319 FUND_BALANCE_ACCOUNT_FLAG,
320 YE_GENERAL_FLAG,
321 YE_NEG_RECEIVABLES_FLAG,
322 YE_NEG_PAYABLES_FLAG,
323 DISBURSEMENTS_FLAG,
324 COLLECTIONS_FLAG,
325 USSGL_ENABLED_FLAG,
326 CREATION_DATE,
327 CREATED_BY,
328 LAST_UPDATE_DATE,
329 LAST_UPDATED_BY,
330 LAST_UPDATE_LOGIN)
331 VALUES ('1200', -- ussgl account number
332 'Foreign Currency', -- description
333 'D', -- natural balance
334 '1', -- reporting type
335 ' ', -- total resource begin/end flag
336 ' ', -- total resource debit/credit flag
337 ' ', -- resource status begin//end flag
338 ' ', -- resource status debit/credit flag
339 'N', -- ye end anticipated flag
340 ' ', -- ye resource/equity flag
341 ' ', -- ye resource/equity begin/end flag
342 'N', -- fund balance account flag
343 'N', -- ye general flag
344 'N', -- ye negative receivables flag
345 'N', -- ye negative payables flag
346 'N', -- disbursement flag
347 'N', -- collections flag
348 'Y', -- ussgl enabled flag
349 sysdate, -- creation_date
350 FND_GLOBAL.USER_ID, -- created by
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,
360 TOTAL_RESOURCE_DC_FLAG,
361 RESOURCE_STATUS_BE_FLAG,
362 RESOURCE_STATUS_DC_FLAG,
363 YE_ANTICIPATED_FLAG,
364 YE_RESOURCE_EQUITY_FLAG,
365 YE_RESOURCE_EQUITY_BE_FLAG,
366 FUND_BALANCE_ACCOUNT_FLAG,
367 YE_GENERAL_FLAG,
368 YE_NEG_RECEIVABLES_FLAG,
369 YE_NEG_PAYABLES_FLAG,
370 DISBURSEMENTS_FLAG,
371 COLLECTIONS_FLAG,
372 USSGL_ENABLED_FLAG,
373 CREATION_DATE,
374 CREATED_BY,
375 LAST_UPDATE_DATE,
376 LAST_UPDATED_BY,
377 LAST_UPDATE_LOGIN)
378 VALUES ('1310', -- ussgl account number
379 'Accounts Receivable', -- description
380 'D', -- natural balance
381 '1', -- reporting type
382 ' ', -- total resource begin/end flag
383 ' ', -- total resource debit/credit flag
384 ' ', -- resource status begin//end flag
385 ' ', -- resource status debit/credit flag
386 'N', -- ye end anticipated flag
387 ' ', -- ye resource/equity flag
388 ' ', -- ye resource/equity begin/end flag
389 'N', -- fund balance account flag
390 'N', -- ye general flag
391 'N', -- ye negative receivables flag
392 'N', -- ye negative payables flag
393 'N', -- disbursement flag
394 'N', -- collections flag
395 'Y', -- ussgl enabled flag
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 INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
403 DESCRIPTION,
404 NATURAL_BALANCE,
405 REPORTING_TYPE,
406 TOTAL_RESOURCE_BE_FLAG,
407 TOTAL_RESOURCE_DC_FLAG,
408 RESOURCE_STATUS_BE_FLAG,
409 RESOURCE_STATUS_DC_FLAG,
410 YE_ANTICIPATED_FLAG,
411 YE_RESOURCE_EQUITY_FLAG,
412 YE_RESOURCE_EQUITY_BE_FLAG,
413 FUND_BALANCE_ACCOUNT_FLAG,
414 YE_GENERAL_FLAG,
415 YE_NEG_RECEIVABLES_FLAG,
416 YE_NEG_PAYABLES_FLAG,
417 DISBURSEMENTS_FLAG,
418 COLLECTIONS_FLAG,
419 USSGL_ENABLED_FLAG,
420 CREATION_DATE,
421 CREATED_BY,
422 LAST_UPDATE_DATE,
423 LAST_UPDATED_BY,
424 LAST_UPDATE_LOGIN)
425 VALUES ('1319', -- ussgl account number
426 'Allowance for Loss on Accounts Receivable', -- description
430 ' ', -- total resource debit/credit flag
427 'C', -- natural balance
428 '1', -- reporting type
429 ' ', -- total resource begin/end flag
431 ' ', -- resource status begin//end flag
432 ' ', -- resource status debit/credit flag
433 'N', -- ye end anticipated flag
434 ' ', -- ye resource/equity flag
435 ' ', -- ye resource/equity begin/end flag
436 'N', -- fund balance account flag
437 'N', -- ye general flag
438 'N', -- ye negative receivables flag
439 'N', -- ye negative payables flag
440 'N', -- disbursement flag
441 'N', -- collections flag
442 'Y', -- ussgl enabled flag
443 sysdate, -- creation_date
444 FND_GLOBAL.USER_ID, -- created by
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,
454 TOTAL_RESOURCE_DC_FLAG,
455 RESOURCE_STATUS_BE_FLAG,
456 RESOURCE_STATUS_DC_FLAG,
457 YE_ANTICIPATED_FLAG,
458 YE_RESOURCE_EQUITY_FLAG,
459 YE_RESOURCE_EQUITY_BE_FLAG,
460 FUND_BALANCE_ACCOUNT_FLAG,
461 YE_GENERAL_FLAG,
462 YE_NEG_RECEIVABLES_FLAG,
463 YE_NEG_PAYABLES_FLAG,
464 DISBURSEMENTS_FLAG,
465 COLLECTIONS_FLAG,
466 USSGL_ENABLED_FLAG,
467 CREATION_DATE,
468 CREATED_BY,
469 LAST_UPDATE_DATE,
470 LAST_UPDATED_BY,
471 LAST_UPDATE_LOGIN)
472 VALUES ('1320', -- ussgl account number
473 'Employment Benefit Contributions Receivable', -- description
474 'D', -- natural balance
475 '1', -- reporting type
476 ' ', -- total resource begin/end flag
477 ' ', -- total resource debit/credit flag
478 ' ', -- resource status begin//end flag
479 ' ', -- resource status debit/credit flag
480 'N', -- ye end anticipated flag
481 ' ', -- ye resource/equity flag
482 ' ', -- ye resource/equity begin/end flag
483 'N', -- fund balance account flag
484 'N', -- ye general flag
485 'N', -- ye negative receivables flag
486 'N', -- ye negative payables flag
487 'N', -- disbursement flag
488 'N', -- collections flag
489 'Y', -- ussgl enabled flag
490 sysdate, -- creation_date
491 FND_GLOBAL.USER_ID, -- created by
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,
501 TOTAL_RESOURCE_DC_FLAG,
502 RESOURCE_STATUS_BE_FLAG,
506 YE_RESOURCE_EQUITY_BE_FLAG,
503 RESOURCE_STATUS_DC_FLAG,
504 YE_ANTICIPATED_FLAG,
505 YE_RESOURCE_EQUITY_FLAG,
507 FUND_BALANCE_ACCOUNT_FLAG,
508 YE_GENERAL_FLAG,
509 YE_NEG_RECEIVABLES_FLAG,
510 YE_NEG_PAYABLES_FLAG,
511 DISBURSEMENTS_FLAG,
512 COLLECTIONS_FLAG,
513 USSGL_ENABLED_FLAG,
514 CREATION_DATE,
515 CREATED_BY,
516 LAST_UPDATE_DATE,
517 LAST_UPDATED_BY,
518 LAST_UPDATE_LOGIN)
519 VALUES ('1325', -- ussgl account number
520 'Taxes Receivable', -- description
521 'D', -- natural balance
522 '1', -- reporting type
523 ' ', -- total resource begin/end flag
524 ' ', -- total resource debit/credit flag
525 ' ', -- resource status begin//end flag
526 ' ', -- resource status debit/credit flag
527 'N', -- ye end anticipated flag
528 ' ', -- ye resource/equity flag
529 ' ', -- ye resource/equity begin/end flag
530 'N', -- fund balance account flag
531 'N', -- ye general flag
532 'N', -- ye negative receivables flag
533 'N', -- ye negative payables flag
534 'N', -- disbursement flag
535 'N', -- collections flag
536 'Y', -- ussgl enabled flag
537 sysdate, -- creation_date
538 FND_GLOBAL.USER_ID, -- created by
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,
548 TOTAL_RESOURCE_DC_FLAG,
549 RESOURCE_STATUS_BE_FLAG,
550 RESOURCE_STATUS_DC_FLAG,
551 YE_ANTICIPATED_FLAG,
552 YE_RESOURCE_EQUITY_FLAG,
553 YE_RESOURCE_EQUITY_BE_FLAG,
554 FUND_BALANCE_ACCOUNT_FLAG,
555 YE_GENERAL_FLAG,
556 YE_NEG_RECEIVABLES_FLAG,
557 YE_NEG_PAYABLES_FLAG,
558 DISBURSEMENTS_FLAG,
559 COLLECTIONS_FLAG,
560 USSGL_ENABLED_FLAG,
561 CREATION_DATE,
562 CREATED_BY,
563 LAST_UPDATE_DATE,
564 LAST_UPDATED_BY,
565 LAST_UPDATE_LOGIN)
566 VALUES ('1329', -- ussgl account number
567 'Allowance for Loss on Taxes Receivable', -- description
568 'C', -- natural balance
569 '1', -- reporting type
570 ' ', -- total resource begin/end flag
571 ' ', -- total resource debit/credit flag
572 ' ', -- resource status begin//end flag
573 ' ', -- resource status debit/credit flag
574 'N', -- ye end anticipated flag
575 ' ', -- ye resource/equity flag
576 ' ', -- ye resource/equity begin/end flag
577 'N', -- fund balance account flag
578 'N', -- ye general flag
579 'N', -- ye negative receivables flag
580 'N', -- ye negative payables flag
581 'N', -- disbursement flag
582 'N', -- collections flag
583 'Y', -- ussgl enabled flag
584 sysdate, -- creation_date
585 FND_GLOBAL.USER_ID, -- created by
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,
595 TOTAL_RESOURCE_DC_FLAG,
596 RESOURCE_STATUS_BE_FLAG,
597 RESOURCE_STATUS_DC_FLAG,
598 YE_ANTICIPATED_FLAG,
599 YE_RESOURCE_EQUITY_FLAG,
600 YE_RESOURCE_EQUITY_BE_FLAG,
601 FUND_BALANCE_ACCOUNT_FLAG,
602 YE_GENERAL_FLAG,
603 YE_NEG_RECEIVABLES_FLAG,
604 YE_NEG_PAYABLES_FLAG,
605 DISBURSEMENTS_FLAG,
606 COLLECTIONS_FLAG,
607 USSGL_ENABLED_FLAG,
608 CREATION_DATE,
609 CREATED_BY,
610 LAST_UPDATE_DATE,
611 LAST_UPDATED_BY,
612 LAST_UPDATE_LOGIN)
613 VALUES ('1330', -- ussgl account number
614 'Receivable for Transfers of Currently Invested Balances', -- description
615 'D', -- natural balance
616 '1', -- reporting type
617 ' ', -- total resource begin/end flag
618 ' ', -- total resource debit/credit flag
619 ' ', -- resource status begin//end flag
620 ' ', -- resource status debit/credit flag
621 'N', -- ye end anticipated flag
622 'R', -- ye resource/equity flag
623 'E', -- ye resource/equity begin/end flag
624 'N', -- fund balance account flag
625 'N', -- ye general flag
626 'Y', -- ye negative receivables flag
627 'N', -- ye negative payables flag
628 'N', -- disbursement flag
629 'N', -- collections flag
630 'Y', -- ussgl enabled flag
631 sysdate, -- creation_date
632 FND_GLOBAL.USER_ID, -- created by
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,
642 TOTAL_RESOURCE_DC_FLAG,
643 RESOURCE_STATUS_BE_FLAG,
644 RESOURCE_STATUS_DC_FLAG,
645 YE_ANTICIPATED_FLAG,
649 YE_GENERAL_FLAG,
646 YE_RESOURCE_EQUITY_FLAG,
647 YE_RESOURCE_EQUITY_BE_FLAG,
648 FUND_BALANCE_ACCOUNT_FLAG,
650 YE_NEG_RECEIVABLES_FLAG,
651 YE_NEG_PAYABLES_FLAG,
652 DISBURSEMENTS_FLAG,
653 COLLECTIONS_FLAG,
654 USSGL_ENABLED_FLAG,
655 CREATION_DATE,
656 CREATED_BY,
657 LAST_UPDATE_DATE,
658 LAST_UPDATED_BY,
659 LAST_UPDATE_LOGIN)
660 VALUES ('1335', -- ussgl account number
661 'Expenditure Transfers Receivable', -- description
662 'D', -- natural balance
663 '1', -- reporting type
664 ' ', -- total resource begin/end flag
665 ' ', -- total resource debit/credit flag
666 ' ', -- resource status begin//end flag
667 ' ', -- resource status debit/credit flag
668 'N', -- ye end anticipated flag
669 ' ', -- ye resource/equity flag
670 ' ', -- ye resource/equity begin/end flag
671 'N', -- fund balance account flag
672 'N', -- ye general flag
673 'N', -- ye negative receivables flag
674 'N', -- ye negative payables flag
675 'N', -- disbursement flag
676 'N', -- collections flag
677 'Y', -- ussgl enabled flag
678 sysdate, -- creation_date
679 FND_GLOBAL.USER_ID, -- created by
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,
689 TOTAL_RESOURCE_DC_FLAG,
690 RESOURCE_STATUS_BE_FLAG,
691 RESOURCE_STATUS_DC_FLAG,
692 YE_ANTICIPATED_FLAG,
693 YE_RESOURCE_EQUITY_FLAG,
694 YE_RESOURCE_EQUITY_BE_FLAG,
695 FUND_BALANCE_ACCOUNT_FLAG,
696 YE_GENERAL_FLAG,
697 YE_NEG_RECEIVABLES_FLAG,
698 YE_NEG_PAYABLES_FLAG,
699 DISBURSEMENTS_FLAG,
700 COLLECTIONS_FLAG,
701 USSGL_ENABLED_FLAG,
702 CREATION_DATE,
703 CREATED_BY,
704 LAST_UPDATE_DATE,
705 LAST_UPDATED_BY,
706 LAST_UPDATE_LOGIN)
707 VALUES ('1340', -- ussgl account number
708 'Interest Receivable', -- description
709 'D', -- natural balance
710 '1', -- reporting type
711 ' ', -- total resource begin/end flag
712 ' ', -- total resource debit/credit flag
713 ' ', -- resource status begin//end flag
714 ' ', -- resource status debit/credit flag
715 'N', -- ye end anticipated flag
716 ' ', -- ye resource/equity flag
717 ' ', -- ye resource/equity begin/end flag
718 'N', -- fund balance account flag
719 'N', -- ye general flag
720 'N', -- ye negative receivables flag
721 'N', -- ye negative payables flag
722 'N', -- disbursement flag
723 'N', -- collections flag
724 'Y', -- ussgl enabled flag
725 sysdate, -- creation_date
726 FND_GLOBAL.USER_ID, -- created by
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,
736 TOTAL_RESOURCE_DC_FLAG,
737 RESOURCE_STATUS_BE_FLAG,
738 RESOURCE_STATUS_DC_FLAG,
739 YE_ANTICIPATED_FLAG,
740 YE_RESOURCE_EQUITY_FLAG,
741 YE_RESOURCE_EQUITY_BE_FLAG,
742 FUND_BALANCE_ACCOUNT_FLAG,
743 YE_GENERAL_FLAG,
744 YE_NEG_RECEIVABLES_FLAG,
745 YE_NEG_PAYABLES_FLAG,
746 DISBURSEMENTS_FLAG,
747 COLLECTIONS_FLAG,
748 USSGL_ENABLED_FLAG,
749 CREATION_DATE,
750 CREATED_BY,
751 LAST_UPDATE_DATE,
752 LAST_UPDATED_BY,
753 LAST_UPDATE_LOGIN)
754 VALUES ('1349', -- ussgl account number
755 'Allowance for Loss on Interest Receivable', -- description
756 'C', -- natural balance
757 '1', -- reporting type
758 ' ', -- total resource begin/end flag
759 ' ', -- total resource debit/credit flag
760 ' ', -- resource status begin//end flag
761 ' ', -- resource status debit/credit flag
762 'N', -- ye end anticipated flag
763 ' ', -- ye resource/equity flag
764 ' ', -- ye resource/equity begin/end flag
765 'N', -- fund balance account flag
766 'N', -- ye general flag
767 'N', -- ye negative receivables flag
768 'N', -- ye negative payables flag
769 'N', -- disbursement flag
770 'N', -- collections flag
771 'Y', -- ussgl enabled flag
772 sysdate, -- creation_date
773 FND_GLOBAL.USER_ID, -- created by
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,
783 TOTAL_RESOURCE_DC_FLAG,
784 RESOURCE_STATUS_BE_FLAG,
785 RESOURCE_STATUS_DC_FLAG,
786 YE_ANTICIPATED_FLAG,
787 YE_RESOURCE_EQUITY_FLAG,
788 YE_RESOURCE_EQUITY_BE_FLAG,
792 YE_NEG_PAYABLES_FLAG,
789 FUND_BALANCE_ACCOUNT_FLAG,
790 YE_GENERAL_FLAG,
791 YE_NEG_RECEIVABLES_FLAG,
793 DISBURSEMENTS_FLAG,
794 COLLECTIONS_FLAG,
795 USSGL_ENABLED_FLAG,
796 CREATION_DATE,
797 CREATED_BY,
798 LAST_UPDATE_DATE,
799 LAST_UPDATED_BY,
800 LAST_UPDATE_LOGIN)
801 VALUES ('1350', -- ussgl account number
802 'Loans Receivable', -- description
803 'D', -- natural balance
804 '1', -- reporting type
805 ' ', -- total resource begin/end flag
806 ' ', -- total resource debit/credit flag
807 ' ', -- resource status begin//end flag
808 ' ', -- resource status debit/credit flag
809 'N', -- ye end anticipated flag
810 ' ', -- ye resource/equity flag
811 ' ', -- ye resource/equity begin/end flag
812 'N', -- fund balance account flag
813 'N', -- ye general flag
814 'N', -- ye negative receivables flag
815 'N', -- ye negative payables flag
816 'N', -- disbursement flag
817 'N', -- collections flag
818 'Y', -- ussgl enabled flag
819 sysdate, -- creation_date
820 FND_GLOBAL.USER_ID, -- created by
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,
830 TOTAL_RESOURCE_DC_FLAG,
831 RESOURCE_STATUS_BE_FLAG,
832 RESOURCE_STATUS_DC_FLAG,
833 YE_ANTICIPATED_FLAG,
834 YE_RESOURCE_EQUITY_FLAG,
835 YE_RESOURCE_EQUITY_BE_FLAG,
836 FUND_BALANCE_ACCOUNT_FLAG,
837 YE_GENERAL_FLAG,
838 YE_NEG_RECEIVABLES_FLAG,
839 YE_NEG_PAYABLES_FLAG,
840 DISBURSEMENTS_FLAG,
841 COLLECTIONS_FLAG,
842 USSGL_ENABLED_FLAG,
843 CREATION_DATE,
844 CREATED_BY,
845 LAST_UPDATE_DATE,
846 LAST_UPDATED_BY,
847 LAST_UPDATE_LOGIN)
848 VALUES ('1359', -- ussgl account number
849 'Allowance for Loss on Loans Receivable', -- description
850 'C', -- natural balance
851 '1', -- reporting type
852 ' ', -- total resource begin/end flag
853 ' ', -- total resource debit/credit flag
854 ' ', -- resource status begin//end flag
855 ' ', -- resource status debit/credit flag
856 'N', -- ye end anticipated flag
857 ' ', -- ye resource/equity flag
858 ' ', -- ye resource/equity begin/end flag
859 'N', -- fund balance account flag
860 'N', -- ye general flag
861 'N', -- ye negative receivables flag
862 'N', -- ye negative payables flag
863 'N', -- disbursement flag
864 'N', -- collections flag
865 'Y', -- ussgl enabled flag
866 sysdate, -- creation_date
867 FND_GLOBAL.USER_ID, -- created by
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,
877 TOTAL_RESOURCE_DC_FLAG,
878 RESOURCE_STATUS_BE_FLAG,
879 RESOURCE_STATUS_DC_FLAG,
880 YE_ANTICIPATED_FLAG,
881 YE_RESOURCE_EQUITY_FLAG,
882 YE_RESOURCE_EQUITY_BE_FLAG,
883 FUND_BALANCE_ACCOUNT_FLAG,
884 YE_GENERAL_FLAG,
885 YE_NEG_RECEIVABLES_FLAG,
886 YE_NEG_PAYABLES_FLAG,
887 DISBURSEMENTS_FLAG,
888 COLLECTIONS_FLAG,
889 USSGL_ENABLED_FLAG,
890 CREATION_DATE,
891 CREATED_BY,
892 LAST_UPDATE_DATE,
893 LAST_UPDATED_BY,
894 LAST_UPDATE_LOGIN)
895 VALUES ('1360', -- ussgl account number
896 'Penalties, Fines and Administrative Fees Receivable', -- description
897 'D', -- natural balance
898 '1', -- reporting type
899 ' ', -- total resource begin/end flag
900 ' ', -- total resource debit/credit flag
901 ' ', -- resource status begin//end flag
902 ' ', -- resource status debit/credit flag
903 'N', -- ye end anticipated flag
904 ' ', -- ye resource/equity flag
905 ' ', -- ye resource/equity begin/end flag
906 'N', -- fund balance account flag
907 'N', -- ye general flag
908 'N', -- ye negative receivables flag
909 'N', -- ye negative payables flag
910 'N', -- disbursement flag
911 'N', -- collections flag
912 'Y', -- ussgl enabled flag
913 sysdate, -- creation_date
914 FND_GLOBAL.USER_ID, -- created by
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,
924 TOTAL_RESOURCE_DC_FLAG,
925 RESOURCE_STATUS_BE_FLAG,
926 RESOURCE_STATUS_DC_FLAG,
927 YE_ANTICIPATED_FLAG,
928 YE_RESOURCE_EQUITY_FLAG,
929 YE_RESOURCE_EQUITY_BE_FLAG,
930 FUND_BALANCE_ACCOUNT_FLAG,
934 DISBURSEMENTS_FLAG,
931 YE_GENERAL_FLAG,
932 YE_NEG_RECEIVABLES_FLAG,
933 YE_NEG_PAYABLES_FLAG,
935 COLLECTIONS_FLAG,
936 USSGL_ENABLED_FLAG,
937 CREATION_DATE,
938 CREATED_BY,
939 LAST_UPDATE_DATE,
940 LAST_UPDATED_BY,
941 LAST_UPDATE_LOGIN)
942 VALUES ('1369', -- ussgl account number
943 'Allowance for Loss on Penalties, Fines and Administrative Fees Receivable', -- description
944 'C', -- natural balance
945 '1', -- reporting type
946 ' ', -- total resource begin/end flag
947 ' ', -- total resource debit/credit flag
948 ' ', -- resource status begin//end flag
949 ' ', -- resource status debit/credit flag
950 'N', -- ye end anticipated flag
951 ' ', -- ye resource/equity flag
952 ' ', -- ye resource/equity begin/end flag
953 'N', -- fund balance account flag
954 'N', -- ye general flag
955 'N', -- ye negative receivables flag
956 'N', -- ye negative payables flag
957 'N', -- disbursement flag
958 'N', -- collections flag
959 'Y', -- ussgl enabled flag
960 sysdate, -- creation_date
961 FND_GLOBAL.USER_ID, -- created by
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,
971 TOTAL_RESOURCE_DC_FLAG,
972 RESOURCE_STATUS_BE_FLAG,
973 RESOURCE_STATUS_DC_FLAG,
974 YE_ANTICIPATED_FLAG,
975 YE_RESOURCE_EQUITY_FLAG,
976 YE_RESOURCE_EQUITY_BE_FLAG,
977 FUND_BALANCE_ACCOUNT_FLAG,
978 YE_GENERAL_FLAG,
979 YE_NEG_RECEIVABLES_FLAG,
980 YE_NEG_PAYABLES_FLAG,
981 DISBURSEMENTS_FLAG,
982 COLLECTIONS_FLAG,
983 USSGL_ENABLED_FLAG,
984 CREATION_DATE,
985 CREATED_BY,
986 LAST_UPDATE_DATE,
987 LAST_UPDATED_BY,
988 LAST_UPDATE_LOGIN)
989 VALUES ('1399', -- ussgl account number
990 'Allowance for Subsidy', -- description
991 'C', -- natural balance
992 '1', -- reporting type
993 ' ', -- total resource begin/end flag
994 ' ', -- total resource debit/credit flag
995 ' ', -- resource status begin//end flag
996 ' ', -- resource status debit/credit flag
997 'N', -- ye end anticipated flag
998 ' ', -- ye resource/equity flag
999 ' ', -- ye resource/equity begin/end flag
1000 'N', -- fund balance account flag
1001 'N', -- ye general flag
1002 'N', -- ye negative receivables flag
1003 'N', -- ye negative payables flag
1004 'N', -- disbursement flag
1005 'N', -- collections flag
1006 'Y', -- ussgl enabled flag
1007 sysdate, -- creation_date
1008 FND_GLOBAL.USER_ID, -- created by
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,
1018 TOTAL_RESOURCE_DC_FLAG,
1019 RESOURCE_STATUS_BE_FLAG,
1020 RESOURCE_STATUS_DC_FLAG,
1021 YE_ANTICIPATED_FLAG,
1022 YE_RESOURCE_EQUITY_FLAG,
1023 YE_RESOURCE_EQUITY_BE_FLAG,
1024 FUND_BALANCE_ACCOUNT_FLAG,
1025 YE_GENERAL_FLAG,
1026 YE_NEG_RECEIVABLES_FLAG,
1027 YE_NEG_PAYABLES_FLAG,
1028 DISBURSEMENTS_FLAG,
1029 COLLECTIONS_FLAG,
1030 USSGL_ENABLED_FLAG,
1031 CREATION_DATE,
1032 CREATED_BY,
1033 LAST_UPDATE_DATE,
1034 LAST_UPDATED_BY,
1035 LAST_UPDATE_LOGIN)
1036 VALUES ('1410', -- ussgl account number
1037 'Advances to Others', -- description
1038 'D', -- natural balance
1039 '1', -- reporting type
1040 ' ', -- total resource begin/end flag
1041 ' ', -- total resource debit/credit flag
1042 ' ', -- resource status begin//end flag
1043 ' ', -- resource status debit/credit flag
1044 'N', -- ye end anticipated flag
1045 ' ', -- ye resource/equity flag
1046 ' ', -- ye resource/equity begin/end flag
1047 'N', -- fund balance account flag
1048 'N', -- ye general flag
1049 'N', -- ye negative receivables flag
1050 'N', -- ye negative payables flag
1051 'N', -- disbursement flag
1052 'N', -- collections flag
1053 'Y', -- ussgl enabled flag
1054 sysdate, -- creation_date
1055 FND_GLOBAL.USER_ID, -- created by
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,
1065 TOTAL_RESOURCE_DC_FLAG,
1066 RESOURCE_STATUS_BE_FLAG,
1067 RESOURCE_STATUS_DC_FLAG,
1068 YE_ANTICIPATED_FLAG,
1069 YE_RESOURCE_EQUITY_FLAG,
1070 YE_RESOURCE_EQUITY_BE_FLAG,
1071 FUND_BALANCE_ACCOUNT_FLAG,
1072 YE_GENERAL_FLAG,
1073 YE_NEG_RECEIVABLES_FLAG,
1077 USSGL_ENABLED_FLAG,
1074 YE_NEG_PAYABLES_FLAG,
1075 DISBURSEMENTS_FLAG,
1076 COLLECTIONS_FLAG,
1078 CREATION_DATE,
1079 CREATED_BY,
1080 LAST_UPDATE_DATE,
1081 LAST_UPDATED_BY,
1082 LAST_UPDATE_LOGIN)
1083 VALUES ('1450', -- ussgl account number
1084 'Prepayments', -- description
1085 'D', -- natural balance
1086 '1', -- reporting type
1087 ' ', -- total resource begin/end flag
1088 ' ', -- total resource debit/credit flag
1089 ' ', -- resource status begin//end flag
1090 ' ', -- resource status debit/credit flag
1091 'N', -- ye end anticipated flag
1092 ' ', -- ye resource/equity flag
1093 ' ', -- ye resource/equity begin/end flag
1094 'N', -- fund balance account flag
1095 'N', -- ye general flag
1096 'N', -- ye negative receivables flag
1097 'N', -- ye negative payables flag
1098 'N', -- disbursement flag
1099 'N', -- collections flag
1100 'Y', -- ussgl enabled flag
1101 sysdate, -- creation_date
1102 FND_GLOBAL.USER_ID, -- created by
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,
1112 TOTAL_RESOURCE_DC_FLAG,
1113 RESOURCE_STATUS_BE_FLAG,
1114 RESOURCE_STATUS_DC_FLAG,
1115 YE_ANTICIPATED_FLAG,
1116 YE_RESOURCE_EQUITY_FLAG,
1117 YE_RESOURCE_EQUITY_BE_FLAG,
1118 FUND_BALANCE_ACCOUNT_FLAG,
1119 YE_GENERAL_FLAG,
1120 YE_NEG_RECEIVABLES_FLAG,
1121 YE_NEG_PAYABLES_FLAG,
1122 DISBURSEMENTS_FLAG,
1123 COLLECTIONS_FLAG,
1124 USSGL_ENABLED_FLAG,
1125 CREATION_DATE,
1126 CREATED_BY,
1127 LAST_UPDATE_DATE,
1128 LAST_UPDATED_BY,
1129 LAST_UPDATE_LOGIN)
1130 VALUES ('1511', -- ussgl account number
1131 'Operating Materials and Supplies Held for Use', -- description
1132 'D', -- natural balance
1133 '1', -- reporting type
1134 ' ', -- total resource begin/end flag
1135 ' ', -- total resource debit/credit flag
1136 ' ', -- resource status begin//end flag
1137 ' ', -- resource status debit/credit flag
1138 'N', -- ye end anticipated flag
1139 ' ', -- ye resource/equity flag
1140 ' ', -- ye resource/equity begin/end flag
1141 'N', -- fund balance account flag
1142 'N', -- ye general flag
1143 'N', -- ye negative receivables flag
1144 'N', -- ye negative payables flag
1145 'N', -- disbursement flag
1146 'N', -- collections flag
1147 'Y', -- ussgl enabled flag
1148 sysdate, -- creation_date
1149 FND_GLOBAL.USER_ID, -- created by
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,
1159 TOTAL_RESOURCE_DC_FLAG,
1160 RESOURCE_STATUS_BE_FLAG,
1161 RESOURCE_STATUS_DC_FLAG,
1162 YE_ANTICIPATED_FLAG,
1163 YE_RESOURCE_EQUITY_FLAG,
1164 YE_RESOURCE_EQUITY_BE_FLAG,
1165 FUND_BALANCE_ACCOUNT_FLAG,
1166 YE_GENERAL_FLAG,
1167 YE_NEG_RECEIVABLES_FLAG,
1168 YE_NEG_PAYABLES_FLAG,
1169 DISBURSEMENTS_FLAG,
1170 COLLECTIONS_FLAG,
1171 USSGL_ENABLED_FLAG,
1172 CREATION_DATE,
1173 CREATED_BY,
1174 LAST_UPDATE_DATE,
1175 LAST_UPDATED_BY,
1176 LAST_UPDATE_LOGIN)
1177 VALUES ('1512', -- ussgl account number
1178 'Operating Materials and Supplies Held in Reserve for Future Use', -- description
1179 'D', -- natural balance
1180 '1', -- reporting type
1181 ' ', -- total resource begin/end flag
1182 ' ', -- total resource debit/credit flag
1183 ' ', -- resource status begin//end flag
1184 ' ', -- resource status debit/credit flag
1185 'N', -- ye end anticipated flag
1186 ' ', -- ye resource/equity flag
1187 ' ', -- ye resource/equity begin/end flag
1188 'N', -- fund balance account flag
1189 'N', -- ye general flag
1190 'N', -- ye negative receivables flag
1191 'N', -- ye negative payables flag
1192 'N', -- disbursement flag
1193 'N', -- collections flag
1194 'Y', -- ussgl enabled flag
1195 sysdate, -- creation_date
1196 FND_GLOBAL.USER_ID, -- created by
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,
1206 TOTAL_RESOURCE_DC_FLAG,
1207 RESOURCE_STATUS_BE_FLAG,
1208 RESOURCE_STATUS_DC_FLAG,
1209 YE_ANTICIPATED_FLAG,
1210 YE_RESOURCE_EQUITY_FLAG,
1211 YE_RESOURCE_EQUITY_BE_FLAG,
1212 FUND_BALANCE_ACCOUNT_FLAG,
1213 YE_GENERAL_FLAG,
1214 YE_NEG_RECEIVABLES_FLAG,
1215 YE_NEG_PAYABLES_FLAG,
1216 DISBURSEMENTS_FLAG,
1220 CREATED_BY,
1217 COLLECTIONS_FLAG,
1218 USSGL_ENABLED_FLAG,
1219 CREATION_DATE,
1221 LAST_UPDATE_DATE,
1222 LAST_UPDATED_BY,
1223 LAST_UPDATE_LOGIN)
1224 VALUES ('1513', -- ussgl account number
1225 'Operating Materials and Supplies - Excess, Unserviceable and Obsolete', -- description
1226 'D', -- natural balance
1227 '1', -- reporting type
1228 ' ', -- total resource begin/end flag
1229 ' ', -- total resource debit/credit flag
1230 ' ', -- resource status begin//end flag
1231 ' ', -- resource status debit/credit flag
1232 'N', -- ye end anticipated flag
1233 ' ', -- ye resource/equity flag
1234 ' ', -- ye resource/equity begin/end flag
1235 'N', -- fund balance account flag
1236 'N', -- ye general flag
1237 'N', -- ye negative receivables flag
1238 'N', -- ye negative payables flag
1239 'N', -- disbursement flag
1240 'N', -- collections flag
1241 'Y', -- ussgl enabled flag
1242 sysdate, -- creation_date
1243 FND_GLOBAL.USER_ID, -- created by
1244 sysdate, -- last update date
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,
1254 TOTAL_RESOURCE_DC_FLAG,
1255 RESOURCE_STATUS_BE_FLAG,
1256 RESOURCE_STATUS_DC_FLAG,
1257 YE_ANTICIPATED_FLAG,
1258 YE_RESOURCE_EQUITY_FLAG,
1259 YE_RESOURCE_EQUITY_BE_FLAG,
1260 FUND_BALANCE_ACCOUNT_FLAG,
1261 YE_GENERAL_FLAG,
1262 YE_NEG_RECEIVABLES_FLAG,
1263 YE_NEG_PAYABLES_FLAG,
1264 DISBURSEMENTS_FLAG,
1265 COLLECTIONS_FLAG,
1266 USSGL_ENABLED_FLAG,
1267 CREATION_DATE,
1268 CREATED_BY,
1269 LAST_UPDATE_DATE,
1270 LAST_UPDATED_BY,
1271 LAST_UPDATE_LOGIN)
1272 VALUES ('1514', -- ussgl account number
1273 'Operating Materials and Supplies Held for Repair', -- description
1274 'D', -- natural balance
1275 '1', -- reporting type
1276 ' ', -- total resource begin/end flag
1277 ' ', -- total resource debit/credit flag
1278 ' ', -- resource status begin//end flag
1279 ' ', -- resource status debit/credit flag
1280 'N', -- ye end anticipated flag
1281 ' ', -- ye resource/equity flag
1282 ' ', -- ye resource/equity begin/end flag
1283 'N', -- fund balance account flag
1284 'N', -- ye general flag
1285 'N', -- ye negative receivables flag
1286 'N', -- ye negative payables flag
1287 'N', -- disbursement flag
1288 'N', -- collections flag
1289 'Y', -- ussgl enabled flag
1290 sysdate, -- creation_date
1291 FND_GLOBAL.USER_ID, -- created by
1292 sysdate, -- last update date
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,
1302 TOTAL_RESOURCE_DC_FLAG,
1303 RESOURCE_STATUS_BE_FLAG,
1304 RESOURCE_STATUS_DC_FLAG,
1305 YE_ANTICIPATED_FLAG,
1306 YE_RESOURCE_EQUITY_FLAG,
1307 YE_RESOURCE_EQUITY_BE_FLAG,
1308 FUND_BALANCE_ACCOUNT_FLAG,
1309 YE_GENERAL_FLAG,
1310 YE_NEG_RECEIVABLES_FLAG,
1311 YE_NEG_PAYABLES_FLAG,
1312 DISBURSEMENTS_FLAG,
1313 COLLECTIONS_FLAG,
1314 USSGL_ENABLED_FLAG,
1315 CREATION_DATE,
1316 CREATED_BY,
1317 LAST_UPDATE_DATE,
1318 LAST_UPDATED_BY,
1319 LAST_UPDATE_LOGIN)
1320 VALUES ('1519', -- ussgl account number
1321 'Operating Materials and Supplies - Allowance', -- description
1322 'C', -- natural balance
1323 '1', -- reporting type
1324 ' ', -- total resource begin/end flag
1325 ' ', -- total resource debit/credit flag
1326 ' ', -- resource status begin//end flag
1327 ' ', -- resource status debit/credit flag
1328 'N', -- ye end anticipated flag
1329 ' ', -- ye resource/equity flag
1330 ' ', -- ye resource/equity begin/end flag
1331 'N', -- fund balance account flag
1332 'N', -- ye general flag
1333 'N', -- ye negative receivables flag
1334 'N', -- ye negative payables flag
1335 'N', -- disbursement flag
1336 'N', -- collections flag
1337 'Y', -- ussgl enabled flag
1338 sysdate, -- creation_date
1339 FND_GLOBAL.USER_ID, -- created by
1340 sysdate, -- last update date
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,
1350 TOTAL_RESOURCE_DC_FLAG,
1351 RESOURCE_STATUS_BE_FLAG,
1352 RESOURCE_STATUS_DC_FLAG,
1353 YE_ANTICIPATED_FLAG,
1354 YE_RESOURCE_EQUITY_FLAG,
1355 YE_RESOURCE_EQUITY_BE_FLAG,
1356 FUND_BALANCE_ACCOUNT_FLAG,
1357 YE_GENERAL_FLAG,
1358 YE_NEG_RECEIVABLES_FLAG,
1359 YE_NEG_PAYABLES_FLAG,
1363 CREATION_DATE,
1360 DISBURSEMENTS_FLAG,
1361 COLLECTIONS_FLAG,
1362 USSGL_ENABLED_FLAG,
1364 CREATED_BY,
1365 LAST_UPDATE_DATE,
1366 LAST_UPDATED_BY,
1367 LAST_UPDATE_LOGIN)
1368 VALUES ('1521', -- ussgl account number
1369 'Inventory Purchased for Resale', -- description
1370 'D', -- natural balance
1371 '1', -- reporting type
1372 ' ', -- total resource begin/end flag
1373 ' ', -- total resource debit/credit flag
1374 ' ', -- resource status begin//end flag
1375 ' ', -- resource status debit/credit flag
1376 'N', -- ye end anticipated flag
1377 ' ', -- ye resource/equity flag
1378 ' ', -- ye resource/equity begin/end flag
1379 'N', -- fund balance account flag
1380 'N', -- ye general flag
1381 'N', -- ye negative receivables flag
1382 'N', -- ye negative payables flag
1383 'N', -- disbursement flag
1384 'N', -- collections flag
1385 'Y', -- ussgl enabled flag
1386 sysdate, -- creation_date
1387 FND_GLOBAL.USER_ID, -- created by
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,
1397 TOTAL_RESOURCE_DC_FLAG,
1398 RESOURCE_STATUS_BE_FLAG,
1399 RESOURCE_STATUS_DC_FLAG,
1400 YE_ANTICIPATED_FLAG,
1401 YE_RESOURCE_EQUITY_FLAG,
1402 YE_RESOURCE_EQUITY_BE_FLAG,
1403 FUND_BALANCE_ACCOUNT_FLAG,
1404 YE_GENERAL_FLAG,
1405 YE_NEG_RECEIVABLES_FLAG,
1406 YE_NEG_PAYABLES_FLAG,
1407 DISBURSEMENTS_FLAG,
1408 COLLECTIONS_FLAG,
1409 USSGL_ENABLED_FLAG,
1410 CREATION_DATE,
1411 CREATED_BY,
1412 LAST_UPDATE_DATE,
1413 LAST_UPDATED_BY,
1414 LAST_UPDATE_LOGIN)
1415 VALUES ('1522', -- ussgl account number
1416 'Inventory Held in Reserve fo Future Sale', -- description
1417 'D', -- natural balance
1418 '1', -- reporting type
1419 ' ', -- total resource begin/end flag
1420 ' ', -- total resource debit/credit flag
1421 ' ', -- resource status begin//end flag
1422 ' ', -- resource status debit/credit flag
1423 'N', -- ye end anticipated flag
1424 ' ', -- ye resource/equity flag
1425 ' ', -- ye resource/equity begin/end flag
1426 'N', -- fund balance account flag
1427 'N', -- ye general flag
1428 'N', -- ye negative receivables flag
1429 'N', -- ye negative payables flag
1430 'N', -- disbursement flag
1431 'N', -- collections flag
1432 'Y', -- ussgl enabled flag
1433 sysdate, -- creation_date
1434 FND_GLOBAL.USER_ID, -- created by
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,
1444 TOTAL_RESOURCE_DC_FLAG,
1445 RESOURCE_STATUS_BE_FLAG,
1446 RESOURCE_STATUS_DC_FLAG,
1447 YE_ANTICIPATED_FLAG,
1448 YE_RESOURCE_EQUITY_FLAG,
1449 YE_RESOURCE_EQUITY_BE_FLAG,
1450 FUND_BALANCE_ACCOUNT_FLAG,
1451 YE_GENERAL_FLAG,
1452 YE_NEG_RECEIVABLES_FLAG,
1453 YE_NEG_PAYABLES_FLAG,
1454 DISBURSEMENTS_FLAG,
1455 COLLECTIONS_FLAG,
1456 USSGL_ENABLED_FLAG,
1457 CREATION_DATE,
1458 CREATED_BY,
1459 LAST_UPDATE_DATE,
1460 LAST_UPDATED_BY,
1461 LAST_UPDATE_LOGIN)
1462 VALUES ('1523', -- ussgl account number
1463 'Inventory Held for Repair', -- description
1464 'D', -- natural balance
1465 '1', -- reporting type
1466 ' ', -- total resource begin/end flag
1467 ' ', -- total resource debit/credit flag
1468 ' ', -- resource status begin//end flag
1469 ' ', -- resource status debit/credit flag
1470 'N', -- ye end anticipated flag
1471 ' ', -- ye resource/equity flag
1472 ' ', -- ye resource/equity begin/end flag
1473 'N', -- fund balance account flag
1474 'N', -- ye general flag
1475 'N', -- ye negative receivables flag
1476 'N', -- ye negative payables flag
1477 'N', -- disbursement flag
1478 'N', -- collections flag
1479 'Y', -- ussgl enabled flag
1480 sysdate, -- creation_date
1481 FND_GLOBAL.USER_ID, -- created by
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,
1491 TOTAL_RESOURCE_DC_FLAG,
1492 RESOURCE_STATUS_BE_FLAG,
1493 RESOURCE_STATUS_DC_FLAG,
1494 YE_ANTICIPATED_FLAG,
1495 YE_RESOURCE_EQUITY_FLAG,
1496 YE_RESOURCE_EQUITY_BE_FLAG,
1497 FUND_BALANCE_ACCOUNT_FLAG,
1498 YE_GENERAL_FLAG,
1499 YE_NEG_RECEIVABLES_FLAG,
1500 YE_NEG_PAYABLES_FLAG,
1501 DISBURSEMENTS_FLAG,
1502 COLLECTIONS_FLAG,
1506 LAST_UPDATE_DATE,
1503 USSGL_ENABLED_FLAG,
1504 CREATION_DATE,
1505 CREATED_BY,
1507 LAST_UPDATED_BY,
1508 LAST_UPDATE_LOGIN)
1509 VALUES ('1524', -- ussgl account number
1510 'Inventory - Excess, Obsolete and Unserviceable', -- description
1511 'D', -- natural balance
1512 '1', -- reporting type
1513 ' ', -- total resource begin/end flag
1514 ' ', -- total resource debit/credit flag
1515 ' ', -- resource status begin//end flag
1516 ' ', -- resource status debit/credit flag
1517 'N', -- ye end anticipated flag
1518 ' ', -- ye resource/equity flag
1519 ' ', -- ye resource/equity begin/end flag
1520 'N', -- fund balance account flag
1521 'N', -- ye general flag
1522 'N', -- ye negative receivables flag
1523 'N', -- ye negative payables flag
1524 'N', -- disbursement flag
1525 'N', -- collections flag
1526 'Y', -- ussgl enabled flag
1527 sysdate, -- creation_date
1528 FND_GLOBAL.USER_ID, -- created by
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,
1538 TOTAL_RESOURCE_DC_FLAG,
1539 RESOURCE_STATUS_BE_FLAG,
1540 RESOURCE_STATUS_DC_FLAG,
1541 YE_ANTICIPATED_FLAG,
1542 YE_RESOURCE_EQUITY_FLAG,
1543 YE_RESOURCE_EQUITY_BE_FLAG,
1544 FUND_BALANCE_ACCOUNT_FLAG,
1545 YE_GENERAL_FLAG,
1546 YE_NEG_RECEIVABLES_FLAG,
1547 YE_NEG_PAYABLES_FLAG,
1548 DISBURSEMENTS_FLAG,
1549 COLLECTIONS_FLAG,
1550 USSGL_ENABLED_FLAG,
1551 CREATION_DATE,
1552 CREATED_BY,
1553 LAST_UPDATE_DATE,
1554 LAST_UPDATED_BY,
1555 LAST_UPDATE_LOGIN)
1556 VALUES ('1525', -- ussgl account number
1557 'Inventory, Raw Materials', -- description
1558 'D', -- natural balance
1559 '1', -- reporting type
1560 ' ', -- total resource begin/end flag
1561 ' ', -- total resource debit/credit flag
1562 ' ', -- resource status begin//end flag
1563 ' ', -- resource status debit/credit flag
1564 'N', -- ye end anticipated flag
1565 ' ', -- ye resource/equity flag
1566 ' ', -- ye resource/equity begin/end flag
1567 'N', -- fund balance account flag
1568 'N', -- ye general flag
1569 'N', -- ye negative receivables flag
1570 'N', -- ye negative payables flag
1571 'N', -- disbursement flag
1572 'N', -- collections flag
1573 'Y', -- ussgl enabled flag
1574 sysdate, -- creation_date
1575 FND_GLOBAL.USER_ID, -- created by
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,
1585 TOTAL_RESOURCE_DC_FLAG,
1586 RESOURCE_STATUS_BE_FLAG,
1587 RESOURCE_STATUS_DC_FLAG,
1588 YE_ANTICIPATED_FLAG,
1589 YE_RESOURCE_EQUITY_FLAG,
1590 YE_RESOURCE_EQUITY_BE_FLAG,
1591 FUND_BALANCE_ACCOUNT_FLAG,
1592 YE_GENERAL_FLAG,
1593 YE_NEG_RECEIVABLES_FLAG,
1594 YE_NEG_PAYABLES_FLAG,
1595 DISBURSEMENTS_FLAG,
1596 COLLECTIONS_FLAG,
1597 USSGL_ENABLED_FLAG,
1598 CREATION_DATE,
1599 CREATED_BY,
1600 LAST_UPDATE_DATE,
1601 LAST_UPDATED_BY,
1602 LAST_UPDATE_LOGIN)
1603 VALUES ('1526', -- ussgl account number
1604 'Inventory - Work-in-Process', -- description
1605 'D', -- natural balance
1606 '1', -- reporting type
1607 ' ', -- total resource begin/end flag
1608 ' ', -- total resource debit/credit flag
1609 ' ', -- resource status begin//end flag
1610 ' ', -- resource status debit/credit flag
1611 'N', -- ye end anticipated flag
1612 ' ', -- ye resource/equity flag
1613 ' ', -- ye resource/equity begin/end flag
1614 'N', -- fund balance account flag
1615 'N', -- ye general flag
1616 'N', -- ye negative receivables flag
1617 'N', -- ye negative payables flag
1618 'N', -- disbursement flag
1619 'N', -- collections flag
1620 'Y', -- ussgl enabled flag
1621 sysdate, -- creation_date
1622 FND_GLOBAL.USER_ID, -- created by
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,
1632 TOTAL_RESOURCE_DC_FLAG,
1633 RESOURCE_STATUS_BE_FLAG,
1634 RESOURCE_STATUS_DC_FLAG,
1635 YE_ANTICIPATED_FLAG,
1636 YE_RESOURCE_EQUITY_FLAG,
1637 YE_RESOURCE_EQUITY_BE_FLAG,
1638 FUND_BALANCE_ACCOUNT_FLAG,
1639 YE_GENERAL_FLAG,
1640 YE_NEG_RECEIVABLES_FLAG,
1641 YE_NEG_PAYABLES_FLAG,
1642 DISBURSEMENTS_FLAG,
1643 COLLECTIONS_FLAG,
1644 USSGL_ENABLED_FLAG,
1645 CREATION_DATE,
1649 LAST_UPDATE_LOGIN)
1646 CREATED_BY,
1647 LAST_UPDATE_DATE,
1648 LAST_UPDATED_BY,
1650 VALUES ('1527', -- ussgl account number
1651 'Inventory - Finished Goods', -- description
1652 'D', -- natural balance
1653 '1', -- reporting type
1654 ' ', -- total resource begin/end flag
1655 ' ', -- total resource debit/credit flag
1656 ' ', -- resource status begin//end flag
1657 ' ', -- resource status debit/credit flag
1658 'N', -- ye end anticipated flag
1659 ' ', -- ye resource/equity flag
1660 ' ', -- ye resource/equity begin/end flag
1661 'N', -- fund balance account flag
1662 'N', -- ye general flag
1663 'N', -- ye negative receivables flag
1664 'N', -- ye negative payables flag
1665 'N', -- disbursement flag
1666 'N', -- collections flag
1667 'Y', -- ussgl enabled flag
1668 sysdate, -- creation_date
1669 FND_GLOBAL.USER_ID, -- created by
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,
1679 TOTAL_RESOURCE_DC_FLAG,
1680 RESOURCE_STATUS_BE_FLAG,
1681 RESOURCE_STATUS_DC_FLAG,
1682 YE_ANTICIPATED_FLAG,
1683 YE_RESOURCE_EQUITY_FLAG,
1684 YE_RESOURCE_EQUITY_BE_FLAG,
1685 FUND_BALANCE_ACCOUNT_FLAG,
1686 YE_GENERAL_FLAG,
1687 YE_NEG_RECEIVABLES_FLAG,
1688 YE_NEG_PAYABLES_FLAG,
1689 DISBURSEMENTS_FLAG,
1690 COLLECTIONS_FLAG,
1691 USSGL_ENABLED_FLAG,
1692 CREATION_DATE,
1693 CREATED_BY,
1694 LAST_UPDATE_DATE,
1695 LAST_UPDATED_BY,
1696 LAST_UPDATE_LOGIN)
1697 VALUES ('1529', -- ussgl account number
1698 'Inventory - Allowance', -- description
1699 'C', -- natural balance
1700 '1', -- reporting type
1701 ' ', -- total resource begin/end flag
1702 ' ', -- total resource debit/credit flag
1703 ' ', -- resource status begin//end flag
1704 ' ', -- resource status debit/credit flag
1705 'N', -- ye end anticipated flag
1706 ' ', -- ye resource/equity flag
1707 ' ', -- ye resource/equity begin/end flag
1708 'N', -- fund balance account flag
1709 'N', -- ye general flag
1710 'N', -- ye negative receivables flag
1711 'N', -- ye negative payables flag
1712 'N', -- disbursement flag
1713 'N', -- collections flag
1714 'Y', -- ussgl enabled flag
1715 sysdate, -- creation_date
1716 FND_GLOBAL.USER_ID, -- created by
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,
1726 TOTAL_RESOURCE_DC_FLAG,
1727 RESOURCE_STATUS_BE_FLAG,
1728 RESOURCE_STATUS_DC_FLAG,
1729 YE_ANTICIPATED_FLAG,
1730 YE_RESOURCE_EQUITY_FLAG,
1731 YE_RESOURCE_EQUITY_BE_FLAG,
1732 FUND_BALANCE_ACCOUNT_FLAG,
1733 YE_GENERAL_FLAG,
1734 YE_NEG_RECEIVABLES_FLAG,
1735 YE_NEG_PAYABLES_FLAG,
1736 DISBURSEMENTS_FLAG,
1737 COLLECTIONS_FLAG,
1738 USSGL_ENABLED_FLAG,
1739 CREATION_DATE,
1740 CREATED_BY,
1741 LAST_UPDATE_DATE,
1742 LAST_UPDATED_BY,
1743 LAST_UPDATE_LOGIN)
1744 VALUES ('1531', -- ussgl account number
1745 'Seized Monetary Instruments', -- description
1746 'D', -- natural balance
1747 '1', -- reporting type
1748 ' ', -- total resource begin/end flag
1749 ' ', -- total resource debit/credit flag
1750 ' ', -- resource status begin//end flag
1751 ' ', -- resource status debit/credit flag
1752 'N', -- ye end anticipated flag
1753 ' ', -- ye resource/equity flag
1754 ' ', -- ye resource/equity begin/end flag
1755 'N', -- fund balance account flag
1756 'N', -- ye general flag
1757 'N', -- ye negative receivables flag
1758 'N', -- ye negative payables flag
1759 'N', -- disbursement flag
1760 'N', -- collections flag
1761 'Y', -- ussgl enabled flag
1762 sysdate, -- creation_date
1763 FND_GLOBAL.USER_ID, -- created by
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,
1773 TOTAL_RESOURCE_DC_FLAG,
1774 RESOURCE_STATUS_BE_FLAG,
1775 RESOURCE_STATUS_DC_FLAG,
1776 YE_ANTICIPATED_FLAG,
1777 YE_RESOURCE_EQUITY_FLAG,
1778 YE_RESOURCE_EQUITY_BE_FLAG,
1779 FUND_BALANCE_ACCOUNT_FLAG,
1780 YE_GENERAL_FLAG,
1781 YE_NEG_RECEIVABLES_FLAG,
1782 YE_NEG_PAYABLES_FLAG,
1783 DISBURSEMENTS_FLAG,
1784 COLLECTIONS_FLAG,
1785 USSGL_ENABLED_FLAG,
1786 CREATION_DATE,
1787 CREATED_BY,
1788 LAST_UPDATE_DATE,
1789 LAST_UPDATED_BY,
1793 'D', -- natural balance
1790 LAST_UPDATE_LOGIN)
1791 VALUES ('1532', -- ussgl account number
1792 'Seized Cash Deposited', -- description
1794 '1', -- reporting type
1795 ' ', -- total resource begin/end flag
1796 ' ', -- total resource debit/credit flag
1797 ' ', -- resource status begin//end flag
1798 ' ', -- resource status debit/credit flag
1799 'N', -- ye end anticipated flag
1800 ' ', -- ye resource/equity flag
1801 ' ', -- ye resource/equity begin/end flag
1802 'N', -- fund balance account flag
1803 'N', -- ye general flag
1804 'N', -- ye negative receivables flag
1805 'N', -- ye negative payables flag
1806 'N', -- disbursement flag
1807 'N', -- collections flag
1808 'Y', -- ussgl enabled flag
1809 sysdate, -- creation_date
1810 FND_GLOBAL.USER_ID, -- created by
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,
1820 TOTAL_RESOURCE_DC_FLAG,
1821 RESOURCE_STATUS_BE_FLAG,
1822 RESOURCE_STATUS_DC_FLAG,
1823 YE_ANTICIPATED_FLAG,
1824 YE_RESOURCE_EQUITY_FLAG,
1825 YE_RESOURCE_EQUITY_BE_FLAG,
1826 FUND_BALANCE_ACCOUNT_FLAG,
1827 YE_GENERAL_FLAG,
1828 YE_NEG_RECEIVABLES_FLAG,
1829 YE_NEG_PAYABLES_FLAG,
1830 DISBURSEMENTS_FLAG,
1831 COLLECTIONS_FLAG,
1832 USSGL_ENABLED_FLAG,
1833 CREATION_DATE,
1834 CREATED_BY,
1835 LAST_UPDATE_DATE,
1836 LAST_UPDATED_BY,
1837 LAST_UPDATE_LOGIN)
1838 VALUES ('1541', -- ussgl account number
1839 'Forfeited Property Held for Sale', -- description
1840 'D', -- natural balance
1841 '1', -- reporting type
1842 ' ', -- total resource begin/end flag
1843 ' ', -- total resource debit/credit flag
1844 ' ', -- resource status begin//end flag
1845 ' ', -- resource status debit/credit flag
1846 'N', -- ye end anticipated flag
1847 ' ', -- ye resource/equity flag
1848 ' ', -- ye resource/equity begin/end flag
1849 'N', -- fund balance account flag
1850 'N', -- ye general flag
1851 'N', -- ye negative receivables flag
1852 'N', -- ye negative payables flag
1853 'N', -- disbursement flag
1854 'N', -- collections flag
1855 'Y', -- ussgl enabled flag
1856 sysdate, -- creation_date
1857 FND_GLOBAL.USER_ID, -- created by
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,
1867 TOTAL_RESOURCE_DC_FLAG,
1868 RESOURCE_STATUS_BE_FLAG,
1869 RESOURCE_STATUS_DC_FLAG,
1870 YE_ANTICIPATED_FLAG,
1871 YE_RESOURCE_EQUITY_FLAG,
1872 YE_RESOURCE_EQUITY_BE_FLAG,
1873 FUND_BALANCE_ACCOUNT_FLAG,
1874 YE_GENERAL_FLAG,
1875 YE_NEG_RECEIVABLES_FLAG,
1876 YE_NEG_PAYABLES_FLAG,
1877 DISBURSEMENTS_FLAG,
1878 COLLECTIONS_FLAG,
1879 USSGL_ENABLED_FLAG,
1880 CREATION_DATE,
1881 CREATED_BY,
1882 LAST_UPDATE_DATE,
1883 LAST_UPDATED_BY,
1884 LAST_UPDATE_LOGIN)
1885 VALUES ('1542', -- ussgl account number
1886 'Forfeited Property Held for Donation or Use', -- description
1887 'D', -- natural balance
1888 '1', -- reporting type
1889 ' ', -- total resource begin/end flag
1890 ' ', -- total resource debit/credit flag
1891 ' ', -- resource status begin//end flag
1892 ' ', -- resource status debit/credit flag
1893 'N', -- ye end anticipated flag
1894 ' ', -- ye resource/equity flag
1895 ' ', -- ye resource/equity begin/end flag
1896 'N', -- fund balance account flag
1897 'N', -- ye general flag
1898 'N', -- ye negative receivables flag
1899 'N', -- ye negative payables flag
1900 'N', -- disbursement flag
1901 'N', -- collections flag
1902 'Y', -- ussgl enabled flag
1903 sysdate, -- creation_date
1904 FND_GLOBAL.USER_ID, -- created by
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,
1914 TOTAL_RESOURCE_DC_FLAG,
1915 RESOURCE_STATUS_BE_FLAG,
1916 RESOURCE_STATUS_DC_FLAG,
1917 YE_ANTICIPATED_FLAG,
1918 YE_RESOURCE_EQUITY_FLAG,
1919 YE_RESOURCE_EQUITY_BE_FLAG,
1920 FUND_BALANCE_ACCOUNT_FLAG,
1921 YE_GENERAL_FLAG,
1922 YE_NEG_RECEIVABLES_FLAG,
1923 YE_NEG_PAYABLES_FLAG,
1924 DISBURSEMENTS_FLAG,
1925 COLLECTIONS_FLAG,
1926 USSGL_ENABLED_FLAG,
1927 CREATION_DATE,
1928 CREATED_BY,
1929 LAST_UPDATE_DATE,
1930 LAST_UPDATED_BY,
1931 LAST_UPDATE_LOGIN)
1932 VALUES ('1549', -- ussgl account number
1936 ' ', -- total resource begin/end flag
1933 'Forfeited Property - Allowance', -- description
1934 'C', -- natural balance
1935 '1', -- reporting type
1937 ' ', -- total resource debit/credit flag
1938 ' ', -- resource status begin//end flag
1939 ' ', -- resource status debit/credit flag
1940 'N', -- ye end anticipated flag
1941 ' ', -- ye resource/equity flag
1942 ' ', -- ye resource/equity begin/end flag
1943 'N', -- fund balance account flag
1944 'N', -- ye general flag
1945 'N', -- ye negative receivables flag
1946 'N', -- ye negative payables flag
1947 'N', -- disbursement flag
1948 'N', -- collections flag
1949 'Y', -- ussgl enabled flag
1950 sysdate, -- creation_date
1951 FND_GLOBAL.USER_ID, -- created by
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,
1961 TOTAL_RESOURCE_DC_FLAG,
1962 RESOURCE_STATUS_BE_FLAG,
1963 RESOURCE_STATUS_DC_FLAG,
1964 YE_ANTICIPATED_FLAG,
1965 YE_RESOURCE_EQUITY_FLAG,
1966 YE_RESOURCE_EQUITY_BE_FLAG,
1967 FUND_BALANCE_ACCOUNT_FLAG,
1968 YE_GENERAL_FLAG,
1969 YE_NEG_RECEIVABLES_FLAG,
1970 YE_NEG_PAYABLES_FLAG,
1971 DISBURSEMENTS_FLAG,
1972 COLLECTIONS_FLAG,
1973 USSGL_ENABLED_FLAG,
1974 CREATION_DATE,
1975 CREATED_BY,
1976 LAST_UPDATE_DATE,
1977 LAST_UPDATED_BY,
1978 LAST_UPDATE_LOGIN)
1979 VALUES ('1551', -- ussgl account number
1980 'Foreclosed Property', -- description
1981 'D', -- natural balance
1982 '1', -- reporting type
1983 ' ', -- total resource begin/end flag
1984 ' ', -- total resource debit/credit flag
1985 ' ', -- resource status begin//end flag
1986 ' ', -- resource status debit/credit flag
1987 'N', -- ye end anticipated flag
1988 ' ', -- ye resource/equity flag
1989 ' ', -- ye resource/equity begin/end flag
1990 'N', -- fund balance account flag
1991 'N', -- ye general flag
1992 'N', -- ye negative receivables flag
1993 'N', -- ye negative payables flag
1994 'N', -- disbursement flag
1995 'N', -- collections flag
1996 'Y', -- ussgl enabled flag
1997 sysdate, -- creation_date
1998 FND_GLOBAL.USER_ID, -- created by
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,
2008 TOTAL_RESOURCE_DC_FLAG,
2009 RESOURCE_STATUS_BE_FLAG,
2010 RESOURCE_STATUS_DC_FLAG,
2011 YE_ANTICIPATED_FLAG,
2012 YE_RESOURCE_EQUITY_FLAG,
2013 YE_RESOURCE_EQUITY_BE_FLAG,
2014 FUND_BALANCE_ACCOUNT_FLAG,
2015 YE_GENERAL_FLAG,
2016 YE_NEG_RECEIVABLES_FLAG,
2017 YE_NEG_PAYABLES_FLAG,
2018 DISBURSEMENTS_FLAG,
2019 COLLECTIONS_FLAG,
2020 USSGL_ENABLED_FLAG,
2021 CREATION_DATE,
2022 CREATED_BY,
2023 LAST_UPDATE_DATE,
2024 LAST_UPDATED_BY,
2025 LAST_UPDATE_LOGIN)
2026 VALUES ('1559', -- ussgl account number
2027 'Foreclosed Property - Allowance', -- description
2028 'C', -- natural balance
2029 '1', -- reporting type
2030 ' ', -- total resource begin/end flag
2031 ' ', -- total resource debit/credit flag
2032 ' ', -- resource status begin//end flag
2033 ' ', -- resource status debit/credit flag
2034 'N', -- ye end anticipated flag
2035 ' ', -- ye resource/equity flag
2036 ' ', -- ye resource/equity begin/end flag
2037 'N', -- fund balance account flag
2038 'N', -- ye general flag
2039 'N', -- ye negative receivables flag
2040 'N', -- ye negative payables flag
2041 'N', -- disbursement flag
2042 'N', -- collections flag
2043 'Y', -- ussgl enabled flag
2044 sysdate, -- creation_date
2045 FND_GLOBAL.USER_ID, -- created by
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,
2055 TOTAL_RESOURCE_DC_FLAG,
2056 RESOURCE_STATUS_BE_FLAG,
2057 RESOURCE_STATUS_DC_FLAG,
2058 YE_ANTICIPATED_FLAG,
2059 YE_RESOURCE_EQUITY_FLAG,
2060 YE_RESOURCE_EQUITY_BE_FLAG,
2061 FUND_BALANCE_ACCOUNT_FLAG,
2062 YE_GENERAL_FLAG,
2063 YE_NEG_RECEIVABLES_FLAG,
2064 YE_NEG_PAYABLES_FLAG,
2065 DISBURSEMENTS_FLAG,
2066 COLLECTIONS_FLAG,
2067 USSGL_ENABLED_FLAG,
2068 CREATION_DATE,
2069 CREATED_BY,
2070 LAST_UPDATE_DATE,
2071 LAST_UPDATED_BY,
2072 LAST_UPDATE_LOGIN)
2073 VALUES ('1561', -- ussgl account number
2074 'Commodities Held Under Price Support and Stabilization Support Programs', -- description
2078 ' ', -- total resource debit/credit flag
2075 'D', -- natural balance
2076 '1', -- reporting type
2077 ' ', -- total resource begin/end flag
2079 ' ', -- resource status begin//end flag
2080 ' ', -- resource status debit/credit flag
2081 'N', -- ye end anticipated flag
2082 ' ', -- ye resource/equity flag
2083 ' ', -- ye resource/equity begin/end flag
2084 'N', -- fund balance account flag
2085 'N', -- ye general flag
2086 'N', -- ye negative receivables flag
2087 'N', -- ye negative payables flag
2088 'N', -- disbursement flag
2089 'N', -- collections flag
2090 'Y', -- ussgl enabled flag
2091 sysdate, -- creation_date
2092 FND_GLOBAL.USER_ID, -- created by
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,
2102 TOTAL_RESOURCE_DC_FLAG,
2103 RESOURCE_STATUS_BE_FLAG,
2104 RESOURCE_STATUS_DC_FLAG,
2105 YE_ANTICIPATED_FLAG,
2106 YE_RESOURCE_EQUITY_FLAG,
2107 YE_RESOURCE_EQUITY_BE_FLAG,
2108 FUND_BALANCE_ACCOUNT_FLAG,
2109 YE_GENERAL_FLAG,
2110 YE_NEG_RECEIVABLES_FLAG,
2111 YE_NEG_PAYABLES_FLAG,
2112 DISBURSEMENTS_FLAG,
2113 COLLECTIONS_FLAG,
2114 USSGL_ENABLED_FLAG,
2115 CREATION_DATE,
2116 CREATED_BY,
2117 LAST_UPDATE_DATE,
2118 LAST_UPDATED_BY,
2119 LAST_UPDATE_LOGIN)
2120 VALUES ('1569', -- ussgl account number
2121 'Commodities - Allowance', -- description
2122 'C', -- natural balance
2123 '1', -- reporting type
2124 ' ', -- total resource begin/end flag
2125 ' ', -- total resource debit/credit flag
2126 ' ', -- resource status begin//end flag
2127 ' ', -- resource status debit/credit flag
2128 'N', -- ye end anticipated flag
2129 ' ', -- ye resource/equity flag
2130 ' ', -- ye resource/equity begin/end flag
2131 'N', -- fund balance account flag
2132 'N', -- ye general flag
2133 'N', -- ye negative receivables flag
2134 'N', -- ye negative payables flag
2135 'N', -- disbursement flag
2136 'N', -- collections flag
2137 'Y', -- ussgl enabled flag
2138 sysdate, -- creation_date
2139 FND_GLOBAL.USER_ID, -- created by
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,
2149 TOTAL_RESOURCE_DC_FLAG,
2150 RESOURCE_STATUS_BE_FLAG,
2151 RESOURCE_STATUS_DC_FLAG,
2152 YE_ANTICIPATED_FLAG,
2153 YE_RESOURCE_EQUITY_FLAG,
2154 YE_RESOURCE_EQUITY_BE_FLAG,
2155 FUND_BALANCE_ACCOUNT_FLAG,
2156 YE_GENERAL_FLAG,
2157 YE_NEG_RECEIVABLES_FLAG,
2158 YE_NEG_PAYABLES_FLAG,
2159 DISBURSEMENTS_FLAG,
2160 COLLECTIONS_FLAG,
2161 USSGL_ENABLED_FLAG,
2162 CREATION_DATE,
2163 CREATED_BY,
2164 LAST_UPDATE_DATE,
2165 LAST_UPDATED_BY,
2166 LAST_UPDATE_LOGIN)
2167 VALUES ('1571', -- ussgl account number
2168 'Stockpile Materials Held in Reserve', -- description
2169 'D', -- natural balance
2170 '1', -- reporting type
2171 ' ', -- total resource begin/end flag
2172 ' ', -- total resource debit/credit flag
2173 ' ', -- resource status begin//end flag
2174 ' ', -- resource status debit/credit flag
2175 'N', -- ye end anticipated flag
2176 ' ', -- ye resource/equity flag
2177 ' ', -- ye resource/equity begin/end flag
2178 'N', -- fund balance account flag
2179 'N', -- ye general flag
2180 'N', -- ye negative receivables flag
2181 'N', -- ye negative payables flag
2182 'N', -- disbursement flag
2183 'N', -- collections flag
2184 'Y', -- ussgl enabled flag
2185 sysdate, -- creation_date
2186 FND_GLOBAL.USER_ID, -- created by
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,
2196 TOTAL_RESOURCE_DC_FLAG,
2197 RESOURCE_STATUS_BE_FLAG,
2198 RESOURCE_STATUS_DC_FLAG,
2199 YE_ANTICIPATED_FLAG,
2200 YE_RESOURCE_EQUITY_FLAG,
2201 YE_RESOURCE_EQUITY_BE_FLAG,
2202 FUND_BALANCE_ACCOUNT_FLAG,
2203 YE_GENERAL_FLAG,
2204 YE_NEG_RECEIVABLES_FLAG,
2205 YE_NEG_PAYABLES_FLAG,
2206 DISBURSEMENTS_FLAG,
2207 COLLECTIONS_FLAG,
2208 USSGL_ENABLED_FLAG,
2209 CREATION_DATE,
2210 CREATED_BY,
2211 LAST_UPDATE_DATE,
2212 LAST_UPDATED_BY,
2213 LAST_UPDATE_LOGIN)
2214 VALUES ('1572', -- ussgl account number
2215 'Stockpile Materials Held for Sale', -- description
2216 'D', -- natural balance
2217 '1', -- reporting type
2221 ' ', -- resource status debit/credit flag
2218 ' ', -- total resource begin/end flag
2219 ' ', -- total resource debit/credit flag
2220 ' ', -- resource status begin//end flag
2222 'N', -- ye end anticipated flag
2223 ' ', -- ye resource/equity flag
2224 ' ', -- ye resource/equity begin/end flag
2225 'N', -- fund balance account flag
2226 'N', -- ye general flag
2227 'N', -- ye negative receivables flag
2228 'N', -- ye negative payables flag
2229 'N', -- disbursement flag
2230 'N', -- collections flag
2231 'Y', -- ussgl enabled flag
2232 sysdate, -- creation_date
2233 FND_GLOBAL.USER_ID, -- created by
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,
2243 TOTAL_RESOURCE_DC_FLAG,
2244 RESOURCE_STATUS_BE_FLAG,
2245 RESOURCE_STATUS_DC_FLAG,
2246 YE_ANTICIPATED_FLAG,
2247 YE_RESOURCE_EQUITY_FLAG,
2248 YE_RESOURCE_EQUITY_BE_FLAG,
2249 FUND_BALANCE_ACCOUNT_FLAG,
2250 YE_GENERAL_FLAG,
2251 YE_NEG_RECEIVABLES_FLAG,
2252 YE_NEG_PAYABLES_FLAG,
2253 DISBURSEMENTS_FLAG,
2254 COLLECTIONS_FLAG,
2255 USSGL_ENABLED_FLAG,
2256 CREATION_DATE,
2257 CREATED_BY,
2258 LAST_UPDATE_DATE,
2259 LAST_UPDATED_BY,
2260 LAST_UPDATE_LOGIN)
2261 VALUES ('1591', -- ussgl account number
2262 'Other Related Property', -- description
2263 'D', -- natural balance
2264 '1', -- reporting type
2265 ' ', -- total resource begin/end flag
2266 ' ', -- total resource debit/credit flag
2267 ' ', -- resource status begin//end flag
2268 ' ', -- resource status debit/credit flag
2269 'N', -- ye end anticipated flag
2270 ' ', -- ye resource/equity flag
2271 ' ', -- ye resource/equity begin/end flag
2272 'N', -- fund balance account flag
2273 'N', -- ye general flag
2274 'N', -- ye negative receivables flag
2275 'N', -- ye negative payables flag
2276 'N', -- disbursement flag
2277 'N', -- collections flag
2278 'Y', -- ussgl enabled flag
2279 sysdate, -- creation_date
2280 FND_GLOBAL.USER_ID, -- created by
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,
2290 TOTAL_RESOURCE_DC_FLAG,
2291 RESOURCE_STATUS_BE_FLAG,
2292 RESOURCE_STATUS_DC_FLAG,
2293 YE_ANTICIPATED_FLAG,
2294 YE_RESOURCE_EQUITY_FLAG,
2295 YE_RESOURCE_EQUITY_BE_FLAG,
2296 FUND_BALANCE_ACCOUNT_FLAG,
2297 YE_GENERAL_FLAG,
2298 YE_NEG_RECEIVABLES_FLAG,
2299 YE_NEG_PAYABLES_FLAG,
2300 DISBURSEMENTS_FLAG,
2301 COLLECTIONS_FLAG,
2302 USSGL_ENABLED_FLAG,
2303 CREATION_DATE,
2304 CREATED_BY,
2305 LAST_UPDATE_DATE,
2306 LAST_UPDATED_BY,
2307 LAST_UPDATE_LOGIN)
2308 VALUES ('1599', -- ussgl account number
2309 'Other Related Property - Allowance', -- description
2310 'C', -- natural balance
2311 '1', -- reporting type
2312 ' ', -- total resource begin/end flag
2313 ' ', -- total resource debit/credit flag
2314 ' ', -- resource status begin//end flag
2315 ' ', -- resource status debit/credit flag
2316 'N', -- ye end anticipated flag
2317 ' ', -- ye resource/equity flag
2318 ' ', -- ye resource/equity begin/end flag
2319 'N', -- fund balance account flag
2320 'N', -- ye general flag
2321 'N', -- ye negative receivables flag
2322 'N', -- ye negative payables flag
2323 'N', -- disbursement flag
2324 'N', -- collections flag
2325 'Y', -- ussgl enabled flag
2326 sysdate, -- creation_date
2327 FND_GLOBAL.USER_ID, -- created by
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,
2337 TOTAL_RESOURCE_DC_FLAG,
2338 RESOURCE_STATUS_BE_FLAG,
2339 RESOURCE_STATUS_DC_FLAG,
2340 YE_ANTICIPATED_FLAG,
2341 YE_RESOURCE_EQUITY_FLAG,
2342 YE_RESOURCE_EQUITY_BE_FLAG,
2343 FUND_BALANCE_ACCOUNT_FLAG,
2344 YE_GENERAL_FLAG,
2345 YE_NEG_RECEIVABLES_FLAG,
2346 YE_NEG_PAYABLES_FLAG,
2347 DISBURSEMENTS_FLAG,
2348 COLLECTIONS_FLAG,
2349 USSGL_ENABLED_FLAG,
2350 CREATION_DATE,
2351 CREATED_BY,
2352 LAST_UPDATE_DATE,
2353 LAST_UPDATED_BY,
2354 LAST_UPDATE_LOGIN)
2355 VALUES ('1610', -- ussgl account number
2356 'Investment in U.S. Treasury Securities Issued by Public Debt', -- description
2357 'D', -- natural balance
2358 '3', -- reporting type
2359 ' ', -- total resource begin/end flag
2363 'N', -- ye end anticipated flag
2360 ' ', -- total resource debit/credit flag
2361 ' ', -- resource status begin//end flag
2362 ' ', -- resource status debit/credit flag
2364 'R', -- ye resource/equity flag
2365 'E', -- ye resource/equity begin/end flag
2366 'N', -- fund balance account flag
2367 'N', -- ye general flag
2368 'N', -- ye negative receivables flag
2369 'N', -- ye negative payables flag
2370 'N', -- disbursement flag
2371 'N', -- collections flag
2372 'Y', -- ussgl enabled flag
2373 sysdate, -- creation_date
2374 FND_GLOBAL.USER_ID, -- created by
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,
2384 TOTAL_RESOURCE_DC_FLAG,
2385 RESOURCE_STATUS_BE_FLAG,
2386 RESOURCE_STATUS_DC_FLAG,
2387 YE_ANTICIPATED_FLAG,
2388 YE_RESOURCE_EQUITY_FLAG,
2389 YE_RESOURCE_EQUITY_BE_FLAG,
2390 FUND_BALANCE_ACCOUNT_FLAG,
2391 YE_GENERAL_FLAG,
2392 YE_NEG_RECEIVABLES_FLAG,
2393 YE_NEG_PAYABLES_FLAG,
2394 DISBURSEMENTS_FLAG,
2395 COLLECTIONS_FLAG,
2396 USSGL_ENABLED_FLAG,
2397 CREATION_DATE,
2398 CREATED_BY,
2399 LAST_UPDATE_DATE,
2400 LAST_UPDATED_BY,
2401 LAST_UPDATE_LOGIN)
2402 VALUES ('1611', -- ussgl account number
2403 'Discount on U.S. Treasury Securities Issued by Public Debt', -- description
2404 'C', -- natural balance
2405 '3', -- reporting type
2406 ' ', -- total resource begin/end flag
2407 ' ', -- total resource debit/credit flag
2408 ' ', -- resource status begin//end flag
2409 ' ', -- resource status debit/credit flag
2410 'N', -- ye end anticipated flag
2411 'R', -- ye resource/equity flag
2412 'E', -- ye resource/equity begin/end flag
2413 'N', -- fund balance account flag
2414 'N', -- ye general flag
2415 'N', -- ye negative receivables flag
2416 'N', -- ye negative payables flag
2417 'N', -- disbursement flag
2418 'N', -- collections flag
2419 'Y', -- ussgl enabled flag
2420 sysdate, -- creation_date
2421 FND_GLOBAL.USER_ID, -- created by
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,
2431 TOTAL_RESOURCE_DC_FLAG,
2432 RESOURCE_STATUS_BE_FLAG,
2433 RESOURCE_STATUS_DC_FLAG,
2434 YE_ANTICIPATED_FLAG,
2435 YE_RESOURCE_EQUITY_FLAG,
2436 YE_RESOURCE_EQUITY_BE_FLAG,
2437 FUND_BALANCE_ACCOUNT_FLAG,
2438 YE_GENERAL_FLAG,
2439 YE_NEG_RECEIVABLES_FLAG,
2440 YE_NEG_PAYABLES_FLAG,
2441 DISBURSEMENTS_FLAG,
2442 COLLECTIONS_FLAG,
2443 USSGL_ENABLED_FLAG,
2444 CREATION_DATE,
2445 CREATED_BY,
2446 LAST_UPDATE_DATE,
2447 LAST_UPDATED_BY,
2448 LAST_UPDATE_LOGIN)
2449 VALUES ('1612', -- ussgl account number
2450 'Premium on U.S. Treasury Securities Issued by Public Debt', -- description
2451 'D', -- natural balance
2452 '3', -- reporting type
2453 ' ', -- total resource begin/end flag
2454 ' ', -- total resource debit/credit flag
2455 ' ', -- resource status begin//end flag
2456 ' ', -- resource status debit/credit flag
2457 'N', -- ye end anticipated flag
2458 ' ', -- ye resource/equity flag
2459 ' ', -- ye resource/equity begin/end flag
2460 'N', -- fund balance account flag
2461 'N', -- ye general flag
2462 'N', -- ye negative receivables flag
2463 'N', -- ye negative payables flag
2464 'N', -- disbursement flag
2465 'N', -- collections flag
2466 'Y', -- ussgl enabled flag
2467 sysdate, -- creation_date
2468 FND_GLOBAL.USER_ID, -- created by
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,
2478 TOTAL_RESOURCE_DC_FLAG,
2479 RESOURCE_STATUS_BE_FLAG,
2480 RESOURCE_STATUS_DC_FLAG,
2481 YE_ANTICIPATED_FLAG,
2482 YE_RESOURCE_EQUITY_FLAG,
2483 YE_RESOURCE_EQUITY_BE_FLAG,
2484 FUND_BALANCE_ACCOUNT_FLAG,
2485 YE_GENERAL_FLAG,
2486 YE_NEG_RECEIVABLES_FLAG,
2487 YE_NEG_PAYABLES_FLAG,
2488 DISBURSEMENTS_FLAG,
2489 COLLECTIONS_FLAG,
2490 USSGL_ENABLED_FLAG,
2491 CREATION_DATE,
2492 CREATED_BY,
2493 LAST_UPDATE_DATE,
2494 LAST_UPDATED_BY,
2495 LAST_UPDATE_LOGIN)
2496 VALUES ('1613', -- ussgl account number
2497 'Amortization of Discount and Premium on U.S. Treasury Securities Issued by Public Debt', -- description
2498 'E', -- natural balance
2499 '3', -- reporting type
2500 ' ', -- total resource begin/end flag
2504 'N', -- ye end anticipated flag
2501 ' ', -- total resource debit/credit flag
2502 ' ', -- resource status begin//end flag
2503 ' ', -- resource status debit/credit flag
2505 ' ', -- ye resource/equity flag
2506 ' ', -- ye resource/equity begin/end flag
2507 'N', -- fund balance account flag
2508 'N', -- ye general flag
2509 'N', -- ye negative receivables flag
2510 'N', -- ye negative payables flag
2511 'N', -- disbursement flag
2512 'N', -- collections flag
2513 'Y', -- ussgl enabled flag
2514 sysdate, -- creation_date
2515 FND_GLOBAL.USER_ID, -- created by
2516 sysdate, -- last update date
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,
2526 TOTAL_RESOURCE_DC_FLAG,
2527 RESOURCE_STATUS_BE_FLAG,
2528 RESOURCE_STATUS_DC_FLAG,
2529 YE_ANTICIPATED_FLAG,
2530 YE_RESOURCE_EQUITY_FLAG,
2531 YE_RESOURCE_EQUITY_BE_FLAG,
2532 FUND_BALANCE_ACCOUNT_FLAG,
2533 YE_GENERAL_FLAG,
2534 YE_NEG_RECEIVABLES_FLAG,
2535 YE_NEG_PAYABLES_FLAG,
2536 DISBURSEMENTS_FLAG,
2537 COLLECTIONS_FLAG,
2538 USSGL_ENABLED_FLAG,
2539 CREATION_DATE,
2540 CREATED_BY,
2541 LAST_UPDATE_DATE,
2542 LAST_UPDATED_BY,
2543 LAST_UPDATE_LOGIN)
2544 VALUES ('1618', -- ussgl account number
2545 'Market Adjustment - Investments', -- description
2546 'E', -- natural balance
2547 '1', -- reporting type
2548 ' ', -- total resource begin/end flag
2549 ' ', -- total resource debit/credit flag
2550 ' ', -- resource status begin//end flag
2551 ' ', -- resource status debit/credit flag
2552 'N', -- ye end anticipated flag
2553 ' ', -- ye resource/equity flag
2554 ' ', -- ye resource/equity begin/end flag
2555 'N', -- fund balance account flag
2556 'N', -- ye general flag
2557 'N', -- ye negative receivables flag
2558 'N', -- ye negative payables flag
2559 'N', -- disbursement flag
2560 'N', -- collections flag
2561 'Y', -- ussgl enabled flag
2562 sysdate, -- creation_date
2563 FND_GLOBAL.USER_ID, -- created by
2564 sysdate, -- last update date
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,
2574 TOTAL_RESOURCE_DC_FLAG,
2575 RESOURCE_STATUS_BE_FLAG,
2576 RESOURCE_STATUS_DC_FLAG,
2577 YE_ANTICIPATED_FLAG,
2578 YE_RESOURCE_EQUITY_FLAG,
2579 YE_RESOURCE_EQUITY_BE_FLAG,
2580 FUND_BALANCE_ACCOUNT_FLAG,
2581 YE_GENERAL_FLAG,
2582 YE_NEG_RECEIVABLES_FLAG,
2583 YE_NEG_PAYABLES_FLAG,
2584 DISBURSEMENTS_FLAG,
2585 COLLECTIONS_FLAG,
2586 USSGL_ENABLED_FLAG,
2587 CREATION_DATE,
2588 CREATED_BY,
2589 LAST_UPDATE_DATE,
2590 LAST_UPDATED_BY,
2591 LAST_UPDATE_LOGIN)
2592 VALUES ('1620', -- ussgl account number
2593 'Investment in Securities Other than Public Debt Securities', -- description
2594 'D', -- natural balance
2595 '3', -- reporting type
2596 ' ', -- total resource begin/end flag
2597 ' ', -- total resource debit/credit flag
2598 ' ', -- resource status begin//end flag
2599 ' ', -- resource status debit/credit flag
2600 'N', -- ye end anticipated flag
2601 'R', -- ye resource/equity flag
2602 'E', -- ye resource/equity begin/end flag
2603 'N', -- fund balance account flag
2604 'N', -- ye general flag
2605 'N', -- ye negative receivables flag
2606 'N', -- ye negative payables flag
2607 'N', -- disbursement flag
2608 'N', -- collections flag
2609 'Y', -- ussgl enabled flag
2610 sysdate, -- creation_date
2611 FND_GLOBAL.USER_ID, -- created by
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,
2621 TOTAL_RESOURCE_DC_FLAG,
2622 RESOURCE_STATUS_BE_FLAG,
2623 RESOURCE_STATUS_DC_FLAG,
2624 YE_ANTICIPATED_FLAG,
2625 YE_RESOURCE_EQUITY_FLAG,
2626 YE_RESOURCE_EQUITY_BE_FLAG,
2627 FUND_BALANCE_ACCOUNT_FLAG,
2628 YE_GENERAL_FLAG,
2629 YE_NEG_RECEIVABLES_FLAG,
2630 YE_NEG_PAYABLES_FLAG,
2631 DISBURSEMENTS_FLAG,
2632 COLLECTIONS_FLAG,
2633 USSGL_ENABLED_FLAG,
2634 CREATION_DATE,
2635 CREATED_BY,
2636 LAST_UPDATE_DATE,
2637 LAST_UPDATED_BY,
2638 LAST_UPDATE_LOGIN)
2639 VALUES ('1621', -- ussgl account number
2640 'Discount on Securities Other than Public Debt Securities', -- description
2641 'C', -- natural balance
2642 '3', -- reporting type
2643 ' ', -- total resource begin/end flag
2647 'N', -- ye end anticipated flag
2644 ' ', -- total resource debit/credit flag
2645 ' ', -- resource status begin//end flag
2646 ' ', -- resource status debit/credit flag
2648 'R', -- ye resource/equity flag
2649 'E', -- ye resource/equity begin/end flag
2650 'N', -- fund balance account flag
2651 'N', -- ye general flag
2652 'N', -- ye negative receivables flag
2653 'N', -- ye negative payables flag
2654 'N', -- disbursement flag
2655 'N', -- collections flag
2656 'Y', -- ussgl enabled flag
2657 sysdate, -- creation_date
2658 FND_GLOBAL.USER_ID, -- created by
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,
2668 TOTAL_RESOURCE_DC_FLAG,
2669 RESOURCE_STATUS_BE_FLAG,
2670 RESOURCE_STATUS_DC_FLAG,
2671 YE_ANTICIPATED_FLAG,
2672 YE_RESOURCE_EQUITY_FLAG,
2673 YE_RESOURCE_EQUITY_BE_FLAG,
2674 FUND_BALANCE_ACCOUNT_FLAG,
2675 YE_GENERAL_FLAG,
2676 YE_NEG_RECEIVABLES_FLAG,
2677 YE_NEG_PAYABLES_FLAG,
2678 DISBURSEMENTS_FLAG,
2679 COLLECTIONS_FLAG,
2680 USSGL_ENABLED_FLAG,
2681 CREATION_DATE,
2682 CREATED_BY,
2683 LAST_UPDATE_DATE,
2684 LAST_UPDATED_BY,
2685 LAST_UPDATE_LOGIN)
2686 VALUES ('1622', -- ussgl account number
2687 'Premium on Securities Other than Public Debt Securities', -- description
2688 'D', -- natural balance
2689 '3', -- reporting type
2690 ' ', -- total resource begin/end flag
2691 ' ', -- total resource debit/credit flag
2692 ' ', -- resource status begin//end flag
2693 ' ', -- resource status debit/credit flag
2694 'N', -- ye end anticipated flag
2695 ' ', -- ye resource/equity flag
2696 ' ', -- ye resource/equity begin/end flag
2697 'N', -- fund balance account flag
2698 'N', -- ye general flag
2699 'N', -- ye negative receivables flag
2700 'N', -- ye negative payables flag
2701 'N', -- disbursement flag
2702 'N', -- collections flag
2703 'Y', -- ussgl enabled flag
2704 sysdate, -- creation_date
2705 FND_GLOBAL.USER_ID, -- created by
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,
2715 TOTAL_RESOURCE_DC_FLAG,
2716 RESOURCE_STATUS_BE_FLAG,
2717 RESOURCE_STATUS_DC_FLAG,
2718 YE_ANTICIPATED_FLAG,
2719 YE_RESOURCE_EQUITY_FLAG,
2720 YE_RESOURCE_EQUITY_BE_FLAG,
2721 FUND_BALANCE_ACCOUNT_FLAG,
2722 YE_GENERAL_FLAG,
2723 YE_NEG_RECEIVABLES_FLAG,
2724 YE_NEG_PAYABLES_FLAG,
2725 DISBURSEMENTS_FLAG,
2726 COLLECTIONS_FLAG,
2727 USSGL_ENABLED_FLAG,
2728 CREATION_DATE,
2729 CREATED_BY,
2730 LAST_UPDATE_DATE,
2731 LAST_UPDATED_BY,
2732 LAST_UPDATE_LOGIN)
2733 VALUES ('1623', -- ussgl account number
2734 'Amoritization of Premium and Discount on Securities Other than Public Debt Securities', -- description
2735 'E', -- natural balance
2736 '3', -- reporting type
2737 ' ', -- total resource begin/end flag
2738 ' ', -- total resource debit/credit flag
2739 ' ', -- resource status begin//end flag
2740 ' ', -- resource status debit/credit flag
2741 'N', -- ye end anticipated flag
2742 ' ', -- ye resource/equity flag
2743 ' ', -- ye resource/equity begin/end flag
2744 'N', -- fund balance account flag
2745 'N', -- ye general flag
2746 'N', -- ye negative receivables flag
2747 'N', -- ye negative payables flag
2748 'N', -- disbursement flag
2749 'N', -- collections flag
2750 'Y', -- ussgl enabled flag
2751 sysdate, -- creation_date
2752 FND_GLOBAL.USER_ID, -- created by
2753 sysdate, -- last update date
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,
2763 TOTAL_RESOURCE_DC_FLAG,
2764 RESOURCE_STATUS_BE_FLAG,
2765 RESOURCE_STATUS_DC_FLAG,
2766 YE_ANTICIPATED_FLAG,
2767 YE_RESOURCE_EQUITY_FLAG,
2768 YE_RESOURCE_EQUITY_BE_FLAG,
2769 FUND_BALANCE_ACCOUNT_FLAG,
2770 YE_GENERAL_FLAG,
2771 YE_NEG_RECEIVABLES_FLAG,
2772 YE_NEG_PAYABLES_FLAG,
2773 DISBURSEMENTS_FLAG,
2774 COLLECTIONS_FLAG,
2775 USSGL_ENABLED_FLAG,
2776 CREATION_DATE,
2777 CREATED_BY,
2778 LAST_UPDATE_DATE,
2779 LAST_UPDATED_BY,
2780 LAST_UPDATE_LOGIN)
2781 VALUES ('1630', -- ussgl account number
2782 'Investments in U.S. Treasury Zero Coupon Bonds Issued by Public Debt', -- description
2783 'D', -- natural balance
2784 '3', -- reporting type
2788 ' ', -- resource status debit/credit flag
2785 ' ', -- total resource begin/end flag
2786 ' ', -- total resource debit/credit flag
2787 ' ', -- resource status begin//end flag
2789 'N', -- ye end anticipated flag
2790 'R', -- ye resource/equity flag
2791 'E', -- ye resource/equity begin/end flag
2792 'N', -- fund balance account flag
2793 'N', -- ye general flag
2794 'N', -- ye negative receivables flag
2795 'N', -- ye negative payables flag
2796 'N', -- disbursement flag
2797 'N', -- collections flag
2798 'Y', -- ussgl enabled flag
2799 sysdate, -- creation_date
2800 FND_GLOBAL.USER_ID, -- created by
2801 sysdate, -- last update date
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,
2811 TOTAL_RESOURCE_DC_FLAG,
2812 RESOURCE_STATUS_BE_FLAG,
2813 RESOURCE_STATUS_DC_FLAG,
2814 YE_ANTICIPATED_FLAG,
2815 YE_RESOURCE_EQUITY_FLAG,
2816 YE_RESOURCE_EQUITY_BE_FLAG,
2817 FUND_BALANCE_ACCOUNT_FLAG,
2818 YE_GENERAL_FLAG,
2819 YE_NEG_RECEIVABLES_FLAG,
2820 YE_NEG_PAYABLES_FLAG,
2821 DISBURSEMENTS_FLAG,
2822 COLLECTIONS_FLAG,
2823 USSGL_ENABLED_FLAG,
2824 CREATION_DATE,
2825 CREATED_BY,
2826 LAST_UPDATE_DATE,
2827 LAST_UPDATED_BY,
2828 LAST_UPDATE_LOGIN)
2829 VALUES ('1631', -- ussgl account number
2830 'Discount on U.S. Treasury Zero Coupon Bonds Issued by Public Debt', -- description
2831 'C', -- natural balance
2832 '3', -- reporting type
2833 ' ', -- total resource begin/end flag
2834 ' ', -- total resource debit/credit flag
2835 ' ', -- resource status begin//end flag
2836 ' ', -- resource status debit/credit flag
2837 'N', -- ye end anticipated flag
2838 'R', -- ye resource/equity flag
2839 'E', -- ye resource/equity begin/end flag
2840 'N', -- fund balance account flag
2841 'N', -- ye general flag
2842 'N', -- ye negative receivables flag
2843 'N', -- ye negative payables flag
2844 'N', -- disbursement flag
2845 'N', -- collections flag
2846 'Y', -- ussgl enabled flag
2847 sysdate, -- creation_date
2848 FND_GLOBAL.USER_ID, -- created by
2849 sysdate, -- last update date
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,
2859 TOTAL_RESOURCE_DC_FLAG,
2860 RESOURCE_STATUS_BE_FLAG,
2861 RESOURCE_STATUS_DC_FLAG,
2862 YE_ANTICIPATED_FLAG,
2863 YE_RESOURCE_EQUITY_FLAG,
2864 YE_RESOURCE_EQUITY_BE_FLAG,
2865 FUND_BALANCE_ACCOUNT_FLAG,
2866 YE_GENERAL_FLAG,
2867 YE_NEG_RECEIVABLES_FLAG,
2868 YE_NEG_PAYABLES_FLAG,
2869 DISBURSEMENTS_FLAG,
2870 COLLECTIONS_FLAG,
2871 USSGL_ENABLED_FLAG,
2872 CREATION_DATE,
2873 CREATED_BY,
2874 LAST_UPDATE_DATE,
2875 LAST_UPDATED_BY,
2876 LAST_UPDATE_LOGIN)
2877 VALUES ('1633', -- ussgl account number
2878 'Amortization of Discount on U.S. Treasury Zero Coupon Bonds Issue by Public Debt', -- description
2879 'D', -- natural balance
2880 '3', -- reporting type
2881 ' ', -- total resource begin/end flag
2882 ' ', -- total resource debit/credit flag
2883 ' ', -- resource status begin//end flag
2884 ' ', -- resource status debit/credit flag
2885 'N', -- ye end anticipated flag
2886 'R', -- ye resource/equity flag
2887 'E', -- ye resource/equity begin/end flag
2888 'N', -- fund balance account flag
2889 'N', -- ye general flag
2890 'N', -- ye negative receivables flag
2891 'N', -- ye negative payables flag
2892 'N', -- disbursement flag
2893 'N', -- collections flag
2894 'Y', -- ussgl enabled flag
2895 sysdate, -- creation_date
2896 FND_GLOBAL.USER_ID, -- created by
2897 sysdate, -- last update date
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,
2907 TOTAL_RESOURCE_DC_FLAG,
2908 RESOURCE_STATUS_BE_FLAG,
2909 RESOURCE_STATUS_DC_FLAG,
2910 YE_ANTICIPATED_FLAG,
2911 YE_RESOURCE_EQUITY_FLAG,
2912 YE_RESOURCE_EQUITY_BE_FLAG,
2913 FUND_BALANCE_ACCOUNT_FLAG,
2914 YE_GENERAL_FLAG,
2915 YE_NEG_RECEIVABLES_FLAG,
2916 YE_NEG_PAYABLES_FLAG,
2917 DISBURSEMENTS_FLAG,
2918 COLLECTIONS_FLAG,
2919 USSGL_ENABLED_FLAG,
2920 CREATION_DATE,
2921 CREATED_BY,
2922 LAST_UPDATE_DATE,
2923 LAST_UPDATED_BY,
2924 LAST_UPDATE_LOGIN)
2925 VALUES ('1638', -- ussgl account number
2926 'Market Adjustment - Investments in U.S. Treasury Zero Coupon Bonds', -- description
2930 ' ', -- total resource debit/credit flag
2927 'E', -- natural balance
2928 '3', -- reporting type
2929 ' ', -- total resource begin/end flag
2931 ' ', -- resource status begin//end flag
2932 ' ', -- resource status debit/credit flag
2933 'N', -- ye end anticipated flag
2934 'R', -- ye resource/equity flag
2935 'E', -- ye resource/equity begin/end flag
2936 'N', -- fund balance account flag
2937 'N', -- ye general flag
2938 'N', -- ye negative receivables flag
2939 'N', -- ye negative payables flag
2940 'N', -- disbursement flag
2941 'N', -- collections flag
2942 'Y', -- ussgl enabled flag
2943 sysdate, -- creation_date
2944 FND_GLOBAL.USER_ID, -- created by
2945 sysdate, -- last update date
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,
2955 TOTAL_RESOURCE_DC_FLAG,
2956 RESOURCE_STATUS_BE_FLAG,
2957 RESOURCE_STATUS_DC_FLAG,
2958 YE_ANTICIPATED_FLAG,
2959 YE_RESOURCE_EQUITY_FLAG,
2960 YE_RESOURCE_EQUITY_BE_FLAG,
2961 FUND_BALANCE_ACCOUNT_FLAG,
2962 YE_GENERAL_FLAG,
2963 YE_NEG_RECEIVABLES_FLAG,
2964 YE_NEG_PAYABLES_FLAG,
2965 DISBURSEMENTS_FLAG,
2966 COLLECTIONS_FLAG,
2967 USSGL_ENABLED_FLAG,
2968 CREATION_DATE,
2969 CREATED_BY,
2970 LAST_UPDATE_DATE,
2971 LAST_UPDATED_BY,
2972 LAST_UPDATE_LOGIN)
2973 VALUES ('1639', -- ussgl account number
2974 'Contra Market Adjustment - Investments in U.S. Treasury Zero Coupon Bonds', -- description
2975 'E', -- natural balance
2976 '3', -- reporting type
2977 ' ', -- total resource begin/end flag
2978 ' ', -- total resource debit/credit flag
2979 ' ', -- resource status begin//end flag
2980 ' ', -- resource status debit/credit flag
2981 'N', -- ye end anticipated flag
2982 'R', -- ye resource/equity flag
2983 'E', -- ye resource/equity begin/end flag
2984 'N', -- fund balance account flag
2985 'N', -- ye general flag
2986 'N', -- ye negative receivables flag
2987 'N', -- ye negative payables flag
2988 'N', -- disbursement flag
2989 'N', -- collections flag
2990 'Y', -- ussgl enabled flag
2991 sysdate, -- creation_date
2992 FND_GLOBAL.USER_ID, -- created by
2993 sysdate, -- last update date
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,
3003 TOTAL_RESOURCE_DC_FLAG,
3004 RESOURCE_STATUS_BE_FLAG,
3005 RESOURCE_STATUS_DC_FLAG,
3006 YE_ANTICIPATED_FLAG,
3007 YE_RESOURCE_EQUITY_FLAG,
3008 YE_RESOURCE_EQUITY_BE_FLAG,
3009 FUND_BALANCE_ACCOUNT_FLAG,
3010 YE_GENERAL_FLAG,
3011 YE_NEG_RECEIVABLES_FLAG,
3012 YE_NEG_PAYABLES_FLAG,
3013 DISBURSEMENTS_FLAG,
3014 COLLECTIONS_FLAG,
3015 USSGL_ENABLED_FLAG,
3016 CREATION_DATE,
3017 CREATED_BY,
3018 LAST_UPDATE_DATE,
3019 LAST_UPDATED_BY,
3020 LAST_UPDATE_LOGIN)
3021 VALUES ('1690', -- ussgl account number
3022 'Other Investments', -- description
3023 'D', -- natural balance
3024 '1', -- reporting type
3025 ' ', -- total resource begin/end flag
3026 ' ', -- total resource debit/credit flag
3027 ' ', -- resource status begin//end flag
3028 ' ', -- resource status debit/credit flag
3029 'N', -- ye end anticipated flag
3030 ' ', -- ye resource/equity flag
3031 ' ', -- ye resource/equity begin/end flag
3032 'N', -- fund balance account flag
3033 'N', -- ye general flag
3034 'N', -- ye negative receivables flag
3035 'N', -- ye negative payables flag
3036 'N', -- disbursement flag
3037 'N', -- collections flag
3038 'Y', -- ussgl enabled flag
3039 sysdate, -- creation_date
3040 FND_GLOBAL.USER_ID, -- created by
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,
3050 TOTAL_RESOURCE_DC_FLAG,
3051 RESOURCE_STATUS_BE_FLAG,
3052 RESOURCE_STATUS_DC_FLAG,
3053 YE_ANTICIPATED_FLAG,
3054 YE_RESOURCE_EQUITY_FLAG,
3055 YE_RESOURCE_EQUITY_BE_FLAG,
3056 FUND_BALANCE_ACCOUNT_FLAG,
3057 YE_GENERAL_FLAG,
3058 YE_NEG_RECEIVABLES_FLAG,
3059 YE_NEG_PAYABLES_FLAG,
3060 DISBURSEMENTS_FLAG,
3061 COLLECTIONS_FLAG,
3062 USSGL_ENABLED_FLAG,
3063 CREATION_DATE,
3064 CREATED_BY,
3065 LAST_UPDATE_DATE,
3066 LAST_UPDATED_BY,
3067 LAST_UPDATE_LOGIN)
3068 VALUES ('1711', -- ussgl account number
3069 'Land and Land Rights', -- description
3070 'D', -- natural balance
3074 ' ', -- resource status begin//end flag
3071 '1', -- reporting type
3072 ' ', -- total resource begin/end flag
3073 ' ', -- total resource debit/credit flag
3075 ' ', -- resource status debit/credit flag
3076 'N', -- ye end anticipated flag
3077 ' ', -- ye resource/equity flag
3078 ' ', -- ye resource/equity begin/end flag
3079 'N', -- fund balance account flag
3080 'N', -- ye general flag
3081 'N', -- ye negative receivables flag
3082 'N', -- ye negative payables flag
3083 'N', -- disbursement flag
3084 'N', -- collections flag
3085 'Y', -- ussgl enabled flag
3086 sysdate, -- creation_date
3087 FND_GLOBAL.USER_ID, -- created by
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,
3097 TOTAL_RESOURCE_DC_FLAG,
3098 RESOURCE_STATUS_BE_FLAG,
3099 RESOURCE_STATUS_DC_FLAG,
3100 YE_ANTICIPATED_FLAG,
3101 YE_RESOURCE_EQUITY_FLAG,
3102 YE_RESOURCE_EQUITY_BE_FLAG,
3103 FUND_BALANCE_ACCOUNT_FLAG,
3104 YE_GENERAL_FLAG,
3105 YE_NEG_RECEIVABLES_FLAG,
3106 YE_NEG_PAYABLES_FLAG,
3107 DISBURSEMENTS_FLAG,
3108 COLLECTIONS_FLAG,
3109 USSGL_ENABLED_FLAG,
3110 CREATION_DATE,
3111 CREATED_BY,
3112 LAST_UPDATE_DATE,
3113 LAST_UPDATED_BY,
3114 LAST_UPDATE_LOGIN)
3115 VALUES ('1712', -- ussgl account number
3116 'Improvements to Land', -- description
3117 'D', -- natural balance
3118 '1', -- reporting type
3119 ' ', -- total resource begin/end flag
3120 ' ', -- total resource debit/credit flag
3121 ' ', -- resource status begin//end flag
3122 ' ', -- resource status debit/credit flag
3123 'N', -- ye end anticipated flag
3124 ' ', -- ye resource/equity flag
3125 ' ', -- ye resource/equity begin/end flag
3126 'N', -- fund balance account flag
3127 'N', -- ye general flag
3128 'N', -- ye negative receivables flag
3129 'N', -- ye negative payables flag
3130 'N', -- disbursement flag
3131 'N', -- collections flag
3132 'Y', -- ussgl enabled flag
3133 sysdate, -- creation_date
3134 FND_GLOBAL.USER_ID, -- created by
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,
3144 TOTAL_RESOURCE_DC_FLAG,
3145 RESOURCE_STATUS_BE_FLAG,
3146 RESOURCE_STATUS_DC_FLAG,
3147 YE_ANTICIPATED_FLAG,
3148 YE_RESOURCE_EQUITY_FLAG,
3149 YE_RESOURCE_EQUITY_BE_FLAG,
3150 FUND_BALANCE_ACCOUNT_FLAG,
3151 YE_GENERAL_FLAG,
3152 YE_NEG_RECEIVABLES_FLAG,
3153 YE_NEG_PAYABLES_FLAG,
3154 DISBURSEMENTS_FLAG,
3155 COLLECTIONS_FLAG,
3156 USSGL_ENABLED_FLAG,
3157 CREATION_DATE,
3158 CREATED_BY,
3159 LAST_UPDATE_DATE,
3160 LAST_UPDATED_BY,
3161 LAST_UPDATE_LOGIN)
3162 VALUES ('1719', -- ussgl account number
3163 'Accumulated Depreciation on Improvements to Land', -- description
3164 'C', -- natural balance
3165 '1', -- reporting type
3166 ' ', -- total resource begin/end flag
3167 ' ', -- total resource debit/credit flag
3168 ' ', -- resource status begin//end flag
3169 ' ', -- resource status debit/credit flag
3170 'N', -- ye end anticipated flag
3171 ' ', -- ye resource/equity flag
3172 ' ', -- ye resource/equity begin/end flag
3173 'N', -- fund balance account flag
3174 'N', -- ye general flag
3175 'N', -- ye negative receivables flag
3176 'N', -- ye negative payables flag
3177 'N', -- disbursement flag
3178 'N', -- collections flag
3179 'Y', -- ussgl enabled flag
3180 sysdate, -- creation_date
3181 FND_GLOBAL.USER_ID, -- created by
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,
3191 TOTAL_RESOURCE_DC_FLAG,
3192 RESOURCE_STATUS_BE_FLAG,
3193 RESOURCE_STATUS_DC_FLAG,
3194 YE_ANTICIPATED_FLAG,
3195 YE_RESOURCE_EQUITY_FLAG,
3196 YE_RESOURCE_EQUITY_BE_FLAG,
3197 FUND_BALANCE_ACCOUNT_FLAG,
3198 YE_GENERAL_FLAG,
3199 YE_NEG_RECEIVABLES_FLAG,
3200 YE_NEG_PAYABLES_FLAG,
3201 DISBURSEMENTS_FLAG,
3202 COLLECTIONS_FLAG,
3203 USSGL_ENABLED_FLAG,
3204 CREATION_DATE,
3205 CREATED_BY,
3206 LAST_UPDATE_DATE,
3207 LAST_UPDATED_BY,
3208 LAST_UPDATE_LOGIN)
3209 VALUES ('1720', -- ussgl account number
3210 'Construction-in-Progress', -- description
3211 'D', -- natural balance
3212 '1', -- reporting type
3213 ' ', -- total resource begin/end flag
3217 'N', -- ye end anticipated flag
3214 ' ', -- total resource debit/credit flag
3215 ' ', -- resource status begin//end flag
3216 ' ', -- resource status debit/credit flag
3218 ' ', -- ye resource/equity flag
3219 ' ', -- ye resource/equity begin/end flag
3220 'N', -- fund balance account flag
3221 'N', -- ye general flag
3222 'N', -- ye negative receivables flag
3223 'N', -- ye negative payables flag
3224 'N', -- disbursement flag
3225 'N', -- collections flag
3226 'Y', -- ussgl enabled flag
3227 sysdate, -- creation_date
3228 FND_GLOBAL.USER_ID, -- created by
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,
3238 TOTAL_RESOURCE_DC_FLAG,
3239 RESOURCE_STATUS_BE_FLAG,
3240 RESOURCE_STATUS_DC_FLAG,
3241 YE_ANTICIPATED_FLAG,
3242 YE_RESOURCE_EQUITY_FLAG,
3243 YE_RESOURCE_EQUITY_BE_FLAG,
3244 FUND_BALANCE_ACCOUNT_FLAG,
3245 YE_GENERAL_FLAG,
3246 YE_NEG_RECEIVABLES_FLAG,
3247 YE_NEG_PAYABLES_FLAG,
3248 DISBURSEMENTS_FLAG,
3249 COLLECTIONS_FLAG,
3250 USSGL_ENABLED_FLAG,
3251 CREATION_DATE,
3252 CREATED_BY,
3253 LAST_UPDATE_DATE,
3254 LAST_UPDATED_BY,
3255 LAST_UPDATE_LOGIN)
3256 VALUES ('1730', -- ussgl account number
3257 'Buildings, Improvements and Renovations', -- description
3258 'D', -- natural balance
3259 '1', -- reporting type
3260 ' ', -- total resource begin/end flag
3261 ' ', -- total resource debit/credit flag
3262 ' ', -- resource status begin//end flag
3263 ' ', -- resource status debit/credit flag
3264 'N', -- ye end anticipated flag
3265 ' ', -- ye resource/equity flag
3266 ' ', -- ye resource/equity begin/end flag
3267 'N', -- fund balance account flag
3268 'N', -- ye general flag
3269 'N', -- ye negative receivables flag
3270 'N', -- ye negative payables flag
3271 'N', -- disbursement flag
3272 'N', -- collections flag
3273 'Y', -- ussgl enabled flag
3274 sysdate, -- creation_date
3275 FND_GLOBAL.USER_ID, -- created by
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,
3285 TOTAL_RESOURCE_DC_FLAG,
3286 RESOURCE_STATUS_BE_FLAG,
3287 RESOURCE_STATUS_DC_FLAG,
3288 YE_ANTICIPATED_FLAG,
3289 YE_RESOURCE_EQUITY_FLAG,
3290 YE_RESOURCE_EQUITY_BE_FLAG,
3291 FUND_BALANCE_ACCOUNT_FLAG,
3292 YE_GENERAL_FLAG,
3293 YE_NEG_RECEIVABLES_FLAG,
3294 YE_NEG_PAYABLES_FLAG,
3295 DISBURSEMENTS_FLAG,
3296 COLLECTIONS_FLAG,
3297 USSGL_ENABLED_FLAG,
3298 CREATION_DATE,
3299 CREATED_BY,
3300 LAST_UPDATE_DATE,
3301 LAST_UPDATED_BY,
3302 LAST_UPDATE_LOGIN)
3303 VALUES ('1739', -- ussgl account number
3304 'Accumulated Depreciation on Buildings, Improvements and Renovations', -- description
3305 'C', -- natural balance
3306 '1', -- reporting type
3307 ' ', -- total resource begin/end flag
3308 ' ', -- total resource debit/credit flag
3309 ' ', -- resource status begin//end flag
3310 ' ', -- resource status debit/credit flag
3311 'N', -- ye end anticipated flag
3312 ' ', -- ye resource/equity flag
3313 ' ', -- ye resource/equity begin/end flag
3314 'N', -- fund balance account flag
3315 'N', -- ye general flag
3316 'N', -- ye negative receivables flag
3317 'N', -- ye negative payables flag
3318 'N', -- disbursement flag
3319 'N', -- collections flag
3320 'Y', -- ussgl enabled flag
3321 sysdate, -- creation_date
3322 FND_GLOBAL.USER_ID, -- created by
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,
3332 TOTAL_RESOURCE_DC_FLAG,
3333 RESOURCE_STATUS_BE_FLAG,
3334 RESOURCE_STATUS_DC_FLAG,
3335 YE_ANTICIPATED_FLAG,
3336 YE_RESOURCE_EQUITY_FLAG,
3337 YE_RESOURCE_EQUITY_BE_FLAG,
3338 FUND_BALANCE_ACCOUNT_FLAG,
3339 YE_GENERAL_FLAG,
3340 YE_NEG_RECEIVABLES_FLAG,
3341 YE_NEG_PAYABLES_FLAG,
3342 DISBURSEMENTS_FLAG,
3343 COLLECTIONS_FLAG,
3344 USSGL_ENABLED_FLAG,
3345 CREATION_DATE,
3346 CREATED_BY,
3347 LAST_UPDATE_DATE,
3348 LAST_UPDATED_BY,
3349 LAST_UPDATE_LOGIN)
3350 VALUES ('1740', -- ussgl account number
3351 'Other Structures and Facilities', -- description
3352 'D', -- natural balance
3353 '1', -- reporting type
3354 ' ', -- total resource begin/end flag
3355 ' ', -- total resource debit/credit flag
3359 ' ', -- ye resource/equity flag
3356 ' ', -- resource status begin//end flag
3357 ' ', -- resource status debit/credit flag
3358 'N', -- ye end anticipated flag
3360 ' ', -- ye resource/equity begin/end flag
3361 'N', -- fund balance account flag
3362 'N', -- ye general flag
3363 'N', -- ye negative receivables flag
3364 'N', -- ye negative payables flag
3365 'N', -- disbursement flag
3366 'N', -- collections flag
3367 'Y', -- ussgl enabled flag
3368 sysdate, -- creation_date
3369 FND_GLOBAL.USER_ID, -- created by
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,
3379 TOTAL_RESOURCE_DC_FLAG,
3380 RESOURCE_STATUS_BE_FLAG,
3381 RESOURCE_STATUS_DC_FLAG,
3382 YE_ANTICIPATED_FLAG,
3383 YE_RESOURCE_EQUITY_FLAG,
3384 YE_RESOURCE_EQUITY_BE_FLAG,
3385 FUND_BALANCE_ACCOUNT_FLAG,
3386 YE_GENERAL_FLAG,
3387 YE_NEG_RECEIVABLES_FLAG,
3388 YE_NEG_PAYABLES_FLAG,
3389 DISBURSEMENTS_FLAG,
3390 COLLECTIONS_FLAG,
3391 USSGL_ENABLED_FLAG,
3392 CREATION_DATE,
3393 CREATED_BY,
3394 LAST_UPDATE_DATE,
3395 LAST_UPDATED_BY,
3396 LAST_UPDATE_LOGIN)
3397 VALUES ('1749', -- ussgl account number
3398 'Accumulated Depreciation on Other Structures and Facilities', -- description
3399 'C', -- natural balance
3400 '1', -- reporting type
3401 ' ', -- total resource begin/end flag
3402 ' ', -- total resource debit/credit flag
3403 ' ', -- resource status begin//end flag
3404 ' ', -- resource status debit/credit flag
3405 'N', -- ye end anticipated flag
3406 ' ', -- ye resource/equity flag
3407 ' ', -- ye resource/equity begin/end flag
3408 'N', -- fund balance account flag
3409 'N', -- ye general flag
3410 'N', -- ye negative receivables flag
3411 'N', -- ye negative payables flag
3412 'N', -- disbursement flag
3413 'N', -- collections flag
3414 'Y', -- ussgl enabled flag
3415 sysdate, -- creation_date
3416 FND_GLOBAL.USER_ID, -- created by
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,
3426 TOTAL_RESOURCE_DC_FLAG,
3427 RESOURCE_STATUS_BE_FLAG,
3428 RESOURCE_STATUS_DC_FLAG,
3429 YE_ANTICIPATED_FLAG,
3430 YE_RESOURCE_EQUITY_FLAG,
3431 YE_RESOURCE_EQUITY_BE_FLAG,
3432 FUND_BALANCE_ACCOUNT_FLAG,
3433 YE_GENERAL_FLAG,
3434 YE_NEG_RECEIVABLES_FLAG,
3435 YE_NEG_PAYABLES_FLAG,
3436 DISBURSEMENTS_FLAG,
3437 COLLECTIONS_FLAG,
3438 USSGL_ENABLED_FLAG,
3439 CREATION_DATE,
3440 CREATED_BY,
3441 LAST_UPDATE_DATE,
3442 LAST_UPDATED_BY,
3443 LAST_UPDATE_LOGIN)
3444 VALUES ('1750', -- ussgl account number
3445 'Equipment', -- description
3446 'D', -- natural balance
3447 '1', -- reporting type
3448 ' ', -- total resource begin/end flag
3449 ' ', -- total resource debit/credit flag
3450 ' ', -- resource status begin//end flag
3451 ' ', -- resource status debit/credit flag
3452 'N', -- ye end anticipated flag
3453 ' ', -- ye resource/equity flag
3454 ' ', -- ye resource/equity begin/end flag
3455 'N', -- fund balance account flag
3456 'N', -- ye general flag
3457 'N', -- ye negative receivables flag
3458 'N', -- ye negative payables flag
3459 'N', -- disbursement flag
3460 'N', -- collections flag
3461 'Y', -- ussgl enabled flag
3462 sysdate, -- creation_date
3463 FND_GLOBAL.USER_ID, -- created by
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,
3473 TOTAL_RESOURCE_DC_FLAG,
3474 RESOURCE_STATUS_BE_FLAG,
3475 RESOURCE_STATUS_DC_FLAG,
3476 YE_ANTICIPATED_FLAG,
3477 YE_RESOURCE_EQUITY_FLAG,
3478 YE_RESOURCE_EQUITY_BE_FLAG,
3479 FUND_BALANCE_ACCOUNT_FLAG,
3480 YE_GENERAL_FLAG,
3481 YE_NEG_RECEIVABLES_FLAG,
3482 YE_NEG_PAYABLES_FLAG,
3483 DISBURSEMENTS_FLAG,
3484 COLLECTIONS_FLAG,
3485 USSGL_ENABLED_FLAG,
3486 CREATION_DATE,
3487 CREATED_BY,
3488 LAST_UPDATE_DATE,
3489 LAST_UPDATED_BY,
3490 LAST_UPDATE_LOGIN)
3491 VALUES ('1759', -- ussgl account number
3492 'Accumulated Depreciation on Equipment', -- description
3493 'C', -- natural balance
3494 '1', -- reporting type
3495 ' ', -- total resource begin/end flag
3496 ' ', -- total resource debit/credit flag
3497 ' ', -- resource status begin//end flag
3501 ' ', -- ye resource/equity begin/end flag
3498 ' ', -- resource status debit/credit flag
3499 'N', -- ye end anticipated flag
3500 ' ', -- ye resource/equity flag
3502 'N', -- fund balance account flag
3503 'N', -- ye general flag
3504 'N', -- ye negative receivables flag
3505 'N', -- ye negative payables flag
3506 'N', -- disbursement flag
3507 'N', -- collections flag
3508 'Y', -- ussgl enabled flag
3509 sysdate, -- creation_date
3510 FND_GLOBAL.USER_ID, -- created by
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,
3520 TOTAL_RESOURCE_DC_FLAG,
3521 RESOURCE_STATUS_BE_FLAG,
3522 RESOURCE_STATUS_DC_FLAG,
3523 YE_ANTICIPATED_FLAG,
3524 YE_RESOURCE_EQUITY_FLAG,
3525 YE_RESOURCE_EQUITY_BE_FLAG,
3526 FUND_BALANCE_ACCOUNT_FLAG,
3527 YE_GENERAL_FLAG,
3528 YE_NEG_RECEIVABLES_FLAG,
3529 YE_NEG_PAYABLES_FLAG,
3530 DISBURSEMENTS_FLAG,
3531 COLLECTIONS_FLAG,
3532 USSGL_ENABLED_FLAG,
3533 CREATION_DATE,
3534 CREATED_BY,
3535 LAST_UPDATE_DATE,
3536 LAST_UPDATED_BY,
3537 LAST_UPDATE_LOGIN)
3538 VALUES ('1810', -- ussgl account number
3539 'Assets Under Capital Lease', -- description
3540 'D', -- natural balance
3541 '1', -- reporting type
3542 ' ', -- total resource begin/end flag
3543 ' ', -- total resource debit/credit flag
3544 ' ', -- resource status begin//end flag
3545 ' ', -- resource status debit/credit flag
3546 'N', -- ye end anticipated flag
3547 ' ', -- ye resource/equity flag
3548 ' ', -- ye resource/equity begin/end flag
3549 'N', -- fund balance account flag
3550 'N', -- ye general flag
3551 'N', -- ye negative receivables flag
3552 'N', -- ye negative payables flag
3553 'N', -- disbursement flag
3554 'N', -- collections flag
3555 'Y', -- ussgl enabled flag
3556 sysdate, -- creation_date
3557 FND_GLOBAL.USER_ID, -- created by
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,
3567 TOTAL_RESOURCE_DC_FLAG,
3568 RESOURCE_STATUS_BE_FLAG,
3569 RESOURCE_STATUS_DC_FLAG,
3570 YE_ANTICIPATED_FLAG,
3571 YE_RESOURCE_EQUITY_FLAG,
3572 YE_RESOURCE_EQUITY_BE_FLAG,
3573 FUND_BALANCE_ACCOUNT_FLAG,
3574 YE_GENERAL_FLAG,
3575 YE_NEG_RECEIVABLES_FLAG,
3576 YE_NEG_PAYABLES_FLAG,
3577 DISBURSEMENTS_FLAG,
3578 COLLECTIONS_FLAG,
3579 USSGL_ENABLED_FLAG,
3580 CREATION_DATE,
3581 CREATED_BY,
3582 LAST_UPDATE_DATE,
3583 LAST_UPDATED_BY,
3584 LAST_UPDATE_LOGIN)
3585 VALUES ('1819', -- ussgl account number
3586 'Accumulated Depreciation on Assets Under Capital Lease', -- description
3587 'C', -- natural balance
3588 '1', -- reporting type
3589 ' ', -- total resource begin/end flag
3590 ' ', -- total resource debit/credit flag
3591 ' ', -- resource status begin//end flag
3592 ' ', -- resource status debit/credit flag
3593 'N', -- ye end anticipated flag
3594 ' ', -- ye resource/equity flag
3595 ' ', -- ye resource/equity begin/end flag
3596 'N', -- fund balance account flag
3597 'N', -- ye general flag
3598 'N', -- ye negative receivables flag
3599 'N', -- ye negative payables flag
3600 'N', -- disbursement flag
3601 'N', -- collections flag
3602 'Y', -- ussgl enabled flag
3603 sysdate, -- creation_date
3604 FND_GLOBAL.USER_ID, -- created by
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,
3614 TOTAL_RESOURCE_DC_FLAG,
3615 RESOURCE_STATUS_BE_FLAG,
3616 RESOURCE_STATUS_DC_FLAG,
3617 YE_ANTICIPATED_FLAG,
3618 YE_RESOURCE_EQUITY_FLAG,
3619 YE_RESOURCE_EQUITY_BE_FLAG,
3620 FUND_BALANCE_ACCOUNT_FLAG,
3621 YE_GENERAL_FLAG,
3622 YE_NEG_RECEIVABLES_FLAG,
3623 YE_NEG_PAYABLES_FLAG,
3624 DISBURSEMENTS_FLAG,
3625 COLLECTIONS_FLAG,
3626 USSGL_ENABLED_FLAG,
3627 CREATION_DATE,
3628 CREATED_BY,
3629 LAST_UPDATE_DATE,
3630 LAST_UPDATED_BY,
3631 LAST_UPDATE_LOGIN)
3632 VALUES ('1820', -- ussgl account number
3633 'Leasehold Improvements', -- description
3634 'D', -- natural balance
3635 '1', -- reporting type
3636 ' ', -- total resource begin/end flag
3637 ' ', -- total resource debit/credit flag
3638 ' ', -- resource status begin//end flag
3639 ' ', -- resource status debit/credit flag
3643 'N', -- fund balance account flag
3640 'N', -- ye end anticipated flag
3641 ' ', -- ye resource/equity flag
3642 ' ', -- ye resource/equity begin/end flag
3644 'N', -- ye general flag
3645 'N', -- ye negative receivables flag
3646 'N', -- ye negative payables flag
3647 'N', -- disbursement flag
3648 'N', -- collections flag
3649 'Y', -- ussgl enabled flag
3650 sysdate, -- creation_date
3651 FND_GLOBAL.USER_ID, -- created by
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,
3661 TOTAL_RESOURCE_DC_FLAG,
3662 RESOURCE_STATUS_BE_FLAG,
3663 RESOURCE_STATUS_DC_FLAG,
3664 YE_ANTICIPATED_FLAG,
3665 YE_RESOURCE_EQUITY_FLAG,
3666 YE_RESOURCE_EQUITY_BE_FLAG,
3667 FUND_BALANCE_ACCOUNT_FLAG,
3668 YE_GENERAL_FLAG,
3669 YE_NEG_RECEIVABLES_FLAG,
3670 YE_NEG_PAYABLES_FLAG,
3671 DISBURSEMENTS_FLAG,
3672 COLLECTIONS_FLAG,
3673 USSGL_ENABLED_FLAG,
3674 CREATION_DATE,
3675 CREATED_BY,
3676 LAST_UPDATE_DATE,
3677 LAST_UPDATED_BY,
3678 LAST_UPDATE_LOGIN)
3679 VALUES ('1829', -- ussgl account number
3680 'Accumulated Amortization on Leasehold Improvements', -- description
3681 'C', -- natural balance
3682 '1', -- reporting type
3683 ' ', -- total resource begin/end flag
3684 ' ', -- total resource debit/credit flag
3685 ' ', -- resource status begin//end flag
3686 ' ', -- resource status debit/credit flag
3687 'N', -- ye end anticipated flag
3688 ' ', -- ye resource/equity flag
3689 ' ', -- ye resource/equity begin/end flag
3690 'N', -- fund balance account flag
3691 'N', -- ye general flag
3692 'N', -- ye negative receivables flag
3693 'N', -- ye negative payables flag
3694 'N', -- disbursement flag
3695 'N', -- collections flag
3696 'Y', -- ussgl enabled flag
3697 sysdate, -- creation_date
3698 FND_GLOBAL.USER_ID, -- created by
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,
3708 TOTAL_RESOURCE_DC_FLAG,
3709 RESOURCE_STATUS_BE_FLAG,
3710 RESOURCE_STATUS_DC_FLAG,
3711 YE_ANTICIPATED_FLAG,
3712 YE_RESOURCE_EQUITY_FLAG,
3713 YE_RESOURCE_EQUITY_BE_FLAG,
3714 FUND_BALANCE_ACCOUNT_FLAG,
3715 YE_GENERAL_FLAG,
3716 YE_NEG_RECEIVABLES_FLAG,
3717 YE_NEG_PAYABLES_FLAG,
3718 DISBURSEMENTS_FLAG,
3719 COLLECTIONS_FLAG,
3720 USSGL_ENABLED_FLAG,
3721 CREATION_DATE,
3722 CREATED_BY,
3723 LAST_UPDATE_DATE,
3724 LAST_UPDATED_BY,
3725 LAST_UPDATE_LOGIN)
3726 VALUES ('1830', -- ussgl account number
3727 'Internal Use Software', -- description
3728 'D', -- natural balance
3729 '1', -- reporting type
3730 ' ', -- total resource begin/end flag
3731 ' ', -- total resource debit/credit flag
3732 ' ', -- resource status begin//end flag
3733 ' ', -- resource status debit/credit flag
3734 'N', -- ye end anticipated flag
3735 ' ', -- ye resource/equity flag
3736 ' ', -- ye resource/equity begin/end flag
3737 'N', -- fund balance account flag
3738 'N', -- ye general flag
3739 'N', -- ye negative receivables flag
3740 'N', -- ye negative payables flag
3741 'N', -- disbursement flag
3742 'N', -- collections flag
3743 'Y', -- ussgl enabled flag
3744 sysdate, -- creation_date
3745 FND_GLOBAL.USER_ID, -- created by
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,
3755 TOTAL_RESOURCE_DC_FLAG,
3756 RESOURCE_STATUS_BE_FLAG,
3757 RESOURCE_STATUS_DC_FLAG,
3758 YE_ANTICIPATED_FLAG,
3759 YE_RESOURCE_EQUITY_FLAG,
3760 YE_RESOURCE_EQUITY_BE_FLAG,
3761 FUND_BALANCE_ACCOUNT_FLAG,
3762 YE_GENERAL_FLAG,
3763 YE_NEG_RECEIVABLES_FLAG,
3764 YE_NEG_PAYABLES_FLAG,
3765 DISBURSEMENTS_FLAG,
3766 COLLECTIONS_FLAG,
3767 USSGL_ENABLED_FLAG,
3768 CREATION_DATE,
3769 CREATED_BY,
3770 LAST_UPDATE_DATE,
3771 LAST_UPDATED_BY,
3772 LAST_UPDATE_LOGIN)
3773 VALUES ('1832', -- ussgl account number
3774 'Internal Use Software in Development', -- description
3775 'D', -- natural balance
3776 '1', -- reporting type
3777 ' ', -- total resource begin/end flag
3778 ' ', -- total resource debit/credit flag
3779 ' ', -- resource status begin//end flag
3780 ' ', -- resource status debit/credit flag
3781 'N', -- ye end anticipated flag
3785 'N', -- ye general flag
3782 ' ', -- ye resource/equity flag
3783 ' ', -- ye resource/equity begin/end flag
3784 'N', -- fund balance account flag
3786 'N', -- ye negative receivables flag
3787 'N', -- ye negative payables flag
3788 'N', -- disbursement flag
3789 'N', -- collections flag
3790 'Y', -- ussgl enabled flag
3791 sysdate, -- creation_date
3792 FND_GLOBAL.USER_ID, -- created by
3793 sysdate, -- last update date
3794 FND_GLOBAL.USER_ID, -- last updated by
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,
3804 TOTAL_RESOURCE_DC_FLAG,
3805 RESOURCE_STATUS_BE_FLAG,
3806 RESOURCE_STATUS_DC_FLAG,
3807 YE_ANTICIPATED_FLAG,
3808 YE_RESOURCE_EQUITY_FLAG,
3809 YE_RESOURCE_EQUITY_BE_FLAG,
3810 FUND_BALANCE_ACCOUNT_FLAG,
3811 YE_GENERAL_FLAG,
3812 YE_NEG_RECEIVABLES_FLAG,
3813 YE_NEG_PAYABLES_FLAG,
3814 DISBURSEMENTS_FLAG,
3815 COLLECTIONS_FLAG,
3816 USSGL_ENABLED_FLAG,
3817 CREATION_DATE,
3818 CREATED_BY,
3819 LAST_UPDATE_DATE,
3820 LAST_UPDATED_BY,
3821 LAST_UPDATE_LOGIN)
3822 VALUES ('1839', -- ussgl account number
3823 'Accumulated Amortization on Internal Use Software', -- description
3824 'C', -- natural balance
3825 '1', -- reporting type
3826 ' ', -- total resource begin/end flag
3827 ' ', -- total resource debit/credit flag
3828 ' ', -- resource status begin//end flag
3829 ' ', -- resource status debit/credit flag
3830 'N', -- ye end anticipated flag
3831 ' ', -- ye resource/equity flag
3832 ' ', -- ye resource/equity begin/end flag
3833 'N', -- fund balance account flag
3834 'N', -- ye general flag
3835 'N', -- ye negative receivables flag
3836 'N', -- ye negative payables flag
3837 'N', -- disbursement flag
3838 'N', -- collections flag
3839 'Y', -- ussgl enabled flag
3840 sysdate, -- creation_date
3841 FND_GLOBAL.USER_ID, -- created by
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,
3851 TOTAL_RESOURCE_DC_FLAG,
3852 RESOURCE_STATUS_BE_FLAG,
3853 RESOURCE_STATUS_DC_FLAG,
3854 YE_ANTICIPATED_FLAG,
3855 YE_RESOURCE_EQUITY_FLAG,
3856 YE_RESOURCE_EQUITY_BE_FLAG,
3857 FUND_BALANCE_ACCOUNT_FLAG,
3858 YE_GENERAL_FLAG,
3859 YE_NEG_RECEIVABLES_FLAG,
3860 YE_NEG_PAYABLES_FLAG,
3861 DISBURSEMENTS_FLAG,
3862 COLLECTIONS_FLAG,
3863 USSGL_ENABLED_FLAG,
3864 CREATION_DATE,
3865 CREATED_BY,
3866 LAST_UPDATE_DATE,
3867 LAST_UPDATED_BY,
3868 LAST_UPDATE_LOGIN)
3869 VALUES ('1840', -- ussgl account number
3870 'Other Natural Resources', -- description
3871 'D', -- natural balance
3872 '1', -- reporting type
3873 ' ', -- total resource begin/end flag
3874 ' ', -- total resource debit/credit flag
3875 ' ', -- resource status begin//end flag
3876 ' ', -- resource status debit/credit flag
3877 'N', -- ye end anticipated flag
3878 ' ', -- ye resource/equity flag
3879 ' ', -- ye resource/equity begin/end flag
3880 'N', -- fund balance account flag
3881 'N', -- ye general flag
3882 'N', -- ye negative receivables flag
3883 'N', -- ye negative payables flag
3884 'N', -- disbursement flag
3885 'N', -- collections flag
3886 'Y', -- ussgl enabled flag
3887 sysdate, -- creation_date
3888 FND_GLOBAL.USER_ID, -- created by
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,
3898 TOTAL_RESOURCE_DC_FLAG,
3899 RESOURCE_STATUS_BE_FLAG,
3900 RESOURCE_STATUS_DC_FLAG,
3901 YE_ANTICIPATED_FLAG,
3902 YE_RESOURCE_EQUITY_FLAG,
3903 YE_RESOURCE_EQUITY_BE_FLAG,
3904 FUND_BALANCE_ACCOUNT_FLAG,
3905 YE_GENERAL_FLAG,
3906 YE_NEG_RECEIVABLES_FLAG,
3907 YE_NEG_PAYABLES_FLAG,
3908 DISBURSEMENTS_FLAG,
3909 COLLECTIONS_FLAG,
3910 USSGL_ENABLED_FLAG,
3911 CREATION_DATE,
3912 CREATED_BY,
3913 LAST_UPDATE_DATE,
3914 LAST_UPDATED_BY,
3915 LAST_UPDATE_LOGIN)
3916 VALUES ('1849', -- ussgl account number
3917 'Allowance for Depletion', -- description
3918 'C', -- natural balance
3919 '1', -- reporting type
3920 ' ', -- total resource begin/end flag
3921 ' ', -- total resource debit/credit flag
3922 ' ', -- resource status begin//end flag
3923 ' ', -- resource status debit/credit flag
3924 'N', -- ye end anticipated flag
3925 ' ', -- ye resource/equity flag
3929 'N', -- ye negative receivables flag
3926 ' ', -- ye resource/equity begin/end flag
3927 'N', -- fund balance account flag
3928 'N', -- ye general flag
3930 'N', -- ye negative payables flag
3931 'N', -- disbursement flag
3932 'N', -- collections flag
3933 'Y', -- ussgl enabled flag
3934 sysdate, -- creation_date
3935 FND_GLOBAL.USER_ID, -- created by
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,
3945 TOTAL_RESOURCE_DC_FLAG,
3946 RESOURCE_STATUS_BE_FLAG,
3947 RESOURCE_STATUS_DC_FLAG,
3948 YE_ANTICIPATED_FLAG,
3949 YE_RESOURCE_EQUITY_FLAG,
3950 YE_RESOURCE_EQUITY_BE_FLAG,
3951 FUND_BALANCE_ACCOUNT_FLAG,
3952 YE_GENERAL_FLAG,
3953 YE_NEG_RECEIVABLES_FLAG,
3954 YE_NEG_PAYABLES_FLAG,
3955 DISBURSEMENTS_FLAG,
3956 COLLECTIONS_FLAG,
3957 USSGL_ENABLED_FLAG,
3958 CREATION_DATE,
3959 CREATED_BY,
3960 LAST_UPDATE_DATE,
3961 LAST_UPDATED_BY,
3962 LAST_UPDATE_LOGIN)
3963 VALUES ('1890', -- ussgl account number
3964 'Other General Property, Plant and Equipment', -- description
3965 'D', -- natural balance
3966 '1', -- reporting type
3967 ' ', -- total resource begin/end flag
3968 ' ', -- total resource debit/credit flag
3969 ' ', -- resource status begin//end flag
3970 ' ', -- resource status debit/credit flag
3971 'N', -- ye end anticipated flag
3972 ' ', -- ye resource/equity flag
3973 ' ', -- ye resource/equity begin/end flag
3974 'N', -- fund balance account flag
3975 'N', -- ye general flag
3976 'N', -- ye negative receivables flag
3977 'N', -- ye negative payables flag
3978 'N', -- disbursement flag
3979 'N', -- collections flag
3980 'Y', -- ussgl enabled flag
3981 sysdate, -- creation_date
3982 FND_GLOBAL.USER_ID, -- created by
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,
3992 TOTAL_RESOURCE_DC_FLAG,
3993 RESOURCE_STATUS_BE_FLAG,
3994 RESOURCE_STATUS_DC_FLAG,
3995 YE_ANTICIPATED_FLAG,
3996 YE_RESOURCE_EQUITY_FLAG,
3997 YE_RESOURCE_EQUITY_BE_FLAG,
3998 FUND_BALANCE_ACCOUNT_FLAG,
3999 YE_GENERAL_FLAG,
4000 YE_NEG_RECEIVABLES_FLAG,
4001 YE_NEG_PAYABLES_FLAG,
4002 DISBURSEMENTS_FLAG,
4003 COLLECTIONS_FLAG,
4004 USSGL_ENABLED_FLAG,
4005 CREATION_DATE,
4006 CREATED_BY,
4007 LAST_UPDATE_DATE,
4008 LAST_UPDATED_BY,
4009 LAST_UPDATE_LOGIN)
4010 VALUES ('1920', -- ussgl account number
4011 'Unrequisitioned Authorized Appropriations', -- description
4012 'D', -- natural balance
4013 '1', -- reporting type
4014 ' ', -- total resource begin/end flag
4015 ' ', -- total resource debit/credit flag
4016 ' ', -- resource status begin//end flag
4017 ' ', -- resource status debit/credit flag
4018 'N', -- ye end anticipated flag
4019 ' ', -- ye resource/equity flag
4020 ' ', -- ye resource/equity begin/end flag
4021 'N', -- fund balance account flag
4022 'N', -- ye general flag
4023 'N', -- ye negative receivables flag
4024 'N', -- ye negative payables flag
4025 'N', -- disbursement flag
4026 'N', -- collections flag
4027 'Y', -- ussgl enabled flag
4028 sysdate, -- creation_date
4029 FND_GLOBAL.USER_ID, -- created by
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,
4039 TOTAL_RESOURCE_DC_FLAG,
4040 RESOURCE_STATUS_BE_FLAG,
4041 RESOURCE_STATUS_DC_FLAG,
4042 YE_ANTICIPATED_FLAG,
4043 YE_RESOURCE_EQUITY_FLAG,
4044 YE_RESOURCE_EQUITY_BE_FLAG,
4045 FUND_BALANCE_ACCOUNT_FLAG,
4046 YE_GENERAL_FLAG,
4047 YE_NEG_RECEIVABLES_FLAG,
4048 YE_NEG_PAYABLES_FLAG,
4049 DISBURSEMENTS_FLAG,
4050 COLLECTIONS_FLAG,
4051 USSGL_ENABLED_FLAG,
4052 CREATION_DATE,
4053 CREATED_BY,
4054 LAST_UPDATE_DATE,
4055 LAST_UPDATED_BY,
4056 LAST_UPDATE_LOGIN)
4057 VALUES ('1921', -- ussgl account number
4058 'Receivable Appropriations', -- description
4059 'D', -- natural balance
4060 '1', -- reporting type
4061 ' ', -- total resource begin/end flag
4062 ' ', -- total resource debit/credit flag
4063 ' ', -- resource status begin//end flag
4064 ' ', -- resource status debit/credit flag
4065 'N', -- ye end anticipated flag
4066 ' ', -- ye resource/equity flag
4067 ' ', -- ye resource/equity begin/end flag
4071 'N', -- ye negative payables flag
4068 'N', -- fund balance account flag
4069 'N', -- ye general flag
4070 'N', -- ye negative receivables flag
4072 'N', -- disbursement flag
4073 'N', -- collections flag
4074 'Y', -- ussgl enabled flag
4075 sysdate, -- creation_date
4076 FND_GLOBAL.USER_ID, -- created by
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,
4086 TOTAL_RESOURCE_DC_FLAG,
4087 RESOURCE_STATUS_BE_FLAG,
4088 RESOURCE_STATUS_DC_FLAG,
4089 YE_ANTICIPATED_FLAG,
4090 YE_RESOURCE_EQUITY_FLAG,
4091 YE_RESOURCE_EQUITY_BE_FLAG,
4092 FUND_BALANCE_ACCOUNT_FLAG,
4093 YE_GENERAL_FLAG,
4094 YE_NEG_RECEIVABLES_FLAG,
4095 YE_NEG_PAYABLES_FLAG,
4096 DISBURSEMENTS_FLAG,
4097 COLLECTIONS_FLAG,
4098 USSGL_ENABLED_FLAG,
4099 CREATION_DATE,
4100 CREATED_BY,
4101 LAST_UPDATE_DATE,
4102 LAST_UPDATED_BY,
4103 LAST_UPDATE_LOGIN)
4104 VALUES ('1990', -- ussgl account number
4105 'Other Assets', -- description
4106 'D', -- natural balance
4107 '1', -- reporting type
4108 ' ', -- total resource begin/end flag
4109 ' ', -- total resource debit/credit flag
4110 ' ', -- resource status begin//end flag
4111 ' ', -- resource status debit/credit flag
4112 'N', -- ye end anticipated flag
4113 ' ', -- ye resource/equity flag
4114 ' ', -- ye resource/equity begin/end flag
4115 'N', -- fund balance account flag
4116 'N', -- ye general flag
4117 'N', -- ye negative receivables flag
4118 'N', -- ye negative payables flag
4119 'N', -- disbursement flag
4120 'N', -- collections flag
4121 'Y', -- ussgl enabled flag
4122 sysdate, -- creation_date
4123 FND_GLOBAL.USER_ID, -- created by
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,
4133 TOTAL_RESOURCE_DC_FLAG,
4134 RESOURCE_STATUS_BE_FLAG,
4135 RESOURCE_STATUS_DC_FLAG,
4136 YE_ANTICIPATED_FLAG,
4137 YE_RESOURCE_EQUITY_FLAG,
4138 YE_RESOURCE_EQUITY_BE_FLAG,
4139 FUND_BALANCE_ACCOUNT_FLAG,
4140 YE_GENERAL_FLAG,
4141 YE_NEG_RECEIVABLES_FLAG,
4142 YE_NEG_PAYABLES_FLAG,
4143 DISBURSEMENTS_FLAG,
4144 COLLECTIONS_FLAG,
4145 USSGL_ENABLED_FLAG,
4146 CREATION_DATE,
4147 CREATED_BY,
4148 LAST_UPDATE_DATE,
4149 LAST_UPDATED_BY,
4150 LAST_UPDATE_LOGIN)
4151 VALUES ('2110', -- ussgl account number
4152 'Accounts Payable', -- description
4153 'C', -- natural balance
4154 '1', -- reporting type
4155 ' ', -- total resource begin/end flag
4156 ' ', -- total resource debit/credit flag
4157 ' ', -- resource status begin//end flag
4158 ' ', -- resource status debit/credit flag
4159 'N', -- ye end anticipated flag
4160 ' ', -- ye resource/equity flag
4161 ' ', -- ye resource/equity begin/end flag
4162 'N', -- fund balance account flag
4163 'N', -- ye general flag
4164 'N', -- ye negative receivables flag
4165 'N', -- ye negative payables flag
4166 'N', -- disbursement flag
4167 'N', -- collections flag
4168 'Y', -- ussgl enabled flag
4169 sysdate, -- creation_date
4170 FND_GLOBAL.USER_ID, -- created by
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,
4180 TOTAL_RESOURCE_DC_FLAG,
4181 RESOURCE_STATUS_BE_FLAG,
4182 RESOURCE_STATUS_DC_FLAG,
4183 YE_ANTICIPATED_FLAG,
4184 YE_RESOURCE_EQUITY_FLAG,
4185 YE_RESOURCE_EQUITY_BE_FLAG,
4186 FUND_BALANCE_ACCOUNT_FLAG,
4187 YE_GENERAL_FLAG,
4188 YE_NEG_RECEIVABLES_FLAG,
4189 YE_NEG_PAYABLES_FLAG,
4190 DISBURSEMENTS_FLAG,
4191 COLLECTIONS_FLAG,
4192 USSGL_ENABLED_FLAG,
4193 CREATION_DATE,
4194 CREATED_BY,
4195 LAST_UPDATE_DATE,
4196 LAST_UPDATED_BY,
4197 LAST_UPDATE_LOGIN)
4198 VALUES ('2120', -- ussgl account number
4199 'Disbursement in Transit', -- description
4200 'C', -- natural balance
4201 '1', -- reporting type
4202 ' ', -- total resource begin/end flag
4203 ' ', -- total resource debit/credit flag
4204 ' ', -- resource status begin//end flag
4205 ' ', -- resource status debit/credit flag
4206 'N', -- ye end anticipated flag
4207 ' ', -- ye resource/equity flag
4208 ' ', -- ye resource/equity begin/end flag
4209 'N', -- fund balance account flag
4210 'N', -- ye general flag
4214 'N', -- collections flag
4211 'N', -- ye negative receivables flag
4212 'N', -- ye negative payables flag
4213 'N', -- disbursement flag
4215 'Y', -- ussgl enabled flag
4216 sysdate, -- creation_date
4217 FND_GLOBAL.USER_ID, -- created by
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,
4227 TOTAL_RESOURCE_DC_FLAG,
4228 RESOURCE_STATUS_BE_FLAG,
4229 RESOURCE_STATUS_DC_FLAG,
4230 YE_ANTICIPATED_FLAG,
4231 YE_RESOURCE_EQUITY_FLAG,
4232 YE_RESOURCE_EQUITY_BE_FLAG,
4233 FUND_BALANCE_ACCOUNT_FLAG,
4234 YE_GENERAL_FLAG,
4235 YE_NEG_RECEIVABLES_FLAG,
4236 YE_NEG_PAYABLES_FLAG,
4237 DISBURSEMENTS_FLAG,
4238 COLLECTIONS_FLAG,
4239 USSGL_ENABLED_FLAG,
4240 CREATION_DATE,
4241 CREATED_BY,
4242 LAST_UPDATE_DATE,
4243 LAST_UPDATED_BY,
4244 LAST_UPDATE_LOGIN)
4245 VALUES ('2130', -- ussgl account number
4246 'Contract Holdbacks', -- description
4247 'C', -- natural balance
4248 '1', -- reporting type
4249 ' ', -- total resource begin/end flag
4250 ' ', -- total resource debit/credit flag
4251 ' ', -- resource status begin//end flag
4252 ' ', -- resource status debit/credit flag
4253 'N', -- ye end anticipated flag
4254 ' ', -- ye resource/equity flag
4255 ' ', -- ye resource/equity begin/end flag
4256 'N', -- fund balance account flag
4257 'N', -- ye general flag
4258 'N', -- ye negative receivables flag
4259 'N', -- ye negative payables flag
4260 'N', -- disbursement flag
4261 'N', -- collections flag
4262 'Y', -- ussgl enabled flag
4263 sysdate, -- creation_date
4264 FND_GLOBAL.USER_ID, -- created by
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,
4274 TOTAL_RESOURCE_DC_FLAG,
4275 RESOURCE_STATUS_BE_FLAG,
4276 RESOURCE_STATUS_DC_FLAG,
4277 YE_ANTICIPATED_FLAG,
4278 YE_RESOURCE_EQUITY_FLAG,
4279 YE_RESOURCE_EQUITY_BE_FLAG,
4280 FUND_BALANCE_ACCOUNT_FLAG,
4281 YE_GENERAL_FLAG,
4282 YE_NEG_RECEIVABLES_FLAG,
4283 YE_NEG_PAYABLES_FLAG,
4284 DISBURSEMENTS_FLAG,
4285 COLLECTIONS_FLAG,
4286 USSGL_ENABLED_FLAG,
4287 CREATION_DATE,
4288 CREATED_BY,
4289 LAST_UPDATE_DATE,
4290 LAST_UPDATED_BY,
4291 LAST_UPDATE_LOGIN)
4292 VALUES ('2140', -- ussgl account number
4293 'Accrued Interest Payable', -- description
4294 'C', -- natural balance
4295 '1', -- reporting type
4296 ' ', -- total resource begin/end flag
4297 ' ', -- total resource debit/credit flag
4298 ' ', -- resource status begin//end flag
4299 ' ', -- resource status debit/credit flag
4300 'N', -- ye end anticipated flag
4301 ' ', -- ye resource/equity flag
4302 ' ', -- ye resource/equity begin/end flag
4303 'N', -- fund balance account flag
4304 'N', -- ye general flag
4305 'N', -- ye negative receivables flag
4306 'N', -- ye negative payables flag
4307 'N', -- disbursement flag
4308 'N', -- collections flag
4309 'Y', -- ussgl enabled flag
4310 sysdate, -- creation_date
4311 FND_GLOBAL.USER_ID, -- created by
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,
4321 TOTAL_RESOURCE_DC_FLAG,
4322 RESOURCE_STATUS_BE_FLAG,
4323 RESOURCE_STATUS_DC_FLAG,
4324 YE_ANTICIPATED_FLAG,
4325 YE_RESOURCE_EQUITY_FLAG,
4326 YE_RESOURCE_EQUITY_BE_FLAG,
4327 FUND_BALANCE_ACCOUNT_FLAG,
4328 YE_GENERAL_FLAG,
4329 YE_NEG_RECEIVABLES_FLAG,
4330 YE_NEG_PAYABLES_FLAG,
4331 DISBURSEMENTS_FLAG,
4332 COLLECTIONS_FLAG,
4333 USSGL_ENABLED_FLAG,
4334 CREATION_DATE,
4335 CREATED_BY,
4336 LAST_UPDATE_DATE,
4337 LAST_UPDATED_BY,
4338 LAST_UPDATE_LOGIN)
4339 VALUES ('2150', -- ussgl account number
4340 'Payable for Transfers of Currently Invested Balances', -- description
4341 'C', -- natural balance
4342 '1', -- reporting type
4343 ' ', -- total resource begin/end flag
4344 ' ', -- total resource debit/credit flag
4345 ' ', -- resource status begin//end flag
4346 ' ', -- resource status debit/credit flag
4347 'N', -- ye end anticipated flag
4348 'E', -- ye resource/equity flag
4349 'E', -- ye resource/equity begin/end flag
4350 'N', -- fund balance account flag
4351 'N', -- ye general flag
4352 'N', -- ye negative receivables flag
4353 'Y', -- ye negative payables flag
4357 sysdate, -- creation_date
4354 'N', -- disbursement flag
4355 'N', -- collections flag
4356 'Y', -- ussgl enabled flag
4358 FND_GLOBAL.USER_ID, -- created by
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,
4368 TOTAL_RESOURCE_DC_FLAG,
4369 RESOURCE_STATUS_BE_FLAG,
4370 RESOURCE_STATUS_DC_FLAG,
4371 YE_ANTICIPATED_FLAG,
4372 YE_RESOURCE_EQUITY_FLAG,
4373 YE_RESOURCE_EQUITY_BE_FLAG,
4374 FUND_BALANCE_ACCOUNT_FLAG,
4375 YE_GENERAL_FLAG,
4376 YE_NEG_RECEIVABLES_FLAG,
4377 YE_NEG_PAYABLES_FLAG,
4378 DISBURSEMENTS_FLAG,
4379 COLLECTIONS_FLAG,
4380 USSGL_ENABLED_FLAG,
4381 CREATION_DATE,
4382 CREATED_BY,
4383 LAST_UPDATE_DATE,
4384 LAST_UPDATED_BY,
4385 LAST_UPDATE_LOGIN)
4386 VALUES ('2155', -- ussgl account number
4387 'Expenditure Transfers Payable', -- description
4388 'C', -- natural balance
4389 '1', -- reporting type
4390 ' ', -- total resource begin/end flag
4391 ' ', -- total resource debit/credit flag
4392 ' ', -- resource status begin//end flag
4393 ' ', -- resource status debit/credit flag
4394 'N', -- ye end anticipated flag
4395 ' ', -- ye resource/equity flag
4396 ' ', -- ye resource/equity begin/end flag
4397 'N', -- fund balance account flag
4398 'N', -- ye general flag
4399 'N', -- ye negative receivables flag
4400 'N', -- ye negative payables flag
4401 'N', -- disbursement flag
4402 'N', -- collections flag
4403 'Y', -- ussgl enabled flag
4404 sysdate, -- creation_date
4405 FND_GLOBAL.USER_ID, -- created by
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,
4415 TOTAL_RESOURCE_DC_FLAG,
4416 RESOURCE_STATUS_BE_FLAG,
4417 RESOURCE_STATUS_DC_FLAG,
4418 YE_ANTICIPATED_FLAG,
4419 YE_RESOURCE_EQUITY_FLAG,
4420 YE_RESOURCE_EQUITY_BE_FLAG,
4421 FUND_BALANCE_ACCOUNT_FLAG,
4422 YE_GENERAL_FLAG,
4423 YE_NEG_RECEIVABLES_FLAG,
4424 YE_NEG_PAYABLES_FLAG,
4425 DISBURSEMENTS_FLAG,
4426 COLLECTIONS_FLAG,
4427 USSGL_ENABLED_FLAG,
4428 CREATION_DATE,
4429 CREATED_BY,
4430 LAST_UPDATE_DATE,
4431 LAST_UPDATED_BY,
4432 LAST_UPDATE_LOGIN)
4433 VALUES ('2160', -- ussgl account number
4434 'Entitlement Benefits Due and Payable', -- description
4435 'C', -- natural balance
4436 '1', -- reporting type
4437 ' ', -- total resource begin/end flag
4438 ' ', -- total resource debit/credit flag
4439 ' ', -- resource status begin//end flag
4440 ' ', -- resource status debit/credit flag
4441 'N', -- ye end anticipated flag
4442 ' ', -- ye resource/equity flag
4443 ' ', -- ye resource/equity begin/end flag
4444 'N', -- fund balance account flag
4445 'N', -- ye general flag
4446 'N', -- ye negative receivables flag
4447 'N', -- ye negative payables flag
4448 'N', -- disbursement flag
4449 'N', -- collections flag
4450 'Y', -- ussgl enabled flag
4451 sysdate, -- creation_date
4452 FND_GLOBAL.USER_ID, -- created by
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,
4462 TOTAL_RESOURCE_DC_FLAG,
4463 RESOURCE_STATUS_BE_FLAG,
4464 RESOURCE_STATUS_DC_FLAG,
4465 YE_ANTICIPATED_FLAG,
4466 YE_RESOURCE_EQUITY_FLAG,
4467 YE_RESOURCE_EQUITY_BE_FLAG,
4468 FUND_BALANCE_ACCOUNT_FLAG,
4469 YE_GENERAL_FLAG,
4470 YE_NEG_RECEIVABLES_FLAG,
4471 YE_NEG_PAYABLES_FLAG,
4472 DISBURSEMENTS_FLAG,
4473 COLLECTIONS_FLAG,
4474 USSGL_ENABLED_FLAG,
4475 CREATION_DATE,
4476 CREATED_BY,
4477 LAST_UPDATE_DATE,
4478 LAST_UPDATED_BY,
4479 LAST_UPDATE_LOGIN)
4480 VALUES ('2170', -- ussgl account number
4481 'Subsidy Payable to Financing Account', -- description
4482 'C', -- natural balance
4483 '1', -- reporting type
4484 ' ', -- total resource begin/end flag
4485 ' ', -- total resource debit/credit flag
4486 ' ', -- resource status begin//end flag
4487 ' ', -- resource status debit/credit flag
4488 'N', -- ye end anticipated flag
4489 ' ', -- ye resource/equity flag
4490 ' ', -- ye resource/equity begin/end flag
4491 'N', -- fund balance account flag
4492 'N', -- ye general flag
4493 'N', -- ye negative receivables flag
4494 'N', -- ye negative payables flag
4495 'N', -- disbursement flag
4496 'N', -- collections flag
4500 sysdate, -- last update date
4497 'Y', -- ussgl enabled flag
4498 sysdate, -- creation_date
4499 FND_GLOBAL.USER_ID, -- created by
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,
4509 TOTAL_RESOURCE_DC_FLAG,
4510 RESOURCE_STATUS_BE_FLAG,
4511 RESOURCE_STATUS_DC_FLAG,
4512 YE_ANTICIPATED_FLAG,
4513 YE_RESOURCE_EQUITY_FLAG,
4514 YE_RESOURCE_EQUITY_BE_FLAG,
4515 FUND_BALANCE_ACCOUNT_FLAG,
4516 YE_GENERAL_FLAG,
4517 YE_NEG_RECEIVABLES_FLAG,
4518 YE_NEG_PAYABLES_FLAG,
4519 DISBURSEMENTS_FLAG,
4520 COLLECTIONS_FLAG,
4521 USSGL_ENABLED_FLAG,
4522 CREATION_DATE,
4523 CREATED_BY,
4524 LAST_UPDATE_DATE,
4525 LAST_UPDATED_BY,
4526 LAST_UPDATE_LOGIN)
4527 VALUES ('2179', -- ussgl account number
4528 'Contra Liability for Subsidy Payable to Financing Account ', -- description
4529 'D', -- natural balance
4530 '1', -- reporting type
4531 ' ', -- total resource begin/end flag
4532 ' ', -- total resource debit/credit flag
4533 ' ', -- resource status begin//end flag
4534 ' ', -- resource status debit/credit flag
4535 'N', -- ye end anticipated flag
4536 ' ', -- ye resource/equity flag
4537 ' ', -- ye resource/equity begin/end flag
4538 'N', -- fund balance account flag
4539 'N', -- ye general flag
4540 'N', -- ye negative receivables flag
4541 'N', -- ye negative payables flag
4542 'N', -- disbursement flag
4543 'N', -- collections flag
4544 'Y', -- ussgl enabled flag
4545 sysdate, -- creation_date
4546 FND_GLOBAL.USER_ID, -- created by
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,
4556 TOTAL_RESOURCE_DC_FLAG,
4557 RESOURCE_STATUS_BE_FLAG,
4558 RESOURCE_STATUS_DC_FLAG,
4559 YE_ANTICIPATED_FLAG,
4560 YE_RESOURCE_EQUITY_FLAG,
4561 YE_RESOURCE_EQUITY_BE_FLAG,
4562 FUND_BALANCE_ACCOUNT_FLAG,
4563 YE_GENERAL_FLAG,
4564 YE_NEG_RECEIVABLES_FLAG,
4565 YE_NEG_PAYABLES_FLAG,
4566 DISBURSEMENTS_FLAG,
4567 COLLECTIONS_FLAG,
4568 USSGL_ENABLED_FLAG,
4569 CREATION_DATE,
4570 CREATED_BY,
4571 LAST_UPDATE_DATE,
4572 LAST_UPDATED_BY,
4573 LAST_UPDATE_LOGIN)
4574 VALUES ('2180', -- ussgl account number
4575 'Loan Guarantee Liability', -- description
4576 'C', -- natural balance
4577 '1', -- reporting type
4578 ' ', -- total resource begin/end flag
4579 ' ', -- total resource debit/credit flag
4580 ' ', -- resource status begin//end flag
4581 ' ', -- resource status debit/credit flag
4582 'N', -- ye end anticipated flag
4583 ' ', -- ye resource/equity flag
4584 ' ', -- ye resource/equity begin/end flag
4585 'N', -- fund balance account flag
4586 'N', -- ye general flag
4587 'N', -- ye negative receivables flag
4588 'N', -- ye negative payables flag
4589 'N', -- disbursement flag
4590 'N', -- collections flag
4591 'Y', -- ussgl enabled flag
4592 sysdate, -- creation_date
4593 FND_GLOBAL.USER_ID, -- created by
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,
4603 TOTAL_RESOURCE_DC_FLAG,
4604 RESOURCE_STATUS_BE_FLAG,
4605 RESOURCE_STATUS_DC_FLAG,
4606 YE_ANTICIPATED_FLAG,
4607 YE_RESOURCE_EQUITY_FLAG,
4608 YE_RESOURCE_EQUITY_BE_FLAG,
4609 FUND_BALANCE_ACCOUNT_FLAG,
4610 YE_GENERAL_FLAG,
4611 YE_NEG_RECEIVABLES_FLAG,
4612 YE_NEG_PAYABLES_FLAG,
4613 DISBURSEMENTS_FLAG,
4614 COLLECTIONS_FLAG,
4615 USSGL_ENABLED_FLAG,
4616 CREATION_DATE,
4617 CREATED_BY,
4618 LAST_UPDATE_DATE,
4619 LAST_UPDATED_BY,
4620 LAST_UPDATE_LOGIN)
4621 VALUES ('2190', -- ussgl account number
4622 'Other Accrued Liabilities', -- description
4623 'C', -- natural balance
4624 '1', -- reporting type
4625 ' ', -- total resource begin/end flag
4626 ' ', -- total resource debit/credit flag
4627 ' ', -- resource status begin//end flag
4628 ' ', -- resource status debit/credit flag
4629 'N', -- ye end anticipated flag
4630 ' ', -- ye resource/equity flag
4631 ' ', -- ye resource/equity begin/end flag
4632 'N', -- fund balance account flag
4633 'N', -- ye general flag
4634 'N', -- ye negative receivables flag
4635 'N', -- ye negative payables flag
4636 'N', -- disbursement flag
4637 'N', -- collections flag
4638 'Y', -- ussgl enabled flag
4639 sysdate, -- creation_date
4643 FND_GLOBAL.USER_ID -- last updated login
4640 FND_GLOBAL.USER_ID, -- created by
4641 sysdate, -- last update date
4642 FND_GLOBAL.USER_ID, -- last updated by
4644 );
4645 INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4646 DESCRIPTION,
4647 NATURAL_BALANCE,
4648 REPORTING_TYPE,
4649 TOTAL_RESOURCE_BE_FLAG,
4650 TOTAL_RESOURCE_DC_FLAG,
4651 RESOURCE_STATUS_BE_FLAG,
4652 RESOURCE_STATUS_DC_FLAG,
4653 YE_ANTICIPATED_FLAG,
4654 YE_RESOURCE_EQUITY_FLAG,
4655 YE_RESOURCE_EQUITY_BE_FLAG,
4656 FUND_BALANCE_ACCOUNT_FLAG,
4657 YE_GENERAL_FLAG,
4658 YE_NEG_RECEIVABLES_FLAG,
4659 YE_NEG_PAYABLES_FLAG,
4660 DISBURSEMENTS_FLAG,
4661 COLLECTIONS_FLAG,
4662 USSGL_ENABLED_FLAG,
4663 CREATION_DATE,
4664 CREATED_BY,
4665 LAST_UPDATE_DATE,
4666 LAST_UPDATED_BY,
4667 LAST_UPDATE_LOGIN)
4668 VALUES ('2210', -- ussgl account number
4669 'Accrued Funded Payroll and Leave', -- description
4670 'C', -- natural balance
4671 '1', -- reporting type
4672 ' ', -- total resource begin/end flag
4673 ' ', -- total resource debit/credit flag
4674 ' ', -- resource status begin//end flag
4675 ' ', -- resource status debit/credit flag
4676 'N', -- ye end anticipated flag
4677 ' ', -- ye resource/equity flag
4678 ' ', -- ye resource/equity begin/end flag
4679 'N', -- fund balance account flag
4680 'N', -- ye general flag
4681 'N', -- ye negative receivables flag
4682 'N', -- ye negative payables flag
4683 'N', -- disbursement flag
4684 'N', -- collections flag
4685 'Y', -- ussgl enabled flag
4686 sysdate, -- creation_date
4687 FND_GLOBAL.USER_ID, -- created by
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,
4697 TOTAL_RESOURCE_DC_FLAG,
4698 RESOURCE_STATUS_BE_FLAG,
4699 RESOURCE_STATUS_DC_FLAG,
4700 YE_ANTICIPATED_FLAG,
4701 YE_RESOURCE_EQUITY_FLAG,
4702 YE_RESOURCE_EQUITY_BE_FLAG,
4703 FUND_BALANCE_ACCOUNT_FLAG,
4704 YE_GENERAL_FLAG,
4705 YE_NEG_RECEIVABLES_FLAG,
4706 YE_NEG_PAYABLES_FLAG,
4707 DISBURSEMENTS_FLAG,
4708 COLLECTIONS_FLAG,
4709 USSGL_ENABLED_FLAG,
4710 CREATION_DATE,
4711 CREATED_BY,
4712 LAST_UPDATE_DATE,
4713 LAST_UPDATED_BY,
4714 LAST_UPDATE_LOGIN)
4715 VALUES ('2211', -- ussgl account number
4716 'Witholdings Payable', -- description
4717 'C', -- natural balance
4718 '1', -- reporting type
4719 ' ', -- total resource begin/end flag
4720 ' ', -- total resource debit/credit flag
4721 ' ', -- resource status begin//end flag
4722 ' ', -- resource status debit/credit flag
4723 'N', -- ye end anticipated flag
4724 ' ', -- ye resource/equity flag
4725 ' ', -- ye resource/equity begin/end flag
4726 'N', -- fund balance account flag
4727 'N', -- ye general flag
4728 'N', -- ye negative receivables flag
4729 'N', -- ye negative payables flag
4730 'N', -- disbursement flag
4731 'N', -- collections flag
4732 'Y', -- ussgl enabled flag
4733 sysdate, -- creation_date
4734 FND_GLOBAL.USER_ID, -- created by
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,
4744 TOTAL_RESOURCE_DC_FLAG,
4745 RESOURCE_STATUS_BE_FLAG,
4746 RESOURCE_STATUS_DC_FLAG,
4747 YE_ANTICIPATED_FLAG,
4748 YE_RESOURCE_EQUITY_FLAG,
4749 YE_RESOURCE_EQUITY_BE_FLAG,
4750 FUND_BALANCE_ACCOUNT_FLAG,
4751 YE_GENERAL_FLAG,
4752 YE_NEG_RECEIVABLES_FLAG,
4753 YE_NEG_PAYABLES_FLAG,
4754 DISBURSEMENTS_FLAG,
4755 COLLECTIONS_FLAG,
4756 USSGL_ENABLED_FLAG,
4757 CREATION_DATE,
4758 CREATED_BY,
4759 LAST_UPDATE_DATE,
4760 LAST_UPDATED_BY,
4761 LAST_UPDATE_LOGIN)
4762 VALUES ('2213', -- ussgl account number
4763 'Employer Contributions and Payroll Taxes Payable', -- description
4764 'C', -- natural balance
4765 '1', -- reporting type
4766 ' ', -- total resource begin/end flag
4767 ' ', -- total resource debit/credit flag
4768 ' ', -- resource status begin//end flag
4769 ' ', -- resource status debit/credit flag
4770 'N', -- ye end anticipated flag
4771 ' ', -- ye resource/equity flag
4772 ' ', -- ye resource/equity begin/end flag
4773 'N', -- fund balance account flag
4774 'N', -- ye general flag
4775 'N', -- ye negative receivables flag
4776 'N', -- ye negative payables flag
4777 'N', -- disbursement flag
4778 'N', -- collections flag
4779 'Y', -- ussgl enabled flag
4780 sysdate, -- creation_date
4781 FND_GLOBAL.USER_ID, -- created by
4782 sysdate, -- last update date
4786 INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4783 FND_GLOBAL.USER_ID, -- last updated by
4784 FND_GLOBAL.USER_ID -- last updated login
4785 );
4787 DESCRIPTION,
4788 NATURAL_BALANCE,
4789 REPORTING_TYPE,
4790 TOTAL_RESOURCE_BE_FLAG,
4791 TOTAL_RESOURCE_DC_FLAG,
4792 RESOURCE_STATUS_BE_FLAG,
4793 RESOURCE_STATUS_DC_FLAG,
4794 YE_ANTICIPATED_FLAG,
4795 YE_RESOURCE_EQUITY_FLAG,
4796 YE_RESOURCE_EQUITY_BE_FLAG,
4797 FUND_BALANCE_ACCOUNT_FLAG,
4798 YE_GENERAL_FLAG,
4799 YE_NEG_RECEIVABLES_FLAG,
4800 YE_NEG_PAYABLES_FLAG,
4801 DISBURSEMENTS_FLAG,
4802 COLLECTIONS_FLAG,
4803 USSGL_ENABLED_FLAG,
4804 CREATION_DATE,
4805 CREATED_BY,
4806 LAST_UPDATE_DATE,
4807 LAST_UPDATED_BY,
4808 LAST_UPDATE_LOGIN)
4809 VALUES ('2215', -- ussgl account number
4810 'Other Post-Employment Benefits Due and Payable', -- description
4811 'C', -- natural balance
4812 '1', -- reporting type
4813 ' ', -- total resource begin/end flag
4814 ' ', -- total resource debit/credit flag
4815 ' ', -- resource status begin//end flag
4816 ' ', -- resource status debit/credit flag
4817 'N', -- ye end anticipated flag
4818 ' ', -- ye resource/equity flag
4819 ' ', -- ye resource/equity begin/end flag
4820 'N', -- fund balance account flag
4821 'N', -- ye general flag
4822 'N', -- ye negative receivables flag
4823 'N', -- ye negative payables flag
4824 'N', -- disbursement flag
4825 'N', -- collections flag
4826 'Y', -- ussgl enabled flag
4827 sysdate, -- creation_date
4828 FND_GLOBAL.USER_ID, -- created by
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,
4838 TOTAL_RESOURCE_DC_FLAG,
4839 RESOURCE_STATUS_BE_FLAG,
4840 RESOURCE_STATUS_DC_FLAG,
4841 YE_ANTICIPATED_FLAG,
4842 YE_RESOURCE_EQUITY_FLAG,
4843 YE_RESOURCE_EQUITY_BE_FLAG,
4844 FUND_BALANCE_ACCOUNT_FLAG,
4845 YE_GENERAL_FLAG,
4846 YE_NEG_RECEIVABLES_FLAG,
4847 YE_NEG_PAYABLES_FLAG,
4848 DISBURSEMENTS_FLAG,
4849 COLLECTIONS_FLAG,
4850 USSGL_ENABLED_FLAG,
4851 CREATION_DATE,
4852 CREATED_BY,
4853 LAST_UPDATE_DATE,
4854 LAST_UPDATED_BY,
4855 LAST_UPDATE_LOGIN)
4856 VALUES ('2216', -- ussgl account number
4857 'Pension Benefits Due and Payable to Beneficiaries', -- description
4858 'C', -- natural balance
4859 '1', -- reporting type
4860 ' ', -- total resource begin/end flag
4861 ' ', -- total resource debit/credit flag
4862 ' ', -- resource status begin//end flag
4863 ' ', -- resource status debit/credit flag
4864 'N', -- ye end anticipated flag
4865 ' ', -- ye resource/equity flag
4866 ' ', -- ye resource/equity begin/end flag
4867 'N', -- fund balance account flag
4868 'N', -- ye general flag
4869 'N', -- ye negative receivables flag
4870 'N', -- ye negative payables flag
4871 'N', -- disbursement flag
4872 'N', -- collections flag
4873 'Y', -- ussgl enabled flag
4874 sysdate, -- creation_date
4875 FND_GLOBAL.USER_ID, -- created by
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,
4885 TOTAL_RESOURCE_DC_FLAG,
4886 RESOURCE_STATUS_BE_FLAG,
4887 RESOURCE_STATUS_DC_FLAG,
4888 YE_ANTICIPATED_FLAG,
4889 YE_RESOURCE_EQUITY_FLAG,
4890 YE_RESOURCE_EQUITY_BE_FLAG,
4891 FUND_BALANCE_ACCOUNT_FLAG,
4892 YE_GENERAL_FLAG,
4893 YE_NEG_RECEIVABLES_FLAG,
4894 YE_NEG_PAYABLES_FLAG,
4895 DISBURSEMENTS_FLAG,
4896 COLLECTIONS_FLAG,
4897 USSGL_ENABLED_FLAG,
4898 CREATION_DATE,
4899 CREATED_BY,
4900 LAST_UPDATE_DATE,
4901 LAST_UPDATED_BY,
4902 LAST_UPDATE_LOGIN)
4903 VALUES ('2217', -- ussgl account number
4904 'Benefit Premiums Payable to Carriers', -- description
4905 'C', -- natural balance
4906 '1', -- reporting type
4907 ' ', -- total resource begin/end flag
4908 ' ', -- total resource debit/credit flag
4909 ' ', -- resource status begin//end flag
4910 ' ', -- resource status debit/credit flag
4911 'N', -- ye end anticipated flag
4912 ' ', -- ye resource/equity flag
4913 ' ', -- ye resource/equity begin/end flag
4914 'N', -- fund balance account flag
4915 'N', -- ye general flag
4916 'N', -- ye negative receivables flag
4917 'N', -- ye negative payables flag
4918 'N', -- disbursement flag
4919 'N', -- collections flag
4920 'Y', -- ussgl enabled flag
4921 sysdate, -- creation_date
4922 FND_GLOBAL.USER_ID, -- created by
4923 sysdate, -- last update date
4924 FND_GLOBAL.USER_ID, -- last updated by
4928 DESCRIPTION,
4925 FND_GLOBAL.USER_ID -- last updated login
4926 );
4927 INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
4929 NATURAL_BALANCE,
4930 REPORTING_TYPE,
4931 TOTAL_RESOURCE_BE_FLAG,
4932 TOTAL_RESOURCE_DC_FLAG,
4933 RESOURCE_STATUS_BE_FLAG,
4934 RESOURCE_STATUS_DC_FLAG,
4935 YE_ANTICIPATED_FLAG,
4936 YE_RESOURCE_EQUITY_FLAG,
4937 YE_RESOURCE_EQUITY_BE_FLAG,
4938 FUND_BALANCE_ACCOUNT_FLAG,
4939 YE_GENERAL_FLAG,
4940 YE_NEG_RECEIVABLES_FLAG,
4941 YE_NEG_PAYABLES_FLAG,
4942 DISBURSEMENTS_FLAG,
4943 COLLECTIONS_FLAG,
4944 USSGL_ENABLED_FLAG,
4945 CREATION_DATE,
4946 CREATED_BY,
4947 LAST_UPDATE_DATE,
4948 LAST_UPDATED_BY,
4949 LAST_UPDATE_LOGIN)
4950 VALUES ('2218', -- ussgl account number
4951 'Life Insurance Benefits Due and Payable to Beneficiaries', -- description
4952 'C', -- natural balance
4953 '1', -- reporting type
4954 ' ', -- total resource begin/end flag
4955 ' ', -- total resource debit/credit flag
4956 ' ', -- resource status begin//end flag
4957 ' ', -- resource status debit/credit flag
4958 'N', -- ye end anticipated flag
4959 ' ', -- ye resource/equity flag
4960 ' ', -- ye resource/equity begin/end flag
4961 'N', -- fund balance account flag
4962 'N', -- ye general flag
4963 'N', -- ye negative receivables flag
4964 'N', -- ye negative payables flag
4965 'N', -- disbursement flag
4966 'N', -- collections flag
4967 'Y', -- ussgl enabled flag
4968 sysdate, -- creation_date
4969 FND_GLOBAL.USER_ID, -- created by
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,
4979 TOTAL_RESOURCE_DC_FLAG,
4980 RESOURCE_STATUS_BE_FLAG,
4981 RESOURCE_STATUS_DC_FLAG,
4982 YE_ANTICIPATED_FLAG,
4983 YE_RESOURCE_EQUITY_FLAG,
4984 YE_RESOURCE_EQUITY_BE_FLAG,
4985 FUND_BALANCE_ACCOUNT_FLAG,
4986 YE_GENERAL_FLAG,
4987 YE_NEG_RECEIVABLES_FLAG,
4988 YE_NEG_PAYABLES_FLAG,
4989 DISBURSEMENTS_FLAG,
4990 COLLECTIONS_FLAG,
4991 USSGL_ENABLED_FLAG,
4992 CREATION_DATE,
4993 CREATED_BY,
4994 LAST_UPDATE_DATE,
4995 LAST_UPDATED_BY,
4996 LAST_UPDATE_LOGIN)
4997 VALUES ('2220', -- ussgl account number
4998 'Unfunded Leave', -- description
4999 'C', -- natural balance
5000 '1', -- reporting type
5001 ' ', -- total resource begin/end flag
5002 ' ', -- total resource debit/credit flag
5003 ' ', -- resource status begin//end flag
5004 ' ', -- resource status debit/credit flag
5005 'N', -- ye end anticipated flag
5006 ' ', -- ye resource/equity flag
5007 ' ', -- ye resource/equity begin/end flag
5008 'N', -- fund balance account flag
5009 'N', -- ye general flag
5010 'N', -- ye negative receivables flag
5011 'N', -- ye negative payables flag
5012 'N', -- disbursement flag
5013 'N', -- collections flag
5014 'Y', -- ussgl enabled flag
5015 sysdate, -- creation_date
5016 FND_GLOBAL.USER_ID, -- created by
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,
5026 TOTAL_RESOURCE_DC_FLAG,
5027 RESOURCE_STATUS_BE_FLAG,
5028 RESOURCE_STATUS_DC_FLAG,
5029 YE_ANTICIPATED_FLAG,
5030 YE_RESOURCE_EQUITY_FLAG,
5031 YE_RESOURCE_EQUITY_BE_FLAG,
5032 FUND_BALANCE_ACCOUNT_FLAG,
5033 YE_GENERAL_FLAG,
5034 YE_NEG_RECEIVABLES_FLAG,
5035 YE_NEG_PAYABLES_FLAG,
5036 DISBURSEMENTS_FLAG,
5037 COLLECTIONS_FLAG,
5038 USSGL_ENABLED_FLAG,
5039 CREATION_DATE,
5040 CREATED_BY,
5041 LAST_UPDATE_DATE,
5042 LAST_UPDATED_BY,
5043 LAST_UPDATE_LOGIN)
5044 VALUES ('2225', -- ussgl account number
5045 'Unfunded FECA Liability', -- description
5046 'C', -- natural balance
5047 '1', -- reporting type
5048 ' ', -- total resource begin/end flag
5049 ' ', -- total resource debit/credit flag
5050 ' ', -- resource status begin//end flag
5051 ' ', -- resource status debit/credit flag
5052 'N', -- ye end anticipated flag
5053 ' ', -- ye resource/equity flag
5054 ' ', -- ye resource/equity begin/end flag
5055 'N', -- fund balance account flag
5056 'N', -- ye general flag
5057 'N', -- ye negative receivables flag
5058 'N', -- ye negative payables flag
5059 'N', -- disbursement flag
5060 'N', -- collections flag
5061 'Y', -- ussgl enabled flag
5062 sysdate, -- creation_date
5063 FND_GLOBAL.USER_ID, -- created by
5064 sysdate, -- last update date
5065 FND_GLOBAL.USER_ID, -- last updated by
5066 FND_GLOBAL.USER_ID -- last updated login
5067 );
5071 REPORTING_TYPE,
5068 INSERT INTO FV_FACTS_USSGL_ACCOUNTS ( USSGL_ACCOUNT,
5069 DESCRIPTION,
5070 NATURAL_BALANCE,
5072 TOTAL_RESOURCE_BE_FLAG,
5073 TOTAL_RESOURCE_DC_FLAG,
5074 RESOURCE_STATUS_BE_FLAG,
5075 RESOURCE_STATUS_DC_FLAG,
5076 YE_ANTICIPATED_FLAG,
5077 YE_RESOURCE_EQUITY_FLAG,
5078 YE_RESOURCE_EQUITY_BE_FLAG,
5079 FUND_BALANCE_ACCOUNT_FLAG,
5080 YE_GENERAL_FLAG,
5081 YE_NEG_RECEIVABLES_FLAG,
5082 YE_NEG_PAYABLES_FLAG,
5083 DISBURSEMENTS_FLAG,
5084 COLLECTIONS_FLAG,
5085 USSGL_ENABLED_FLAG,
5086 CREATION_DATE,
5087 CREATED_BY,
5088 LAST_UPDATE_DATE,
5089 LAST_UPDATED_BY,
5090 LAST_UPDATE_LOGIN)
5091 VALUES ('2290', -- ussgl account number
5092 'Other Unfunded Employment Related Liability', -- description
5093 'C', -- natural balance
5094 '1', -- reporting type
5095 ' ', -- total resource begin/end flag
5096 ' ', -- total resource debit/credit flag
5097 ' ', -- resource status begin//end flag
5098 ' ', -- resource status debit/credit flag
5099 'N', -- ye end anticipated flag
5100 ' ', -- ye resource/equity flag
5101 ' ', -- ye resource/equity begin/end flag
5102 'N', -- fund balance account flag
5103 'N', -- ye general flag
5104 'N', -- ye negative receivables flag
5105 'N', -- ye negative payables flag
5106 'N', -- disbursement flag
5107 'N', -- collections flag
5108 'Y', -- ussgl enabled flag
5109 sysdate, -- creation_date
5110 FND_GLOBAL.USER_ID, -- created by
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,
5120 TOTAL_RESOURCE_DC_FLAG,
5121 RESOURCE_STATUS_BE_FLAG,
5122 RESOURCE_STATUS_DC_FLAG,
5123 YE_ANTICIPATED_FLAG,
5124 YE_RESOURCE_EQUITY_FLAG,
5125 YE_RESOURCE_EQUITY_BE_FLAG,
5126 FUND_BALANCE_ACCOUNT_FLAG,
5127 YE_GENERAL_FLAG,
5128 YE_NEG_RECEIVABLES_FLAG,
5129 YE_NEG_PAYABLES_FLAG,
5130 DISBURSEMENTS_FLAG,
5131 COLLECTIONS_FLAG,
5132 USSGL_ENABLED_FLAG,
5133 CREATION_DATE,
5134 CREATED_BY,
5135 LAST_UPDATE_DATE,
5136 LAST_UPDATED_BY,
5137 LAST_UPDATE_LOGIN)
5138 VALUES ('2310', -- ussgl account number
5139 'Advances from Others', -- description
5140 'C', -- natural balance
5141 '1', -- reporting type
5142 ' ', -- total resource begin/end flag
5143 ' ', -- total resource debit/credit flag
5144 ' ', -- resource status begin//end flag
5145 ' ', -- resource status debit/credit flag
5146 'N', -- ye end anticipated flag
5147 ' ', -- ye resource/equity flag
5148 ' ', -- ye resource/equity begin/end flag
5149 'N', -- fund balance account flag
5150 'N', -- ye general flag
5151 'N', -- ye negative receivables flag
5152 'N', -- ye negative payables flag
5153 'N', -- disbursement flag
5154 'N', -- collections flag
5155 'Y', -- ussgl enabled flag
5156 sysdate, -- creation_date
5157 FND_GLOBAL.USER_ID, -- created by
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,
5167 TOTAL_RESOURCE_DC_FLAG,
5168 RESOURCE_STATUS_BE_FLAG,
5169 RESOURCE_STATUS_DC_FLAG,
5170 YE_ANTICIPATED_FLAG,
5171 YE_RESOURCE_EQUITY_FLAG,
5172 YE_RESOURCE_EQUITY_BE_FLAG,
5173 FUND_BALANCE_ACCOUNT_FLAG,
5174 YE_GENERAL_FLAG,
5175 YE_NEG_RECEIVABLES_FLAG,
5176 YE_NEG_PAYABLES_FLAG,
5177 DISBURSEMENTS_FLAG,
5178 COLLECTIONS_FLAG,
5179 USSGL_ENABLED_FLAG,
5180 CREATION_DATE,
5181 CREATED_BY,
5182 LAST_UPDATE_DATE,
5183 LAST_UPDATED_BY,
5184 LAST_UPDATE_LOGIN)
5185 VALUES ('2320', -- ussgl account number
5186 'Deferred Credits', -- description
5187 'C', -- natural balance
5188 '1', -- reporting type
5189 ' ', -- total resource begin/end flag
5190 ' ', -- total resource debit/credit flag
5191 ' ', -- resource status begin//end flag
5192 ' ', -- resource status debit/credit flag
5193 'N', -- ye end anticipated flag
5194 ' ', -- ye resource/equity flag
5195 ' ', -- ye resource/equity begin/end flag
5196 'N', -- fund balance account flag
5197 'N', -- ye general flag
5198 'N', -- ye negative receivables flag
5199 'N', -- ye negative payables flag
5200 'N', -- disbursement flag
5201 'N', -- collections flag
5202 'Y', -- ussgl enabled flag
5203 sysdate, -- creation_date
5204 FND_GLOBAL.USER_ID, -- created by
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,
5213 TOTAL_RESOURCE_BE_FLAG,
5210 DESCRIPTION,
5211 NATURAL_BALANCE,
5212 REPORTING_TYPE,
5214 TOTAL_RESOURCE_DC_FLAG,
5215 RESOURCE_STATUS_BE_FLAG,
5216 RESOURCE_STATUS_DC_FLAG,
5217 YE_ANTICIPATED_FLAG,
5218 YE_RESOURCE_EQUITY_FLAG,
5219 YE_RESOURCE_EQUITY_BE_FLAG,
5220 FUND_BALANCE_ACCOUNT_FLAG,
5221 YE_GENERAL_FLAG,
5222 YE_NEG_RECEIVABLES_FLAG,
5223 YE_NEG_PAYABLES_FLAG,
5224 DISBURSEMENTS_FLAG,
5225 COLLECTIONS_FLAG,
5226 USSGL_ENABLED_FLAG,
5227 CREATION_DATE,
5228 CREATED_BY,
5229 LAST_UPDATE_DATE,
5230 LAST_UPDATED_BY,
5231 LAST_UPDATE_LOGIN)
5232 VALUES ('2400', -- ussgl account number
5233 'Liability for Deposit Funds, Clearing Accounts and Undeposited Collections', -- description
5234 'C', -- natural balance
5235 '1', -- reporting type
5236 ' ', -- total resource begin/end flag
5237 ' ', -- total resource debit/credit flag
5238 ' ', -- resource status begin//end flag
5239 ' ', -- resource status debit/credit flag
5240 'N', -- ye end anticipated flag
5241 ' ', -- ye resource/equity flag
5242 ' ', -- ye resource/equity begin/end flag
5243 'N', -- fund balance account flag
5244 'N', -- ye general flag
5245 'N', -- ye negative receivables flag
5246 'N', -- ye negative payables flag
5247 'N', -- disbursement flag
5248 'N', -- collections flag
5249 'Y', -- ussgl enabled flag
5250 sysdate, -- creation_date
5251 FND_GLOBAL.USER_ID, -- created by
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,
5261 TOTAL_RESOURCE_DC_FLAG,
5262 RESOURCE_STATUS_BE_FLAG,
5263 RESOURCE_STATUS_DC_FLAG,
5264 YE_ANTICIPATED_FLAG,
5265 YE_RESOURCE_EQUITY_FLAG,
5266 YE_RESOURCE_EQUITY_BE_FLAG,
5267 FUND_BALANCE_ACCOUNT_FLAG,
5268 YE_GENERAL_FLAG,
5269 YE_NEG_RECEIVABLES_FLAG,
5270 YE_NEG_PAYABLES_FLAG,
5271 DISBURSEMENTS_FLAG,
5272 COLLECTIONS_FLAG,
5273 USSGL_ENABLED_FLAG,
5274 CREATION_DATE,
5275 CREATED_BY,
5276 LAST_UPDATE_DATE,
5277 LAST_UPDATED_BY,
5278 LAST_UPDATE_LOGIN)
5279 VALUES ('2510', -- ussgl account number
5280 'Principal Payable to Treasury', -- description
5281 'C', -- natural balance
5282 '1', -- reporting type
5283 ' ', -- total resource begin/end flag
5284 ' ', -- total resource debit/credit flag
5285 ' ', -- resource status begin//end flag
5286 ' ', -- resource status debit/credit flag
5287 'N', -- ye end anticipated flag
5288 ' ', -- ye resource/equity flag
5289 ' ', -- ye resource/equity begin/end flag
5290 'N', -- fund balance account flag
5291 'N', -- ye general flag
5292 'N', -- ye negative receivables flag
5293 'N', -- ye negative payables flag
5294 'N', -- disbursement flag
5295 'N', -- collections flag
5296 'Y', -- ussgl enabled flag
5297 sysdate, -- creation_date
5298 FND_GLOBAL.USER_ID, -- created by
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,
5308 TOTAL_RESOURCE_DC_FLAG,
5309 RESOURCE_STATUS_BE_FLAG,
5310 RESOURCE_STATUS_DC_FLAG,
5311 YE_ANTICIPATED_FLAG,
5312 YE_RESOURCE_EQUITY_FLAG,
5313 YE_RESOURCE_EQUITY_BE_FLAG,
5314 FUND_BALANCE_ACCOUNT_FLAG,
5315 YE_GENERAL_FLAG,
5316 YE_NEG_RECEIVABLES_FLAG,
5317 YE_NEG_PAYABLES_FLAG,
5318 DISBURSEMENTS_FLAG,
5319 COLLECTIONS_FLAG,
5320 USSGL_ENABLED_FLAG,
5321 CREATION_DATE,
5322 CREATED_BY,
5323 LAST_UPDATE_DATE,
5324 LAST_UPDATED_BY,
5325 LAST_UPDATE_LOGIN)
5326 VALUES ('2520', -- ussgl account number
5327 'Principal Payable to the Federal Financing Bank', -- description
5328 'C', -- natural balance
5329 '1', -- reporting type
5330 ' ', -- total resource begin/end flag
5331 ' ', -- total resource debit/credit flag
5332 ' ', -- resource status begin//end flag
5333 ' ', -- resource status debit/credit flag
5334 'N', -- ye end anticipated flag
5335 ' ', -- ye resource/equity flag
5336 ' ', -- ye resource/equity begin/end flag
5337 'N', -- fund balance account flag
5338 'N', -- ye general flag
5339 'N', -- ye negative receivables flag
5340 'N', -- ye negative payables flag
5341 'N', -- disbursement flag
5342 'N', -- collections flag
5343 'Y', -- ussgl enabled flag
5344 sysdate, -- creation_date
5345 FND_GLOBAL.USER_ID, -- created by
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,
5355 TOTAL_RESOURCE_DC_FLAG,
5356 RESOURCE_STATUS_BE_FLAG,
5357 RESOURCE_STATUS_DC_FLAG,
5358 YE_ANTICIPATED_FLAG,
5359 YE_RESOURCE_EQUITY_FLAG,
5360 YE_RESOURCE_EQUITY_BE_FLAG,
5361 FUND_BALANCE_ACCOUNT_FLAG,
5362 YE_GENERAL_FLAG,
5363 YE_NEG_RECEIVABLES_FLAG,
5364 YE_NEG_PAYABLES_FLAG,
5365 DISBURSEMENTS_FLAG,
5366 COLLECTIONS_FLAG,
5367 USSGL_ENABLED_FLAG,
5368 CREATION_DATE,
5369 CREATED_BY,
5370 LAST_UPDATE_DATE,
5371 LAST_UPDATED_BY,
5372 LAST_UPDATE_LOGIN)
5373 VALUES ('2530', -- ussgl account number
5374 'Securities Issued by Federal Agencies Under General and Special Financing Authority, Net', -- description
5375 'C', -- natural balance
5376 '1', -- reporting type
5377 ' ', -- total resource begin/end flag
5378 ' ', -- total resource debit/credit flag
5379 ' ', -- resource status begin//end flag
5380 ' ', -- resource status debit/credit flag
5381 'N', -- ye end anticipated flag
5382 ' ', -- ye resource/equity flag
5383 ' ', -- ye resource/equity begin/end flag
5384 'N', -- fund balance account flag
5385 'N', -- ye general flag
5386 'N', -- ye negative receivables flag
5387 'N', -- ye negative payables flag
5388 'N', -- disbursement flag
5389 'N', -- collections flag
5390 'Y', -- ussgl enabled flag
5391 sysdate, -- creation_date
5392 FND_GLOBAL.USER_ID, -- created by
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,
5402 TOTAL_RESOURCE_DC_FLAG,
5403 RESOURCE_STATUS_BE_FLAG,
5404 RESOURCE_STATUS_DC_FLAG,
5405 YE_ANTICIPATED_FLAG,
5406 YE_RESOURCE_EQUITY_FLAG,
5407 YE_RESOURCE_EQUITY_BE_FLAG,
5408 FUND_BALANCE_ACCOUNT_FLAG,
5409 YE_GENERAL_FLAG,
5410 YE_NEG_RECEIVABLES_FLAG,
5411 YE_NEG_PAYABLES_FLAG,
5412 DISBURSEMENTS_FLAG,
5413 COLLECTIONS_FLAG,
5414 USSGL_ENABLED_FLAG,
5415 CREATION_DATE,
5416 CREATED_BY,
5417 LAST_UPDATE_DATE,
5418 LAST_UPDATED_BY,
5419 LAST_UPDATE_LOGIN)
5420 VALUES ('2540', -- ussgl account number
5421 'Participation Certificates', -- description
5422 'C', -- natural balance
5423 '1', -- reporting type
5424 ' ', -- total resource begin/end flag
5425 ' ', -- total resource debit/credit flag
5426 ' ', -- resource status begin//end flag
5427 ' ', -- resource status debit/credit flag
5428 'N', -- ye end anticipated flag
5429 ' ', -- ye resource/equity flag
5430 ' ', -- ye resource/equity begin/end flag
5431 'N', -- fund balance account flag
5432 'N', -- ye general flag
5433 'N', -- ye negative receivables flag
5434 'N', -- ye negative payables flag
5435 'N', -- disbursement flag
5436 'N', -- collections flag
5437 'Y', -- ussgl enabled flag
5438 sysdate, -- creation_date
5439 FND_GLOBAL.USER_ID, -- created by
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,
5449 TOTAL_RESOURCE_DC_FLAG,
5450 RESOURCE_STATUS_BE_FLAG,
5451 RESOURCE_STATUS_DC_FLAG,
5452 YE_ANTICIPATED_FLAG,
5453 YE_RESOURCE_EQUITY_FLAG,
5454 YE_RESOURCE_EQUITY_BE_FLAG,
5455 FUND_BALANCE_ACCOUNT_FLAG,
5456 YE_GENERAL_FLAG,
5457 YE_NEG_RECEIVABLES_FLAG,
5458 YE_NEG_PAYABLES_FLAG,
5459 DISBURSEMENTS_FLAG,
5460 COLLECTIONS_FLAG,
5461 USSGL_ENABLED_FLAG,
5462 CREATION_DATE,
5463 CREATED_BY,
5464 LAST_UPDATE_DATE,
5465 LAST_UPDATED_BY,
5466 LAST_UPDATE_LOGIN)
5467 VALUES ('2590', -- ussgl account number
5468 'Other Debt', -- description
5469 'C', -- natural balance
5470 '1', -- reporting type
5471 ' ', -- total resource begin/end flag
5472 ' ', -- total resource debit/credit flag
5473 ' ', -- resource status begin//end flag
5474 ' ', -- resource status debit/credit flag
5475 'N', -- ye end anticipated flag
5476 ' ', -- ye resource/equity flag
5477 ' ', -- ye resource/equity begin/end flag
5478 'N', -- fund balance account flag
5479 'N', -- ye general flag
5480 'N', -- ye negative receivables flag
5481 'N', -- ye negative payables flag
5482 'N', -- disbursement flag
5483 'N', -- collections flag
5484 'Y', -- ussgl enabled flag
5485 sysdate, -- creation_date
5486 FND_GLOBAL.USER_ID, -- created by
5487 sysdate, -- last update date
5488 FND_GLOBAL.USER_ID, -- last updated by
5489 FND_GLOBAL.USER_ID -- last updated login
5490 );
5491 end if;
5492 Exception
5493 When Others Then
5494 errbuf := substr(SQLERRM,1,225);
5495 retcode := -1;
5496 END;
5497 End;