VIEW: APPS.PA_PRODUCT_INSTALLATION_V

Source

View Text - Preformatted

SELECT lookup_code, meaning, description, decode(lookup_code,'PJF','Y','PLM',PA_EGO_WRAPPER_PUB.CHECK_PLM_INSTALLED, decode(attribute1,null,'N',nvl(fnd_profile.value(attribute1),'N'))) from pa_lookups WHERE lookup_type = 'PA_PRODUCT_CODE' and trunc(sysdate) between nvl(start_date_active, trunc(sysdate)) and nvl(end_date_active, trunc(sysdate))

View Text - HTML Formatted

SELECT LOOKUP_CODE
, MEANING
, DESCRIPTION
, DECODE(LOOKUP_CODE
, 'PJF'
, 'Y'
, 'PLM'
, PA_EGO_WRAPPER_PUB.CHECK_PLM_INSTALLED
, DECODE(ATTRIBUTE1
, NULL
, 'N'
, NVL(FND_PROFILE.VALUE(ATTRIBUTE1)
, 'N')))
FROM PA_LOOKUPS
WHERE LOOKUP_TYPE = 'PA_PRODUCT_CODE'
AND TRUNC(SYSDATE) BETWEEN NVL(START_DATE_ACTIVE
, TRUNC(SYSDATE))
AND NVL(END_DATE_ACTIVE
, TRUNC(SYSDATE))