JG Statutory Asset Ledger Report- Not Supported: Reserved For Future Use
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Statutory Asset Ledger Report
Application: Regional Localizations
Source: Statutory Asset Ledger Report (XML) - Not Supported: Reserved For Future Use
Short Name: JGZZFALE_XML
DB package: JG_JGZZFALE_XMLP_PKG
Description: Statutory Asset Ledger Report
Application: Regional Localizations
Source: Statutory Asset Ledger Report (XML) - Not Supported: Reserved For Future Use
Short Name: JGZZFALE_XML
DB package: JG_JGZZFALE_XMLP_PKG
Run
JG Statutory Asset Ledger Report- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
select i.asset_number, i.description, i.company, substr(i.asset_cost_acct, 1, :P_PRECISION * :P_PRECISION_WIDTH) parent_account, i.asset_cost_acct cost_account, i.account_description, i.date_placed_in_service, a.commitment, a.investment_law, nvl(sum(i.cost), 0) cost, nvl(sum(i.ltd_deprn), 0) reserve, nvl(sum(i.nbv), 0) nbv, i.serial_number, i.tag_number, i.category, i.employee_name, i.employee_number, nvl(i.life_yr_mo,0), nvl(i.ytd_deprn,0), nvl(i.deprn_amount,0), nvl(i.nbv_beginning_fy,0), i.deprn_expense_acct, i.accum_deprn_acct, i.expense_acct_description, i.functional_currency_code, i.cost_center, i.cost_center_description, i.company_description, i.category_description, i.organization_name, i.major_category_description, i.minor_category_description, JG_JGZZFALE_XMLP_PKG.cf_parent_acct_descrformula(substr ( i.asset_cost_acct , 1 , :P_PRECISION * :P_PRECISION_WIDTH )) CF_PARENT_ACCT_DESCR from fa_additions a, fa_deprn_rep_itf i where i.request_id = :P_CONC_REQUEST_ID and i.company = :P_BALANCING_SEGMENT and a.asset_number = i.asset_number group by i.asset_number, i.description, i.company, substr(i.asset_cost_acct, 1, :P_PRECISION * :P_PRECISION_WIDTH), i.asset_cost_acct, i.account_description, i.date_placed_in_service, a.commitment, a.investment_law, i.serial_number, i.tag_number, i.category, i.employee_name, i.employee_number, i.life_yr_mo, nvl(i.ytd_deprn,0), nvl(i.deprn_amount,0), nvl(i.nbv_beginning_fy,0), i.deprn_expense_acct, i.accum_deprn_acct, i.expense_acct_description, i.functional_currency_code, i.cost_center, i.cost_center_description, i.company_description, i.category_description, i.organization_name, i.major_category_description, i.minor_category_description order by i.asset_cost_acct, i.asset_number |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Official Run |
|
LOV Oracle | |
Book |
|
LOV Oracle | |
Balancing Segment |
|
Char | |
Period |
|
LOV Oracle | |
Parent Totals |
|
LOV Oracle | |
Precision |
|
LOV Oracle | |
Precision Width |
|
Number | |
Country |
|
LOV Oracle | |
First Global Attribute |
|
LOV Oracle | |
Second Global Attribute |
|
LOV Oracle |