1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
<dataTemplate name="XX_VAL" description="Sis" version="1.0">
- <parameters>
<parameter name="id" dataType="number" />
<parameter name="p_date_ref" dataType="date" />
</parameters>
- <dataQuery>
- <sqlStatement name="exi0">
- <![CDATA[
select CODE, ATT SIEGE, to_char(systimestamp,'dd/mm/yyyy HH:MI:SSAM') DATE_IMP
from apps.mtl_parameters
where ORGANIZATION_ID = :p_ol_id
]]>
</sqlStatement>
- <sqlStatement name="exi1">
- <![CDATA[
select distinct mi.segment1||'.'||mi.segment2 Cop
,xx_get_val_enc(:id, :p_date_ref, 'M-B', '02', mi.segment1, mi.segment2,'000') NEUF
,, |
Partager