SPB_CATEG_CD_VW

(SQL View)
 Index Back

Category View

20/04/10 ANU 11640793 We Ensured that Inactive item categor ies are not selectable within Bid Factors by Category page.

SELECT A.SETID , A.CATEGORY_CD , A.DESCR60 FROM PS_ITM_CAT_TBL A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_ITM_CAT_TBL 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.EFF_STATUS = 'A' AND A.CATEGORY_TYPE = ( SELECT CATEGORY_TYPE FROM PS_INSTALLATION_PO)

  • Related Language Record: SPB_CATCD_LG_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

    Prompt Table: SETID_TBL

    2 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code

    Prompt Table: SPB_CATEG_CD_VW
    Set Control Field: SETID

    3 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description