APPS.CTO_ITEM_PK dependencies on BOM_CTO_MODEL_ORGS

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 1565: update bom_cto_model_orgs

1561: where line_id = v_model_lines.line_id ;
1562:
1563:
1564:
1565: update bom_cto_model_orgs
1566: set config_item_id = lXConfigId
1567: where group_reference_id = v_bcso_group_reference_id ;
1568:
1569:

Line 1742: update bom_cto_model_orgs

1738: where line_id = v_model_lines.line_id ;
1739:
1740:
1741:
1742: update bom_cto_model_orgs
1743: set config_item_id = lXConfigId
1744: where group_reference_id = v_bcso_group_reference_id ;
1745:
1746:

Line 1798: ( select organization_id from bom_cto_model_orgs bcmo

1794: begin
1795: select 1 /* BCMO not in synch with Model Item */ into v_model_item_status from dual
1796: where exists ( select organization_id from mtl_system_items msi
1797: where not exists
1798: ( select organization_id from bom_cto_model_orgs bcmo
1799: where bcmo.config_item_id = lXConfigId
1800: and bcmo.organization_id = msi.organization_id )
1801: and msi.inventory_item_id = v_model_lines.inventory_item_id ) ;
1802:

Line 1911: update bom_cto_model_orgs

1907: where line_id = v_model_lines.line_id ;
1908:
1909:
1910:
1911: update bom_cto_model_orgs
1912: set config_item_id = lXConfigId
1913: where group_reference_id = v_bcso_group_reference_id ;
1914:
1915: