PV_REQ_APPR_VW2(SQL View) |
Index Back |
|---|
| SELECT H.BUSINESS_UNIT , H.REQ_ID , H.REQ_DT , H.CURRENCY_CD , SUM (L.MERCHANDISE_AMT) FROM PS_REQ_HDR H , PS_REQ_LINE L WHERE H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.REQ_ID = L.REQ_ID AND L.CURR_STATUS <> 'X' GROUP BY H.BUSINESS_UNIT, H.REQ_ID, H.REQ_DT, H.CURRENCY_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 3 | REQ_DT | Date(10) | DATE | Requisition Date |
| 4 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 5 | REQ_TOTAL | Signed Number(30,5) | DECIMAL(28,5) NOT NULL | Requisition Total |