DBA Data[Home] [Help]

APPS.FVFCATT2 dependencies on FV_FACTS_ATTRIBUTES

Line 15: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

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: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
16: SGL_ATTRIBUTES_ID,
17: FACTS_ACCT_NUMBER,
18: USSGL_ACCT_NUMBER,
19: BALANCE_TYPE,

Line 44: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

40: LAST_UPDATE_DATE,
41: LAST_UPDATED_BY,
42: LAST_UPDATE_LOGIN)
43: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
44: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
45: '2990', -- facct account number
46: '2990', -- ussgl account number
47: 'E', -- balance type
48: 'N', -- authority type

Line 72: INSERT INTO FV_FACTS_ATTRIBUTES (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_ATTRIBUTES (SET_OF_BOOKS_ID,
73: SGL_ATTRIBUTES_ID,
74: FACTS_ACCT_NUMBER,
75: USSGL_ACCT_NUMBER,
76: BALANCE_TYPE,

Line 101: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

97: LAST_UPDATE_DATE,
98: LAST_UPDATED_BY,
99: LAST_UPDATE_LOGIN)
100: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
101: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
102: '2995', -- facct account number
103: '2995', -- ussgl account number
104: 'E', -- balance type
105: 'N', -- authority type

Line 129: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

125: sysdate, -- last update date
126: FND_GLOBAL.USER_ID, -- last updated by
127: FND_GLOBAL.USER_ID -- last updated login
128: );
129: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
130: SGL_ATTRIBUTES_ID,
131: FACTS_ACCT_NUMBER,
132: USSGL_ACCT_NUMBER,
133: BALANCE_TYPE,

Line 158: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

154: LAST_UPDATE_DATE,
155: LAST_UPDATED_BY,
156: LAST_UPDATE_LOGIN)
157: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
158: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
159: '3100', -- facct account number
160: '3100', -- ussgl account number
161: 'E', -- balance type
162: 'N', -- authority type

Line 186: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

182: sysdate, -- last update date
183: FND_GLOBAL.USER_ID, -- last updated by
184: FND_GLOBAL.USER_ID -- last updated login
185: );
186: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
187: SGL_ATTRIBUTES_ID,
188: FACTS_ACCT_NUMBER,
189: USSGL_ACCT_NUMBER,
190: BALANCE_TYPE,

Line 215: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

211: LAST_UPDATE_DATE,
212: LAST_UPDATED_BY,
213: LAST_UPDATE_LOGIN)
214: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
215: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
216: '3105', -- facct account number
217: '3105', -- ussgl account number
218: 'E', -- balance type
219: 'N', -- authority type

Line 243: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

239: sysdate, -- last update date
240: FND_GLOBAL.USER_ID, -- last updated by
241: FND_GLOBAL.USER_ID -- last updated login
242: );
243: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
244: SGL_ATTRIBUTES_ID,
245: FACTS_ACCT_NUMBER,
246: USSGL_ACCT_NUMBER,
247: BALANCE_TYPE,

Line 272: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

268: LAST_UPDATE_DATE,
269: LAST_UPDATED_BY,
270: LAST_UPDATE_LOGIN)
271: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
272: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
273: '3310', -- facct account number
274: '3310', -- ussgl account number
275: 'E', -- balance type
276: 'N', -- authority type

Line 300: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

296: sysdate, -- last update date
297: FND_GLOBAL.USER_ID, -- last updated by
298: FND_GLOBAL.USER_ID -- last updated login
299: );
300: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
301: SGL_ATTRIBUTES_ID,
302: FACTS_ACCT_NUMBER,
303: USSGL_ACCT_NUMBER,
304: BALANCE_TYPE,

Line 329: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

325: LAST_UPDATE_DATE,
326: LAST_UPDATED_BY,
327: LAST_UPDATE_LOGIN)
328: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
329: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
330: '5100', -- facct account number
331: '5100', -- ussgl account number
332: 'E', -- balance type
333: 'N', -- authority type

Line 357: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

353: sysdate, -- last update date
354: FND_GLOBAL.USER_ID, -- last updated by
355: FND_GLOBAL.USER_ID -- last updated login
356: );
357: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
358: SGL_ATTRIBUTES_ID,
359: FACTS_ACCT_NUMBER,
360: USSGL_ACCT_NUMBER,
361: BALANCE_TYPE,

Line 386: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

382: LAST_UPDATE_DATE,
383: LAST_UPDATED_BY,
384: LAST_UPDATE_LOGIN)
385: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
386: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
387: '5109', -- facct account number
388: '5109', -- ussgl account number
389: 'E', -- balance type
390: 'N', -- authority type

Line 414: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

410: sysdate, -- last update date
411: FND_GLOBAL.USER_ID, -- last updated by
412: FND_GLOBAL.USER_ID -- last updated login
413: );
414: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
415: SGL_ATTRIBUTES_ID,
416: FACTS_ACCT_NUMBER,
417: USSGL_ACCT_NUMBER,
418: BALANCE_TYPE,

Line 443: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

439: LAST_UPDATE_DATE,
440: LAST_UPDATED_BY,
441: LAST_UPDATE_LOGIN)
442: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
443: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
444: '5200', -- facct account number
445: '5200', -- ussgl account number
446: 'E', -- balance type
447: 'N', -- authority type

Line 471: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

467: sysdate, -- last update date
468: FND_GLOBAL.USER_ID, -- last updated by
469: FND_GLOBAL.USER_ID -- last updated login
470: );
471: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
472: SGL_ATTRIBUTES_ID,
473: FACTS_ACCT_NUMBER,
474: USSGL_ACCT_NUMBER,
475: BALANCE_TYPE,

Line 500: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

496: LAST_UPDATE_DATE,
497: LAST_UPDATED_BY,
498: LAST_UPDATE_LOGIN)
499: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
500: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
501: '5209', -- facct account number
502: '5209', -- ussgl account number
503: 'E', -- balance type
504: 'N', -- authority type

