APPS.BOM_OPEN_INTERFACE_UTL dependencies on BOM_STRUCTURE_TYPES_VL

Line 344: FROM BOM_STRUCTURE_TYPES_VL bstv

340: stmt_num := 9.8;
341: /* Update structure type name to the internal name from the display name */
342: UPDATE BOM_BILL_OF_MTLS_INTERFACE BBMI
343: SET structure_type_name = (SELECT structure_type_name
344: FROM BOM_STRUCTURE_TYPES_VL bstv
345: WHERE decode(BBMI.structure_type_name, null, to_char(bstv.structure_type_id), bstv.display_name)
346: = decode(BBMI.structure_type_name, null, to_char(BBMI.structure_type_id), BBMI.structure_type_name))
347: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
348: AND (structure_type_name is not null OR structure_type_id is not null)

Line 356: FROM BOM_STRUCTURE_TYPES_VL bstv

352: ( (p_batch_id IS NULL) AND (BBMI.batch_id IS NULL) )
353: OR ( p_batch_id = BBMI.batch_id )
354: )
355: AND exists (SELECT null
356: FROM BOM_STRUCTURE_TYPES_VL bstv
357: WHERE decode(BBMI.structure_type_name, null, to_char(bstv.structure_type_id), bstv.display_name) =
358: decode(BBMI.structure_type_name, null, to_char(BBMI.structure_type_id), BBMI.structure_type_name));
359:
360: stmt_num := 10;