RO_BP_BPEL_LVW

(SQL View)
 Index Back

Language Prompt View

Language Prompt view for getting the Business Projects and BPEL Processes

SELECT A.RC_BUS_PROCESS_ID , F.LANGUAGE_CD , F.DESCR FROM PS_RC_BUS_PROCESS A , PS_RC_BUS_PROC_LNG F WHERE A.RC_BUS_PROCESS_ID = F.RC_BUS_PROCESS_ID AND A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_RC_BUS_PROCESS A_ED WHERE A.RC_BUS_PROCESS_ID = A_ED.RC_BUS_PROCESS_ID AND A_ED.EFFDT <= %CurrentDateIn ) AND A.EFF_STATUS <> 'I' AND A.RC_VALIDATE = 'Y' AND A.BUS_PROJ_TYPE='M' UNION SELECT A.IB_OPERATIONNAME , E.LANGUAGE_CD , E.DESCR FROM PSOPERATION A , PSOPRVERDFN B , PSIBRTNGDEFN C , PSNODEPROP D , PSOPERATIONLANG E WHERE A.IB_OPERATIONNAME = B.IB_OPERATIONNAME AND A.IB_OPERATIONNAME = C.IB_OPERATIONNAME AND A.IB_OPERATIONNAME = E.IB_OPERATIONNAME AND B.ACTIVE_FLAG = 'A' AND C.RECEIVERNODENAME = D.MSGNODENAME AND D.PROPNAME = 'BPELCONSOLEURL' AND %EffdtCheck(PSIBRTNGDEFN, C, %CurrentDateIn) AND C.EFF_STATUS = 'A'

  • Related Language Record for RO_BP_BPEL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUS_PROCESS_ID Character(100) VARCHAR2(100) NOT NULL Business Process Name to be used for Business Project as well as BPEL process name
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description