ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4706551A9E05362FB09050512 SELECT &ACCT_FLEX_BAL_SEG COMP_CODE, NVL (null, BAL.Category_Books_Account) ACCOUNT, LO.description C_PROPERTY_TYPE, CA.description C_CATEGORY_DESC, CA.category_id C_CATEGORY_ID, NVL(SUM (DECODE (BAL.Source_Type_Code, 'BEGIN', NVL(BAL.Amount,0), NULL)),0) BEGIN, NVL(SUM (DECODE (BAL.Source_Type_Code, 'ADDITION', NVL(BAL.Amount,0), NULL)),0) ADDITION, NVL(SUM (DECODE (BAL.Source_Type_Code, 'DEPRECIATION', NVL(BAL.Amount,0), NULL)),0) DEPRECIATION, NVL(SUM (DECODE (BAL.Source_Type_Code, 'RECLASS', NVL(BAL.Amount,0), NULL)),0) RECLASS, NVL(SUM (DECODE (BAL.Source_Type_Code, 'RETIREMENT', -NVL(BAL.Amount,0), NULL)),0) RETIREMENT, NVL(SUM (DECODE (BAL.Source_Type_Code, 'REVALUATION', NVL(BAL.Amount,0), NULL)),0) REVALUATION, NVL(SUM (DECODE (BAL.Source_Type_Code, 'TAX', NVL(BAL.Amount,0), NULL)),0) TAX, NVL(SUM (DECODE (BAL.Source_Type_Code, 'TRANSFER', NVL(BAL.Amount,0), NULL)),0) TRANSFER, NVL(SUM (DECODE (BAL.Source_Type_Code, 'END', NVL(BAL.Amount,0), NULL)),0) END, fnd_flex_xml_publisher_apis.process_kff_combination_1('comp_code_dsp', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') COMP_CODE_DSP, JE_JEHUFAMD_XMLP_PKG.bal_out_of_balanceformula(:BAL_BEGIN, :BAL_ADD, :BAL_DEPRN, :BAL_RECLASS, :BAL_RETIRE, :BAL_ADJUST, :BAL_TRANS, :BAL_END) BAL_OUT_OF_BALANCE, JE_JEHUFAMD_XMLP_PKG.acct_out_of_balanceformula(:ACCT_BEGIN, :ACCT_ADD, :ACCT_DEPRN, :ACCT_RECLASS, :ACCT_RETIRE, :ACCT_ADJUST, :ACCT_TRANS, :ACCT_END) ACCT_OUT_OF_BALANCE, JE_JEHUFAMD_XMLP_PKG.adjustformula(NVL(SUM (DECODE (BAL.Source_Type_Code, 'TAX', NVL(BAL.Amount,0), NULL)),0), NVL(SUM (DECODE (BAL.Source_Type_Code, 'REVALUATION', NVL(BAL.Amount,0), NULL)),0)) ADJUST, JE_JEHUFAMD_XMLP_PKG.out_of_balanceformula(NVL(SUM (DECODE (BAL.Source_Type_Code, 'BEGIN', NVL(BAL.Amount,0), NULL)),0), NVL(SUM (DECODE (BAL.Source_Type_Code, 'ADDITION', NVL(BAL.Amount,0), NULL)),0), NVL(SUM (DECODE (BAL.Source_Type_Code, 'DEPRECIATION', NVL(BAL.Amount,0), NULL)),0), NVL(SUM (DECODE (BAL.Source_Type_Code, 'RECLASS', NVL(BAL.Amount,0), NULL)),0), NVL(SUM (DECODE (BAL.Source_Type_Code, 'RETIREMENT', -NVL(BAL.Amount,0), NULL)),0), :ADJUST, NVL(SUM (DECODE (BAL.Source_Type_Code, 'TRANSFER', NVL(BAL.Amount,0), NULL)),0), NVL(SUM (DECODE (BAL.Source_Type_Code, 'END', NVL(BAL.Amount,0), NULL)),0)) OUT_OF_BALANCE, NVL (fnd_flex_xml_publisher_apis.process_kff_combination_1('account_d', 'SQLGL', 'GL#', ajcc.CHART_OF_ACCOUNTS_ID, NULL, ajcc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE'), BAL.Category_Books_Account) ACCOUNT_D FROM JE_HU_BALANCES_REPORT BAL, FA_CATEGORIES CA, FA_LOOKUPS LO, GL_CODE_COMBINATIONS DHCC, GL_CODE_COMBINATIONS AJCC WHERE DHCC.Code_Combination_ID = BAL.Distribution_CCID AND AJCC.Code_Combination_ID (+) = BAL.Adjustment_CCID AND :DO_INSERT = 1 AND BAL.category_id = CA.category_id AND LO.lookup_code = CA.property_type_code AND LO.lookup_type = 'PROPERTY TYPE' AND LO.enabled_flag = 'Y' AND sysdate between nvl(LO.start_date_active,sysdate) AND nvl(LO.end_date_active,sysdate) AND :P_COMPANY = fnd_flex_xml_publisher_apis.process_kff_combination_1('comp_code_dsp', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') GROUP BY null, NVL (&ACCT_FLEX_ACCT_SEG, BAL.Category_Books_Account), LO.description, CA.description, CA.category_id, fnd_flex_xml_publisher_apis.process_kff_combination_1('comp_code_dsp', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE'), NVL (fnd_flex_xml_publisher_apis.process_kff_combination_1('account_d', 'SQLGL', 'GL#', ajcc.CHART_OF_ACCOUNTS_ID, NULL, ajcc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE'), BAL.Category_Books_Account) ORDER BY 4 JE JEHUFAMD_XML US JE Hungarian Accumulated Depreciation Movement Schedule- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Hungarian Asset Movement Schedule: Accumulated Depreciation Application: European Localizations Source: Hungarian Accumulated Depreciation Movement Schedule (XML) - Not Supported: Reserved For Future Use Short Name: JEHUFAMD_XML DB package: JE_JEHUFAMD_XMLP_PKG BI Publisher &acct_flex_acct_seg &acct_flex_bal_seg :acct_add :acct_adjust :acct_bal_aprompt :acct_begin :acct_cc_aprompt :acct_deprn :acct_end :acct_reclass :acct_retire :acct_trans :adjust :bal_add :bal_adjust :bal_begin :bal_deprn :bal_end :bal_reclass :bal_retire :bal_trans :cat_maj_rprompt :cp_balance_type :cp_begin_or_end :cp_distribution_source_book :cp_end_date :cp_end_date_open :cp_fdrcsid :cp_period1_pc :cp_period1_pcd :cp_period1_pod :cp_period2_pc :cp_period2_pcd :cp_period_pc :cp_period_pcd :cp_period_pod :do_insert :p_adj_mode :p_book :p_company :p_conc_request_id :p_min_precision :p_period1 :p_period2 :p_report_type :period1_fy :period1_pcd :period1_pod :period2_fy :period2_pcd :period2_pod :rp_bal_lprompt :rp_company_name :rp_ctr_aprompt :rp_report_name 1 -30 :p_report_type Char RESERVE Y US Report Type Report Type 2 -20 :p_not_used_in_report Number SELECT ACCOUNTING_FLEX_STRUCTURE FROM FA_BOOK_CONTROLS WHERE BOOK_TYPE_CODE = :$flex$.book Y US Account Flex Structure Account Flex Structure 3 10 :p_book LOV Oracle FA_BOOK_TYPE Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls_sec order by book_type_code Y US Book Book 4 20 :p_period1 LOV Oracle JGZZ_FA_DEPRN_PERIODS_FROM Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_book_type and period_counter> (select min(dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.fa_book_type) and (period_close_date is not null or (period_close_date is null and deprn_run is not null)) order by period_counter Y US From Period From Period 5 30 :p_period2 LOV Oracle JGZZ_FA_DEPRN_PERIODS_TO Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_book_type and period_counter>=( select period_counter from fa_deprn_periods where book_type_code=:$flex$.fa_book_type and period_name=:$flex$.jgzz_fa_deprn_periods_from) and (period_close_date is not null or (period_close_date is null and deprn_run is not null)) order by period_counter Y US To Period To Period 6 40 :p_company Char Y US Company Company :$flex$.book Book Account Flex Structure :$flex$.fa_book_type Book From Period :$flex$.fa_book_type Book To Period :$flex$.jgzz_fa_deprn_periods_from From Period To Period