IGC Contract Commitment Open Interface Exception Report- Not Supported: Reserved For Future Use
Description
- Categories
- BI Publisher
- Application
- Contract Commitment
- Source
- Contract Commitment Open Interface Exception Report (XML) - Not Supported: Reserved For Future Use
- Short Name
- IGCCLDER_XML
- DB package
- IGC_IGCCLDER_XMLP_PKG
Imported from BI Publisher
Contract Commitment Open Interface Exception Report
Contract Commitment Open Interface Exception Report
SQL 19 lines
select ige.interface_header_id "Interface Header ID" , ige.interface_acct_line_id "Interface Account Line ID" , ige.interface_det_pf_line_id "Payment Forecast ID" , igh.cc_num "Contract Number" , iga.cc_acct_line_num "Account Line Number" , igf.cc_det_pf_line_num "Forecast Line Number" , ige.error_message "Error Message" from igc_cc_interface_errors ige , igc_cc_headers_interface igh , igc_cc_acct_lines_interface iga , igc_cc_det_pf_interface igf where ige.batch_id = :P_batch_id and ige.interface_header_id = igh.interface_header_id(+) and ige.interface_header_id = iga.interface_header_id(+) and ige.interface_acct_line_id = iga.interface_acct_line_id(+) and ige.interface_acct_line_id= igf.interface_acct_line_id(+) and ige.interface_det_pf_line_id = igf.interface_det_pf_line_id(+) order by ige.interface_header_id |
Parameters 1
| Parameter | Type | List of values SQL |
|---|---|---|
| Operating Unit | LOV |