BUSINESS_UNITAUC_IDAUC_ROUNDAUC_VERSIONLINE_NBRGRP_LINE_NBRDefault Value: 1
AUC_OPT_LNGP_VW(SQL View) |
Index Back |
|---|---|
Sourcing Line Group MembersSourcing Line Group Members |
| SELECT ALG.BUSINESS_UNIT , ALG.AUC_ID , ALG.AUC_ROUND , ALG.AUC_VERSION , ALG.LINE_NBR , ALG.GRP_LINE_NBR , ALG.AUC_GRP_QTY , %Round(%DECDIV(AL.AUC_PRICE, AL2.AUC_PRICE), 4) FROM PS_AUC_LINE_GROUP ALG INNER JOIN PS_AUC_LINE AL ON AL.BUSINESS_UNIT = ALG.BUSINESS_UNIT AND AL.AUC_ID = ALG.AUC_ID AND AL.AUC_ROUND = ALG.AUC_ROUND AND AL.AUC_VERSION = ALG.AUC_VERSION AND AL.LINE_NBR = ALG.GRP_LINE_NBR INNER JOIN PS_AUC_LINE AL2 ON AL2.BUSINESS_UNIT = ALG.BUSINESS_UNIT AND AL2.AUC_ID = ALG.AUC_ID AND AL2.AUC_ROUND = ALG.AUC_ROUND AND AL2.AUC_VERSION = ALG.AUC_VERSION AND AL2.LINE_NBR = ALG.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 | GRP_LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Group Line Number |
| 7 | AUC_GRP_QTY | Number(16,4) | DECIMAL(15,4) NOT NULL |
Group Qty
Default Value: 1 |
| 8 | SSO_PRICE_PCNT | Number(15,4) | DECIMAL(14,4) NOT NULL | price pencentage |