JL Brazilian Payables Import Bank Collection Documents - draft

Description
Categories: BI Publisher
Columns: File Control, Description, Total Registry, Total Amount, Total Validated Registry, Total Validated Amount ...
Application: Latin America Localizations
Source: Brazilian Payables Import Bank Collection Documents Report (XML) - Not Supported: Reserved For Future Use
Short Name: JLBRPICR_XML
DB package: JL_JLBRPICR_XMLP_PKG
select 	tmp.file_control file_control,
		 i.description,tmp.total_registry,tmp.total_amount,tmp.total_validated_registry,tmp.total_validated_amount
from	jl_br_ap_int_collection_tmp tmp, FND_LOOKUPS i
where	tmp.file_control = :p_file_control and
	(i.lookup_type = 'JLBR_COLLECT_IMPORT_ERROR'  and  
	i.lookup_code = tmp.error_code)
Parameter Name SQL text Validation
File Control
 
LOV Oracle
SOB
 
Number