ASSET_LOC_VW3_L

(SQL View)
 Index Back

Asset Current Location Lang


SELECT A.BUSINESS_UNIT , A.ASSET_ID , A.EFFDT , A.EFFSEQ , B.LANGUAGE_CD , B.DESCR , B.DESCR_AC , B.DESCRSHORT FROM PS_ASSET_LOCATION A , PS_LOCATION_LANG B , PS_SET_CNTRL_REC S WHERE A.EFFDT = ( SELECT MAX(EA.EFFDT) FROM PS_ASSET_LOCATION EA WHERE A.BUSINESS_UNIT = EA.BUSINESS_UNIT AND A.ASSET_ID = EA.ASSET_ID AND EA.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) AND S.RECNAME = 'LOCATION_TBL' AND S.SETCNTRLVALUE = A.BUSINESS_UNIT AND S.SETID = B.SETID AND B.LOCATION = A.LOCATION AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_LOCATION_TBL EB WHERE EB.SETID = B.SETID AND EB.LOCATION = B.LOCATION AND EB.EFFDT <= %CurrentDateIn)

  • Related Language Record for ASSET_LOC_VW3

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCR_AC Character(30) VARCHAR2(30) NOT NULL Alternate Description
    8 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description