DBA Data[Home] [Help]

APPS.CS_KB_SOLN_IN_PROGRESS_PKG dependencies on CS_KB_SETS_VL

Line 17: FROM CS_KB_SETS_VL Soln,

13:
14: CURSOR GET_IN_PROGRESS_SOLUTIONS IS
15: SELECT Soln.Set_id, Soln.Set_Number, Soln.Locked_By, Soln.FLow_Details_Id, Soln.Name,
16: FlowDetail.Group_id
17: FROM CS_KB_SETS_VL Soln,
18: CS_KB_WF_FLOW_DETAILS FlowDetail
19: WHERE Soln.STATUS IN ('SAV','NOT','REJ')
20: AND Soln.LATEST_VERSION_FLAG = 'Y'
21: AND Soln.Flow_Details_id = FlowDetail.Flow_Details_Id (+)