VIEW: APPS.MSC_APPS_INSTANCES_V

Source

View Text - Preformatted

SELECT a.INSTANCE_CODE, a.APPS_VER, L.meaning, a.INSTANCE_TYPE, a.DBS_VER, a.A2M_DBLINK, a.M2A_DBLINK, a.ENABLE_FLAG, a.LRID, a.LRTYPE, a.APPS_LRN, a.INSTANCE_ID, a.LCID, a.ST_STATUS, a.CLEANSED_FLAG, a.GMT_DIFFERENCE, a.LAST_UPDATE_DATE, a.LAST_UPDATED_BY, a.CREATION_DATE, a.CREATED_BY, a.LAST_UPDATE_LOGIN, a.REQUEST_ID, a.PROGRAM_APPLICATION_ID, a.PROGRAM_ID, a.PROGRAM_UPDATE_DATE, a.ATTRIBUTE_CATEGORY, a.ATTRIBUTE1, a.ATTRIBUTE2, a.ATTRIBUTE3, a.ATTRIBUTE4, a.ATTRIBUTE5, a.ATTRIBUTE6, a.ATTRIBUTE7, a.ATTRIBUTE8, a.ATTRIBUTE9, a.ATTRIBUTE10, a.ATTRIBUTE11, a.ATTRIBUTE12, a.ATTRIBUTE13, a.ATTRIBUTE14, a.ATTRIBUTE15, a.currency from msc_apps_instances a, mfg_lookups l WHERE l.lookup_type = 'MSC_APPS_VERSION' and l.lookup_code = a.apps_ver

View Text - HTML Formatted

SELECT A.INSTANCE_CODE
, A.APPS_VER
, L.MEANING
, A.INSTANCE_TYPE
, A.DBS_VER
, A.A2M_DBLINK
, A.M2A_DBLINK
, A.ENABLE_FLAG
, A.LRID
, A.LRTYPE
, A.APPS_LRN
, A.INSTANCE_ID
, A.LCID
, A.ST_STATUS
, A.CLEANSED_FLAG
, A.GMT_DIFFERENCE
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.REQUEST_ID
, A.PROGRAM_APPLICATION_ID
, A.PROGRAM_ID
, A.PROGRAM_UPDATE_DATE
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.CURRENCY
FROM MSC_APPS_INSTANCES A
, MFG_LOOKUPS L
WHERE L.LOOKUP_TYPE = 'MSC_APPS_VERSION'
AND L.LOOKUP_CODE = A.APPS_VER