INV_EXP_ORD_VW (SQL View)	Index Back
Expense Issue Order Number This view selects the Order information from the Transaction_inv record for expense issue transactions.

INV_EXP_ORD_VW

(SQL View)

Expense Issue Order Number

This view selects the Order information from the Transaction_inv record for expense issue transactions.

SELECT DISTINCT A.ORDER_NO FROM PS_ISSUE_HDR_INV A , PS_TRANSACTION_INV B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.ORDER_NO = B.ORDER_NO AND B.TRANSACTION_GROUP = '036' AND A.DEMAND_SOURCE IN ('IN', 'PO', 'PR') AND A.INTERNAL_FLG = 'Y' AND A.FULFILL_FLAG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop