SP_CAPCLN_CLSLW

(SQL View)
 Index Back

Lng rec for SP_CAPCLN_CLSVW


SELECT C.OPRCLASS ,A.CONTRACT_NUM ,A.CONTRACT_LINE_NUM , A.BUSINESS_UNIT_PC , A.PROJECT_ID , LNG.LANGUAGE_CD , LNG.DESCR FROM PS_CA_DETAIL_PROJ A , PS_PROJECT PRJ , PS_BUS_UNIT_TBL_FS B , PS_SEC_BU_CLS C , PS_PROJECT_LANG LNG WHERE A.BUSINESS_UNIT_PC = B.BUSINESS_UNIT AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.BUSINESS_UNIT_PC = PRJ.BUSINESS_UNIT AND A.PROJECT_ID = PRJ.PROJECT_ID AND %Join(COMMON_KEYS,PROJECT PRJ,PROJECT_LANG LNG)

  • Related Language Record for SP_CAPCLN_CLSVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
    2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
    3 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
    4 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
    5 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description