DBA Data[Home] [Help]

APPS.BOMPVALB dependencies on BOM_REFERENCE_DESIGNATORS

Line 2824: from bom_reference_designators a, bom_ref_desgs_interface b

2820: */
2821: begin
2822: select 1
2823: into dummy
2824: from bom_reference_designators a, bom_ref_desgs_interface b
2825: where b.transaction_id = trans_id
2826: and a.component_sequence_id = b.component_sequence_id
2827: and a.COMPONENT_REFERENCE_DESIGNATOR =
2828: b.COMPONENT_REFERENCE_DESIGNATOR

Line 2936: from bom_reference_designators

2932:
2933: if (qty_flag = 1) then
2934: select count(*)
2935: into ref_qty
2936: from bom_reference_designators
2937: where component_sequencE_id = cmp_seq_id;
2938:
2939: select count(*)
2940: into int_ref_qty