VENDOR_SETIDVENDOR_IDBUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: BU_ITEMS_INV_VW
INV_ITEM_IDPrompt Table: MG_ITEM_OWN_VW
BOM_TYPEPR=Production
RW=Rework
BOM_CODEEN_ICBOMVND_VW(SQL View) |
Index Back |
|---|---|
BOM Component View06/07/00 RT Created rel lang vw 05/31/00 ST Removed field DESCR_BU as it isn't used anywhere. (didn't create related lang view) 05/30/00 rml Field descr is used in en_ic_srch_wrk 03/13/2000 RML Added roleuser and emailid from ps_rolexlatopr; used by ECO maintenance and ECO approval to find out who should be notified 02/16/2000 RML Changed view to show only mfg and production bills (bom_type = 'PR' and bom_state = 'PR') Created on 09/13/99 RML Used by self service application en_ic_bom_inq - bill of material inquiry |
| SELECT DISTINCT P.SETID , P.VENDOR_ID , P.BUSINESS_UNIT , P.INV_ITEM_ID , P.BOM_TYPE , P.BOM_CODE , A.DESCR , A.DESCR60 , P.EN_IC_MGBOM_READ , P.EN_IC_MGBOM_UPD , P.EN_IC_BOM_READ , P.EN_IC_ECR_VIEW , P.EN_IC_ECR_UPD , P.EN_IC_ECO_VIEW , P.EN_VND_APPR_ECO , P.EN_VND_NEW_ECO FROM PS_MASTER_ITEM_TBL A , PS_SET_CNTRL_REC S , PS_EN_IC_BOM_PRIV P WHERE S.SETCNTRLVALUE = P.BUSINESS_UNIT AND S.RECNAME = 'MASTER_ITEM_TBL' AND A.SETID = S.SETID AND P.INV_ITEM_ID = A.INV_ITEM_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: BU_ITEMS_INV_VW |
| 4 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: MG_ITEM_OWN_VW |
| 5 | BOM_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
03/26/00 RML Added a label "Type"
PR=Production RW=Rework |
| 6 | BOM_CODE |
Number(2,0) | SMALLINT NOT NULL | CN# EN800-3.0, anna 09/21 added new field to database |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 9 | EN_IC_MGBOM_READ | Character(1) | VARCHAR2(1) NOT NULL | test |
| 10 | EN_IC_MGBOM_UPD | Character(1) | VARCHAR2(1) NOT NULL | Vendor security to update mBOM - used by BOM Access by Vendor; currently not being used |
| 11 | EN_IC_BOM_READ | Character(1) | VARCHAR2(1) NOT NULL | Vendor security to read BOM |
| 12 | EN_IC_ECR_VIEW | Character(1) | VARCHAR2(1) NOT NULL | Vendor security to view ECR - used by BOM Access by Vendor |
| 13 | EN_IC_ECR_UPD | Character(1) | VARCHAR2(1) NOT NULL | Vendor security to update ECR - used by BOM Access by Vendor |
| 14 | EN_IC_ECO_VIEW | Character(1) | VARCHAR2(1) NOT NULL | Vendor security to view ECO - used by BOM Access by Vendor |
| 15 | EN_VND_APPR_ECO | Character(1) | VARCHAR2(1) NOT NULL | Created on 03/02/2000 RML Whether to notify vendor when an ECO is approved in Approve ECO. Option is to be added to BOM Access by Vendor under Maintain BOMs and Revs |
| 16 | EN_VND_NEW_ECO | Character(1) | VARCHAR2(1) NOT NULL | Created on 03/02/2000 RML Whether to notify vendor when a new ECO is created. Option is to be added to BOM Access by Vendor under Maintain BOMs and Revs |