DBA Data[Home] [Help]

APPS.FVFCRT7B dependencies on FV_FACTS_RT7_ACCOUNTS

Line 49: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

45: FND_GLOBAL.USER_ID, -- last updated by
46: FND_GLOBAL.USER_ID -- last updated login
47: );
48:
49: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
50: RT7_ACCOUNT_ID,
51: RT7_CODE_ID,
52: RT7_BE_FLAG,
53: RT7_USSGL_ACCOUNT,

Line 61: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

57: LAST_UPDATE_DATE,
58: LAST_UPDATED_BY,
59: LAST_UPDATE_LOGIN)
60: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
61: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
62: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
63: 'E', -- Begin/End flag
64: '1611', -- USSGL Account
65: 'N', -- Transaction Partner

Line 72: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

68: sysdate, -- last update date
69: FND_GLOBAL.USER_ID, -- last updated by
70: FND_GLOBAL.USER_ID -- last updated login
71: );
72: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
73: RT7_ACCOUNT_ID,
74: RT7_CODE_ID,
75: RT7_BE_FLAG,
76: RT7_USSGL_ACCOUNT,

Line 84: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

80: LAST_UPDATE_DATE,
81: LAST_UPDATED_BY,
82: LAST_UPDATE_LOGIN)
83: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
84: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
85: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
86: 'E', -- Begin/End flag
87: '1621', -- USSGL Account
88: 'N', -- Transaction Partner

Line 119: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

115: sysdate, -- last update date
116: FND_GLOBAL.USER_ID, -- last updated by
117: FND_GLOBAL.USER_ID -- last updated login
118: );
119: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
120: RT7_ACCOUNT_ID,
121: RT7_CODE_ID,
122: RT7_BE_FLAG,
123: RT7_USSGL_ACCOUNT,

Line 131: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

127: LAST_UPDATE_DATE,
128: LAST_UPDATED_BY,
129: LAST_UPDATE_LOGIN)
130: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
131: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
132: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
133: 'E', -- Begin/End flag
134: '1120', -- USSGL Account
135: 'N', -- Transaction Partner

Line 142: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

138: sysdate, -- last update date
139: FND_GLOBAL.USER_ID, -- last updated by
140: FND_GLOBAL.USER_ID -- last updated login
141: );
142: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
143: RT7_ACCOUNT_ID,
144: RT7_CODE_ID,
145: RT7_BE_FLAG,
146: RT7_USSGL_ACCOUNT,

Line 154: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

150: LAST_UPDATE_DATE,
151: LAST_UPDATED_BY,
152: LAST_UPDATE_LOGIN)
153: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
154: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
155: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
156: 'E', -- Begin/End flag
157: '1130', -- USSGL Account
158: 'N', -- Transaction Partner

Line 190: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

186: sysdate, -- last update date
187: FND_GLOBAL.USER_ID, -- last updated by
188: FND_GLOBAL.USER_ID -- last updated login
189: );
190: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
191: RT7_ACCOUNT_ID,
192: RT7_CODE_ID,
193: RT7_BE_FLAG,
194: RT7_USSGL_ACCOUNT,

Line 202: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

198: LAST_UPDATE_DATE,
199: LAST_UPDATED_BY,
200: LAST_UPDATE_LOGIN)
201: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
202: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
203: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
204: 'E', -- Begin/End flag
205: '1611', -- USSGL Account
206: 'N', -- Transaction Partner

Line 213: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

209: sysdate, -- last update date
210: FND_GLOBAL.USER_ID, -- last updated by
211: FND_GLOBAL.USER_ID -- last updated login
212: );
213: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
214: RT7_ACCOUNT_ID,
215: RT7_CODE_ID,
216: RT7_BE_FLAG,
217: RT7_USSGL_ACCOUNT,

Line 225: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

221: LAST_UPDATE_DATE,
222: LAST_UPDATED_BY,
223: LAST_UPDATE_LOGIN)
224: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
225: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
226: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
227: 'E', -- Begin/End flag
228: '1612', -- USSGL Account
229: 'N', -- Transaction Partner

Line 236: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

232: sysdate, -- last update date
233: FND_GLOBAL.USER_ID, -- last updated by
234: FND_GLOBAL.USER_ID -- last updated login
235: );
236: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
237: RT7_ACCOUNT_ID,
238: RT7_CODE_ID,
239: RT7_BE_FLAG,
240: RT7_USSGL_ACCOUNT,

