|
SELECT ASG.BUSINESS_UNIT , ORD.PROJECT_ID , ASG.ACTIVITY_ID , B.FIELDNAME , D.DESCR , B.FO_EDIT_MASK FROM PS_FO_ASGN_CSF_DTL D ,PS_FO_CSF_FIELD B ,PS_RS_ASSIGNMENT ASG ,PS_RS_SO_HDR ORD WHERE ASG.ASSIGNMENT_ID = D.ASSIGNMENT_ID AND D.FO_CSF_ID = B.FO_CSF_ID AND D.FO_CSF_DESCR = B.FO_CSF_DESCR AND D.EFFDT = ( SELECT MAX(DD.EFFDT) FROM PS_FO_ASGN_CSF_DTL DD WHERE D.ASSIGNMENT_ID = DD.ASSIGNMENT_ID AND D.FO_CSF_ID = DD.FO_CSF_ID AND D.FO_CSF_DESCR = DD.FO_CSF_DESCR AND DD.EFFDT <= %CurrentDateIn) AND B.EFFDT = ( SELECT MAX(BB.EFFDT) FROM PS_FO_CSF_FIELD BB WHERE B.FO_CSF_ID = BB.FO_CSF_ID AND B.FO_CSF_DESCR = BB.FO_CSF_DESCR AND BB.EFFDT <= %CurrentDateIn) AND ORD.BUSINESS_UNIT = ASG.BUSINESS_UNIT AND ORD.SO_ID = ASG.SO_ID
|