Query:
SELECT *
FROM fnd_lookup_values_vl flv
WHERE lookup_type = 'POS_BUSINESS_CLASSIFICATIONS'
AND flv.enabled_flag='Y'
--AND lookup_code = '8010'
AND flv.start_date_active < sysdate
AND (flv.end_date_active > sysdate or flv.end_date_active is null)
Application Developer->Application->Lookups->Application Object Library
Query Type with POS_BUSINESS_CLASSIFICATIONS
No comments:
Post a Comment