WM_ASSET_LOC

(SQL View)
 Index Back

Asset Location


SELECT A.BUSINESS_UNIT , A.ASSET_ID , A.LOCATION , A.DOCUMENT_ID , A.AUTH_STATUS , A.AUTHORIZATION_NAME , A.AUTHORIZATION_DT FROM PS_ASSET_LOCATION A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_ASSET_LOCATION B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.ASSET_ID = A.ASSET_ID AND B.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(C.EFFSEQ) FROM PS_ASSET_LOCATION C WHERE C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.ASSET_ID = A.ASSET_ID AND C.EFFDT = A.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
3 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

4 DOCUMENT_ID Character(12) VARCHAR2(12) NOT NULL Document
5 AUTH_STATUS Character(1) VARCHAR2(1) NOT NULL Authorization Status
A=Authorized
N=Not Authorized
P=Authorization Pending
6 AUTHORIZATION_NAME Character(30) VARCHAR2(30) NOT NULL Authorization Name
7 AUTHORIZATION_DT Date(10) DATE Date Authorized