Entries by Oracle ERP Apps Guide

, , ,

How to Get GL Code Combination Description

Script 1:(Works in Both 11i & R12) SELECT gcc.segment1 ||’.’ ||gcc.segment2 ||’.’ ||gcc.segment3 ACCOUNT, A1.DESCRIPTION ||’-‘ ||A2.DESCRIPTION ||’-‘ || A3.DESCRIPTION DECS FROM fnd_flex_values_vl A1, fnd_flex_values_vl A2, fnd_flex_values_vl A3, gl_code_combinations gcc WHERE a1.flex_value       =gcc.segment1 AND a1.FLEX_VALUE_SET_ID IN (SELECT FLEX_VALUE_SET_ID FROM fnd_id_flex_segments WHERE application_id       = 101 AND id_flex_code       […]