[Home] [Help]
View: IGI_EXP_WKF_ASSIGN_V
Product: | IGI - Public Sector Financials International |
Description: | Displays document types assigned to a workflow. |
Implementation/DBA Data: |
APPS.IGI_EXP_WKF_ASSIGN_V
|
View Text
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
Columns
Name |
ROW_ID |
DOCUMENT_ID |
DOCUMENT_TYPE |
WKF_ID |
WKF_NAME |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |