FA Ceiling Listing - draft

Description
Categories: BI Publisher
Application: Assets
Source: Ceiling Listing (XML) - Not Supported: Reserved For Future Use
Short Name: FASCEILG_XML
DB package: FA_FASCEILG_XMLP_PKG
SELECT
        CT.CEILING_TYPE	Raw_Ceiling_Type,
        CT.Currency_Code,
        CL.Ceiling_Name,
        CL.Start_Date,
        CL.End_Date,
        CL.Year_Of_Life,
        ROUND(CL.Limit, CU.PRECISION) LIMIT, 
	FA_FASCEILG_XMLP_PKG.ceiling_typeformula(CT.CEILING_TYPE) Ceiling_Type
FROM
        FA_CEILINGS		CL,
        FA_CEILING_TYPES	CT,
        GL_CURRENCIES	CU
WHERE
        cl.ceiling_name		= ct.ceiling_name
AND cu.currency_code = ct.currency_code
order by Ceiling_Type, CL.Ceiling_Name,CT.Currency_Code,
CL.Start_Date,CL.Year_Of_Life