PC_PIVOT_LNG_VW

(SQL View)
 Index Back

Language view for Pivot Views

Language view for Pivot Views

SELECT A.OPRID , A.BUSINESS_UNIT , A.PROJECT_ID , B.CONTRACT_NUM , B.LANGUAGE_CD , C.DESCR , B.NAME1 FROM PS_PC_OPRID_PRJACT A , PS_PC_CON_CUST_LVW B , PS_PC_LOC_LNG_VW C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.PROJECT_ID = C.PROJECT_ID AND B.LANGUAGE_CD = C.LANGUAGE_CD UNION SELECT A.OPRID , A.BUSINESS_UNIT , A.PROJECT_ID , B.CONTRACT_NUM , C.LANGUAGE_CD , C.DESCR , B.NAME1 FROM PS_PC_OPRID_PRJACT A , PS_PC_CON_CUST_VW B , PS_PC_LOC_LNG_VW C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.PROJECT_ID = C.PROJECT_ID AND NOT EXISTS ( SELECT 'X' FROM PS_PC_CON_CUST_LVW D WHERE D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.PROJECT_ID = A.PROJECT_ID AND D.CONTRACT_NUM = B.CONTRACT_NUM AND D.LANGUAGE_CD = C.LANGUAGE_CD) UNION SELECT A.OPRID , A.BUSINESS_UNIT , A.PROJECT_ID , B.CONTRACT_NUM , B.LANGUAGE_CD , C.DESCR , B.NAME1 FROM PS_PC_OPRID_PRJACT A , PS_PC_CON_CUST_LVW B , PS_PC_PROJ_LOC_VW C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.PROJECT_ID = C.PROJECT_ID AND NOT EXISTS ( SELECT 'X' FROM PS_PC_LOC_LNG_VW D WHERE D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.PROJECT_ID = A.PROJECT_ID AND D.LANGUAGE_CD = B.LANGUAGE_CD)

  • Related Language Record for PC_PIV_BDACT_VW PC_PIV_FNSUM_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    4 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 PC_LOCATION_DESCR Character(30) VARCHAR2(30) NOT NULL Project Location Description
    7 PC_CUST_NAME Character(40) VARCHAR2(40) NOT NULL Project Customer Name