APPS.BOM_IMPORT_PUB dependencies on BOM_STRUCTURE_TYPES_VL

Line 433: FROM bom_structure_types_vl STV1 where

429: AND structure_type_id IS NULL;
430:
431: UPDATE bom_bill_of_mtls_interface
432: SET structure_type_name = (SELECT STV1.structure_type_name
433: FROM bom_structure_types_vl STV1 where
434: STV1.structure_type_id = pg_batch_options.structure_type_id)
435: WHERE batch_id = p_batch_id
436: AND structure_type_name IS NULL
437: AND (process_flag = 1 OR process_flag = 5)

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

434: STV1.structure_type_id = pg_batch_options.structure_type_id)
435: WHERE batch_id = p_batch_id
436: AND structure_type_name IS NULL
437: AND (process_flag = 1 OR process_flag = 5)
438: AND exists (select STV2.structure_type_name from bom_structure_types_vl STV2
439: WHERE STV2.structure_type_id = pg_batch_options.structure_type_id);
440:
441: END IF;
442: