SELECT application_id, profile_option_id, level_value, profile_option_value
FROM fnd_profile_option_values fpov
WHERE level_id = 10004
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
SELECT APPLICATION_ID
, PROFILE_OPTION_ID
, LEVEL_VALUE
, PROFILE_OPTION_VALUE
FROM FND_PROFILE_OPTION_VALUES FPOV
WHERE LEVEL_ID = 10004
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
|
|
|