PRCR_DS_REQ_VW(SQL View) |
Index Back |
|---|---|
Requisition Header ViewRequisition Header View Date Initials bug descr -----------------------------------------------------------------------------------------------------------------240112 anu 13603028 Ensuerd that the merchandise amount on requisition document status is correctly displayed with based on whether the req line is cancelled or not. 19/04/2012 Anu 13901964 We ensured that Cancelled requisition can be found on review requisition document status page. |
| SELECT A.BUSINESS_UNIT , A.REQ_ID , A.REQ_STATUS , A.HOLD_STATUS , A.REQ_DT , A.ORIGIN , A.REQUESTOR_ID , (CASE WHEN B.OPRDEFNDESC IS NOT NULL THEN B.OPRDEFNDESC ELSE A.REQUESTOR_ID END) , A.ENTERED_DT , A.APPROVAL_DT , A.BUDGET_HDR_STATUS , A.DST_CNTRL_ID , A.CURRENCY_CD , A.CURRENCY_CD_BASE , A.ACTIVITY_DATE ,SUM(CASE L.CURR_STATUS WHEN 'X' THEN 0 ELSE L.MERCHANDISE_AMT END) , SUM(CASE L.CURR_STATUS WHEN 'X' THEN 0 ELSE L.MERCH_AMT_BSE END) FROM (PS_REQ_HDR A LEFT OUTER JOIN PSOPRDEFN B ON A.REQUESTOR_ID = B.OPRID) , PS_REQ_LINE L WHERE A.BUSINESS_UNIT = L.BUSINESS_UNIT AND A.REQ_ID = L.REQ_ID GROUP BY A.BUSINESS_UNIT , A.REQ_ID , A.REQ_STATUS , A.HOLD_STATUS , A.REQ_DT , A.ORIGIN , A.REQUESTOR_ID ,B.OPRDEFNDESC , A.ENTERED_DT , A.APPROVAL_DT , A.BUDGET_HDR_STATUS , A.DST_CNTRL_ID , A.CURRENCY_CD , A.CURRENCY_CD_BASE , A.ACTIVITY_DATE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_PM_NONVW |
| 2 | REQ_ID |
Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 3 | REQ_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Req status
A=Approved C=Complete D=Denied I=Initial LA=Line Approved O=Open P=Pending Approval V=Preview X=Canceled |
| 4 | HOLD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Hold From Further Processing
Y/N Table Edit |
| 5 | REQ_DT | Date(10) | DATE NOT NULL | Requisition Date |
| 6 | ORIGIN | Character(3) | VARCHAR2(3) NOT NULL |
Origin
Prompt Table: ORIGIN_PO |
| 7 | REQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL |
Requestor id
Prompt Table: REQUESTOR_TBL |
| 8 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |
| 9 | ENTERED_DT | Date(10) | DATE | Entered on |
| 10 | APPROVAL_DT | Date(10) | DATE | Date of Approval |
| 11 | BUDGET_HDR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Budget Checking Header Status
E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid |
| 12 | DST_CNTRL_ID | Character(10) | VARCHAR2(10) NOT NULL | Accounting Template |
| 13 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 14 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 15 | ACTIVITY_DATE | Date(10) | DATE | Last Activity |
| 16 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 17 | MERCH_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Merchandise Amount |