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