AUC_COLLAB_CS1

(SQL View)
 Index Back

Line Constraints Descr Collab


SELECT DISTINCT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , A.LINE_NBR , B.DESCR254_MIXED , (CASE B.AUC_LINE_TYPE WHEN 'G' THEN B.AUC_GROUP_ID ELSE B.INV_ITEM_ID END) FROM PS_AUC_COLLAB_LOG A , PS_AUC_LINE B , PS_AUC_HDR C WHERE (A.RECNAME = 'AUC_LINE_CONST' OR A.RECNAME = 'AUC_LN_CNST_ATT' OR A.RECNAME = 'AUC_LNCNST_ATLS') AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.AUC_ID = C.AUC_ID AND A.AUC_ROUND = C.AUC_ROUND AND A.AUC_VERSION = C.AUC_VERSION AND (C.AUC_COLLAB_STATUS = 'A' OR (A.AUC_COLLAB_SEQNUM < C.AUC_COLLAB_SEQNUM AND C.AUC_COLLAB_STATUS = 'C')) AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.AUC_ID = A.AUC_ID AND B.AUC_ROUND = A.AUC_ROUND AND B.AUC_VERSION = A.AUC_VERSION AND B.LINE_NBR = A.LINE_NBR

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