BIAPPS - INFORMATICA - Query per estrarre l'associativa Workflow / Mapping di Informatica

 Di seguito una query per poter associare i workflow ai mapping eseguiti in Informatica.

Tutto internamente ad Informatica:

-------------------------------------------------------------------

--- QUERY ESTRAZIONE associativa WF_MAPPING in INFORMATICA      ---

--- Da eseguire come utente sys sul database che contiene il repository di INFORMATICA   ---

-------------------------------------------------------------------

SELECT distinct 

        SUB.SUBJ_NAME subject_area_info ,

        WF.WORKFLOW_NAME, opb_task.TASK_NAME task_name_info,     

        OPB_TASK_INST.INSTANCE_NAME ,MAP.MAPPING_NAME

        ,MAP.MAPPING_ID, opb_task.IS_VALID,    opb_task.IS_ENABLED,

        OPB_OBJECT_TYPE.OBJECT_TYPE_NAME TASK_TYPE_NAME

    FROM

        INFA.OPB_TASK_INST, 

        INFA.OPB_OBJECT_TYPE, 

        INFA.OPB_TASK, 

        INFA.REP_WORKFLOWS WF,

        INFA.OPB_SUBJECT SUB,

        INFA.OPB_SESSION SESS, 

        INFA.OPB_MAPPING map

    WHERE

        OPB_TASK_INST.TASK_TYPE = OPB_OBJECT_TYPE.OBJECT_TYPE_ID

        AND OPB_TASK_INST.WORKFLOW_ID = OPB_TASK.TASK_ID

        AND OPB_TASK_INST.VERSION_NUMBER = OPB_TASK.VERSION_NUMBER

        AND OPB_TASK.IS_VISIBLE = 1

        AND WF.WORKFLOW_ID=OPB_TASK_INST.WORKFLOW_ID 

        AND WF.SUBJECT_ID=SUB.SUBJ_ID 

        AND OPB_TASK.SUBJECT_ID=SUB.SUBJ_ID

        AND SUB.SUBJ_ID=WF.SUBJECT_ID 

        AND OPB_TASK_INST.TASK_ID=SESS.SESSION_ID 

        AND MAP.MAPPING_ID=SESS.MAPPING_ID

        AND MAP.SUBJECT_ID=WF.SUBJECT_ID

        AND MAP.IS_VALID=1