AUC_ITM_PO_VW

(SQL View)
 Index Back

Purchased Items View

View for Sourcing 'Copy From' feature.

SELECT A.SETID ,A.INV_ITEM_ID ,B.DESCR ,B.DESCRSHORT ,B.DESCR254_MIXED FROM PS_INV_ITEMS A , PS_PURCH_ITEM_ATTR B , PS_MASTER_ITEM_TBL C WHERE A.SETID = B.SETID AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.SETID = C.SETID AND A.INV_ITEM_ID = C.INV_ITEM_ID AND C.ITM_STATUS_CURRENT = '1' AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_INV_ITEMS C WHERE C.SETID = B.SETID AND C.INV_ITEM_ID = B.INV_ITEM_ID AND EFFDT <= %CurrentDateIn) AND ((%CurrentDateIn >= B.PO_AVAIL_DT) AND (B.PO_UNAVAIL_DT > %CurrentDateIn))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: MST_ITM_VW

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
5 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description