OPRIDWORKSHEET_IDLINE_NBRFR_REPORT_ENTITYFR_WS_LOCK_VW(SQL View) |
Index Back |
|---|---|
Cash Flows Worksheet LinesCash Flows Worksheet Lines |
| SELECT C.OPRID , A.WORKSHEET_ID , A.LINE_NBR , C.FR_REPORT_ENTITY , MIN(B.FR_VALUE_LOCKED_SW) FROM PS_FR_WORKSHT_LN A , PS_FR_WORKSHT_LOCK B , PS_FR_WS_BU_SEL C WHERE B.WORKSHEET_ID = A.WORKSHEET_ID AND B.FR_ELEMENT_ID = A.FR_ELEMENT_ID AND C.WORKSHEET_ID = B.WORKSHEET_ID AND C.BUSINESS_UNIT = B.BUSINESS_UNIT GROUP BY C.OPRID, A.WORKSHEET_ID, A.LINE_NBR, C.FR_REPORT_ENTITY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | WORKSHEET_ID |
Character(20) | VARCHAR2(20) NOT NULL | Cash Flows Worksheet ID |
| 3 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 4 | FR_REPORT_ENTITY |
Character(20) | VARCHAR2(20) NOT NULL | Report Entity |
| 5 | FR_VALUE_LOCKED_SW | Character(1) | VARCHAR2(1) NOT NULL | Value locked |