RE_LSABU_PTY_LG

(SQL View)
 Index Back

RE Asset Properties Amend.

RE Asset Properties Amendement Related Language

SELECT P.BUSINESS_UNIT , Z.LS_KEY , P.ASSET_ID , P.LANGUAGE_CD , P.PROPERTY_ID , P.PROPERTY_NM , P.PROPERTY_DESCR FROM PS_ASSET_PROP_LG P , PS_ASSET A , PS_RE_LSA_PPTY Z , PS_RE_LSA X WHERE P.BUSINESS_UNIT = A.BUSINESS_UNIT AND P.ASSET_ID = A.ASSET_ID AND P.PROPERTY_ID = Z.PROPERTY_ID AND A.ASSET_STATUS = 'I' AND X.LS_KEY = Z.LS_KEY AND X.AMND_NBR = Z.AMND_NBR AND X.AMND_STATUS = '1'

  • Related Language Record for RE_LSA_BU_PPTY

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_AM_NONVW

    2 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key
    3 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

    Prompt Table: ASSET

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Property ID
    6 PROPERTY_NM Character(50) VARCHAR2(50) NOT NULL Used to store an Asset Property Name
    7 PROPERTY_DESCR Character(50) VARCHAR2(50) NOT NULL Property Description