GM_PT_AWD_CS_VW

(SQL View)
 Index Back

budget Amount


SELECT DISTINCT B.CONTRACT_NUM , B.BUSINESS_UNIT , A.BUDGET_CATEGORY FROM PS_GM_PT_PRJ_BUD A , PS_GM_PT_PROJECT B WHERE (A.AMOUNT_TYPE = 'CSD' OR A.AMOUNT_TYPE = 'TCS') AND B.BUSINESS_UNIT_PC = A.BUSINESS_UNIT_PC AND B.PROJECT_ID = A.PROJECT_ID UNION SELECT DISTINCT B1.CONTRACT_NUM , B1.BUSINESS_UNIT , A1.BUDGET_CATEGORY FROM PS_GM_PT_PRJ_TRN A1 , PS_GM_PT_PROJECT B1 WHERE (A1.AMOUNT_TYPE = 'CSD' OR A1.AMOUNT_TYPE = 'TCS') AND B1.BUSINESS_UNIT_PC = A1.BUSINESS_UNIT_PC AND B1.PROJECT_ID = A1.PROJECT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 BUDGET_CATEGORY Character(15) VARCHAR2(15) NOT NULL BUDGET_CATEGORY