APPS.CTO_CONFIG_ITEM_PK dependencies on MTL_DESCR_ELEMENT_VALUES

Line 7481: insert into MTL_DESCR_ELEMENT_VALUES

7477: +---------------------------------------------------------*/
7478:
7479: lStmtNumber := 250;
7480:
7481: insert into MTL_DESCR_ELEMENT_VALUES
7482: (inventory_item_id,
7483: element_name,
7484: last_update_date,
7485: last_updated_by,

Line 7513: mtl_descr_element_values D,

7509: NULL, -- program_id
7510: SYSDATE, -- program_update_date
7511: NULL -- request_id
7512: from mtl_system_items s,
7513: mtl_descr_element_values D,
7514: mtl_descriptive_elements E
7515: where D.inventory_item_id = S.inventory_item_id
7516: and s.inventory_item_id = pModelid
7517: and s.organization_id = lValidationOrg

Line 7522: from mtl_descr_element_values

7518: and E.item_catalog_group_id = S.item_catalog_group_id
7519: and E.element_name = D.element_name
7520: and NOT EXISTS
7521: (select NULL
7522: from mtl_descr_element_values
7523: where inventory_item_id = pConfigId
7524: and organization_id = lValidationOrg);
7525:
7526: IF PG_DEBUG <> 0 THEN

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

7523: where inventory_item_id = pConfigId
7524: and organization_id = lValidationOrg);
7525:
7526: IF PG_DEBUG <> 0 THEN
7527: oe_debug_pub.add('Create_Item: ' || 'after insert: MTL_DESCR_ELEMENT_VALUES',2);
7528: END IF;
7529:
7530:
7531: /*--------------------------------------+