AUC_LNFMTRND_VW

(SQL View)
 Index Back

AUC_LINE with max Round View


SELECT DISTINCT B.BUSINESS_UNIT , B.BUSINESS_UNIT , B.AUC_ID , B.LINE_NBR , B.INV_ITEM_ID , B.DESCR254_MIXED FROM PS_AUC_HDR A , PS_AUC_LINE B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.AUC_ID = B.AUC_ID AND A.AUC_ROUND = B.AUC_ROUND AND B.AUC_ROUND = ( SELECT MAX(B1.AUC_ROUND) FROM PS_AUC_LINE B1 WHERE B.BUSINESS_UNIT = B1.BUSINESS_UNIT AND B.AUC_ID = B1.AUC_ID AND B.LINE_NBR = B1.LINE_NBR) AND A.AUC_VERSION = B.AUC_VERSION AND B.AUC_VERSION = ( SELECT MAX(C1.AUC_VERSION) FROM PS_AUC_LINE C1 WHERE B.BUSINESS_UNIT = C1.BUSINESS_UNIT AND B.AUC_ID = C1.AUC_ID AND B.AUC_ROUND = C1.AUC_ROUND AND B.LINE_NBR = C1.LINE_NBR)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 TO_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit selection field
3 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
4 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
6 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description