[Home] [Help]
2088: WHERE EXISTS ( SELECT 1
2089: FROM fnd_concurrent_programs fcp,
2090: fnd_concurrent_requests fcr,
2091: fem_intg_dim_rules idr,
2092: fem_object_definition_b fodb
2093: WHERE fcp.concurrent_program_id = fcr.concurrent_program_id
2094: AND fcp.application_id = fcr.program_application_id
2095: AND fcp.application_id = 274
2096: AND fcp.concurrent_program_name = 'FEM_INTG_DIM_RULE_ENGINE'
2165: UPDATE FEM_INTG_DIM_RULE_DEFS
2166: SET MAX_CCID_PROCESSED = FEM_INTG_DIM_RULE_ENG_PKG.pv_max_ccid_to_be_mapped
2167: WHERE DIM_RULE_OBJ_DEF_ID IN ( SELECT defs.dim_rule_obj_def_id
2168: FROM fem_intg_dim_rules idr,
2169: fem_object_definition_b fodb,
2170: fem_xdim_dimensions fxd,
2171: fem_intg_dim_rule_defs defs,
2172: fem_tab_columns_b ftcb
2173: WHERE ftcb.table_name = 'FEM_BALANCES'
4011: WHERE EXISTS ( SELECT 1
4012: FROM fnd_concurrent_programs fcp,
4013: fnd_concurrent_requests fcr,
4014: fem_intg_dim_rules idr,
4015: fem_object_definition_b fodb
4016: WHERE fcp.concurrent_program_id = fcr.concurrent_program_id
4017: AND fcp.application_id = fcr.program_application_id
4018: AND fcp.application_id = 274
4019: AND fcp.concurrent_program_name = 'FEM_INTG_DIM_RULE_ENGINE'
4088: UPDATE FEM_INTG_DIM_RULE_DEFS
4089: SET MAX_CCID_PROCESSED = FEM_INTG_DIM_RULE_ENG_PKG.pv_max_ccid_to_be_mapped
4090: WHERE DIM_RULE_OBJ_DEF_ID IN ( SELECT defs.dim_rule_obj_def_id
4091: FROM fem_intg_dim_rules idr,
4092: fem_object_definition_b fodb,
4093: fem_xdim_dimensions fxd,
4094: fem_intg_dim_rule_defs defs,
4095: fem_tab_columns_b ftcb
4096: WHERE ftcb.table_name = 'FEM_BALANCES'
4623: defs.application_column_name1,
4624: defs.default_member_id,
4625: defs.dim_mapping_option_code
4626: FROM fem_intg_dim_rules idr,
4627: fem_object_definition_b fodb,
4628: fem_xdim_dimensions fxd,
4629: fem_intg_dim_rule_defs defs,
4630: fem_tab_columns_b ftcb
4631: WHERE ftcb.table_name = 'FEM_BALANCES'