PV_MS_CHNG_LNS

(SQL View)
Index Back

SELECT CHNG_ORD_BATCH , BUSINESS_UNIT , PO_ID , LINE_NBR FROM PS_PO_CHNG_LINE WHERE CHNG_ORD_BATCH <> 0 GROUP BY CHNG_ORD_BATCH, BUSINESS_UNIT, PO_ID, LINE_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CHNG_ORD_BATCH Number(3,0) SMALLINT NOT NULL Change Order Number
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
4 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]