CA_PC_WC_REV_VW

(SQL View)
 Index Back

Project Analysis Grp filter vw

Incorrect Project Analysis Group Filter view

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , B.ACTIVITY_ID , C.CONTRACT_NUM , MYP.OPRID FROM PS_PROJECT A , PS_PROJ_ACTIVITY B , PS_CA_DETAIL_PROJ C , PS_CA_DETAIL D , PS_PC_OPRID_PRJACT MYP WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND A.BUSINESS_UNIT = MYP.BUSINESS_UNIT AND A.PROJECT_ID = MYP.PROJECT_ID AND A.EFF_STATUS = 'A' AND B.EFF_STATUS = 'A' AND B.COSTING_ACT_SW = 'Y' AND B.BUSINESS_UNIT =C.BUSINESS_UNIT_PC AND B.PROJECT_ID = C.PROJECT_ID AND B.ACTIVITY_ID = C.ACTIVITY_ID AND C.CONTRACT_NUM = D.CONTRACT_NUM AND C.CONTRACT_LINE_NUM = D.CONTRACT_LINE_NUM AND D.PRICING_STRUCTURE = 'RATE'

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

Default Value: PROJ_ACTIVITY.BUSINESS_UNIT

Prompt Table: SP_BU_PC_NONVW

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

Default Value: PROJ_ACTIVITY.PROJECT_ID

Prompt Table: SP_PROJ_NONVW

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

Default Value: PROJ_ACTIVITY.ACTIVITY_ID

Prompt Table: PROJ_ACT_SRCH

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

Prompt Table: CA_CONTRACT_VW

5 OPRID2 Character(30) VARCHAR2(30) NOT NULL A user's ID