OIM

QUERY to get the INPUT VALUES

SELECT
mil.mil_name,MIl.Mil_kEY,
ADJ.ADJ_METHOD,ADJ.ADJ_Constructor,ADJ.ADJ_METHOD_DISPLAY,adj.adj_jar_file,
ADT.ADT_NAME,ADT.ADT_TYPE,
adp.adp_name,adp.adp_description,
evt.evt_name,
mil.mil_name
,adv.adv_name,adv.adv_desc,adv.adv_data_type,adv.adv_map_value
,adm.adm_display_value,adm.adm_map_value
,atp.atp_in_out_flag,atp.atp_type
from ADJ,ADT,ADP,evt,mil
--,ars
,adV,adm,atp
where ADJ.ADT_KEY = ADT.ADT_KEY
AND ADT.ADP_KEY = ADP.ADP_KEY
AND adp.evt_key = evt.evt_key
and evt.evt_key= mil.evt_key
---check process
--and adp.adp_key = ars.adP_Key
AND ADP.ADP_KEY = ADv.ADP_KEY
And ADT.ADT_KEY = atp.ADT_KEY
and atp.atp_key=adm.atp_key
And atp.atp_in_out_flag = 'Input'
and mil.mil_name  in ('System Validation') order by mil.mil_name