DBA Data[Home] [Help]

APPS.EGO_ITEM_BULKLOAD_PKG dependencies on BOM_INVENTORY_COMPS_INTERFACE

Line 7300: UPDATE BOM_INVENTORY_COMPS_INTERFACE

7296: AND ( item_number = l_old_item_num_table(bill_id_row_index) OR
7297: source_system_reference = l_ss_ref_table(bill_id_row_index));
7298:
7299: FORALL bom_inv_id_row_index IN 1..l_item_rows_processed
7300: UPDATE BOM_INVENTORY_COMPS_INTERFACE
7301: SET component_item_number = l_item_num_table(bom_inv_id_row_index)
7302: WHERE process_flag = p_rec_status
7303: AND batch_id = l_xset_id
7304: AND ( component_item_number = l_old_item_num_table(bom_inv_id_row_index) OR

Line 7308: UPDATE BOM_INVENTORY_COMPS_INTERFACE

7304: AND ( component_item_number = l_old_item_num_table(bom_inv_id_row_index) OR
7305: comp_source_system_reference = l_ss_ref_table(bom_inv_id_row_index));
7306:
7307: FORALL bom_par_id_row_index IN 1..l_item_rows_processed
7308: UPDATE BOM_INVENTORY_COMPS_INTERFACE
7309: SET assembly_item_number = l_item_num_table(bom_par_id_row_index)
7310: WHERE process_flag = p_rec_status
7311: AND batch_id = l_xset_id
7312: AND ( assembly_item_number = l_old_item_num_table(bom_par_id_row_index) OR