eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MSD_SR_SUP_ALL_V

Source

View Text - Preformatted


SELECT distinct '1.'||to_char(pvv.VENDOR_ID) LEVEL_VALUE_PK, pvv.VENDOR_NAME LEVEL_VALUE, pvv.VENDOR_NAME LEVEL_VALUE_DESC, to_char(MSD_SR_UTIL.get_all_geo_pk) PARENT_VALUE_PK, MSD_SR_UTIL.get_all_geo_desc PARENT_VALUE, MSD_SR_UTIL.get_all_geo_desc PARENT_VALUE_DESC, to_char(null) ATTRIBUTE1, to_char(null) ATTRIBUTE2, to_char(null) ATTRIBUTE3, to_char(null) ATTRIBUTE4, to_char(null) ATTRIBUTE5, flv.MEANING SYSTEM_ATTRIBUTE1, to_char(null) SYSTEM_ATTRIBUTE2, 2 DP_ENABLED_FLAG FROM fnd_lookup_values_vl flv, PO_VENDORS pvv WHERE FLV.LOOKUP_TYPE='MSD_LEVEL_VALUE_DESC' AND FLV.LOOKUP_CODE='S' UNION SELECT to_char(msd_sr_util.get_null_pk) LEVEL_VALUE_PK, msd_sr_util.get_null_desc LEVEL_VALUE, null LEVEL_VALUE_DESC, to_char(MSD_SR_UTIL.get_all_geo_pk) PARENT_VALUE_PK, MSD_SR_UTIL.get_all_geo_desc PARENT_VALUE, MSD_SR_UTIL.get_all_geo_desc PARENT_VALUE_DESC, null, null, null, null, null , to_char(null) SYSTEM_ATTRIBUTE1 , to_char(null) SYSTEM_ATTRIBUTE2 , 1 DP_ENABLED_FLAG FROM dual

View Text - HTML Formatted

SELECT DISTINCT '1.'||TO_CHAR(PVV.VENDOR_ID) LEVEL_VALUE_PK
, PVV.VENDOR_NAME LEVEL_VALUE
, PVV.VENDOR_NAME LEVEL_VALUE_DESC
, TO_CHAR(MSD_SR_UTIL.GET_ALL_GEO_PK) PARENT_VALUE_PK
, MSD_SR_UTIL.GET_ALL_GEO_DESC PARENT_VALUE
, MSD_SR_UTIL.GET_ALL_GEO_DESC PARENT_VALUE_DESC
, TO_CHAR(NULL) ATTRIBUTE1
, TO_CHAR(NULL) ATTRIBUTE2
, TO_CHAR(NULL) ATTRIBUTE3
, TO_CHAR(NULL) ATTRIBUTE4
, TO_CHAR(NULL) ATTRIBUTE5
, FLV.MEANING SYSTEM_ATTRIBUTE1
, TO_CHAR(NULL) SYSTEM_ATTRIBUTE2
, 2 DP_ENABLED_FLAG
FROM FND_LOOKUP_VALUES_VL FLV
, PO_VENDORS PVV
WHERE FLV.LOOKUP_TYPE='MSD_LEVEL_VALUE_DESC'
AND FLV.LOOKUP_CODE='S' UNION SELECT TO_CHAR(MSD_SR_UTIL.GET_NULL_PK) LEVEL_VALUE_PK
, MSD_SR_UTIL.GET_NULL_DESC LEVEL_VALUE
, NULL LEVEL_VALUE_DESC
, TO_CHAR(MSD_SR_UTIL.GET_ALL_GEO_PK) PARENT_VALUE_PK
, MSD_SR_UTIL.GET_ALL_GEO_DESC PARENT_VALUE
, MSD_SR_UTIL.GET_ALL_GEO_DESC PARENT_VALUE_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_CHAR(NULL) SYSTEM_ATTRIBUTE1
, TO_CHAR(NULL) SYSTEM_ATTRIBUTE2
, 1 DP_ENABLED_FLAG
FROM DUAL