VIEW: APPS.IGS_AS_CAL_CONF_V

Source

View Text - Preformatted

SELECT CF.ROWID ROW_ID, CF.S_CONTROL_NUM, CF.ASS_ITEM_CUTOFF_DT_ALIAS, ASS.DESCRIPTION ASS_ITEM_CUTOFF_DT_DESC, CF.MID_MGS_START_DT_ALIAS, MID_S.DESCRIPTION MID_MGS_START_DT_DESC, CF.MID_MGS_END_DT_ALIAS, MID_E.DESCRIPTION MID_MGS_END_DT_DESC, CF.EFINAL_MGS_START_DT_ALIAS, EFINAL_S.DESCRIPTION EFINAL_MGS_START_DT_DESC , CF.EFINAL_MGS_END_DT_ALIAS, EFINAL_E.DESCRIPTION EFINAL_MGS_END_DT_DESC, CF.FINAL_MGS_START_DT_ALIAS, FINAL_S.DESCRIPTION FINAL_MGS_START_DT_DESC, CF.FINAL_MGS_END_DT_ALIAS, FINAL_E.DESCRIPTION FINAL_MGS_END_DT_DESC, CF.CREATED_BY, CF.CREATION_DATE, CF.LAST_UPDATED_BY, CF.LAST_UPDATE_DATE, CF.LAST_UPDATE_LOGIN FROM IGS_AS_CAL_CONF CF, IGS_CA_DA ASS, IGS_CA_DA MID_S, IGS_CA_DA MID_E, IGS_CA_DA EFINAL_S, IGS_CA_DA EFINAL_E, IGS_CA_DA FINAL_S, IGS_CA_DA FINAL_E WHERE ASS.DT_ALIAS(+)=CF.ASS_ITEM_CUTOFF_DT_ALIAS AND MID_S.DT_ALIAS(+)=CF.MID_MGS_START_DT_ALIAS AND MID_E.DT_ALIAS(+)=CF.MID_MGS_END_DT_ALIAS AND FINAL_S.DT_ALIAS(+)=CF.FINAL_MGS_START_DT_ALIAS AND FINAL_E.DT_ALIAS(+)=CF.FINAL_MGS_END_DT_ALIAS AND EFINAL_S.DT_ALIAS(+)=CF.EFINAL_MGS_START_DT_ALIAS AND EFINAL_E.DT_ALIAS(+)=CF.EFINAL_MGS_END_DT_ALIAS

View Text - HTML Formatted

SELECT CF.ROWID ROW_ID
, CF.S_CONTROL_NUM
, CF.ASS_ITEM_CUTOFF_DT_ALIAS
, ASS.DESCRIPTION ASS_ITEM_CUTOFF_DT_DESC
, CF.MID_MGS_START_DT_ALIAS
, MID_S.DESCRIPTION MID_MGS_START_DT_DESC
, CF.MID_MGS_END_DT_ALIAS
, MID_E.DESCRIPTION MID_MGS_END_DT_DESC
, CF.EFINAL_MGS_START_DT_ALIAS
, EFINAL_S.DESCRIPTION EFINAL_MGS_START_DT_DESC
, CF.EFINAL_MGS_END_DT_ALIAS
, EFINAL_E.DESCRIPTION EFINAL_MGS_END_DT_DESC
, CF.FINAL_MGS_START_DT_ALIAS
, FINAL_S.DESCRIPTION FINAL_MGS_START_DT_DESC
, CF.FINAL_MGS_END_DT_ALIAS
, FINAL_E.DESCRIPTION FINAL_MGS_END_DT_DESC
, CF.CREATED_BY
, CF.CREATION_DATE
, CF.LAST_UPDATED_BY
, CF.LAST_UPDATE_DATE
, CF.LAST_UPDATE_LOGIN
FROM IGS_AS_CAL_CONF CF
, IGS_CA_DA ASS
, IGS_CA_DA MID_S
, IGS_CA_DA MID_E
, IGS_CA_DA EFINAL_S
, IGS_CA_DA EFINAL_E
, IGS_CA_DA FINAL_S
, IGS_CA_DA FINAL_E
WHERE ASS.DT_ALIAS(+)=CF.ASS_ITEM_CUTOFF_DT_ALIAS
AND MID_S.DT_ALIAS(+)=CF.MID_MGS_START_DT_ALIAS
AND MID_E.DT_ALIAS(+)=CF.MID_MGS_END_DT_ALIAS
AND FINAL_S.DT_ALIAS(+)=CF.FINAL_MGS_START_DT_ALIAS
AND FINAL_E.DT_ALIAS(+)=CF.FINAL_MGS_END_DT_ALIAS
AND EFINAL_S.DT_ALIAS(+)=CF.EFINAL_MGS_START_DT_ALIAS
AND EFINAL_E.DT_ALIAS(+)=CF.EFINAL_MGS_END_DT_ALIAS