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
SQL 23 lines
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 |
Parameters 4
| Parameter | Type | List of values SQL |
|---|---|---|
| Ledger Name | LOV Oracle | |
| Charge Center | LOV Oracle | |
| Start Period | LOV Oracle | |
| End Period | LOV Oracle |