APPS.BOM_IMPORT_PUB dependencies on BOM_STRUCTURE_TYPES_VL

Line 426: FROM bom_structure_types_vl STV1 where

422: AND structure_type_id IS NULL;
423:
424: UPDATE bom_bill_of_mtls_interface
425: SET structure_type_name = (SELECT STV1.structure_type_name
426: FROM bom_structure_types_vl STV1 where
427: STV1.structure_type_id = pg_batch_options.structure_type_id)
428: WHERE batch_id = p_batch_id
429: AND structure_type_name IS NULL
430: AND (process_flag = 1 OR process_flag = 5)

Line 431: AND exists (select STV2.structure_type_name from bom_structure_types_vl STV2

427: STV1.structure_type_id = pg_batch_options.structure_type_id)
428: WHERE batch_id = p_batch_id
429: AND structure_type_name IS NULL
430: AND (process_flag = 1 OR process_flag = 5)
431: AND exists (select STV2.structure_type_name from bom_structure_types_vl STV2
432: WHERE STV2.structure_type_id = pg_batch_options.structure_type_id);
433:
434: END IF;
435: