PTPPB_CATG_LVW

(SQL View)
Index Back

Pagelet Category Prompt View


SELECT A.PTPPB_PGLT_CATG_ID , B.LANGUAGE_CD , B.DESCR FROM PS_PTPPB_PGLT_CATG A , PS_PTPPB_PGLT_CLNG B WHERE A.PTPPB_PGLT_CATG_ID = B.PTPPB_PGLT_CATG_ID AND A.ACTIVE_FLAG = 'A'

  • Related Language Record for PTPPB_CATG_PVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTPPB_PGLT_CATG_ID Character(30) VARCHAR2(30) NOT NULL Category ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description