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 3080: gl_code_combinations_kfv glcc,mfg_lookups mlWOtype

3076: mtl_serial_numbers msn,
3077: csi_item_instances cii,
3078: mtl_eam_locations loc, mtl_system_items_kfv msi2,
3079: bom_departments bd, hr_organization_units hou,
3080: gl_code_combinations_kfv glcc,mfg_lookups mlWOtype
3081:
3082:
3083: WHERE
3084: efc.id = ef.forecast_id AND