APPS.CTO_UPDATE_ITEMS_PK dependencies on BOM_CTO_MODEL_ORGS

Line 303: delete from bom_cto_model_orgs

299:
300: --
301: -- delete from bcmo
302: --
303: delete from bom_cto_model_orgs
304: where config_item_id in
305: (select /* INDEX (BOM_CTO_ORDER_LINES_UPG BOM_CTO_ORDER_LINES_UPG_N4 BOM_CTO_ORDER_LINES_UPG_N2 ) */
306: distinct config_item_id
307: from bom_cto_order_lines_upg

Line 894: from bom_cto_model_orgs bcmo,

890: bcmo.model_item_id,
891: bcso.line_id,
892: bcso.top_model_line_id,
893: bcso.config_item_id
894: from bom_cto_model_orgs bcmo,
895: bom_cto_src_orgs_b bcso
896: where bcso.config_item_id = bcmo.config_item_id and
897: bcso.config_item_id in (select /*+ INDEX (BOM_CTO_ORDER_LINES_UPG BOM_CTO_ORDER_LINES_UPG_N4 ) */
898: distinct config_item_id