JL Brazilian Payables Import Bank Collection Documents Report- Not Supported: Reserved For Future Use

➜ Back to Library
XMLXML import file

Description

Categories
BI Publisher
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
Imported from BI Publisher
Brazilian Payables Import Bank Collection Documents Report

SQL 7 lines

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)

Parameters 2

ParameterTypeList of values SQL
Operating UnitLOV
File ControlLOV Oracle