RO_BPSTAT_L_VW

(SQL View)
 Index Back

BP Status Description Lang

BP Status Description related language view

SELECT A.BUS_PROC_INSTANCE , B.LANGUAGE_CD , A.RC_BUS_PROCESS_ID , B.DESCR , C.XLATLONGNAME FROM %Table(RC_BP_STATUS) A , %Table(RC_BUS_PROC_LNG) B , %Table(PSXLATITEMLANG) C WHERE A.RC_BUS_PROCESS_ID=B.RC_BUS_PROCESS_ID AND %EffdtCheck(RC_BUS_PROCESS, B, %currentdatein) AND C.FIELDNAME='BUS_PROCESS_STATUS' AND A.BUS_PROCESS_STATUS = C.FIELDVALUE AND %EffdtCheck(PSXLATITEM, C, %currentdatein) AND B.LANGUAGE_CD =C.LANGUAGE_CD

  • Related Language Record for RO_BPSTATDSC_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUS_PROC_INSTANCE Number(18,0) DECIMAL(18) NOT NULL Business Project Instance. This is the Business Project instance of a business project.
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 RC_BUS_PROCESS_ID Character(15) VARCHAR2(15) NOT NULL Business Process ID used in Business Process tracking.
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name