GM_PT_PREPRJ_VW

(SQL View)
 Index Back

Pre-Spending Project


SELECT DISTINCT A.BUSINESS_UNIT , A.PROJECT_ID FROM PS_PROJECT A , PS_PROJECT_TEAM B , PS_GM_PROP_PROJ C WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.PROJECT_ID = A.PROJECT_ID AND A.GRANT_FLG = 'Y' AND C.PROJECT_ID = A.PROJECT_ID AND C.PPSL_TO_PRJCT_FLG = 'P' AND NOT EXISTS ( SELECT 'X' FROM PS_GM_PT_ACC_LVL3 LVL3 WHERE LVL3.BUSINESS_UNIT_PC = A.BUSINESS_UNIT AND LVL3.PROJECT_ID = A.PROJECT_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField