DBA Data[Home] [Help]

APPS.EAM_FORECAST_PVT dependencies on GL_CODE_COMBINATIONS

Line 120: SELECT code_combination_id from gl_code_combinations glcc

116: AND cdv.wip_entity_id = p_wip_entity_id
117: --AND cdv.organization_id = p_organization_id Bug#5632148
118: AND (p_account_from is null or
119: cdv.reference_account in (
120: SELECT code_combination_id from gl_code_combinations glcc
121: where fnd_flex_ext.get_segs('SQLGL', 'GL#',
122: glcc.chart_of_accounts_id, glcc.code_combination_id) >= p_account_from
123: AND fnd_flex_ext.get_segs('SQLGL', 'GL#', glcc.chart_of_accounts_id,
124: glcc.code_combination_id) <= p_account_to))

Line 161: SELECT code_combination_id from gl_code_combinations glcc

157: AND cdv.wip_entity_id = p_wip_entity_id
158: --AND cdv.organization_id = p_organization_id Bug#5632148
159: AND (p_account_from is null or
160: cdv.reference_account in (
161: SELECT code_combination_id from gl_code_combinations glcc
162: where fnd_flex_ext.get_segs('SQLGL', 'GL#',
163: glcc.chart_of_accounts_id, glcc.code_combination_id) >= p_account_from
164: AND fnd_flex_ext.get_segs('SQLGL', 'GL#', glcc.chart_of_accounts_id,
165: glcc.code_combination_id) <= p_account_to));

Line 2749: gl_code_combinations_kfv glcc

2745:
2746: (SELECT DISTINCT wip_entity_id, ccid, forecast_id AS id
2747: FROM eam_forecast_cebba )efc,
2748:
2749: gl_code_combinations_kfv glcc
2750:
2751:
2752: WHERE
2753: efc.id = ef.forecast_id AND