FA Ceiling Listing - draft

➜ Back to Library
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
Run FA Ceiling Listing - draft and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
 
Related Blitz Reports
FA Asset Category Listing FA Asset Register AP Accounted Invoice Aging FA Tax Reserve Ledger FA Revaluation Reserve CE Transactions Available for Reconciliation FA Asset Additions FA Asset Cost FA Cost Adjustments
Blitz Report™

Blitz Report™ provides multiple benefits: