SCP_SEC_BS_VWFL

(SQL View)
 Index Back

AUC Bid Status view


SELECT 'L' AS BID_STATUS_FLG ,'All' AS BID_STATUS_TXT , -2 FROM PS_INSTALLATION UNION SELECT A.FIELDVALUE AS BID_STATUS_FLG , A.XLATLONGNAME AS BID_STATUS_TXT , -1 FROM PSXLATITEM A WHERE A.FIELDNAME = 'SCP_BID_STATUS_FLG' AND A.FIELDVALUE IN('N') AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PSXLATITEM B WHERE A.FIELDNAME = B.FIELDNAME AND B.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' UNION SELECT A.FIELDVALUE AS BID_STATUS_FLG , A.XLATLONGNAME AS BID_STATUS_TXT , 0 FROM PSXLATITEM A WHERE A.FIELDNAME = 'SCP_BID_STATUS_FLG' AND A.FIELDVALUE IN('A','W') AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PSXLATITEM B WHERE A.FIELDNAME = B.FIELDNAME AND B.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' UNION SELECT A.FIELDVALUE AS BID_STATUS_FLG , A.XLATLONGNAME AS BID_STATUS_TXT , 1 FROM PSXLATITEM A WHERE A.FIELDNAME = 'SCP_BID_STATUS_FLG' AND A.FIELDVALUE IN('O') AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PSXLATITEM B WHERE A.FIELDNAME = B.FIELDNAME AND B.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' UNION SELECT A.FIELDVALUE AS BID_STATUS_FLG , A.XLATLONGNAME AS BID_STATUS_TXT , 3 FROM PSXLATITEM A WHERE A.FIELDNAME = 'SCP_BID_STATUS_FLG' AND A.FIELDVALUE IN('D','T') AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PSXLATITEM B WHERE A.FIELDNAME = B.FIELDNAME AND B.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCP_BID_STATUS_FLG Character(1) VARCHAR2(1) NOT NULL Bid Status Format
A=Accepted
D=Declined
L=All
N=New
O=Outbid
T=Withdrew
W=Winning
2 BID_STATUS_TXT Character(30) VARCHAR2(30) NOT NULL Status
3 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number