EG_IC_ECRHDR_VW(SQL View) |
Index Back |
|---|---|
ECR Header View (IC)10/06/99 RML EN800-2.0 Created view to be used with self service ECR maintenance |
| SELECT DISTINCT a.business_unit , a.eco_id , b.inv_item_id , a.eg_priority , a.eg_approval_flag , a.descr , a.deptid , a.eg_requestor , c.setid , c.vendor_id , c.en_ic_ecr_view 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 = 'CR' AND a.eco_state = b.eco_state AND a.en_vnd_no_access = 'N' AND c.business_unit = b.business_unit AND c.inv_item_id = b.inv_item_id AND (c.bom_type = b.bom_type OR b.bom_type = ' ') AND (c.bom_code = b.bom_code OR b.bom_code = 0) AND c.en_ic_ecr_view = 'Y' AND a.vendor_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_BUMGOP_NONVW |
| 2 | ECR_ID |
Character(10) | VARCHAR2(10) NOT NULL |
ECR Number
Prompt Table: EG_ECR_HDRP_VW |
| 3 | INV_ITEM_ID_LAST |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 4 | EG_PRIORITY | Character(4) | VARCHAR2(4) NOT NULL |
Priority Code
Prompt Table: EG_PRIORITY_CD |
| 5 | EG_APPROVAL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Status
A=Approved C=Canceled D=Denied P=Pending R=Converted Default Value: P |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 8 | EG_REQUESTOR | Character(30) | VARCHAR2(30) NOT NULL | Requested by |
| 9 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 10 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 11 | EN_IC_ECR_VIEW | Character(1) | VARCHAR2(1) NOT NULL | Vendor security to view ECR - used by BOM Access by Vendor |