IGI Balanced Budget Journal Input Proforma - draft

Description
Categories: BI Publisher, Financials
Application: Public Sector Financials International
Source: Budgeting: Balanced Budget Journal Input Proforma (XML) - Not Supported: Reserved For Future Use
Short Name: IGIGBIPB_XML
DB package: IGI_IGIGBIPB_XMLP_PKG
SELECT 	&P_FLEXDATA C_FLEXDATA, 
		gl_ass.CODE_COMBINATION_ID CCID,
		gsob.NAME SOB_NAME,
		gl_ent.NAME ORG_NAME,
		defs.LATEST_PROFILE_CODE  PROF_CODE,
		fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_flexfield', 'SQLGL', 'GL#', gl_comb.CHART_OF_ACCOUNTS_ID, NULL, gl_comb.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') CF_FLEXFIELD
	FROM	GL_CODE_COMBINATIONS gl_comb,
		GL_BUDGET_ASSIGNMENTS gl_ass, 
		GL_SETS_OF_BOOKS gsob,
		GL_BUDGET_ENTITIES gl_ent,
		IGI_BUD_PROFILE_DEFAULTS defs,
		IGI_BUD_PROFILE_CODES codes, GL_LOOKUPS LK
	WHERE	gl_ass.LEDGER_ID = :P_SOB_ID
	AND	gl_ass.BUDGET_ENTITY_ID = :P_BUD_ENT_ID
	AND	gl_ass.CURRENCY_CODE = :P_CURR
	AND 	gl_ass.CODE_COMBINATION_ID =  gl_comb.CODE_COMBINATION_ID
                AND     LK.LOOKUP_TYPE(+) = 'ACCOUNT TYPE' 
                AND     LK.LOOKUP_CODE(+) = gl_comb.ACCOUNT_TYPE
	AND 	gl_comb.DETAIL_BUDGETING_ALLOWED_FLAG = 'Y'
	AND 	gl_comb.SUMMARY_FLAG = 'N'
	AND	gsob.SET_OF_BOOKS_ID = gl_ass.LEDGER_ID
                AND 	gl_comb.IGI_BALANCED_BUDGET_FLAG = 'Y'
	AND	gl_ent.LEDGER_ID = gl_ass.LEDGER_ID
	AND 	gl_ent.BUDGET_ENTITY_ID = :P_BUD_ENT_ID
	AND 	defs.SET_OF_BOOKS_ID = gl_ass.LEDGER_ID
	AND 	defs.CODE_COMBINATION_ID = gl_ass.CODE_COMBINATION_ID
	AND 	defs.LATEST_PROFILE_CODE = codes.PROFILE_CODE
	AND	defs.SET_OF_BOOKS_ID = codes.SET_OF_BOOKS_ID
	AND	SYSDATE BETWEEN nvl(codes.START_DATE_ACTIVE, SYSDATE)
			         AND nvl(codes.END_DATE_ACTIVE, SYSDATE+1)
	AND	gl_comb.CHART_OF_ACCOUNTS_ID = :P_STRUCT_NUM
	ORDER BY 3, 2,1
Parameter Name SQL text Validation
Data Access Set ID
 
Number
Chart of Accounts ID
 
LOV Oracle
Budget Entity ID
 
LOV Oracle
Currency Code ID
 
LOV Oracle
Ledger ID
 
LOV Oracle