SP_CAPCLN_OPRVW

(SQL View)
Index Back

SELECT C.OPRID ,A.CONTRACT_NUM ,A.CONTRACT_LINE_NUM , A.BUSINESS_UNIT_PC , A.PROJECT_ID , PRJ.DESCR , A.ACTIVITY_ID FROM PS_CA_DETAIL_PROJ A , PS_PROJECT PRJ , PS_BUS_UNIT_TBL_FS B , PS_SEC_BU_OPR C 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

  • Related Language Record: SP_CAPCLN_OPRLW
  • # 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 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID