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