[Home] [Help]
68: | Modified : 02-APR-2004 Sushant Sawant
69: | Fixed Bug 3545019
70: | User created config for type3 model with match off
71: | changed order qty for option item and recreated config with match on
72: | This scenario errors out as bom_cto_src_orgs_b should be cleared
73: | for all partial reuse or no reuse scenarios. Data for type3 configs
74: | is stored in different formats.
75: | The fix will always clear bom_cto_src_orgs_b for partial reuse and no
76: | reuse scenarios to avoid the current issue.
71: | changed order qty for option item and recreated config with match on
72: | This scenario errors out as bom_cto_src_orgs_b should be cleared
73: | for all partial reuse or no reuse scenarios. Data for type3 configs
74: | is stored in different formats.
75: | The fix will always clear bom_cto_src_orgs_b for partial reuse and no
76: | reuse scenarios to avoid the current issue.
77: |
78: |
79: | Modified : 13-APR-2004 Sushant Sawant
145:
146: cursor c_copy_src_rules IS
147: select bcso.rcv_org_id, bcso.organization_id, bcol.config_creation, bcso.create_src_rules
148: , bcso.model_item_id , bcso.config_item_id
149: from bom_cto_order_lines bcol, bom_cto_src_orgs bcso
150: where bcol.ato_line_id = pTopAtoLineId
151: and bcol.bom_item_type = '1' and nvl( bcol.wip_supply_type , 1 ) <> '6'
152: and bcol.option_specific = 'N'
153: and bcol.line_id = bcso.line_id ; /*Do not copy sourcing assignments for OSS Items*/
156: and bcso.reference_id is null
157: UNION
158: select bcso.rcv_org_id, bcso.organization_id, bcol.config_creation, bcso.create_src_rules
159: , bcso.inventory_item_id, bcso.config_item_id
160: from bom_cto_order_lines bcol, bom_cto_src_orgs bcso, bom_cto_model_orgs bcmo
161: where bcol.ato_line_id = pTopAtoLineId
162: and bcol.bom_item_type = '1' and nvl( bcol.wip_supply_type , 1 ) <> '6'
163: and bcol.option_specific = 'N'
164: and bcol.line_id = bcso.line_id
718:
719:
720: /* Fix for bug 3545019 and partial reuse scenarios */
721:
722: delete from bom_cto_src_orgs_b where top_model_line_id = pTopAtoLineId ;
723:
724: IF PG_DEBUG <> 0 THEN
725: oe_debug_pub.add('Create_And_Link_Item: ' ||
726: ' deleted from bcso_b as reuse is not applicable or doesnt exist '
1499:
1500:
1501: if( v_bcmo_config_orgs = '3' ) then
1502:
1503: select group_reference_id into v_bcso_group_reference_id from bom_cto_src_orgs_b
1504: where line_id = v_model_lines.line_id ;
1505:
1506:
1507:
1521:
1522:
1523:
1524: else
1525: update bom_cto_src_orgs_b
1526: set config_item_id = lXConfigId
1527: where line_id = v_model_lines.line_id ;
1528:
1529:
1658: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol_gt ' || lXConfigId
1659: || ' for ' || v_model_lines.line_id , 1);
1660:
1661:
1662: update bom_cto_src_orgs_b
1663: set config_item_id = lXConfigId
1664: where line_id = v_model_lines.line_id ;
1665:
1666:
1673:
1674:
1675: if( v_model_lines.config_creation = 3 and v_perform_match = 'U' ) then
1676:
1677: select group_reference_id into v_bcso_group_reference_id from bom_cto_src_orgs_b
1678: where line_id = v_model_lines.line_id ;
1679:
1680:
1681:
1842: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol_gt ' || lXConfigId
1843: || ' for ' || v_model_lines.line_id , 1);
1844:
1845:
1846: select group_reference_id into v_bcso_group_reference_id from bom_cto_src_orgs_b
1847: where line_id = v_model_lines.line_id ;
1848:
1849:
1850:
1859: || ' rows ' || SQL%ROWCOUNT, 1);
1860:
1861:
1862: /* Needs to account for BCMO for type 3 */
1863: update bom_cto_src_orgs_b
1864: set config_item_id = lXConfigId
1865: where line_id = v_model_lines.line_id ;
1866:
1867:
1964: || ' for ' || v_model_lines.line_id , 1);
1965:
1966:
1967:
1968: update bom_cto_src_orgs_b
1969: set config_item_id = lXConfigId
1970: where line_id = v_model_lines.line_id ;
1971:
1972: