[Home] [Help]
15:
16: SELECT bbom.alternate_bom_designator
17: INTO x_alternate_designator
18: FROM bom_bill_of_materials bbom,
19: bom_inventory_components bic,
20: wsm_co_products bcp
21: WHERE bcp.co_product_group_id = x_co_product_group_id
22: AND bcp.component_sequence_id = bic.component_sequence_id
23: AND bic.bill_sequence_id = bbom.bill_sequence_id
81: BEGIN
82:
83: x_progress := '010';
84:
85: SELECT bom_inventory_components_s.nextval
86: INTO x_result
87: FROM sys.dual;
88:
89: x_error_code := 0;
116: -- June 22nd, 2000.
117: /*
118: select component_sequence_id
119: into l_id
120: from bom_inventory_components
121: where bill_sequence_id = p_bill_sequence_id
122: and component_item_id = p_component_item_id
123: and operation_seq_num = p_operation_sequence_num
124: and effectivity_date = p_effectivity_date;
132: ** only will have the Inventory components.- Bala, June 22nd, 2000.
133: */
134: select bic.component_sequence_id
135: into l_id
136: from bom_inventory_components bic,
137: bom_bill_of_materials bom
138: where bom.bill_sequence_id = p_bill_sequence_id
139: and bic.bill_sequence_id = bom.common_bill_sequence_id
140: and bic.component_item_id = p_component_item_id