PROCESS_INSTANCEPrompt Table: RS_CRAFT_DETAIL
WM_PMPJC_LBR_VW(SQL View) |
Index Back |
|---|---|
Projection Labor requirementsProjection Labor requirements |
| SELECT A.PROCESS_INSTANCE , B.CRAFT_ID , SUM (B.REQ_DURATION ) FROM PS_WM_PM_PJC A , PS_WM_PM_PJC_LBRRQ B WHERE A.PROCESS_INSTANCE = B.PROCESS_INSTANCE AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PJC_ID = B.PJC_ID AND A.CREATE_WO_FLG = 'Y' GROUP BY A.PROCESS_INSTANCE , B.CRAFT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | CRAFT_ID | Character(16) | VARCHAR2(16) NOT NULL |
Craft Identification
Prompt Table: RS_CRAFT_DETAIL |
| 3 | REQ_DURATION | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Schedule Duration |