WM_WO_ATLS_VW

(SQL View)
 Index Back

Tools View

This view is used for Entering Tools usage entry

SELECT W.OPRID , W.BUSINESS_UNIT , W.WO_ID , W.WO_TASK_ID , T.RES_LN_NBR , T.RQMT_LN_NBR , T.ASSET_TYPE , T.ASSET_SUBTYPE , T.MODEL , T.BUSINESS_UNIT_AM , T.MFG_ID , T.ASSET_ID , T.SCHED_START_DT , T.SCHED_START_TIME , T.SCHED_END_DT , T.SCHED_END_TIME , T.SCHED_COST_TLS , T.SCHED_DURATION , T.SCHED_USAGE , T.ACTL_START_DT , T.ACTL_START_TIME , T.ACTL_END_DT , T.ACTL_END_TIME , T.ACTL_DURATION , T.ACTL_COST_TLS , T.ACTL_USAGE , T.TOOL_COST_RATE , T.TOOL_BILL_RATE , T.CURRENCY_CD , T.TOOL_COST_RATE_ACT , T.TOOL_BILL_RATE_ACT , T.TOOL_UOM , T.TRANS_DT , T.ACCOUNTING_DT , T.ASSIGNMENT_ID , T.PROCURE_STATUS , T.MAX_DISTRIB_LINE , '2' , W.INTERNAL_STATUS , W.STATUS_CD FROM PS_WM_WOE_WB_VW W , PS_WM_WO_SCHED_TLS T WHERE W.BUSINESS_UNIT = T.BUSINESS_UNIT (+) AND W.WO_ID = T.WO_ID (+) AND W.WO_TASK_ID = T.WO_TASK_ID (+) AND NOT (W.INTERNAL_STATUS IN ('06','07') AND T.ASSET_ID IS NULL)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: WM_WOE_WRK.BUSINESS_UNIT

Prompt Table: SP_BU_WM_NONVW

3 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification

Prompt Table: WM_OPEN_WO_DV

4 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number

Prompt Table: WM_OPEN_TSK_DV

5 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.

Default Value: 0

Prompt Table: %EDIT_RES_LINE

6 RQMT_LN_NBR Number(5,0) INTEGER NOT NULL Requirement Line Number

Prompt Table: WM_WO_RQMT_TOOL

7 ASSET_TYPE Character(3) VARCHAR2(3) NOT NULL Asset Type
010=IT Hardware
020=IT Software
040=Equipment
050=Property
060=Fleet
070=Machinery
080=Furniture
090=Facility
100=Intangible
200=Asset Retirement Obligations
999=Other
8 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

Prompt Table: AM_SUBTYPE

9 MODEL Character(30) VARCHAR2(30) NOT NULL Model

Prompt Table: WM_ASSET_VW3

10 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

Prompt Table: SP_BU_AM_NONVW

11 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
12 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

Prompt Table: %EDITTABLE4

13 SCHED_START_DT Date(10) DATE Scheduled Start Date
14 SCHED_START_TIME Time(15) TIMESTAMP Schedule Start Time
15 SCHED_END_DT Date(10) DATE Scheduled End Date
16 SCHED_END_TIME Time(15) TIMESTAMP Schedule End Time
17 SCHED_COST_TLS Signed Number(28,3) DECIMAL(26,3) NOT NULL Schedule Tools Cost
18 SCHED_DURATION Signed Number(9,2) DECIMAL(7,2) NOT NULL Scheduled Duration
19 SCHED_USAGE Signed Number(9,2) DECIMAL(7,2) NOT NULL Scheduled Usage
20 ACTL_START_DT Date(10) DATE Actual Start Date
21 ACTL_START_TIME Time(15) TIMESTAMP Actual Start Time
22 ACTL_END_DT Date(10) DATE Actual End Date
23 ACTL_END_TIME Time(15) TIMESTAMP Actual End Time
24 ACTL_DURATION Signed Number(9,2) DECIMAL(7,2) NOT NULL Actual Duration
25 ACTL_COST_TLS Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual Tools Cost
26 ACTL_USAGE Signed Number(9,2) DECIMAL(7,2) NOT NULL Actual Usage
27 TOOL_COST_RATE Number(27,3) DECIMAL(26,3) NOT NULL Cost Rate
28 TOOL_BILL_RATE Number(27,3) DECIMAL(26,3) NOT NULL Billing Rate
29 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: BUS_UNIT_TBL_WM.BASE_CURRENCY

30 TOOL_COST_RATE_ACT Number(27,3) DECIMAL(26,3) NOT NULL Cost Rate

Default Value: WM_WO_ATLS_VW.TOOL_COST_RATE

31 TOOL_BILL_RATE_ACT Number(27,3) DECIMAL(26,3) NOT NULL Billing Rate

Default Value: WM_WO_ATLS_VW.TOOL_BILL_RATE

32 TOOL_UOM Character(3) VARCHAR2(3) NOT NULL Tools Unit of Measure
33 TRANS_DT Date(10) DATE Transaction Date

Default Value: %DATE

34 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

Default Value: %DATE

35 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID
36 PROCURE_STATUS Character(2) VARCHAR2(2) NOT NULL Indicates whether or not a Labor or a Tools resource in Maintenance Management is being procured.
1=No Procurement
2=Being Procured
37 MAX_DISTRIB_LINE Number(5,0) INTEGER NOT NULL Highest Distribution Line
38 RSRC_TYPE Character(1) VARCHAR2(1) NOT NULL Work Order Management Resource Types
1=Labor
2=Tools
3=Material

Default Value: 2

39 INTERNAL_STATUS Character(2) VARCHAR2(2) NOT NULL Internal Status
01=Open
02=Awaiting Schedule
03=Scheduled
04=Work In Progress
05=Complete
06=Closed
07=Canceled
08=On Hold
09=Work Order Created
40 STATUS_CD Character(4) VARCHAR2(4) NOT NULL User defined Status Code