PROBINSTPrompt Table: SP_PRBINS_NONVW
PL_SEQ_NBRDefault Value: 0
Prompt Table: PL_PLNPR_SEQ_VW
Prompt Table: SPL_PLNPRDBU_VW
SPL_PLNPRD_AVW(SQL View) |
Index Back |
|---|---|
Add view for planned prodKPN 12/13/02: Added |
| SELECT DISTINCT A.PROBINST , A.PL_SEQ_NBR , A.BUSINESS_UNIT FROM PS_PL_PLNPRD_HEADR A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROBINST |
Character(20) | VARCHAR2(20) NOT NULL |
Optimization Problem Instance
Prompt Table: SP_PRBINS_NONVW |
| 2 | PL_SEQ_NBR |
Number(9,0) | DECIMAL(9) NOT NULL |
01/09/02 EGS (CN#PL900-1): Added
Default Value: 0 Prompt Table: PL_PLNPR_SEQ_VW |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SPL_PLNPRDBU_VW |