Line 528: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

524: sysdate, -- last update date
525: FND_GLOBAL.USER_ID, -- last updated by
526: FND_GLOBAL.USER_ID -- last updated login
527: );
528: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
529: SGL_ATTRIBUTES_ID,
530: FACTS_ACCT_NUMBER,
531: USSGL_ACCT_NUMBER,
532: BALANCE_TYPE,

Line 557: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

553: LAST_UPDATE_DATE,
554: LAST_UPDATED_BY,
555: LAST_UPDATE_LOGIN)
556: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
557: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
558: '5310', -- facct account number
559: '5310', -- ussgl account number
560: 'E', -- balance type
561: 'N', -- authority type

Line 585: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

581: sysdate, -- last update date
582: FND_GLOBAL.USER_ID, -- last updated by
583: FND_GLOBAL.USER_ID -- last updated login
584: );
585: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
586: SGL_ATTRIBUTES_ID,
587: FACTS_ACCT_NUMBER,
588: USSGL_ACCT_NUMBER,
589: BALANCE_TYPE,

Line 614: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

610: LAST_UPDATE_DATE,
611: LAST_UPDATED_BY,
612: LAST_UPDATE_LOGIN)
613: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
614: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
615: '5319', -- facct account number
616: '5319', -- ussgl account number
617: 'E', -- balance type
618: 'N', -- authority type

Line 642: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

638: sysdate, -- last update date
639: FND_GLOBAL.USER_ID, -- last updated by
640: FND_GLOBAL.USER_ID -- last updated login
641: );
642: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
643: SGL_ATTRIBUTES_ID,
644: FACTS_ACCT_NUMBER,
645: USSGL_ACCT_NUMBER,
646: BALANCE_TYPE,

Line 671: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

667: LAST_UPDATE_DATE,
668: LAST_UPDATED_BY,
669: LAST_UPDATE_LOGIN)
670: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
671: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
672: '5320', -- facct account number
673: '5320', -- ussgl account number
674: 'E', -- balance type
675: 'N', -- authority type

Line 699: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

695: sysdate, -- last update date
696: FND_GLOBAL.USER_ID, -- last updated by
697: FND_GLOBAL.USER_ID -- last updated login
698: );
699: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
700: SGL_ATTRIBUTES_ID,
701: FACTS_ACCT_NUMBER,
702: USSGL_ACCT_NUMBER,
703: BALANCE_TYPE,

Line 728: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

724: LAST_UPDATE_DATE,
725: LAST_UPDATED_BY,
726: LAST_UPDATE_LOGIN)
727: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
728: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
729: '5329', -- facct account number
730: '5329', -- ussgl account number
731: 'E', -- balance type
732: 'N', -- authority type

Line 756: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

752: sysdate, -- last update date
753: FND_GLOBAL.USER_ID, -- last updated by
754: FND_GLOBAL.USER_ID -- last updated login
755: );
756: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
757: SGL_ATTRIBUTES_ID,
758: FACTS_ACCT_NUMBER,
759: USSGL_ACCT_NUMBER,
760: BALANCE_TYPE,

Line 785: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

781: LAST_UPDATE_DATE,
782: LAST_UPDATED_BY,
783: LAST_UPDATE_LOGIN)
784: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
785: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
786: '5400', -- facct account number
787: '5400', -- ussgl account number
788: 'E', -- balance type
789: 'N', -- authority type

Line 813: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

809: sysdate, -- last update date
810: FND_GLOBAL.USER_ID, -- last updated by
811: FND_GLOBAL.USER_ID -- last updated login
812: );
813: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
814: SGL_ATTRIBUTES_ID,
815: FACTS_ACCT_NUMBER,
816: USSGL_ACCT_NUMBER,
817: BALANCE_TYPE,

Line 842: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

838: LAST_UPDATE_DATE,
839: LAST_UPDATED_BY,
840: LAST_UPDATE_LOGIN)
841: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
842: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
843: '5409', -- facct account number
844: '5409', -- ussgl account number
845: 'E', -- balance type
846: 'N', -- authority type

Line 870: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

866: sysdate, -- last update date
867: FND_GLOBAL.USER_ID, -- last updated by
868: FND_GLOBAL.USER_ID -- last updated login
869: );
870: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
871: SGL_ATTRIBUTES_ID,
872: FACTS_ACCT_NUMBER,
873: USSGL_ACCT_NUMBER,
874: BALANCE_TYPE,

Line 899: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

895: LAST_UPDATE_DATE,
896: LAST_UPDATED_BY,
897: LAST_UPDATE_LOGIN)
898: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
899: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
900: '5500', -- facct account number
901: '5500', -- ussgl account number
902: 'E', -- balance type
903: 'N', -- authority type

Line 927: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

923: sysdate, -- last update date
924: FND_GLOBAL.USER_ID, -- last updated by
925: FND_GLOBAL.USER_ID -- last updated login
926: );
927: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
928: SGL_ATTRIBUTES_ID,
929: FACTS_ACCT_NUMBER,
930: USSGL_ACCT_NUMBER,
931: BALANCE_TYPE,

Line 956: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

952: LAST_UPDATE_DATE,
953: LAST_UPDATED_BY,
954: LAST_UPDATE_LOGIN)
955: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
956: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
957: '5509', -- facct account number
958: '5509', -- ussgl account number
959: 'E', -- balance type
960: 'N', -- authority type

Line 984: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

980: sysdate, -- last update date
981: FND_GLOBAL.USER_ID, -- last updated by
982: FND_GLOBAL.USER_ID -- last updated login
983: );
984: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
985: SGL_ATTRIBUTES_ID,
986: FACTS_ACCT_NUMBER,
987: USSGL_ACCT_NUMBER,
988: BALANCE_TYPE,

Line 1013: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

