DBA Data[Home] [Help]

VIEW: APPS.IGS_PS_FAC_OVR_WL_V

Source

View Text - Preformatted

SELECT FOW.ROWID ROW_ID, FOW.FAC_OVR_WL_ID, FOW.FAC_WL_ID, FOW.START_DATE, FOW.END_DATE, FOW.NEW_EXP_WL, FOW.OVERRIDE_REASON, WOR.DESCRIPTION, FOW.CREATED_BY, FOW.CREATION_DATE, FOW.LAST_UPDATED_BY, FOW.LAST_UPDATE_DATE, FOW.LAST_UPDATE_LOGIN FROM IGS_PS_FAC_OVR_WL FOW, IGS_PS_WL_OVER_RESN WOR WHERE FOW.OVERRIDE_REASON = WOR.OVERRIDE_REASON
View Text - HTML Formatted

SELECT FOW.ROWID ROW_ID
, FOW.FAC_OVR_WL_ID
, FOW.FAC_WL_ID
, FOW.START_DATE
, FOW.END_DATE
, FOW.NEW_EXP_WL
, FOW.OVERRIDE_REASON
, WOR.DESCRIPTION
, FOW.CREATED_BY
, FOW.CREATION_DATE
, FOW.LAST_UPDATED_BY
, FOW.LAST_UPDATE_DATE
, FOW.LAST_UPDATE_LOGIN
FROM IGS_PS_FAC_OVR_WL FOW
, IGS_PS_WL_OVER_RESN WOR
WHERE FOW.OVERRIDE_REASON = WOR.OVERRIDE_REASON