PO_LN_MFGID_VW

(SQL View)
Index Back

PO Line Manufacturers

Distinct Manufacturers on PO Lines

SELECT DISTINCT L.BUSINESS_UNIT , L.PO_ID , L.MFG_ID , M.DESCR60 FROM PS_PO_LINE L , PS_MANUFACTURER M , PS_SET_CNTRL_REC S WHERE L.ITM_SETID = M.SETID AND L.MFG_ID = M.MFG_ID AND L.MFG_ID <> ' ' AND M.SETID = S.SETID AND L.ITM_SETID = S.SETCNTRLVALUE AND S.RECNAME = 'MANUFACTURER'

  • Related Language Record: PO_LN_MFGID_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    3 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
    4 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description