ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F0153869E053B46B63588994 select ige.cc_header_id "Contract Header ID" , igh.cc_type "Contract Type" , igh.cc_num "Contract Number" , iga.cc_acct_line_num "Account Line Number" , igf.cc_det_pf_line_num "Forecast Line Number" , ige.exception_reason "Error Message" from igc_cc_process_exceptions ige , igc_cc_headers igh , igc_cc_acct_lines iga , igc_cc_det_pf igf where ige.set_of_books_id = :P_SET_OF_BOOKS_ID and ige.org_id = :P_ORG_ID and ige.process_type = :P_PROCESS_TYPE and ige.process_phase = :P_PROCESS_PHASE and ige.request_id = :P_REQUEST_ID and ige.cc_header_id = igh.cc_header_id(+) and ige.cc_header_id = iga.cc_header_id(+) and ige.cc_acct_line_id = iga.cc_acct_line_id(+) and ige.cc_acct_line_id= igf.cc_acct_line_id(+) and ige.cc_det_pf_line_id = igf.cc_det_pf_line_id(+) Y IGC IGCCRVFR_XML F IGC Etat des exceptions de correction de réévaluation Contract Commitment- Non pris en charge : réservé pour une utilisation ultérieure Application: Contract Commitment Source: Etat des exceptions de correction de réévaluation Contract Commitment (XML) - Non pris en charge : réservé pour une utilisation ultérieure Short Name: IGCCRVFR_XML DB package: IGC_IGCCYRPR_XMLP_PKG US IGC Contract Commitment Revaluation Fix Exception - draft Application: Contract Commitment Source: Contract Commitment Revaluation Fix Exception Report (XML) - Not Supported: Reserved For Future Use Short Name: IGCCRVFR_XML DB package: IGC_IGCCYRPR_XMLP_PKG BI Publisher :currency_code :operating_unit :org_name :p_conc_request_id :p_org_id :p_process_phase :p_process_type :p_request_id :p_set_of_books_id :set_of_books_name 1 10 :p_set_of_books_id Number select fnd_profile.value('GL_SET_OF_BKS_ID') from dual Y F ID livre US Ledger Id 2 20 :p_org_id Number select fnd_profile.value('ORG_ID') from dual Y F ID organisation US Organization Id 3 30 :p_process_phase LOV Oracle IGC_PROCESS_PHASE Y select lookup_code id, meaning value, null description from fnd_lookup_values where lookup_type='IGC_CC_PROCESS_PHASE' and language=userenv ('LANG') order by value,description Y F Phase du traitement US Process Phase 4 40 :p_process_type Char Y F Type de traitement US Process Type 5 50 :p_request_id Number Y F ID traitement US Request Id