SPF_WO_SP_VW

(SQL View)
Index Back

Service Performed location vw

View that is created to use as search record in Service Performed Location page(SPF_WO_SP_ADDR_PG)

SELECT BUSINESS_UNIT , WORK_ORDER_ID , WO_NAME FROM PS_SPF_WORDERREC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_SP_NONVW

2 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID

Default Value: NEXT

3 WO_NAME Character(30) VARCHAR2(30) NOT NULL Work Order Name