135: l_org_id NUMBER;
136: l_child_org_id NUMBER;
137: l_config_orgs VARCHAR2(30);
138: l_child_config_orgs VARCHAR2(30);
139: l_plan_level bom_explosion_temp.plan_level%TYPE;
140:
141:
142: TYPE ConfigCurTyp is REF CURSOR ;
143:
154:
155:
156: -- rkaza. 04/28/2005.
157: -- adding organization_id join between bet and msi for perf improvement
158: cursor child_config_cur(xgrp_id bom_explosion_temp.group_id%TYPE ) is
159: select distinct bet.component_item_id,msi_b.config_orgs,bet.plan_level
160: from bom_explosion_temp bet
161: , mtl_system_items msi
162: , mtl_system_items msi_b
156: -- rkaza. 04/28/2005.
157: -- adding organization_id join between bet and msi for perf improvement
158: cursor child_config_cur(xgrp_id bom_explosion_temp.group_id%TYPE ) is
159: select distinct bet.component_item_id,msi_b.config_orgs,bet.plan_level
160: from bom_explosion_temp bet
161: , mtl_system_items msi
162: , mtl_system_items msi_b
163: where bet.group_id = xgrp_id
164: and bet.component_item_id = msi.inventory_item_id