CA_PROJ_ACT_VW

(SQL View)
 Index Back

Srch Rec for Inquire Proj/Act

Search Record for the Self-Service iClient version of the Inquire Project/Activities for Contracts

SELECT HDR.BUSINESS_UNIT ,DTL_PROJ.CONTRACT_NUM ,SOLD.NAME1 ,DTL_PROJ.CONTRACT_LINE_NUM ,HDR.CONTRACT_TYPE ,DTL_PROJ.BUSINESS_UNIT_PC ,DTL_PROJ.PROJECT_ID ,DTL.DESCR ,STATUS.PROJECT_STATUS ,PROJ.PROJECT_TYPE ,PROJ.DESCR ,HDR.CA_RQST_SRC ,CA_TYPE.DESCR ,HDR.CONTRACT_ADMIN FROM PS_CA_DETAIL_PROJ DTL_PROJ ,PS_CA_CONTR_HDR HDR ,PS_CUST_SLD_VW SOLD ,PS_CA_DETAIL DTL ,PS_PROJECT PROJ ,PS_PROJECT_STATUS STATUS ,PS_CA_TYPE_TBL CA_TYPE ,PS_SET_CNTRL_GROUP D WHERE DTL_PROJ.CONTRACT_NUM = HDR.CONTRACT_NUM AND SOLD.CUST_ID = HDR.SOLD_TO_CUST_ID AND CA_TYPE.CONTRACT_TYPE = HDR.CONTRACT_TYPE AND HDR.CONTRACT_NUM = DTL.CONTRACT_NUM AND DTL_PROJ .CONTRACT_LINE_NUM = DTL.CONTRACT_LINE_NUM AND PROJ.BUSINESS_UNIT = STATUS.BUSINESS_UNIT AND PROJ.PROJECT_ID = STATUS.PROJECT_ID AND DTL_PROJ.BUSINESS_UNIT_PC = PROJ.BUSINESS_UNIT AND DTL_PROJ.PROJECT_ID = PROJ.PROJECT_ID AND D.REC_GROUP_ID = ( SELECT REC_GROUP_ID FROM PS_REC_GROUP_REC WHERE RECNAME = 'CUSTOMER') AND SOLD.SETID = D.SETID AND HDR.BUSINESS_UNIT = D.SETCNTRLVALUE AND STATUS.EFFDT = ( SELECT MAX(A.EFFDT) FROM PS_PROJECT_STATUS A WHERE STATUS.BUSINESS_UNIT = A.BUSINESS_UNIT AND STATUS.PROJECT_ID = A.PROJECT_ID) AND STATUS.EFFSEQ = ( SELECT MAX(B.EFFSEQ) FROM PS_PROJECT_STATUS B WHERE STATUS.BUSINESS_UNIT = B.BUSINESS_UNIT AND STATUS.PROJECT_ID = B.PROJECT_ID AND STATUS.EFFDT = B.EFFDT)

  • Related Language Record: CA_PRACT_VW_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT

    Prompt Table: SP_BU_CA_NONVW

    2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

    Prompt Table: CA_CNTR_SRCH_VW

    3 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    4 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
    5 CONTRACT_TYPE Character(15) VARCHAR2(15) NOT NULL Contract Type

    Prompt Table: CA_TYPE_TBL
    Set Control Field: BUSINESS_UNIT

    6 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

    Prompt Table: SP_BU_PC_NONVW

    7 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

    Prompt Table: SP_CAPRJ2_NONVW

    8 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    9 PROJECT_STATUS Character(1) VARCHAR2(1) NOT NULL Project Status
    B=Budgeted
    C=Closed
    H=Hold
    O=Open
    P=Proposed

    Prompt Table: PROJ_STATUS_TBL

    10 PROJECT_TYPE Character(5) VARCHAR2(5) NOT NULL Project Type
    A=Activity
    G=Grant
    H=Phase
    P=Project
    S=Segment

    Prompt Table: PROJ_TYPE_TBL
    Set Control Field: BUSINESS_UNIT_PC

    11 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    12 CA_RQST_SRC Character(3) VARCHAR2(3) NOT NULL Contract Classification
    FED=Federal Reimbursable Agreement
    GEN=Generic Application
    GOV=Government
    INT=Internal
    OND=CRM Field Services On Demand
    STD=Standard
    13 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
    14 CONTRACT_ADMIN Character(40) VARCHAR2(40) NOT NULL Contract Administrator defined on CABU.

    Prompt Table: MEMBER_VW