SCP_ASNITMF_VWL

(SQL View)
 Index Back

Sup Portal: ASN History Vw Lan


SELECT DISTINCT D.INV_ITEM_ID , F.LANGUAGE_CD , E.DESCR60 , E.DESCRSHORT , V.oprid FROM PS_RECV_AOHD_EC C , PS_RECV_AOLN_EC D , PS_RECV_ASHD_EC B , PS_EO_EIP_CTL A , PS_VENDOR_USER V , PS_MASTER_ITEM_TBL E , PS_MASTER_ITM_LANG F WHERE A.EIP_CTL_ID = B.EIP_CTL_ID AND C.EIP_CTL_ID = D.EIP_CTL_ID AND C.ASN_SEQ_NBR = D.ASN_SEQ_NBR AND B.EIP_CTL_ID = C.EIP_CTL_ID AND B.VENDOR_SETID = V.SETID AND B.VENDOR_ID = V.VENDOR_ID AND V.SETID = E.SETID AND D.INV_ITEM_ID = E.INV_ITEM_ID AND D.INV_ITEM_ID <> ' ' AND E.SETID = F.SETID AND E.INV_ITEM_ID = F.INV_ITEM_ID

  • Related Language Record for SCP_ASNITMFL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).