DBA Data[Home] [Help]

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 2716: INSERT INTO BOM_REFERENCE_DESIGNATORS

2712: p_dest_comp_seq_id => l_component_seqeunce_id,
2713: x_Return_Status => l_Return_Status);
2714:
2715: -- Copy Reference designators to new component
2716: INSERT INTO BOM_REFERENCE_DESIGNATORS
2717: ( COMPONENT_REFERENCE_DESIGNATOR
2718: , LAST_UPDATE_DATE
2719: , LAST_UPDATED_BY
2720: , CREATION_DATE

Line 2786: FROM BOM_REFERENCE_DESIGNATORS ref_desg

2782: , ref_desg.attribute14
2783: , ref_desg.attribute15
2784: , ref_desg.Original_System_Reference
2785: , ref_desg.common_component_sequence_id
2786: FROM BOM_REFERENCE_DESIGNATORS ref_desg
2787: WHERE ref_desg.component_sequence_id = p_comp_seq_id;
2788:
2789: -- Copy Substitute components to new component
2790: INSERT INTO BOM_SUBSTITUTE_COMPONENTS