RF_IPRD_DEPT_VW

(SQL View)
 Index Back

Installed Product Department

This is a prompt view for installed products by Department.

SELECT DISTINCT B.SETID , B.DEPTID , A.DESCR FROM PS_DEPT_TBL A , PS_RF_INST_PROD B WHERE B.INST_PROD_TYPE = '001' AND A.SETID = ( SELECT R.SETID FROM PS_SET_CNTRL_REC R WHERE R.RECNAME = 'DEPT_TBL' AND B.SETID = R.SETCNTRLVALUE) AND B.DEPTID = A.DEPTID AND A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_DEPT_TBL C WHERE C.EFFDT <= %CurrentDateIn AND A.SETID = C.SETID AND A.DEPTID = C.DEPTID) AND A.EFF_STATUS = 'A'

  • Related Language Record: RF_IPRD_DEPTLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_RB.SETID

    2 DEPTID Character(15) VARCHAR2(15) NOT NULL Department
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description