APPS.CTO_UPDATE_ITEMS_PK dependencies on MTL_DESCR_ELEMENT_VALUES

Line 2170: insert into MTL_DESCR_ELEMENT_VALUES

2166: +---------------------------------------------------------*/
2167:
2168: lStmtNumber := 100;
2169:
2170: insert into MTL_DESCR_ELEMENT_VALUES
2171: (inventory_item_id,
2172: element_name,
2173: last_update_date,
2174: last_updated_by,

Line 2203: mtl_descr_element_values D,

2199: NULL, -- program_id
2200: SYSDATE, -- program_update_date
2201: NULL -- request_id
2202: from mtl_system_items s,
2203: mtl_descr_element_values D,
2204: mtl_descriptive_elements E,
2205: bom_cto_order_lines_upg bcolu
2206: where bcolu.config_item_id is not null
2207: and bcolu.status = 'BCSO'

Line 2215: from mtl_descr_element_values

2211: and E.item_catalog_group_id = S.item_catalog_group_id
2212: and E.element_name = D.element_name
2213: and NOT EXISTS
2214: (select NULL
2215: from mtl_descr_element_values
2216: where inventory_item_id = bcolu.config_item_id
2217: and organization_id = bcolu.ship_from_org_id);
2218:
2219: WriteToLog('Inserted rows into mtl_descr_element_values:: '||sql%rowcount,2);

Line 2219: WriteToLog('Inserted rows into mtl_descr_element_values:: '||sql%rowcount,2);

2215: from mtl_descr_element_values
2216: where inventory_item_id = bcolu.config_item_id
2217: and organization_id = bcolu.ship_from_org_id);
2218:
2219: WriteToLog('Inserted rows into mtl_descr_element_values:: '||sql%rowcount,2);
2220:
2221:
2222: /*--------------------------------------+
2223: Insert into mtl_item_categories