PV_CHNG_XREF_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.BUSINESS_UNIT , A.PO_ID , B.REQ_ID , A.REVIEWED , A.REVIEWED_DT , A.OPRID_MODIFIED_BY , A.LAST_DTTM_UPDATE , A.APPROVED_FLG , A.OPRID , A.PROCESS_INSTANCE , PV.APPR_STATUS FROM PS_CHNG_RQST A ,PS_PO_LINE_DISTRIB B , PS_PV_CHNG_RST_DTL PV WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID AND A.BUSINESS_UNIT = PV.BUSINESS_UNIT AND A.PO_ID = PV.PO_ID AND A.CHNG_SOURCE = PV.CHNG_SOURCE AND A.CHNG_DTTM = PV.CHNG_DTTM AND PV.BUSINESS_UNIT = B.BUSINESS_UNIT AND PV.REQ_ID = B.REQ_ID AND B.REQ_ID <> ' ' AND B.LINE_NBR = ( SELECT MAX(C.LINE_NBR) FROM PS_PO_LINE_DISTRIB C WHERE A.PO_ID = C.PO_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND C.REQ_ID <> ' ') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PM_NONVW |
| 2 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 3 | REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 4 | REVIEWED | Character(1) | VARCHAR2(1) NOT NULL |
Review Complete
N=No Y=Yes Y/N Table Edit |
| 5 | REVIEWED_DT | Date(10) | DATE | Reviewed On |
| 6 | OPRID_MODIFIED_BY | Character(30) | VARCHAR2(30) NOT NULL | Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase. |
| 7 | LAST_DTTM_UPDATE | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 8 | APPROVED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Approved by Auditor
D=Denied N=Not Approved Y=Approved Y/N Table Edit |
| 9 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 10 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 11 | APPR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Approval status flag used on appr_inst_log and derived records to track virtual approver status
A=Approved D=Denied P=Pending |