VIEW: APPS.IGS_CO_TYPE_V

Source

View Text - Preformatted

SELECT ct.ROWID row_id, ct.correspondence_type, ct.description, ct.sys_generated_ind, ct.closed_ind, ct.created_by, ct.creation_date, ct.last_updated_by, ct.last_update_date, ct.last_update_login, ct.job_application_id, ct.job_program_id, app.application_name, con.user_concurrent_program_name FROM igs_co_type ct, fnd_application_tl app, fnd_concurrent_programs_tl con WHERE ct.job_application_id = app.application_id(+) AND app.language (+) = userenv('LANG') AND ct.job_program_id = con.concurrent_program_id(+) AND con.language (+) = userenv('LANG')

View Text - HTML Formatted

SELECT CT.ROWID ROW_ID
, CT.CORRESPONDENCE_TYPE
, CT.DESCRIPTION
, CT.SYS_GENERATED_IND
, CT.CLOSED_IND
, CT.CREATED_BY
, CT.CREATION_DATE
, CT.LAST_UPDATED_BY
, CT.LAST_UPDATE_DATE
, CT.LAST_UPDATE_LOGIN
, CT.JOB_APPLICATION_ID
, CT.JOB_PROGRAM_ID
, APP.APPLICATION_NAME
, CON.USER_CONCURRENT_PROGRAM_NAME
FROM IGS_CO_TYPE CT
, FND_APPLICATION_TL APP
, FND_CONCURRENT_PROGRAMS_TL CON
WHERE CT.JOB_APPLICATION_ID = APP.APPLICATION_ID(+)
AND APP.LANGUAGE (+) = USERENV('LANG')
AND CT.JOB_PROGRAM_ID = CON.CONCURRENT_PROGRAM_ID(+)
AND CON.LANGUAGE (+) = USERENV('LANG')