1009: LAST_UPDATE_DATE,
1010: LAST_UPDATED_BY,
1011: LAST_UPDATE_LOGIN)
1012: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1013: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1014: '5600', -- facct account number
1015: '5600', -- ussgl account number
1016: 'E', -- balance type
1017: 'N', -- authority type

Line 1041: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

1037: sysdate, -- last update date
1038: FND_GLOBAL.USER_ID, -- last updated by
1039: FND_GLOBAL.USER_ID -- last updated login
1040: );
1041: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1042: SGL_ATTRIBUTES_ID,
1043: FACTS_ACCT_NUMBER,
1044: USSGL_ACCT_NUMBER,
1045: BALANCE_TYPE,

Line 1070: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

1066: LAST_UPDATE_DATE,
1067: LAST_UPDATED_BY,
1068: LAST_UPDATE_LOGIN)
1069: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1070: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1071: '5609', -- facct account number
1072: '5609', -- ussgl account number
1073: 'E', -- balance type
1074: 'N', -- authority type

Line 1098: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

1094: sysdate, -- last update date
1095: FND_GLOBAL.USER_ID, -- last updated by
1096: FND_GLOBAL.USER_ID -- last updated login
1097: );
1098: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1099: SGL_ATTRIBUTES_ID,
1100: FACTS_ACCT_NUMBER,
1101: USSGL_ACCT_NUMBER,
1102: BALANCE_TYPE,

Line 1127: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

1123: LAST_UPDATE_DATE,
1124: LAST_UPDATED_BY,
1125: LAST_UPDATE_LOGIN)
1126: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1127: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1128: '5610', -- facct account number
1129: '5610', -- ussgl account number
1130: 'E', -- balance type
1131: 'N', -- authority type

Line 1155: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

1151: sysdate, -- last update date
1152: FND_GLOBAL.USER_ID, -- last updated by
1153: FND_GLOBAL.USER_ID -- last updated login
1154: );
1155: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1156: SGL_ATTRIBUTES_ID,
1157: FACTS_ACCT_NUMBER,
1158: USSGL_ACCT_NUMBER,
1159: BALANCE_TYPE,

Line 1184: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

1180: LAST_UPDATE_DATE,
1181: LAST_UPDATED_BY,
1182: LAST_UPDATE_LOGIN)
1183: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1184: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1185: '5619', -- facct account number
1186: '5619', -- ussgl account number
1187: 'E', -- balance type
1188: 'N', -- authority type

Line 1212: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

1208: sysdate, -- last update date
1209: FND_GLOBAL.USER_ID, -- last updated by
1210: FND_GLOBAL.USER_ID -- last updated login
1211: );
1212: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1213: SGL_ATTRIBUTES_ID,
1214: FACTS_ACCT_NUMBER,
1215: USSGL_ACCT_NUMBER,
1216: BALANCE_TYPE,

Line 1241: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

1237: LAST_UPDATE_DATE,
1238: LAST_UPDATED_BY,
1239: LAST_UPDATE_LOGIN)
1240: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1241: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1242: '5700', -- facct account number
1243: '5700', -- ussgl account number
1244: 'E', -- balance type
1245: 'N', -- authority type

Line 1269: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

1265: sysdate, -- last update date
1266: FND_GLOBAL.USER_ID, -- last updated by
1267: FND_GLOBAL.USER_ID -- last updated login
1268: );
1269: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1270: SGL_ATTRIBUTES_ID,
1271: FACTS_ACCT_NUMBER,
1272: USSGL_ACCT_NUMBER,
1273: BALANCE_TYPE,

Line 1298: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

1294: LAST_UPDATE_DATE,
1295: LAST_UPDATED_BY,
1296: LAST_UPDATE_LOGIN)
1297: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1298: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1299: '5720', -- facct account number
1300: '5720', -- ussgl account number
1301: 'E', -- balance type
1302: 'N', -- authority type

Line 1326: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

1322: sysdate, -- last update date
1323: FND_GLOBAL.USER_ID, -- last updated by
1324: FND_GLOBAL.USER_ID -- last updated login
1325: );
1326: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1327: SGL_ATTRIBUTES_ID,
1328: FACTS_ACCT_NUMBER,
1329: USSGL_ACCT_NUMBER,
1330: BALANCE_TYPE,

Line 1355: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

1351: LAST_UPDATE_DATE,
1352: LAST_UPDATED_BY,
1353: LAST_UPDATE_LOGIN)
1354: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1355: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1356: '5730', -- facct account number
1357: '5730', -- ussgl account number
1358: 'E', -- balance type
1359: 'N', -- authority type

Line 1383: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

1379: sysdate, -- last update date
1380: FND_GLOBAL.USER_ID, -- last updated by
1381: FND_GLOBAL.USER_ID -- last updated login
1382: );
1383: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1384: SGL_ATTRIBUTES_ID,
1385: FACTS_ACCT_NUMBER,
1386: USSGL_ACCT_NUMBER,
1387: BALANCE_TYPE,

Line 1412: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

1408: LAST_UPDATE_DATE,
1409: LAST_UPDATED_BY,
1410: LAST_UPDATE_LOGIN)
1411: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1412: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1413: '5740', -- facct account number
1414: '5740', -- ussgl account number
1415: 'E', -- balance type
1416: 'N', -- authority type

Line 1440: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

1436: sysdate, -- last update date
1437: FND_GLOBAL.USER_ID, -- last updated by
1438: FND_GLOBAL.USER_ID -- last updated login
1439: );
1440: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1441: SGL_ATTRIBUTES_ID,
1442: FACTS_ACCT_NUMBER,
1443: USSGL_ACCT_NUMBER,
1444: BALANCE_TYPE,

Line 1469: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

