Tuesday, December 27, 2016

Query to Get the DFF details & Segment values

Query to find DFF


Let's say, we need to find Descriptive Flexfield (DFF) called, "Further Job Information". In the following example, I am trying to get all the information for "US" context code.

























SELECT ffv.descriptive_flexfield_name DFFName,
  ffv.application_table_name TABLEName,
  ffv.title Title,
  ap.application_name Application,
  ffc.descriptive_flex_context_code ContextCode,
  ffc.descriptive_flex_context_name ContextName,
  ffc.description ContextDESC,
  ffc.enabled_flag ContextEnableFlag,
  att.column_seq_num SegmentNUMBER,
  att.form_left_prompt SegmentName,
  att.application_column_name,
  fvs.flex_value_set_name,
  att.display_flag Displayed,
  att.enabled_flag Enabled,
  att.required_flag Required
FROM apps.fnd_descriptive_flexs_vl ffv,
  apps.fnd_descr_flex_contexts_vl ffc,
  apps.fnd_descr_flex_col_usage_vl att,
  apps.fnd_flex_value_sets fvs,
  apps.fnd_application_vl ap
WHERE ffv.descriptive_flexfield_name = att.descriptive_flexfield_name
AND ap.application_id                =ffv.application_id
AND ffv.descriptive_flexfield_name   = ffc.descriptive_flexfield_name
AND ffv.application_id               = ffc.application_id
AND ffc.descriptive_flex_context_code=att.descriptive_flex_context_code
AND fvs.flex_value_set_id            =att.flex_value_set_id
AND ffv.title LIKE '%Pricing Contexts%'
and ffc.descriptive_flex_context_code='PRICING ATTRIBUTE'
--AND ffc.descriptive_flex_context_code LIKE ‘Give Context Code Value’
ORDER BY att.column_seq_num;

No comments:

Post a Comment

Oracle Fusion - Cost Lines and Expenditure Item link in Projects

SELECT   ccd.transaction_id,ex.expenditure_item_id,cacat.serial_number FROM fusion.CST_INV_TRANSACTIONS cit,   fusion.cst_cost_distribution_...