APPS.BOM_UTIL dependencies on ENG_REVISED_ITEMS

Line 37: FROM ENG_REVISED_ITEMS

33: return 0;
34: end if;
35:
36: SELECT count(distinct change_id) INTO l_change_order_count
37: FROM ENG_REVISED_ITEMS
38: WHERE bill_sequence_id = p_bill_sequence_id;
39:
40: RETURN l_change_order_count;
41: END get_change_order_count;

Line 499: eng_revised_items eri--eng_change_lines ecl

495: IS
496: SELECT eec.change_notice
497: FROM
498: eng_engineering_changes eec,
499: eng_revised_items eri--eng_change_lines ecl
500: WHERE eri.change_id/*cl.change_id*/ = eec.change_id
501: -- AND ecl.change_line_id = c_p_change_line_id;
502: AND eri.revised_item_sequence_id = c_p_change_line_id;
503: l_change_notice eng_engineering_changes.change_notice%type;