SPF_PEXP_SRCH_V (SQL View)	Index Back
Plog Expense Search View Returns the available Progress Log related Expense Sheet IDs as part of the search view for Invoices

SPF_PEXP_SRCH_V

(SQL View)

Plog Expense Search View

Returns the available Progress Log related Expense Sheet IDs as part of the search view for Invoices

SELECT DISTINCT D.BUSINESS_UNIT , X.SHEET_ID FROM PS_SPA_EXP_XREF X , PS_SPA_PLOG_DTL D WHERE D.BUSINESS_UNIT = X.BUSINESS_UNIT AND D.WORK_ORDER_ID = X.WORK_ORDER_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: BUS_UNIT_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_SP_NONVW

2 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID