ASSET_LOC_VW

(SQL View)
 Index Back

Asset Current Location


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

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

2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
3 LOCATION_EFFDT Date(10) DATE Location Effective Date
4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

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

Prompt Table: AM_AREA_TBL

11 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
12 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time