VIEW: APPS.IGI_EXP_POSITION_ACTION_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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