APPS.BOM_GLOBALS dependencies on BOM_REFERENCE_DESIGNATORS

Line 1608: FROM bom_reference_designators rd

1604: IS
1605: cursor c_ref_desg ( p_component_seq IN NUMBER)
1606: IS
1607: SELECT component_reference_designator
1608: FROM bom_reference_designators rd
1609: , bom_components_b comp
1610: WHERE comp.component_sequence_id = p_component_seq
1611: AND rd.component_sequence_id = comp.component_sequence_id
1612: AND ( (comp.implementation_date IS NULL AND

Line 2759: INSERT INTO BOM_REFERENCE_DESIGNATORS

2755: BOM_UDA_OVERRIDES_PVT.Copy_Comp_UDA_Overrides(p_comp_seq_id, l_component_seqeunce_id);
2756: --EMTAPIA: End added to support component UDA override values
2757:
2758: -- Copy Reference designators to new component
2759: INSERT INTO BOM_REFERENCE_DESIGNATORS
2760: ( COMPONENT_REFERENCE_DESIGNATOR
2761: , LAST_UPDATE_DATE
2762: , LAST_UPDATED_BY
2763: , CREATION_DATE

Line 2829: FROM BOM_REFERENCE_DESIGNATORS ref_desg

2825: , ref_desg.attribute14
2826: , ref_desg.attribute15
2827: , ref_desg.Original_System_Reference
2828: , ref_desg.common_component_sequence_id
2829: FROM BOM_REFERENCE_DESIGNATORS ref_desg
2830: WHERE ref_desg.component_sequence_id = p_comp_seq_id;
2831:
2832: -- Copy Substitute components to new component
2833: INSERT INTO BOM_SUBSTITUTE_COMPONENTS