SCP_RCPOSHP_VW4

(SQL View)
 Index Back

Supplier User

Supplier User

SELECT A.VENDOR_SETID ,A.VENDOR_ID ,A.GROUP_NAME ,A.OPRID ,COUNT(A.PO_ID) FROM PS_SCP_RCPOSHP_VW3 A , PS_SCP_USR_PRF_FL C WHERE A.DUE_DT < %CurrentDateIn AND C.OPRID = A.OPRID AND C.SCP_TRANS_TYPE = 4 AND C.FIELD_NAME = 'NUM_DAYS_PO_OVRDUE' AND (%CurrentDateIn - %DatePart(A.DATETIME_DISP) ) >=0 AND (%CurrentDateIn - %DatePart(A.DATETIME_DISP) ) <=FIELDNUM GROUP BY A.VENDOR_SETID ,A.vendor_id ,A.GROUP_NAME,A.OPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 GROUP_NAME Character(30) VARCHAR2(30) NOT NULL Group Name
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 COUNT1 Number(10,0) DECIMAL(10) NOT NULL Counter