BUSINESS_UNITPROCESS_INSTANCEBOM_STATEEN=Engineering
PR=Manufacturing
EN_BOM_DELV_VW(SQL View) |
Index Back |
|---|---|
BOM Expl/Verif vw10/11/99 lee 10/7/99 r-anrud-ev56c - lee - delete bom verification records. Note: this view contains a dummy field. It is needed to activate the save button when a fetch, w/no parms, and select all is performed. The code, using this field is in en_bom_delv_wrk.en_select_all_pb.fieldchange. |
| SELECT DISTINCT business_unit , process_instance , bom_state , 'Z' FROM PS_EN_BOM_EXPL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 3 | BOM_STATE |
Character(2) | VARCHAR2(2) NOT NULL |
BOM State
EN=Engineering PR=Manufacturing |
| 4 | DUMMY_FIELD | Character(1) | VARCHAR2(1) NOT NULL | Dummy Field for Hiding Groups |