DBA Data[Home] [Help]

VIEW: APPS.BIS_OBJ_PROG_LINKAGES_V

Source

View Text - Preformatted

SELECT lk.OBJECT_TYPE, lk.OBJECT_OWNER, lk.OBJECT_NAME, lk.CONC_PROGRAM_NAME, conc.USER_CONCURRENT_PROGRAM_NAME CONC_PROGRAM_LONGNAME, lk.CONC_APP_ID, lk.CONC_APP_SHORT_NAME, lk.ENABLED_FLAG, lk.CREATED_BY, lk.CREATION_DATE, lk.LAST_UPDATED_BY, lk.LAST_UPDATE_LOGIN, lk.LAST_UPDATE_DATE, lk.rowid row_id, lk.refresh_mode from bis_obj_prog_linkages lk, fnd_concurrent_programs_vl conc WHERE lk.conc_program_name = conc.concurrent_program_name(+) and lk.CONC_APP_ID = conc.application_id(+)
View Text - HTML Formatted

SELECT LK.OBJECT_TYPE
, LK.OBJECT_OWNER
, LK.OBJECT_NAME
, LK.CONC_PROGRAM_NAME
, CONC.USER_CONCURRENT_PROGRAM_NAME CONC_PROGRAM_LONGNAME
, LK.CONC_APP_ID
, LK.CONC_APP_SHORT_NAME
, LK.ENABLED_FLAG
, LK.CREATED_BY
, LK.CREATION_DATE
, LK.LAST_UPDATED_BY
, LK.LAST_UPDATE_LOGIN
, LK.LAST_UPDATE_DATE
, LK.ROWID ROW_ID
, LK.REFRESH_MODE
FROM BIS_OBJ_PROG_LINKAGES LK
, FND_CONCURRENT_PROGRAMS_VL CONC
WHERE LK.CONC_PROGRAM_NAME = CONC.CONCURRENT_PROGRAM_NAME(+)
AND LK.CONC_APP_ID = CONC.APPLICATION_ID(+)