PROBINSTPrompt Table: SP_PRBINS_NONVW
BUSINESS_UNITPrompt Table: PL_PLNPOBU_VW
PL_SEQ_NBRDefault Value: 0
PL_PLN_PO_ADDVW(SQL View) |
Index Back |
|---|---|
Planned Purchase Orde add viewPlanned Purchase Orde add view |
| SELECT DISTINCT A.PROBINST , B.BUSINESS_UNIT , A.PL_SEQ_NBR FROM PS_PL_PLN_PO A , PS_PL_PURCHASE_OPT B WHERE A.PROBINST = B.PROBINST |
| # | 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 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: PL_PLNPOBU_VW |
| 3 | PL_SEQ_NBR |
Number(9,0) | DECIMAL(9) NOT NULL |
01/09/02 EGS (CN#PL900-1): Added
Default Value: 0 |