Select all views of a procedure step that provide data in a dialog flow, their destination views in the flowed-to procedure step, and the associated entity types.
SELECT ... FROM ... DIALOG_FLOW DLG, DLG_DATA_SENT DDS, BUS_PROC_STEP PSF, - from procedure step VIEW_SET VSF, - from view set ENTITY_VIEW EVF, - from entity view ENTITY_TYPE ETF, - from entity type BUS_PROC_STEP PST, - to procedure step VIEW_SET VST, - to view set ENTITY_VIEW EVT, - to entity view ENTITY_TYPE ETT, - to entity type WHERE ... AND DDS.DIALOG_FLOW_ID = DLG.ID AND EVF.ID = DDS.SRC_DATA_VIEW_ID AND ETF.ID = EVF.ENTITY_ID AND VSF.ID = EVF.VIEW_SET_ID AND PSF.ID = VSF.ACTIVITY_ID AND EVT.ID = DDS.DST_DATA_VIEW_ID AND ETT.ID = EVT.ENTITY_ID AND VST.ID = EVT.VIEW_SET_ID AND PST.ID = VST.ACTIVITY_ID; LNK_DATA_RTND (Link Data Returned)
The Link Data Returned table represents the data that is returned from a linked-to procedure step when it returns to a linked-from procedure step. It is identified by the dialog flow and identifies the source of the data returned (in an export view of the linked-to procedure step that is returning) and the destination of the data returned (in an import view of the linked-from procedure step). It is created in the Dialog Flow Diagram, when you select a dialog flow line representing a link, Detail, and Data Returned.
|
Copyright © 2013 CA.
All rights reserved.
|
|