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 |
