DBA Data[Home] [Help]

APPS.INVNIRIS dependencies on MTL_SYSTEM_ITEMS_INTERFACE_S

Line 722: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

718:
719: BEGIN
720:
721: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
722: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
723: WHERE transaction_id IS NULL
724: AND set_process_id = xset_id;
725:
726: --Assign Item Id and apply template.

Line 1364: ,mtl_system_items_interface_s.nextval

1360: ,cur.inventory_item_id
1361: ,1
1362: ,cur.set_process_id
1363: ,'UPDATE'
1364: ,mtl_system_items_interface_s.nextval
1365: ,cur.inventory_item_status_code --Bug 5383744
1366: ,cur.allowed_units_lookup_code
1367: ,cur.item_type
1368: ,NVL(cur.description,l_msb_rec.description));

Line 1738: ,mtl_system_items_interface_s.nextval

1734: ,cur.inventory_item_id
1735: ,1
1736: ,cur.set_process_id
1737: ,'UPDATE'
1738: ,mtl_system_items_interface_s.nextval
1739: ,cur.inventory_item_status_code --Bug 5383744
1740: ,cur.allowed_units_lookup_code
1741: ,cur.item_type
1742: ,NVL(cur.description,l_msb_rec.description));