DBA Data[Home] [Help]

APPS.CTO_UPDATE_ITEMS_PK dependencies on MTL_DESCR_ELEMENT_VALUES

Line 2027: insert into MTL_DESCR_ELEMENT_VALUES

2023: +---------------------------------------------------------*/
2024:
2025: lStmtNumber := 100;
2026:
2027: insert into MTL_DESCR_ELEMENT_VALUES
2028: (inventory_item_id,
2029: element_name,
2030: last_update_date,
2031: last_updated_by,

Line 2060: mtl_descr_element_values D,

2056: NULL, -- program_id
2057: SYSDATE, -- program_update_date
2058: NULL -- request_id
2059: from mtl_system_items s,
2060: mtl_descr_element_values D,
2061: mtl_descriptive_elements E,
2062: bom_cto_order_lines_upg bcolu
2063: where bcolu.config_item_id is not null
2064: and bcolu.status = 'BCSO'

Line 2072: from mtl_descr_element_values

2068: and E.item_catalog_group_id = S.item_catalog_group_id
2069: and E.element_name = D.element_name
2070: and NOT EXISTS
2071: (select NULL
2072: from mtl_descr_element_values
2073: where inventory_item_id = bcolu.config_item_id
2074: and organization_id = bcolu.ship_from_org_id);
2075:
2076: WriteToLog('Inserted rows into mtl_descr_element_values:: '||sql%rowcount,2);

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

2072: from mtl_descr_element_values
2073: where inventory_item_id = bcolu.config_item_id
2074: and organization_id = bcolu.ship_from_org_id);
2075:
2076: WriteToLog('Inserted rows into mtl_descr_element_values:: '||sql%rowcount,2);
2077:
2078:
2079: /*--------------------------------------+
2080: Insert into mtl_item_categories