Line 248: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

244: LAST_UPDATE_DATE,
245: LAST_UPDATED_BY,
246: LAST_UPDATE_LOGIN)
247: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
248: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
249: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
250: 'E', -- Begin/End flag
251: '1613', -- USSGL Account
252: 'N', -- Transaction Partner

Line 283: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

279: sysdate, -- last update date
280: FND_GLOBAL.USER_ID, -- last updated by
281: FND_GLOBAL.USER_ID -- last updated login
282: );
283: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
284: RT7_ACCOUNT_ID,
285: RT7_CODE_ID,
286: RT7_BE_FLAG,
287: RT7_USSGL_ACCOUNT,

Line 295: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

291: LAST_UPDATE_DATE,
292: LAST_UPDATED_BY,
293: LAST_UPDATE_LOGIN)
294: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
295: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
296: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
297: 'E', -- Begin/End flag
298: '4032', -- USSGL Account
299: 'N', -- Transaction Partner

Line 307: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

303: FND_GLOBAL.USER_ID, -- last updated by
304: FND_GLOBAL.USER_ID -- last updated login
305: );
306:
307: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
308: RT7_ACCOUNT_ID,
309: RT7_CODE_ID,
310: RT7_BE_FLAG,
311: RT7_USSGL_ACCOUNT,

Line 319: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

315: LAST_UPDATE_DATE,
316: LAST_UPDATED_BY,
317: LAST_UPDATE_LOGIN)
318: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
319: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
320: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
321: 'E', -- Begin/End flag
322: '4034', -- USSGL Account
323: 'N', -- Transaction Partner

Line 331: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

327: FND_GLOBAL.USER_ID, -- last updated by
328: FND_GLOBAL.USER_ID -- last updated login
329: );
330:
331: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
332: RT7_ACCOUNT_ID,
333: RT7_CODE_ID,
334: RT7_BE_FLAG,
335: RT7_USSGL_ACCOUNT,

Line 343: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

339: LAST_UPDATE_DATE,
340: LAST_UPDATED_BY,
341: LAST_UPDATE_LOGIN)
342: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
343: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
344: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
345: 'E', -- Begin/End flag
346: '4131', -- USSGL Account
347: 'N', -- Transaction Partner

Line 355: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

351: FND_GLOBAL.USER_ID, -- last updated by
352: FND_GLOBAL.USER_ID -- last updated login
353: );
354:
355: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
356: RT7_ACCOUNT_ID,
357: RT7_CODE_ID,
358: RT7_BE_FLAG,
359: RT7_USSGL_ACCOUNT,

Line 367: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

363: LAST_UPDATE_DATE,
364: LAST_UPDATED_BY,
365: LAST_UPDATE_LOGIN)
366: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
367: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
368: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
369: 'E', -- Begin/End flag
370: '4132', -- USSGL Account
371: 'N', -- Transaction Partner

Line 379: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

375: FND_GLOBAL.USER_ID, -- last updated by
376: FND_GLOBAL.USER_ID -- last updated login
377: );
378:
379: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
380: RT7_ACCOUNT_ID,
381: RT7_CODE_ID,
382: RT7_BE_FLAG,
383: RT7_USSGL_ACCOUNT,

Line 391: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

387: LAST_UPDATE_DATE,
388: LAST_UPDATED_BY,
389: LAST_UPDATE_LOGIN)
390: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
391: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
392: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
393: 'E', -- Begin/End flag
394: '4133', -- USSGL Account
395: 'N', -- Transaction Partner

Line 403: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

399: FND_GLOBAL.USER_ID, -- last updated by
400: FND_GLOBAL.USER_ID -- last updated login
401: );
402:
403: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
404: RT7_ACCOUNT_ID,
405: RT7_CODE_ID,
406: RT7_BE_FLAG,
407: RT7_USSGL_ACCOUNT,

Line 415: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

411: LAST_UPDATE_DATE,
412: LAST_UPDATED_BY,
413: LAST_UPDATE_LOGIN)
414: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
415: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
416: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
417: 'E', -- Begin/End flag
418: '4135', -- USSGL Account
419: 'N', -- Transaction Partner

Line 427: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

423: FND_GLOBAL.USER_ID, -- last updated by
424: FND_GLOBAL.USER_ID -- last updated login
425: );
426:
427: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
428: RT7_ACCOUNT_ID,
429: RT7_CODE_ID,
430: RT7_BE_FLAG,
431: RT7_USSGL_ACCOUNT,

Line 439: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

435: LAST_UPDATE_DATE,
436: LAST_UPDATED_BY,
437: LAST_UPDATE_LOGIN)
438: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
439: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
440: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
441: 'E', -- Begin/End flag
442: '4138', -- USSGL Account
443: 'N', -- Transaction Partner

Line 451: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

447: FND_GLOBAL.USER_ID, -- last updated by
448: FND_GLOBAL.USER_ID -- last updated login
449: );
450:
451: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
452: RT7_ACCOUNT_ID,
453: RT7_CODE_ID,
454: RT7_BE_FLAG,
455: RT7_USSGL_ACCOUNT,

Line 463: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

459: LAST_UPDATE_DATE,
460: LAST_UPDATED_BY,
461: LAST_UPDATE_LOGIN)
462: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
463: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
464: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
465: 'B', -- Begin/End flag
466: '4139', -- USSGL Account
467: 'N', -- Transaction Partner

Line 498: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

494: sysdate, -- last update date
495: FND_GLOBAL.USER_ID, -- last updated by
496: FND_GLOBAL.USER_ID -- last updated login
497: );
498: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
499: RT7_ACCOUNT_ID,
500: RT7_CODE_ID,
501: RT7_BE_FLAG,
502: RT7_USSGL_ACCOUNT,

Line 510: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

506: LAST_UPDATE_DATE,
507: LAST_UPDATED_BY,
508: LAST_UPDATE_LOGIN)
509: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
510: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
511: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
512: 'E', -- Begin/End flag
513: '4042', -- USSGL Account
514: 'N', -- Transaction Partner

Line 522: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

518: FND_GLOBAL.USER_ID, -- last updated by
519: FND_GLOBAL.USER_ID -- last updated login
520: );
521:
522: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
523: RT7_ACCOUNT_ID,
524: RT7_CODE_ID,
525: RT7_BE_FLAG,
526: RT7_USSGL_ACCOUNT,

Line 534: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

530: LAST_UPDATE_DATE,
531: LAST_UPDATED_BY,
532: LAST_UPDATE_LOGIN)
533: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
534: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
535: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
536: 'E', -- Begin/End flag
537: '4044', -- USSGL Account
538: 'N', -- Transaction Partner

Line 546: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

542: FND_GLOBAL.USER_ID, -- last updated by
543: FND_GLOBAL.USER_ID -- last updated login
544: );
545:
546: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
547: RT7_ACCOUNT_ID,
548: RT7_CODE_ID,
549: RT7_BE_FLAG,
550: RT7_USSGL_ACCOUNT,

Line 558: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

554: LAST_UPDATE_DATE,
555: LAST_UPDATED_BY,
556: LAST_UPDATE_LOGIN)
557: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
558: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
559: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
560: 'E', -- Begin/End flag
561: '4141', -- USSGL Account
562: 'N', -- Transaction Partner

Line 570: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

566: FND_GLOBAL.USER_ID, -- last updated by
567: FND_GLOBAL.USER_ID -- last updated login
568: );
569:
570: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
571: RT7_ACCOUNT_ID,
572: RT7_CODE_ID,
573: RT7_BE_FLAG,
574: RT7_USSGL_ACCOUNT,

Line 582: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

578: LAST_UPDATE_DATE,
579: LAST_UPDATED_BY,
580: LAST_UPDATE_LOGIN)
581: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
582: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
583: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
584: 'E', -- Begin/End flag
585: '4142', -- USSGL Account
586: 'N', -- Transaction Partner

Line 594: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

590: FND_GLOBAL.USER_ID, -- last updated by
591: FND_GLOBAL.USER_ID -- last updated login
592: );
593:
594: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
595: RT7_ACCOUNT_ID,
596: RT7_CODE_ID,
597: RT7_BE_FLAG,
598: RT7_USSGL_ACCOUNT,

Line 606: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

