SELECT MGRPOS.PR_EMP_ID FROM
&TABLE_OWNER.S_POSTN POS, &TABLE_OWNER.S_EMPLOYEE EMP, &TABLE_OWNER.S_POSTN MGRPOS, &TABLE_OWNER.S_SRV_REQ SR
SR.ROW_ID = ?
SR.OWNER_EMP_ID = EMP.ROW_ID
EMP.PR_POSTN_ID = POS.ROW_ID
POS.PAR_POSTN_ID = MGRPOS.ROW_ID
SR.ROW_ID = ? uses a question mark as a placeholder for inputting the value of the Primary ID. The system knows to substitute the Primary ID for the question mark.
This SQL statement joins four tables, giving access to data from all of them. In this example, only one field is retrieved.
Policy Monitor requires the definitions contained in the workflow policy object, workflow policy components, and workflow policy columns. In working and coding workflow policy action programs using the Siebel tables, explicit joining of the base table through SQL code is required.