1465: LAST_UPDATE_DATE,
1466: LAST_UPDATED_BY,
1467: LAST_UPDATE_LOGIN)
1468: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1469: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1470: '5745', -- facct account number
1471: '5745', -- ussgl account number
1472: 'E', -- balance type
1473: 'N', -- authority type

Line 1497: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

1493: sysdate, -- last update date
1494: FND_GLOBAL.USER_ID, -- last updated by
1495: FND_GLOBAL.USER_ID -- last updated login
1496: );
1497: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1498: SGL_ATTRIBUTES_ID,
1499: FACTS_ACCT_NUMBER,
1500: USSGL_ACCT_NUMBER,
1501: BALANCE_TYPE,

Line 1526: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

1522: LAST_UPDATE_DATE,
1523: LAST_UPDATED_BY,
1524: LAST_UPDATE_LOGIN)
1525: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1526: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1527: '5750', -- facct account number
1528: '5750', -- ussgl account number
1529: 'E', -- balance type
1530: 'N', -- authority type

Line 1554: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

1550: sysdate, -- last update date
1551: FND_GLOBAL.USER_ID, -- last updated by
1552: FND_GLOBAL.USER_ID -- last updated login
1553: );
1554: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1555: SGL_ATTRIBUTES_ID,
1556: FACTS_ACCT_NUMBER,
1557: USSGL_ACCT_NUMBER,
1558: BALANCE_TYPE,

Line 1583: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

1579: LAST_UPDATE_DATE,
1580: LAST_UPDATED_BY,
1581: LAST_UPDATE_LOGIN)
1582: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1583: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1584: '5755', -- facct account number
1585: '5755', -- ussgl account number
1586: 'E', -- balance type
1587: 'N', -- authority type

Line 1611: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

1607: sysdate, -- last update date
1608: FND_GLOBAL.USER_ID, -- last updated by
1609: FND_GLOBAL.USER_ID -- last updated login
1610: );
1611: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1612: SGL_ATTRIBUTES_ID,
1613: FACTS_ACCT_NUMBER,
1614: USSGL_ACCT_NUMBER,
1615: BALANCE_TYPE,

Line 1640: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

1636: LAST_UPDATE_DATE,
1637: LAST_UPDATED_BY,
1638: LAST_UPDATE_LOGIN)
1639: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1640: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1641: '5760', -- facct account number
1642: '5760', -- ussgl account number
1643: 'E', -- balance type
1644: 'N', -- authority type

Line 1668: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

1664: sysdate, -- last update date
1665: FND_GLOBAL.USER_ID, -- last updated by
1666: FND_GLOBAL.USER_ID -- last updated login
1667: );
1668: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1669: SGL_ATTRIBUTES_ID,
1670: FACTS_ACCT_NUMBER,
1671: USSGL_ACCT_NUMBER,
1672: BALANCE_TYPE,

Line 1697: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

1693: LAST_UPDATE_DATE,
1694: LAST_UPDATED_BY,
1695: LAST_UPDATE_LOGIN)
1696: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1697: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1698: '5765', -- facct account number
1699: '5765', -- ussgl account number
1700: 'E', -- balance type
1701: 'N', -- authority type

Line 1725: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

1721: sysdate, -- last update date
1722: FND_GLOBAL.USER_ID, -- last updated by
1723: FND_GLOBAL.USER_ID -- last updated login
1724: );
1725: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1726: SGL_ATTRIBUTES_ID,
1727: FACTS_ACCT_NUMBER,
1728: USSGL_ACCT_NUMBER,
1729: BALANCE_TYPE,

Line 1754: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

1750: LAST_UPDATE_DATE,
1751: LAST_UPDATED_BY,
1752: LAST_UPDATE_LOGIN)
1753: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1754: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1755: '5780', -- facct account number
1756: '5780', -- ussgl account number
1757: 'E', -- balance type
1758: 'N', -- authority type

Line 1782: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

1778: sysdate, -- last update date
1779: FND_GLOBAL.USER_ID, -- last updated by
1780: FND_GLOBAL.USER_ID -- last updated login
1781: );
1782: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1783: SGL_ATTRIBUTES_ID,
1784: FACTS_ACCT_NUMBER,
1785: USSGL_ACCT_NUMBER,
1786: BALANCE_TYPE,

Line 1811: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

1807: LAST_UPDATE_DATE,
1808: LAST_UPDATED_BY,
1809: LAST_UPDATE_LOGIN)
1810: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1811: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1812: '5790', -- facct account number
1813: '5790', -- ussgl account number
1814: 'E', -- balance type
1815: 'N', -- authority type

Line 1839: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

1835: sysdate, -- last update date
1836: FND_GLOBAL.USER_ID, -- last updated by
1837: FND_GLOBAL.USER_ID -- last updated login
1838: );
1839: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1840: SGL_ATTRIBUTES_ID,
1841: FACTS_ACCT_NUMBER,
1842: USSGL_ACCT_NUMBER,
1843: BALANCE_TYPE,

Line 1868: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

1864: LAST_UPDATE_DATE,
1865: LAST_UPDATED_BY,
1866: LAST_UPDATE_LOGIN)
1867: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1868: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1869: '5799', -- facct account number
1870: '5799', -- ussgl account number
1871: 'E', -- balance type
1872: 'N', -- authority type

Line 1896: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

1892: sysdate, -- last update date
1893: FND_GLOBAL.USER_ID, -- last updated by
1894: FND_GLOBAL.USER_ID -- last updated login
1895: );
1896: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1897: SGL_ATTRIBUTES_ID,
1898: FACTS_ACCT_NUMBER,
1899: USSGL_ACCT_NUMBER,
1900: BALANCE_TYPE,

Line 1925: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

1921: LAST_UPDATE_DATE,
1922: LAST_UPDATED_BY,
1923: LAST_UPDATE_LOGIN)
1924: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1925: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1926: '5800', -- facct account number
1927: '5800', -- ussgl account number
1928: 'E', -- balance type
1929: 'N', -- authority type