602: LAST_UPDATE_DATE,
603: LAST_UPDATED_BY,
604: LAST_UPDATE_LOGIN)
605: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
606: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
607: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
608: 'E', -- Begin/End flag
609: '4143', -- USSGL Account
610: 'N', -- Transaction Partner

Line 618: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

614: FND_GLOBAL.USER_ID, -- last updated by
615: FND_GLOBAL.USER_ID -- last updated login
616: );
617:
618: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
619: RT7_ACCOUNT_ID,
620: RT7_CODE_ID,
621: RT7_BE_FLAG,
622: RT7_USSGL_ACCOUNT,

Line 630: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

626: LAST_UPDATE_DATE,
627: LAST_UPDATED_BY,
628: LAST_UPDATE_LOGIN)
629: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
630: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
631: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
632: 'E', -- Begin/End flag
633: '4145', -- USSGL Account
634: 'N', -- Transaction Partner

Line 642: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

638: FND_GLOBAL.USER_ID, -- last updated by
639: FND_GLOBAL.USER_ID -- last updated login
640: );
641:
642: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
643: RT7_ACCOUNT_ID,
644: RT7_CODE_ID,
645: RT7_BE_FLAG,
646: RT7_USSGL_ACCOUNT,

Line 654: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

650: LAST_UPDATE_DATE,
651: LAST_UPDATED_BY,
652: LAST_UPDATE_LOGIN)
653: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
654: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
655: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
656: 'E', -- Begin/End flag
657: '4148', -- USSGL Account
658: 'N', -- Transaction Partner

Line 666: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

662: FND_GLOBAL.USER_ID, -- last updated by
663: FND_GLOBAL.USER_ID -- last updated login
664: );
665:
666: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
667: RT7_ACCOUNT_ID,
668: RT7_CODE_ID,
669: RT7_BE_FLAG,
670: RT7_USSGL_ACCOUNT,

Line 678: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

674: LAST_UPDATE_DATE,
675: LAST_UPDATED_BY,
676: LAST_UPDATE_LOGIN)
677: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
678: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
679: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
680: 'B', -- Begin/End flag
681: '4149', -- USSGL Account
682: 'N', -- Transaction Partner

Line 713: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

709: sysdate, -- last update date
710: FND_GLOBAL.USER_ID, -- last updated by
711: FND_GLOBAL.USER_ID -- last updated login
712: );
713: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
714: RT7_ACCOUNT_ID,
715: RT7_CODE_ID,
716: RT7_BE_FLAG,
717: RT7_USSGL_ACCOUNT,

Line 725: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

721: LAST_UPDATE_DATE,
722: LAST_UPDATED_BY,
723: LAST_UPDATE_LOGIN)
724: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
725: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
726: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
727: 'E', -- Begin/End flag
728: '4042', -- USSGL Account
729: 'N', -- Transaction Partner

Line 737: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

733: FND_GLOBAL.USER_ID, -- last updated by
734: FND_GLOBAL.USER_ID -- last updated login
735: );
736:
737: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
738: RT7_ACCOUNT_ID,
739: RT7_CODE_ID,
740: RT7_BE_FLAG,
741: RT7_USSGL_ACCOUNT,

Line 749: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

745: LAST_UPDATE_DATE,
746: LAST_UPDATED_BY,
747: LAST_UPDATE_LOGIN)
748: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
749: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
750: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
751: 'E', -- Begin/End flag
752: '4044', -- USSGL Account
753: 'N', -- Transaction Partner

Line 761: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

757: FND_GLOBAL.USER_ID, -- last updated by
758: FND_GLOBAL.USER_ID -- last updated login
759: );
760:
761: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
762: RT7_ACCOUNT_ID,
763: RT7_CODE_ID,
764: RT7_BE_FLAG,
765: RT7_USSGL_ACCOUNT,

Line 773: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

769: LAST_UPDATE_DATE,
770: LAST_UPDATED_BY,
771: LAST_UPDATE_LOGIN)
772: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
773: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
774: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
775: 'E', -- Begin/End flag
776: '4141', -- USSGL Account
777: 'N', -- Transaction Partner

Line 785: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

781: FND_GLOBAL.USER_ID, -- last updated by
782: FND_GLOBAL.USER_ID -- last updated login
783: );
784:
785: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
786: RT7_ACCOUNT_ID,
787: RT7_CODE_ID,
788: RT7_BE_FLAG,
789: RT7_USSGL_ACCOUNT,

