eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_ITEM_PK dependencies on BOM_CTO_SRC_ORGS

Line 72: | This scenario errors out as bom_cto_src_orgs_b should be cleared

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.

Line 75: | The fix will always clear bom_cto_src_orgs_b for partial reuse and no

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

Line 149: from bom_cto_order_lines bcol, bom_cto_src_orgs bcso

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: -- Bugfix 14270815: Sourcing rules should get created for CIB = 1,2 configs

Line 175: from bom_cto_order_lines bcol, bom_cto_src_orgs bcso, bom_cto_model_orgs bcmo

171: and bcso.reference_id is null
172: UNION
173: select bcso.rcv_org_id, bcso.organization_id, bcol.config_creation, bcso.create_src_rules
174: , bcso.inventory_item_id, bcso.config_item_id
175: from bom_cto_order_lines bcol, bom_cto_src_orgs bcso, bom_cto_model_orgs bcmo
176: where bcol.ato_line_id = pTopAtoLineId
177: and bcol.bom_item_type = '1' and nvl( bcol.wip_supply_type , 1 ) <> '6'
178: and bcol.option_specific = 'N'
179: and bcol.line_id = bcso.line_id

Line 714: from bom_cto_src_orgs

710: */
711:
712: begin
713: select 'Y' into v_bcso_data_exists
714: from bom_cto_src_orgs
715: where top_model_line_id = pTopAtoLineId
716: and rownum = 1; -- Bug Fix 5532777
717: exception
718: when no_data_found then

Line 776: delete from bom_cto_src_orgs_b where top_model_line_id = pTopAtoLineId ;

772:
773:
774: /* Fix for bug 3545019 and partial reuse scenarios */
775:
776: delete from bom_cto_src_orgs_b where top_model_line_id = pTopAtoLineId ;
777:
778: IF PG_DEBUG <> 0 THEN
779: oe_debug_pub.add('Create_And_Link_Item: ' ||
780: ' deleted from bcso_b as reuse is not applicable or doesnt exist '

Line 914: -- Step 5) populate bom_cto_src_orgs

910:
911:
912:
913: --
914: -- Step 5) populate bom_cto_src_orgs
915: --
916:
917: lStmtNum := 80 ;
918:

Line 1560: select group_reference_id into v_bcso_group_reference_id from bom_cto_src_orgs_b

1556:
1557:
1558: if( v_bcmo_config_orgs = '3' ) then
1559:
1560: select group_reference_id into v_bcso_group_reference_id from bom_cto_src_orgs_b
1561: where line_id = v_model_lines.line_id ;
1562:
1563:
1564:

Line 1582: update bom_cto_src_orgs_b

1578:
1579:
1580:
1581: else
1582: update bom_cto_src_orgs_b
1583: set config_item_id = lXConfigId
1584: where line_id = v_model_lines.line_id ;
1585:
1586:

Line 1721: update bom_cto_src_orgs_b

1717:
1718: IF( NVL(v_model_lines.config_creation, 1) IN (1,2) OR
1719: (v_model_lines.config_creation = 3 AND v_perform_match = 'N')) THEN --Bugfix 7640680
1720:
1721: update bom_cto_src_orgs_b
1722: set config_item_id = lXConfigId
1723: where line_id = v_model_lines.line_id ;
1724:
1725: END IF;

Line 1737: select group_reference_id into v_bcso_group_reference_id from bom_cto_src_orgs_b

1733: --Bugfix 7640680: For perform_match in Y,U,C, the relevant data is in bcmo and not bcso.
1734: --if( v_model_lines.config_creation = 3 and v_perform_match = 'U' ) then
1735: if( nvl(v_model_lines.config_creation, 1) = 3 and v_perform_match in ('Y', 'U', 'C')) then
1736:
1737: select group_reference_id into v_bcso_group_reference_id from bom_cto_src_orgs_b
1738: where line_id = v_model_lines.line_id ;
1739:
1740:
1741:

Line 1906: select group_reference_id into v_bcso_group_reference_id from bom_cto_src_orgs_b

1902: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol_gt ' || lXConfigId
1903: || ' for ' || v_model_lines.line_id , 1);
1904:
1905:
1906: select group_reference_id into v_bcso_group_reference_id from bom_cto_src_orgs_b
1907: where line_id = v_model_lines.line_id ;
1908:
1909:
1910:

Line 1923: update bom_cto_src_orgs_b

1919: || ' rows ' || SQL%ROWCOUNT, 1);
1920:
1921:
1922: /* Needs to account for BCMO for type 3 */
1923: update bom_cto_src_orgs_b
1924: set config_item_id = lXConfigId
1925: where line_id = v_model_lines.line_id ;
1926:
1927:

Line 2028: update bom_cto_src_orgs_b

2024: || ' for ' || v_model_lines.line_id , 1);
2025:
2026:
2027:
2028: update bom_cto_src_orgs_b
2029: set config_item_id = lXConfigId
2030: where line_id = v_model_lines.line_id ;
2031:
2032: