BUSINESS_UNITRFQ_IDA=Approved
C=Closed
H=On Hold
O=Open
X=Canceled
RFQ_RESP_ER_VW2(SQL View) |
Index Back |
|---|---|
RFQ Response Error RFQ Id View |
| select distinct a.business_unit, a.rfq_id, b.rfq_status, b.rfq_ref from ps_rfq_resp_hdr_ec a, PS_RFQ_HDR b where a.po_edi_status = 'E' and a.business_unit = b.business_unit and a.rfq_id = b.rfq_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | RFQ_ID |
Character(10) | VARCHAR2(10) NOT NULL | RFQ ID |
| 3 | RFQ_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
RFQ Status
A=Approved C=Closed H=On Hold O=Open X=Canceled |
| 4 | RFQ_REF | Character(30) | VARCHAR2(30) NOT NULL | RFQ Reference |