CA_BP_SUMM_VW

(SQL View)
 Index Back

CA_BP_SUMM_VW


SELECT B.CONTRACT_NUM , D.BILL_PLAN_ID , B.FOREIGN_CURRENCY , SUM(B.FOREIGN_AMOUNT) FROM PS_CA_PROJ_SUMMARY B , PS_CA_DETAIL D , PS_CA_DETAIL_PROJ C , PS_CA_CONTR_HDR E , PS_CA_BILL_PLAN A WHERE C.CONTRACT_NUM = B.CONTRACT_NUM AND C.BUSINESS_UNIT_PC = B.BUSINESS_UNIT_PC AND C.PROJECT_ID = B.PROJECT_ID AND C.ACTIVITY_ID = B.ACTIVITY_ID AND D.CONTRACT_NUM = C.CONTRACT_NUM AND D.CONTRACT_LINE_NUM = C.CONTRACT_LINE_NUM AND C.CONTRACT_NUM = E.CONTRACT_NUM AND A.CONTRACT_NUM = B.CONTRACT_NUM AND A.BILL_PLAN_ID = D.BILL_PLAN_ID GROUP BY B.CONTRACT_NUM, D.BILL_PLAN_ID, B.FOREIGN_CURRENCY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
2 BILL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Billing Plan ID
3 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
4 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount