DBA Data[Home] [Help]

APPS.EGO_ITEM_BULKLOAD_PKG dependencies on BOM_REF_DESGS_INTERFACE

Line 7340: UPDATE BOM_REF_DESGS_INTERFACE

7336: AND ( substitute_comp_number = l_old_item_num_table(bom_sub_id_row_index) OR
7337: subcom_source_system_reference = l_ss_ref_table(bom_sub_id_row_index));
7338:
7339: FORALL bom_ref_id_row_index IN 1..l_item_rows_processed
7340: UPDATE BOM_REF_DESGS_INTERFACE
7341: SET assembly_item_number = l_item_num_table(bom_ref_id_row_index)
7342: WHERE process_flag = p_rec_status
7343: AND batch_id = l_xset_id
7344: AND ( assembly_item_number = l_old_item_num_table(bom_ref_id_row_index) OR

Line 7348: UPDATE BOM_REF_DESGS_INTERFACE

7344: AND ( assembly_item_number = l_old_item_num_table(bom_ref_id_row_index) OR
7345: parent_source_system_reference = l_ss_ref_table(bom_ref_id_row_index));
7346:
7347: FORALL bom_ref_id_row_index IN 1..l_item_rows_processed
7348: UPDATE BOM_REF_DESGS_INTERFACE
7349: SET component_item_number = l_item_num_table(bom_ref_id_row_index)
7350: WHERE process_flag = p_rec_status
7351: AND batch_id = l_xset_id
7352: AND ( component_item_number = l_old_item_num_table(bom_ref_id_row_index) OR