SUP_CAT_TREELNG

(SQL View)
 Index Back

Categorization Descr

/*05/04/2017 PRJ25828287 Created language record for SUP_CAT_TREEVW */

SELECT A.SETID , A.BIDDER_ID , A.BIDDER_TYPE , A.BRANCH_ID , A.CATEGORY_CD , B.TREE_ID , B.TREE_SETID ,(NVL(HDR.LANGUAGE_CD ,ITM.LANGUAGE_CD)) ,(NVL(HDR.DESCR60 ,ITM.DESCR60)) FROM PS_AUC_BID_SLF_CAT A LEFT OUTER JOIN ( SELECT D.BIDDER_ID , E.TREE_ID , E. TREE_SETID FROM PS_SUP_OB_REG_TEMP E , PS_SUP_OB_REG_DEF D WHERE D.SUP_OB_TEMPLATE_ID = E.SUP_OB_TEMPLATE_ID AND D.SUPOB_REG_OPT_TYPE = E.SUPOB_REG_OPT_TYPE) B ON A.BIDDER_ID = B.BIDDER_ID LEFT OUTER JOIN ( SELECT ENG.SETID , ENG.TREE_ID , ENG.BRANCH_ID , ENG.CATEGORY_CD ,LNG.LANGUAGE_CD , LNG.DESCR60 FROM PS_AUC_CATEGRY_HDR ENG , PS_AUC_CAT_HDR_LNG LNG WHERE ENG.CATEGORY_CD = LNG.CATEGORY_CD AND ENG.DESCR60 = LNG.DESCR60)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 ,LANGUAGE_CD , DESCR60 FROM PS_ITM_CAT_TBL_LNG )ITM ON ITM.CATEGORY_CD = A.CATEGORY_CD AND ITM.SETID = B.TREE_SETID

  • Related Language Record for SUP_CAT_TREEVW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    9 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description