PC_AM_ACT_LSRCH

(SQL View)
 Index Back

Project Activity Search

This search view is just like PROJ_ACT_SRCH except this view does not allow for 'pending' projects to be selected.

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ROW_NUMBER_5 , A.ACTIVITY_ID , B.LANGUAGE_CD , D.DESCR , B.DESCR FROM PS_PROJ_ACTIVITY A , PS_PROJ_ACTIVTY_LG B ,PS_PROJECT C , PS_PROJECT_LANG D , PS_PC_AM_RULE_ACT E WHERE %Join(COMMON_KEYS, PROJ_ACTIVITY A, PROJ_ACTIVTY_LG B) AND %Join(COMMON_KEYS, PROJ_ACTIVITY A, PROJECT C) AND %Join(COMMON_KEYS, PROJECT C, PROJECT_LANG D) AND %Join(COMMON_KEYS, PROJ_ACTIVITY A, PC_AM_RULE_ACT E) AND B.LANGUAGE_CD = D.LANGUAGE_CD AND A.COSTING_ACT_SW = 'Y' AND C.SUMMARY_PRJ = 'N' AND C.EFF_STATUS IN ('A', 'I') AND E.PC_AM_CAP_RULE IN ('1', '6') UNION SELECT F.BUSINESS_UNIT , F.PROJECT_ID , F.ROW_NUMBER_5 , F.ACTIVITY_ID , H.LANGUAGE_CD , H.DESCR , F.DESCR FROM PS_PROJ_ACTIVITY F ,PS_PROJECT G , PS_PROJECT_LANG H , PS_PC_AM_RULE_ACT I WHERE F.BUSINESS_UNIT = G.BUSINESS_UNIT AND F.PROJECT_ID = G.PROJECT_ID AND G.BUSINESS_UNIT =H.BUSINESS_UNIT AND G.PROJECT_ID = H.PROJECT_ID AND F.BUSINESS_UNIT = I.BUSINESS_UNIT AND F.PROJECT_ID = I.PROJECT_ID AND F.ACTIVITY_ID = I.ACTIVITY_ID AND F.COSTING_ACT_SW = 'Y' AND G.SUMMARY_PRJ = 'N' AND G.EFF_STATUS IN ('A', 'I') AND I.PC_AM_CAP_RULE IN ('1', '6') AND NOT EXISTS ( SELECT 'X' FROM PS_PROJ_ACTIVTY_LG J WHERE J.BUSINESS_UNIT = H.BUSINESS_UNIT AND J.PROJECT_ID = H.PROJECT_ID AND J.LANGUAGE_CD = H.LANGUAGE_CD) UNION SELECT K.BUSINESS_UNIT , K.PROJECT_ID , K.ROW_NUMBER_5 , K.ACTIVITY_ID , L.LANGUAGE_CD , M.DESCR , L.DESCR FROM PS_PROJ_ACTIVITY K , PS_PROJ_ACTIVTY_LG L ,PS_PROJECT M , PS_PC_AM_RULE_ACT N WHERE K.BUSINESS_UNIT = L.BUSINESS_UNIT AND K.PROJECT_ID = L.PROJECT_ID AND K.ACTIVITY_ID = L.ACTIVITY_ID AND K.BUSINESS_UNIT =M.BUSINESS_UNIT AND K.PROJECT_ID = M.PROJECT_ID AND K.BUSINESS_UNIT = N.BUSINESS_UNIT AND K.PROJECT_ID = N.PROJECT_ID AND K.ACTIVITY_ID = N.ACTIVITY_ID AND K.COSTING_ACT_SW = 'Y' AND M.SUMMARY_PRJ = 'N' AND M.EFF_STATUS IN ('A', 'I') AND N.PC_AM_CAP_RULE IN ('1', '6') AND NOT EXISTS ( SELECT 'X' FROM PS_PROJECT_LANG O WHERE O.BUSINESS_UNIT = L.BUSINESS_UNIT AND O.PROJECT_ID = L.PROJECT_ID AND O.LANGUAGE_CD = L.LANGUAGE_CD)

  • Related Language Record for PC_AM_ACT_SRCH

    • # 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
    3 ROW_NUMBER_5 Number(5,0) INTEGER NOT NULL Row Number
    4 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR1 Character(30) VARCHAR2(30) NOT NULL Project Description
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description