Product: | MSC - Advanced Supply Chain Planning |
---|---|
Description: | |
Implementation/DBA Data: | APPS.MSC_APPS_INSTANCES_V |
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