Line 1953: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

1949: sysdate, -- last update date
1950: FND_GLOBAL.USER_ID, -- last updated by
1951: FND_GLOBAL.USER_ID -- last updated login
1952: );
1953: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1954: SGL_ATTRIBUTES_ID,
1955: FACTS_ACCT_NUMBER,
1956: USSGL_ACCT_NUMBER,
1957: BALANCE_TYPE,

Line 1982: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

1978: LAST_UPDATE_DATE,
1979: LAST_UPDATED_BY,
1980: LAST_UPDATE_LOGIN)
1981: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1982: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1983: '5801', -- facct account number
1984: '5801', -- ussgl account number
1985: 'E', -- balance type
1986: 'N', -- authority type

Line 2010: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

2006: sysdate, -- last update date
2007: FND_GLOBAL.USER_ID, -- last updated by
2008: FND_GLOBAL.USER_ID -- last updated login
2009: );
2010: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2011: SGL_ATTRIBUTES_ID,
2012: FACTS_ACCT_NUMBER,
2013: USSGL_ACCT_NUMBER,
2014: BALANCE_TYPE,

Line 2039: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

2035: LAST_UPDATE_DATE,
2036: LAST_UPDATED_BY,
2037: LAST_UPDATE_LOGIN)
2038: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2039: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2040: '5809', -- facct account number
2041: '5809', -- ussgl account number
2042: 'E', -- balance type
2043: 'N', -- authority type

Line 2067: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

2063: sysdate, -- last update date
2064: FND_GLOBAL.USER_ID, -- last updated by
2065: FND_GLOBAL.USER_ID -- last updated login
2066: );
2067: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2068: SGL_ATTRIBUTES_ID,
2069: FACTS_ACCT_NUMBER,
2070: USSGL_ACCT_NUMBER,
2071: BALANCE_TYPE,

Line 2096: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

2092: LAST_UPDATE_DATE,
2093: LAST_UPDATED_BY,
2094: LAST_UPDATE_LOGIN)
2095: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2096: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2097: '5890', -- facct account number
2098: '5890', -- ussgl account number
2099: 'E', -- balance type
2100: 'N', -- authority type

Line 2124: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

2120: sysdate, -- last update date
2121: FND_GLOBAL.USER_ID, -- last updated by
2122: FND_GLOBAL.USER_ID -- last updated login
2123: );
2124: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2125: SGL_ATTRIBUTES_ID,
2126: FACTS_ACCT_NUMBER,
2127: USSGL_ACCT_NUMBER,
2128: BALANCE_TYPE,

Line 2153: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

2149: LAST_UPDATE_DATE,
2150: LAST_UPDATED_BY,
2151: LAST_UPDATE_LOGIN)
2152: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2153: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2154: '5900', -- facct account number
2155: '5900', -- ussgl account number
2156: 'E', -- balance type
2157: 'N', -- authority type

Line 2181: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

2177: sysdate, -- last update date
2178: FND_GLOBAL.USER_ID, -- last updated by
2179: FND_GLOBAL.USER_ID -- last updated login
2180: );
2181: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2182: SGL_ATTRIBUTES_ID,
2183: FACTS_ACCT_NUMBER,
2184: USSGL_ACCT_NUMBER,
2185: BALANCE_TYPE,

Line 2210: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

2206: LAST_UPDATE_DATE,
2207: LAST_UPDATED_BY,
2208: LAST_UPDATE_LOGIN)
2209: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2210: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2211: '5909', -- facct account number
2212: '5909', -- ussgl account number
2213: 'E', -- balance type
2214: 'N', -- authority type

Line 2238: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

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_ATTRIBUTES (SET_OF_BOOKS_ID,
2239: SGL_ATTRIBUTES_ID,
2240: FACTS_ACCT_NUMBER,
2241: USSGL_ACCT_NUMBER,
2242: BALANCE_TYPE,

Line 2267: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

2263: LAST_UPDATE_DATE,
2264: LAST_UPDATED_BY,
2265: LAST_UPDATE_LOGIN)
2266: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2267: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2268: '5990', -- facct account number
2269: '5990', -- ussgl account number
2270: 'E', -- balance type
2271: 'N', -- authority type

Line 2295: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

2291: sysdate, -- last update date
2292: FND_GLOBAL.USER_ID, -- last updated by
2293: FND_GLOBAL.USER_ID -- last updated login
2294: );
2295: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2296: SGL_ATTRIBUTES_ID,
2297: FACTS_ACCT_NUMBER,
2298: USSGL_ACCT_NUMBER,
2299: BALANCE_TYPE,

Line 2324: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

2320: LAST_UPDATE_DATE,
2321: LAST_UPDATED_BY,
2322: LAST_UPDATE_LOGIN)
2323: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2324: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2325: '5991', -- facct account number
2326: '5991', -- ussgl account number
2327: 'E', -- balance type
2328: 'N', -- authority type

Line 2352: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

2348: sysdate, -- last update date
2349: FND_GLOBAL.USER_ID, -- last updated by
2350: FND_GLOBAL.USER_ID -- last updated login
2351: );
2352: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2353: SGL_ATTRIBUTES_ID,
2354: FACTS_ACCT_NUMBER,
2355: USSGL_ACCT_NUMBER,
2356: BALANCE_TYPE,

Line 2381: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

2377: LAST_UPDATE_DATE,
2378: LAST_UPDATED_BY,
2379: LAST_UPDATE_LOGIN)
2380: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2381: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2382: '6100', -- facct account number
2383: '6100', -- ussgl account number
2384: 'E', -- balance type
2385: 'N', -- authority type

Line 2409: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

2405: sysdate, -- last update date
2406: FND_GLOBAL.USER_ID, -- last updated by
2407: FND_GLOBAL.USER_ID -- last updated login
2408: );
2409: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2410: SGL_ATTRIBUTES_ID,
2411: FACTS_ACCT_NUMBER,
2412: USSGL_ACCT_NUMBER,
2413: BALANCE_TYPE,

