Product: | OKL - Leasing and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_AM_RMK_ASSGN_UV |
SELECT DCTB.ROWID ROW_ID
, DCTB.ID ID
, DCTB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, DCTB.RMR_ID RMR_ID
, WFU.DISPLAY_NAME REMARKETER_NAME
, DCTB.ICO_ID ICO_ID
, FAC.DESCRIPTION FA_CATEGORY
, DCTB.ILN_ID ILN_ID
, FAL.SEGMENT1||'-'||FAL.SEGMENT2||'-'||FAL.SEGMENT3||'-'||FAL.SEGMENT4 FA_LOCATION
, DCTB.DATE_EFFECTIVE_FROM DATE_EFFECTIVE_FROM
, DCTB.DATE_EFFECTIVE_TO DATE_EFFECTIVE_TO
, DCTB.ORG_ID ORG_ID
, DCTB.CREATED_BY CREATED_BY
, DCTB.CREATION_DATE CREATION_DATE
, DCTB.LAST_UPDATED_BY LAST_UPDATED_BY
, DCTB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DCTB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_DF_CTGY_RMK_TMS DCTB
, OKL_AM_REMARKET_TEAMS_UV WFU
, OKL_AM_ITEM_CATEGORIES_UV FAC
, FA_LOCATIONS FAL
WHERE DCTB.RMR_ID = WFU.ORIG_SYSTEM_ID
AND DCTB.ICO_ID = FAC.CATEGORY_ID
AND DCTB.ILN_ID = FAL.LOCATION_ID (+)