FA Category Accounts Report
SELECT Al1.Book_Name,
Al1.Book_Type,
Al1.Fa_Category,
Al1.Fa_Subcategory,
Al1.Deprn_Method,
Al1.Life_In_Months,
Al1.Depreciate_Flag,
Al1.Enabled_Flag,
Al1.Subcomponent_Life_Rule,
Al1.Owned_Leased,
Al1.Percent_Salvage,
Al1.Depreciation_Limit,
Al1.Deprn_Expense_Acct,
Al1.Deprn_Exp_Local_Acct,
Al1.Asset_Clearing_Combination,
Al1.Asset_Cost_Combination,
Al1.Reserve_Combination,
Al1.Cip_Clearing_Combination,
Al1.Cip_Cost_Combination,
Al1.Impair_Exp_Acct,
Al1.Impair_Resv_Acct,
to_char(Al1.Last_Updt_Date,'mm/dd/yyyy hh:mi:ss AM') Last_Updt_Date,
to_char(sysdate,'mm/dd/yyyy hh:mi:ss AM') timestamp
-- Al1.LIFE_IN_MONTHS1,
-- Al1.METHOD_CODE1
FROM (SELECT Bkd.Category_Id Fa_Category_Id,
Bkd.Book_Type_Code Book_Name,
Ctl.Book_Class Book_Type,
Fac.Segment1 Fa_Category,
Fac.Segment2 Fa_Subcategory,
--Bkd.Life_In_Months Life_In_Months,
-- Bkd.minimum_Life_In_Months Life_In_Months, ** COMMENT Added by Sharanu 17-Apr-2025 **
FM.LIFE_IN_MONTHS Life_In_Months, -- ** Added by Sharanu 17-Apr-2025 **
--Bkd.Deprn_Method Deprn_Method,
--Bkd.Method_id Deprn_Method, ** COMMENT Added by Sharanu 17-Apr-2025 **
FM.METHOD_CODE Deprn_Method, -- ** Added by Sharanu 17-Apr-2025 **
Bkd.Depreciate_Flag Depreciate_Flag,
Fac.Summary_Flag Summary_Flag,
Fac.Enabled_Flag Enabled_Flag,
Fac.Owned_Leased Owned_Leased,
Fac.Category_Type Category_Type,
Fac.Capitalize_Flag Capitalize_Flag,
Fac.Start_Date_Active Start_Date_Active,
Fac.End_Date_Active End_Date_Active,
Fac.Inventorial Inventorial,
Ctb.Asset_Clearing_Account_ccid Asset_Clearing_Acct,
Ctb.Asset_Cost_Account_ccid Asset_Cost_Acct,
--Ctb.Cip_Clearing_Acct Cip_Clearing_Acct,
--Ctb.Cip_Cost_Acct Cip_Cost_Acct,
null Cip_Clearing_Acct,
null Cip_Cost_Acct,
Ctb.Deprn_Expense_Account_ccid Deprn_Expense_Acct,
--Glcc5.Segment3 Deprn_Exp_Local_Acct, **COMMENT by sharanu 17-Apr-2025 **
Glcc5.Segment4 Deprn_Exp_Local_Acct, -- ** added by Sharan 17-Apr-2025 **
--Ctb.Deprn_Reserve_Acct Deprn_Reserve_Acct,
null Deprn_Reserve_Acct,
Ctb.Reval_Amort_Account_ccid Reval_Amort_Acct,
Ctb.Reval_Reserve_Account_ccid Reval_Reserve_Acct,
Glcc.Segment1 || '.' || Glcc.Segment3 || '.' || Glcc.Segment4 || '.' ||
Glcc.Segment5 || '.' || Glcc.Segment6 || '.' || Glcc.Segment7 || '.' ||
Glcc.Segment8 || '.' || Glcc.Segment9 Asset_Cost_Combination,
Glcc1.Segment1 || '.' || Glcc1.Segment3 || '.' ||
Glcc1.Segment4 || '.' || Glcc1.Segment5 || '.' ||
Glcc1.Segment6 || '.' || Glcc1.Segment7 || '.' ||
Glcc1.Segment8 || '.' || Glcc1.Segment9 Asset_Clearing_Combination,
Glcc4.Segment1 || '.' || Glcc4.Segment3 || '.' ||
Glcc4.Segment4 || '.' || Glcc4.Segment5 || '.' ||
Glcc4.Segment6 || '.' || Glcc4.Segment7 || '.' ||
Glcc4.Segment8 || '.' || Glcc4.Segment9 Reserve_Combination,
Glcc2.Segment1 || '.' || Glcc2.Segment3 || '.' ||
Glcc2.Segment4 || '.' || Glcc2.Segment5 || '.' ||
Glcc2.Segment6 || '.' || Glcc2.Segment7 || '.' ||
Glcc2.Segment8 || '.' || Glcc2.Segment9 Cip_Cost_Combination,
Glcc3.Segment1 || '.' || Glcc3.Segment3 || '.' ||
Glcc3.Segment4 || '.' || Glcc3.Segment5 || '.' ||
Glcc3.Segment6 || '.' || Glcc3.Segment7 || '.' ||
Glcc3.Segment8 || '.' || Glcc3.Segment9 Cip_Clearing_Combination,
Bkd.Percent_Salvage_Value Percent_Salvage,
Bkd.Subcomponent_Life_Rule Subcomponent_Life_Rule,
Bkd.Special_Deprn_Limit_Amount Depreciation_Limit,
Bkd.Last_Update_Date Last_Updt_Date,
Bkd.Creation_Date Creation_Date,
Ctb.Impair_Expense_Account_ccid Impair_Exp_Acct,
Ctb.Impair_Reserve_Account_ccid Impair_Resv_Acct
--FM.LIFE_IN_MONTHS LIFE_IN_MONTHS1,
-- FM.METHOD_CODE METHOD_CODE1
FROM Fa_Category_Book_Defaults Bkd,
Fa_Categories_b Fac,
Fa_Category_Books Ctb,
Fa_Book_Controls Ctl,
Gl_Code_Combinations Glcc,
Gl_Code_Combinations Glcc1,
Gl_Code_Combinations Glcc2,
Gl_Code_Combinations Glcc3,
Gl_Code_Combinations Glcc4,
Gl_Code_Combinations Glcc5,
FA_METHODS FM
WHERE FM.METHOD_ID=Bkd.METHOD_ID
AND Fac.Category_Id = Bkd.Category_Id
AND Bkd.Category_Id = Ctb.Category_Id
AND Bkd.Book_Type_Code = Ctb.Book_Type_Code
AND Ctl.Book_Type_Code = Ctb.Book_Type_Code
AND Ctb.Asset_Cost_Account_Ccid = Glcc.Code_Combination_Id(+)
AND Ctb.Asset_Clearing_Account_Ccid =Glcc1.Code_Combination_Id(+)
AND Ctb.Wip_Cost_Account_Ccid = Glcc2.Code_Combination_Id(+)
AND Ctb.Wip_Clearing_Account_Ccid = Glcc3.Code_Combination_Id(+)
AND Ctb.Reserve_Account_Ccid = Glcc4.Code_Combination_Id(+)
AND Ctb.Deprn_Expense_Account_Ccid = Glcc5.Code_Combination_Id(+)
AND Substr(Bkd.Book_Type_Code, 1, 3) NOT IN
('121', '139','166','168','225','521','538','557','576','611','621','626')
AND Ctl.Date_Ineffective IS NULL
--AND Bkd.End_Dpis = nvl(:p_End_Dpis,Bkd.End_Dpis)
-- AND nvl(trunc(Bkd.End_Dpis),trunc(sysdate)) = nvl(to_date(:p_End_Dpis,'mm/dd/yyyy'),nvl(trunc(Bkd.End_Dpis),trunc(sysdate)))
AND Fac.Enabled_Flag = 'Y'
--AND Bkd.Book_Type_Code = nvl(:P_Book_Type_Code,Bkd.Book_Type_Code)
AND (Bkd.Book_Type_Code IN (:P_Book_Type_Code) OR COALESCE(:P_Book_Type_Code,null) IS Null)
) Al1
Report END : FA Category Accounts Report
No comments:
Post a Comment