PO_SS_ASNOLN_LG

(SQL View)
 Index Back

Sup Portal: ASN History LangVw


SELECT A.EIP_CTL_ID , C.LANGUAGE_CD , C.DESCR254_MIXED FROM PS_RECV_AOLN_EC A , PS_PO_LINE B , PS_RECV_AOLN_LANG C WHERE A.BUSINESS_UNIT_PO = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID AND A.LINE_NBR = B.LINE_NBR AND A.EIP_CTL_ID = C.EIP_CTL_ID AND A.ASN_SEQ_NBR = C.ASN_SEQ_NBR AND A.ASN_SCHED_NBR = C.ASN_SCHED_NBR

  • Related Language Record for PO_SS_ASNOLN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description