DBA Data[Home] [Help]

APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on BOM_REFERENCE_DESIGNATORS

Line 785: bom_reference_designators

781: IS
782: SELECT
783: component_reference_designator reference_designator_name
784: FROM
785: bom_reference_designators
786: WHERE
787: component_sequence_id = p_component_sequence_id
788: AND NVL(acd_type,1) = 1; --Only added components are taken
789:

Line 842: bom_reference_designators

838: ,DECODE(p_new_ref_designator ,NULL ,NULL ,p_new_ref_designator.new_routing_revision) new_routing_revision
839: ,DECODE(p_new_ref_designator ,NULL ,NULL ,p_new_ref_designator.return_status) return_status
840: ,DECODE(p_new_ref_designator ,NULL ,NULL ,p_new_ref_designator.row_identifier ) row_identifier
841: FROM
842: bom_reference_designators
843: WHERE
844: component_reference_designator = p_ref_designator_name AND
845: component_sequence_id = p_component_sequence_id;
846:

Line 4311: ,bom_reference_designators brd

4307: ,brd.original_system_reference
4308: FROM
4309: bom_inventory_components bic
4310: ,eng_revised_items eri
4311: ,bom_reference_designators brd
4312: WHERE
4313: eri.change_id = p_change_id AND
4314: eri.revised_item_id = p_revised_item_id AND
4315: bic.component_item_id = p_component_id AND