AUC_NOA_SRCH(SQL View) |
Index Back |
|---|---|
NOA Search ViewNOA Search View |
| SELECT A.business_unit , A.auc_id , A.auc_round , a.auc_version ,A.AUC_FORMAT ,A.AUC_TYPE ,A.AUC_STATUS FROM PS_AUC_HDR A , ps_auc_award_hdr B WHERE (A.blind_flg <> 'Y' OR A.auc_dttm_finish <= %CurrentDateTimeIn) AND A.AUC_NOA = 'Y' AND A.auc_format <> 'E' AND A.business_unit = B.business_unit AND A.auc_id = B.auc_id AND A.auc_round = B.auc_round AND A.auc_version = B.auc_version AND B.AUC_BID_AWARD = 'A' AND ( B.PO_ID <> ' ' OR B.CNTRCT_ID <> ' ') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_AUC_BU_NONVW |
| 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 | AUC_FORMAT | Character(1) | VARCHAR2(1) NOT NULL |
Event Format
F=Sell I=RFI R=Buy S=Service |
| 6 | AUC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Event Type
E=Auction S=RFx |
| 7 | AUC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Event Status
A=Awarded C=Collaborating Event D=Collaborating Bid Analysis E=Evaluating F=RFI Reviewed I=Pending RFI Review N=Not Awarded O=Open P=Posted Q=Paused R=Pending Scheduled Review S=Pending Post Approval T=Pending Award U=Pending Award Approval W=Post to Third Party Failed X=Cancelled Z=Inactive Version Default Value: O |