RECV_LNSHIP_SLV

(SQL View)
 Index Back

Language record

for RECV_LNSHIP_SVW

SELECT A.BUSINESS_UNIT , A.RECEIVER_ID , A.RECV_LN_NBR , A.RECV_SHIP_SEQ_NBR , B.LANGUAGE_CD , B.DESCR , B.DESCRSHORT FROM PS_RECV_LN_SHIP A , PS_SHIPTO_LANG B WHERE B.SETID = ( SELECT SETID FROM PS_RECV_HDR C WHERE C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.RECEIVER_ID = A.RECEIVER_ID) AND B.SHIPTO_ID = A.SHIPTO_ID AND B.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PS_SHIPTO_LANG B2 WHERE B2.SETID = B.SETID AND B2.SHIPTO_ID = B.SHIPTO_ID AND B2.EFFDT <= %CurrentDateIn)

  • Related Language Record for RECV_LNSHIP_SVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
    3 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
    4 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description