SPF_INV_ID5_VW

(SQL View)
 Index Back

Invoice ID Lookup 5

This view returns the Invoice ID lookup values for the Supplier's Service Provider Contact that has access to approve the invoice Date Initials Reference # Description 031307 Raja 1604644002 The system sends email to user, if user configured only with Worklist. While submitting, approving or rejecting an invoice, email should be sent only if email routing preference is enabled on the user profile

SELECT DISTINCT R.ROLEUSER , D.INVOICE_ID FROM PS_SPF_INVOICE_DTL D , PSOPRALIAS A , PS_ROLEXLATOPR R WHERE D.INV_LINE_STATUS <> '1' AND (A.OPRID = D.SP_SUP_INVAPPROVER OR (A.PERSON_ID = D.SP_SUP_INVAPPROVER AND A.OPRALIASTYPE = 'SPP') OR A.OPRID IN ( SELECT DISTINCT U.OPRID FROM PS_EOAW_USERINST U WHERE U.EOAWUSER_TYPE = 'A' AND U.EOAWSTEP_INSTANCE IN ( SELECT EOAWSTEP_INSTANCE FROM PS_EOAW_STEPINST WHERE EOAWTHREAD_ID IN ( SELECT EOAWTHREAD_ID FROM PS_SPF_IN_APR_XREF WHERE EOAWPRCS_ID = 'SP_INVOICE' AND D.BUSINESS_UNIT = BUSINESS_UNIT AND D.INVOICE_ID = INVOICE_ID) AND EOAWPRCS_ID = 'SP_INVOICE'))) AND (R.ROLEUSER = A.OPRID OR R.ROLEUSER = ( SELECT R1.ROLEUSER_ALT FROM PS_ROLEXLATOPR R1 WHERE R1.ROLEUSER = A.OPRID AND D.SP_SUP_INVAPPROVER <> ' ' AND %CurrentDateIn BETWEEN R1.EFFDT_FROM AND R1.EFFDT_TO))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number