VIEW: APPS.MSD_SR_LOC_SUP_V

Source

View Text - Preformatted

SELECT '1.'||to_char(pvsa.VENDOR_SITE_ID) LEVEL_VALUE_PK, pvv.VENDOR_NAME || ':' || pvv.SEGMENT1 || ':' || pvsa.VENDOR_SITE_CODE LEVEL_VALUE, pvv.VENDOR_NAME || ':' || pvv.SEGMENT1 || ':' || pvsa.VENDOR_SITE_CODE LEVEL_VALUE_DESC, '1.'||to_char(pvsa.VENDOR_ID) PARENT_VALUE_PK, pvv.VENDOR_NAME PARENT_VALUE, pvv.VENDOR_NAME 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_VENDOR_SITES_ALL pvsa, PO_VENDORS pvv WHERE FLV.LOOKUP_TYPE='MSD_LEVEL_VALUE_DESC' AND FLV.LOOKUP_CODE='S' AND pvsa.VENDOR_ID= pvv.VENDOR_ID UNION SELECT to_char(msd_sr_util.get_null_pk) LEVEL_VALUE_PK, msd_sr_util.get_null_desc LEVEL_VALUE, null, to_char(msd_sr_util.get_null_pk) PARENT_VALUE_PK, msd_sr_util.get_null_desc PARENT_VALUE, null, null ATTRIBUTE1, null ATTRIBUTE2, null ATTRIBUTE3, null ATTRIBUTE4, null ATTRIBUTE5, to_char(null) SYSTEM_ATTRIBUTE1, to_char(null) SYSTEM_ATTRIBUTE2, 1 DP_ENABLED_FLAG FROM dual

View Text - HTML Formatted

SELECT '1.'||TO_CHAR(PVSA.VENDOR_SITE_ID) LEVEL_VALUE_PK
, PVV.VENDOR_NAME || ':' || PVV.SEGMENT1 || ':' || PVSA.VENDOR_SITE_CODE LEVEL_VALUE
, PVV.VENDOR_NAME || ':' || PVV.SEGMENT1 || ':' || PVSA.VENDOR_SITE_CODE LEVEL_VALUE_DESC
, '1.'||TO_CHAR(PVSA.VENDOR_ID) PARENT_VALUE_PK
, PVV.VENDOR_NAME PARENT_VALUE
, PVV.VENDOR_NAME 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_VENDOR_SITES_ALL PVSA
, PO_VENDORS PVV
WHERE FLV.LOOKUP_TYPE='MSD_LEVEL_VALUE_DESC'
AND FLV.LOOKUP_CODE='S'
AND PVSA.VENDOR_ID= PVV.VENDOR_ID UNION SELECT TO_CHAR(MSD_SR_UTIL.GET_NULL_PK) LEVEL_VALUE_PK
, MSD_SR_UTIL.GET_NULL_DESC LEVEL_VALUE
, NULL
, TO_CHAR(MSD_SR_UTIL.GET_NULL_PK) PARENT_VALUE_PK
, MSD_SR_UTIL.GET_NULL_DESC PARENT_VALUE
, NULL
, NULL ATTRIBUTE1
, NULL ATTRIBUTE2
, NULL ATTRIBUTE3
, NULL ATTRIBUTE4
, NULL ATTRIBUTE5
, TO_CHAR(NULL) SYSTEM_ATTRIBUTE1
, TO_CHAR(NULL) SYSTEM_ATTRIBUTE2
, 1 DP_ENABLED_FLAG
FROM DUAL