CSHDPOTNDRVWLNG

(SQL View)
 Index Back

Dept Only Tender View


SELECT a.business_unit , a.cashier_office , a.cashier , b.tender_key ,c.language_cd , c.descr FROM ps_csh_off_cashier a , ps_tender_cshr_tbl b , ps_TENDER_KEY_LNG c ,PS_TENDER_KEY_TBL Y WHERE a.business_unit = b.business_unit AND a.cashier = b.cashier AND b.effdt = c.effdt AND b.business_unit = c.business_unit AND b.tender_key = c.tender_key AND c.effdt = ( SELECT MAX (e.effdt) FROM ps_TENDER_KEY_LNG e WHERE c.business_unit = e.business_unit AND c.tender_key = e.tender_key AND e.effdt <= %CurrentDateIn) AND Y.eff_status = 'A' AND Y.tender_category IN ('CC','CK','CS','DB','DD','TP') AND c.BUSINESS_UNIT=Y.BUSINESS_UNIT AND c.TENDER_KEY=Y.TENDER_KEY AND c.EFFDT=Y.EFFDT AND b.in_allowed = 'Y'

  • Related Language Record for CSH_DPO_TNDR_VW

  • Parent record: CSH_BD_CSH_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 CASHIER_OFFICE Character(8) VARCHAR2(8) NOT NULL Cashier's Office
    3 CASHIER Character(30) VARCHAR2(30) NOT NULL Cashier
    4 TENDER_KEY Character(10) VARCHAR2(10) NOT NULL Tender Key
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description