BUSINESS_UNITAUC_IDAUC_ROUNDAUC_VERSIONLINE_NBRAUC_COLLAB_BF1(SQL View) |
Index Back |
|---|---|
Bid Factor line change - descrCollaboration Change view for Sourcing Event Line bid factor changes (description only). |
| 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_LN_BID_FCTR' OR A.RECNAME = 'AUC_LN_FCTR_LST' OR A.RECNAME = 'AUC_LN_BF_RVW') 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 |