GM_PCL_HDR_LVW

(SQL View)
 Index Back

Protocol Header View

Protocol Header View which have at least one Version in APPROVED, DRAFT, RETURN AND PENDING Status

SELECT DISTINCT H.BUSINESS_UNIT , H.PCL_ID , L.LANGUAGE_CD , L.DESCR20A FROM PS_GM_PCL_HDR H , PS_GM_PCL_VRSN V ,PS_GM_PCL_HDR_LNG L WHERE H.BUSINESS_UNIT = V.BUSINESS_UNIT AND H.PCL_ID = V.PCL_ID AND V.PCL_STATUS IN ('DRFT', 'APPR', 'RETD', 'PEND') AND %Join(COMMON_KEYS, GM_PCL_HDR H, GM_PCL_HDR_LNG L)

  • Related Language Record for GM_PCL_HDR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT

    Prompt Table: SP_BU_PC_NONVW

    2 PCL_ID Character(15) VARCHAR2(15) NOT NULL PCL_ID

    Default Value: NEXT

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR20A Character(20) VARCHAR2(20) NOT NULL Short Description