SUP_CAT_TREVW2

(SQL View)
 Index Back

Categorization Descr

/*Created the view to get category description based on tree setid and Supplier ID*/

SELECT A.SETID , A.BIDDER_ID , A.BIDDER_TYPE , A.BRANCH_ID , A.CATEGORY_CD , B.TREE_ID , B.TREE_SETID ,(NVL(HDR.DESCR60 ,ITM.DESCR60)) FROM PS_AUC_BID_SLF_CAT A LEFT OUTER JOIN ( SELECT D.VENDOR_ID , D.TREE_ID , D.TREE_SETID ,D.BRANCH_ID ,D.CATEGORY_CD FROM PS_SUP_CATEGORY D ) B ON A.BIDDER_ID = B.VENDOR_ID AND A.BRANCH_ID = B.BRANCH_ID AND A.CATEGORY_CD = B.CATEGORY_CD LEFT OUTER JOIN ( SELECT SETID , TREE_ID , BRANCH_ID , CATEGORY_CD , DESCR60 FROM PS_AUC_CATEGRY_HDR )HDR ON HDR.SETID = B.TREE_SETID AND HDR.CATEGORY_CD = A.CATEGORY_CD AND HDR.TREE_ID = B.TREE_ID AND HDR.BRANCH_ID = A.BRANCH_ID LEFT OUTER JOIN ( SELECT DISTINCT SETID , CATEGORY_CD , DESCR60 FROM PS_ITM_CAT_TBL )ITM ON ITM.CATEGORY_CD = A.CATEGORY_CD AND ITM.SETID = B.TREE_SETID

  • Related Language Record: SUP_CAT_TRELNG2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
    3 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
    B=Bidder
    C=Customer
    P=Public
    U=Uploaded
    V=Supplier
    4 BRANCH_ID Character(10) VARCHAR2(10) NOT NULL The local branch office identifier associated with a given bank/counterparty.
    5 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code
    6 TREE_ID Character(36) VARCHAR2(36) NOT NULL Tree ID
    7 TREE_SETID Character(5) VARCHAR2(5) NOT NULL Tree SetID
    8 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description