SP_CHNG_TRK2_VW

(SQL View)
 Index Back

Change tracking inquiry view

Change tracking inquiry view for sPro req line

SELECT DISTINCT A.BUSINESS_UNIT , A.REQ_ID , A.REQ_NAME , A.REQUESTOR_ID , B.LAST_DTTM_UPDATE , B.OPRID_MODIFIED_BY , B.CHNG_ORD_BATCH FROM PS_REQ_HDR A , PS_PV_REQ_LN_XREF X , PS_SPREQ_CHNG_LINE B , PS_REQ_CHNG_ORD C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.ORIG_TRAN='EPO' AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.REQ_ID = X.REQ_ID AND B.SP_REQ_ID = X.SP_REQ_ID AND A.BUSINESS_UNIT = X.BUSINESS_UNIT AND C.REQ_ID = A.REQ_ID AND B.CHNG_ORD_BATCH = C.CHNG_ORD_BATCH AND C.CHNG_ORD_BATCH = ( SELECT MAX(D.CHNG_ORD_BATCH) FROM PS_SPREQ_CHNG_LINE D WHERE D.BUSINESS_UNIT = C.BUSINESS_UNIT AND D.SP_REQ_ID = X.SP_REQ_ID AND C.REQ_ID = X.REQ_ID AND C.BUSINESS_UNIT = X.BUSINESS_UNIT) AND NOT EXISTS ( SELECT 'X' FROM PS_PV_CHNG_TRK1_VW A1 WHERE A.BUSINESS_UNIT = A1.BUSINESS_UNIT AND A.REQ_ID = A1.REQ_ID AND A.ORIG_TRAN='EPO')

# 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 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
3 REQ_NAME Character(30) VARCHAR2(30) NOT NULL Requisition Name
4 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id

Prompt Table: %EDITTABLE16

5 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.
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 CHNG_ORD_BATCH Number(3,0) SMALLINT NOT NULL Change Order Number