ITM_CAT_RQSTVLN

(SQL View)
 Index Back

Category Codes - RL

Related Language - Used as Category prompt table for requisitions when a requestor can only use specific catalogs.

SELECT DISTINCT A.SETID , C.REQUESTOR_ID , A.CATEGORY_TYPE , A.CATEGORY_CD , A.LANGUAGE_CD , A.DESCR60 FROM PS_ITM_CAT_TBL_LNG A , PSTREENODE B , PS_REQUESTOR_CAT C WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_ITM_CAT_TBL_LNG A1 WHERE A1.SETID = A.SETID AND A1.CATEGORY_TYPE = A.CATEGORY_TYPE AND A1.CATEGORY_ID = A.CATEGORY_ID AND A1.CATEGORY_CD = A.CATEGORY_CD AND A1.EFFDT <= %CurrentDateIn) AND A.SETID = B.SETID AND A.CATEGORY_CD = B.TREE_NODE AND B.SETID = C.SETID AND B.TREE_NAME = C.CATALOG_ID

  • Related Language Record for ITM_CAT_RQST_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    2 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id

    Default Value: REQ_HDR.REQUESTOR_ID

    3 CATEGORY_TYPE Character(3) VARCHAR2(3) NOT NULL Category Type
    PSF=User Def
    UNS=UN/SPSC

    Default Value: INSTALLATION_PO.CATEGORY_TYPE

    4 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description