SPF_INV_ID4_VW

(SQL View)
 Index Back

Invoice ID Lookup 4

This view returns the Invoice ID lookup values for the Enterprise Invoice Approver that has access to approve the invoice if a Business Unit is not first selected as a prompt criteria 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.BUSINESS_UNIT , D.INVOICE_ID , B.DESCR FROM PS_SPF_INVOICE_HDR H , PS_SPF_INVOICE_DTL D , PS_SPF_WORDERREC W , PS_BUS_UNIT_TBL_FS B , PS_ROLEXLATOPR R WHERE B.BUSINESS_UNIT = H.BUSINESS_UNIT AND H.BUSINESS_UNIT = D.BUSINESS_UNIT AND H.INVOICE_ID = D.INVOICE_ID AND D.BUSINESS_UNIT = W.BUSINESS_UNIT AND D.WORK_ORDER_ID = W.WORK_ORDER_ID AND D.INV_LINE_STATUS <> '1' AND (R.ROLEUSER = W.WO_CLIID OR R.ROLEUSER = ( SELECT R1.ROLEUSER_ALT FROM PS_ROLEXLATOPR R1 WHERE R1.ROLEUSER = W.WO_CLIID AND %CurrentDateIn BETWEEN R1.EFFDT_FROM AND R1.EFFDT_TO))

  • Related Language Record: SPF_INV_ID4_LNG

    • # 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description