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
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