BI_APPRV_NM_VW(SQL View) |
Index Back |
|---|
| SELECT h.business_unit , h.invoice , C.OPRID , O.OPRDEFNDESC FROM PS_BI_PEND_VW1 H ,PS_BI_AW_XREF A , PSOPRDEFN O ,PS_EOAW_STEPINST B LEFT OUTER JOIN PS_EOAW_USERINST C ON B.EOAWSTEP_INSTANCE = C.EOAWSTEP_INSTANCE WHERE A.EOAWTHREAD_ID=B.EOAWTHREAD_ID AND A.EOAWPRCS_ID=B.EOAWPRCS_ID AND A.EOAWDEFN_ID=B.EOAWDEFN_ID AND C.EOAWSTEP_STATUS = 'P' AND H.BUSINESS_UNIT = A.BUSINESS_UNIT AND H.INVOICE = A.INVOICE AND C.OPRID = O.OPRID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | APPROVER_NAME | Character(50) | VARCHAR2(50) NOT NULL | Approver |