EG_SS_VNDECO_VW(SQL View) |
Index Back |
|---|---|
ECO Header View (IClient)06/04/00 rml Add OPRID to support multiple suppliers per operator 05/16/00 RML New supplier security allowing multiple suppliers per user. Changed view to order ECOs by supplier id instead of oprid. Created on 10/11/99 RML EG800-2.0 Copied from eg_eco_hdr_vw; modified to include supplier id |
| SELECT DISTINCT V.OPRID , V.SETID , V.VENDOR_ID , A.BUSINESS_UNIT , A.ECO_ID , B.INV_ITEM_ID , A.EG_PRIORITY , A.EG_APPROVAL_FLAG , A.DESCR , A.EG_CLASSIFICATION , A.EG_WF_RTG_TYPE , A.EG_UDEF_ACTY , A.EG_ANALYST , A.EG_RELEASE_DATE FROM PS_EG_ECO_HEADER A , PS_EG_ECO_ASSY B , PS_VENDOR_USER V , PS_EG_ECO_OPR_APPR D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.ECO_ID = B.ECO_ID AND A.ECO_STATE = 'CO' AND A.ECO_STATE = B.ECO_STATE AND D.EG_OPRID_APPROVAL = V.OPRID AND A.EN_VND_NO_ACCESS = 'N' AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.ECO_ID = D.ECO_ID AND D.ECO_ID NOT IN ( SELECT E.ECO_ID FROM PS_EG_IC_ECOHDR_VW E WHERE E.BUSINESS_UNIT = D.BUSINESS_UNIT AND E.ECO_ID = D.ECO_ID AND E.VENDOR_SETID = V.SETID AND E.VENDOR_ID = V.VENDOR_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 3 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 4 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUMGOP_NONVW |
| 5 | ECO_ID |
Character(10) | VARCHAR2(10) NOT NULL |
ECO Number
Prompt Table: EG_ECO_HDRP_VW |
| 6 | INV_ITEM_ID_LAST | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 7 | EG_PRIORITY | Character(4) | VARCHAR2(4) NOT NULL |
Priority Code
Prompt Table: EG_PRIORITY_CD |
| 8 | EG_APPROV_ECO_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Status
A=Approved C=Canceled D=Denied P=Pending R=Released Default Value: P |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 10 | EG_CLASSIFICATION | Character(10) | VARCHAR2(10) NOT NULL |
Classification
Prompt Table: EG_CLASSIFY_CD |
| 11 | EG_WF_RTG_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
ECO Type
Prompt Table: EG_WF_RTG_TYPE |
| 12 | EG_UDEF_ACTY | Character(10) | VARCHAR2(10) NOT NULL |
ECO Activity
Prompt Table: EG_WF_RTG_AP_VW |
| 13 | EG_ANALYST | Character(30) | VARCHAR2(30) NOT NULL | Analyst |
| 14 | EG_RELEASE_DATE | Date(10) | DATE |
07/31/00...LAJ
Added eg_release_date2 label id. This will be used on the ECO line status page.
Default Value: %date |