PR_APPRVL_SRCH

(SQL View)
 Index Back

Payment Request

Main Record

SELECT a.REQUEST_ID , d.OPRID , a.BUSINESS_UNIT , a.oprid , a.ENTERED_DTTM , a.INVOICE_ID , a.INVOICE_DT , a.VENDOR_ID , a.NAME1 , a.DESCR50 , a.GROSS_AMT , a.TXN_CURRENCY_CD , a.PR_STATUS FROM PS_PR_REQUEST a , PS_PR_REQUEST_xref b , ps_eoaw_stepinst c , ps_eoaw_userinst d WHERE a.PR_STATUS = '4' AND NOT EXISTS ( SELECT 'X' FROM PS_PR_TEMPLATE e WHERE e.PR_TEMPLATE_ID = a.PR_TEMPLATE_ID AND e.PR_WORKFLOW_OPT = 'N') AND a.request_id = b.request_id AND b.eoawthread_id=c.eoawthread_id AND b.eoawprcs_id=c.eoawprcs_id AND b.eoawdefn_id=c.eoawdefn_id AND c.eoawstep_instance = d.eoawstep_instance AND (A.PR_STATUS = '4' AND c.eoawSTEP_STATUS IN ('P','H'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID

Prompt Table: PR_APPRVL_SRCH

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

Default Value: OPR_DEF_TBL_AP.OPRID

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

Prompt Table: SP_BUS_AP_NONVW

4 ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered by
5 ENTERED_DTTM DateTime(26) TIMESTAMP Entered Datetime
6 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
7 INVOICE_DT Date(10) DATE Invoice Date
8 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
9 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
10 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
11 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
12 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

Prompt Table: CURR_TXN_VW

13 PR_STATUS Character(1) VARCHAR2(1) NOT NULL To detemine Payment Request Status
1=New
2=Denied
3=Submitted
4=Pending
5=Approved
6=Vouchered
7=Cancelled