eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FVFCRT7B SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 14


		SELECT  count(*)
		INTO	v_count
		FROM	fv_facts_rt7_codes
		WHERE	set_of_books_id =v_sob;

Line: 25


INSERT INTO FV_FACTS_RT7_CODES	 (SET_OF_BOOKS_ID,
				 RT7_CODE_ID,
				 RT7_CODE,
				 RT7_BORROWING_SOURCE,
				 RT7_CODE_DESCRIPTION,
				 RT7_AUTHORITY_TYPE,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),		-- sob
	FV_FACTS_RT7_CODES_S.NEXTVAL,					-- RT7 header id
	'911',								-- Authorization code
	' ',								-- RT7 borrowing source
	'Investments Purchased at a Discount - Unrealized Discount', 	-- Transaction Type
	'O',								-- RT7 authority type
	sysdate,							-- creation_date
	FND_GLOBAL.USER_ID,						-- created by
	sysdate,							-- last update date
	FND_GLOBAL.USER_ID,						-- last updated by
	FND_GLOBAL.USER_ID						-- last updated login
);

Line: 49


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'1611',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 72


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'1621',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 96


INSERT INTO FV_FACTS_RT7_CODES	 (SET_OF_BOOKS_ID,
				 RT7_CODE_ID,
				 RT7_CODE,
				 RT7_BORROWING_SOURCE,
				 RT7_CODE_DESCRIPTION,
				 RT7_AUTHORITY_TYPE,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_CODES_S.NEXTVAL,				-- RT7 header id
	'921',							-- Authorization code
	' ',							-- RT7 borrowing source
	'Funds Held Outside the Treasury - Imprest Funds', 	-- Transaction Type
	'O',							-- RT7 authority type
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 119


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'1120',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 142


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'1130',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 167


INSERT INTO FV_FACTS_RT7_CODES	 (SET_OF_BOOKS_ID,
				 RT7_CODE_ID,
				 RT7_CODE,
				 RT7_BORROWING_SOURCE,
				 RT7_CODE_DESCRIPTION,
				 RT7_AUTHORITY_TYPE,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_CODES_S.NEXTVAL,				-- RT7 header id
	'931',							-- Authorization code
	' ',							-- RT7 borrowing source
	'Investments Purchased at a Discount - Unamortized Premium and Discount', -- Transaction Type
	'O',							-- RT7 authority type
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 190


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'1611',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 213


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'1612',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 236


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'1613',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 260


INSERT INTO FV_FACTS_RT7_CODES	 (SET_OF_BOOKS_ID,
				 RT7_CODE_ID,
				 RT7_CODE,
				 RT7_BORROWING_SOURCE,
				 RT7_CODE_DESCRIPTION,
				 RT7_AUTHORITY_TYPE,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_CODES_S.NEXTVAL,				-- RT7 header id
	'941',							-- Authorization code
	' ',							-- RT7 borrowing source
	'Unfunded Contract Authority',				-- Transaction Type
	'C',							-- RT7 authority type
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 283


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'4032',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 307


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'4034',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 331


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'4131',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 355


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'4132',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 379


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'4133',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 403


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'4135',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 427


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'4138',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 451


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'B',							-- Begin/End flag
	'4139',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 475


INSERT INTO FV_FACTS_RT7_CODES	 (SET_OF_BOOKS_ID,
				 RT7_CODE_ID,
				 RT7_CODE,
				 RT7_BORROWING_SOURCE,
				 RT7_CODE_DESCRIPTION,
				 RT7_AUTHORITY_TYPE,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_CODES_S.NEXTVAL,				-- RT7 header id
	'951',							-- Authorization code
	'T',							-- RT7 borrowing source
	'Authority to Borrow from the Treasury',		-- Transaction Type
	'B',							-- RT7 authority type
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 498


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'4042',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 522


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'4044',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 546


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'4141',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 570


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'4142',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 594


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'4143',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 618


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'4145',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 642


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'4148',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 666


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'B',							-- Begin/End flag
	'4149',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 690


INSERT INTO FV_FACTS_RT7_CODES	 (SET_OF_BOOKS_ID,
				 RT7_CODE_ID,
				 RT7_CODE,
				 RT7_BORROWING_SOURCE,
				 RT7_CODE_DESCRIPTION,
				 RT7_AUTHORITY_TYPE,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_CODES_S.NEXTVAL,				-- RT7 header id
	'962',							-- Authorization code
	'P',							-- RT7 borrowing source
	'Authority to Borrow from the Public',		 	-- Transaction Type
	'B',							-- RT7 authority type
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 713


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'4042',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 737


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'4044',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 761


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'4141',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 785


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'4142',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 809


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'4143',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 833


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'4145',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 857


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'4148',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 881


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'B',							-- Begin/End flag
	'4149',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 905


INSERT INTO FV_FACTS_RT7_CODES	 (SET_OF_BOOKS_ID,
				 RT7_CODE_ID,
				 RT7_CODE,
				 RT7_BORROWING_SOURCE,
				 RT7_CODE_DESCRIPTION,
				 RT7_AUTHORITY_TYPE,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_CODES_S.NEXTVAL,				-- RT7 header id
	'971',							-- Authorization code
	' ',							-- RT7 borrowing source
	'Investments in Public Debt Securities',	 	-- Transaction Type
	'O',							-- RT7 authority type
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 928


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'1610',							-- USSGL Account
	'N',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 952


INSERT INTO FV_FACTS_RT7_CODES	 (SET_OF_BOOKS_ID,
				 RT7_CODE_ID,
				 RT7_CODE,
				 RT7_BORROWING_SOURCE,
				 RT7_CODE_DESCRIPTION,
				 RT7_AUTHORITY_TYPE,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_CODES_S.NEXTVAL,				-- RT7 header id
	'972',							-- Authorization code
	' ',							-- RT7 borrowing source
	'Investments in Agency Securities',			-- Transaction Type
	'O',							-- RT7 authority type
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);

Line: 976


INSERT INTO FV_FACTS_RT7_ACCOUNTS	 (SET_OF_BOOKS_ID,
				 RT7_ACCOUNT_ID,
				 RT7_CODE_ID,
				 RT7_BE_FLAG,
				 RT7_USSGL_ACCOUNT,
				 RT7_TRANSACTION_PARTNER,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 LAST_UPDATE_LOGIN)
VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')),	-- sob
	FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL,			-- RT7 DETAIL id
	FV_FACTS_RT7_CODES_S.CURRVAL,				-- RT7 HEADER ID
	'E',							-- Begin/End flag
	'1620',							-- USSGL Account
	'F',							-- Transaction Partner
	sysdate,						-- creation_date
	FND_GLOBAL.USER_ID,					-- created by
	sysdate,						-- last update date
	FND_GLOBAL.USER_ID,					-- last updated by
	FND_GLOBAL.USER_ID					-- last updated login
);