VIEW: APPS.FND_PROFILE_VALUES_SERVER_V

Source

View Text - Preformatted

SELECT application_id, profile_option_id, level_value, profile_option_value
FROM fnd_profile_option_values fpov
WHERE level_id = 10005
AND EXISTS
   (SELECT 1
    FROM fnd_profile_options po
    WHERE po.profile_option_id = fpov.profile_option_id
    AND po.application_id = fpov.application_id
    AND po.start_date_active <= ( TRUNC(SYSDATE + 1) - .000011574 )
    AND (po.end_date_active is NULL OR
         po.end_date_active > ( TRUNC(SYSDATE) - .000011574 ))
    )
order by profile_option_id, application_id

View Text - HTML Formatted

SELECT APPLICATION_ID
, PROFILE_OPTION_ID
, LEVEL_VALUE
, PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES FPOV WHERE LEVEL_ID = 10005 AND EXISTS (SELECT 1
FROM FND_PROFILE_OPTIONS PO
WHERE PO.PROFILE_OPTION_ID = FPOV.PROFILE_OPTION_ID
AND PO.APPLICATION_ID = FPOV.APPLICATION_ID
AND PO.START_DATE_ACTIVE <= ( TRUNC(SYSDATE + 1) - .000011574 )
AND (PO.END_DATE_ACTIVE IS NULL OR PO.END_DATE_ACTIVE > ( TRUNC(SYSDATE) - .000011574 )) ) ORDER BY PROFILE_OPTION_ID
, APPLICATION_ID