DBA Data[Home] [Help]

APPS.EGO_ITEM_BULKLOAD_PKG dependencies on BOM_INVENTORY_COMPS_INTERFACE

Line 7147: UPDATE BOM_INVENTORY_COMPS_INTERFACE

7143: AND ( item_number = l_old_item_num_table(bill_id_row_index) OR
7144: source_system_reference = l_ss_ref_table(bill_id_row_index));
7145:
7146: FORALL bom_inv_id_row_index IN 1..l_item_rows_processed
7147: UPDATE BOM_INVENTORY_COMPS_INTERFACE
7148: SET component_item_number = l_item_num_table(bom_inv_id_row_index)
7149: WHERE process_flag = p_rec_status
7150: AND batch_id = l_xset_id
7151: AND ( component_item_number = l_old_item_num_table(bom_inv_id_row_index) OR

Line 7155: UPDATE BOM_INVENTORY_COMPS_INTERFACE

7151: AND ( component_item_number = l_old_item_num_table(bom_inv_id_row_index) OR
7152: comp_source_system_reference = l_ss_ref_table(bom_inv_id_row_index));
7153:
7154: FORALL bom_par_id_row_index IN 1..l_item_rows_processed
7155: UPDATE BOM_INVENTORY_COMPS_INTERFACE
7156: SET assembly_item_number = l_item_num_table(bom_par_id_row_index)
7157: WHERE process_flag = p_rec_status
7158: AND batch_id = l_xset_id
7159: AND ( assembly_item_number = l_old_item_num_table(bom_par_id_row_index) OR