Line 2438: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

2434: LAST_UPDATE_DATE,
2435: LAST_UPDATED_BY,
2436: LAST_UPDATE_LOGIN)
2437: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2438: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2439: '6190', -- facct account number
2440: '6190', -- ussgl account number
2441: 'E', -- balance type
2442: 'N', -- authority type

Line 2466: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

2462: sysdate, -- last update date
2463: FND_GLOBAL.USER_ID, -- last updated by
2464: FND_GLOBAL.USER_ID -- last updated login
2465: );
2466: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2467: SGL_ATTRIBUTES_ID,
2468: FACTS_ACCT_NUMBER,
2469: USSGL_ACCT_NUMBER,
2470: BALANCE_TYPE,

Line 2495: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

2491: LAST_UPDATE_DATE,
2492: LAST_UPDATED_BY,
2493: LAST_UPDATE_LOGIN)
2494: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2495: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2496: '6199', -- facct account number
2497: '6199', -- ussgl account number
2498: 'E', -- balance type
2499: 'N', -- authority type

Line 2523: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

2519: sysdate, -- last update date
2520: FND_GLOBAL.USER_ID, -- last updated by
2521: FND_GLOBAL.USER_ID -- last updated login
2522: );
2523: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2524: SGL_ATTRIBUTES_ID,
2525: FACTS_ACCT_NUMBER,
2526: USSGL_ACCT_NUMBER,
2527: BALANCE_TYPE,

Line 2552: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

2548: LAST_UPDATE_DATE,
2549: LAST_UPDATED_BY,
2550: LAST_UPDATE_LOGIN)
2551: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2552: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2553: '6310', -- facct account number
2554: '6310', -- ussgl account number
2555: 'E', -- balance type
2556: 'N', -- authority type

Line 2580: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

2576: sysdate, -- last update date
2577: FND_GLOBAL.USER_ID, -- last updated by
2578: FND_GLOBAL.USER_ID -- last updated login
2579: );
2580: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2581: SGL_ATTRIBUTES_ID,
2582: FACTS_ACCT_NUMBER,
2583: USSGL_ACCT_NUMBER,
2584: BALANCE_TYPE,

Line 2609: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

2605: LAST_UPDATE_DATE,
2606: LAST_UPDATED_BY,
2607: LAST_UPDATE_LOGIN)
2608: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2609: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2610: '6320', -- facct account number
2611: '6320', -- ussgl account number
2612: 'E', -- balance type
2613: 'N', -- authority type

Line 2637: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

2633: sysdate, -- last update date
2634: FND_GLOBAL.USER_ID, -- last updated by
2635: FND_GLOBAL.USER_ID -- last updated login
2636: );
2637: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2638: SGL_ATTRIBUTES_ID,
2639: FACTS_ACCT_NUMBER,
2640: USSGL_ACCT_NUMBER,
2641: BALANCE_TYPE,

Line 2666: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

2662: LAST_UPDATE_DATE,
2663: LAST_UPDATED_BY,
2664: LAST_UPDATE_LOGIN)
2665: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2666: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2667: '6330', -- facct account number
2668: '6330', -- ussgl account number
2669: 'E', -- balance type
2670: 'N', -- authority type

Line 2694: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

2690: sysdate, -- last update date
2691: FND_GLOBAL.USER_ID, -- last updated by
2692: FND_GLOBAL.USER_ID -- last updated login
2693: );
2694: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2695: SGL_ATTRIBUTES_ID,
2696: FACTS_ACCT_NUMBER,
2697: USSGL_ACCT_NUMBER,
2698: BALANCE_TYPE,

Line 2723: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

2719: LAST_UPDATE_DATE,
2720: LAST_UPDATED_BY,
2721: LAST_UPDATE_LOGIN)
2722: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2723: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2724: '6400', -- facct account number
2725: '6400', -- ussgl account number
2726: 'E', -- balance type
2727: 'N', -- authority type

Line 2751: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

2747: sysdate, -- last update date
2748: FND_GLOBAL.USER_ID, -- last updated by
2749: FND_GLOBAL.USER_ID -- last updated login
2750: );
2751: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2752: SGL_ATTRIBUTES_ID,
2753: FACTS_ACCT_NUMBER,
2754: USSGL_ACCT_NUMBER,
2755: BALANCE_TYPE,

Line 2780: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

2776: LAST_UPDATE_DATE,
2777: LAST_UPDATED_BY,
2778: LAST_UPDATE_LOGIN)
2779: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2780: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2781: '6500', -- facct account number
2782: '6500', -- ussgl account number
2783: 'E', -- balance type
2784: 'N', -- authority type

Line 2808: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

2804: sysdate, -- last update date
2805: FND_GLOBAL.USER_ID, -- last updated by
2806: FND_GLOBAL.USER_ID -- last updated login
2807: );
2808: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2809: SGL_ATTRIBUTES_ID,
2810: FACTS_ACCT_NUMBER,
2811: USSGL_ACCT_NUMBER,
2812: BALANCE_TYPE,

Line 2837: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

2833: LAST_UPDATE_DATE,
2834: LAST_UPDATED_BY,
2835: LAST_UPDATE_LOGIN)
2836: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2837: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2838: '6600', -- facct account number
2839: '6600', -- ussgl account number
2840: 'E', -- balance type
2841: 'N', -- authority type

Line 2866: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

2862: FND_GLOBAL.USER_ID, -- last updated by
2863: FND_GLOBAL.USER_ID -- last updated login
2864: );
2865:
2866: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2867: SGL_ATTRIBUTES_ID,
2868: FACTS_ACCT_NUMBER,
2869: USSGL_ACCT_NUMBER,
2870: BALANCE_TYPE,

Line 2895: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

