IGC Contract Commitment Mass Payment Forecast Shift Exception - draft

Description
Categories: BI Publisher, Financials
Application: Contract Commitment
Source: Contract Commitment Mass Payment Forecast Shift Exception Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGCCMPPR_XML
DB package: IGC_IGCCYRPR_XMLP_PKG
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(+)
Parameter Name SQL text Validation
Organization Id
 
Number
Ledger Id
 
Number
Ask a question