ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4706651A9E05362FB09050512 SELECT &ACCT_FLEX_BAL_SEG COMP_CODE, NVL(&ACCT_FLEX_ACCT_SEG, 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, DECODE(:P_REPORT_TYPE, 'COST', 'ADDITION', 'CIP ADDITION'), NVL(BAL.Amount,0), NULL) ) ,0) ADDITION, NVL(SUM (DECODE(BAL.Source_Type_Code, DECODE(:P_REPORT_TYPE, 'CIP COST', 'ADDITION'),-NVL(BAL.Amount,0), NULL) ),0) CAPITALIZATION, NVL(SUM (DECODE (BAL.Source_Type_Code, DECODE(:P_REPORT_TYPE, 'COST', 'ADJUSTMENT', 'CIP ADJUSTMENT'), NVL(BAL.Amount,0), NULL) ),0) ADJUSTMENT, NVL(SUM (DECODE (BAL.Source_Type_Code, 'RECLASS', NVL(BAL.Amount,0), NULL)),0) RECLASS, NVL(SUM (DECODE (BAL.Source_Type_Code, DECODE(:P_REPORT_TYPE, 'COST', 'RETIREMENT', 'CIP 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, '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_d', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') COMP_CODE_D, JE_JEHUFAMS_XMLP_PKG.bal_out_of_balanceformula(:BAL_BEGIN, :BAL_ADD, :BAL_REVAL, :BAL_RECLASS, :BAL_RETIRE, :BAL_ADJUST, :BAL_TRANS, :BAL_CAPITAL, :BAL_END) BAL_OUT_OF_BALANCE, JE_JEHUFAMS_XMLP_PKG.acct_out_of_balanceformula(:ACCT_BEGIN, :ACCT_ADD, :ACCT_REVAL, :ACCT_RECLASS, :ACCT_RETIRE, :ACCT_ADJUST, :ACCT_TRANS, :ACCT_CAPITAL, :ACCT_END) ACCT_OUT_OF_BALANCE, JE_JEHUFAMS_XMLP_PKG.caprevalformula(NVL ( SUM ( DECODE ( BAL.Source_Type_Code , 'REVALUATION' , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 ), NVL ( SUM ( DECODE ( BAL.Source_Type_Code , DECODE ( :P_REPORT_TYPE , 'CIP COST' , 'ADDITION' ) , - NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 )) CAPREVAL, JE_JEHUFAMS_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 , DECODE ( :P_REPORT_TYPE , 'COST' , 'ADDITION' , 'CIP ADDITION' ) , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 ), NVL ( SUM ( DECODE ( BAL.Source_Type_Code , 'REVALUATION' , 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 , DECODE ( :P_REPORT_TYPE , 'COST' , 'RETIREMENT' , 'CIP RETIREMENT' ) , - NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 ), NVL ( SUM ( DECODE ( BAL.Source_Type_Code , DECODE ( :P_REPORT_TYPE , 'COST' , 'ADJUSTMENT' , 'CIP ADJUSTMENT' ) , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 ), NVL ( SUM ( DECODE ( BAL.Source_Type_Code , 'TRANSFER' , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 ), NVL ( SUM ( DECODE ( BAL.Source_Type_Code , DECODE ( :P_REPORT_TYPE , 'CIP COST' , 'ADDITION' ) , - NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 ), NVL ( SUM ( DECODE ( BAL.Source_Type_Code , 'END' , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 )) OOB, 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_d', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') GROUP BY &ACCT_FLEX_BAL_SEG, 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_d', '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 Y JE JEHUFAMS_XML US JE Hungarian Asset Movement Schedule: Gross Changes- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Hungarian Asset Movement Schedule (Gross Changes) Application: European Localizations Source: Hungarian Asset Movement Schedule: Gross Changes (XML) - Not Supported: Reserved For Future Use Short Name: JEHUFAMS_XML DB package: JE_JEHUFAMS_XMLP_PKG BI Publisher &acct_flex_acct_seg &acct_flex_bal_seg :acct_add :acct_adjust :acct_bal_aprompt :acct_begin :acct_capital :acct_cc_aprompt :acct_end :acct_reclass :acct_retire :acct_reval :acct_trans :bal_add :bal_adjust :bal_begin :bal_capital :bal_end :bal_reclass :bal_retire :bal_reval :bal_trans :cat_maj_rprompt :cp_balance_type :cp_begin_or_end :cp_distribution_source_book :cp_end_date :cp_end_period_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 COST 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