2891: LAST_UPDATE_DATE,
2892: LAST_UPDATED_BY,
2893: LAST_UPDATE_LOGIN)
2894: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2895: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2896: '6710', -- facct account number
2897: '6710', -- ussgl account number
2898: 'E', -- balance type
2899: 'N', -- authority type

Line 2923: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

2919: sysdate, -- last update date
2920: FND_GLOBAL.USER_ID, -- last updated by
2921: FND_GLOBAL.USER_ID -- last updated login
2922: );
2923: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2924: SGL_ATTRIBUTES_ID,
2925: FACTS_ACCT_NUMBER,
2926: USSGL_ACCT_NUMBER,
2927: BALANCE_TYPE,

Line 2952: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

2948: LAST_UPDATE_DATE,
2949: LAST_UPDATED_BY,
2950: LAST_UPDATE_LOGIN)
2951: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2952: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2953: '6720', -- facct account number
2954: '6720', -- ussgl account number
2955: 'E', -- balance type
2956: 'N', -- authority type

Line 2980: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

2976: sysdate, -- last update date
2977: FND_GLOBAL.USER_ID, -- last updated by
2978: FND_GLOBAL.USER_ID -- last updated login
2979: );
2980: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2981: SGL_ATTRIBUTES_ID,
2982: FACTS_ACCT_NUMBER,
2983: USSGL_ACCT_NUMBER,
2984: BALANCE_TYPE,

Line 3009: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

3005: LAST_UPDATE_DATE,
3006: LAST_UPDATED_BY,
3007: LAST_UPDATE_LOGIN)
3008: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3009: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3010: '6730', -- facct account number
3011: '6730', -- ussgl account number
3012: 'E', -- balance type
3013: 'N', -- authority type

Line 3037: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

3033: sysdate, -- last update date
3034: FND_GLOBAL.USER_ID, -- last updated by
3035: FND_GLOBAL.USER_ID -- last updated login
3036: );
3037: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3038: SGL_ATTRIBUTES_ID,
3039: FACTS_ACCT_NUMBER,
3040: USSGL_ACCT_NUMBER,
3041: BALANCE_TYPE,

Line 3066: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

3062: LAST_UPDATE_DATE,
3063: LAST_UPDATED_BY,
3064: LAST_UPDATE_LOGIN)
3065: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3066: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3067: '6790', -- facct account number
3068: '6790', -- ussgl account number
3069: 'E', -- balance type
3070: 'N', -- authority type

Line 3094: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

3090: sysdate, -- last update date
3091: FND_GLOBAL.USER_ID, -- last updated by
3092: FND_GLOBAL.USER_ID -- last updated login
3093: );
3094: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3095: SGL_ATTRIBUTES_ID,
3096: FACTS_ACCT_NUMBER,
3097: USSGL_ACCT_NUMBER,
3098: BALANCE_TYPE,

Line 3123: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

3119: LAST_UPDATE_DATE,
3120: LAST_UPDATED_BY,
3121: LAST_UPDATE_LOGIN)
3122: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3123: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3124: '6800', -- facct account number
3125: '6800', -- ussgl account number
3126: 'E', -- balance type
3127: 'N', -- authority type

Line 3151: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

3147: sysdate, -- last update date
3148: FND_GLOBAL.USER_ID, -- last updated by
3149: FND_GLOBAL.USER_ID -- last updated login
3150: );
3151: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3152: SGL_ATTRIBUTES_ID,
3153: FACTS_ACCT_NUMBER,
3154: USSGL_ACCT_NUMBER,
3155: BALANCE_TYPE,

Line 3180: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

3176: LAST_UPDATE_DATE,
3177: LAST_UPDATED_BY,
3178: LAST_UPDATE_LOGIN)
3179: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3180: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3181: '6850', -- facct account number
3182: '6850', -- ussgl account number
3183: 'E', -- balance type
3184: 'N', -- authority type

Line 3208: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

3204: sysdate, -- last update date
3205: FND_GLOBAL.USER_ID, -- last updated by
3206: FND_GLOBAL.USER_ID -- last updated login
3207: );
3208: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3209: SGL_ATTRIBUTES_ID,
3210: FACTS_ACCT_NUMBER,
3211: USSGL_ACCT_NUMBER,
3212: BALANCE_TYPE,

Line 3237: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

3233: LAST_UPDATE_DATE,
3234: LAST_UPDATED_BY,
3235: LAST_UPDATE_LOGIN)
3236: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3237: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3238: '6900', -- facct account number
3239: '6900', -- ussgl account number
3240: 'E', -- balance type
3241: 'N', -- authority type

Line 3265: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

3261: sysdate, -- last update date
3262: FND_GLOBAL.USER_ID, -- last updated by
3263: FND_GLOBAL.USER_ID -- last updated login
3264: );
3265: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3266: SGL_ATTRIBUTES_ID,
3267: FACTS_ACCT_NUMBER,
3268: USSGL_ACCT_NUMBER,
3269: BALANCE_TYPE,

Line 3294: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

3290: LAST_UPDATE_DATE,
3291: LAST_UPDATED_BY,
3292: LAST_UPDATE_LOGIN)
3293: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3294: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3295: '7110', -- facct account number
3296: '7110', -- ussgl account number
3297: 'E', -- balance type
3298: 'N', -- authority type

Line 3322: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

3318: sysdate, -- last update date
3319: FND_GLOBAL.USER_ID, -- last updated by
3320: FND_GLOBAL.USER_ID -- last updated login
3321: );
3322: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3323: SGL_ATTRIBUTES_ID,
3324: FACTS_ACCT_NUMBER,
3325: USSGL_ACCT_NUMBER,
3326: BALANCE_TYPE,

Line 3351: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

3347: LAST_UPDATE_DATE,
3348: LAST_UPDATED_BY,
3349: LAST_UPDATE_LOGIN)
3350: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3351: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3352: '7180', -- facct account number
3353: '7180', -- ussgl account number
3354: 'E', -- balance type
3355: 'N', -- authority type

