GM_PCL_APP_SRCH

(SQL View)
 Index Back

Protocol Approver Search VW


SELECT H.BUSINESS_UNIT , H.PCL_ID , V.PCL_VRSN_ID , H.PCL_TYPE , V.PCL_STATUS , V.DESCR FROM PS_GM_PCL_HDR H , PS_GM_PCL_VRSN V , PS_GM_PCL_APPROVE A WHERE H.BUSINESS_UNIT = V.BUSINESS_UNIT AND H.PCL_ID = V.PCL_ID AND A.BUSINESS_UNIT = V.BUSINESS_UNIT AND A.PCL_ID = V.PCL_ID AND A.PCL_VRSN_ID = V.PCL_VRSN_ID AND V.REV_TYPE_ADMIN <>'F'

  • Related Language Record: GM_PCL_APP_SR_L

    • # 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

    Prompt Table: GM_PCL_HDR

    3 PCL_VRSN_ID Character(7) VARCHAR2(7) NOT NULL PCL_VRSN_ID
    4 PCL_TYPE Character(10) VARCHAR2(10) NOT NULL Protocol Type

    Prompt Table: GM_PCL_TYPE

    5 PCL_STATUS Character(4) VARCHAR2(4) NOT NULL PCL_STATUS
    APPR=Approved
    DEND=Denied
    DRFT=Draft
    EXPD=Expired
    INAC=Inactive
    PEND=Pending
    RETD=Returned
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description