SPF_PO_SRCH_VW (SQL View)	Index Back
PO ID Search VW Returns a list of Purchase Order IDs for work orders that have been released where time or progress logs may have been entered. This may include PO IDs associated with work order status in Pending Terminate, Terminated, Closed, Finalized, or Canceled. PO IDs associated with work order Status of Open, Submitted, Denied, and Approved are not included.

SPF_PO_SRCH_VW

(SQL View)

PO ID Search VW

Returns a list of Purchase Order IDs for work orders that have been released where time or progress logs may have been entered. This may include PO IDs associated with work order status in Pending Terminate, Terminated, Closed, Finalized, or Canceled. PO IDs associated with work order Status of Open, Submitted, Denied, and Approved are not included.

SELECT DISTINCT BUSINESS_UNIT , PO_ID FROM PS_SPF_WORDERREC WHERE WO_STATUS IN ('L','C','P','T') OR WORK_ORDER_ID IN ( SELECT W2.WORK_ORDER_ID FROM PS_SPF_WORDERREC W2 WHERE W2.WO_STATUS = 'N' AND W2.ACT_END_DT >= W2.START_DATE)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_SP_NONVW

2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_SP_NONVW
2	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order