IGI Internal Trading: Internal Charge Status - draft
Description
Categories: BI Publisher
Application: Public Sector Financials International
Source: Internal Trading: Internal Charge Status Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGIGITSR_XML
DB package: IGI_IGIGITSR_XMLP_PKG
Source: Internal Trading: Internal Charge Status Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGIGITSR_XML
DB package: IGI_IGIGITSR_XMLP_PKG
Run
IGI Internal Trading: Internal Charge Status - draft and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT icl.it_header_id line_header_id , icl.it_line_num , nvl(icl.entered_dr,0) charge_amount , nvl(icl.entered_cr,0) payment_amount , iis.name service_type , iic.name rcv_charge_center , il.meaning, IGI_IGIGITSR_XMLP_PKG.CF_DATA_FOUNDFORMULA(icl.it_line_num) CF_DATA_FOUND FROM igi_itr_charge_lines icl , igi_lookups il , igi_itr_charge_center iic , igi_itr_charge_service ics , igi_itr_service iis WHERE icl.set_of_books_id = :P_SET_OF_BOOKS_ID AND icl.charge_center_id = iic.charge_center_id AND il.lookup_type = 'ITR_SERVICE_STATUS' AND icl.status_flag = il.lookup_code AND icl.charge_service_id = ics.charge_service_id AND ics.service_id = iis.service_id and icl.it_header_id=:it_header_id ORDER BY icl.it_header_id , icl.it_line_num |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Ledger Name |
|
LOV Oracle | |
Charge Center |
|
LOV Oracle | |
Start Period |
|
LOV Oracle | |
End Period |
|
LOV Oracle |