|
SELECT D.LS_KEY , D.ASSET_SEQ_NBR , D.LS_MAP_ID , %Coalesce(B.PROPERTY_ID,0) , D.OCCUPANCY_DT , D.PPTY_RENT_AREA , D.PPTY_USE_AREA , D.BUSINESS_UNIT_AM , D.ASSET_ID , A.DESCR , CASE WHEN (E.PROFILE_ID2 IS NULL OR E.PROFILE_ID2 = ' ') THEN A.PROFILE_ID ELSE E.PROFILE_ID2 END , A.ASSET_TYPE , A.ASSET_SUBTYPE , (%Coalesce ( (SELECT C.LOCATION2 FROM PS_RE_ASSET_LOC_VW C WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT_AM AND A.ASSET_ID = C.ASSET_ID ), ' ')) AS LOCATION , (%Coalesce ( (SELECT C.AREA_ID FROM PS_RE_ASSET_LOC_VW C WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT_AM AND A.ASSET_ID = C.ASSET_ID ), ' ')) AS AREA_ID , A.TAG_NUMBER , A.SERIAL_ID , A.CAP_NUM , A.CAP_SEQUENCE , D.EST_LIFE , D.COST , D.CURRENCY_CD , %Coalesce(B.PROPERTY_DESCR, ' ') , %Coalesce(B.PROPERTY_NM, ' ') , %Coalesce(B.PROPERTY_CLASS, ' ' ) , %Coalesce(B.PARENT_PROPERTY_ID, 0) , B.SPACE_UOM , D.FMV , D.GUAR_RESIDUAL , D.XFER_OF_OWNERSHIP , D.AMT_PURCHASE_OPT , D.QUANTITY , D.CAP_LEASE_AMT , D.ISNEW_FLAG , D.DST_ALLOC_METHOD , CASE WHEN (E.CATEGORY_2 IS NULL OR E.CATEGORY_2 = ' ') THEN D.CATEGORY ELSE E.CATEGORY_2 END , D.TRANS_CODE , D.PRORATION_RATE , D.ASSET_CLASSIFY , D.ALLOC_IDC , D.STLINE_PRORATE_RT , D.IDC_PRORATION_RATE , D.PB_REVIEW , D.DISCOUNTED_PVLP , D.ADJUSTED_PV_MLP , D.ALLOC_LS_PAYMENTS , D.INITIAL_DIRECT_CST , D.LEASE_INCENTIVE , D.EXISTING_ASSET , D.SUGGESTED_ALLOC , D.CURRENT_LS_PAYMENT , D.PVLP_STLINE_RATE , D.AMOUNT_ALLOC_GUAR , D.RT_EFFDT , D.RATE_MULT , D.RATE_DIV , D.DECREASE_ROU , D.DECREASE_SCOPE_PER , D.RET_ENTERED_AMT , D.RETIRE_QTY , D.RETIRE_CURR_CD , D.PPTY_RETIRE_AREA , D.TXN_REMOVAL_COST , D.REMOVAL_CURR_CD , D.DISPOSAL_CODE , D.CONVENTION , D.TOTAL_AMOUNT_LO , D.TOTAL_AMOUNT_REXP , D.TOTAL_AMOUNT_INC , D.TOTAL_AMT_LO_BSE , D.TOTAL_AMT_REXP_BSE , D.TOTAL_AMT_INC_BSE , D.ASSET_COST_BSE , D.RET_PAY_AMT , D.RET_LO_AMT , D.RET_EXP_AMT , D.RET_INC_AMT , D.RET_REC_AMT , D.RET_GL_AMT , D.RET_PAY_AMT_BSE , D.RET_LO_AMT_BSE , D.RET_EXP_AMT_BSE , D.RET_INC_AMT_BSE , D.RET_REC_AMT_BSE , D.TOT_RET_PAY_AMT , D.TOT_RET_LO_AMT , D.TOT_RET_EXP_AMT , D.TOT_RET_INC_AMT , D.TOT_RET_REM_AMT , D.TOT_RET_LO_AMT_BSE , D.TOT_RET_EX_AMT_BSE , D.TOT_RET_IN_AMT_BSE , D.ADJ_AMOUNT_GA_LS , D.ADJ_AMT_GA_LS_A1 , D.ADJ_AMT_GA_LS_REXP , D.ADJ_AMT_GA_LS_INC , D.TOTAL_AMT_AA_GA_LS , D.TOTAL_AMT_A1_GA_LS , D.TOTAL_AMT_RE_GA_LS , D.TOTAL_AMT_IN_GA_LS , D.CF_SEQNO , D.CF_SEQNO_GL , D.CF_SEQNO_EXP , D.CF_SEQNO_INC , D.CF_SEQNO_REC FROM PS_ASSET_PROPERTY B RIGHT OUTER JOIN PS_ASSET A ON A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.ASSET_ID = B.ASSET_ID LEFT OUTER JOIN PS_RE_LS_PPTY D ON A.ASSET_ID = D.ASSET_ID AND A.BUSINESS_UNIT = D.BUSINESS_UNIT_AM LEFT OUTER JOIN PS_RE_LS_PRFCTG E ON E.BUSINESS_UNIT_AM = D.BUSINESS_UNIT_AM AND E.ASSET_ID = D.ASSET_ID
|
LS_KEY