IGC Contract Commitment Complete Cover Commitment Exception Report- Not Supported: Reserved For Future Use

Description

Imported from BI Publisher
Description: Contract Commitment Complete Cover Commitment Exception Report
Application: Contract Commitment
Source: Contract Commitment Complete Cover Commitment Exception Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGCCCOVR_XML
DB package: IGC_IGCCYRPR_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Copy

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(+)