USG_LOCATION_VW

(SQL View)
 Index Back

Consumer Usage - Consumer Prom

Consumer Usage Maintenance - Consumer Prompt Table

SELECT DISTINCT A.BUSINESS_UNIT , A.LOCATION , B.DESCR FROM PS_USAGE_INV A , PS_LOCATION_TBL B WHERE B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_LOCATION_TBL C WHERE C.SETID = ( SELECT D.SETID FROM PS_SET_CNTRL_REC D WHERE D.SETCNTRLVALUE = A.BUSINESS_UNIT AND D.RECNAME = 'LOCATION_TBL' ) AND C.LOCATION = B.LOCATION AND C.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' AND A.LOCATION = B.LOCATION

  • Related Language Record: USG_LOC_LNG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description