AUC_NON_LOT_VW(SQL View) |
Index Back |
---|---|
Eligible Event Lots prompt |
SELECT DISTINCT A.BUSINESS_UNIT , A.AUC_FORMAT , A.AUC_TYPE , A.AUC_ID , A.AUC_NAME FROM PS_AUC_HDR A WHERE A.AUC_STATUS NOT IN ('X','A','N','T') AND A.AUC_TMPLTE_FLG <> 'Y' AND NOT EXISTS ( SELECT 'X' FROM PS_AUC_HDR B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.AUC_FORMAT = A.AUC_FORMAT AND B.AUC_TYPE = A.AUC_TYPE AND B.AUC_PREV_LOT_ID = A.AUC_ID) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: AUC_HDR.BUSINESS_UNIT Prompt Table: AUC_BU_ASSGN_VW |
2 | AUC_FORMAT | Character(1) | VARCHAR2(1) NOT NULL |
Event Format
F=Sell I=RFI R=Buy S=Service Default Value: AUC_HDR.AUC_FORMAT |
3 | AUC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Event Type
E=Auction S=RFx Default Value: AUC_HDR.AUC_TYPE |
4 | AUC_ID | Character(10) | VARCHAR2(10) NOT NULL | Event ID |
5 | AUC_NAME | Character(50) | VARCHAR2(50) NOT NULL | Event Name |