VIEW: APPS.OKL_AM_RMK_ASSGN_UV

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)