Seibel Query help : - Joining Order table with Asset or CX_ACTION table.
945284Apr 18 2013 — edited Apr 18 2013Hi Team
I need help joining the Order table with the Asset table
or the Order table with CX_ACTION table to
Can i get reference on this .
select x.x_msisdn,
x.x_product_name,
x.x_action,
x.x_status_outcome,
a.recovered_dt,
x.x_amount,
x.created,
x.x_number_retries,
o.ORDER_NUM "FMW Order No",
DECODE(FULFLMNT_STATUS_CD , 'Failed','Failed', o.STATUS_CD) "Order Status"
from
siebel.cx_action x,
siebel.s_order o,
siebel.s_asset a
where a.row_id = x.x_asset_id
and x.created > to_date('08/01/2013 08:00:00', 'dd/mm/yyyy hh24:mi:ss')
and x.created < to_date('09/04/2013 07:50:00', 'dd/mm/yyyy hh24:mi:ss')
Regards