ASSET_LOC_SVW (SQL View)	Index Back
Asset Location View for PTSF Asset current location view for PTSF

ASSET_LOC_SVW

(SQL View)

Asset Location View for PTSF

Asset current location view for PTSF

SELECT A.BUSINESS_UNIT , A.ASSET_ID , A.EFFDT , A.EFFSEQ , A.LOCATION , A.AREA_ID 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 EFFDT Date(10) DATE Effective Date
Default Value: %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 AREA_ID Character(10) VARCHAR2(10) NOT NULL Area ID
Prompt Table: AM_AREA_TBL

#	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	EFFDT	Date(10)	DATE	Effective Date Default Value: %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	AREA_ID	Character(10)	VARCHAR2(10) NOT NULL	Area ID Prompt Table: AM_AREA_TBL