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 |