APPS.BOM_IMPORT_PUB dependencies on BOM_REFERENCE_DESIGNATORS

Line 157: FROM bom_reference_designators

153:
154: CURSOR Get_PIMDH_RefDs
155: IS
156: SELECT *
157: FROM bom_reference_designators
158: WHERE component_sequence_id = p_comp_seq_id
159: ORDER BY component_reference_designator;
160:
161: TYPE ref_intf_type IS TABLE OF bom_ref_desgs_interface%ROWTYPE;

Line 162: TYPE ref_pimdh_type IS TABLE OF bom_reference_designators%ROWTYPE;

158: WHERE component_sequence_id = p_comp_seq_id
159: ORDER BY component_reference_designator;
160:
161: TYPE ref_intf_type IS TABLE OF bom_ref_desgs_interface%ROWTYPE;
162: TYPE ref_pimdh_type IS TABLE OF bom_reference_designators%ROWTYPE;
163:
164: l_src_refds ref_intf_type;
165: l_pimdh_refds ref_pimdh_type;
166: l_src_count NUMBER;

Line 2859: FROM bom_reference_designators

2855:
2856: CURSOR c_pdh_ref_desg (p_comp_seq_id IN NUMBER)
2857: IS
2858: SELECT component_reference_designator
2859: FROM bom_reference_designators
2860: WHERE component_sequence_id = p_comp_seq_id
2861: ORDER BY 1 DESC;
2862:
2863: l_ref_desg VARCHAR2(32000);