IGC Contract Commitment Archive Purge - draft

Description
Categories: BI Publisher
Columns: Vendor Name, Cc Header Id, Cc Num, Cc Type, Cc Desc, Cc Preparer User Id, Preparer, Cc Owner User Id, Owner, Creation Date ...
Application: Contract Commitment
Source: Contract Commitment Archive Purge Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGCCAPRR_XML
DB package: IGC_IGCCAPRR_XMLP_PKG
select
     ven.vendor_name,
     hist.cc_header_id,
     hist.cc_num,
     fnd1.meaning cc_type,
     head.cc_desc,
     head.cc_preparer_user_id,
     usr1.user_name preparer,
     head.cc_owner_user_id,
     usr2.user_name owner,
     to_char(head.creation_date,'DD-MON-YY') creation_date,
     head.currency_code,
     sum(acct.cc_acct_entered_amt) amount,
     to_char(hist.last_cc_activity_date,'DD-MON-YY') last_cc_activity_date
from igc_c