EP_J_CAT_T_SB_I

(SQL View)
 Index Back

Catalog Types: Sub-Items

ePerformance specific interface view for the JPM Catalog Type interface view. This view is used to only return valid Sub-Item Catalog Types (doesn't include Item catalog types).

SELECT A.JPM_CAT_TYPE2 , A.JPM_CAT_TYPE , B.DESCR FROM PS_JPM_CAT_T_RLAT A , PS_JPM_CAT_TYPES B WHERE A.JPM_CAT_TYPE = B.JPM_CAT_TYPE AND A.JPM_CAT_RLAT_CD = 'C'

  • Related Language Record: EP_J_CATSB_LN_V

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EP_J_ITEM_CAT_TYPE Character(12) VARCHAR2(12) NOT NULL ePerformance specific version of the JPM Catalog Type field.
    2 EP_J_SUB_CAT_TYPE Character(12) VARCHAR2(12) NOT NULL ePerformance specific version of the JPM Catalog Type field.
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description