GM_PREF_AWD_LVW

(SQL View)
 Index Back

Award Preferences Lng Vw

Award Preferences Language view

SELECT PREF_AWD.OPRID , AWD.BUSINESS_UNIT , AWD.CONTRACT_NUM , AWD_LNG.LANGUAGE_CD , AWD_LNG.TITLE56 , CUST_LNG.NAME1 FROM PS_GM_AWARD AWD , PS_GM_AWARD_LNG AWD_LNG , PS_CUSTOMER CUST , PS_CUSTOMER_LANG CUST_LNG , PS_GM_MY_PREF PREF_AWD WHERE PREF_AWD.BUSINESS_UNIT = AWD.BUSINESS_UNIT AND AWD_LNG.CONTRACT_NUM = AWD.CONTRACT_NUM AND ((PREF_AWD.BEGIN_DT <= AWD.BEGIN_DT) OR PREF_AWD.BEGIN_DT IS NULL) AND ((PREF_AWD.GM_SELECT_PI ='N') OR (PREF_AWD.GM_SELECT_PI ='Y' AND EXISTS ( SELECT 'X' FROM PS_GM_PREF_PI PREF_PI WHERE PREF_PI.OPRID = PREF_AWD.OPRID AND PREF_PI.EMPLID = AWD.EMPLID ))) AND ((PREF_AWD.GM_SEL_AWD_STS ='N') OR (PREF_AWD.GM_SEL_AWD_STS ='Y' AND EXISTS ( SELECT 'X' FROM PS_GM_PREF_AWD_STS PREF_STS WHERE PREF_STS.OPRID = PREF_AWD.OPRID AND PREF_STS.AWARD_STATUS = AWD.AWARD_STATUS ))) AND CUST.CUST_ID = AWD.CUST_ID AND CUST.CUST_ID = CUST_LNG.CUST_ID AND CUST.SETID = CUST_LNG.SETID AND CUST.SETID = ( SELECT REC.SETID FROM PS_SET_CNTRL_REC REC WHERE REC.RECNAME = 'CUSTOMER' AND AWD.BUSINESS_UNIT = REC.SETCNTRLVALUE ) AND ((PREF_AWD.GM_SELECT_SPONSOR ='N') OR (PREF_AWD.GM_SELECT_SPONSOR ='Y' AND EXISTS ( SELECT 'X' FROM PS_GM_PREF_SPONSOR PREF_SPN WHERE PREF_SPN.OPRID = PREF_AWD.OPRID AND PREF_SPN.CUST_ID = AWD.CUST_ID AND PREF_SPN.SETID = CUST.SETID )))

  • Related Language Record for GM_AWD_CERT_VW GM_LOC_EXP_VW GM_PREF_AWD_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 TITLE56 Character(56) VARCHAR2(56) NOT NULL TITLE56
    6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1