PO_RC_WB_AW_VW

(SQL View)

SELECT A.BUSINESS_UNIT ,A.PO_ID ,A.LINE_NBR ,A.EOAWPRCS_ID ,A.EOAWDEFN_ID ,A.EOAWTHREAD_ID ,B.EOAWSTEP_INSTANCE ,C.EOAWUSTEP_INST_ID ,C.OPRID ,C.EOAWSTEP_STATUS ,%Round(%DateTimeDiff(C.EOAWDTTM_MODIFIED,%currentdatetimein)/1440,0) FROM PS_PO_AW A , PS_EOAW_STEPINST B , PS_EOAW_USERINST C WHERE A.EOAWTHREAD_ID=( SELECT MAX(D.EOAWTHREAD_ID) FROM PS_PO_AW D WHERE D.EOAWPRCS_ID=A.EOAWPRCS_ID AND D.EOAWDEFN_ID=A.EOAWDEFN_ID AND D.BUSINESS_UNIT=A.BUSINESS_UNIT AND D.PO_ID=A.PO_ID AND D.LINE_NBR=A.LINE_NBR) AND B.EOAWTHREAD_ID=A.EOAWTHREAD_ID AND A.EOAWPRCS_ID=B.EOAWPRCS_ID AND A.EOAWDEFN_ID=B.EOAWDEFN_ID AND B.EOAWSTEP_STATUS= 'P' AND C.EOAWSTEP_STATUS='P' AND C.EOAWSTEP_INSTANCE=B.EOAWSTEP_INSTANCE ORDER BY A.PO_ID,A.LINE_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

4 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID

5 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID

6 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID

7 EOAWSTEP_INSTANCE Number(15,0) DECIMAL(15) NOT NULL Object id of a step instance. Generated off the main thread id for the approval process.

8 EOAWUSTEP_INST_ID Number(15,0) DECIMAL(15) NOT NULL Object id of a step instance. Generated off the main thread id for the approval process.

9 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

10 EOAWSTEP_STATUS Character(1) VARCHAR2(1) NOT NULL Step Instance Status
A=Approved
B=Pushed back
C=Auto Approved
D=Denied
E=Administrator denied
F=Deleted
G=Bypassed
H=On Hold
I=No Action Taken
K=Skipped
L=Terminated
M=Administrator approved
N=Not Active
P=Pending
R=No longer in role
T=Terminated
U=Auto approved
X=Deleted
Z=Pending Denial

11 NO_OF_DAYS Number(3,0) SMALLINT NOT NULL Used as criteria for the number of daily route scheduling option on the Route Calendar Maintenance Panel to determine every how many days calendar dates will be generated for the daily option.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
3	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
4	EOAWPRCS_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Process ID
5	EOAWDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Framework Definition ID
6	EOAWTHREAD_ID	Number(15,0)	DECIMAL(15) NOT NULL	Approval Framework Thread ID
7	EOAWSTEP_INSTANCE	Number(15,0)	DECIMAL(15) NOT NULL	Object id of a step instance. Generated off the main thread id for the approval process.
8	EOAWUSTEP_INST_ID	Number(15,0)	DECIMAL(15) NOT NULL	Object id of a step instance. Generated off the main thread id for the approval process.
9	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
10	EOAWSTEP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Step Instance Status A=Approved B=Pushed back C=Auto Approved D=Denied E=Administrator denied F=Deleted G=Bypassed H=On Hold I=No Action Taken K=Skipped L=Terminated M=Administrator approved N=Not Active P=Pending R=No longer in role T=Terminated U=Auto approved X=Deleted Z=Pending Denial
11	NO_OF_DAYS	Number(3,0)	SMALLINT NOT NULL	Used as criteria for the number of daily route scheduling option on the Route Calendar Maintenance Panel to determine every how many days calendar dates will be generated for the daily option.