USERIDBUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
PLOG_IDSPA_E_PLGAPR_VW(SQL View) |
Index Back |
|---|
| SELECT O.ROLEUSER , W.BUSINESS_UNIT , P.PLOG_ID , P.VENDOR_ID , V.VENDOR_NAME_SHORT , P.CREATION_DT , SUM(D.SP_BILL_AMOUNT_BSE) , D.CURRENCY_CD_BASE FROM PS_SPF_WORDERREC W , PS_SPA_PLOG_HDR P , PS_SPA_PLOG_DTL D , PS_VENDOR V , PS_SET_CNTRL_GROUP S , PS_ROLEXLATOPR O WHERE W.BUSINESS_UNIT = P.BUSINESS_UNIT AND P.PLOG_ID =D.PLOG_ID AND W.WORK_ORDER_ID = D.WORK_ORDER_ID AND P.PLOG_STATUS IN ('OPN', 'SUB') AND V.VENDOR_ID = W.VENDOR_ID AND W.BUSINESS_UNIT = S.SETCNTRLVALUE AND S.REC_GROUP_ID = 'FS_38' AND S.SETID = V.SETID AND (O.ROLEUSER IN ( SELECT C.OPRID FROM PS_SPA_PL_APR_XREF A , PS_EOAW_STEPINST B , PS_EOAW_USERINST C WHERE A.EOAWDEFN_ID = B.EOAWDEFN_ID AND A.EOAWPRCS_ID = B.EOAWPRCS_ID AND A.EOAWTHREAD_ID = B.EOAWTHREAD_ID AND B.EOAWSTEP_INSTANCE = C.EOAWSTEP_INSTANCE AND A.BUSINESS_UNIT = P.BUSINESS_UNIT AND A.PLOG_ID = P.PLOG_ID)) GROUP BY O.ROLEUSER , W.BUSINESS_UNIT , P.PLOG_ID , P.VENDOR_ID , V.VENDOR_NAME_SHORT ,P.CREATION_DT , D.CURRENCY_CD_BASE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | USERID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT |
| 3 | PLOG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Time Sheet Unique Identifier (System Generated) |
| 4 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 5 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |
| 6 | CREATION_DT | Date(10) | DATE | Creation Date |
| 7 | SP_BILL_AMOUNT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Time and Expense amount reported in the base currency |
| 8 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |