[Home] [Help]
View: IGI_EXP_WKF_STEP_V
Product: | IGI - Public Sector Financials International |
Description: | Displays individual workflow step setup information. |
Implementation/DBA Data: |
APPS.IGI_EXP_WKF_STEP_V
|
View Text
SELECT E.ROWID ROW_ID
, J.NAME POSITION_TYPE
, P.NAME POSITION_STRUCTURE_NAME
, E.POSITION_STRUCTURE_ID
, P.JOB_ID
, E.WKF_ID
, E.STEP_NO
, E.FLOW_ID
, E.CREATION_DATE
, E.CREATED_BY
, E.LAST_UPDATE_LOGIN
, E.LAST_UPDATE_DATE
, E.LAST_UPDATED_BY
, FFV.DESCRIPTION JOB_TYPE
FROM HR.PER_JOBS J
, IGI_EXP_POS_STRUCTURES P
, HR.PER_POS_STRUCTURE_VERSIONS V
, IGI_EXP_WKF_STEP E
, APPS.FND_FLEX_VALUE_SETS FFVS
, APPS.FND_FLEX_VALUES_VL FFV
WHERE E.POSITION_STRUCTURE_ID = P.POSITION_STRUCTURE_ID
AND P.JOB_ID = J.JOB_ID
AND P.POSITION_STRUCTURE_ID = V.POSITION_STRUCTURE_ID (+)
AND FFVS.FLEX_VALUE_SET_NAME = 'IGI_EXP_JOBS'
AND FFVS.FLEX_VALUE_SET_ID = FFV.FLEX_VALUE_SET_ID
AND SUBSTR( J.NAME
, 1
, LENGTH(FFV.FLEX_VALUE) ) = FFV.FLEX_VALUE
Columns
Name |
ROW_ID |
POSITION_TYPE |
POSITION_STRUCTURE_NAME |
POSITION_STRUCTURE_ID |
JOB_ID |
WKF_ID |
STEP_NO |
FLOW_ID |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
JOB_TYPE |