VIEW: APPS.PO_PRICE_DIFF_LOOKUPS_V

Source

View Text - Preformatted

SELECT LV.LOOKUP_CODE, LV.MEANING, LV.DESCRIPTION FROM FND_LOOKUP_TYPES_VL LT, FND_LOOKUP_VALUES_VL LV WHERE LT.LOOKUP_TYPE = LV.LOOKUP_TYPE AND LV.SECURITY_GROUP_ID = LT.SECURITY_GROUP_ID AND LT.LOOKUP_TYPE = 'PRICE DIFFERENTIALS' AND LT.APPLICATION_ID = 201 AND LT.VIEW_APPLICATION_ID = 0 AND LT.VIEW_APPLICATION_ID = LV.VIEW_APPLICATION_ID AND NVL(LV.ENABLED_FLAG,'Y') = 'Y' AND SYSDATE BETWEEN NVL(LV.START_DATE_ACTIVE, SYSDATE - 1) AND NVL(LV.END_DATE_ACTIVE, SYSDATE + 1) AND LV.LOOKUP_CODE NOT IN ('STANDARD', 'FIXED PRICE') AND LV.SECURITY_GROUP_ID = fnd_global.lookup_security_group(LV.LOOKUP_TYPE, LV.VIEW_APPLICATION_ID)

View Text - HTML Formatted

SELECT LV.LOOKUP_CODE
, LV.MEANING
, LV.DESCRIPTION
FROM FND_LOOKUP_TYPES_VL LT
, FND_LOOKUP_VALUES_VL LV
WHERE LT.LOOKUP_TYPE = LV.LOOKUP_TYPE
AND LV.SECURITY_GROUP_ID = LT.SECURITY_GROUP_ID
AND LT.LOOKUP_TYPE = 'PRICE DIFFERENTIALS'
AND LT.APPLICATION_ID = 201
AND LT.VIEW_APPLICATION_ID = 0
AND LT.VIEW_APPLICATION_ID = LV.VIEW_APPLICATION_ID
AND NVL(LV.ENABLED_FLAG
, 'Y') = 'Y'
AND SYSDATE BETWEEN NVL(LV.START_DATE_ACTIVE
, SYSDATE - 1)
AND NVL(LV.END_DATE_ACTIVE
, SYSDATE + 1)
AND LV.LOOKUP_CODE NOT IN ('STANDARD'
, 'FIXED PRICE')
AND LV.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(LV.LOOKUP_TYPE
, LV.VIEW_APPLICATION_ID)