APPS.BOM_IMPORT_PUB dependencies on BOM_REFERENCE_DESIGNATORS

Line 164: FROM bom_reference_designators

160:
161: CURSOR Get_PIMDH_RefDs
162: IS
163: SELECT *
164: FROM bom_reference_designators
165: WHERE component_sequence_id = p_comp_seq_id
166: ORDER BY component_reference_designator;
167:
168: TYPE ref_intf_type IS TABLE OF bom_ref_desgs_interface%ROWTYPE;

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

165: WHERE component_sequence_id = p_comp_seq_id
166: ORDER BY component_reference_designator;
167:
168: TYPE ref_intf_type IS TABLE OF bom_ref_desgs_interface%ROWTYPE;
169: TYPE ref_pimdh_type IS TABLE OF bom_reference_designators%ROWTYPE;
170:
171: l_src_refds ref_intf_type;
172: l_pimdh_refds ref_pimdh_type;
173: l_src_count NUMBER;

Line 3012: FROM bom_reference_designators

3008:
3009: CURSOR c_pdh_ref_desg (p_comp_seq_id IN NUMBER)
3010: IS
3011: SELECT component_reference_designator
3012: FROM bom_reference_designators
3013: WHERE component_sequence_id = p_comp_seq_id
3014: ORDER BY 1 DESC;
3015:
3016: l_ref_desg VARCHAR2(32000);