FA Budget - draft

Description

Application: Assets
Source: Budget Report (XML) - Not Supported: Reserved For Future Use
Short Name: FAS956_XML
DB package: FA_FAS956_XMLP_PKG
EN US

FA Budget - draft and other Oracle EBS reports with Blitz Report™ on our demo environment

Copy

SELECT
	SC.Company_Name,
	SC.Category_Flex_Structure,
	SC.Location_Flex_Structure,
	SC.Asset_Key_Flex_Structure,
	BC.Book_Type_Code,
	BC.Book_Class,
	BC.Accounting_Flex_Structure,
	BC.Distribution_Source_Book,
	SOB.Currency_Code, 
--	FA_FAS956_XMLP_PKG.report_nameformula(FA_SYSTEM_CONTROLS.Company_Name) Report_Name, 
	FA_FAS956_XMLP_PKG.report_nameformula(SC.Company_Name) Report_Name, 
	--&acct_bal_lprompt ACCT_BAL_LPROMPT, 
	--&acct_cc_lprompt ACCT_CC_LPROMPT, 
	--&cat_maj_lprompt CAT_MAJ_LPROMPT,
	FA_FAS956_XMLP_PKG.ACCT_BAL_APROMPT_p ACCT_BAL_APROMPT,
	FA_FAS956_XMLP_PKG.ACCT_CC_APROMPT_p ACCT_CC_APROMPT,
	FA_FAS956_XMLP_PKG.CAT_MAJ_RPROMPT_p CAT_MAJ_RPROMPT
FROM
	FA_SYSTEM_CONTROLS	SC,
	FA_BOOK_CONTROLS 	BC,
	GL_SETS_OF_BOOKS 	SOB
WHERE
	BC.Book_Type_Code = :P_BOOK
AND	SOB.Set_Of_Books_ID = BC.Set_Of_Books_ID