ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F0103869E053B46B63588994 SELECT null FLEX_DATA_ALL, icd.balance_type BALANCE_TYPE, icd.encumbrance_type BDGT_OR_ECMBR, icd.period_name PERIOD, icd.budget_name FUNDING_BUDGET, icd.amount_type AMOUNT_TYPE, nvl( icd.cc_func_dr_amt, 0 ) - nvl( icd.cc_func_cr_amt, 0 ) AMOUNT, nvl( icd.funds_available_amt, 0 ) FUNDS_AVAILABLE, icd.status_code_meaning STATUS, icd.result_code_meaning RESULT_DESCRIPTION, gll.meaning PRINT_REPORT, fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_field_all', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FLEX_FIELD_ALL FROM gl_lookups gll, gl_code_combinations gcc, igc_cbc_dr_v icd WHERE icd.cc_header_id = :P_HEADER_ID and (:P_PRINT_REPORT = 'ALL' or ( (icd.cbc_result_code between 'P20' and 'P29') or (icd.cbc_result_code like 'F%') ) ) and gcc.code_combination_id = icd.code_combination_id and gll.lookup_type (+) = 'PRINT SELECTION' and gll.lookup_code (+) = :P_PRINT_REPORT ORDER BY DECODE( nvl( substr( icd.cbc_result_code, 0, 1 ), 'N' ) , 'F', 1, 'F' , 'P', DECODE( substr( icd.cbc_result_code, 0, 2 ), 'P2', 3, 'P1', 5, 7 ), 'P', DECODE( substr( icd.cbc_result_code, 0, 2), 'P2', 4, 'P1', 6, 8 ), 'N', 9 ), period_name Y IGC IGCBDTRR_XML F IGC Engagement sur contrat - Résultats de l'affichage- Non pris en charge : réservé pour une utilisation ultérieure Application: Contract Commitment Source: Engagement sur contrat - Résultats de l'affichage (XML) - Non pris en charge : réservé pour une utilisation ultérieure Short Name: IGCBDTRR_XML DB package: IGC_IGCBDTRR_XMLP_PKG US IGC Contract Commitment Display Results - draft Application: Contract Commitment Source: Contract Commitment Display Results (XML) - Not Supported: Reserved For Future Use Short Name: IGCBDTRR_XML DB package: IGC_IGCBDTRR_XMLP_PKG BI Publisher :flex_select_all :functional_currency :p_conc_request_id :p_header_id :p_print_report :p_set_of_books_id :set_of_books_name :struct_num 1 10 :p_set_of_books_id Number F ID livre US Ledger Id 2 20 :p_header_id Number F ID en-tête CC US CC Header Id 3 30 :p_print_report Char F Type d'état US Report Type