SPF_SRCBU_TM_LV

(SQL View)
 Index Back

SELECT DISTINCT C.BUSINESS_UNIT ,A.TEAM_ID ,PERSON_ID ,T.LANGUAGE_CD ,T.DESCR FROM PS_SPB_TEAM A , PS_SPB_MEM_BY_TEAM B ,PS_SPF_REQ_LINE C , PS_SET_CNTRL_GROUP S , PS_SPB_TEAM_LANG T WHERE A.SETID =B.SETID AND A.TEAM_ID= B.TEAM_ID AND A.EFFDT=B.EFFDT AND A.TEAM_TYPE = B.TEAM_TYPE AND A.EFF_STATUS = 'A' AND B.TEAM_TYPE = 'SC' AND C.BUSINESS_UNIT = S.SETCNTRLVALUE AND S.REC_GROUP_ID = 'SP_02' AND B.SETID = S.SETID AND A.SETID=T.SETID AND A.TEAM_ID=T.TEAM_ID AND A.EFFDT=T.EFFDT AND A.TEAM_TYPE=T.TEAM_TYPE AND %EffdtCheck(SPB_TEAM,A,%CurrentDateIn)

  • Related Language Record for SPF_SRC_BU_TEAM

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 TEAM_ID Character(15) VARCHAR2(15) NOT NULL Team ID
    3 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description