EOEP_APPCDPL_VW

(SQL View)
 Index Back

Pricing Appl Code (root/pl)

Pricing Application Codes that have no parent and has price list field list.

SELECT eoep_app_cd , descr , eoep_parent_app FROM ps_eoep_app_code WHERE eoep_parent_app = ' ' AND eoep_app_cd IN ( SELECT DISTINCT eoep_app_cd FROM PS_EOEP_APPLST_FLD)

  • Related Language Record: EOEP_APPCD_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOEP_APP_CD Character(4) VARCHAR2(4) NOT NULL Transaction Code

    Prompt Table: EOEP_APPCD_VW

    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 EOEP_PARENT_APP Character(4) VARCHAR2(4) NOT NULL Parent Application Code

    Prompt Table: EOEP_APPCD_VW