APPS.CTO_CONFIG_ITEM_PK dependencies on MTL_DESCR_ELEMENT_VALUES

Line 7296: insert into MTL_DESCR_ELEMENT_VALUES

7292: +---------------------------------------------------------*/
7293:
7294: lStmtNumber := 250;
7295:
7296: insert into MTL_DESCR_ELEMENT_VALUES
7297: (inventory_item_id,
7298: element_name,
7299: last_update_date,
7300: last_updated_by,

Line 7328: mtl_descr_element_values D,

7324: NULL, -- program_id
7325: SYSDATE, -- program_update_date
7326: NULL -- request_id
7327: from mtl_system_items s,
7328: mtl_descr_element_values D,
7329: mtl_descriptive_elements E
7330: where D.inventory_item_id = S.inventory_item_id
7331: and s.inventory_item_id = pModelid
7332: and s.organization_id = lValidationOrg

Line 7337: from mtl_descr_element_values

7333: and E.item_catalog_group_id = S.item_catalog_group_id
7334: and E.element_name = D.element_name
7335: and NOT EXISTS
7336: (select NULL
7337: from mtl_descr_element_values
7338: where inventory_item_id = pConfigId
7339: and organization_id = lValidationOrg);
7340:
7341: IF PG_DEBUG <> 0 THEN

Line 7342: oe_debug_pub.add('Create_Item: ' || 'after insert: MTL_DESCR_ELEMENT_VALUES',2);

7338: where inventory_item_id = pConfigId
7339: and organization_id = lValidationOrg);
7340:
7341: IF PG_DEBUG <> 0 THEN
7342: oe_debug_pub.add('Create_Item: ' || 'after insert: MTL_DESCR_ELEMENT_VALUES',2);
7343: END IF;
7344:
7345:
7346: /*--------------------------------------+