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

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

Contact us to schedule a demo or if you need help with the installation

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
Ledger Id
 
Number
Organization Id
 
Number
Process Phase
 
LOV Oracle
Process Type
 
Char
Request Id
 
Number