DBA Data[Home] [Help]

APPS.OKL_REPORT_GENERATOR_PVT dependencies on GL_LEDGERS_PUBLIC_V

Line 159: gl_ledgers_public_v glp --,

155: IS
156: SELECT s.application_column_name segment_col_name
157: FROM fnd_id_flex_segments s,
158: fnd_segment_attribute_values sav,
159: gl_ledgers_public_v glp --,
160: WHERE s.application_id = 101 -- GL Application ID
161: AND s.id_flex_code = 'GL#'
162: AND s.id_flex_num = glp.chart_of_accounts_id --COA ID
163: AND s.enabled_flag = 'Y'

Line 223: ||' ,gl_ledgers_public_v gl'

219: ||')'
220: ||' SELECT cc.code_combination_id'
221: ||' ,' || l_segment || ' ' -- segment3
222: ||' FROM gl_code_combinations cc'
223: ||' ,gl_ledgers_public_v gl'
224: ||' WHERE cc.chart_of_accounts_id = gl.chart_of_accounts_id'
225: ||' AND cc.enabled_flag = ' || '''' || 'Y' || ''''
226: ||' AND gl.ledger_id = ' || p_ledger_id
227: ||' AND EXISTS'