VIEW: APPS.MSD_HIERARCHIES_LB_V

Source

View Text - Preformatted

SELECT mh.ROWID, mh.HIERARCHY_ID, mh.HIERARCHY_NAME, mh.DESCRIPTION, mh.DIMENSION_CODE, flv.meaning, mh.VALID_FLAG, ml.meaning, mh.LAST_UPDATE_DATE, mh.LAST_UPDATED_BY, mh.CREATION_DATE, mh.CREATED_BY, mh.LAST_UPDATE_LOGIN, mh.REQUEST_ID, mh.PROGRAM_APPLICATION_ID, mh.PROGRAM_ID, mh.PROGRAM_UPDATE_DATE, mh.ATTRIBUTE_CATEGORY, mh.ATTRIBUTE1, mh.ATTRIBUTE2, mh.ATTRIBUTE3, mh.ATTRIBUTE4, mh.ATTRIBUTE5, mh.ATTRIBUTE6, mh.ATTRIBUTE7, mh.ATTRIBUTE8, mh.ATTRIBUTE9, mh.ATTRIBUTE10, mh.ATTRIBUTE11, mh.ATTRIBUTE12, mh.ATTRIBUTE13, mh.ATTRIBUTE14, mh.ATTRIBUTE15 from fnd_lookup_values_vl flv, mfg_lookups ml, msd_hierarchies mh WHERE flv.lookup_code = mh.dimension_code and flv.lookup_type = 'MSD_DIMENSIONS_LB' and ml.lookup_code = mh.valid_flag and ml.lookup_type = 'SYS_YES_NO' and mh.plan_type = 'LIABILITY'

View Text - HTML Formatted

SELECT MH.ROWID
, MH.HIERARCHY_ID
, MH.HIERARCHY_NAME
, MH.DESCRIPTION
, MH.DIMENSION_CODE
, FLV.MEANING
, MH.VALID_FLAG
, ML.MEANING
, MH.LAST_UPDATE_DATE
, MH.LAST_UPDATED_BY
, MH.CREATION_DATE
, MH.CREATED_BY
, MH.LAST_UPDATE_LOGIN
, MH.REQUEST_ID
, MH.PROGRAM_APPLICATION_ID
, MH.PROGRAM_ID
, MH.PROGRAM_UPDATE_DATE
, MH.ATTRIBUTE_CATEGORY
, MH.ATTRIBUTE1
, MH.ATTRIBUTE2
, MH.ATTRIBUTE3
, MH.ATTRIBUTE4
, MH.ATTRIBUTE5
, MH.ATTRIBUTE6
, MH.ATTRIBUTE7
, MH.ATTRIBUTE8
, MH.ATTRIBUTE9
, MH.ATTRIBUTE10
, MH.ATTRIBUTE11
, MH.ATTRIBUTE12
, MH.ATTRIBUTE13
, MH.ATTRIBUTE14
, MH.ATTRIBUTE15
FROM FND_LOOKUP_VALUES_VL FLV
, MFG_LOOKUPS ML
, MSD_HIERARCHIES MH
WHERE FLV.LOOKUP_CODE = MH.DIMENSION_CODE
AND FLV.LOOKUP_TYPE = 'MSD_DIMENSIONS_LB'
AND ML.LOOKUP_CODE = MH.VALID_FLAG
AND ML.LOOKUP_TYPE = 'SYS_YES_NO'
AND MH.PLAN_TYPE = 'LIABILITY'