Oracle E-Business Suite AOL Objects Queries

AOL Messages : Used for Warning, Information, Error Purposes in : PLSQL, Forms, OAF and Reports

SELECT fa.application_short_name ,
fat.application_name,
fm.message_name,
fm.message_text
FROM fnd_new_messages fm,
fnd_application_tl fat,
fnd_application fa
WHERE 1 =1
AND fa.application_id = fat.application_id
AND fm.application_id = fa.application_id ;

Lookup Values – Used in Reports, Workflow, Forms, OAF Pages etc

SELECT flv.lookup_type,
flv.lookup_code,
flv.meaning,
flv.enabled_flag
FROM fnd_lookup_values flv
WHERE 1 =1
AND flv.enabled_flag='Y'
AND TRUNC(sysdate) BETWEEN TRUNC(NVL(start_date_active,sysdate)) AND TRUNC(NVL(end_date_active,sysdate) )
ORDER BY flv.lookup_type ;

ValueSet – Reports, Forms, Workflow, OAF Pages etc

SELECT ffvs.flex_value_set_id,
  ffvs.flex_value_set_name,
  ffvs.validation_type ,
  ffv.flex_value,
  ffv.enabled_flag,
  ffv.start_date_active,
  ffv.end_date_active ,
  ffvt.description
FROM FND_FLEX_VALUE_SETS ffvs ,
  FND_FLEX_VALUES ffv ,
  FND_FLEX_VALUES_TL ffvt
WHERE 1                      =1
AND ffvs.flex_value_set_id   = ffv.flex_value_set_id
AND ffv.flex_value_id        = ffvt.flex_value_id

Leave a Reply

Your email address will not be published.