View: PA_PRODUCT_INSTALLATION_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_PRODUCT_INSTALLATION_V

View Text

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))

Columns