5 queries found for "Outbound Message"

Get all from Outbound Message

select * 
from F1_OUTMSG

uploaded by Nuno Rodrigues

Get specific Outbound Message

select * 
from F1_OUTMSG
where 
OUTMSG_ID = 'XXXX'

uploaded by Nuno Rodrigues

Outbound message

Select /*+ NO_INDEX (F1_OUTMSG,FT010S1) */  
from f1_outmsg
where cre_dttm > to_date('20150812 00:00','YYYYMMDD HH24:MI')    /*your date*/
 and  outmsg_type_cd  ='CM-MSGTYPE'  /*your message type*/
 and OUTMSG_STATUS_FLG='C'   /*your message status*/
  and (xml_source like '%01231231231232%' ) /*a reference, for instance task id*/
order by cre_dttm desc  

uploaded by Fernando Lopez Bello

Get all from Outbound Messages

--Details about Outbound messages
SELECT * FROM F1_OUTMSG

uploaded by Venkata Sai Bhargav Kakunuri

Finding outbound messages based on External Source

--Finding outbound messages based on External Source 
SELECT * FROM F1_OUTMSG WHERE NT_XID_CD='EXTERNAL_SOURCE_CODE'

uploaded by Venkata Sai Bhargav Kakunuri