Line 3379: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

3375: sysdate, -- last update date
3376: FND_GLOBAL.USER_ID, -- last updated by
3377: FND_GLOBAL.USER_ID -- last updated login
3378: );
3379: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3380: SGL_ATTRIBUTES_ID,
3381: FACTS_ACCT_NUMBER,
3382: USSGL_ACCT_NUMBER,
3383: BALANCE_TYPE,

Line 3408: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

3404: LAST_UPDATE_DATE,
3405: LAST_UPDATED_BY,
3406: LAST_UPDATE_LOGIN)
3407: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3408: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3409: '7190', -- facct account number
3410: '7190', -- ussgl account number
3411: 'E', -- balance type
3412: 'N', -- authority type

Line 3436: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

3432: sysdate, -- last update date
3433: FND_GLOBAL.USER_ID, -- last updated by
3434: FND_GLOBAL.USER_ID -- last updated login
3435: );
3436: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3437: SGL_ATTRIBUTES_ID,
3438: FACTS_ACCT_NUMBER,
3439: USSGL_ACCT_NUMBER,
3440: BALANCE_TYPE,

Line 3465: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

3461: LAST_UPDATE_DATE,
3462: LAST_UPDATED_BY,
3463: LAST_UPDATE_LOGIN)
3464: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3465: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3466: '7210', -- facct account number
3467: '7210', -- ussgl account number
3468: 'E', -- balance type
3469: 'N', -- authority type

Line 3493: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

3489: sysdate, -- last update date
3490: FND_GLOBAL.USER_ID, -- last updated by
3491: FND_GLOBAL.USER_ID -- last updated login
3492: );
3493: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3494: SGL_ATTRIBUTES_ID,
3495: FACTS_ACCT_NUMBER,
3496: USSGL_ACCT_NUMBER,
3497: BALANCE_TYPE,

Line 3522: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

3518: LAST_UPDATE_DATE,
3519: LAST_UPDATED_BY,
3520: LAST_UPDATE_LOGIN)
3521: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3522: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3523: '7280', -- facct account number
3524: '7280', -- ussgl account number
3525: 'E', -- balance type
3526: 'N', -- authority type

Line 3550: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

3546: sysdate, -- last update date
3547: FND_GLOBAL.USER_ID, -- last updated by
3548: FND_GLOBAL.USER_ID -- last updated login
3549: );
3550: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3551: SGL_ATTRIBUTES_ID,
3552: FACTS_ACCT_NUMBER,
3553: USSGL_ACCT_NUMBER,
3554: BALANCE_TYPE,

Line 3579: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

3575: LAST_UPDATE_DATE,
3576: LAST_UPDATED_BY,
3577: LAST_UPDATE_LOGIN)
3578: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3579: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3580: '7290', -- facct account number
3581: '7290', -- ussgl account number
3582: 'E', -- balance type
3583: 'N', -- authority type

Line 3607: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

3603: sysdate, -- last update date
3604: FND_GLOBAL.USER_ID, -- last updated by
3605: FND_GLOBAL.USER_ID -- last updated login
3606: );
3607: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3608: SGL_ATTRIBUTES_ID,
3609: FACTS_ACCT_NUMBER,
3610: USSGL_ACCT_NUMBER,
3611: BALANCE_TYPE,

Line 3636: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

3632: LAST_UPDATE_DATE,
3633: LAST_UPDATED_BY,
3634: LAST_UPDATE_LOGIN)
3635: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3636: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3637: '7300', -- facct account number
3638: '7300', -- ussgl account number
3639: 'E', -- balance type
3640: 'N', -- authority type

Line 3664: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

3660: sysdate, -- last update date
3661: FND_GLOBAL.USER_ID, -- last updated by
3662: FND_GLOBAL.USER_ID -- last updated login
3663: );
3664: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3665: SGL_ATTRIBUTES_ID,
3666: FACTS_ACCT_NUMBER,
3667: USSGL_ACCT_NUMBER,
3668: BALANCE_TYPE,

Line 3693: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

3689: LAST_UPDATE_DATE,
3690: LAST_UPDATED_BY,
3691: LAST_UPDATE_LOGIN)
3692: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3693: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3694: '7400', -- facct account number
3695: '7400', -- ussgl account number
3696: 'E', -- balance type
3697: 'N', -- authority type

Line 3721: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

3717: sysdate, -- last update date
3718: FND_GLOBAL.USER_ID, -- last updated by
3719: FND_GLOBAL.USER_ID -- last updated login
3720: );
3721: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3722: SGL_ATTRIBUTES_ID,
3723: FACTS_ACCT_NUMBER,
3724: USSGL_ACCT_NUMBER,
3725: BALANCE_TYPE,

Line 3750: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

3746: LAST_UPDATE_DATE,
3747: LAST_UPDATED_BY,
3748: LAST_UPDATE_LOGIN)
3749: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3750: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3751: '7500', -- facct account number
3752: '7500', -- ussgl account number
3753: 'E', -- balance type
3754: 'N', -- authority type

Line 3778: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,

3774: sysdate, -- last update date
3775: FND_GLOBAL.USER_ID, -- last updated by
3776: FND_GLOBAL.USER_ID -- last updated login
3777: );
3778: INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3779: SGL_ATTRIBUTES_ID,
3780: FACTS_ACCT_NUMBER,
3781: USSGL_ACCT_NUMBER,
3782: BALANCE_TYPE,

Line 3807: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID

3803: LAST_UPDATE_DATE,
3804: LAST_UPDATED_BY,
3805: LAST_UPDATE_LOGIN)
3806: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3807: FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3808: '7600', -- facct account number
3809: '7600', -- ussgl account number
3810: 'E', -- balance type
3811: 'N', -- authority type