CA_AP_EV_PM_VW

(SQL View)
 Index Back

Contr Rev Plan Evnt View

Record will contain one row for each pending Revenue Plan event that is associated with a Project milestone/activity. A pending event is an event of Pending or Ready status

SELECT AP.BUSINESS_UNIT_PC ,AP.PROJECT_ID ,AP.ACTIVITY_ID ,AP.CONTRACT_NUM ,AP.ACCT_PLAN_ID ,AP.EVENT_NUM ,AP.ACTIVITY_STATUS ,HDR.DESCR ,HDR.SOLD_TO_CUST_ID ,HDR.BUSINESS_UNIT ,'Revenue' AS CONTR_IMP_AREA FROM PS_CA_AP_EVENT AP , PS_CA_CONTR_HDR HDR WHERE AP.AP_EVENT_TYPE = '02' AND AP.MILESTONE_ORIGIN = 'A' AND AP.AP_EVENT_STATUS IN ('NEW','RDY') AND AP.CONTRACT_NUM = HDR.CONTRACT_NUM

# 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