IGI Internal Trading: Internal Charge Status - draft

➜ Back to Library
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
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
Download
Related Blitz Reports
IGI Standing Charges: Transaction History Report- Not Supported: Reserved For Future Use IGI Standing Charges: Listing- Not Supported: Reserved For Future Use IGI Standing Charges: Charge Item Price History- Not Supported: Reserved For Future Use IGI Standing Charges: Preliminary Invoice Register- Not Supported: Reserved For Future Use IGI Standing Charges: Item Price History Report- Not Supported: Reserved For Future Use IGI Standing Charges: Transaction Report- Not Supported: Reserved For Future Use AP 1099 Payments Report- Not Supported: Reserved For Future Use IGI Unbalanced Budget Journal Report- Not Supported: Reserved For Future Use IGI CIS2007 Monthly Returns
Blitz Report™

Blitz Report™ provides multiple benefits: