DBA Data[Home] [Help]

APPS.INVPPROC dependencies on MTL_DESCR_ELEMENT_VALUES

Line 1262: delete from mtl_descr_element_values

1258: END IF;
1259:
1260: -- Bug #1068191 (1031733)
1261: --
1262: delete from mtl_descr_element_values
1263: where inventory_item_id in
1264: ( select inventory_item_id
1265: from mtl_parameters MP,
1266: MTL_SYSTEM_ITEMS_INTERFACE I

Line 1279: table_name := 'MTL_DESCR_ELEMENT_VALUES';

1275: IF l_inv_debug_level IN(101, 102) THEN
1276: INVPUTLI.info('INVPPROC.inproit_process_item: inserting into MDEV with xset_id = '|| xset_id);
1277: END IF;
1278:
1279: table_name := 'MTL_DESCR_ELEMENT_VALUES';
1280:
1281: -- bug 10373720, set last_update date and creation date to sysdate
1282: --- old NVL(I.LAST_UPDATE_DATE, l_sysdate),NVL(I.CREATION_DATE, l_sysdate),
1283: insert into MTL_DESCR_ELEMENT_VALUES

Line 1283: insert into MTL_DESCR_ELEMENT_VALUES

1279: table_name := 'MTL_DESCR_ELEMENT_VALUES';
1280:
1281: -- bug 10373720, set last_update date and creation date to sysdate
1282: --- old NVL(I.LAST_UPDATE_DATE, l_sysdate),NVL(I.CREATION_DATE, l_sysdate),
1283: insert into MTL_DESCR_ELEMENT_VALUES
1284: (inventory_item_id,
1285: element_name,
1286: default_element_flag,
1287: last_update_date,