CA_MS_CD_PM_VW

(SQL View)
 Index Back

Contract Milestone Cond. View

Record will contain one row for each Milestone condition that is associated with a Contract and is associated with a Project milestone/activity A pending Milestone condition is a condition of status Ready while the parent milestone status is Pending or Ready.

SELECT CD.BUSINESS_UNIT_PC , CD.PROJECT_ID , CD.ACTIVITY_ID ,MS.CONTRACT_NUM , %Sql(PC_COM_CHAR,MS.MS_SEQNUM,3,3,3) %Concat '(' %Concat MS.MILESTONE_ID %Concat ')' , CD.MS_COND_SEQ , CD.ACTIVITY_STATUS , HDR.DESCR , HDR.SOLD_TO_CUST_ID , HDR.BUSINESS_UNIT , 'Milestone' AS CONTR_IMP_AREA FROM PS_CA_MILESTONE MS , PS_CA_MS_COND CD , PS_CA_CONTR_HDR HDR WHERE MS.MILESTONE_STATUS IN ('P','R') AND MS.CONTRACT_NUM = CD.CONTRACT_NUM AND MS.MS_SEQNUM = CD.MS_SEQNUM AND CD.MS_COND_TYPE = 'MS' AND CD.MILESTONE_SOURCE = 'PC' AND CD.MS_COND_STATUS = 'R' AND MS.CONTRACT_NUM = HDR.CONTRACT_NUM

  • Parent record: CA_PROJ_MLS_VW

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

    Prompt Table: BUS_UNIT_PC_VW

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

    Prompt Table: CA_PROJ_MS_VW

    3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

    Prompt Table: CA_ACT_MS_VW

    4 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
    5 AP_BP_MLS_ID Character(15) VARCHAR2(15) NOT NULL Rev/Bill Plan or Milestone ID
    6 EVENT_COND_NUM Number(3,0) SMALLINT NOT NULL Event /Condition Number
    7 ACTIVITY_STATUS Character(1) VARCHAR2(1) NOT NULL Activity Status

    Prompt Table: PROJ_STATUS_TBL

    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
    10 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    11 CONTR_IMP_AREA Character(15) VARCHAR2(15) NOT NULL Contract Impact Area