SPA_SHEET_HDR_V

(SQL View)
 Index Back

Expenses for a WO

View to display Expenses for a given WO

SELECT DISTINCT B.BUSINESS_UNIT , A.SHEET_ID , A.SHEET_NAME , A.PERSON_ID , W.WORK_ORDER_ID , W.MRSC_PARENT_WOID , W.SUB_LINE FROM PS_SPA_SHEET_HDR A , PS_SPA_EXP_XREF B , PS_SPF_WORDERREC W WHERE A.SHEET_ID = B.SHEET_ID AND B.BUSINESS_UNIT = W.BUSINESS_UNIT AND B.WORK_ORDER_ID = W.WORK_ORDER_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
3 SHEET_NAME Character(30) VARCHAR2(30) NOT NULL Report Description
4 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
5 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
6 MRSC_PARENT_WOID Character(15) VARCHAR2(15) NOT NULL Multi Resource Parent WOID
7 SUB_LINE Character(1) VARCHAR2(1) NOT NULL Sub Line
N=No
Y=Yes