IGC Contract Commitment Revaluation Fix Exception - draft
Description
- Categories
- BI Publisher
- 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
SQL 21 lines
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(+) |
Parameters 5
| Parameter | Type | List of values SQL |
|---|---|---|
| Ledger Id | Number | |
| Organization Id | Number | |
| Process Phase | LOV Oracle | |
| Process Type | Char | |
| Request Id | Number |