EG_IC_ECOHDR_VW(SQL View) |
Index Back |
|---|---|
ECO Header View (IClient)05/15/00 RML Added PC to RowInit to hide ECO link if no rows exist in list. Created on 10/11/99 RML EG800-2.0 Copied from eg_eco_hdr_vw; modified to include supplier id. View to show only ECOs with affected items which have access granted to suppliers |
| SELECT DISTINCT A.BUSINESS_UNIT , A.ECO_ID , 'CO' , 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 , C.SETID , C.VENDOR_ID FROM PS_EG_ECO_HEADER A , PS_EG_ECO_ASSY B , PS_EN_IC_BOM_PRIV C 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 A.EN_VND_NO_ACCESS = 'N' AND C.EN_IC_ECO_VIEW = 'Y' AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.INV_ITEM_ID = C.INV_ITEM_ID AND (B.BOM_TYPE = C.BOM_TYPE OR B.BOM_TYPE = ' ' OR C.BOM_TYPE = ' ') AND (B.BOM_CODE = C.BOM_CODE OR B.BOM_CODE = 0 OR C.BOM_CODE = 0) |
| # | 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_BUMGOP_NONVW |
| 2 | ECO_ID |
Character(10) | VARCHAR2(10) NOT NULL |
ECO Number
Prompt Table: EG_ECO_HDRP_VW |
| 3 | ECO_STATE | Character(2) | VARCHAR2(2) NOT NULL |
ECR / ECO Flag
CO=Engineering Change Order CR=Engineering Chg Request |
| 4 | INV_ITEM_ID_LAST | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | EG_PRIORITY | Character(4) | VARCHAR2(4) NOT NULL |
Priority Code
Prompt Table: EG_PRIORITY_CD |
| 6 | EG_APPROV_ECO_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Status
A=Approved C=Canceled D=Denied P=Pending R=Released Default Value: P |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | EG_CLASSIFICATION | Character(10) | VARCHAR2(10) NOT NULL |
Classification
Prompt Table: EG_CLASSIFY_CD |
| 9 | EG_WF_RTG_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
ECO Type
Prompt Table: EG_WF_RTG_TYPE |
| 10 | EG_UDEF_ACTY | Character(10) | VARCHAR2(10) NOT NULL |
ECO Activity
Prompt Table: EG_WF_RTG_AP_VW |
| 11 | EG_ANALYST | Character(30) | VARCHAR2(30) NOT NULL | Analyst |
| 12 | 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 |
| 13 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 14 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |