VIEW: APPS.IGI_EXP_WKF_ASSIGN_V

Source

View Text - Preformatted

SELECT a.rowid row_id , a.doc_type_id document_id , d.description document_type , a.wkf_id , e.wkf_name , a.creation_date , a.created_by , a.last_update_login , a.last_updated_by , a.last_update_date FROM IGI_EXP_WKF_PROFILE E,IGI_EXP_DOC_TYPE D,IGI_EXP_WKF_ASSIGN A WHERE a.wkf_id = e.wkf_id AND a.doc_type_id=d.doc_type_id

View Text - HTML Formatted

SELECT A.ROWID ROW_ID
, A.DOC_TYPE_ID DOCUMENT_ID
, D.DESCRIPTION DOCUMENT_TYPE
, A.WKF_ID
, E.WKF_NAME
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
FROM IGI_EXP_WKF_PROFILE E
, IGI_EXP_DOC_TYPE D
, IGI_EXP_WKF_ASSIGN A
WHERE A.WKF_ID = E.WKF_ID
AND A.DOC_TYPE_ID=D.DOC_TYPE_ID