WM_TLS_LOC_VW

(SQL View)
 Index Back

Work Order Tool Location


SELECT W.BUSINESS_UNIT , W.WO_ID , W.WO_TASK_ID , L.ASSET_ID , L.LOCATION FROM PS_WM_WO_SCHED_TLS W , PS_ASSET_LOCATION L WHERE W.BUSINESS_UNIT_AM = L.BUSINESS_UNIT AND W.ASSET_ID = L.ASSET_ID AND L.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ASSET_LOCATION A WHERE A.BUSINESS_UNIT = L.BUSINESS_UNIT AND A.ASSET_ID = L.ASSET_ID AND EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_ASSET_LOCATION B WHERE B.BUSINESS_UNIT = L.BUSINESS_UNIT AND B.ASSET_ID = L.ASSET_ID))

# 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_WM_NONVW

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

Prompt Table: WM_WOT_OPEN_VW

3 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number
4 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

Prompt Table: ASSET

5 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL