SPA_TM_WODIST_V

(SQL View)
Index Back

Timesheet Work Order Distrib


SELECT A.BUSINESS_UNIT ,A.TIME_SHEET_ID ,A.WORK_ORDER_ID ,A.DISTRIB_LINE_NUM ,A.LINE_NBR ,B.DESCR FROM PS_SPA_TIME_DTL A , PS_SPF_WOPO_DISTRB B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.WORK_ORDER_ID = B.WORK_ORDER_ID AND A.DISTRIB_LINE_NUM = B.DISTRIB_LINE_NUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 TIME_SHEET_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)
3 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
4 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
5 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description