Line 797: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

793: LAST_UPDATE_DATE,
794: LAST_UPDATED_BY,
795: LAST_UPDATE_LOGIN)
796: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
797: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
798: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
799: 'E', -- Begin/End flag
800: '4142', -- USSGL Account
801: 'N', -- Transaction Partner

Line 809: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

805: FND_GLOBAL.USER_ID, -- last updated by
806: FND_GLOBAL.USER_ID -- last updated login
807: );
808:
809: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
810: RT7_ACCOUNT_ID,
811: RT7_CODE_ID,
812: RT7_BE_FLAG,
813: RT7_USSGL_ACCOUNT,

Line 821: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

817: LAST_UPDATE_DATE,
818: LAST_UPDATED_BY,
819: LAST_UPDATE_LOGIN)
820: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
821: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
822: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
823: 'E', -- Begin/End flag
824: '4143', -- USSGL Account
825: 'N', -- Transaction Partner

Line 833: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

829: FND_GLOBAL.USER_ID, -- last updated by
830: FND_GLOBAL.USER_ID -- last updated login
831: );
832:
833: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
834: RT7_ACCOUNT_ID,
835: RT7_CODE_ID,
836: RT7_BE_FLAG,
837: RT7_USSGL_ACCOUNT,

Line 845: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

841: LAST_UPDATE_DATE,
842: LAST_UPDATED_BY,
843: LAST_UPDATE_LOGIN)
844: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
845: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
846: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
847: 'E', -- Begin/End flag
848: '4145', -- USSGL Account
849: 'N', -- Transaction Partner

Line 857: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

853: FND_GLOBAL.USER_ID, -- last updated by
854: FND_GLOBAL.USER_ID -- last updated login
855: );
856:
857: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
858: RT7_ACCOUNT_ID,
859: RT7_CODE_ID,
860: RT7_BE_FLAG,
861: RT7_USSGL_ACCOUNT,

Line 869: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

865: LAST_UPDATE_DATE,
866: LAST_UPDATED_BY,
867: LAST_UPDATE_LOGIN)
868: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
869: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
870: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
871: 'E', -- Begin/End flag
872: '4148', -- USSGL Account
873: 'N', -- Transaction Partner

Line 881: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

877: FND_GLOBAL.USER_ID, -- last updated by
878: FND_GLOBAL.USER_ID -- last updated login
879: );
880:
881: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
882: RT7_ACCOUNT_ID,
883: RT7_CODE_ID,
884: RT7_BE_FLAG,
885: RT7_USSGL_ACCOUNT,

Line 893: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

889: LAST_UPDATE_DATE,
890: LAST_UPDATED_BY,
891: LAST_UPDATE_LOGIN)
892: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
893: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
894: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
895: 'B', -- Begin/End flag
896: '4149', -- USSGL Account
897: 'N', -- Transaction Partner

Line 928: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

924: sysdate, -- last update date
925: FND_GLOBAL.USER_ID, -- last updated by
926: FND_GLOBAL.USER_ID -- last updated login
927: );
928: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
929: RT7_ACCOUNT_ID,
930: RT7_CODE_ID,
931: RT7_BE_FLAG,
932: RT7_USSGL_ACCOUNT,

Line 940: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

936: LAST_UPDATE_DATE,
937: LAST_UPDATED_BY,
938: LAST_UPDATE_LOGIN)
939: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
940: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
941: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
942: 'E', -- Begin/End flag
943: '1610', -- USSGL Account
944: 'N', -- Transaction Partner

Line 976: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,

972: FND_GLOBAL.USER_ID, -- last updated by
973: FND_GLOBAL.USER_ID -- last updated login
974: );
975:
976: INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
977: RT7_ACCOUNT_ID,
978: RT7_CODE_ID,
979: RT7_BE_FLAG,
980: RT7_USSGL_ACCOUNT,

Line 988: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id

984: LAST_UPDATE_DATE,
985: LAST_UPDATED_BY,
986: LAST_UPDATE_LOGIN)
987: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
988: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
989: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
990: 'E', -- Begin/End flag
991: '1620', -- USSGL Account
992: 'F', -- Transaction Partner