PROCESS_INSTANCEBUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUMGOP_NONVW
PRODUCTION_IDPrompt Table: SF_OP_MTN_VW
OP_SEQUENCECE_OP_LIST_VW(SQL View) |
Index Back |
|---|---|
Cost Management Operation List |
| select process_instance, business_unit, production_id, min(op_sequence) from PS_CE_OP_LIST_COPY group by process_instance, business_unit, production_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUMGOP_NONVW |
| 3 | PRODUCTION_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Production ID
Prompt Table: SF_OP_MTN_VW |
| 4 | OP_SEQUENCE |
Number(4,0) | SMALLINT NOT NULL | Operation Sequence |