INV_RECV_LIN_VW

(SQL View)
Index Back

Inv Recv lot view - IN inst


SELECT DISTINCT r.business_unit , r.rma_id , r.rma_line_nbr , rl.inv_item_id , r.lot_id FROM PS_RMA_SERIAL_LOT r , ps_rma_line rl WHERE r.business_unit = rl.business_unit AND r.rma_id = rl.rma_id AND r.rma_line_nbr = rl.rma_line_nbr

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
2 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number
3 RMA_LINE_NBR Number(5,0) INTEGER NOT NULL RMA Line Number
4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
5 LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID