ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4727751A9E05362FB09050512Y select -- null ACCOUNT, --null COMPANY, fnd_flex_xml_publisher_apis.process_kff_combination_1('accounting_segment', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE') ACCOUNT, fnd_flex_xml_publisher_apis.process_kff_combination_1('balancing_segment', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') COMPANY, substr(fnd_flex_xml_publisher_apis.process_kff_combination_1('accounting_segment', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE'),1,3) Groups, substr(fnd_flex_xml_publisher_apis.process_kff_combination_1('accounting_segment', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE'),1,2) Sub_Class, substr(fnd_flex_xml_publisher_apis.process_kff_combination_1('accounting_segment', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE'),1,1) Class, decode(:P_CURRENCY_TYPE, 'T', decode(sign(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))), 1, sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)),0) + sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)), 'S', decode(sign(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))), 1, sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)),0) + sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)), 'E', sum(decode(bl.translated_flag, 'R', decode(sign(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)), 1, decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0),0) + decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0), decode(sign(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0)), 1, decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0),0) + decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0)))) BEGIN_DR, decode(:P_CURRENCY_TYPE, 'T', decode(sign(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))), -1, abs(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))),0) + sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)), 'S', decode(sign(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))), -1, abs(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))),0) + sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)), 'E', sum(decode(bl.translated_flag, 'R', decode(sign(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)), -1, abs(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)),0) + decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0), decode(sign(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0)), -1, abs(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0)),0) + decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0)))) BEGIN_CR, decode(:P_CURRENCY_TYPE, 'T',sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_dr,0),0)), 'S',sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_dr,0),0)), 'E',sum(decode(bl.translated_flag, 'R',decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_dr,0),0), decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_dr_beq,0),0)))) PER_DR, decode(:P_CURRENCY_TYPE, 'T',sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_cr,0),0)), 'S',sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_cr,0),0)), 'E',sum(decode(bl.translated_flag, 'R',decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_cr,0),0), decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_cr_beq,0),0)))) PER_CR, decode(:P_CURRENCY_TYPE, 'T', decode(sign(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))), 1, sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)),0) + sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)), 'S', decode(sign(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))), 1, sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)),0) + sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)), 'E', sum(decode(bl.translated_flag, 'R', decode(sign(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)), 1, decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0),0) + decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0), decode(sign(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0)), 1, decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0),0) + decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0)))) + decode(:P_CURRENCY_TYPE, 'T',sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_dr,0),0)), 'S',sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_dr,0),0)), 'E',sum(decode(bl.translated_flag, 'R',decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_dr,0),0), decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_dr_beq,0),0)))) END_DR, decode(:P_CURRENCY_TYPE, 'T', decode(sign(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))), -1, abs(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))),0) + sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)), 'S', decode(sign(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))), -1, abs(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))),0) + sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)), 'E', sum(decode(bl.translated_flag, 'R', decode(sign(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)), -1, abs(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)),0) + decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0), decode(sign(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0)), -1, abs(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0)),0) + decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0)))) + decode(:P_CURRENCY_TYPE, 'T',sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_cr,0),0)), 'S',sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_cr,0),0)), 'E',sum(decode(bl.translated_flag, 'R',decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_cr,0),0), decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_cr_beq,0),0)))) END_CR, decode(:P_CURRENCY_TYPE, 'T', decode(sign(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))), 1, sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)),0) + sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)), 'S', decode(sign(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))), 1, sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)),0) + sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)), 'E', sum(decode(bl.translated_flag, 'R', decode(sign(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)), 1, decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0),0) + decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0), decode(sign(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0)), 1, decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0),0) + decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0)))) + decode(:P_CURRENCY_TYPE, 'T',sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_dr,0),0)), 'S',sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_dr,0),0)), 'E',sum(decode(bl.translated_flag, 'R',decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_dr,0),0), decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_dr_beq,0),0)))) - (decode(:P_CURRENCY_TYPE, 'T', decode(sign(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))), -1, abs(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))),0) + sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)), 'S', decode(sign(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))), -1, abs(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))),0) + sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)), 'E', sum(decode(bl.translated_flag, 'R', decode(sign(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)), -1, abs(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)),0) + decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0), decode(sign(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0)), -1, abs(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0)),0) + decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0)))) + decode(:P_CURRENCY_TYPE, 'T',sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_cr,0),0)), 'S',sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_cr,0),0)), 'E',sum(decode(bl.translated_flag, 'R',decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_cr,0),0), decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_cr_beq,0),0))))) NET, max(LR.TARGET_LEDGER_name) LEDGER_NAME_H, --GL_GLYRLBGE_XMLP_PKG.c_bal_lpromptformula(:C_BAL_LPROMPT) C_BAL_LPROMPT, fnd_flex_xml_publisher_apis.process_kff_combination_1('disp_company', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') DISP_COMPANY, fnd_flex_xml_publisher_apis.process_kff_combination_1('company_name', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'DESCRIPTION') COMPANY_NAME, GL_GLYRLBGE_XMLP_PKG.comp_net_crformula(:COMP_NET) COMP_NET_CR, fnd_flex_xml_publisher_apis.process_kff_combination_1('bal_secure', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'SECURITY') BAL_SECURE, GL_GLYRLBGE_XMLP_PKG.cl_net_crformula(:CL_NET) CL_NET_CR, GL_GLYRLBGE_XMLP_PKG.sc_net_crformula(:SC_NET) SC_NET_CR, GL_GLYRLBGE_XMLP_PKG.gr_net_crformula(:GR_NET) GR_NET_CR, fnd_flex_xml_publisher_apis.process_kff_combination_1('account_desc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'DESCRIPTION') ACCOUNT_DESC, fnd_flex_xml_publisher_apis.process_kff_combination_1('account_value', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE') ACCOUNT_VALUE, GL_GLYRLBGE_XMLP_PKG.zero_indicatorformula( decode(:P_CURRENCY_TYPE, 'T', decode(sign(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))), -1, abs(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))),0) + sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)), 'S', decode(sign(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))), -1, abs(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))),0) + sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)), 'E', sum(decode(bl.translated_flag, 'R', decode(sign(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)), -1, abs(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)),0) + decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0), decode(sign(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0)), -1, abs(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0)),0) + decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0)))) , decode(:P_CURRENCY_TYPE, 'T', decode(sign(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))), 1, sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)),0) + sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)), 'S', decode(sign(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))), 1, sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)),0) + sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)), 'E', sum(decode(bl.translated_flag, 'R', decode(sign(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)), 1, decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0),0) + decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0), decode(sign(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0)), 1, decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0),0) + decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0)))), decode(:P_CURRENCY_TYPE, 'T',sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_dr,0),0)), 'S',sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_dr,0),0)), 'E',sum(decode(bl.translated_flag, 'R',decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_dr,0),0), decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_dr_beq,0),0)))), decode(:P_CURRENCY_TYPE, 'T',sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_cr,0),0)), 'S',sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_cr,0),0)), 'E',sum(decode(bl.translated_flag, 'R',decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_cr,0),0), decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_cr_beq,0),0)))) ) ZERO_INDICATOR, GL_GLYRLBGE_XMLP_PKG.net_crformula( decode(:P_CURRENCY_TYPE, 'T', decode(sign(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))), 1, sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)),0) + sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)), 'S', decode(sign(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))), 1, sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)),0) + sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)), 'E', sum(decode(bl.translated_flag, 'R', decode(sign(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)), 1, decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0),0) + decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0), decode(sign(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0)), 1, decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0),0) + decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0)))) + decode(:P_CURRENCY_TYPE, 'T',sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_dr,0),0)), 'S',sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_dr,0),0)), 'E',sum(decode(bl.translated_flag, 'R',decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_dr,0),0), decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_dr_beq,0),0)))) - (decode(:P_CURRENCY_TYPE, 'T', decode(sign(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))), -1, abs(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))),0) + sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)), 'S', decode(sign(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))), -1, abs(sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0))),0) + sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)) - sum(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)), 'E', sum(decode(bl.translated_flag, 'R', decode(sign(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)), -1, abs(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0)),0) + decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr,0),0), decode(sign(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0)), -1, abs(decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_dr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0)),0) + decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0) - decode(bl.period_name,:FIRST_PERIOD_NAME,nvl(bl.begin_balance_cr_beq,0),0)))) + decode(:P_CURRENCY_TYPE, 'T',sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_cr,0),0)), 'S',sum(decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_cr,0),0)), 'E',sum(decode(bl.translated_flag, 'R',decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_cr,0),0), decode(bl.period_name,:P_PERIOD_NAME,nvl(bl.period_net_cr_beq,0),0)))))) NET_CR, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_secure', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'SECURITY') ACCT_SECURE FROM gl_balances BL, gl_code_combinations CC, GL_LEDGERS GLL, GL_LEDGER_SET_ASSIGNMENTS ASG, GL_LEDGER_RELATIONSHIPS LR WHERE bl.currency_code = :ACTUAL_CURRENCY AND bl.period_name in (:FIRST_PERIOD_NAME,:P_PERIOD_NAME) AND bl.actual_flag = 'A' AND &CURRENCY_WHERE AND &ACCESS_WHERE AND cc.template_id is null AND CC.SUMMARY_FLAG = 'N' AND &ACCOUNTING_SEGMENT_WHERE AND &BALANCING_SEGMENT_WHERE AND cc.chart_of_accounts_id = :STRUCT_NUM AND cc.code_combination_id = bl.code_combination_id AND GLL.LEDGER_ID = :P_LEDGER_ID AND ASG.LEDGER_SET_ID(+) = GLL.LEDGER_ID AND LR.TARGET_LEDGER_ID = NVL(ASG.LEDGER_ID, GLL.LEDGER_ID) AND LR.SOURCE_LEDGER_ID = NVL(ASG.LEDGER_ID, GLL.LEDGER_ID) AND LR.TARGET_CURRENCY_CODE = :P_LEDGER_CURRENCY AND LR.SOURCE_LEDGER_ID = BL.LEDGER_ID AND LR.TARGET_LEDGER_ID = BL.LEDGER_ID GROUP BY fnd_flex_xml_publisher_apis.process_kff_combination_1('accounting_segment', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('balancing_segment', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE'), LR.TARGET_LEDGER_NAME --ADDED ,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_secure', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'SECURITY'),fnd_flex_xml_publisher_apis.process_kff_combination_1('account_value', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE'),fnd_flex_xml_publisher_apis.process_kff_combination_1('account_desc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'DESCRIPTION'),fnd_flex_xml_publisher_apis.process_kff_combination_1('bal_secure', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'SECURITY'),fnd_flex_xml_publisher_apis.process_kff_combination_1('company_name', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'DESCRIPTION'),fnd_flex_xml_publisher_apis.process_kff_combination_1('disp_company', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') order by --2,1 LEDGER_NAME_H,COMPANY,CLASS,SUB_CLASS,GROUPS,ACCOUNT,BEGIN_DR,BEGIN_CR,PER_DR,PER_CR,END_DR, END_CR,NET SQLGL GLYRLBGE_XML AR GL ميزان المراجعة - الممتد (بتنسيق XML) Imported from BI Publisher Description: ميزان مراجعة ممتد Application: الأستاذ العام Source: ميزان المراجعة - الممتد (بتنسيق XML) Short Name: GLYRLBGE_XML DB package: GL_GLYRLBGE_XMLP_PKG D GL Summen/Saldenliste - Erweitert Imported from BI Publisher Description: Summen/Saldenliste - Erweitert Application: Rechnungswesen Source: Summen/Saldenliste - Erweitert (XML) Short Name: GLYRLBGE_XML DB package: GL_GLYRLBGE_XMLP_PKG E GL Balance de Comprobación - Expandido Imported from BI Publisher Description: Balance de Comprobación Expandido Application: General Ledger Source: Balance de Comprobación - Expandido (XML) Short Name: GLYRLBGE_XML DB package: GL_GLYRLBGE_XMLP_PKG F GL Balance - Grand format Imported from BI Publisher Description: Balance grand format Application: General Ledger Source: Balance - Grand format (XML) Short Name: GLYRLBGE_XML DB package: GL_GLYRLBGE_XMLP_PKG I GL Bilancio di verifica - Esteso Imported from BI Publisher Description: Bilancio di verifica esteso Application: General Ledger Source: Bilancio di verifica - Esteso (XML) Short Name: GLYRLBGE_XML DB package: GL_GLYRLBGE_XMLP_PKG JA GL 残高試算表 - 貸借両建 Imported from BI Publisher Description: 貸借両建の残高試算表 Application: General Ledger Source: 残高試算表 - 貸借両建 (XML) Short Name: GLYRLBGE_XML DB package: GL_GLYRLBGE_XMLP_PKG KO GL 시산표 - 확장 Imported from BI Publisher Description: 확장된 시산표 Application: General Ledger Source: 시산표 - 확장(XML) Short Name: GLYRLBGE_XML DB package: GL_GLYRLBGE_XMLP_PKG PTB GL Balancete - Expandido Imported from BI Publisher Description: Balancete Expandido Application: General Ledger Source: Balancete - Expandido (XML) Short Name: GLYRLBGE_XML DB package: GL_GLYRLBGE_XMLP_PKG RU GL Расширенный пробный баланс Imported from BI Publisher Description: Расширенный пробный баланс Application: Главная книга Source: Расширенный пробный баланс (XML) Short Name: GLYRLBGE_XML DB package: GL_GLYRLBGE_XMLP_PKG S GL Råbalans - Utökad Imported from BI Publisher Description: Utökad råbalans Application: General Ledger Source: Råbalans - Utökad (XML) Short Name: GLYRLBGE_XML DB package: GL_GLYRLBGE_XMLP_PKG TR GL Mizan - Genişletilmiş Imported from BI Publisher Description: Genişletilmiş Mizan Application: Genel Muhasebe Source: Mizan - Genişletilmiş (XML) Short Name: GLYRLBGE_XML DB package: GL_GLYRLBGE_XMLP_PKG US GL Trial Balance - Expanded Imported from BI Publisher Description: Expanded Trial Balance Application: General Ledger Source: Trial Balance - Expanded (XML) Short Name: GLYRLBGE_XML DB package: GL_GLYRLBGE_XMLP_PKG ZHS GL 试算表 - 已扩展 Imported from BI Publisher Description: 扩展试算表 Application: 总帐管理系统 Source: 试算表 - 已扩展 (XML) Short Name: GLYRLBGE_XML DB package: GL_GLYRLBGE_XMLP_PKG BI Publisher &access_where &accounting_segment_where &balancing_segment_where &currency_where :access_name :access_where :accounting_orderby :accounting_segment :accounting_segment_where :actual_currency :balancing_orderby :balancing_segment :balancing_segment_where :begin_cr_select :begin_dr_select :c_industry_code :cl_net :comp_net :currency_name :currency_where :end_cr_select :end_dr_select :first_period_name :gr_net :p_access_set_id :p_chart_of_accounts_id :p_company :p_conc_request_id :p_currency_code :p_currency_type :p_end_account :p_entered_currency :p_ledger_currency :p_ledger_id :p_ledger_name :p_minprecision :p_period_name :p_precision :p_start_account :per_cr_select :per_dr_select :sc_net :struct_num :translate_where 1 -40 :p_access_set_id Number fnd_profile.value('GL_ACCESS_SET_ID') Y AR معرف مجموعة الوصول للبيانات معرف مجموعة الوصول للبيانات D Kennung DatenzugriffsSet Kennung DatenzugriffsSet E Id Juego de Accesos a Datos Id juego de accesos a datos F ID jeu d'accès aux données ID jeu d'accès aux données I Id serie di accesso dati Id della serie di accesso ai dati JA データ・アクセス・セットID データ・アクセス・セットID KO 데이터 액세스 세트 ID 데이터 액세스 세트 ID PTB Id do Conjunto de Acesso a Dados Id do Conjunto de Acesso a Dados RU Идент. набора доступа к данным Идент. набора доступа к данным S Id för dataåtkomstuppsättning Id för dataåtkomstuppsättning TR Veri Erişim Kümesi No Veri Erişim Kümesi No US Data Access Set Id Data Access Set Id ZHS 数据访问权限集标识 数据访问权限集标识 2 -30 :p_ledger_id Number select gl_ledger_utils_pkg.get_ledger_id_of_short_name(:$flex$.ledger_ledger_set) FROM DUAL Y AR GL_SRS_LEDGER_ID_UNVALIDATED معرف الأستاذ D GL_SRS_LEDGER_ID_UNVALIDATED Buchkennung E GL_SRS_LEDGER_ID_UNVALIDATED Id Libro Mayor F GL_SRS_LEDGER_ID_UNVALIDATED ID livre I GL_SRS_LEDGER_ID_UNVALIDATED Id sezionale JA GL_SRS_LEDGER_ID_UNVALIDATED 元帳ID KO GL_SRS_LEDGER_ID_UNVALIDATED 원장 ID PTB GL_SRS_LEDGER_ID_UNVALIDATED Id do Razão RU GL_SRS_LEDGER_ID_UNVALIDATED Идентификатор книги S GL_SRS_LEDGER_ID_UNVALIDATED Huvudboks-id TR GL_SRS_LEDGER_ID_UNVALIDATED Defter No US GL_SRS_LEDGER_ID_UNVALIDATED Ledger Id ZHS GL_SRS_LEDGER_ID_UNVALIDATED 分类账标识 3 -20 :p_chart_of_accounts_id Number SELECT chart_of_accounts_id FROM gl_access_sets WHERE access_set_id = fnd_profile.value('GL_ACCESS_SET_ID') Y AR معرف جدول تصنيف الحسابات معرف جدول تصنيف الحسابات D Kontenplankennung Kontenplankennung E Id Plan de Cuentas Identificador de Plan de Cuentas F ID plan de comptes ID plan de comptes I Id piano dei conti ID del piano dei conti JA 勘定体系ID 勘定体系ID KO 계정코드집 ID 계정코드집 ID PTB Id do Plano de Contas Id do Plano de Contas RU Идент. плана счетов Идент. плана счетов S Kontoplans-id Kontoplans-id TR Hesap Planı No Hesap Planı No US Chart Of Accounts Id Chart Of Accounts Id ZHS 科目表标识 科目表标识 4 10 :p_ledger_name LOV Oracle GL_SRS_LEDGER_WITH_SETS_AND_ALCS_STORE_SHORT_NAME Y select nvl(rel.target_ledger_short_name,led.short_name) id, nvl(rel.target_ledger_name,led.name) value, led.description description from gl_access_set_ledgers ac,gl_ledgers led,gl_ledger_relationships rel where ac.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and led.ledger_id=ac.ledger_id and rel.source_ledger_id(+)=ac.ledger_id and rel.target_ledger_id(+)=ac.ledger_id and rel.application_id(+)=101 order by nvl(rel.target_ledger_name,led.name) select name from gl_ledgers where ledger_id = gl_access_set_security_pkg.get_default_ledger_id(fnd_profile.value('GL_ACCESS_SET_ID'), 'R') Y AR دفتر الأستاذ/مجموعة دفاتر الأستاذ اسم الأستاذ D Buch/BuchSet Buchbezeichnung E Libro Mayor/Juego de Libros Mayores Nombre de Libro Mayor F Livre/jeu de livres Nom du livre I Libro contabile/serie libri contabili Nome del libro contabile JA 元帳/元帳セット 元帳名 KO 원장/원장 세트 원장명 PTB Razão/Conjunto de Razões Nome do Razão RU Книга/набор книг Имя книги S Huvudbok/huvudboksgrupp Huvudbok TR Defter / Defter Kümesi Defter Adı US Ledger/Ledger Set Ledger Name ZHS 分类账/分类账集 分类账名称 5 20 :p_ledger_currency LOV Oracle GL_SRS_LEDGER_CURRENCIES Y select curr.currency_code id, curr.currency_code value, null description from fnd_currencies curr where curr.currency_code in (select rel.target_currency_code from gl_ledger_relationships rel where rel.target_ledger_short_name=:$flex$.gl_srs_ledger_with_sets_and_alcs_store_short_name union select rel.target_currency_code from gl_ledger_set_assignments ls,gl_ledger_relationships rel where ls.ledger_set_id=:$flex$.gl_srs_ledger_id_unvalidated and rel.source_ledger_id=ls.ledger_id and rel.target_ledger_id=ls.ledger_id) order by value,description SELECT GL_LEDGER_UTILS_PKG.GET_DEFAULT_LEDGER_CURRENCY(:$flex$.ledger_ledger_set) FROM DUAL Y AR عملة الأستاذ عملة الأستاذ D Buchwährung Buchwährung E Divisa de Libro Mayor Divisa de Libro Mayor F Devise comptable Devise comptable I Divisa libro contabile Divisa del libro contabile JA 元帳通貨 元帳通貨 KO 원장 통화 원장 통화 PTB Moeda do Razão Moeda do Razão RU Валюта книги Валюта книги S Huvudboksvaluta Huvudboksvaluta TR Defter Para Birimi Defter Para Birimi US Ledger Currency Ledger Currency ZHS 分类账币种 分类账币种 6 30 :p_currency_type LOV Oracle GL_SRS_CURRENCY_TYPE Y select lookup_code id, meaning value, description description from gl_lookups where lookup_type='GL_CURRENCY_TYPE' and lookup_code in ('T','S','E') order by meaning select meaning from gl_lookups WHERE LOOKUP_TYPE = 'GL_CURRENCY_TYPE' and lookup_code = 'T' Y AR نوع العملة نوع العملة D Währungsart Währungsart E Tipo de Divisa Tipo de Divisa F Type de devise Type de devise I Tipo di divisa Tipo di divisa JA 通貨タイプ 通貨タイプ KO 통화 유형 통화 유형 PTB Tipo de Moeda Tipo de Moeda RU Тип валюты Тип валюты S Valutatyp Valutatyp TR Para Birimi Tipi Para Birimi Tipi US Currency Type Currency Type ZHS 币种类型 币种类型 7 40 :p_entered_currency LOV Oracle GL_SRS_ENTERED_CURRENCIES Y select currency_code id, currency_code value, null description from gl_entered_currencies_v where currency_type=:$flex$.gl_srs_currency_type order by value,description SELECT CURRENCY_CODE FROM GL_ENTERED_CURRENCIES_V WHERE CURRENCY_TYPE = DECODE(:$flex$.currency_type, 'S', 'S', 'T', 'T', NULL) Y AR العملة المدخلة العملة المدخلة D Eingabewährung Eingabewährung E Divisa Introducida Divisa Introducida F Devise de saisie Devise de saisie I Divisa inserita Divisa inserita JA 入力通貨 入力通貨 KO 입력 통화 입력 통화 PTB Moeda Informada Moeda Informada RU Введенная валюта Введенная валюта S Registrerad valuta Registrerad valuta TR Girilen Para Birimi Girilen Para Birimi US Entered Currency Entered Currency ZHS 输入币种 输入币种 8 50 :p_period_name LOV Oracle GL_SRS_PERIOD_NAME_FOR_LEDGER_SET Y select per.period_name id, per.period_name value, null description from gl_ledgers led,gl_periods per where led.ledger_id=:$flex$.gl_srs_ledger_id_unvalidated and per.period_set_name=led.period_set_name and per.period_type=led.accounted_period_type and exists ( select 'has data' from gl_ledgers led2, gl_ledger_set_assignments ls, gl_ledger_relationships rel, gl_period_statuses ps where led2.ledger_id=led.ledger_id and ls.ledger_set_id (+)=led2.ledger_id and rel.source_ledger_id=nvl(ls.ledger_id,led.ledger_id) and rel.target_ledger_id=nvl(ls.ledger_id,led.ledger_id) and rel.target_currency_code=:$flex$.gl_srs_ledger_currencies and ps.application_id=101 and ps.ledger_id=rel.source_ledger_id and ps.closing_status in ('O','C','P') and ps.period_name=per.period_name) order by per.period_year,per.period_num Y AR الفترة اسم الفترة D Periode Periodenbezeichnung E Período Nombre del Período F Période Nom de la période I Periodo Nome del periodo JA 期間 期間名 KO 기간 기간명 PTB Período Nome do Período RU Период Имя периода S Period Periodnamn TR Dönem Dönem Adı US Period Period Name ZHS 期间 期间名称 9 60 :p_start_account Char Y AR الحساب من الحساب من D Von Konto Von Konto E De Cuenta De Cuenta F Compte - De Compte - De I Conto - Da Conto - Da JA 勘定科目:自 勘定科目:自 KO 계정: 부터 계정: 부터 PTB Conta - De Conta - De RU Счет с Счет с S Från konto Från konto TR Hesap, İlk Hesap, İlk US Account From Account From ZHS 账户自 账户自 10 70 :p_end_account Char Y AR حساب إلى حساب إلى D Bis Konto Bis Konto E A Cuenta A Cuenta F Compte - A Compte - A I Conto - A Conto - A JA 勘定科目:至 勘定科目:至 KO 계정: 까지 계정: 까지 PTB Conta - Até Conta - Até RU Счет по Счет по S Till konto Till konto TR Hesap, Son Hesap, Son US Account To Account To ZHS 账户至 账户至 11 80 :p_company Char AR مقطع الترصيد مقطع الترصيد D Buchungskreis Buchungskreis E Segmento de Balance Segmento de Balance F Segment d'équilibrage Segment d'équilibrage I Segmento di quadratura Segmento di quadratura JA 貸借一致セグメント 貸借一致セグメント KO 잔액 조정 세그먼트 잔액 조정 세그먼트 PTB Segmento Balanceador Segmento Balanceador RU Балансирующий сегмент Балансирующий сегмент S Balanssegment Balanssegment TR Dengeleme Segmenti Dengeleme Segmenti US Balancing Segment Balancing Segment ZHS 平衡段 平衡段 12 90 :p_precision LOV Oracle GL_NLS_FRA_PRECISION Y select lookup_code id, meaning value, description description from gl_lookups where lookup_type='GL_NLS_FRA_PRECISION' order by meaning Y AR الدقة الدقة D Nachkommastellen Nachkommastellen E Precisión Precisión F Précision Précision I Precisione Precisione JA 精度 精度 KO 소수점 이하 자리수 소수점 이하 자리수 PTB Precisão Precisão RU Точность Точность TR Duyarlılık Duyarlılık US Precision Precision ZHS 精确度 精确度