SELECT DISTINCT fdcb.context_code
, fdcb.context_identifier
, fdcb.enabled_flag
, fdsb.segment_code
, fdsb.segment_identifier
, fdsb.column_name
FROM fusion.fnd_df_contexts_tl fdct
, fusion.fnd_df_contexts_b fdcb
, fusion.fnd_df_segments_tl fdst
, fusion.fnd_df_segments_b fdsb
WHERE fdct.context_code = fdcb.context_code
AND fdcb.context_code = fdsb.context_code
AND fdst.context_code = fdsb.context_code
AND fdst.segment_code = fdsb.segment_code
AND fdct.application_id = fdcb.application_id
AND fdct.language = userenv('Lang')
AND fdst.language = userenv('Lang')
AND fdct.descriptive_flexfield_code = 'DOO_FULFILL_LINES_ADD_INFO'
AND fdcb.context_code = '<Context_Code>'
ORDER BY fdcb.context_identifier
, fdsb.segment_identifier
Tuesday, July 20, 2021
FA:OM:SQL To List EFF Segments and attribute Columns mapping for Specific Context
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.