View: IGI_EXP_POSITION_ACTION_V

Product:	IGI - Public Sector Financials International
Description:	Displays details of approval privileges for individual position identifiers.
Implementation/DBA Data:	APPS.IGI_EXP_POSITION_ACTION_V

View Text

SELECT DISTINCT JE.ROWID ROW_ID
, POS.NAME POSITION_NAME
, JE.POSITION_STRUCTURE_ID
, JE.CREATE_DOC
, JE.APPROVE
, JE.REJECT
, JE.HOLD
, JE.PEC
, JE.REQUISITION
, JE.POSITION_ID
, JE.WKF_ID
, JE.FLOW_ID
, JE.STEP_NO
, JE.CREATION_DATE
, JE.CREATED_BY
, JE.LAST_UPDATE_LOGIN
, JE.LAST_UPDATE_DATE
, JE.LAST_UPDATED_BY
FROM PER_ALL_POSITIONS POS
, IGI_EXP_POSITION_ACTION JE
, IGI_EXP_WKF_STEP ST
WHERE JE.POSITION_ID = POS.POSITION_ID
AND JE.POSITION_STRUCTURE_ID = ST.POSITION_STRUCTURE_ID
AND JE.WKF_ID = ST.WKF_ID
AND JE.FLOW_ID = ST.FLOW_ID
AND JE.STEP_NO = ST.STEP_NO

Columns