RUN_CNTL_IDPROCESS_INSTANCEPrompt Table: EN_BOM_EXPL
BUSINESS_UNITEN=Engineering
PR=Manufacturing
EG_BOM_EXPL_VW(SQL View) |
Index Back |
|---|---|
EBOM Explosion result View |
| select distinct a.run_cntl_id, b.process_instance, b.business_unit, b.bom_state from PS_EN_BOM_EXPL_REQ a, ps_en_bom_expl b where a.process_instance = b.process_instance and a.bom_state = 'EN' and b.bom_state = a.bom_state |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 2 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL |
Process Instance
Prompt Table: EN_BOM_EXPL |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | BOM_STATE | Character(2) | VARCHAR2(2) NOT NULL |
BOM State
EN=Engineering PR=Manufacturing |