EG_SS_VNDECR_VW(SQL View) |
Index Back |
|---|---|
ECRs created by suppliers (SS)05/16/00 RML Added supplier_setid 03/16/00 RML Removed oprid 03/15/00 RML EN800-2.0 Created view to be used with self service ECR maintenance - shows all ECR created by suppliers |
| SELECT DISTINCT a.vendor_setid , a.vendor_id , a.business_unit , a.eco_id , b.inv_item_id , a.eg_priority , a.eg_approval_flag , a.descr , a.deptid , a.eg_requestor FROM ps_eg_eco_header a , PS_EG_ECO_ASSY b 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 a.vendor_id <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUMGOP_NONVW |
| 4 | ECR_ID |
Character(10) | VARCHAR2(10) NOT NULL | ECR Number |
| 5 | INV_ITEM_ID_LAST |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 6 | EG_PRIORITY | Character(4) | VARCHAR2(4) NOT NULL |
Priority Code
Prompt Table: EG_PRIORITY_CD |
| 7 | EG_APPROVAL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Status
A=Approved C=Canceled D=Denied P=Pending R=Converted Default Value: P |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 9 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 10 | EG_REQUESTOR | Character(30) | VARCHAR2(30) NOT NULL | Requested by |