PC_BUDDT_ITM_VW (SQL View)	Index Back
Budget Items by budget plan This view displays the budget items used for a particular budget plan.

PC_BUDDT_ITM_VW

(SQL View)

Budget Items by budget plan

This view displays the budget items used for a particular budget plan.

SELECT DISTINCT A.PC_BUDGET_ITEM FROM PS_PC_BUD_ITEM A , PS_PC_BUD_PLAN B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND A.PC_BUDGET_ID = B.PC_BUDGET_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PC_BUDGET_ITEM Character(15) VARCHAR2(15) NOT NULL Project Budgeting: Budget Item 11/15/2004- FS - Added label COST_BUDGET_ITEM