IGC Contract Commitment Open Interface Exception - draft

Description
Categories: BI Publisher, Financials
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
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
Parameter Name SQL text Validation
Organization Id
 
Number
Ledger Id
 
Number
Ask a question