RF_IPRD_LOC_VW

(SQL View)
Index Back

Installed Product Location

This is a prompt view for installed products by Location

SELECT DISTINCT B.SETID , B.LOCATION , A.DESCR FROM PS_LOCATION_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 = 'LOCATION_TBL' AND B.SETID = R.SETCNTRLVALUE) AND B.LOCATION = A.LOCATION AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_LOCATION_TBL B WHERE B.EFFDT <= %CurrentDateIn AND A.SETID = B.SETID AND A.LOCATION = B.LOCATION) AND A.EFF_STATUS = 'A'

  • Related Language Record: RF_IPRD_LOC_LVW
  • # 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 LOCATION Character(15) VARCHAR2(15) NOT NULL This field stores the Location Code.
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description