[Home] [Help]
118: sql_stmt_num := 3;
119:
120: SELECT COUNT (*)
121: INTO total_reference_designators
122: FROM bom_reference_designators brd,
123: bom_inventory_components bic
124: WHERE bic.bill_sequence_id = from_bill_seq_id
125: AND NVL (bic.eco_for_production, 2) = 2
126: AND bic.component_sequence_id = brd.component_sequence_id
5564: sql_stmt_num := 46;
5565:
5566: IF specific_copy_flag = 'Y'
5567: THEN
5568: INSERT INTO bom_reference_designators
5569: (component_reference_designator,
5570: last_update_date,
5571: last_updated_by,
5572: creation_date,
5626: brd.attribute12,
5627: brd.attribute13,
5628: brd.attribute14,
5629: brd.attribute15
5630: FROM bom_reference_designators brd,
5631: bom_components_b bic,
5632: bom_copy_explosions_v bev
5633: WHERE bic.bill_sequence_id = to_sequence_id
5634: AND NVL (bic.eco_for_production, 2) = 2
5641: OR (specific_copy_flag = 'Y'
5642: AND copy_all_rfds_flag = 'Y')
5643: )
5644: THEN
5645: INSERT INTO bom_reference_designators
5646: (component_reference_designator,
5647: last_update_date,
5648: last_updated_by,
5649: creation_date,
5703: brd.attribute12,
5704: brd.attribute13,
5705: brd.attribute14,
5706: brd.attribute15
5707: FROM bom_reference_designators brd,
5708: bom_inventory_components bic
5709: WHERE bic.bill_sequence_id = to_sequence_id
5710: AND NVL (bic.eco_for_production, 2) = 2
5711: AND brd.component_sequence_id = bic.created_by
11267: --Turn on trigger BOMTBICX
11268: bom_globals.g_skip_bomtbicx := 'N';
11269: sql_stmt_num := 46;
11270:
11271: INSERT INTO bom_reference_designators
11272: (component_reference_designator,
11273: last_update_date,
11274: last_updated_by,
11275: creation_date,
11329: brd.attribute12,
11330: brd.attribute13,
11331: brd.attribute14,
11332: brd.attribute15
11333: FROM bom_reference_designators brd,
11334: bom_components_b bic,
11335: bom_copy_explosions_v bev
11336: WHERE bic.bill_sequence_id = to_sequence_id
11337: AND NVL (bic.eco_for_production, 2) = 2