DBA Data[Home] [Help]

APPS.BOM_IMPORT_PUB dependencies on EGO_FND_DSC_FLX_CTX_EXT

Line 3087: from ego_fnd_dsc_flx_ctx_ext efd,

3083: select distinct efd.attr_group_id,
3084: efd.descriptive_flex_context_code attr_group_name,
3085: efd.descriptive_flexfield_name attr_group_type,
3086: bcua.structure_type_id
3087: from ego_fnd_dsc_flx_ctx_ext efd,
3088: bom_cmp_usr_attr_interface bcua
3089: where efd.application_id = 702
3090: and efd.descriptive_flexfield_name = 'BOM_COMPONENTMGMT_GROUP'
3091: and efd.descriptive_flex_context_code = bcua.attr_group_int_name

Line 3188: attr_group_id = (select attr_group_id from EGO_FND_DSC_FLX_CTX_EXT where application_id = 702 and DESCRIPTIVE_FLEXFIELD_NAME = 'BOM_COMPONENTMGMT_GROUP' and DESCRIPTIVE_FLEX_CONTEXT_CODE = BCUA.attr_group_int_name),

3184: UPDATE bom_cmp_usr_attr_interface BCUA
3185: SET component_sequence_id = l_comp_seq_id,
3186: bill_sequence_id = l_bill_seq_id,
3187: process_status = 2,
3188: attr_group_id = (select attr_group_id from EGO_FND_DSC_FLX_CTX_EXT where application_id = 702 and DESCRIPTIVE_FLEXFIELD_NAME = 'BOM_COMPONENTMGMT_GROUP' and DESCRIPTIVE_FLEX_CONTEXT_CODE = BCUA.attr_group_int_name),
3189: attr_group_type = 'BOM_COMPONENTMGMT_GROUP'
3190: WHERE (BCUA.data_set_id = p_batch_id or BCUA.batch_id = p_batch_id )
3191: AND BCUA.process_status NOT in (3,4)
3192: AND ( (BCUA.component_sequence_id = l_comp_seq_id)