FA Parent Asset Transactions - draft

Description

Application: Assets
Source: Parent Asset Transactions Report (XML) - Not Supported: Reserved For Future Use
Short Name: FASPARTX_XML
DB package: FA_FASPARTX_XMLP_PKG

FA Parent Asset Transactions - 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_FASPARTX_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_FASPARTX_XMLP_PKG.period1_pcformula() Period1_PC,
	--FA_FASPARTX_XMLP_PKG.ACCT_BAL_APROMPT_p ACCT_BAL_APROMPT,
	--FA_FASPARTX_XMLP_PKG.ACCT_CC_APROMPT_p ACCT_CC_APROMPT,
	--FA_FASPARTX_XMLP_PKG.CAT_MAJ_RPROMPT_p CAT_MAJ_RPROMPT,
	FA_FASPARTX_XMLP_PKG.Period1_POD_p Period1_POD,
	FA_FASPARTX_XMLP_PKG.Period1_PCD_p Period1_PCD,
	FA_FASPARTX_XMLP_PKG.Period1_FY_p Period1_FY
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